Summary

• 6 plus Years of Industry Experience in using SAS for Data Management and reporting in financial , logistic and medical domain.
• Have implementation projects from Technical side and also have worked with the clients to gather requirements.
• Strong Project coordination including strategic planning, trend analysis, forecasting, variance analysis, database management.
• 100 Project completion on time while meeting strict timelines and budget requirements.
• Core SAS Programmer with experience in SAS tools like Base/SAS, SAS/Macros, SAS/SQL, and SAS/ODS.
• Extensive SAS programming experience in Design, Development, Implementations, Testing, Support, Maintenance Upgrade or Promote and Migration of SAS Application.
• Exceptional ability in problem solving, data analysis, complex reports generation with macro and data transfer between different environments.
• Expertise in transforming data imported from disparate data sources into analysis data structures, using SAS functions, options, ODS, array processing and storing and managing data in SAS data files.
• Experience in Share point and Microsoft Office tools like MS Word, MS PowerPoint, and MS Excel etc.
• Experience in cleaning and resolving data issues as well as merging data from different sources into a single integrated dataset.
• Excellent problem solving skills for delivering useful and compact solutions.
• Always keen and eager to face up to challenges by means of innovative ideas.
• Motivate supportive, cooperative and a quick-learner. Strong communication skills and ability to work well in a team.
• Quick learner with ability to understand job requirements employs new ideas, concepts, methods, and technologies.
• Strong Knowledge on writing and modifying the SAS Macros.
• Developing SQL queries to generate daily, weekly, monthly and quarterly reports and used SAS Macros to and system options to automate the process

TECHNICAL SKILLS:

• SAS Tools: BASE/SAS v8.0 v9.1, SAS/STAT, SAS/MACRO, SAS/GRAPH, SAS/ODS, SAS/AF, SAS/ACCESS, SAS/Connect, SAS/Enterprise Guide, SAS/ETL.
• Programming Languages: SQL, PL/SQL.
• RDBMS : Oracle , DB2,Teradata.
• Operating Systems: Windows, UNIX, Mainframes.

Professional Experience:

Confidential

Role: Sr.SAS Programmer/ Analyst

Roles Responsibilities:

• Supporting Marketing Campaigns for consumer cards and Small Business Services.
• Customer Segmentation and Targeting likely responders for profitable campaigns
• Slice/ Dice Complex data with SAS macro/ SQL and Advance Excel Techniques and develop Customer Statement for various LOB depicting overall performance of departments handling the respective projects.
• Analyze Requirements, system development Testing for New Automation capabilities
• Continuously looking for areas for improvement in existing system.
• Mean and Standard deviation for all continuous variables using Proc Means.
• Created data sets by using BASE SAS and SAS macro's in large SAS databases.
• Data Collected using time study techniques for in-depth quantitative and qualitative analysis.
• Fulfillment of production tables, export/ import survey data from vendor using SAS flat files.
• Provided business logic by understanding the SAS program code and vice versa.
• Performed data validation using SAS procedures to ensure data quality and consistency.
• Maintained and enhanced existing SAS reporting programs.
• Performed documentation of the SAS Code for the better understanding of the program.
• Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall strategies.

Environment: SAS, BASE/SAS, SAS/MACRO, SAS/SQL, SAS/ODS, Mainframes and Windows 2003/XP.

Confidential

Role: Sr.SAS Programmer/ Analyst

Roles Responsibilities:

• Study of Client requirements and draft them into system specific requirements.
• Worked closely with project managers, statisticians, database management personnel and other associated members of the team.
• Responsible for data cleaning, data validation, identification and resolving any data inconsistencies and discrepancies to standardize the data.
• Extracted data from different sources like Teradata, Excel and test files using SAS Access facility and SQL scripts Interface and Reports and providing the status to PM on weekly basis.
• Reviewing the milestone dates with the client as when the UAT will be done.
• Modified and developed SAS reporting programs for marketing campaigns to meet business requirements and created mail lists for direct mailing.
• Developed SQL queries to generate daily, weekly, monthly and quarterly reports and used SAS Macros to and system options to automate the process
• Creating programs implementing various logics involved behind data loading, client reporting, and data manipulations using SAS 9.0 programming language.
• Planned, designed and developed test plans, scenarios and test cases, and ensured traceability between test cases and business requirements and technical specifications.
• Continuously looking for areas for improvement in existing system.
• Giving the Quality Sign off on the reports.
• Reviewing analysis and test plan documentation for complex interfaces
• Efficiently wrote SAS Macros and used company macros for daily programming

Environment: SAS, BASE/SAS, SAS/MACRO, SAS/SQL, SAS/ODS, Oracle, Teradeta, UNIX, and Windows 2003/XP.

Confidential

Role: Data Analyst

Roles Responsibilities

• Reviewed existing literature on Medicare, Medicaid and models dealing with Medicaid fraud
• Attended various seminar presentations on Medicaid fraud such as finding duplicate claims, service after death, multiple service providers etc.
• Modified existing SAS programs for facilitating migration from Mainframes to Oracle data engine.
• Used SAS/ASSIST to extract data from SAS Files and Oracle Data base.
• Involved in writing code using Base SAS SAS/Macros to clean and validate data from oracle tables and conducted data investigation
• Involved in Data mining using Enterprise Miner for various health care datasets such as Eligibility, Inpatient, Outpatient, Long Term Care and Pharmacy Rx .
• Involved in developing various fraud algorithms and validated existing algorithms against specification
• Generated formats using PROC FORMAT for frequently used variables such as CPT Current procedural terminology , HCPC, DRG Diagnosis related group , Program type, type of claim, type of service, diagnosis code, Adjustment Indicator etc.
• Used SAS import procedure to generate temporary and permanent SAS data sets from txt, csv and excel data sets.
• Created various Graphs using SAS/GRAPH, SAS/GPLOT and SAS/INSIGHT.
• Validating data and creating reports using different procedures like PROC FREQ, PROC MEANS, PROC TRANSPOSE, PROC DATASETS, PROC SORT, PROC COMPARE, PROC SQL, PROC REPORT etc. and SAS ODS facility.
• Extensively used statistical procedures and predictive modeling techniques such as ANOVA, Regression Analysis, Trend Analysis, Cluster Analysis and Principle Component Analysis.
• Conducted QA for macros generated by other programmers using Macro options MLOGIC, SYMBOLGEN, MPRINT, MACROGEN etc.
• Performed documentation of the SAS Code for the better understanding of the program.

Environment: Base SAS, SAS Macros, SAS/Access, SAS/ASSIST, SAS/STAT, SAS/GRAPH, SAS/IML, Enterprise Miner, ORACLE, Main Frames, Excel, Windows XP, UNIX.