Summary of Experience

Having 6 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.

• SAS professional with 6 years of experience in developing statistical methods routinely used in Financial/Health care/Education/Telecom/Sales and Marketing data analysis.
• Experience in SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/ACCESS, SAS Enterprise Guide
• 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 print, proc sort
• Have strong knowledge about drop, keep, retain, and date manipulations, formats, in formats.
• Work as part of a project team to coordinate database development and determine project scope and limitations. Write and code logical and physical database descriptions.
• Proven skills in Data Cleansing, Data Archival, Data Migration, ad-hoc reporting and coding utilizing SAS on UNIX, Windows
• Experience in using various MS office tools for analyzing, arranging and presenting data
• Strong experience in coding using SQL, Procedures/Functions, SAS macros.
• Experience resolving data quality assurance issues in connection with information delivery and development tasks.
• 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
• Ability to work independently as well as collectively & willing to relocate

• SAS Tools:
• SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/ACCESS, SAS Enterprise Guide.
• Programming:
• SQL, PL/SQL and Unix.
• Databases:
• Oracle 11g, DB2, Teradata, Sybase
• Package:
• MS Word, MS Excel, MS Power point, MS Visio, MS Project Management
• Environment:
• Windows and Unix.

• B.Tech in Engineering

Confidential,Phoenix, AZ Jan 2011 – till date
SAS Developer/Analyst

Responsibilities:

• Make the results actionable for Marketing, Campaign Planning, Strategic Planning, Finance and Sales organizations.
• Experience resolving data quality assurance issues in connection with information delivery and development tasks.
• 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.
• Testing case design, performing testing and validation of new code prior to release.
• 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.
• 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.
• 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.
• Used SAS PROC SQL Pass through Facility to work with DB2 database.
• 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.
• 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/SQL, SAS/CONNECT, SAS/ACCESS, SAS/ODS, Oracle 11g, Sybase, UNIX and Windows XP.

Confidential,Dallas, TX Oct 2008 – Dec 2010
SAS Developer

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

Responsibilities:

• Understand and update the existing code or create new code by using BASE/SAS, SAS/MACROS and SAS/SQL to implement new requirements.
• Get the Production the SAS code and analyze.
• 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.
• Performed data integrity checks and data cleaning using SAS MACROS and data steps, created HTML outputs with table of contents using ODS HTML.
• 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.
• 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 and Windows XP.

Confidential,India Jul 2005 – Sep 2008
Senior SAS Developer

Worked for Commercial Mortgage Analytics 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.
• 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.
• 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.