SUMMARY:

• Around 15 years of experience in Software Development and Design in the areas of Commercial and Business Applications as a Informatica Architect, Technical Lead, & and Application Developer.
• Implemented successfully 5 very large scale End - to-End Data warehouse for fortune 500 companies
• 14 years of solid experience in using Informatica Power center, IDQ, MDM,B2B, Power Exchange and Analyst.
• Experience in extracting and integration of various data sources like Oracle, DB2, Flat Files, XML, JMS and COBOL files.
• Hands on experience on all aspects of data quality: profiling, cleansing / standardization, normalization, de-duping, merging / consolidation, fuzzy matching, data integration and reconciliation and exception transformations.
• Imported IDQ mapplet to Informatica power center and integrated in the regular mapping for cleansing, standardization and address validation issues.
• Strong knowledge in writing complex SQL queries and SQL Tuning.
• Responsible for defining the information architecture and technology infrastructure along with the design of multi-dimensional data models and the Business Intelligence delivery solutions
• Provided leadership roles including client mentoring
• Knowledge in OLAP tool like Business Object, Cognos
• Worked on the Informatica Administration.Setup a Grid in production environment to implement the High Availability functionality and resolve production performance issues & meet SLAs
• Experience in writing UNIX shell scripts
• Experience in Control-M, Tivoli, AutoSys, Espresso schedule and VSS (Version Control).
• Proficient in EDW-Data Integration from MDM systems.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Creating landing tables Staging tables Base Tables as per the data model and data sources
• Defining Trust Score Validation rules Match rules and Merge settings
• Flexibility in adapting to any new technology.

TECHNICAL SKILLS:

ETL: Informatica Power Center 9.x,Data Quality 9.x,DT Studio, Power Exchange

OLAP Tool: Business Objects, Cognos

Data Management Tools: Informatica MDM hub console,IDD

Data Modeling: ERWIN

RDBMS: Oracle 11g, Teradata,DB2,GreenPlum

Programming Language: SQL, PL/SQL,Java, Unix Shell scripts

Operating System: Sun Solaris, HP-UNIX, Linux, Win NT/2003/2008

Testing: Test Director, Quality Center, JIRA

Scheduling Tools: Control-M,Espresso,AutoSys

Other Tools: TOAD,Remedy,Clarity, Visio,Appfluent

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

Informatica Architect

Environment: Informatica Powercenter 9.x, Informatica Data quality 9.x, MDM 10.x, Power Exchange,UNIX, Oracle 11g, Green Plum, Harvest, Autosys,JIRA, Java, Protegrity,Erwin9.x,XML

• Responsible for analyzing various systems data and developing ETL solution to integrate into CDH.
• Participating in ETL design phase and creating ETL Design Specs for mappings.
• Participate in data modeling and database design.
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business.
• Developed the REAL TIME power center mappings and publish the message queues from JMS application using DT Studio.
• Analyzed the data based on requirements, wrote down the techno-functional documentations and developed complex mappings using Informatica Data Quality (IDQ) Developer to remove the noises of data using Parser, Labeler, Standardization, Case Conversion,Address Validation, Key Generator, Lookup, Decision etc Transformations and performed the unit testing for accuracy of data.
• Imported IDQ mapplet to Informatica power center and integrated in the regular mapping for cleansing, standardization and address validation issues.
• Created various power center mappings to handle the complex customer data and load into Landing tables.
• Carried out extensive profiling of new and existing data sources to detect anomalies and errors before developing the corresponding solutions to sanitize and remedy the data source.
• To deliver high-quality master data information developed and implemented data standardization, validation, enrichment, de-duplication, and consolidation rules.
• Implemented various data masking techniques to secure the sensitive production data.
• Designed developed and implemented Master Data Management solution Customer Party MDM Domain using MDM 10.x.
• Design, develop and test all Hub components like Data model, Cleanse rules, Trust, Roles and Data security, Batch processes, Metadata validation and change management.
• Implement Informatica MDM workflow including data profiling configuration specification and coding match rules tuning migration
• Participated in the Code reviews and create harvest packages to deploy the code into productions.
• Co-ordinate the development,testing and business teams during integration/UAT.

Confidential, Irving,TX

ETL Architect

Environment: Informatica 9.5.1, Informatica Data quality 9.x, UNIX, Business Objects Enterprise 4.0, DB2, Harvest, Tivoli,Erwin r7.x

• Analyze User Requirement and Design data integration solutions.
• Provide direction to team on solution approach.
• Prepare high level and low level design documents.
• Participate in data modeling and database design.
• Extensive experience designing relational and dimensional data models, deploying and supporting a large, complex data warehouse/data marts
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model
• Peer Review the Deliverables and make sure that on time delivery with quality
• Communicate with all stakeholders on delivery status
• Identified data quality issues, anomalies, patterns, based on defined business rules and created metrics and score Cards by IDQ Profiling.
• Cleansed, standardized, labeled and fix the data gaps in IDQ where it checks with reference tables to fix major business issues.
• Imported IDQ mapplet to Informatica power center and integrated in the regular mapping for cleansing, standardization and address validation issues.
• Extensively worked for address validation and name matching (Standardization)
• Involved in the ETL development and provide the technical assistance to the team.
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for creation of the universe with Classes, Objects and Condition Objects.
• Created Aliases and Contexts to resolve the Loops and Traps (fan traps and chasm traps).
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
• Work with QA team on defining test approach
• Handling L1,L2 and L3 support and make sure meet the SLA’s
• Performance tuning of the existing long running sessions/jobs.
• Perform impact analysis and handle ETL change requests based on the business rules.
• Coordinating the Onsite and Offshore team.
• Involve in researching and resolving production issues
• Perform the multi-tasking activities like Design, Development, Production support, Administration and Handling the production tickets

