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.
• 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.x,
• Unix Shell Scripting, awk Programming, perl scripting
• Oracle PL/SQL
• IBM DB2 UDB
• Teradata Teradata SQL Assistant , Fast load,, MLoad, BTEQ
• Tools: Tivoli Maestr scheduler, Toad Oracle/DB2

Project Experience:

Sr. Consultant, Application Development

Confidential

• 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 t 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 t provide on time and on budget service t the business.
• Manage the solutions planning, design and development, and execution of desired software IS solutions t 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 t make sure there is a thorough understanding of all requirements.
• Analyze and build software solutions that are robust and defect free.
• Work with various software cross-competency teams completing tasks related t business solution planning and business case development.
• 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. Work collaboratively with business representatives, Project Management and varied IS teams t develop and implement the specific technology and architecture necessary t deliver business solutions.
• 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
• Worked on PBM business applications development: Retiree Drug Subsidy, Health Management Initiatives, Drug Utilization Review DUR , Pipeline, Changed Data Capture, Full refresh, extract processes.
• Worked on performance tuning of SQL and Informatica objects code
• Provided support t Enterprise Data Warehouse Applications

Technologies:

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

ETL Developer

Confidential

• My responsibilities included:
• Developed Informatica mappings, workflow and UNIX shell scripts, PL/SQL stored procedures
• Providing on call support t 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

IT Associate

Confidential

• 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 t 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

Confidential

• Confidential Department of Defence introduced the TRICARE program in response t 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 t define and establish methods t reform the Military Healthcare system int 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

Confidential

• 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:

Wipr InfoTech has developed the Prototype Model for the Internet Banking Solution t 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

• 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.
• Confidential IT improve the day t day efficiency in the hospitality industry, the inventory control system has been developed t control procurement, materials, recipes, forecasting, production, sales. It automates the food and beverage acquisitions, non perishables like stationery, guest amenities, housekeeping and other consumables.
• Developed UNIX shell scripts PL/SQL stored procedures
• Programming language C
• System analysis, design, development

Technologies:

UNIX AIX, informatics, Microsoft Visio