SUMMARY

• Strong Data Warehousing ETL experience of using Informatica Data Quality, Power Center, Power Exchange & MDM HUB versions 10.1/9.6.1/9.5.1/9.1/8.6.1/8.5/8.1/7.1 Power Center Client tools Mapping Designer, Repository manager, Workflow Manager/Monitor, Informatica Power Exchange.
• Extensive experience in working with Tableau Desktop, Tableau Server in various versions of Tableau 9.X(9.3,9.0) & 8.X (8.3, 8.2, 8.1, 8.0) and Business Objects.
• 2 years of experience in OFSAAI Data Entry Forms and Queries, Excel upload with Checker and Maker Process, Metadata Restore/Archive Utility and Data model create and upload process in Erwin Tool.
• As a ETL Lead performed different activities like project module tracking, Understanding the Nature of data with the help of business Analyst, Design Discussion, Task Allocation, Code Review, Mentoring the Developers, Code Demo with Business Users, code migration, Performing UAT and getting signoff, Release Management, Scheduling the Jobs and Production Turn Over Meetings.
• Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Responsible in identifying the entities and their attributes to create the Entity Relationship and Architecture diagram.
• Experienced in creating IDQ mappings using Labeler, Standardizer, Address Validator transformations with Informatica Developer and migrated to Informatica Power Center.
• Experienced in creating Logical Data Object ( LDO) and profiling for multiple sources in informatica developer and analyst.
• Develop numerous mappings using the various transformations including Address Doctor, Association, Case Converter, Classifier, Comparison, Consolidation, Match, Merge, Parser and Exception etc.
• Experienced in using Data Integration Hub (DIH) in creating topics and applications to publish and subscribe data.
• Data governance application for Informatica MDM Hub that enables business users to effectively create, manage, consume, and monitor master data using IDD ( Informatica Data Director).
• Good experience in integration of various data sources with Multiple Relational Databases like Oracle, Teradata, SQL Server, DB2, Mainframe and non-relational sources like flat files, XML, Excel files.
• Extensive experience & proficient knowledge in writing Advance/complex Sql Queries, PL/SQL Sequences, Procedures, Functions, Triggers and Unix/Linux Scripting.
• Extensively used various active and passive transformations like Filter, Router, Source Qualifier, Joiner, and Look up, Update Strategy, Sequence Generator, Rank, and Aggregator, Normalization, Stored Procedure, Sql Transformation, Transaction Control, Xml source definition, Xml parser, Xml generator.
• Responsible for implementing SCD Type-1, Type-2, CDC, Truncate/Reload and Incremental Loading mappings using Mapping Variables and Parameter Files.
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level by implementing Push Down Optimization, Session level Partition, Ordering the data in Lookup/Join queries.
• Worked with Session Logs, and Workflow Logs for Error handling, Troubleshooting and collecting performance data in order to speed up the Load Process across environments.
• Experienced in creating Tableau Desktop reports, data blending, dual axis, and publishing in server by providing the respective permissions, adjusting the report specifications in higher environments as per business users.
• Experienced in loading data into Essbase database with sql loader and data files, extracted the same with calc scripts, involved in creating Outline dimensions and its data members, used smart view to view the data in Essbase server.
• Responsible for Production Support and Issue Resolutions using Session Logs, Workflow Logs, Depends on Severity of the issues, will decide to go with Break the Glass, Cyber Ark and Normal Migration process.
• Strong technical background, and possess excellent analytical & Communication skills, creativity, leadership qualities, team spirit & above all a Positive attitude to shoulder successfully, any responsibility or challenges.
• Team coordination including mix of Business, Senior Management, IT Team (BA, Development, and Testing Teams) resides across different locations/countries.
• Research-oriented, motivated, proactive, self-starter with strong technical, analytical and interpersonal skills.

TECHNICAL SKILLS

ETL Informatica: Informatica Data Quality, Informatica Power center, informatica Power Exchange, Informatica MDM HUB 7.1/8.5/8.6.1/9.1/ 9.5.1/9.6.1 /10.1

RDBMS: Oracle 12c/11g/10g / 9i, SQL Server 2, DB2, Teradata 15.0

Database Tools: TOAD, SQL Developer, DB2, Teradata 15.0

Tools: Tableau desktop/server 9.3/10, EAS & HPP 11.1.2.3, HP ALM, ITSM (Service Now), SQL server Management Studio, Winscp, Endevour, Reveleus ( OFSSAI 7.0)

