SUMMARY

• Certified Base & Advanced SAS Professional wif 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 toquantitative, statistical andfinancial models. Capable of working wif 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 noledge of statistical analysis of financial and health care data and in teh 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 teh 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 teh 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 wif Business users in gathering teh 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 wif excellent analytical and problem solving skills
• Worked extensively wif SAS on UNIX, Windows and Mainframes, SAS Enterprise Guide, PC-SAS.
• Professional Experience wif Import Various External Data Files into SAS Dataset, working wif 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 wif 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 forbetter 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 noledge on HADOOP-HDFS, PIG, SQOOP, HIVE,HBASE and MapReduce.

TECHNICAL SKILLS

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

PROFESSIONAL EXPERIENCE

Confidential

Sr.SAS Developer

Responsibilities:

• Teh main responsibilities in this position are to enable process and trend analysis and provide recommendations forthe 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 teh 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 existingSAScode into high qualitySAScode dat is efficient (fast), automated, maintainable, and follows industry best practices.
• Created SAS Datasets wif teh usage of SAS MACRO, Macro Variables, CALL SYMPUT.
• Developed ad-hoc reports using SQL Pass through, libname Statements and PROC SQL to interact wif different RDBMS like Teradata and SQL server.
• Analyzed data using PROC FREQ, PROC MEANS, PROC Transpose and proc univariate to TEMPeffectively 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 teh new codes for prod implementation.
• Creation of RFC’s wif Implementation document wif tagging of new and backout code, test case document and attending cab review meetings to explain teh impact of new implementation.
• Preparation of detailed design and code change document for future reference.

Confidential

Project Leader

Responsibilities:

• Involved in requirements gathering & Estimation of Efforts.
• Design Preparation.
• Interact wif assigned business analysts and project managers to perform work outlined
• Assigning teh projects to teh team based on capacity.
• Follow-up wif teh team and making sure teh work done on time.
• Successfully completed more TEMPthan 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 wif large datasets and business applications
• Regular Status meetings wif teh clients and TCS Managers on teh progress of tasks.
• Sharing of Knowledge wif teh team members.
• Tracking and updating teh project status by using teh CCLM repository.

Confidential, IRVING,TX

Team Lead

Responsibilities:

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

Confidential

Team Member

Responsibilities:

• Requirement Analysis
• Create and review teh 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 wif teh team members
• Regular Status meetings wif teh clients and TCS Managers on teh progress of tasks.
• Published teh noledge based documents into Knowmax.
• Published code snippets in Mighty for automation which avoids re-work.
• Prepared implementation Documents for Production implementation by Maestro Team.

Confidential

Team Member

Responsibilities:

• Analyzing teh Business Requirements and System Specifications to understand teh application.
• Involved in presenting induction to teh new joiners in teh project
• Developed SAS code and SQL’s
• Automation of run book preparation for support related activities after implementation.
• Prepared implementation Documents.
• Involved in Creation and review of test Scenario and test Case based on requirement and design document
• Interacting wif onsite coordinators and clients.
• IQA & EQA activities in teh project and preparing defects log
• Customizing teh existed components to work for teh newly created
• Creation of New Jobs & Schedules for Info quest.
• Code fixing, testing, tracking all teh documentation and code through IPMS tool mapping and following teh standards defined in TCS-IQMS.
• Monitoring and fixing production jobs during batch run.
• Capturing of requirements for enhancement projects, coding,
• Unit testing and System testing of teh modules.

Confidential

Team Member

Responsibilities:

• Understanding and Capturing of requirements.
• Involved in teh preparation of high level/low level design documents.
• Involved in teh Analysis, Development and testing phases of teh project.
• Involved in Analyzing and providing teh resolution for teh bugs raised.
• Involved in teh Unit testing and User Acceptance Testing.
• Involved in teh Resolution of technical issues while testing.
• Production Support (Dedicated).
• Worked on Control-M tool for keeping teh system healthy and to make teh jobs of various environments to run as per teh schedule.
• Creating our own region for testing modelling teh UAT regions.
• Adherence to IQMS (Integrated Quality Management System) by
• Following quality procedures like IQA (Internal Quality Assurance).
• EQA (External Quality Assurance) and FI (Final Inspection) for all teh deliverables.
• Adherence to IPMS by entering efforts and logging defects.
• Adherence to SPEED by achieving goals periodically.

Confidential

Developer

Responsibilities:

• Analyzing teh Business Requirements to understand teh application.
• Prepared implementation Documents.
• IQA & EQA activities in teh project and preparing defects log
• Code fixing, testing, tracking all teh documentation and code through IPMS tool mapping and following teh standards defined in TCS-IQMS.
• Capturing of requirements for enhancement projects, coding,
• Unit testing and System testing of teh modules.