Developer Manager
Resume:
Abhishek Shah
Address: *** ******** ***** **, *** 8222, Manchester, CT 06042 Email:
**********@*******.*** Cell: 646-***-****
. Career Objective
Aiming and working towards a challenging career, where I can use and
contribute my knowledge and skills, at full scale, for the growth of the
organization, team and self, and which gives an opportunity for better
learning, building strong foundation, and to excel as a leader.
. Educational Qualification
Qualification University / Location Graduation Grade /
Board Year Percentage
M.C.A. (Masters University of Pune, MH, 2005 74.82%
/ P.G.) Pune India
B.C.A. Sardar Patel V. V. Nagar, 2002 83.70%
(Bachelors / G.) University GJ, India
. Core Competencies
. Data warehouse concepts, architecture, development and implementation
- facts, dimensions, dimension modeling (star schema, snow-flake
schema), SCD (Type 1, Type 2, Type 3) etc.
. RDBMS concepts, architecture and development - SQL, PL/SQL,
performance tuning, CDC (change data capture)
. Informatica development and administration
. Batch scheduling and automation
. Release and Implementation management
. Onsite-offshore model experience
Technical skills:
Data Warehouse (ETL) Informatica PowerCenter 6.X / 7.X / 8.X, Informatica
Tools PowerExchange 8.6.1
RDBMS Oracle 9i/10g, SQL Server 2000
Operating Systems Windows 9x / 2000 / XP / 2003 / Vista, UNIX
Programming / UNIX Shell Scripting, Windows Batch Scripting, PL/SQL
Scripting
Automation and Autosys
Scheduling
Applications and SQL Navigator 4 / 4.5, Toad, WinSql, SQL*Plus, Rational
Utilities ClearCase, Rational ClearQuest, Subversion, Microsoft
VSS 6.0, PVCS Tracker, Documentum, Microsoft Office 2000
/ 2003 / 2007, HP Quality Center, Test Director
SDLC Analysis, Design, Development, Testing, Implementation
and Automation Strategies
Release Management Implementation Scoping, Planning, Coordination,
Execution and Post-implementation
. Professional Qualification
. Data warehousing CCP (Cognizant Certified Professional)
. Employment History
Employment Designation Employer Client Location
Duration
(Total: 5+
years)
AUG 2008 - Till Software Mastech Inc. The Hartford CT -
Date Engineer U.S.A.
JAN 2007 - AUG Associate - Cognizant Technology Merck & Co. PA -
2008 Projects Solutions U.S. Corp. U.S.A.
AUG 2005 - DEC Programmer Cognizant Technology Merck & Co. Pune -
2006 Analyst Solutions U.S. Corp. India
. Personal Qualities
. Ability to analyze and solve problems in an efficient and timely
manner
. Excellent team and role player and have management abilities
. Excellent written and oral communication skills
. Fast, focused and self-motivated learner and always ready to learn new
things
. Punctual, honest, hard-working, organized, flexible and thorough in
work
. Process follower and improver
. Professional Achievements
. Received customer appreciation and positive feedback in all the
projects worked on
. Have always succeeded and recognized in achieving customer
satisfaction in terms of desired quality of work
. Received timely promotions and highest appraisal ratings throughout
the employment
. Received 'Blockbuster of the Month' award while working for Cognizant
Technology Solutions U.S. Corp. at offshore (Pune, India) in 2006
. Received 'Above and Beyond' award while working for Cognizant
Technology Solutions U.S. Corp. at onsite (West Point, PA - U.S.A.) in
2008
. Roles and Responsibilities
. Onsite ETL Lead
> Have worked as Onsite ETL Lead for about 20 months for Cognizant
Technology Solutions US Corp. with total team size of about 10 team
members for 7 projects
> Responsible for planning, requirements analysis, designing,
development, QA and implementation support
> Responsible for interacting with clients and business users,
coordinating project execution and delivery
. Designer and Developer
> Presently working as Designer and Developer for The Hartford
(client) in P&C Reinsurance division
> Responsible for analysis of business requirements for application
change controls, enhancements, bug fixes etc., designing,
developing and unit testing the solution, coordinating with QA and
administration teams for testing and implementation of the solution
. Informatica Administrator
> Presently working as Informatica Administrator for The Hartford
(client) in P&C Reinsurance division
> Responsible for installing, configuring and maintaining Informatica
PowerCenter and PowerExchange servers and clients for development,
QA and Production environments
> Establishing and maintaining users, groups and security for all
Informatica environments within Reinsurance
> Reviewing and migrating Informatica code to QA and Production
. Release Manager
> Presently working as Release Manager for The Hartford (client) in
P&C Reinsurance division
> Responsible for planning, managing, coordinating and implementation
of in-house and/or vendor code/application releases for QA and
Production
> Responsible for planning, coordinating, creating and maintaining
different environments for Reinsurance development and QA
. Relevant Experience
Steady State
Employer Mastech Inc. Client The Hartford
Duration JAN 2009 - Till Date Team Size 15+
Technologi Informatica PowerCenter 6.2, 8.1.1, Informatica PowerExchange
es 8.6.1, UNIX, Oracle 10g, PL/SQL, Autosys, PVCS Tracker, Microsoft
SharePoint
Descriptio Main goal of this project is to update the whole technology
n infrastructure, automation of manual activities, solve system and
application defects and implement change controls identified by
business. This project is planned and targeted to put The Hartford
Reinsurance department in mature, process oriented, defect-free
and highest optimized state.
Role Designer, Developer, Automation Strategist, Informatica
Administrator and Release Manager
Strategic Automation
Employer Mastech Inc. Client The Hartford
Duration AUG 2008 - DEC 2008 Team Size 15+
Technologi Informatica PowerCenter 6.2, UNIX, Oracle 9i, PL/SQL, Autosys,
es PVCS Tracker, Microsoft SharePoint
Descriptio Objective of this project was to identify all manual activities
n pertaining to the Boston department for Reinsurance and automate
them resulting into zero manual intervention. Automation optimized
the process and saved considerable time and manual effort
resulting into less number of human errors.
Role Designer, Developer and Automation Strategist
FSR (Federal and State Reporting)
Employer Cognizant Technology Solutions Client Merck & Co.
U.S. Corp.
Duration OCT 2007 - AUG 2008 Team Size 10+
Technologi Informatica PowerCenter 7.1.4, Oracle 10g, UNIX, Documentum,
es Subversion, Rational ClearQuest
Descriptio FSR system was built to automate reporting of spending for HCP
n (Health Care Providers) to federal authorities of different US
states, by applying all necessary business rules and requirements,
with a collaboration to a third party front-end application, State
Guardian developed by Dendrite.
Role Designer, Developer and Onsite ETL Lead
HHICT (Human Health Incentive Compensation Tool)
Employer Cognizant Technology Solutions Client Merck & Co.
U.S. Corp.
Duration AUG 2007 - AUG 2008 Team Size 15+
Technologi Informatica PowerCenter 7.1.4, Oracle 10g, UNIX, Documentum,
es Rational ClearQuest, JIRA
Descriptio Main objective of this project was to calculate incentive for
n qualified sales force personnel from Merck's both divisions: USHH
and MVD with collaboration with a third party vendor - Callidus.
An application, TrueComp, developed by Callidus, is used to
calculate incentives. Integration of relevant data from several
internal sub systems which are completely heterogeneous in nature
(packed mainframe files, simple flat files, Oracle etc.), were fed
into TrueComp.
Role Designer and Onsite ETL Lead
GCS (Global Compensation Strategy)
Employer Cognizant Technology Solutions Client Merck & Co.
U.S. Corp.
Duration APR 2007 - DEC 2007 Team Size 5+
Technologi Informatica PowerCenter 7.1.4, UNIX, Oracle 9i
es
Descriptio In GCS, we built the process to provide the data to support the
n web application. Data was transformed as per the business rules
and requirements before loading it into the data mart so there was
minimal processing required at front end.
Role Designer, Developer and Onsite ETL Lead
LDW (Legal Data Warehouse)
Employer Cognizant Technology Solutions Client Merck & Co.
U.S. Corp.
Duration FEB 2007 - AUG 2007 Team Size 10+
Technologi Informatica PowerCenter 7.1.4, Oracle 10g, Documentum, Test
es Director
Descriptio In this project integration of three major financial reporting
n systems was done into one single simplified built legal data mart.
Main advantage is information gathered from all 3 systems kept
without superseding each other in the core layer. In aggregation
layer, preference was given to the systems as per the business
requirement and then data gets aggregated for legal and financial
reporting.
Role Developer and Onsite ETL Lead
Quest
Employer Cognizant Technology Solutions Client Merck & Co.
U.S. Corp.
Duration JAN 2007 - JUL 2007 Team Size 6+
Technologi Informatica PowerCenter 7.1.4, UNIX, Oracle 9i, Documentum
es
Descriptio This project was for feeding front end tool, Quest which is used
n by Merck's sales representatives for sales monitoring and
management. We generated the required data from different internal
sources and different Merck divisions according to business rules
and then this generated data is used to populate the back-end data
mart.
Role Developer and Onsite ETL Lead
CM8 (Cognos Migration 8)
Employer Cognizant Technology Solutions Client Merck & Co.
U.S. Corp.
Duration JAN 2007 - FEB 2007 Team Size 7+
Technologi Informatica PowerCenter 7.1.4, UNIX, Oracle 9i, Documentum
es
Descriptio This was a development project in which new Human Resource (HR)
n data mart was built. ODS data is picked from staging tables which
were refreshed daily and then the data is loaded in different
dimensions, facts and prompts in new data mart. Then these tables
are used for the Cognos reporting.
Role Onsite ETL Lead
ORM (Outcomes Research and Management)
Employer Cognizant Technology Solutions U.S. Client Merck & Co.
Corp.
Duration DEC 2005 - AUG 2008 Team Size 5+
Technologi Informatica PowerCenter 7.1.4, UNIX, Oracle 9i/10g, Microsoft
es SharePoint
Descriptio This project was for supporting ORM data mart which has inpatient
n claims, outpatient claims, lab claims, prescriptions and
enrollment data, throughout US. Data comes from two different data
source providers: Medstat and Ingenix. Data is transformed
according to the business rules, and loaded into the data mart.
This data mart is being used for research on outcomes through
statistical analysis on the data mart. Data mart has grown near to
2 TB in size.
Role Developer and Onsite ETL Lead
. Personal Details
. Date of Birth: 11th April, 1982
. Gender: Male
. Languages Known: English (US), Hindi, Gujarati
. Nationality: Indian
. Work Authorization in US: H1B (sponsored by present employer)
Contact this candidate