Software Engineer Project

PROFILE

Having *+ years of experience in IT Industry, which includes development, and

implementation of client server applications using Data warehousing tools like

Informatica 8,7.1,5.1 (Power Center/Power Mart) and Reporting tool like

MicroStrategy, Business Objects

Have good experience in data analysis and have suggested many enhancements

Have the ability to translate business requirements into functional

requirements and have worked with the end users/clients directly while doing

so.

Good working experience on Oracle9i/10g,DB2 databases,Unix,PL SQL and SQL

Have lead a team of 4 members in the most recent project

Extensive experience in Dimensional Data modeling using Star and Snow Flake

schema

Expertise in Telecom,Health Care and Insurance domains.

Well exposed to the Software Development Life cycle, Project Management,

Business Requirement Analysis, and Quality Process Adherence

Have done unit, system and regressing testing

Proven self-starter with results-oriented work ethic .Positive attitude with

readiness to learn continuously in this ever changing IT world

Good communication and team management skills .Excellent problem solving skill

Skill set

Data Warehousing

Informatica PowerMart/Power Center 8,7.1, 5.1, MicroStrategy

Languages

SQL,PL/SQL and good exposure in Unix & Perl

Operating Systems

Windows 98/NT/2000/XP, Linux

DBMS

Oracle 9i/10g,DB2,MS SQL Server 2000,Tera data

Other Tools

MS Office, MS Excel, MS Access, MS Powerpoint, MS project, Toad, AQT,

Hummingbird, Putty, Control M

Employement History

Name of the Company

Designation

From

(Mon-yyyy)

To

(Mon-yyyy)

Duration (Months)

Verizon Data Services Ltd

Software Engineer

Nov 2004

Oct 2006

23 Months

HCL Technologies

Software Engineer

Oct 2006

Jan2007

4 Months

Anthem Blue Cross Blue Shield

ETL Developer

Oct 2007

Jul 2009

21 months

EDUCATION & TRAINING

Title of the Degree with Branch

College/University

Year of Passing

Percentage

Bachelor of Engineering in Electronics & Communication

Madras University

2004

84

Higher Secondary Education

S.B.O.A Matriculation Higher Secondary School

2000

93.6

Secondary Education (CBSE)

S.B.O.A Matriculation Higher Secondary School

1998

88

PROFESSIONAL EXPERIENCE

ANTHEM BLUE CROSS BLUE SHIELD,ST lOUIS,MISSOURI Oct 2007 - Jul 2009

Project 1: West Enterprise Data Warehouse

Client Anthem Blue Cross Blue shield

Role System Analyst

Duration Oct 2007 - Jul 2009

Description WEDW is the West Enterprise Data Warehouse of Anthem/Well point

(Insurance).Persistent Data Store (PDS) tables stage the data

files from the source (Mainframes) and this in turn will become

source to the various EDW (Enterprise Data Warehouse) tables as

per the requirements / business logics. Informatica Mappings used

to load the data from the Source files to PDS staging tables and

from PDS to EDW target tables. UNIX shell scripts are used to run

the ETL workflows and run data validation on DB2 database (PDS &

EDW tables) and for other automation purposes

This is a Maintenance project and typical activities are

Production Support, debugging / fixing Production & data issues.

Debugging and fixing production issues involves data analysis. I

have taken the role of BA several times while fixing issues

raised by clients/end users. Technical work includes developing

new, modifying & analyzing the already existing Mappings and Work

flows in Informatica and Shell scripts in UNIX and writing DB2

queries. The Project Deals with Insurance transactions which

include Claiming of bills, Membership, Capitation, Provider &

Revenue.

Contribution Worked as an onsite coordinator and lead a team of 4 in offshore.

Responsible for requirements gathering and translated

requirements into business rules and made recommendations for

Warehouse Development

Designed the Functional Requirements and Mapping Technical

Specifications

Used Informatica 7.1/8 as an ETL tool to create source/target

definitions, mappings and sessions to extract, transform and load

