SUMMARY

• Certified Base & Advanced SAS Professional with 8 years of working experience in HealthCare, financial, insurance and Pharmaceutical industries.
• Have extensive experience in SAS programming on different platforms - Windows and UNIX , also having worked in updating, data extraction, transformation and loading to data warehouse, data analysis, updating, testing and data validation.
• Ability to turn business requirements into Technical Design specifications and documents, SAS Programs, and SQL Queries related to quantitative, statistical and financial models.  Capable of working with cross-functional teams to manage projects, determine prioritization, and create appropriate timelines. 
• Experience in Data analysis and Reporting in health care, finance and marketing sectors. SAS experience includes detailed knowledge of statistical analysis of financial and health care data and in the production of reports and tables.
• Primarily worked on Predictive modelling in financial and Medicare and Medicaid in HealthCare
• Experience in SAS/BASE,SAS/EG, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ACCESS, and SAS/CONNECT in UNIX and Windows environments.
• Developed new or modified existing SAS programs to load data from the source and create specific datasets.
• Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting .
• Performed data analysis on the datasets using PROC PRINT, PROC SORT, PROC TRANSPOSE, PROC MEANS, PROC SUMMARY, PROC TABULATE, PROC UNIVARIATE AND PROC FREQ .
• Experience in performing ad hoc queries for various application and reports on a daily/weekly or monthly basis.
• Performed Data management like Merging, concatenating, interleaving of SAS datasets using MERGE,UNION and SET statements in DATA step and PROC SQL.
• Experience in using SAS to read, write, import and export to another data file formats including delimited files, spreadsheet, Microsoft excel and access tables.
• Worked closely with Business users in gathering the requirements for project documentation and generated reports. Involved in all stages of SDLC (Software Development Life Cycle).
• Ability to work in self-directed environment and very good team player with excellent analytical and problem solving skills
• Worked extensively with SAS on UNIX, Windows and Mainframes, SAS Enterprise Guide, PC-SAS.
• Professional Experience with Import Various External Data Files into SAS Dataset, working with large datasets and business applications by Using SAS/ACCESS, SAS/INFILE, SAS/IMPORT, SAS/SQL.
• Extensively worked on various RDBMS like Oracle and SQL Server
• Extensive Experience in arranging and participating in meetings with Business Users, Managers and suggesting recommendations for improving system performance.
• Worked in Production support, Development, Technical project requests, Enhancement, implementation support, post-production batch monitoring and Client issues for all supported applications.
• Develop project plan, work-breakdown-structure, metrics, tasks lists, action items, Identify critical paths. Understand and define priorities and milestones.
• Proven skills in efficient processing of millions of records of data, optimizing SAS programs for better performance. ETL process design, Analyzing, Reporting and migrating Data from multiple platforms/databases using SAS,NDM and SFTP. Statistical distributions and calculations.
• Thorough Knowledge and experience in Microsoft Office tools like MS Access, MS SharePoint, MS word, MS PowerPoint, MS Excel.
• Excellent working experience in tools such as INFOMAN, Maestro, Autosys, Resolve IT and ServiseNow.
• Involved in different server setups for new projects and accessing destination servers on various operating systems such as Unix, Windows and Mainframes.
• Have knowledge on HADOOP-HDFS, PIG, SQOOP, HIVE,HBASE and MapReduce.

TECHNICAL PROFILE:

Operating Systems: Windows 2007, MS-DOS, UNIX

SAS Tools: Base SAS, SAS/SQL, SAS/STAT, SAS/MACRO, SAS/GRAPH, SAS/ODS, SAS/ACCESS, SAS/Connect, SAS/Enterprise Guide.

Programming Languages: SQL,PL-SQL C, JAVA,SQOOP,HIVE,MAPREDUCE,PIG

Database: Teradata, DB2, Oracle, MS Access, SQL server, HADOOP and Sybase.

Application Software: MS Office (Word, Excel, Power Point, Access).

Scheduling tools: Maestro, Autosys

Special Software: Infoman, Resove IT, Autosys(Work Load Center) and ServiseNow

Domains: Banking, Insurance, Health Care and Pharmaceutical

CAREER PROFILE

Confidential

Sr.SAS Developer

Activities

