Hemavathi Palanisamy

+1-636-***-****

addri8@r.postjobfree.com

Professional Summary:

Around 6 years of IT experience in the Development, Testing, Implementation and Production Support. Good exposure to SAS (SAS Macros, SAS SQL) and JCL.

Strong communicator and team player with very good inter-personal skills. Quick learner with the ability to make solutions-oriented, creative and innovative contributions in highly demanding situations. Has experience working with large organizations.

Experience on working with SAS under UNIX platform and Mainframe environment.

Combined experience in Software Development Life Cycle and Business / System Analysis: experienced in gathering user requirements, documenting requirements, technical writing, business analysis, system analysis, testing, and implementation of projects.

Proficient in software documentation, business report and technical report writing, documenting processes and procedures during the entire project development life cycle.

Experienced in generating listing, summary and HTML reports using SAS technologies.

Expertise in SAS/Base, SAS/Macro, SAS/SQL, SAS/Graph, SAS/Stat, SAS/ODS.

Excellent Business Intelligence skill in Retail and Health care domain.

Ability to handle pressure and meet deadlines coordinating multiple tasks in project environment.

Ability to adapt to new technology and learn quickly to deliver quality product on time.

Technical Skills:

Environment: Windows 95/98/2000/XP, MS-DOS, Unix, Mainframe

Programming Methodologies: SAS, SQL, JCL

Tools and Utilities: SAS 9.1.3, SAS/BASE, SAS/MACRO, SAS/SQL, ODS, SAS/GRAPH, SAS/ACCESS

Databases: DB2, SQL 2000/2005, Oracle 9i.

Education:

B.E. (Computer Science and Engineering) - Anna University, Chennai, India.

Work Experience:

United Health Group, USA

Mar 2013 – June 2014

Lead – Design and Development.

OH_HCII & Custom Solutions ETL – ICUE Reporting Project

OptumHealth Care Solutions provides personalized health management support and services for more than 40 million Americans. Services include holistic wellness and discount programs, customized portal options, decision support, disease solutions, complex medical condition support, case and utilization management programs and physical health programs.

ICUE also known as the Integrated Clinical User Experience, is a collection of tools and capabilities used by the UHG internal clinical staff which provides a consistent, intuitive, and flexible Integrated Clinical User Experience in the delivery of the services for members across UHG Segments, Programs and Products.

Roles & Responsibilities:

Project Planning and Monitoring

Requirements gathering, analysis and High-level solution

Developing codes based on the mapping and requirement document

Analyzing and working on the review comments

Coordinate and Communicate with the Client on the issues being face and providing appropriate solution

Providing daily status to Client

Doing peer review

Resolving Issues/Disputes

Regular feedback to the team members

Regular customer interaction on various business process improvements

Regular communication with clients on various aspects

Training and Mentoring of the team members

Technology: SAS 9.2, Oracle 9i

United Health Group, USA

Nov 2012 – Feb 2013

Technical Developer

OH_HCII & Custom Solutions ETL – CRDM

OptumHealth Care Solutions provides personalized health management support and services for more than 40 million Americans. Services include holistic wellness and discount programs, customized portal options, decision support, disease solutions, complex medical condition support, case and utilization management programs and physical health programs.

CRDM also known as the Customer Reporting Data Mart, in which automated the CRDM programs to start executing the process automatically once the input file is received from the client.

Roles & Responsibilities:

Gather requirements from Client sponsor and create analysis artifacts.

Create the design document with Visio Diagrams based on the given requirement.

Create the data model.

Create comprehensive test plan and test case for various test scenarios to make sure that the code is tested for quality which meets client requirement

Populate the sample data for testing in Oracle database.

Worked on the predecessor and successor job execution module.

Technology: SAS 9.2, Oracle 9i

Walt Disney, USA

Mar 2012 – Oct 2012

Technical Developer

HRIS Interface Implementation

HRIS (Human Resource Information System) Interface is the most important interface for the client. This project is done to get Person Indicative, Employment, Organizational, Address and Salary data on daily basis and insert the same into DB2 tables for record keeping, Payroll processing and other data processing.

Roles & Responsibilities:

Requirement gathering from Client sponsor and create analysis artifacts.

Create comprehensive test plan and test cases for various test scenarios to make sure that the code is tested for quality which meets client requirement.

Split the project in to modules and create blueprint and assign the work to team.

Migrate the code to Production and schedule jobs in Control-M to run on specified time of a day.

Keep track of the entire project by doing periodic review of work done by my team to make sure that the project is completed well before the deadline.

Coordination with On-site & Offshore during implementation & issue resolution

Relational and Dimensional data modeling.

Provide GO live support

Technology: Base SAS 9.2, JCL, DB2, SQL, File-Aid, Endeavor

Walt Disney, USA

Dec 2009 – Jan 2012

Lead Developer - Design and Development.

Converting 3x to 4x

The objective of this project is version migration of existing client application from 3x to 4x. This included the data conversion and defining many interfaces for the Client. The main benefits of converting 3x to 4x are fewer procedures to set up, fewer jobs to run, more efficient use of CPU and provisions do not need to be loaded multiple times.

Roles & Responsibilities:

Involved in coding batch jobs using SQL, SAS and JCL.

Involved in creating AQUA’s for inserting the data from 3x tables to 4x tables.

Design Documentation Source to Target Mapping.

Code migration from 3x to 4x.

Validating Every day data migration from 3x to 4x.

Carried out Integration testing and recorded testing results in test plan.

Documented project related artifacts and send them for On-site review and store them in the Project database.

Scheduled jobs in Control-M to run on specified time of a day.

Technology: Base SAS 9.1.2, JCL, DB2, SQL, File-Aid, Endeavor

McKesson Corporation, USA

Dec 2008 – Oct 2009

Technical Developer –Design and Development focus.

Life Insurance Carrier Changes (Inbound/Outbound)

This project deals with loading of incoming file from client to ADB2 and to generate the incremental file with the content of differences from the current and previous file.

Roles & Responsibilities:

Involved in requirements hand off meetings.

Prepared analysis document to carry out coding.

Created test plan and test cases for various test scenarios to make sure that the code is tested for quality.

Created EFT requests to setup EFT between Hewitt and Client for transfer of conversion files.

Reviewed the code to make sure that the analysis is translated in to code and reviewed completed test plan to make sure that a reliable testing has be done.

Verified production files and transferred the files to client via EFT.

Technology: Base SAS 9.1.3, JCL, DB2, SQL, File-Aid, Endeavor

Contact this candidate