Web Technologies: HTML, Java, J2EE, JavaScript, JQuery

Programming Languages: C, C++, SQL, PL/SQL

Operating Systems: Windows XP / 2000/NT/ 2003/2007/2010

PROFESSIONAL EXPERIENCE

Confidential, Rockville, MD

Informatica & IDQ Lead

Responsibilities:

• Responsible for Requirement Gathering Analysis and End user Meetings
• Responsible for Business Requirement Documents BRD's and converting Functional Requirements into Technical specifications
• Responsible for providing the Integrated business area's in single platform which was previously distributed across SAS, SQL Server, and Desktop application.
• Created the Entity Relationship Modeling for Product 2.0, for Child, Parent, Landing & Base tables for informatica MDM tables.
• Work with Business Analyst in understanding the Nature of Data, accordingly will get the best possible way to implement in ETL for different Domains.
• Responsible in creating Logical Data Object ( LDO) and profiling for multiple sources in informatica developer and analyst.
• Experienced in creating IDQ mappings using Labeler, Standardizer, Address Validator transformations with Informatica Developer and migrated to Informatica Power Center.
• Develop numerous mappings using the various transformations including Address Doctor, Association, Case Converter, Classifier, Comparison, Consolidation, Match, Merge, Parser etc.
• Responsible in using Data Integration Hub (DIH) in creating topics and applications to publish and subscribe data.
• Data governance application for Informatica MDM Hub that enables business users to effectively create, manage, consume, and monitor master data using IDD ( Informatica Data Director).
• Responsible for creating the Materialized views in providing the data to Downstream for Analytical purpose.
• Extensive experience & proficient knowledge in writing Advance/complex Sql Queries, PL/SQL Sequences, Procedures, Functions, Triggers and Unix/Linux Scripting.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Flat Files & XML.
• Responsible for implementing Re-usable Mapplets, transformations, Mappings, Email, Command tasks and Unix Scripts.
• Lead team to create best practices and automation across multiple process improvements
• Team coordination including mix of Business, Senior Management, IT Team (BA, Development, and Testing Teams) resides across different locations/countries.

Environment: Oracle 11gR2Client, Teradata 15.0, Informatica 10.1, Informatica Data Quality 10.1, Tableau desktop/server 9.0/9.3, EAS & HPP 11.1.2.3, CA Software Change Manager, HP ALM, UNIX, Sql Server Management Studio, Vena System, Winscp, Endeavor- CA7.

Confidential, Pittsburgh, PA

Informatica & IDQ Lead

Responsibilities:

• Responsible for Requirement Gathering by connecting with Business users & Business Analysts.
• Responsible for Business Requirement Documents BRD's and converting Functional Requirements into Technical specifications.
• Responsible for providing the Integrated business area's in single platform which was previously distributed across SAS, SQL Server, and Desktop application.
• Working very closely with ETL Architect in identifying the different source system & their nature of data. Created Architecture Diagram for Different Source systems like PPNR, Mortgage and Expense Models.
• Responsible for identifying the Entities, Attributes & their Relationships to create Entity relationship diagram.
• Responsible for creating Logical & Physical data model through Erwin, Created the STAR dimensional Modeling for CCAR WS#4 like Dimension, Mapping, Reference, Stage and Fact tables.
• Work with Business Analyst in understanding the Nature of Data, accordingly will get the best possible way to implement in ETL for different Domains.
• Responsible for creating LDO, Data Profiling & Scorecard, mappings within IDQ.
• Have worked on Data Cleansing, Data Standardization, Data Governance & Exceptional Handling in IDQ.
• Created Reusable mapplets to utilize the same process for all the PPNR & Mortgage Models for Different Source systems.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Teradata, Flat Files & XML.
• Responsible for implementing Re-usable Mapplets, transformations, Mappings, Email, Command tasks and Unix Scripts.
• Responsible in creating Logical Data Object ( LDO) and profiling for multiple sources in informatica developer and analyst.
• Experienced in creating IDQ mappings using Labeler, Standardizer, Address Validator transformations with Informatica Developer and migrated to Informatica Power Center.
• Responsible in using Data Integration Hub (DIH) in creating topics and applications to publish and subscribe data.
• Data governance application for Informatica MDM Hub that enables business users to effectively create, manage, consume, and monitor master data using IDD ( Informatica Data Director).
• Develop numerous mappings using the various transformations including Address Doctor, Association, Case Converter, Classifier, Comparison, Consolidation, Match, Merge, Parser etc.
• Have implemented SCD Type-1, Type-2, Truncate/Reload and Incremental Loading mappings using Mapping Variables and Parameter Files.
• Have created Tableau Desktop reports, data blending, dual axis, and publishing in server by providing the respective permissions, adjusting the report specifications in higher environments as per users.
• Experienced in loading data into Essbase database with sql loader and data files, extracted the same with calc scripts, involved in creating Outline dimensions and its data members, used smart view to view the data in Essbase server.
• Have created CA7 Jobs to schedule the ETL jobs using Endeavor in production environment.
• Responsible for Production Support and Issue Resolutions using Session Logs, Workflow Logs, Depends Severity addressing the issue solution asap through Break the Glass, Cyber Ark or Normal Migration process.
• Lead team to create best practices and automation across multiple process improvements
• Team coordination including mix of Business, Senior Management, IT Team (BA, Development, and Testing Teams) resides across different locations/countries.

