MP

Summary of Experience

SAS Certified professional with Seven plus years of extensive industry experience in the analysis, design, development of statistical data development including data extraction and manipulation, writing macros and reporting on various projects for financial industries using SAS and its tools.

·               Proficient in SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/ACCESS, SAS Enterprise Guide

·               Experience with the SAS suite of reporting and/or BI tools

·               Solid understanding and proficient use of various procedures like proc SQL, proc report, proc freq, proc means, proc contents, proc dataset, proc append, proc import, proc export, proc print, proc sort

·               Strong knowledge about drop, keep, retain, and date manipulations, formats, in formats.

·               Excellent command in writing complex routines for Data Validations, Data Extraction, transformation and loading to target decision support systems using MS Excel and SAS on various environments.

·               Proven skills in Data Cleansing, Data Archival, Data Migration, ad-hoc reporting and coding utilizing SAS on UNIX, Windows

·               Proficient in BASE SAS, intermediate to expert SQL skills and experience with large data warehousing environments (Teradata, Oracle, etc.)

·               Experience in using various MS office tools for analyzing, arranging and presenting data

·               Strong experience in coding using SQL, Procedures/Functions, SAS macros.

·               Experience with design and implementation of SAS data architecture as used by SAS BIcomponents (OLAP cubes, metadata, roles, etc.)

·               Experience in creating SAS programs for EDIT CHECKS and performed data validation on raw data sets and created data set for analysis.

·               Possess experience as a SAS programmer in UNIX, Mainframe and PC Environment.

§     Knowledge of different types of Data Warehouse, EPM and Business Intelligence solutions such as those from IBM/Cognos, SAP/BO, Oracle/OBIEE , Hyperion, SAS, Teradata and others.

§    Experience in loading flat files to Teradata by writing fast load scripts.

§    Good Experience in Validation methods.

§    Experience with Secure File Transfer Protocol (SFTP).

·               Good analytical skills pertaining understanding a business domain coupled with excellent teamwork and strong communication skills.

·               Hard working, ethical and highly result oriented. Ability to quickly grasp and apply new concepts and technologies.

·               Good knowledge in software engineering methodologies

·               Extensive experience in preparation of reports, tables, listings and graphs

·               Strong leadership, interpersonal and oral/written communication skills

·               Self-starter, good team player, enthusiastic, innovative and challenge oriented.

Technical Skills

Education

Bachelors in Management Information Systems (University of Northern Iowa)

Professional Summary

American Express, Weston, FL                                                    March 2011 – Till Date

SAS Programmer/Analyst

Responsibilities:

·      Make the results actionable for Marketing, Campaign Planning, Strategic Planning, Finance and Sales organizations.

·      Performed statistical analysis and data management on study data by utilizing appropriate statistical methods using SAS and SAS tools.

·      Integrate results of the Marketing Mix Analysis, Price Elasticity and other advanced analyses into business planning process.

·      Assist in the creation of quantitative and qualitative primary research and present the findings.

·      Ability to dig into raw data to find and evaluate actionable insights that will help the organization.

·      Analyze and interpret significant results based on data summaries.

·      Work closely with different Marketing Groups in designing and analyzing the data.

·      Extract the data from a data warehouse and create ad-hoc reports, tables, and graphs according to Business needs.

·      Perform Metadata (Information Map, OLAP, Enterprise Guide) development

·      Direct the development, testing and maintenance of SAS-EBI reports

·      Provide support for, and automation of, routine SAS-EBI stored procedures.

·      Create Data Dictionary and migrate the data when shifting to new version of SAS.

·      Perform statistical analyses and QC statistical output.

·      Results are performed using SAS programming and using techniques such as SAS Macro language, advanced data manipulation, and statistical procedures (e.g., PROC FREQ, PROC REPORT).

·      Used various procedures such as Proc Tabulate, Proc Means and Proc Report to generate tables, listings, graphs and reports.

·      Provide SAS Programming support and technical assistance in the accurate development and intermediate steps required.

·      Modeling SAS data stores (SAS OLAP / SAS MOLAP Cubes) required to supportbusiness intelligence and reporting needs.

·      Assist in Optimization of Performance for SAS OLAP Cubes (SQL to SAS, SAS OLAP Build Time,SAS OLAP slice and dice, SAS OLAP aggregations, partitioning, etc…)

·      Present statistical results using the appropriate graphs, charts, tables and written reports.

·      Creating ad-hoc reports.

·      Used SAS ODS to create HTML, RTF and PDF outputs files in the process of producing reports.

·      Formatted HTML, RTF and PDF reports using SAS output delivery system ODS.

·      Extracted, performed validation and generated SAS data sets from Teradata; applied SQL Pass through Facility.

·      Tested and debugged existing MACROS.

·      Used SAS DATA _ NULL_ and PUT statements to create the customized reports.

·      Develop new macros for report generation using SAS/Macros as per the customer’s requirements.

·      Extracted, performed validation and generated SAS data sets from Teradata; applied SQL Pass through Facility.

·      Default Report output is HTML and provided the options of WORD & EXCEL formats using SAS/ODS statements.