Confidential, Boston, MA

ETL Architect

Environment: UNIX, Informatica 8.6.1, Business Objects, Oracle 10g, Siebel, VSM, Appfluent,Erwin r7.x

• Involved in gathering requirements and created design documents and mapping documents.
• Worked at conceptual/logical/physical data model level using Erwin according to requirements.
• Assisted DBA’s in the development of physical database.
• Designed the ETL mappings and implemented High Availability features in Data warehouse
• Perform the multi-tasking activities like Design,Development, Production support, Administration and Handling the production tickets
• Assign task to the Team and monitor the development status and send the status report to the Manager
• Mentor the team and help them if any technical assistance is required.
• Involved the Informatica Administration tasks.
• Identified the long running SQL’s and fine-tuned those SQL’s with the help of appfluent tool
• Handling L1,L2 and L3 support and make sure meet the SLA’s
• Involved in the development activities for complex tasks.
• Motivate the team in the tight schedules.
• Suggested many improvements to clients and implemented those suggestions in GCDW application.
• Improved the Batch load timings by 50%
• Played the major role to change the project model from staff augmentation to the managed services.
• Code reviews & testing of the systems as per the standards.
• Created Universes by defining connections and retrieving data from database.
• Prepared reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-user.
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.

Confidential, Dallas, TX

ETL Lead

Environment: Unix, Informatica 8.1, Cognos 8.0,Oracle 10g,Espresso,Clear Quest

• Analyzing the requirements and creating Technical design specifications and mapping documents.
• Developing, Testing and Validating ETL mappings, UNIX scripts.
• Scheduling jobs through Espresso
• Co-ordinate with Testing team and resolve the defects raised during SIT
• As part of the Informatica admin install and configure informatica server in various environments, migrate the mapping into different environments, Backup repository
• Played the the role of Process Quality Lead .Co-Ordinate with QA team and provide the metrics to the QA team and also to Project Manager.
• Participate the QA and CMMi audits
• Code reviews & testing of the systems as per the standards.

Confidential, Austin,TX

Team Lead

Environment: UNIX, Ab-Initio, Teradata V2R5, Oracle 9i, Control-M, EME, Test Director 8.0

• Analyzing the requirements and creating Technical design specifications and mapping documents.
• Developing, Testing and Validating ETL flow Abinitio graphs, Teradata-BTEQ &UNIX scripts.
• Performing EME check-in/check-out through Abinitio air commands.
• Loading the transformed data file into TD staging tables through TD Utilities.
• Creating TD macro's for loading the data from staging to target tables.
• Tie-out report generation.
• Scheduling jobs through Unix-wrapper template and Control-M.
• Unit testing and validation of TD warehouse data as per standard test cases and bug fixing.
• Creation of Staging and Target Teradata objects.
• Performance tuning.
• Code reviews & testing of the systems as per the standards.
• Played the role of QCO (Quality Coordinator)

Confidential, San Francisco, CA

Developer

Environment: UNIX, Oracle 9i, Informatica Power center 7.1, Business Objects 5.1.

• Business Analysis and requirement gathering.
• Source System Study
• Gap Analysis and Data Profiling.
• ETL Lead
• ETL Architecture
• Part of a schema designing and re-designing team.
• Build complete ETL Specifications and logic buildings.
• Impact Analysis on a change request.
• Developed various kinds of mappings (simple and complex including SCD's Type 1/2/3).
• Optimizing the mapping through SQL query override.
• Optimizing the mapping to load the data in slowly changing dimension.
• Perform debugging and tuning of mapping and sessions.
• Scheduled and configured workflow and Session task to load data.
• Session tuning.
• Testing mapping to assure that data is loaded as per ETL specification.

Confidential, Irvine,CA

Senior Developer

Environment: UNIX, Oracle 9i, Informatica Power center 6.1, Cognos

• Design and creation of catalogs. Defined User Classes/Security and Privileges.
• Created Reports in Impromptu and distribution of catalog to users for ad hoc reporting and analysis.
• Extraction, Transformation and Loading of the data Using Informatica Power Center.
• Extensively used workflow manager to organize sessions, scripts and commands.
• Extensively worked in the performance tuning of the programs and ETL Procedures.
• Worked with flat file sources and relational sources.
• Extensively worked on understanding the business requirements and designing applications to meet their needs
• Created Dimension maps for Transformer and Created multidimensional Cubes in
• Power play.
• Involved in Creating and deploying of Power play web reports
• Created Standard and Ad-hoc Reports using Cognos. The reports were created using the slice & dice and drill down features and the reports included cross tab, Master Detail and simple reports.
• Generated decision support models for analysis using Cognos Powerplay
• Involved in performance tuning of Impromptu Reports
• Worked on publishing the reports in web server
• Assisted users in troubleshooting their reports.

Confidential

Developer

Environment: UNIX, Oracle 8i, Informatica Power center5.1, Business Objects, PL/SQL

• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• Developed reusable Mapplets and Transformations.
• Created and Monitored Batches and Sessions using Informatica Power Center Server.
• Involved in analyzing, coding and testing of Stored Procedures
• Responsible to tune ETL procedures and schemas to optimize load and query Performance
• Design the Universes in Business Objects.
• Extensively used Business Objects Reports.