SUMMARY

• Certified SAS programmer and Predictive Modeler with more than 7 years of experience in Market/Risk Analysis, Financial Analysis, Data Analysis/Business Analysis, System Analysis & Design, Development, testing and implementation of projects in Manufacturing, Retail, Pharmaceutical, Healthcare and Financial industries.
• Expertise in BI/Data Warehousing concepts, designs, and project implementations.
• Solid understanding and experience in Database marketing, Data Mining, Advanced data mining SQL and SAS Programming in Windows, UNIX environments.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Proficient in Tableau 8.x/7.x/ 6.x (Desktop, Server, Public, Mobile), Micro Strategy 9.x/8.x product suite (Desktop, Intelligence Server, Narrowcast Server).
• Hands - on experience using analytical software like Base SAS 9.2, SAS Enterprise Guide 4.2, SAS/Macros, SAS/SQL, SAS/STAT, SAS/Access, SAS/GRAPH, and SAS/ODS, SPSS, SQL etc.
• Expertise in building and maintaining SQL scripts including database objects such as stored procedures, views and functions for data extraction and analysis.
• Expert in modeling techniques like regression, decision trees etc.
• Excellent Knowledge of statistical analysis like ANOVA, multivariate analysis, T-tests, Chi-Square tests, Correlation, association etc.
• Expert in Base and Advanced SAS programming procedures like PROC SQL, PROC REPORT, PROC ACCESS, PROC GPLOT, PROC GCHART, PROC FORMAT, PROC TABULATE. Extensive experience in SAS/STAT procedures such as PROC GLM, PROC FREQ, PROC MEANS, and PROC UNIVARIATE.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Significant ability to transform large datasets from multiple sources into actionable business intelligence.
• In depth knowledge in Building models for Up-Sell, X-Sell and Retention/Acquisition models for Banking/Financial, Credit card and Marketing Domains to increase the response rate.
• Comfortable in working with various types and volumes of data (demographic, product specific, financial etc.) to produce high quality analytics and metrics.
• Excellent report writing, communication, presentation and interpersonal skills.
• Effective team player with demonstrated leadership, time-management and problem-solving skills.
• Adept at multi-tasking and thriving in a fast-paced environment while coordinating multiple projects.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
• Strong influence management skills, reporting and analytical/problem solving skills with attention to detail.

TECHNICAL SKILLS

Analytics Tools: DataRobot, Tableau, Micro Strategy, Business Objects, Pentaho

SAS Programming tools: BASE SAS, SAS STAT, SAS GRAPH, SAS ODS, SAS/ACCESS, SAS/SQL, SAS Enterprise Guide, SAS/ETL

ETL Tools: Oracle ODI, Informatica, Data Stage, SSIS

Requirements Management: Microsoft Office (Word, PowerPoint, Excel)

Front End Tools: Microsoft Project, Microsoft Office

Databases: DB2, Teradata, Oracle, SQL Server, Access, My SQL, Netezza

Scripting Languages: R, SQL, PL/SQL and XML

Data modeling: Power Designer, ERwin, ER Studio, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

Sr. SAS Admin/ SAS Programmer

Responsibilities:

• Used SAS, SQL, R, SPSS, Tableau and DataRobot to perform end-to-end analytics for the clients.
• Response Modeling (Propensity Modeling) - Predicted the chances of a person getting a disease (Diabetes, Orthopedics, Cancer etc.) using hospital patient data, customer demographics, third party consumer data (Experian) in a geographic footprint. Models such as logistic regression, decision trees, gradient boosted trees, random forest, etc was built to generate the probability output for each person in the data.
• Customer Acquisition - Outcome of predictive models is arranged in deciles and lift is generated to measure the performance of model. Depending on the business objective and marketing budget of the client, I advised them to target top 2-3 deciles to acquire customers. Also, advised them to use an appropriate marketing channel (email, snail mail, social media campaigns, bill boards etc.) depending on whom are we targeting and what’s the mosaic of that cluster.
• Customer Analytics - Devised strategies for customer retention, x-sell, up-sell, and behavior analysis.
• Market Segmentation and Customer Profiling for a large client based out of Missouri - Performed a hierarchical cluster analysis on a 50 mile radius geographic footprint of the client’s headquarters to divide the customer base into 6 segments. Followed it by a thorough profiling of all the customers who were customers of Walgreens in that area. After analyzing the customer behavior and comparing it with the segments created, I strategically decided on the location of a new urgent care centre for the client. This project won many accolades from the client.
• Good knowledge of ICD9, ICD10, DRG, CPT, patient variables, providers and payers.
• Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
• Built compelling, interactive dashboards in Tableau that answer key business questions.
• Interacted with Business users in understanding their requirements.
• Generated insights out of voluminous and complex datasets and built story lines.
• Produced complex table calculations, use of parameters, actions, filters and other advanced options in Tableau.
• Designed excellent tableau dashboards and presented correct decisions independently based on what different kind of visuals would make sense for the business.
• Worked with the report development Manager and other team members on report requirements based on exiting reports/dashboards.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Created Table of Contents (TOC), a common navigation page which had all the links to various reports.
• Made use of filters and making them local and global accordingly.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Actively participated in clarification meeting with the Clients.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau (Desktop, Server), Teradata, Teradata SQL Assistant, Teradata Administrator, SQL, PL/SQL, MS Project

Confidential, IL

SAS Admin / SAS programmer

Responsibilities:

