SUMMARY

• Over eleven years of IT experience in analysis, design and development of software applications with over 9 years of solid experience in implementing Informatica as an ETL tool in a dimensionally modeled data warehousing environment.
• In depth understanding and experience in Master Data Management MDM methodology and implementation.
• Experience in data extraction, transformation and loading using Informatica Power Center 9.1/8.6/7.1.4/6.1,6.2/5.1.2 Source Analyzer, Repository Manager, Data Warehousing Designer, Mapping Designer, Mapplet Transformation and SSIS SQL Server Integration Services 2008/2012.
• Familiarity with Informatica Metadata Manager, Data Analyzer.
• Strong knowledge of Software Development Life Cycle SDLC including requirement analysis, design, development, testing, and implementation of client/server applications.
• Extensively involved in E-R modeling and dimensional data modeling, design of star schema, snow flake schema. Used ERwin for physical and logical data modeling.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment, change data capture.
• Experience in developing reports using OLAP tool Business Objects Supervisor, Designer, BO Reports, WebI, InfoView, BOSDK, WebISDK, and Broadcast Agent .
• Programming experience using SQL, PL/SQL, Oracle, VB Script, Java Script, Unix Shell Programming, Visual Basic, C, HTML, DHTML, Sun Solaris, AIX, and XML.
• Extensive experience in OLAP tools, Materialized Views, Indexing and partitioning techniques for highly responsive Decision Support Systems.
• Strong experience in programming with Oracle SQL, PL/SQL, Stored Procedures, Packages, Functions, Advanced Queues, Database Triggers and using SQL Loader, Rman, Export and Import.
• Highly proficient in converting business requirements into feasible technical solutions applying client-server database skills in mixed OS environments.
• Strong analytical, organizational, presentation and problem solving skills, as well as excellent inter-personal communication skills.

COMPUTER SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL/DB Developer

Responsibilities

• Reviewed requirements for completeness and accuracy and determined if requirements are actionable in the current or new ETL architecture.
• Translated business end user requirements into architecture / High level design requirements and worked with requirement providers to close gaps and issues.
• Extensively used SQL loader to load data from flat files to the database tables in Oracle.
• Created database Tables, Indexes, Views, Materialized Views, Stored Procedures and Packages to support backend development.
• Analyzed data, created Profiles and data quality scorecards. Created reusable Data Quality Rules /Mapplets to identify and cleanse data like duplicates, Nulls etc.,
• Prepared IDQ plans according to the Business Requirements to cleanse the data using Informatica Data Quality and exported IDQ plans into Informatica Power Center to cleanse the data in staging database.
• Effectively utilized transformation like the normalizer, filter, router, expression, aggregator, joiner, lookup connected and unconnected , union, update strategy transformations.
• Parameterized the mappings and increased the re-usability. Modified existing mappings for enhancements as part of new business requirements.
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size, sequence buffer length, target based commit interval and session partitioning.
• Created and maintained Perl scripts to schedule Informatica workflows.
• Developed AutoSys JIL's and worked with various tasks and events for defining, scheduling and monitoring and controlling jobs.
• Created Technical Design Documents for the Informatics jobs/processes created.
• Supported operations during the build/deployment of a new release to the Integration, QA and Production environments.
• Managed user-stakeholder communications, vendor relations, ticket resolution and environment monitoring.
• Interacted with offshore support team for day to day development activities and production support.
• Ensure standards and best practices used in the code development are followed, documented and maintained.

Environment: Informatica Power Center 9.1.0, Informatica Data Quality 9.1, Oracle 11g, SQL Loader, Toad 12.0, SQL Server 2012, HP Quality Center, WinSCP, UNIX AIX, Autosys R11, Windows 7.

Confidential

Senior Informatica Developer

Responsibilities

