SUMMARY

• Over 7.8 years of professional IT experience in software development with focus on design, development, maintenance and enhancement.
• Involved in every phase of Software Development Life Cycle (SDLC) process in the areas of Analysis, Design, Development, Implementation and Testing of Software Applications.
• Proven ability to draw upon experience gained in Healthcare domain to utilize formal software development methodologies and best practices.
• Over 6 years of experience on system in a large Health care provider.
• Have worked extensively on designing, consulting and implementing for the California system in multiple projects.
• Have worked extensively on the Sales and Marketing Information EOCs for new and existing members. Generating reports with all the Healthcare information from different sources.
• Expert in extracting the analysis reports from large data sources with millions of records.
• Experience in generating reports for forecasting and prediction.
• Extensive exposure to advance SAS Programming, merging SAS Datasets, Macro Facility, Producing Reports, SAS Formats and Informants, SAS Functions, Sorting and Managing Data in SAS Datasets.
• Experience in Agile development (Scrum) methodology.
• Excellent skills with PROC TABULATE, SAS Arrays, SAS Base procedures, summary procedures and especially Data Step programming and reporting.
• Experience in PROC SQL joins and PROC SQL set operators to combine tables horizontally and vertically.
• Experience in writing complex programs and debugging.
• Experience in data analysis using PROC UNIVARIATE and list pull requests as per the requirement.
• Worked on SAS SQL Pass - Through facility to connect to databases like DB2 and TERADATA.
• Knowledge on Business Intelligence tools like TABLEAU.
• Over 6 years of experience working in an on-site-offshore team model. 3 year of experience in effectively leading the team and delivering set objectives.
• Have received many appreciations for my quick turn around on any request along with defect free deliverables.
• Communicate effectively with management; quality oriented and performance driven nature with strong technical problem solving skills.
• Strong Problem Resolution Skills, Excellent interpersonal and communication (written and verbal) skills.
• Can learn and adapt quickly to the emerging new technologies/software.

TECHNICAL SKILLS

Languages: SAS, SQL, COBOL, JCL, C, C++, VB Script, HTML

Platforms: Windows, UNIX, OS 390, LINUX

Database: IBM DB2, VSAM, SQL Server, Oracle server, Teradata

SAS Tools: BASE/SAS, SAS/MACROS, SAS/ACCESS, SAS/ODS, SAS/CONNECT, SAS/GRAPH, SAS SCL, Windows SAS and SAS EG

Other Tools: DB Visualizer, SQL Developer, Remedy, SPUFI, FILE-AID, QMF, CA7FileZilla, TOAD, NDM, FTP, SFTP SQL Server Management Studio

Business Domain: Health Care, Finance

PROFESSIONAL EXPERIENCE

Confidential

Senior Programmer Analyst

Responsibilities:

• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
• Captured and analyzed business process requirements from the business team.
• Involved in phases such as Designing (preparation of Functional Specification Document), development and review of components (Batch Programs, Schedules, jobs and reports) as per the analysis.
• Generating forecasting reports for Actuarial and Underwriting departments.
• Created Technical Design documents for new updates, test plans for unit testing and detailed process flow of complex SAS reporting processes.
• Generated detailed Open Enrollment Reports tracking sales and member enrollment during Open Enrollment Period.
• Used various procedures like PROC FREQ, PROC TRANSPOSE, PROC MEAN, PROC PRINT, and PROC REPORT to analyze and generate different kinds of reports.
• Performed Data analysis to find and resolve any data discrepancy issues.
• Performed data manipulation and joining/merging data from multiple sources.
• Extensively used HASH table technique for table look up.
• Automated processes that require least manual intervention.
• Verified deliverables from my team and ensure defect free deliverables to the end users.
• Monitor the production jobs and fix the abends within the SLA.
• Organized and facilitated application transitions to new joiners in the team.
• Presented Monthly Governance Report of my team to Customers.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/CONNECT, SAS/ACCESS, SAS/ODS, Windows SAS, IBM DB2 - SQL, Oracle SQL, SQL Server, COBOL, JCL, SPUFI, FILE-AID, QMF, UJT, SYNCSORT, MVS, MS-Windows XP, Microsoft Excel, Word, PowerPoint.

Confidential

Programmer Analyst

Responsibilities:

• Produced SAS datasets, flat files, and reports for various departments.
• Developed, tested, and debugged SAS programs for formatting and analyzing.
• Performed SAS Data management using SAS functions like FORMATS, INFORMATS, SET, MERGE, SCAN, SUBSTR, SUM, INTCK and INTNX.
• Used Data null and PROC REPORT to generate the outputs.
• Generated reports and converted these reports to client required reporting format like html, pdf and excel using SAS ODS.
• Worked closely with Statisticians and Data managers.
• Generated the List outputs for Marketing Teams that have the list of customers to target as part of Campaigning.
• Created SAS datasets from the flat files which are frequently used to reduce the access time as part of Process improvement.
• Developed programs independently and review/QA other developers programs.
• Worked/coordinated with various teams to deliver reports/data on time.
• Involved in problem solving, data analysis, and complex report generations.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/CONNECT, SAS/ACCESS, IBM DB2 - SQL, Oracle SQL, SQL Server, COBOL, SYNCSORT, JCL, SPUFI, QMF, MS-Windows XP,UNIX, MS-Office, Microsoft Excel, Word, PowerPoint.

Confidential

Quality Analyst

Responsibilities:

• Studying the Business and Functional requirements specification documents andidentifying Test scenarios for the GeoMedia Product.
• Planning testing activities to ensure delivery of test objectives within the outlined timeline.
• Extensively performed critical path analysis to prioritize the test scripts execution based on the magnitude of associated functionality.
• Prepared test scripts for the new functionalities undergoing change/being introduced, ensuring all the aspects of the change is documented.
• Executed Test Scripts, ensuring all aspects of the pertinent functionality undergoing change is translated without adversely impacting the existing functionality
• Interacted with the developers to report the bugs and their impacts.
• Written new scripts for the features added in the GIS product in VBScript.
• Performed requirement gap analysis and Causal analysis of post-production defects.

Environment: GeoMedia product, Automation tool VBScript, Microsoft Windows XP, MS-Office.