SUMMARY

• 11 years of experience in Information Technology with background in Data Warehousing
• 10 years of experience in ETL tools primarily in Informatica
• 5+ years of experience as an ETL Administrator managing Informatica and ODI (Oracle Data Integrator) environments
• 5+ years of experience in Informatica Development and Application Support
• 1+ years of experience as a Data Analyst
• Good knowledge in Informatica Data Quality tools - Informatica Developer, Informatica Analyst
• Good experience working with different PowerExchange interfaces - Mainframe, Salesforce.com, DB2
• Specialized in large data warehouse implementations with focus on ETL Design and Development.
• Primarily worked as an ETL Administrator and Senior Developer responsible for coordinating and successfully executing projects
• Extensive experience in setting up and managing multiple Informatica environments
• Good experience in working with databases Oracle and Sybase IQ. Has good knowledge of SQL
• Good experience in working with RHEL and Mainframe Operating Systems

TECHNICAL SKILLS

Operating System HP-UNIX, LINUX, Windows, DOS, Mainframe z/OS

Databases Oracle 10g/11g, Sybase IQ 12.6

ETL Tools Informatica 9.6/9.5/8.6/8.1/7.1 , Oracle Data Integrator (ODI)Tools/Utilities Oracle SQL Developer/SQL Plus, PCOMM for Mainframe, Putty, WinSCP, MS Office

Programming Languages C, C++, Java, Shell Scripting

Source/Targets in ETL Teradata, Sybase IQ, DB2 in z/OS, Mainframe, Oracle, Flat Files, Salesforce.com

Informatica 8 Administrator (2012)

Informatica Architecture and Administration 7 (2006)

Cognizant Certified Professional in Datawarehousing (2005)

Java Wireless Application Developer (J2ME) (2004)

PROFESSIONAL EXPERIENCE

Data Analyst

Short Hills, NJ

Responsibilities:

• Profiling of several data sources using Informatica Analyst tool
• Flattening of XML source files to flat files using PowerCenter and profiling them
• Work with other Data Architects in reviewing the profile results and address their queries if any
• Create custom profiling results based on the need from Data Architecture Team
• Provide transition on using Informatica Analyst tool other Data Architecture team members
• Export and publish profile results. Update status reports to track the progress

Environment: Informatica Analyst 9.6.1, PowerCenter 9.6.1, RHEL 5.9, Oracle 11g, Flat Files, XML

ETL Administrator/Sr Developer

Parsippany, NJ

Responsibilities:

• Lead ETL Administrator responsible for the development and delivery.
• Responsible for maintenance and support of D&B’s ETL environments comprising of ETL tools Informatica and Oracle Data Integrator (ODI).
• Involved in set up of Development environments for new projects by installing latest versions of Informatica and ODI.
• Apply emergency bug fixes, hot fix releases and perform upgrades of ETL tools.
• Coordinate with ETL Development, Testing and Application Support teams in addressing requests related to the new and existing ETL environment configurations.
• Work with vendor support teams (Informatica and ODI) to fix issues related to the ETL environments and during the environment upgrade activity.
• Perform code reviews, code migration and promoting ETL best practices and ensuring ETL development teams adhere to the D&B coding standards.
• Coordinate with Release Management and Change Management Teams in promoting the ETL code to the Production region.
• Attend meetings conducted by business, development, support and change management teams.
• Manage license and server inventory of existing ETL tools and databases.
• Implement the items which are part of ETL CoE's roadmap (Server Consolidation, Proof of Concepts in New tools/features, Automation, Performance Tuning)

Environment: Informatica PowerCenter 9.6.1/9.5.1 , ODI 11.1, RHEL 5.9, z/OS, Oracle 11g, Sybase IQ 12.6,, SFDC

Project Name: MaxCV Data Buildout

Data Analyst

Parsippany, NJ

Responsibilities:

• Data Analyst at onsite responsible for the co-ordination with the business team and interacting with the Data Modelers in building the Data Model for Data System of Records (SoR).
• Interacted with various file owners for Data, capture the business requirements and articulate the same.
• Responsible to perform gap analysis between the legacy system and the new set of source files in building the data.
• Identify the gaps between the two systems and provide solutions to close the gaps identified.
• Prepared and published Business Definition Layouts (BDL) for the different source files involved in building the Data.
• Prepared and published the Data Transformation Specification (DTS) documents for the different source file having the business rules required to be used while loading the Data.
• Provided walkthrough to the Business and Development teams on the artifacts prepared and publish the same.
• Worked with the development team and addressed any queries raised.
• Analyzed the new user interface built for Data and provided the review comments.

Confidential

Responsibilities:

• Developed ETL mappings in Informatica to migrate data from the MS SQL Server database to DB2 MVS database.
• Reviewed mappings to move the data from the Staging to ODS after implementing the business rules.
• Involved in analyzing the Design Documents, Developing and Testing the mappings to load Datawarehouse from ODS.

Environment: Informatica PowerCenter 7.1, Oracle 9i, DB2, MS SQL Server