• Acted as a liaison between the technology and business areas of the organization.
• Participated in professional system's analysis projects and work initiatives.
• Reviewed and analyzed the business requirements for identification of data sources and target systems.
• Created the strategy and lead the project to migrate Informatica from version 8.5, UNIX installation to version 9.1.0 Windows installation. Apart from Power Center installation, was also responsible for the installation and creation of business processes using Informatica Data Analyzer, Metadata Manager.
• Created a detail end to end installation procedure document for the system support team, to assist them with the Informatica power center as well as other services installation.
• As part of Awards project, modeled a data mart and designed dimension and fact tables that hold the data fetched from source system.
• Created the complex mappings and headed a development team to develop Informatica mappings, sessions and workflows that populate the Awards data mart.
• Created reusable components UDF's, Mapplets , to reduce the complexity in coding and facilitate reusability of code, where code generalization was possible.
• Performed for code review, of the code developed by other developers in the team, before the code was deployed to QA.
• Develop database objects stored procedures, functions, views, tables as part of various BI development initiatives.
• Participate to evaluate new BI tools and technologies.
• Participate with implementation teams to implement BI code and to validate implementation in different environments QA, Stage, and Production .
• Assist with defect determination and resolution, unit and integration testing.
• Assist in end user UAT, QA cycles and production support to business users.
• Worked closely with the system support team to assist in troubleshooting the Informatica environment, also interacted with the Informatica support by opening tickets and following up, for any critical issues.

Environment: Informatica 8.6/9.1, SQL Server 2008/2012, HP Quality Center, Visual Studio suite 2010/2012 , Serena PVCS, Win 2008 R2, Win XP Prof.

Confidential

Senior Informatica Developer/SSIS Developer

Responsibilities

• Involved in business discussions with the data modelers and business users to decide about the subject areas in which the data needs to be organized.
• Recommend data modeling changes and ETL changes to improve maintainability, data quality, best practices and performance.
• Designed and created informatica mappings used to build the data marts according to the subject areas.
• Re-architected data flow for efficiency.
• Created UDF's User Defined Functions and mentored the team to build efficient mappings using the reusable components UDF's, lookups wherever possible.
• Developed complex mappings using multiple sources and targets in different Databases, flat files.
• Created parameter based mappings.
• Worked with dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner and Aggregator transformations.
• Effectively used almost all of the workflow tasks like command, event wait, event raise, assignment and decision tasks to create efficient workflows.
• Created a Migration strategy to migrate Informatica components from Dev to QA/UAT/Production environment.
• Lead the ETL team to instruct and ensure best practices were implemented.
• Involved in the end user training production support.
• Engaged in production support.
• Worked on Documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica 8.6, Oracle 11g, SQL Server 2005, PL SQL Developer, HP Service Manager, WinSCP, UNIX AIX, Windows XP Prof.

Confidential

Data Architect

Responsibilities

• Developed Data Architecture strategy for Current State and Future State architectural assessments.
• Analyzed the implemented real time data collection from vendor sources and internal data points, enabling to maintain the data warehouse most updated.
• Created a migration strategy and lead the effort of migrating from Oracle9i to 10G and Informatica 7.1.4 to 8.1.1.
• Evaluated Master data management tools Golden Source, Asset Control, and Siperion that would best cater the needs of business functionality.
• Involved in integration capability assessments.
• Performed major role in under standing the business requirements and redesign loads into data warehouse as part of MDM project.
• Developed Logical and Physical data models that capture current state/future state data elements and metadata using ER Studio.
• Developed custom connectors and workflows to load data from vendor sources into Golden Source MDM application
• Designed and developed Informatica mappings to load data coming from TIBCO ESB layer into stage tables using JMS Transformation.
• Created the Informatica workflows to load dimension and fact tables using Appworx as a scheduler.
• Involved and supported reporting system built on warehouse, using Business Objects XI.
• Involved in database performance tuning.
• Maintained documentation for all the data flows in the company metadata repository, field to field maps .

Environment: Informatica 8.1.1, Oracle 10g, SQL Server 2005, DB Artisan, Golden Source 8.1.2, WinFTP, UNIX Solaris, Appworx, Windows XP Prof.

Confidential

Informatica Lead

Responsibilities