data into staging tables and work and fact tables eventually.

Good experience on Unix and used Control M to schedule workflows.

Created/Modified Unix scripts to accommodate new changes and

wherever required

Have successfully implemented 6+ tasks assigned

Debugging and Troubleshooting Informatica Mappings and unix

scripts

Involved in Unit and system testing and have done regression

testing when required

Environment Informatica Power Center 7.1/8, DB2,Unix,AQT,Control M

HCL technologies ltd Oct 2006 - Jan 2007

Project 2: Merck USHH,LANSDALE,PA

Client Merck & Co

Role Software Engineer

Duration Oct 2006 - Jan 2007

Description USHH - Unites States Human Healthcare is a system meant for

Training and health programs . The reporting system provides

executives, senior managers and business analysts with access to

accurate and consolidated information. This is a Development,

Maintenance and Production support project which often requires

developing Informatica mappings and PL/SQL procedures

Contribution Enhancements were suggested and eventually applied to have a

smooth run on production

New mappings were created based on the requirement. Design of ETL

mappings using Informatica transformations like Lookup,Filter,

Aggregator, Router and Expression etc.

Have developed Pl/Sql procedures

Involved in unit testing

Solving production Issues

Bug fixing

Change request processing

Environment : Informatica Power Center 7.1,Oracle,Unix

VERIZON DATA SERVICES LTD Nov 2004 - Oct 2006

Project 3: Network Metric Platform

Client Verizon,Virginia

Team Size 70-75

Role Software Engineer

Duration Nov 2004 - Oct 2006

Description Telecom is a regulated business in USA and the genesis of the

project lies in the Central telecommunication Regulation act of

1996. This act opened the local telephone market for competition

giving rise to the competitive local exchange carriers (CLEC). The

bandwidth providers were mandated to provide service to these

smaller telecom service providers who would collect their

customers by offering discounts and use the bandwidth and services

provided by carriers. The FCC therefore asked the incumbent local

exchange carriers (ILECs) to produce metrics validating that the

CLECs were being provided same level of service as any other

customers of ILECs. The Network Metrics Platform (NMP) is an

initiative to bring this data on a central platform. This entails

extracting data from several existing systems feeding this data to

the data warehouse, building data marts to support the reporting

requirements, doing the number crunching and producing the

required reports.

Contribution PHASE 1: First level of transition of the ongoing projects from

our primary vendor Sapient to Verizon, India from Dec 2004 - Feb

2005 for network performance, Operator Services and General

Standards domains.

PHASE 2: Second level of transition of Ordering and Billing domain

from our primary vendor Sapient to Verizon, India from Apr 2005 -

May 2005.

Involved in development, testing and operations for different

domains like Ordering, Billing, Network performance and Operator

Services.

Developed new and maintained existing Informatica mappings and

workflows based on specifications.

Analyzed the business source data and reporting requirements and

have designed source-to-target data maps and business-driven

transformation rules

Participated in the design of new or changing mappings and

workflows and produce requisite specifications. Implemented the

change control requests (CCR) on need basis from client side

Participated in functional test planning and

testing the application. Involved in Developing, implementing and

maintaining unit tests for applications.

Participated in problem solving and troubleshooting for the

applications implemented with Informatica using session and

workflow logs. Responding quickly and effectively to production

issues.

Documented all new and modified mappings according to standards as

part of the Data Warehouse documentation.

Used indexes and partitioning on the fact tables to enhance

performance

Participated in the Informatica upgrade from Informatica 5.1 to

Informatica 7.1 and oracle upgrade from 9i to 10g.

Done the operations of daily, weekly and monthly reporting to FCC

for Billing, Network Performance, Operator Services, General

Standard domains in parallel, monitoring the informatica system to

ensure that they run properly.

Environment Informatica 7.1, Unix, Oracle 9i, MicroStrategy, Unix & Perl

Scripts.

Role Developer(Software Engineer)

Domain Billing, Network Performance

Contact this candidate