Environment: Oracle 11gR2Client, Teradata 15.0, Informatica 9.5.1/9.6.1 , Informatica Power Exchange 9.5.1/9.6.1 , Tableau desktop/server 9.3,EAS & HPP 11.1.2.3, CA Software Change Manager, HP ALM, UNIX, Sql Server Management Studio, Vena System, Winscp, Endeavor- CA7.

Confidential, Pittsburgh, PA

Informatica & IDQ Lead

Responsibilities:

• Generating Daily PWR1 Outbound files to do rating calculations at PEGA Side
• Work with business and document Business Problem and probable solution of the problem.
• Streamlined the ETL Code and implemented the required standards.
• Have implemented the synonyms at the database level to maintain the downtime.
• Carrying monthly loads in all the lower environments as per business need.
• Have created Power Exchange objects such as Datamaps.
• Responsible for implementing Re-usable Mapplets, transformations, Mappings, Email, Command tasks and Unix Scripts.
• Experienced in creating Tableau Desktop reports, data blending, dual axis, and publishing in server by providing the respective permissions, adjusting the report specifications in higher environments as per business users.
• Responsible in creating Logical Data Object ( LDO) and profiling for multiple sources in informatica developer and analyst.
• Experienced in creating IDQ mappings using Labeler, Standardizer, Address Validator transformations with Informatica Developer and migrated to Informatica Power Center.
• Responsible in using Data Integration Hub (DIH) in creating topics and applications to publish and subscribe data.
• Data governance application for Informatica MDM Hub that enables business users to effectively create, manage, consume, and monitor master data using IDD ( Informatica Data Director).
• Develop numerous mappings using the various transformations including Address Doctor, Association, Case Converter, Classifier, Comparison, Consolidation, Match, Merge, Parser etc.
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level by implementing Push Down Optimization, Session level Partition, Ordering the data in Lookup/Join queries.
• Have created CA7 Jobs to schedule the ETL jobs using Endeavor.
• Review scope and solution documents with the business team on immediate basis.
• Seeks sign offs and approval on scope and solution documents. All documents has to be signed by IT and Business Management team.
• Keep solution and approach transparent to Business and IT Management team. No solution should be implemented without approval from Business and IT management.

Environment: Oracle 11gR2Client, Teradata, Informatica 9.5.1/9.6.1 , Informatica Power Exchange 9.5.1/9.6.1 , Tableau desktop/server 9.3,EAS & HPP 11.1.2.3, CA Software Change Manager, HP ALM, UNIX, Sql Server Management Studio, Vena System, Winscp, Endeavor- CA7.

Confidential

Senior Informatica & IDQ Developer

Responsibilities:

• Understanding Business requirements.
• Developing the ETL components as well as Oracle procedures, functions & triggers.
• OFSAAI Data Entry Forms and Queries, Excel upload, Metadata Restore/Archive Utility and Data model creation and upload process.
• Reviewing components and test results prepared by other team members.
• Experienced in debugging mappings. Identifying bugs in existing mappings by analyzing the data flow and evaluating transformations and emphasized on Performance of mapping Optimizations.
• Responsible for implementing Re-usable Mapplets, transformations, Mappings, Email, Command tasks and Unix Scripts.
• Responsible in creating Logical Data Object ( LDO) and profiling for multiple sources in informatica developer and analyst.
• Experienced in creating IDQ mappings using Labeler, Standardizer, Address Validator transformations with Informatica Developer and migrated to Informatica Power Center.
• Responsible for implementing SCD Type-1, Type-2, Truncate/Reload and Incremental Loading mappings using Mapping Variables and Parameter Files.
• Have created Tableau Desktop reports, data blending, dual axis, and publishing in server by providing the respective permissions, adjusting the report specifications in higher environments as per users.
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level by implementing Push Down Optimization, Session level Partition, Ordering the data in Lookup/Join queries.
• Experienced in writing Advance/complex Sql Queries, PL/SQL Sequences, Procedures, Functions, Triggers and Unix/Linux Scripting.
• Carrying out pre-production implementation reviews of deliverables.
• Responsible for implementing the Best ETL solution through Mapping logic, Testing, Migrating the code to higher environment, Creating CA7 Jobs and deploying the code into Prod.