• Involved in project management plan and the understanding of Business Process and Process flow.
• Interviewed Subject Matter Experts, Business Managers to understand the data in Operational systems.
• Installed and Setup Informatica Client tools on client machines.
• Created folders and created users with proper privileges.
• Updating requirements document, solution design, create solution design documents.
• Assign tasks to team members, co-ordinate and monitor Informatica oracle based development tasks like applying transformation logic.
• Designed and developed Informatica ETL mappings to extract master and transactional data and load them to various reporting databases.
• Optimized mappings by using Aggregator, filter, Joiner, Expression, Lookups
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Extensively worked with Oracle objects like triggers, functions, packages and synonyms.
• Developed SQL scripts to be called by command tasks in workflows.
• Worked on different tasks in Workflows like sessions, e-mail, command and decision and configured the sessions to run in parallel and sequential.
• Worked with Scheduler to run the Informatica session on regular interval and to send an email after the completion of loading.
• Involved in Unit Testing, Integration Testing, and System Testing.
• Created and applied labels to all the repository objects and migrated then across various environments.
• Associated with Production support team in various performances related issues.
• Created support documentation for the ETL work done to make production support easier.

Environment: Informatica 8.1.1, Oracle 10g, Flat Files, Windows XP Prof., PL/SQL developer 7.0.3, MS-Visio, WinSCP, UNIX AIX, Star Team.

Confidential

Senior Informatica Consultant

Responsibilities

• Involved in business requirement analysis meetings with the clients.
• Coordinated with the offshore development team in regards of assigning work and updates regarding the progress of project implementation.
• Assisted in logical and physical data modeling using Visio.
• Converted business requirements into technical specifications and mapping documents.
• Designed and developed the ETL strategy to load data into targets reading from flat files and various DB2 source tables.
• Applied the Pre and Post SQL Queries in the session properties to filter the source rows.
• Implemented the Target Update Override functionality.
• Programmed DB2 Triggers for database auditing purposes
• Developed test case documents and complex DB2 queries to validate source and target data for Unit testing and User Acceptance Testing.
• Employed Mercury Quality Center tool to log the bug and issues found during testing
• Used UC4 to create and schedule the workflows.
• Deployed all the code to production environment and provided production support.
• Assisted the Crystal Reports development team in generation ad-hoc and user defined reports.
• Created component documentation for all the ETL mappings developed and trained the support group

Environment: Informatica 7.1.4, DB2, Flat Files, Windows XP Prof., IBM DB2 command editor, MS-Visio, WS-FTP, Mercury Quality Center, UC4, MVS ZOS 1.8, AIX.

Confidential

Informatica Specialist

Responsibilities

• Assisted the Toro team in gathering requirements, data analysis and creating start schema data models for Toro EDW
• Designed and developed Informatica mappings to source data from the staging tables and load the dimension and fact tables of three stars schemas
• Extracted the data from the SAP tables using Informatica Power Connect to transform it as per the company requirements and load into the warehouse
• Utilized IDOC adapter to develop Informatica mappings that load the Oracle staging tables from SAP tables
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy translating business rules and functionality requirements into ETL procedures
• Worked extensively on almost all the transformations such as Update Strategy, Cached lookups, Connected and Unconnected lookups, Filter, Router, Expression, Aggregator, Joiner etc
• Developed Oracle triggers for data verification and auditing purposes
• Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor
• Configured and used the Debugger to troubleshoot the mappings
• Designed and developed unit test cases for the ETL processes
• Created component documentation for all the ETL processes developed before delivering code to System Testing

Environment: Informatica 7.1.2, Power connect 7.1.2, Oracle 9i, SAP Change Files, Windows NT 2000, SQL Developer, Visio

Confidential

Informatica Developer

Responsibilities

