SUMMARY:

• Have almost 8 years of experience in delivering data centric - Data warehousing, Data Integration and has worked extensively on requirements gathering, Data Modeling. He is a Data Warehousing specialist and Informatica Certified Consultant with an excellent track record in de-risking, designing, integrating and implementing Data Warehousing solutions.
• Over years was involved in architecting, designing, developing, and delivering technology and strategy solutions to clients in onshore and offshore roles
• Highly motivated, successful IT professional with the extremely valuable combination of technical knowledge, interpersonal skills, and business acumen.
• Experience in Banking / Financial Services, Insurance, HealthCare and Pharmaceutical industries. s: Informatica Designer 8.x, Confidential: Enterprise Information Management v3.0 - Introduction to BI and DW, Confidential: Level I Industry Proficiency Program - Level 1 Financial Service Industry.
• Quickly learn and master new technology; equally successful in both team and self-directed settings; and proficient in a range of computer systems, languages, tools and testing methodologies.
• Ability to work under stringent deadlines with teams as well as independent.

TECHNICAL SKILLS:

Informatica: Power Center v7.x, 8.x & 9.x, Table Manager, Data Quality, Meta Data Manager, Power Exchange CDC, Cloud. InfoSphere DataStage v8.0/8.1/8.7

Ab Initio: 1.13(GDE) & 2.13(Co-Ops)

SAP BODS: Learning experience.

Data Modeling: Erwin, Oracle Data Modeler, Star-Schema and Snowflake-Schema Modeling methodologies using Kimball (bottom-up) & Inmon (top-down) approaches

Database: Oracle 9i, 10g - SQL & PL/SQL, MS Access Database

CRM Tool: Salesforce.com (Integration with ETL Tools)

Operating System & Programing language: UNIX, UNIX Shell scripting & Perl, Windows NT/2000/XP/2003/2008

Package & Other Tools: MS Access, MS Excel, MS PowerPoint, MS word, Putty, Win SCP, Tortoise CVS, TOAD

PROFESSIONAL EXPERIENCE:

Confidential

ETL Lead

Responsibilities:

• Create process / operational consistency across products to reduce complexity and increase agent agility
• Eliminate non-valued activities
• Automate steps and real-time pop-ups
• Improve multi-channel skill-based routing & outbound work distribution flexibility
• Improved system flexibility with quick configurable changes
• Improve operational oversight & WFM (IB and OB) with integrated CRM/multi-channel metrics & data visibility
• Better visibility across internal partners (i.e. marketing campaigns)

Technical Environment: Salesforce.com, Informatica v9.5, UNIX Shell Scripting

Confidential

ETL - Lead

Responsibilities:

• Technical design, build and testing phases of the engagement
• ETL - Lead, responsible for end to end delivery of project, managed the overall technical delivery plan, prepare data model, design which includes salesforce.com objects and Informatica jobs, risks and issues.
• Assisted the client in setting a defined standards and guidelines for all ETL work
• Oversee the testing strategy and implementation
• Understanding the As - Is legacy ETL and support to in corporate it in the To-Be requirements
• Managing team of 4.

Technical Environment: Salesforce.com, Informatica v9.5, UNIX Shell Script

Confidential

ETL Lead, Sales Force Automation (SFA Project)

Responsibilities:

• Lead team of 5, prepared project plan & reporting to Senior Management and Clients.
• Involve in Functional & Technical requirements for building salesforce.com objects and Data Stage jobs.
• Developed complex jobs using stages like Containers, Transformer, Aggregator, Join, Merge, Pivot, Salesforce.com package (Loading and Extracting)
• Co-ordinate and work along with client and onsite counterparts in design, development and deployment.
• Optimization of long running jobs and Testing.

Technical Environment: Salesforce.com, DataStage v8.1, UNIX Shell script

Confidential

Informatica, Perl - Design, Developer and Tester

Responsibilities:

