OVERVIEW

• Skilled Data Analyst and SAS developer with progressive experience in Information Technology. Accumulated diverse skill set across various key roles in data warehouse, data analysis, and ETL architecture. Possesses excellent time-management and planning skills and has the ability to work constructively in a fast paced, multi-tasking environment.
• Over Five years of experience developing with SAS and performing Data Analysis on UNIX.
• Over Eight years of experience in writing/tuning SQL queries on a wide variety of data sources Oracle, IBM DB2, SQL Server, Teradata BTEQ .
• Proficient in data manipulations, report/graph generation with varied SAS functions, procedures, macros and ODS facilities.
• Well versed with SAS procedures like Proc Print, Proc Means, Proc Report, Proc Transpose, Proc Summary, Proc SQL, Proc Freq, Proc Tabulate.
• Experience in many projects where SAS is used end-to-end.
• Demonstrated expertise in using following tools: SAS 9.3, SAS Enterprise Guide, SAS E-Miner, Business Objects XI, Informatica 9.5, IBM Cognos 10, BMC Performance Assurance , Crystal Reports, Microsoft .NET Dev. Environment, XML/XSL Transformations.
• Core Development skills with ETL, Reports, Graphs and Dashboards.
• Knowledge of reporting platforms such as SSRS, Business Objects and Cognos.
• Understanding of Analytics and various statistical, forecasting and predictive modeling methods like ANOVA, regression, time series analysis, decision trees.

• Extensive knowledge of analytical manipulation and interpretation of large SAS data sets.
• Excellent Data Warehouse modeling skills star schema, snow-flake schema , building data-marts, and summary tables.
• In-depth knowledge, understanding, and experience with the entire SAS EBI suite including Web Reporting Studio WRS , Information Delivery Portal IDP , Information Map Studio IMS , Online Analytical Processing OLAP Cube Studio and Server, Business Intelligence BI Dashboard Studio, Add-In for Microsoft Office AMO .
• Proficient in usage of many popular software packages, including all Microsoft Office applications, Windows Server, BackOffice and Small business server.
• Working knowledge of HTML, XML and Java.
• Excellent interpersonal skills, oral and written communication.
• Highly self-motivated and directed with excellent analytical, problem solving, presentation, and decision making skills..

PROFESSIONAL EXPERIENCE

Confidential

SAS Developer and Consultant

Project Overview:

• Reviewing reporting on vehicle and business health and ensuring that ongoing campaigns are delivering results consistent with business objectives.
• Work with CRM global resources to ensure that State Farm marketing has the right modeling and analytic solutions in place and providing information on those solutions to business partners.
• Manage and coordinate data analysis and data modeling projects across business units to identify and solve a variety of business problems and to meet management objectives.
• Develop strong working relationships with Cycle planning team to provide macro level insights on buying behavior of customers.
• Design and deliver creative approach to insights projects based upon business needs.
• Develop reporting suite of customer metrics in a frequency to drive action and business impact.
• Manage complex analytics projects across US and Canada for Consumer Marketing.
• Partner resources to drive success of the Consumer Insights team. Provide leadership the vision of where Customer insights are going.

Responsibilities:

• Design and develop Reports / Dashboards using SAS Enterprise Guide and Web Report Studio.
• Create Source to Target Mappings using ETL tools, version control, metadata management, automated deployment, and automated detection of change to source systems that can be propagated to the Data Warehouse.
• Analyze business requirements write ETL logic to extract data from Oracle.
• Responsible for testing, publishing reports and providing access to end users.
• Build and maintain complex statistical SAS routines using macros.
• Create detailed documentation outlining report criteria.
• Maintain data integrity and ongoing quality control of reports.
• Ensure that reports support the overall scope of marketing strategies.
• Respond and track status of customer issues, coordinate appropriate response and provide follow up for the duration of an incident/problem ticket life cycle.
• Maintain the data quality of analytical data warehouse and document best practices.
• Deploy jobs and fine tune the performance of the system using special macros. Plan for the overall logical and technical architecture of SAS 9.3.
• Adherence to Service Management guidelines and process.
• Tools / Environment: SAS 9.3, IBM Cognos 10 , Informatica PowerCenter, Business Objects XI, Oracle 11g, IBM DB2, CA E-Health Suite, Crystal Reports, Windows 7 and UNIX.

Confidential

Job Title: SAS Statistical Programmer

• Employ Statistical methods, regression/clustering/time series analysis by R and SAS using advanced mathematical and statistical concepts and theories to collect and analyze data to define business goals and objectives.

• Construct predictive models, algorithms and probability engines to support data analysis or product functions verify model and algorithm effectiveness based on real-world results as well as designing experiments and methodologies to generate and collect data for business use.

• Work closely with compliance team to meet their ad hoc requests via preparing data and designing performance monitoring reports

• Developed models for Performance metrics for forecasting and simulation.

• Designed forecasting system for predicting Call volumes, Capacity requirements, and long-term capital requirements.

• Deliver Industry Best Practice Consulting, Business Reviews, and Business Intelligence tools allowing clients to benchmark performance against Market trends/comparisons.

• Tools / Environment: Base SAS, SAS Enterprise Guide, SAS E-Miner, SPSS, Business Objects XI, Oracle, IBM DB2, Crystal Reports and UNIX.

Confidential

Data Analyst, Reporting team

Responsibilities:

• Design, develop and produce performance and capacity reports that accurately reflect the state of the systems being monitored.
• Analyze performance data and determine appropriate thresholds for automated alerting.
• Develop and implement infrastructure capacity planning and optimization to fully utilize available resources.
• Determining appropriateness and frequency of the metrics being monitored and collected.
• Preparation and presentation of performance tuning and capacity recommendations.
• Conduct performance and capacity planning analysis on the production environment.
• Work with project teams to design and monitor application performance.
• Present analysis and capacity projections to systems management and business partners.
• Identify any changes in the systems architecture, applications, or hardware that may impact performance or capacity of UNIX servers.

Tools / Environment: SPSS, SAS, Business Objects, Oracle, SQL Server, BMC Performance

Assurance , Crystal Reports and UNIX.

Confidential

Database Systems Administrator

Responsibilities:

• Day to day administration of World Wide Web infrastructure, troubleshooting, code development and enhancement, HTML documentation, web content consulting, assisting users and supporting Intranet Web functionality.
• Reported monthly web traffic with log file analysis tools Web Trends .
• Administration of all internet production software.
• Moving tested applications and content into production.
• Performed capacity planning and long term strategy for hosting environment.
• Administration and performance monitoring of all machines, including proactive administration.
• Provided technical support including training of end users.