• Analyzed business requirements by interacting with the business users and application development teams
• Designed and developed the ETL architecture to build and populate the data marts using Informatica
• Designed and developed Informatica mappings for data loads that included Source Qualifier, Aggregator, Joiner, Lookup , Filter, Router, Update Strategy, Expression and Sequence Generator transformations
• Designed Parameter driven Informatica sessions and workflows for extracting, cleansing, transforming and loading the data from the heterogeneous sources into the data warehouse by using parameter files
• Implemented SCD Type 2 strategy to update the Slowly Changing Dimensions and maintain the OLAP tables storing history in the data mart star schema
• Developed Informatica mappings to cleanse and remove duplicate rows from source data
• Programmed Oracle SQL, PL/SQL Stored Procedures, Functions, Triggers and Packages as back-end processes to create and update staging tables, log and audit tables, creating primary keys
• Used workflow manager for session management, database connection management and scheduling of jobs
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels
• Performed Unit Testing and SIT Testing and assisted QA team in Quality Assurance Testing, Load Testing and Performance estimation testing
• Prepared functional and technical specification documents for the ETL standards and strategy
• Developed views necessary for structured and ad-hoc reporting

Environment: Informatica Power Center 7.1, Oracle 9i, DB2, Flat files, Erwin 3.2, Windows NT 2000, Toad, Visio

Confidential

DW Informatica Developer

Responsibilities

• Designed Parameter driven Informatica mappings and sessions for extracting, cleansing, transforming and loading the data from the Complex Flat Files and CIF tables into the data warehouse
• Used various transformations like Unconnected /Connected Lookup, Aggregator, Expression Joiner, Sequence Generator, Router for creating complex business logic in ETL
• Developed logic using sequence generator transformation to replace missing keys and create unique keys
• Created worklets and workflows in the workflow manager to synchronize OLAP system with OLTP system with the logic to run set of tasks at the scheduled times
• Used Repository Manager to migrate Informatica mappings across the development, test and production environments
• Involved in extensive performance tuning by determining bottlenecks at targets, sources, mappings, sessions
• Extensively used PL/SQL for creating views, stored procedure, and indexes on the tables
• Involved in error checking and testing of ETL procedures and programs in Informatica session log
• Developed Component documentation as per Juniper Standards for every product designed
• Assisted the Brio Decision Support Systems DSS team in designing and scheduling the ad-hoc reports

Environment: Informatica 6.2, Oracle 8i, SQL Navigator, Visio, Erwin 4, Windows NT 4, SunOS 5.6, Brio

Confidential

Informatica Consultant

Responsibilities

• Used Informatica to extract, transform and load data from multiple heterogeneous sources into Oracle
• Worked on Source Analyzer, Warehouse designer, Mapping Designer and Transformations, Informatica Repository Manager and Workflow Manager and Monitor
• Created Mappings, Mapplets and Transformations using the Designer and developed Informatica sessions as per the business requirement
• Designed the change data capture logic in the Informatica mappings by incremental extraction of source data
• Used the transformations like Source qualifier, Router, Filter, Sequence Generators and Expression as per the Business requirement to create the mappings
• Developed complex aggregate, joiner, look up transformation rules business rules to generate consolidated data using Informatica Power Mart tool
• Tuned the Informatica mappings and the database sql for better performance of the application
• Developed and tested all the backend programs, Informatica mappings and update processes
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse and datamart.

Environment: Informatica 6.2, Oracle 9i, Toad, SQL Server 2000,Oracle 9i,Windows NT 4,Sun Solaris 8

Confidential

ETL Developer

Responsibilities:

• Developed a dimensional model that identifies the fact table grain, associated dimensions, attributes, and hierarchical drill paths
• The data mart was built using Star Schema data model to look at the invoice amounts from various dimensions like customer, vendor, billing
• Developed Informatica mappings using transformations like Lookup, Stored Procedure, Filter, Expression, Aggregator
• Developed test cases for validating the ETL processes
• Improved the performance of long running jobs by updating the SQL statements and creating indexes.
• Developed SQL, PL/SQL, stored procedures, triggers, cursors for implementing business rules and transformations
• Published Informatica metadata standards and definitions for easy understanding of critical business data

Environment: Informatica PowerMart 5.1, Oracle 8i, PL/SQL, SQL Plus, Windows NT