• Lead technical design, build, Unit testing on ETL interfaces & developed PERL scripts for Reconciling & validating.
• Understand the business requirements and translate them into technical design and implement the same in ETL
• Onshore- Offshore coordination for effective and timely delivery
• Participate in the Defect specialists call and provide the root cause analysis of various defects in the existing system.
• SME for the Data validation/ Reconciliation between legacy and the new systems
• Manage the overall technical delivery risks and issues.

Technical Environment: Informatica Power Center 9, Oracle 10g, SQL developer, Perl on UNIX

Confidential, California, Nevada and Utah

Informatica - Design, Developer and Tester

Responsibilities:

• Understand business need of the client and the transformed Technical specification.
• Understand basic architecture of the project.
• Design Informatica ETL specifications for mapping source data to target, development of Test Scenarios, Scripts based on the business requirements for System, Integration Testing.
• Manage intra and inter-team dependency requirements, and maintain effective and timely communication amongst onshore and offshore teams
• Transactional-understanding, scoping requirements. Interactions at peer/operational level.
• Worked on Informatica Data Quality (IDQ) performed Analysis, Matching, Address Validation and Standardization of data based on the requirements.

Technical Environment: Informatica 8.6 Power Center, Informatica Data Quality (IDQ), Oracle 10g, TOAD v9.0

Confidential

Analyst and Designer, Tech. Lead, Developer and Tester

Responsibilities:

• Worked on business requirements and designed architecture based on the requirements.
• Worked with functional team, performed data quality checks and provided reports based on requirements provided.
• Provided and demonstrated data quality checks functionality to business users.
• Involved and suggested key points during architectural design.
• Obtained good business scenarios and educated the same to offshore team.
• Supported offshore and onshore team over build and testing phase.
• Took responsibility and delivered the works which were ad-hoc.
• Involved in evaluation of giving estimation for Test execution and defect fixing.
• Interact with business users gather requirements, prepare data.
• Involved in preparing and publishing the high level and detailed level design documents.
• Project plans for design phase to testing phase.
• Managed team of 10, by assigning tasks like design, Informatica code development, test cases preparation and execution.
• Explore new features and implemented various Proof of Concept of Informatica v8.5 & 8.6 which was used in this Project.
• Proactively pick up tasks and I worked on other modules for design suggestions, code implementation and testing.
• For change requests I have done design analysis and proposed models, suggested different approaches on the same and get them signed off from the users.
• Knowledge share was given to user by presenting it as power points and walk through on real time scenario which helped them in understanding end to end flow.

Technical Environment: Informatica: Power Center 8.5 and 8.6, Meta Data Manager, Table Manager, Data Quality (IDQ), Oracle 10g: SQL, PL/SQL, UNIX (AIX), TOAD v9.0

Confidential

Ab-Initio Developer and Tester

Responsibilities:

• Developing Ab Initio graphs as part of ETL delivery. Worked on components, sub-graphs and Multi-file system for creating Ab-Initio graphs.
• Executed Unit test cases, by preparing test cases and also some sample graphs to test upon the developed graphs.
• Lead, a part of, the activity of design documents analysis and ETL code development.

Technical Environment: Ab Initio -1.13(GDE) & 2.13(Co-Ops), Oracle 10g, UNIX HP.

Confidential

Informatica Developer & Tester

Responsibilities:

• Analyzing the Data Attributes mapping for Onetime Data load and Batch load.
• Analyzed the attributes, which are required to store in EW (Enterprise Warehouse) where Business Analyst can view the Security data.
• To design technical specification document representing detailed follow of data/build code by integrating i.e. identifying dependencies and automating through Control M for a module.
• Presented the TSD walkthrough to the client for sign off and further suggestions or change request.

Confidential

Informatica Developer & Tester

Responsibilities:

• Responsible for the design, development, implementation, Testing and maintenance.
• Analyze on functional specification and data profiling.
• Designed Technical Specification for data flow and presented walkthrough to the client for sign off.

Technical Environment: Informatica 7.1, UNIX Sun Solaris, Oracle 9i / 10g, Control M.