OBJECTIVE

• To contribute my technical expertise in the global market in various Data warehousing areas and to work in a progressive work environment allowing my technical and analytical skills utilized.

SUMMARY

• 8 Years of excellence in IT industry with experience in Analyzing, Designing, Developing, Testing, Implementing and maintaining Data ware house projects.
• Experience in working withETLmethodologies (Data Extraction, Transformation and Loading) to develop business intelligence for corporations using Informatica 7.1/8.5.
• Experience in Travel/Transport & Healthcare domains
• Experience in working with various Database/Data warehouse that involved analysis, design and development.
• Hands on experience with Data Extraction, Transformation and Data Loading.
• Experience on all phases of data warehouse development life cycle, from business analysis, requirement analysis, design and development to testing, implementation, and support.
• Experienced in doing analysis on data and preparing Business requirement documents, High - Level & Low-Level Design Specs, Unit Test Cases and support document.
• Worked as an ETL (Informatica) designer/developer for ETL DW projects.
• Worked on Oracle, involved in projects having Oracle SQL scripts.
• Expertise in UNIX shell scripts, have been involved in design/development for scripts to avoid manual interventions by automating the process as a value add to the customer.
• Good understanding of data warehousing concepts.
• Experience in handling multiple operational databases like Oracle, Teradata for extraction, staging and data warehouse environments.
• Good knowledge of SQL.
• Efficient at coding and SQL querying from various databases.
• Involved in different phases of the project like Requirement Analysis, Systems Analysis, Data extraction, Cleansing, Transformation and Loading into DataMarts.
• Designed Jobs between sources to data staging area and target data warehouse, using Star Schema, Implemented logic for Slowly Changing Dimensions (Source & Target Change Data Capture).
• Extensive experience in development, debugging, troubleshooting, and monitoring using Informatica tools.
• Broad understanding of dimensional data modeling like Star schema, Snow flake schema, Data Warehousing concepts, Fact and Dimension table design.
• Designed Mapping documentsETLarchitecture documents and specifications.
• Experience with UNIX shell scripting for File validation and scheduling Informatica jobs.
• Strong knowledge on relational database design concepts, SQ and SQL performance optimization techniques.
• Performed Unit, Integration, System, Functional and User Acceptance Testing (UAT) on various testing systems.
• Excellent communication, interpersonal, presentation skills and ability to work in a team as well as individually.
• Innovative in approach, enjoys learning new methods and ideas and putting them into daily practice.

TECHNICAL SKILLS

ETL Tools: Excellent knowledge of ETL Tool Informatica and worked extensively on ETL Development using Informatica. Worked extensively on design and development of a data warehouse built in ORACLE.

Database: Oracle, Teradata,DB2

Scripting: Have good knowledge about UNIX shell scripting and UNIX operating system in general. Specialized in UNIX shell scripting language.

Schedulers: Tivoli, Autosys.

PROFESSIONAL EXPERIENCE

Confidential, Sacramento, CA

ETL/Informatica Designer/Developer Lead

Responsibilities:

• This Account is mainly divided in three levels.
• Enhancements
• Production Support
• Miscellaneous Developments
• Worked in all three levels as a Tech lead and Developer on various projects.
• Delivered around 30 projects with zero post installation defects.
• Worked and won accolades for good work in major enhancements like DRG Implementation, ICD-10 Implementation.
• Worked on several Informatica Issues in production support. Not only successfully handled the same but also trained new resources to work affectively in this technology.
• Worked on designing complete architecture from Mainframe to Informatica (ETL Tool) to Oracle (as a DBA).
• Worked closely with BO resources in design of Database to be in sync with BO Universes.
• Understanding the existing system and client requirements.
• ETL Architecture, High Level Design, Source to Target mappings.
• Involved in BRD/HLD/LLD phase
• Developing the required Informatica/Unix components
• Unit Testing
• Knowledge Transitioning, mentoring and cross training members in the team
• Preparation of transition documents
• Involved in System Integration Testing and fixed bugs encountered during SIT.
• Involved in UAT and fixed bugs encountered during UAT.
• Involved in Production Support activities.

Environment: Informatica Power Center, Informatica Developer, ORACLE, TOAD, SQL, PL/SQL, UNIX, Windows7, Autosys, Tivoli Work Scheduler, Mainframe COBOL, JCL, CICS, Share Point, Erwin.

Confidential, Los Angeles, CA

ETL/Informatica/Mainframe Test lead

Responsibilities:

• Provided technical and investigative support for functional users on interfaces, defects, change requests, debugging issues, testing, service pack upgrades and adhoc report requirements
• Created Test cases in a user required format on regular basis
• Effectively handled presentations and walkthroughs with the clients.
• Gave Training to clients and users on the newly developed systems
• Worked with clients and Onsite SME’s in creating effective solutions for quick testing.
• Organized and attended team meetings on regular basis to increase productivity in the testing process
• Provided technical and business knowledge training to the team and won appreciation for the same.

Environment: Informatica Power Center, Informatica Developer, ORACLE, TOAD, SQL, PL/SQL, Mainframe COBOL, CICS, JCL.

Confidential, Atlanta, GA

ETL/Informatica/Mainframe Developer/Designer/SME/Team Lead

Responsibilities:

• Worked on several time critical issues
• Worked as a Team Lead/Designer & SME for various applications within the account.
• Worked on production support at primary and secondary levels.
• Worked on Coding, Testing & designing several projects
• Worked as a team lead for Payroll and Operations Applications and handled the same effectively
• Attended Calls on a daily basis with clients and helped in solving several business related issues as well
• Knowledge transfer on several project related and technical aspects to the team and won good appreciation for the same
• Worked with several Sysadmins as a part of Migration project, which gave a good exposure on the overall system.
• Worked on Quality related tasks like ID Administration/Data Security and Privacy for Allied
• Worked on around 1500 Problem Tickets in various Applications
• Worked on around 40 major and minor projects in various applications.
• POC and SME for the application being built.
• Involved in the requirement sessions and interact with business to have the key decisions
• Hot fixes and production support for critical issues.
• Came up with the best practices and design patterns
• Reviewed code, design and test plans as appropriate throughout the project lifecycle to assure compliance.
• Involved in Performance Testing of Jobs.
• Prepared Production execution plan and detail implementation task spanning for 3 weeks across different application
• Onshore/Offshore co-ordination

Environment: Informatica Power Center, Informatica Developer, DB2, Teradata, SQL, PL/SQL, UNIX, Windows7, Mainframe COBOL, JCL, CICS, Share Point, Erwin.