Management Sales
Resume:
Résumé
VIJAYPAL SINGH ********.*****@*****.***
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