Environment: Oracle 11gR2Client, Teradata, Informatica Power center/Power Exchange 9.5.1, CA Software Change Manager,Endeavor, HP ALM, UNIX, Sql Server Management Studio, Winscp, CA7

Confidential

Informatica Developer

Responsibilities:

• Understanding existing business model and customer requirements.
• Finding the risk and issue during the requirement and design phase.
• Generated Reusable Transformations and used them extensively in many mappings.
• Designing the integration of the ETL process from source landing server to the load process
• Designing the ETL low level design document and unit test cases.
• Developed Informatica mappings to build business rules to load data.
• Responsible for implementing Re-usable Mapplets, transformations, Mappings, Email, Command tasks and Unix Scripts.
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level by implementing Push Down Optimization, Session level Partition, Ordering the data in Lookup/Join queries.
• Performed NDM files from UNIX to windows server.
• Extracting the source data to feed the staging, Operational and warehouse tables using Informatica Server manager.
• Responsible for implementing the Best ETL solution through Mapping logic, Testing, Migrating the code to higher environment, Creating CA7 Jobs and deploying the code into Prod.
• Have implemented the auto notification process for users with Email tasks.

Environment: Oracle 11gR2Client, Informatica Power Center/Exchange 8.6.1, CA Software Change Manager, HP ALM, UNIX, Sql Server Management Studio, Winscp, CA7.

Confidential

Informatica Developer

Responsibilities:

• Understanding Business requirements.
• Understanding the functionality of the existing systems.
• Providing the post implementation support.
• Developing suitable solutions, alternatives and best possible options.
• Responsible for implementing Re-usable Mapplets, transformations, Mappings, Email, Command tasks and Unix Scripts.
• Responsible for implementing SCD Type-1, Type-2, Truncate/Reload and Incremental Loading mappings using Mapping Variables and Parameter Files.
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level by implementing Push Down Optimization, Session level Partition, Ordering the data in Lookup/Join queries.
• Used Designer to create source definitions, designed targets, created mappings and developed transformations.
• Conducting unit testing.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Used various Informatica transformations like Expression, Filter, Aggregator, Rank and Router to load better and consistent data into the targets.
• Extracting the source data to feed the staging, Operational and warehouse tables using Informatica Server manager

Environment: Oracle 11gR2Client, Informatica Power Center/Exchange 8.6.1, CA Software Change Manager, HP ALM, Unix, Sql Server Management Studio Winscp, CA7

Confidential

Java Developer

Responsibilities:

• Involved in the design, coding, deployment and maintenance of the project.
• Every day we will get Input format from the business to publish in site.
• Depends on the Input format, will generate the output format by using Jelly script and publish into Site
• Creating of appropriate XML files and Jelly Scripts.
• Have to get the approval from business user before publishing in the site for correct content and format.
• Responsible in deploying the input/output format’s in the portal.
• Have migrated the code across environments and addressed the code validations.

Environment: Java, J2EE, Tomcat, Jelly Script, XML, Java Script, CSS, HTML.

Confidential

Java Developer

Responsibilities:

• Involved in the design, coding, deployment and maintenance of the project.
• Creating the front end pages using JSP pages.
• Providing User designed forms using, HTML, J query and Java Script.
• By using Servlets, carried out the Business logic/ Navigation of screens across the application.
• Creating the JDBC Connections to have interactions with database.
• Creating PLSQL Procedures, functions and triggers to do DML operations with Database.
• Creating Model View and Controller Objects.
• Providing the proper navigations to Front/Middle/Back end with MVU Architecture.
• Responsible for providing the Code demo to business users, upon approval will deploy into prod.

Environment: Java, J2EE, Tomcat, Jelly Script, XML, Java Script, CSS, HTML, Toad for Oracle.