·      Used FTP to download SAS Formatted Data into EXCEL AND CSV format.

·      Retrieving Millions of Records Using different Procedures.

·      Used base SAS and SAS/SQL to generate tables.

·      Used PROC compare to compare the data before and after editing

·      Developed various SAS reports for Survey project and involved in code reviews for all the developed reports

Environment: SAS 9.1.3/9.2, BASE/SAS, SAS Enterprise Guide, SAS/MACRO, SAS BI,SAS/SQL, SAS/CONNECT, SAS/ACCESS, SAS/ODS, Oracle 11g, Teradata, UNIX and Windows XP.

Wells Fargo, Sioux Falls, SD                                                  Jan 2009 – Feb 2011

SAS Programmer/ Analyst

Worked for the Analytics team, to update the regular reports and providing solutions for the ad-hoc requests.

Responsibilities:

·   Utilized SAS/ACCESS to extract data from Sybase and other relational databases for analysis.

·   Understand and update the existing code or create new code by using BASE/SAS, SAS/MACROS and SAS/SQL to implement new requirements.

·   Expertise in statistical modeling and analysis on study data by utilizing appropriate statistical methods.

·   Get the Production the SAS code and analyze.

·   Extracted data from the Mainframe flat files using SAS, SAS SQL procedures and create SAS data sets.

·   Wrote various format and integrity edit checks on CSV files and on staging SAS datasets.

·   Develop SAS code to validate data of different portfolios.

·   Modified existing SAS programs and created new programs using SAS macro variables to improve ease and speed of modification as well as consistency of results.

·   Generate Reports in user required format by using ODS and PROC Report.

·   SAS data sets are validated using SAS procedures like Proc Means, Proc Frequency and Proc Univariate.

·   Creating Data Models for different level of test validation based on the reports.

·   Performed data integrity checks and data cleaning using SAS MACROS and data steps, created HTML outputs with table of contents using ODS HTML.

·   Used SAS PROC SQL Pass through Facility to work with Teradata database.

·   Analyzed and implemented the code and table changes to improve performance and enhance data quality.

·   Done Code Optimization using SAS macros.

·   Creates and revises the common macros.

·   Reading data from different sources like .csv, excel, tab delimited files.

·   Perform various business checks on the source data to confirm whether data is correct or not.

·   Compare the source data with historical data to get some statistical analysis.

·   Perform transformations like Merge, Sort and Update etc.. to get the data in required format.

·   Create the understandable EXCEL template to start dad mapping for each line of business.

·   Extensively utilized SAS/BASE, SAS/SQL and SAS/MACRO.

·   Extensively used procedures such as PROC APPEND, PROC IMPORT, PROC MEANS, PROC SUMMARY, PROC CONTENTS and PROC SQL.

·   Involved in project review meetings with respective Business SME’s.

·   Move data sets across platforms (from PC and Mainframe to UNIX and Vice Versa).

·   Generate the genealogy by using EXCEL MACRO to make it better understandable to end user.

Environment: SAS 9.1.3, BASE/SAS, SAS/MACRO, SAS/SQL, SAS/CONNECT, SAS/ACCESS, SAS/ODS, Oracle 11g, UNIX, ETL, Mainframes

First Citizens Bank, Blacksburg, VA                                                             Feb 2006 – Dec 2008

SAS Programmer

Worked with users and development team to develop new projects, enhance the existing projects and supplied the ad-hoc analysis reports.  

Responsibilities:

·               Develop, enhance & execute complex programs and reports with proper documentation.

·               Comprehend production codes, undertake diagnosis, resolution of complex issues and improve the efficiency of processes and programs.

·               Develop business domain expertise, rudimentary project based business knowledge and good theoretical knowledge of tools like SAS, MS office Independently delivers end to end on complex projects and assist in developing and testing new information infrastructure.

·               Manage end-user expectation in the delivery of projects within agreed timelines and as per agreed quality standards.

·               Independently executes standard processes, implements predefined algorithms and corrects identified problems.

·               Created SQL views for retrieving and dynamically updating data.

·               Maintaining large data sets, i.e. reading in data from various sources in various formats to create SAS data sets and/or ASCII files.

·               Documenting the process, i.e. documenting all the possible information about the application like SAS programs, DATA files and source.

·               Preparing project plan for the execution.

·               Independently interacts with business partners to understand business need and translates to technical specifications. Assist in developing and testing new information infrastructure.

·               End to end project management and hands on delivery when required.

·               Take ownership and actively manage project timelines. Execute standard reports, processes, files, and implements predefined algorithms

·               Sets up QA/QC framework and ensures adherence and constant improvement.

·               Used SAS system macros for error handling, code validation, date stamping of log files, collected files to a given directory and scheduling.

·               Develops business and technical knowledge of team members and identifies opportunities of improvement.

Environment: SAS, BASE/SAS, SAS/MACRO, SAS/SQL, SAS/CONNECT, SAS/ACCESS, SAS/ODS, Oracle, Teradata, DB2, UNIX and Windows 2003/XP.