Résumé

VIJAYPAL SINGH acpwjv@r.postjobfree.com

Plano, TX Contact - 214-***-**** )

Summary:

• 10+ years experience primarily in Business Intelligence domain for Pharmacy Benefit Management,

Healthcare, Insurance and Finance.

• Expertise in Business Intelligence Application Development using ETL tools

Informatica, mapping, workflow, Unix Shell Scripts, PL/SQL stored procedures,

Teradata BTEQ, Fast Load, TPT load scripts, Teradata utilities, SAS, awk/perl scripting

• Conceptually strong in Data Warehouse Concepts, Data modeling, Data transformation,

IBM DB2 UDB, Oracle 10g, Unix shell script development, PL/SQL Stored procedure

• Proficient in analysis, design, development of ETL applications

• Managed all aspects of the SDLC process - requirement analysis, time estimates, functional specification,

design, development, testing, packaging, and support/maintenance

• Experience in business analysis, project management and team leadership. Diverse

background with good learning skills, analytical abilities and excellent technical skills.

• Experience in enterprise class Business Intelligence/Datawarehouse projects,

implementations, software development, providing business solution to internal and external

customers

• Highly motivated and result oriented professional with very strong technical, interpersonal and

communication skills.

Technical Skills:

Informatica Power Centre 5.x/6.x/8.x/9.5/9.6,

o

Unix Shell Scripting, awk Programming, perl scripting

o

Oracle (PL/SQL)

o

IBM DB2 UDB

o

Teradata (Teradata SQL Assistant), Fast load,, MLoad, BTEQ

o

Tools: Tivoli Maestro scheduler, Toad (Oracle/DB2)

o

Education:

Bachelor of Engineering, majoring in Computer Science & Engineering

o

Diploma Engineering - Computer Science & Engineering

o

Certifications:

IBM DB2 UDB v 8.1 Database Associate Certification

Microsoft Certified professional

Member Project Management Institute

Trainings:

Informatica Powercenter Administrator/Advanced Developer

Data warehousing Fundamentals & Architecture

Informatica PowerExchange Development

UNIX Shell Scripts Development

HIPPA Compliance Training

Teradata database

Page 1 of 5

Résumé

Project Experience:

• Sr. ETL Consultant (Jan 2015 – Current)

Interstate Batteries, Dallas

National Accounts services Interstate’s largest automotive battery customers and seeks future growth with

retail chains, parts outlets, and major automotive corporations. By leveraging the entire system, this group

helps Interstate approach accounts that are too large for any individual Distributor’s territory.

The NAC account managers develop the business relationships and creatively pursue prospective

accounts. The NAC team also manages certain privately branded batteries for certain outlets. More than

half of Interstate’s annual sales volume passes through its national accounts.

- Designing and development of EDW and data extract-transform-load procedures/processes

- Develop informatica code (mapping, sessions,workflows) for rebates and subsidy application

- Performance enhancement and tuning informatica code & PL/SQL code

Technologies:

Informatica 9.6, Oracle 11i, PL/SQL,Unix Shell Script

• Technical Lead/Sr. Consultant, Application Development ( Jan 2011 – Jan 2015)

CVS Caremark, Richardson,TX

CVS Caremark is one of the largest pharmacy benefit management (PBM) companies in

North America. CVS Caremark is a leading provider of prescriptions and related health

services with over 6900 pharmacy locations throughout the US. My primary role as

Programmer Analyst is to support enterprise data warehouse operations. My responsibilities

included:

• Responsible for supporting the Applications developers and other team members in

making sure all parts of the Project Life Cycle Activities are managed, developed and

supported to provide on time and on budget service to the business.

• Manage the solutions planning, design and development, and execution of desired

Data ware housing solutions compliant to HIPAA, HL7,ICD 10 to the business.

• Identify the Strategic Data Gathering and Subject Matter Information and Analysis

that help develop and support Merchandising, Inventory Replenishment, and Store

Operations Business Units.

• Work with Project Managers and other Developers and Testers to make sure there is

a thorough understanding of all requirements.

• Performed unit testing at various levels of the ETL and actively involved in team code reviews.

• Document and manage customer requirements throughout the development lifecycle,

including requirements definition, requirements analysis, process analysis,

requirements change management, use case and business process modeling, logical

system design and high level estimating.

• Developed Informatica mappings, workflow, B2B Data transformation, DT Studio and

UNIX shell scripts, PL/SQL stored procedures, BTEQ’s, FLOAD, MLOAD, TPT

Teradata utilities scripts, SAS code for various data extract and reports, developing

DB2 UDB load shell scripts using load/import utilities

• Informatica upgrade and migration of code from informatica 8.5 to informatica 9.1

• Teradata upgrade and migration from Teradata 12 to Teradata 13.1

• Managed team of 12 resources for day to day actitivties

• Provided technical inputs to design, development of PBM applications.

• Worked on Informatica data replicator and Informatica Fast clone, Informatica

Powerexchange change data capture

• Worked on developing PBM/Healthcare applications using informatica Powercenter:

Retiree Drug Subsidy, Health Management Initiatives, Drug Utilization Review (DUR),

Pipeline, Changed Data Capture, Full refresh, extract processes.

• Worked on Data conversion for various data marts (Oracle/DB2) to Teradata

• Worked on performance tuning of SQL and Informatica objects code

• Provided support to Enterprise Data Warehouse Applications

Technologies:

Page 2 of 5

Résumé

