| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Senior Data AnalystEMAIL AVAILABLEPHONE NUMBER AVAILABLESomerset, NJSUMMARYI am an experienced data analyst of marketing, sales, inventory and financial data, and adept at producing Key Performance Indicators, building relational databases, programming, query development and supporting clients with technical analyses.My goal is to work in a team on technical projects supporting clients to build and automate standard and ad-hoc reports, and analytical tools to help manage business growth.EXPERIENCEData Analytics and Statistical Analysis Certification courses 2024Shaw Academy online Upskillist coursesData Analysis and processing using R; and, Statistical Modeling using SASData Scientist/Engineer Certificate 2023Kaizen Technologies Edison, NJData Sciences certification program, for Python, Spark and AWSMetrix Learning online Certificates 2022Excel, Python, Power BI, TableauSenior Business/Data Analyst 07/2012 - 09/2022T-MOBILE Lifeline Service, supporting Marketing, Finance and IT Warren, NJ- SAS, Excel, Access, SQL Server, Oracle SQL, Teradata SQL, Alteryx, Linux, Google Analytics collected disjointed subscriber data and built new KPI reports developed reports and ad hoc analyses for Marketing and Finance clients, including e-commerce analytics built regulatory reports for Finance, filed with the FCC and state PUCs; identified fraud and production bugs developed a comprehensive report which identifies why subscribers lost eligibility, used every day by teammates in Marketing for campaign management, diagnostics, Sales for commissions, and by Finance for developing monthly budget; retooling processing and reporting, using Alteryx and Power BI developed models to predict sales for Marketing, Finance and handset management colleaguesSenior Data Analyst 06/2010 - 06/2012BUDCO Analytics Department Piscataway, NJ- SAS, Excel, Access, SQL Server, Business Objects, Alteryx designed and managed relational database for auto insurance client, handling their e-commerce marketing, db QA and automated reports, agent compensation, campaign development and ad hoc analyses compiled socioeconomic indicators of prospects, automated agent marketing kits, retrieved for their marketing materialDatabase Analysis Consultant 10/2009 - 04/2012Construction Financial Management Association IT Princeton, NJ- Excel, Access, SQL, Publisher, Business Objects developed an Access database for distribution of construction industry financial white paper membership management provided technical support for our website, email campaigns, convention data and access to industry financial reports created and automated marketing and finance reports using Business Objects and Access prepared and sent direct marketing messages to chapter members for e-commerce of financial white papers website maintenance, campaign development and analyticsComputer Science Certificate 2009Avtech Institute of Technology Piscataway, NJSAS, SQL, HTML, CSS, JavaScript, DreamweaverMarketing Forecast Analyst 07/2004 - 11/2008Ultimate Office IT and Marketing Farmingdale, NJ- Excel, Access, SQL, Hyperion, SPSS, Ecometry (Inventory, Marketing and Finance system), Google Analytics developed standard and ad hoc reports in support of business management produced reports using Excel and Access, to summarize market trends, forecast product demand and profit, for Finance, Marketing, Sales, Inventory departmentsFounder/CTO 10/2001 - 06/2004Global Metallurgical Supply e-commerce Somerset, NJ- Excel, Access, Html, JavaScript Small Business Administration training courses helped me start a small business, selling high tech equipment to oil industry professionals built e commerce website and prepared lists for email direct marketing campaigns developed an Access database to manage customer work orders and billingReports Manager 12/2002 - 11/2003Chase Home Equity division Iselin, NJ- Excel, Access, Foxpro, Sql, Lotus Notes designed home equity sales analyses, loan database management, financial modeling produced reports using Excel, and Access, to summarize market trends designed production and ad hoc analytical tools for market research, sales, finance and management developed sales agent rewards model, based on sales volume, data quality and the impact on profitStrategic Information and Analysis Manager 01/2001 - 07/2001First Data Corp Western Union Montvale, NJ- SQLPlus, Excel, Access, Oracle, Lotus Notes designed market research analyses, database management and financial modeling produced reports to summarize market trends, analyze customer response to incentive programs, including loyalty rewards, customer surveys and special events designed algorithms to match names and addresses from prospect lists with current customers, and developed logic to consolidate duplicate customers with both invalid and extra database records; this eliminated duplicate addresses, saving thousands of returned mail pieces per mailing, and allowed us to more efficiently identify and serve our customers designed production and ad hoc analytical tools for Market Research, Sales and FinanceSenior Database Analyst 09/1996 - 01/2001The Janus Group Analytics Bridgewater, NJ- SAS, SPSS, Excel, Access, SQL managed a consulting team assigned to clients and projects supervised and trained new employees; accounts for AT&T, Lucent, Ticketmaster, and Home Shopping Network developed and implemented systems to import and summarize questionnaire and census data, to produce interactive tables and graphs allowing clients to quickly respond to market changes created a PowerPoint application that imports raw data into Excel to perform customer segmentation analyses by credit scoring and applying demographics; the automation saved hundreds of person days of manual labor per month wrote various SAS and SQL programs to validate sales and complaints data; this revealed data integrity issues for Home Shopping Network; lead to substantial new business and provided online interactive reports developed financial models of customer retention, projected sales and revenue and reporting tools based on customer demographics and transaction historyTelecommunications Rate Analyst 04/1993 - 08/1996AT&T Marketing Sciences Department Basking Ridge, NJ- Excel, Access, SAS developed automated charting utilities; used to create ad hoc and production graphs for monthly reports; saving processing time and thousands of dollars by allowing users quick in house processing extracted data from Contract Tariffs; transferred to spreadsheets and organized to facilitate case studies for customers with telecommunications requirements in existing contract tariffs, saving many hours of manual labor; this tool was used in a commercial application to quickly provide service to customers developed user interface to interactively select fields and prepare reports from various telecommunications databases; allowing users to dynamically interact with SAS databases supervised clerical staff; developed managed rate databases to reduce manual labor developed analytical reporting tools for marketing, finance, sales managers; tools were used to report to senior management and FCC regulatorsConsultant 07/1991 - 08/1992Warner Computer Services - Analytics Division Fair Lawn, NJ- FORTRAN, Assembly Language designed, modified, tested and documented a large set of FORTRAN programs; as new changes were required to the production system; resulting in other developers requiring significantly less effort for subsequent changes evaluated and developed code specifications and prepared reports for customers; used by both clients and managers for strategic marketing and rate planning analyzed insurance financial and competitive data to enhance corporate policiesSenior Scientific Programmer Analyst / Meteorologist 06/1988 - 07/1991Unisys Corporation - government contract Ivyland, PA- FORTRAN, Unix, SUN Workstations, Assembly Language wrote the programs that process the raw doppler radar scan data to form 4D objects displayed as radar graphics images and time lapse loops used today by the NWS, research facilities, news and in smartphone and tablet radar display apps developed FORTRAN code for the Next Generation Weather Radar system, a nationwide array of strategically placed Doppler stations; these algorithms are currently being used by the National Weather Service to identify and predict storms and severe weather such as thunderstorms, hurricanes, tornadoes, snow and hail built site configuration module and system user interface; documented system and performed software test reviews, built unit and system integration testing performed statistical analyses between radar and observed values for station configurations and validation, this assured the NWS that the modules worked as designed and system properly handled hardware faults and data input errorsStaff Supervisor 04/1983 - 05/1988AT&T - Strategic Pricing, Marketing and Finance departments Basking Ridge, NJ- FORTRAN, SAS, BASIC, VISUAL BASIC developed market research tools to determine the marketing objectives of the competition, analyzed Local Exchange Carrier financials; this facilitated new marketing strategies and helped to raise Millions of dollars in annual revenue supervised clerical and technical support staff; the training and team management allowed these assistants to better help other colleagues and for them to develop their careers developed cost analyses, financial models and reporting tools and reports for the FCC and justice departmentAir Pollution Consultant, Research Assistant, Weather Observer, Forecaster 01/1982 - 04/1984Rutgers University - Meteorology Department New Brunswick, NJ- FORTRAN, SAS, BASIC, SPSS developed FORTRAN code to study the impact of Resource Recovery Plants on air pollution and automobile traffic, and processed air sampling data with EPA programs; analyses used by communities to vote on this issue programming and data extraction from logging devices; received award for accurately reporting data from various instruments, data used as input to forecast models by National Weather Service; prepared daily weather forecasts prepared several meteorological research projects with professors, for research grants; publishedEDUCATIONSAS Institute various classes 1982-1988 - Base SAS, Graphics, Statistics, SQL, Macros, SCLMeteorology and Physical Oceanography BS 1980Rutgers University / Cook College New Brunswick, NJ |
