Rajesh Kapadia
** ******** **** - **********, ** 08536
************@*****.*** - 908-***-****
Well diversified and experienced in Marketing Analytics, Predictive Modeling, Business Intelligence and KPI, Financial Services, Telecommunications and Wireless, Information Systems, Product and Project Management and Market Research Authorized to work in the US for any employer - US CITIZEN PROFESSIONAL EXPERIENCE
Statistical Consultant
L’Oreal-USA – Clark, NJ – November 2015 to Present
• Responsible for Statistical Analysis, Data Analysis, Validation of Operators, Testing and Tests Creation, and Experimental Design
• Used XLSTAT, R, and MS EXCEL, as well as other Statistical analysis packages for Statistical Analysis, Data Extraction, Transformation and Loading, Data Analysis and Data Mining.
• Wrote a number of reports for end users, clients and internal management summarizing findings and statistical inference drawn.
• Developed customer ready dashboards and reports using advanced visualization tools.
• Created attractive Power Point presentations using advanced features.
• Managed multiple projects involving a number of departments, products and functional areas Senior Statistician
Vantage Learning - New Hope, PA - January 2015 to June 2015
• Responsible for Statistical Analysis, Data Analysis, Testing and Tests Creation for Placement, Diagnostics,
• Assessment and Consulting
• Used SPSS and MS EXCEL, as well as other Statistical analysis packages.
• Wrote a number of reports for end users, clients and internal management summarizing findings and statistical inference drawn. Data Analyst
METLIFE - Somerset, NJ - July 2014 to November 2014
• Performed statistical analysis and data analysis for the marketing department for Campaign Analysis and
• Other analytical modeling efforts in support of direct marketing efforts and campaign communication strategies.
• Used SPSS-Modeler and MS EXCEL, MS POWERPOINT, as well as Statistical analysis packages.
• Skills Used
• Used SPSS-Modeler and MS EXCEL, MS POWERPOINT, as well as Statistical analysis packages.
• Was responsible for preparing final reports of the analysis performed and statistical conclusions. Lead Analyst - Data Mining
Subaru of America - Cherry Hill, NJ - March 2013 to June 2014
• Designed, developed, engineered and perfected data mining functions within the Information Technology Department
• Performed statistical analysis and data analysis for the marketing department for customer loyalty modeling, Intention to purchase modeling, churn analysis, sales forecasting and other analytical modeling efforts in Support of direct marketing efforts and campaign communication strategies.
• Gained excellent knowledge and understanding of advanced predictive models and programming in Python.
• The type of analysis performed include, but not limited to, data mining techniques, such as, CHAID, CART, Boosted Tree Classification, Random Forest Classification, General Additive Modeling, Neural Networks, Association Rules Techniques, Text Mining, Cluster Analysis, Linear and Non-linear regression analysis, Forecasting, Non parametric analysis, etc.
• Used STATISTICA 12, R, SPSS and MS EXCEL, MS ACCESS, MS POWERPOINT, MS PROJECT, SQL,
• SQL, Oracle Crystal Ball as well as Statistical analysis packages.
• Produced many management reports, both on a regular basis as well as, on demand on an ad-hoc basis, using MS EXCEL, MS ACCESS and other report writing software. Statistical Marketing Analyst
Exelon Corporation - Philadelphia, PA - May 2012 to November 2012
• Performed statistical analysis in the marketing department for forecasting energy sales (Gas, Electric, etc.), market penetration analysis, ROI analysis on new investments etc.
• Used MS Excel, MS Access, MS PowerPoint, MS Project, SQL, Business insights-Global as well as statistical analysis packages
• Produced management reports, both on a regular basis as well as, on demand on an ad-hoc basis, using
• MS Excel, MS Access and other report writing software Marketing Data Analyst
Strategic Research Insights - Plainsboro, NJ - March 2012 to May 2012
• Responsible for final preparation of MS PowerPoint presentations for market research studies for multi-national pharmaceutical company
• Performed involved complex statistical analysis using MS Excel statistical, financial and data analysis capabilities
• Used MS Excel, Access, PowerPoint, as well as statistical analysis packages Senior Marketing and Business Analyst
Allstate Insurance Agency - Colonia, NJ - December 2011 to February 2012
• Prepared sales reports for homeowners, auto, and other property and casualty insurance, as well as life and health insurance, disability and long term care insurance
• Supported the agency owner in marketing communications, market research and customer support
• Used MS Windows XP, MS Excel, Word and PowerPoint, SharePoint Marketing Analyst
Sears Holding Corporation - New Brunswick, NJ - July 2011 to August 2011
• Performed sales, marketing, market research, and product research for Sears Home Improvements products and services
• Used Windows 2000, Enterprise, MS Excel, MS Access, Visio, MS Word, MS PowerPoint Security Systems Specialist
DEVCON Security Systems - Mount Laurel, NJ - March 2011 to May 2011
• Responsible for security systems planning, design, development, and implementation
• Used Windows 7, MS Word, SharePoint, Visio, MS Excel, MS PowerPoint and MS Access Marketing and Financial Analyst
Penn Mutual Insurance Company - Edison, NJ - June 2010 to February 2011
• Responsible for daily and ad-hoc preparation of sales reports for auto, home, life and health insuranceWrote a number of proposals for pricing
• Supported the marketing department in creating mass marketing material for online niche activities, such as, event marketing, trade shows, conventions, etc.
• Worked with Google Analytical search actives, such as, Ad Sense, and other analytical tools, translating the online marketing activities in the database marketing efforts using various applications, such as, Outlook, Excel, Access, PowerPoint, SharePoint, Visio and MS Project
• Performed online marketing functions, such as, creating and maintaining marketing databases
• Provided information to customer management service, customer service website development and management, data collection, consolidation, extraction and cleaning
• Supported senior executives in presentation preparation, data analysis and writing marketing communication documentation as well as performing website effectiveness analysis using statistical modeling techniques, and providing management reports using standard templates
• Used Windows 7, MS Excel, MS Access, SQL, Statistical Analysis add-ins, MS PowerPoint, MS Word, Visio and MS Project Marketing and Customer Service Analyst
Allstate Insurance Agency - Edison, NJ - February 2008 to July 2008
• Analyzed sales for products targeted towards homeowners, auto, and other property and casualty insurance
• areas using sophisticated analytical modeling for risk management and portfolio optimization techniques
• Supported the agency owners in marketing communications, market research and customer support by
• providing timely management reports for web statistics, effectiveness and utilization efficiencies
• Used MS Windows XP, MS Excel, MS Access, MS Word, Visio, MS Project and MS PowerPoint Financial Analyst
Citigroup - New Brunswick, NJ - April 2006 to February 2008
• Performed financial analysis, planning and portfolio management for clients by performing analytical modeling and statistical analysis, portfolio optimization techniques as well as asset allocation modeling
• Created customer presentations, proposals and marketing documentation for financial services
• Used MS Windows 2000, SAS, STATISTICA, SQL, MS Word, MS Excel and MS PowerPoint Project Manager/Staff Product Manager
AT&T - Bedminster, NJ - June 2001 to April 2006
• Worked as Technology Consultant in product management and marketing research
• Responsible for Product Life Cycle Management, introduction of new services, pricing and profitability management of existing products/services and features
• Performed end-to-end product development cycle management, analytical modeling, strategic planning/ financial analysis/decision modeling, forecasting and budgeting
• Financial analysis for major contracts, promotional effectiveness measurements using standard benchmarking techniques with templates for web statistics, and ROI for Marketing Communication funding
• was included
• Operational effectiveness measurement and analysis included such tasks as product costing, cost minimization studies, interval reduction studies, and Just in Time inventory control studies
• Designed and developed an on-line pricing and price negotiation tool for field support for special pricing
• Performed complete P&L statement preparations for the Business Unit, and developed several forecasting models for sales and R & D budget planning
• Used MS Excel, MS Access, MS PowerPoint, MS Project, SAS and other Statistical Analysis software EDUCATION
MBA
University of Texas - Austin, TX
MS Electrical / Computer Engineering
University of Texas - Austin, TX