Informatica 9.5, Teradata 13.1, PL/SQL, DB2 UDB, Oracle, SAS

• ETL Developer

Tata Consultancy Services, USA ( June 2008 – Jan 2011 )

Client: CVS Caremark

CVS Caremark is one of the largest pharmacy benefit management (PBM) companies in North

America. CVS Caremark is a leading provider of prescriptions and related health services with over 6900

pharmacy locations throughout the US. My primary role as Programmer Analyst is to support enterprise

data warehouse operations.

My responsibilities included:

• Developed Informatica mappings, workflow and UNIX shell scripts, PL/SQL stored

procedures

• Providing on call support to resolve issues in production environment

• Involving in design review, code review and production handover session for new

developments in data warehouse

• Optimizing existing mappings and Unix Shell scripts for better and faster execution

• Carrying out severity analysis of reported bugs and change requests using Casual

Analysis, managing and planning using Assent

• Carrying out defect tracking and closure using WinDelta and attending status calls

• Production support for Daily/Weekly/Monthly jobs

• Performance tuning of SQL’s, Informatica objects

• Developed Informatica mappings, workflow and UNIX shell scripts, PL/SQL stored

procedures

• Developed Informatica mappings, workflow and UNIX shell scripts, PL/SQL stored

procedures, BTEQ’s, FLOAD, MLOAD, TPT Teradata utilities scripts, SAS code for

various data extract and reports, developing DB2 UDB load shell scripts using

load/import utilities

Technologies:

Informatica 9.x/8.x, Teradata 13.x, PL/SQL, DB2 UDB, Oracle, SAS

• IT Associate

Tata Consultancy Services, INDIA ( Sept 2006 – June 2008 )

Client: Fidelity Investments, Boston, USA

Fidelity Investments is one of the World’s leading Investment Company in many areas like

mutual funds, insurance etc. TCS was providing solution for their Security lending Process.

Securities Lending is Trading solution for lending of securities in turn of collateral.

Developed Informatica mapping, workflows, Unix shell scripts

-

Worked on DB2 UDB DBA activities

-

Developed Unix shell scripts to automate various applications

-

Technologies:

UNIX AIX, Informatica, cognos,DB2 UDB, Oracle, MS DOS, SQL, PL/SQL, UNIX, SAS,

Shell scripts, ASP.Net, MS Office (Excel, Access, Power Point, Visio, Word), Erwin tool

3.5.

• Assistant System Engineer

Tata Consultancy Services, INDIA ( July 2005 – Sept 2006 )

Client: Tri-Care Encounter Data (TED)

United States Department of Defence, Virginia, USA

Page 3 of 5

Résumé

United States Department of Defence introduced the TRICARE program in response to the

challenge of maintaining medical combat readiness while providing the best health care for all

eligible personnel. It is a regionally managed health care program that is meant to define and

establish methods to reform the Military Healthcare system into a totally managed care

enterprise, for active duty and retired members of the uniformed services, their families, and

survivors.

• Informatica code development designing transformation maps, mapplets,

workflows, worklets and sessions in Informatica

• Installation and configuration of Informatica in different environments

• Tuning Informatica workflows handling huge data.

• Extraction, Transformation & Loading mechanism design using Informatica and

UNIX shell scripts, awk scripting.

Technologies:

• UNIX AIX, Informatica, cognos,DB2 UDB, Oracle

• Assistant System Engineer ( Aug 2004 – July 2005 )

Team Lease Services Ltd, INDIA

Client: Reliance Industries Limited

Reliance Industries Limited has real time retail outlet sales system for fuel delivery under tie

up with the Ogden, Utah (US) –based Flying J, an integrated petroleum company to automate

its retail outlets (reliance petrol pumps). Tanks and fuel dispensing units are all connected to

server computer which keeps a tab on fuel volumes. The main outlet server is connected to

Dhirubhai Ambani Knowledge City (DAKC) at Mumbai through VSAT.

• Developing Unix Shell Scripts

• Maintaining Database Testing Environment

• Implementation and maintenance of the Retail Outlet Sales System.

• Reconciliation daily and monthly reports.

Technologies:

• UNIX AIX, Oracle 10g

• Internship Projects:

• Wipro InfoTech, INDIA

Wipro InfoTech has developed the Prototype Model for the Internet Banking Solution

to provide end-to-end implementation and integration of the facilities such as Any

Branch Banking, Instant Fund Transfer, cash Management Services Flexi Fixed

deposit Scheme, Tele Banking, and Internet Banking. Internet Banking facilitates the

customer for printing the account statement, funds transfer.

Technologies:

UNIX AIX, IBM DB2 UDB, informatics, Microsoft Visio

• Patni Computer Systems Industries Limited, INDIA

To improve the day to day efficiency in the hospitality industry, the inventory control

system has been developed to control procurement, materials, recipes, forecasting,

Page 4 of 5

Résumé

production, sales. It automates the food and beverage acquisitions, non perishables

like stationery, guest amenities, housekeeping and other consumables.

It records, tracks and control all inventory activity, monitors inter location and inter

property transfers, alerts about physical vs. inventory discrepancies, generates

reports about price turnover, products and revenue, handles product and service

purchase for Housekeeping. It includes a comprehensive information warehouse for

easy access by many reporting systems.

Developed UNIX shell scripts & PL/SQL stored procedures

Programming language C

System analysis, design, development

Technologies:

UNIX AIX, informatics, Microsoft Visio

Page 5 of 5

Contact this candidate