Sr. Statistical Data Analyst Resume
Washington D, C
SUMMARY
- Sr. Statistical Modeler / Web Analytics / SAS Data Analyst
- 8+ years’ experience in statistical data analysis involving large datasets, mathematical programming
- Good balance of analytical capabilities and business knowledge in providing insights that drive companywide decisions
- Experience in Risk Management, Paid Search Optimization, sales/marketing opportunities, customer retention, Web analytics and Email marketing campaigns
- Ability to communicate and present complex research and findings in a simple manner
- Ability to lead projects, teams and meet deadlines
- Positive and flexible attitude, strong self learner and hard working
TECHNICAL SKILLS
Operating Systems: Linux, UNIX, Windows, Mac OS X
Prog. Languages: C, C++, Fortran (77/90), HTML, PERL, MASM, Visual Basic, MS SQL, PL - SQL, VBA, Java, Shell Script
Database: MS-Access, MS-Excel, Sybase, MS SQL Server 2005/2008, OracleMySql
Other: Mathematica, Matlab, Stata, Maple, Base SAS, SAS/STAT, SAS/GRAPH Statistica, NCAR Graphics, SQL Analysis and Reporting services, OLAP cubes, Igor-Pro, LaTeX, Ant, Eclipse, Erwin, JBoss, Perforce, Visio, SSIS, Informatica, Nagios, TOAD, Cygwin, Excel Risk Solver/Optimizer
Web analytics and Email Marketing: Unica NetInsight and Campaign Manager, Omniture Statistical / AnalyticalCustomer retention/survival analysis, Segmentation, Regression, Optimization, Decision trees, ARIMA and Ratio models, Predictive modeling, Boosted trees, CHAID, Clustering, Optimal binning, Correlation, Hypothesis testing, ANOVA, MANOVA, Discriminant and Factor Analysis, Probability distributions
PROFESSIONAL EXPERIENCE
Confidential, Washington, D.C.
Sr. Statistical Data Analyst
Responsibilities:
- Work closely with healthcare professionals, economists and policy experts to develop the model
- Requirement analysis, perform literature reviews to provide evidence base for modeling assumptions
- Instruct and train offshore teams on automation of the analysis and report generation
- Design new data models, support teams in maintaining the existing data models, analyze underlying data and derive appropriate analysis
- Apply statistical techniques such as regression analysis, distribution functions and probability theory in data preparation and model enhancement
- Model simulation setup, data extraction, data quality control, process management, optimization and documentation
- Develop user friendly graphical interface tools for client base for data extraction and analysis
- Multi-dimensional data processing, analysis and report generation, interact with clients on report requirement gathering
- Independently manage client base from requirement gathering to the output delivery
- Provide recommendations on IT infrastructure improvement
Environment: - Matlab R2012a - statistical, parallel processing, mapping, optimization toolbox, Stata/MP 12.0, Mac OS X Server Lion 10.7 - 64bit, MS-Excel-2011, VBA, SQL server 2008, MS-Access-2007
Confidential, Norwalk, CT
Sr. Statistical - SAS Data Analyst / Web and Email Campaign Analyst / Unica Developer
Responsibilities:
- Build filtering models that improved the quality of the customer base through data analysis and optimization - BIN based algorithms
- Optimize and manage the Risk and Chargeback for all VISA transactions
- Build statistical, predictive models for identifying risky customers / transactions using Statistica and Excel Optimizer
- Create forecasting for Risk and Chargeback to manage the impact of decisions made on business
- Create models based on demographics, member behavior and also analyzed the trends in various key performance metrics including call center data
- Implement statistical techniques using tools like SAS 9.2, Statistica, SQL server 2008, MS Excel.
- Develop SQL code and Excel Pivot reports that allowed key marketing partners understand how their decisions were impacting the business
- Develop standardization of key performance metrics across the organization
- Build OLAP Cubes in SQL server 2008 Analysis services for a branch of the business that was requiring retention metrics
- Provide analysis and reporting on the performance of company’s various proprietary online retail, financial products and services using various statistical, mathematical techniques and tools
- Provide technical support, automation of process and reporting requirements
- Test and implement new analytical techniques to help management to come up with informed decisions and prepare dash boards for product performance monitoring purposes
- Experience with scripting languages such as Shell, Perl with Cygwin for file manipulation and process automation
- Perform web analytics using online data and tools such as Unica’s NetInsight
- Analyze member behavior and financial data using web and backend data sources
- Communicate the findings of the analysis to the internal and external client base through reporting and presentations
- Design - test, control sets and manage Email marketing campaigns using Unica’s campaign manager application and AS400, analyze Email campaign responses
- Develop campaign flow charts and implement them for email marketing
- Analyze performance of marketing campaigns across channels - DRTV, Display, Search, Email
- Provide URL page tagging (generic, custom) requirements for analysis and reporting purposes
- Design reports for product and acquisition sites - funnel tracking, click stream etc
- Build dashboards and reports for Entry, Exit pages, referrer, favorite paths etc.,
- Create test environment for new product sites for web analytics
- Exposure to Omniture web analytic tools
- Develop reports for A/B testing, member segmentation
Environment: -Windows XP professional/ 7/ Server 2008R2, SAS 9.2, Statistica 9.1/64bit, SQL Server-2008 & Analysis and Reporting services, OLAP cubes, MS-Excel 2007, AS400, Unica - NetInsight, Unica - Campaign Manager, Shell & Perl scripts, Cygwin, CA Clarity - Project & Portfolio Manager v12, MS Visio
Confidential, Boston, MA
Operations Analyst / Data-miner
Responsibilities:
- Assessment of statistical data analysis and process automation
- Provide analytical and technical support to a growing number of ad-word search client accounts
- Support existing operational infrastructure, tune performance, troubleshoot software defects
- Participate in research and development of statistical algorithms and mathematical, predictive models using Matlab, SQL server2005, Excel (pivot tables, charts etc.) for Search Engine Optimization
- Apply data mining techniques and analyze large datasets
- Train business analysts, client managers / paid search analysts on search engine bidding / Optimization tool
- Analyze adword campaign reports and make optimization recommendations
- As part of professional services team, drove optimization efforts for customers like Dell, Aerotek etc. to increase conversion rates and realize return on investment in online channel
- Provided regular reporting, analysis to clients and help client managers understand the analytics
- Responsible to ensure smooth operation of online bidding tools 24/7 and used Nagios monitoring software
- Automated various processes using Cygwin and Perl scripts
- Participated in database design, generated various customized reports using SQL server 2005
- Working knowledge of SSIS packages and other data modeling, ETL tools
- Experience with Search Engine Marketing and Pay Per Click advertising / Optimization via Google AdWords, Yahoo Search Marketing and MSN adCenter
- Developed visual performance monitoring tools for adword campaigns using Excel and Matlab
- Experience with Regression analysis, hypothesis tests and other statistical techniques
Environment: - Windows XP professional, Matlab 7.4/R2007, SQL Server 2005 & SSIS, DTS, JBoss, Perforce, MS Visio, PERL, Cygwin, Ant, VBA, MS Excel
Confidential
Research Associate
Responsibilities:
- Performed mathematical, statistical modeling, computer simulations and algorithm analysis
- Designed and Implemented a bio-informatics software package used in DNA fingerprinting for searching microsatellites in diatom genome
- Applied Monte Carlo techniques to Quantum and Statistical physics problems
- Implemented Monte Carlo algorithms using Fortran (77/90) on Linux environment with NCAR Graphics and Numerical, MPI libraries
- Strong knowledge in Mathematica, Matlab and Maple programming
- Exposure to parallel computation on 40-node cluster running on Red-Hat Linux environment
- Gained experience in using SAS/Base including modules STAT, MACROS, SQL, GRAPH
- Knowledge on SAS, Access, Excel integration points, data checking, cleaning, manipulation, data analysis and report generation
Environment: Windows XP, Fortran 77/90, Mathematica, SAS, Maple, NCAR Graphics, Igor-Pro