• The main responsibilities in this position are to enable process and trend analysis and provide recommendations for the implementation of new/revised operational and/or reporting processes in Ohio, Kentucky and Indiana.
• Involved in requirements gathering, Estimation of Efforts,Coding Unit testing, RFC Creation, Cert Implementation and Production move.
• Classification of reports based on Carsource Advantage Model of Care which involves Enrolment, member, claims, finance, marketing, pharmacy, provider, service operations, authorization regulatory and utilities.
• Preparation of batch jobs, parameter files, log files, SAS jobs such as control, preparation, formatting, PULL, ETL and Report generation.
• Developed new or modified SAS programs and used SQL Pass through facility and Libname methods to extract data from the Teradata and SQL Server DBs and created study specific SAS datasets, which are used as source datasets for report generating programs.
• Made recommendations on new automation opportunities and ways to enhance existing automation tools.
• Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation..
• Generated customized reports using SAS/MACRO facility, PROC REPORT, PROC TABULATE and PROC SQL.
• Converted existing SAS code into high quality SAS code that is efficient (fast), automated, maintainable, and follows industry best practices.
• Created SAS Datasets with the usage of SAS MACRO, Macro Variables, CALL SYMPUT.
• Developed ad-hoc reports using SQL Pass through, libname Statements and PROC SQL to interact with different RDBMS like Teradata and SQL server.
• Analyzed data using PROC FREQ, PROC MEANS, PROC Transpose and proc univariate to effectively and efficiently coordinate quality activities and improve performance metrics of organizational goals.
• Extensively used ODS HTML, ODS PDF, ODS RTF to prepare, compile, review and submit monthly and quarterly reports for quality committee meetings.
• Used SVN tool to commit the new codes for prod implementation.
• Creation of RFC’s with Implementation document with tagging of new and backout code, test case document and attending cab review meetings to explain the impact of new implementation.
• Preparation of detailed design and code change document for future reference.

Technical Platform

Operating system: Windows 7

Languages/Tools: SAS/Base 9.3, SAS/EG 5.1,

Database: Oracle, SQL Server and Teradata

Tools: Tidal scheduler, SVN, Windows batch

Confidential

Project Leader

Activities

• Involved in requirements gathering & Estimation of Efforts.
• Design Preparation.
• Interact with assigned business analysts and project managers to perform work outlined
• Assigning the projects to the team based on capacity.
• Follow-up with the team and making sure the work done on time.
• Successfully completed more than 20 development projects.
• Developed SAS code and SQL’s for Data Extraction and Loading into flat files.
• Reviewing Unit Test cases to make sure testing is done properly.
• Conducting Final Inspection & Audit.
• Working with large datasets and business applications
• Regular Status meetings with the clients and TCS Managers on the progress of tasks.
• Sharing of Knowledge with the team members.
• Tracking and updating the project status by using the CCLM repository.

Technical Platform

Operating system: Windows Server 2000/ UNIX

Languages/Tools: SAS, UNIX, NDM, SFTP, SSH Tectia, Infoman, Maestro, Autosys and Resolve IT.

Database: Oracle, SQL Server

Location: IRVING,TX,U.S.A

Confidential

Team Lead

Activities

• Involved in presenting induction to the new joiners in the project
• Worked as primary point of contact for all the Production support jobs
• Resolved all the abends on time and achieved the customer confidence
• Developed SAS code and SQL’s for Data Extraction and Loading into flat files.
• Regular Status meetings with the clients and TCS Managers on the progress of tasks.
• Automating the Job failures/alerts notification process by using the UNIX Scripting.
• Resolved the abends as soon as received a call from command center.

Technical Platform

Operating system: Windows Server 2000/ UNIX

Languages/Tools: SAS, UNIX, NDM, SFTP, SSH Tectia, Infoman, Maestro, Autosys and Resolve IT.

Database: Oracle, SQL Server

Location: IRVING,TX,U.S.A

Confidential

Team Member

Activities

• Requirement Analysis
• Create and review the design documents (both HLD and LLD)
• Development and Coding
• Test script Preparation
• Unit and System Testing
• Reviewing and Delivering
• Bug Fixing
• Conducting Final Inspection & Audit
• Sharing of Knowledge with the team members
• Regular Status meetings with the clients and TCS Managers on the progress of tasks.
• Published the knowledge based documents into Knowmax.
• Published code snippets in Mighty for automation which avoids re-work.
• Prepared implementation Documents for Production implementation by Maestro Team.

Technical Platform

Operating system: Windows Server 2000/ UNIX

Languages/Tools: SAS, UNIX, NDM, SFTP, SSH Tectia, Infoman, Maestro, Autosys and Resolve IT.

Database: Oracle, SQL Server

Location:  Chennai, India