• Performed ETL-Extraction/Transformation/Loading, data migration, sampling, data preparation, graphical presentation, statistical analysis, validation, reporting, and documentation.
• Extracted data from different sources like Oracle and Teradata and text files using SAS/Access, SAS SQL procedures and created SAS datasets.
• Used SAS procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE, and PROC REPORT in order to understand and prepare the data.
• Build and maintain SQL scripts including database objects such as stored procedures, views and functions for data extraction and analysis.
• Stored procedures made helped in improving the maintenance, testing and speed/optimization of the server.
• Developed and designed SAS programs/macros to analyze financial data and to create files, tables, listings, and graphs. Developed ad-hoc reports as per business requirements and created various reports like summary reports, tabular reports.
• Developed SAS programs for statistical analysis and data displays working with various SAS products SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS etc. to develop solutions.
• Wrote programs in SAS, generate reports, creating RTF, HTML listings, tables and reports using SAS ODS for ad-hoc report generation.
• Implemented credit risk analysis reporting system based on FICO scores and data management principles, such as joining dataset, indexing, data aggregation, record selection, sub-setting, and multiple records per case, creation and modification of views, accessing multiple databases.

Environment: SAS/Base, SAS Enterprise Guide, SAS/Macro, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ODS, Oracle 9i, MS EXCEL, MS ACCESS

Confidential, San Jose, CA

SAS Programmer/SAS Admin

Responsibilities:

• Extracted data from different sources like Oracle and Teradata and text files using SAS/Access, SAS SQL procedures and created SAS datasets.
• Performed data preparation and transformation using SAS procedures to ensure data quality and consistency.
• Used SAS PROC SQL pass through facility to connect to Oracle tables and created SAS datasets using various
• SQL joins such as left join, right join, inner join and full join.
• Used Stored procedures to improve the performance of the database.
• Developed SAS programs to create a customer mailing list for Direct Mailing and Telemarketing
• Maintained and enhanced existing SAS reporting programs for marketing campaigns.
• Conducted significance tests and study response rates for different offers.
• Performed analysis on campaign response datasets and created reports with extensive use of BASE SAS, Macros, SAS reports, procedures to produce tables and graphs in EXCEL.
• Used SAS SQL to query data and to obtain results, which were generally stored as delimited text.
• Performed extensive regression and statistical data analysis using PROC REG, PROC GLM
• Created executive summary report and power point presentation for campaign results to illustrate internal conferences.

Environment: Windows XP, SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS/Enterprise Guide, HTML, Teradata.

Confidential, San Francisco, CA

Predictive Analyst

Responsibilities:

• Worked with large customer response and sales data sets
• Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets
• Created reports using SAS /ODS and SAS /views from oracle database tables into different formats like HTML and RTF
• Developed SAS programs to create a customer mailing list for Direct Mailing and Telemarketing
• Conducted significance tests and studied response rates for different offers using SAS Enterprise Guide
• Analyzed response and sale results and write up monthly summary on campaign performance
• Created reports using PROC REPORT, PROC TABULATE, and ODS statements to generate output formats
• Generated output using SAS/ODS in CSV, XLS, DOC, PDF and HTML formats
• Reviewed, validated, documented and mentored the team regarding SAS environment

Environment: Windows XP, SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS/Enterprise Guide, HTML, Teradata.

Confidential, Portland, OR

SAS Analyst

Responsibilities:

• Developed SAS programs to create a customer mailing list for direct mailing and telemarketing. Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Involved in update and maintenance of data warehouse and generation of various sales and marketing reports.
• Performed data analysis, created reports with extensive use of BASE SAS, macro and SAS reports with the help of default procedures.
• Generated graphs using SAS Report and SAS /Graph.
• Worked with large customer response and sales data sets.
• Worked on creating SAS Data sets from flat files and merging data. Maintained and enhanced existing SAS reporting programs for marketing campaigns.
• Data processing and validations were done extensively on the SAS datasets using edit check programs.
• Conducted individual account and household level analysis. Conducted significance tests and study response rates for different offers.
• Analyzed response and sale results and write up monthly summary on campaign performance.
• Created data models for different level of marketing based on the reports.
• Created reports using PROC REPORT, PROC TABULATE, ODS to generate output formats in HTML.
• Restructured SAS datasets using PROC Transpose procedure.
• Used PROC SQL pass through facility to work with ORACLE and DB2.

Environment: SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/CONNECT, SAS /STAT, SAS/SQL, ORACLE, Excel, HTML.

Confidential

SAS Programmer

Responsibilities:

• Extensively used SAS Data Step functions and descriptive statistical Procedures to process large amount of customer response and sales data.
• Used PROC SQL LIBNAME and PROC SQL Pass-through methods to access data on Oracle database.
• Created customer mailing lists for Direct Mailing and Telemarketing using PROC Forms
• Extensively used PROC Import and PROC Export procedures for importing and exporting PC files and Microsoft Office files such as Excel Spreadsheet, Access Tables.
• Maintained and enhanced existing SAS Reporting programs using PROC Tabulate, PROC Report, PROC Print, ODS RTF, and ODS PDF for marketing campaigns.
• Used SAS enterprise Guide to run statistical tests like ANOVA, Chi-square etc.
• Created Ad hoc reports for marketing managers using SAS Enterprise Guide.

Environment: Windows XP, SAS Enterprise Guide, Base SAS, SAS/Access, Oracle, SQL.