DEEPA BALAKRISHNAN abi0x0@r.postjobfree.com

949-***-****

PROFILE

IT professional with 7+ years of experience in designing developing and

implementing software applications on Informatica, SQL, PL/SQL and

Mainframe. Solid experience in Health care and retail domain. Strong

analytical and debugging skills.

SKILLS SUMMARY

Languages: SQL, PL/SQL, Unix Shell Scripting, COBOL, JCL,

Dylacore, PC-SAS, SAS

Databases: DB2, IMSDB/DC, Oracle 8i/9i/10g/11g, MySQL, Teradata

ETL: Informatica Power Center 8.6.1 (Repository manager,

Designer, Workflow manager, Workflow monitor)

Tools: Toad, Teradata SQL assistant, MS-Visio, MS access, MS

Power point, ChangeMan, Endevor, Xpediter, FileAid,

AbendAid, TraceMaster, QMF, Tablebase, Visual InterDev,

Visual Source Safe

Operating Windows 98/NT/2000/XP, UNIX, Z/OS, OS/390

Systems:

Also familiar Rexx, CICS, ASP, HTML, VB, Java Script

with:

EDUCATION

Bachelor of Technology from MG University, Kerala, India (in 2001)

CERTIFICATIONS

Oracle Pl/Sql Developer Certified Associate (OCA)

IBM Certified Database Associate -- DB2 Universal Database V8.1 Family

PAHM (Professional, Academy for Healthcare Management)

EXPERIENCE HIGHLIGHTS

Wellpoint Inc, Mason, OH July 2007

-present

Associate Consultant

Implemented various processes like reformat, scrub and load prior

authorization files, accumulator commingle file feeds, eligibility data and

crosswalk file feeds, finance feeds as part of the ongoing New client

Implementation project.

. Requirement gathering, data analysis to validate assumptions, documenting

technical requirements, Estimation

. Create process flow diagrams, mapping specification for complex mappings,

workflow designs

. Generic converter: Designed and created prototype in informatica to

convert any incoming flat file layout to the standard load layout

. Coding, Unit and Integration testing of mappings to transform extracted

data according to multiple rules for different variations of key fields

. Scheduling workflows with triggers and even wait tasks

. Accumulator commingle interface design: Provided modularized mapping

designs for a complicated batch interface.

. Extensive use of transformations (Expression, filter, router, joiner,

sorter, lookup, aggregator and normalizer) to apply the business rules

according to the technical design

. Apply ETL strategy to extract data from Oracle/Mainframe/Teradata sources

to generate feeds, data load files and reports.

. Analyze and identify options for performance improvement, testing and

tuning for optimizing workflow performance (studying performance details

from run logs, optimizing cache use, adjusting buffer size, applying

partitioning to source / targets)

. Debug Using informatica debugger, Source and target test data analysis,

Issue resolutions

. Preparation of implementation plan, CCR documentation

. On call support for workflows implemented, Break fix execution for

emergency business functions.

Software Used:

Informatica Power Center 8.6.1, Toad, Teradata SQL assistant, MS Visio,

Oracle 10g/11g, MySQL, PC-SAS, MS Access

Wellpoint Inc, West Hills, California Feb 2006

- June 2007

Systems Analyst

Requirement gathering, impact analysis, technical design and development of

online screens, and enhancement and performance tuning of batch jobs for

CIRS integration and client migration project for Wellpoint Pharmacy.

. Requirement gathering, Analysis and Estimation

. Eligibility Recon Performance improvements: Identified functional and

technical areas of process improvement and applied necessary

modifications to successfully improve performance of 6 workflows.

. Performance testing and tuning for SQLs (using explain plans to optimize

queries, using primary keys, indexes and hints, use joiners instead vs

sub-queries etc)

. Technical design of jobs and procedures to standardize existing migration

process

. Development of IMS-DC screens to enable user to enter member information.

Enhance letter generation and ID card generation processes to use data

entered by the user

. Load data to DB2 security tables to set appropriate RACF screen

privileges for all users

. Enhancement of daily eligibility feed components (JCLs and PROCs) to

comply to the HIPAA

. CIRS impacts on letter generation: Tested UI and associated batch

components and acquired hands on knowledge on the entire letter

generation and printing process

. Data analysis and Debugging using XPeditor

. Prepare of Go Live plan, implementation plan and service center request

for change tickets

. Study, analyze, document and maintain AIMBAR codes on the letter

generation components

. Issue resolutions and Project implementation

. Production support, track, record and report production runs and status

Software Used:

Z/OS, OS/390, COBOL, JCL, Oracle 9i, PC-SAS, Endevor, IMSDB/DC, DB2,

ChangeMan, QMF, Informatica Power Center 8.6.1, Toad

UST Global, Thiruvananthapuram, Kerala, India (Wellpoint Inc) May 2004 -

Jan 2006

Senior Software Engineer

Analyzed, developed and implemented online claim transaction programs and

batch jobs on mainframe for projects under pharmacy systems department of

Wellpoint Inc. Medicare Part-D, Pharmacy Claims System Integration and

Benefit Repository Revitalization are the projects I worked on.

. Analyze and design for Medicare Best Coverage requirement

. Built Best coverage logic for Medicare Part D: A very complex logic built

on the Online adjudication program to incorporate Medicare best coverage

business rule. This was accomplished with the help of data extraction and

processing using complex IMS-DB calls

. BTS testing of claims with the enhanced online adjudication COBOL program

. Regression Testing and Mismatch analysis for the changes done as part of

Medicare Best coverage logic

. Creation of Data Capture Tool for extracting and comparing table-base

data

. Lead the Analysis team on Batch cycle jobs analysis

. Analysis and preparation of reference document for DUR (Drug Utilization

& Review) processing in the adjudication system

. Analysis of existing Cobol programs to capture the requirements for the

components that are to be converted to the new System

. Low level Design, Review, Coding, Testing and debugging of new Cobol

programs and Stored Procedures

. Lead Testing Team, to test new components that are created

. Prepare Regression Test Plan, test cases for testing the new components

. Pilot RuleSet Release process for migrating clients to the New System

. Performance tuning of the New Benefit Repository Adjudication system.

. Modifying existing Programs, Stored Procedures and regression testing of

the same as part of Performance Tuning

. Creation of maintenance utilities for loading the DB2 tables with data

for new Clients to be configured in the New Adjudication System

. Configuration Control activities on the project related artifacts

Software Used:

Z/OS, COBOL, JCL, IMSDB, chgman, DB2, VSS, REXX, QMF

UST Global, Thiruvananthapuram, Kerala, India (Ahold) Jan

2003 - Apr 2004

Software Engineer

Developed and maintained various software applications for Ahold as part of

merchandising system migration from IDMS-ADSO to CICS-DB2 for one of their

operating companies. Enhanced and automated the PMTool used for automatic

task allocation, effort capture and metrics calculations within the

project. Deployed Enterprise version of PMTool in the company.

. Low level Design, Coding of CICS online screens and batch jobs

. Test plan preparation based on specs provided by the client

. Low level Testing and debugging of online screens and batch jobs

. Design, Coding, Testing and Deployment of ASP pages for new functions in

PMTool

. Analysis for Query Optimization

. Conducting Demo of the PMTool to the Account members

. Testing, Deployment and Production support of the PMTool for individual

Accounts

. Testing of Admin pages and customization for the Enterprise Version of

the Tool

Software Used:

OS390, CICS, Rexx, ASP, JavaScript, Oracle 8i, MySQL

Contact this candidate