SUMMARY

• Over 8 years of total IT experience and Technical proficiency in the Data Warehousing teamed with Data Analysis, Data Modeling, Business Requirements Analysis, Application Design, Development & Testing, Data profiling, data standardization & Quality Control and full life cycle Implementation of Data Warehouse.
• Strong knowledge and experience in various sectors like banking, finance, health care, pharmacies, supermarkets and network communications.
• Proficiency in interviewing stakeholders, requirements analysis and realization using Use Cases, deriving testable functional / non - functional system requirements, providing strategic and tactical inputs and coordinating with business functions and technical project teams from conception through deployment.
• Involved in Requirement gathering, Data Analysis, Application Design, Data Modeling, Application Development, Implementations and Data Quality in different Data warehouse Projects.
• Experience in designing complex ETL/ELT solutions for Data Warehouse Programs.
• Experience in both integration and reporting areas of Data Warehouse using Informatica, Cognos, Business Objects, Teradata and Oracle.
• Erudite in Preparing word documentation and Visio diagrams to depict business processes better.
• Strong Data Warehousing experience in Application development & Quality Assurance testing using Informatica Power Center 9.1/8.6/7.1 Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), Power Exchange, OLAP, OLTP.
• Experience working with multiple Data Sources including Legacy Data, SAP and Third Party Data Providers.
• Hands-on experience with programming on high-performance / distributed computing systems.
• Experience in developing and implementing Statistical analysis OR Dimension Modeling.
• Experience in Data Analytics / DW / BI.
• Experience in P & C Insurance for protecting Risk.
• Experience Data migration from existing data stores and developing capacity plans for new and existing systems.
• Extensive Experience in developing and performance tuning of Informatica mappings.
• Erudite in Using Pushdown Optimization feature of Informatica.
• Experience in Configuration and working on developing maps using Power exchange for SAP& DB2.
• Extensive knowledge with Teradata SQL Assistant, PUMP, Fast Export, Fast Load, Multiload, BTEQ, Coded complex scripts for the Teradata Utilities and finely tuned the queries to enhance performance.
• Worked extensively on performance tuning of ETL maps and considerably decreased the ETL load timings
• Extensively worked with various systems like Oracle, Teradata, MS Access, Flat files, XML and Mainframe, SAP BW, SQL Server.
• Sound understanding of the value and meaning of information, data quality and metadata
• Ability in Strong presentation, verbal and written communication skills.

TECHNICAL SKILLS

ETL Tools: Informatica 9.x/8.x/7.x/6.x/5.x PowerCenter / PowerMart / PowerConnect, WorkFlow Manager, WorkFlow Monitor, Designer, Server Manager, Repository Manager, MDM Informatica.

OLAP Tools: BusinessObjects XIR2/6.x/5i, Designer, Crystal Reports, Web intelligent, Supervisor, SAP R/3, Oracle Discoverer Administrator/Desktop.

Databases: Oracle 10g/9i/8i/7.3, MS-SQL Server 2000/7.0, DB2, Teradata, MS Access 97/2000, MPP, No-SQL or Graph DB.

Operating Systems: Windows NT 4.0/2000/XP/98/95, UNIX, OS/390, AS/400.

Languages: C, C++, UNIX Shell Scripts, J2EE, SQL, Transact-SQL, PL/SQL, COBOL, and Visual Basic 6.0/. Net, XML, Java Script and VB Script

Methodology: Ralph Kimball, Inmon

Web Tech: HTML/DHTML, JavaScript, JMS

GUI and Other: Oracle Designer, Reports, PLSQL, TOAD 8.x/7.x/6.x, SQL Loader, Erwin, Crystal Reports, PVCS VM and PVCS Tracker, CONNX

PROFESSIONAL EXPERIENCE

Confidential, Dallas TX

Sr. Informatica Developer

Responsibilities:

• As a Sr ETL developer provided suggestions and improvements to adhere to the standards.
• Prepared the Code Review Checklist, Standards document and Reusable components to be used across multiple projects. Work on the risk associated with the Property and Causality insurance related issues.
• Actively involved in creating design specifications and ETL design documents
• Created Informatica Mappings to load data and used transformations like Stored procedure transformation, Connected and Unconnected lookups, Source Qualifier, Expression, Sorter, Aggregator, Joiner, Filters, Sequence, Router and Update Strategy and XML transformation
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as Mapplets using Informatica Designer
• Extensively worked on UNIX Shell scripting and BTEQs to extract the data from the warehouse
• Involved in Performance Tuning (Both Database and Informatica) and there by decreased the load time.
• Used Push Down Optimization and Partitioning to improve the performance on Informatica
• Involved in Design review, code review, Performance analysis.

Environment: Informatica Power Center 9.5, Informatica Power Connect, Oracle 11g, SQL server 2010, PL/SQL Procedures, TOAD, ESP Scheduler, s Mainframes, UNIX, PUTTY, VSE Connector.

Confidential, Irving, TX

Sr. Informatica Developer

Responsibilities:

• Responsible for ETL design & implementation to source CRM data from Siebel to Business Warehouse.
• Involved in requirement analysis, ETL design and development for extracting data from the source systems like Oracle, flat files, XML files and loading into data mart using VSE Connector.
• Worked with analysts and data source systems experts to map requirements to ETL code.
• Worked on developing UNIX and Perl Scripts for file parsing and job automations.
• Developed complex mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Router, Update strategy and Sequence generator.
• Converted functional specifications into technical specifications (design of mapping documents).
• Used Autosys,CRON to schedule jobs.
• Worked on administering Informatica 8.6 and 9.5 on windows environment before UNIX migration.
• Created deployment groups to deploy objects.
• Responsible for design and implementation needed for loading and updating the warehouse.
• Worked with Session logs and Work flow logs for Error handling and troubleshooting in Dev environment.
• Created scripts for better handling of incoming source files such as moving files from one directory to another directory and extracting information from file names, such as date, for continuously incoming sources.
• Wrote scripts to ensure e-mails sent to respective people on Failure/Success, error handling, control auditing of different processes.
• Involved in Performance Tuning of existing mappings as well as new ones.
• Wrote complex SQL scripts to avoid Informatica joiners and Look-ups
• Coordinated with DBA’s in resolving the database issues that lead to production job failures.
• Migrated code/objects from the development environment to the QA/testing environment to facilitate the testing of all objects developed and check their consistency end to end on the new environment.
• Involved extensively in Unit testing, integration testing, system testing and UAT.

Environment: Informatica Power Center 9.1, MDM, Informatica Power Connect SAP R/3,OBIEE 11g, Oracle 11g, SQL server 2010, PL/SQL Procedures, TOAD, Perl scripts, Rational Clear case, Autosys, MKS Integrity Client, MS Visio, ALM, Mainframes, UNIX, PUTTY, VSE Connector.

Confidential, Rockaway, NJ

Sr. Informatica Developer

Responsibilities:

• Involved in Requirement Analysis, ETL Design and Development for extracting from the source systems and loading it into the Datamart.
• Involving in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment
• Interacted with the source system to gather the requirements.
• Gathered requirement and prepared mapping documents and the data flow documents.
• Extensively used ETL to load data from multiple sources toStaging area(SQL Server 2008) usingInformatica PowerCenter 8.6Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of IdentifyingFact and Dimension tables.
• Worked with power Center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Maplet Designer and Mapping Designer.
• Experience analyzing user requirements and translating them into system data structure designs.
• Extensively used Informatica Transformation like Source Qualifier, Rank, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.
• Solid Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Involved in writing T-SQL Procedures Using SQL Server.
• Involved in the developing & debugging of Sybase and SQL server procedures.
• Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join in the Joiner transformation.
• Developed Reusable Transformations and Reusable Maplets.
• Worked extensively with Session Parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Created reusable transformations and mapplets and used them in mappings
• Tuned sources, targets, mappings and sessions to improve the performance of data load
• Involved inPerformance tuningfor sources, targets, mappings, and sessions.
• Expertise in using Power Exchange in conversion of files and creating data maps.
• Performedunittestingon the Informatica code by running it in theDebuggerand writing simple test scripts in the database thereby tuning it by identifying and eliminating thebottlenecksfor optimumperformance.
• Involved in Production Support.

Environment: Informatica Power Center 8.6, Informatica Power Exchange 8.x, Mainframes, Oracle 10g, SQL Server 2008, UNIX, PUTTY and MS Visio.

Confidential, Newark NJ

Sr. Informatica Developer

Responsibilities:

• Involved in identifying data ownership/responsibility, requirement gathering, data mapping, mapping design, analysis, validation, and consolidation of source system, defining error and restart logic, and quality assurance and production environment.
• Involved in requirement analysis, ETL design and development for extracting data from the source systems like Oracle, flatfiles, XML files and loading into datamart.
• Worked with analysts and data source systems experts to map requirements to ETL code.
• Documented technical specification, business requirements, and functional specifications for the development of mappings to load data into various target tables.
• Developed complex mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Router, Update strategy and Sequence generator.
• Extensively used various oracle utilities like triggers, cursors, pl/sql procedures and functions.
• Converted functional specifications into technical specifications (design of mapping documents).
• Reviewing of design and code developed by peers.
• Developed complex mappings to load data from multiple source systems like Oracle, flat files Responsible for design and implementation needed for loading and updating the warehouse.
• Created Perl scripts for better handling of incoming source files such as moving files from one directory to another directory and extracting information from file names, such as date, for continuously incoming sources.
• Involved in Performance Tuning of existing mappings as well as new ones.
• Wrote complex SQL scripts to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.
• Coordinated with DBA’s in resolving the database issues that lead to production job failures.
• Involved extensively in Unit testing, integration testing, system testing and UAT.
• Used the Rational Clearcase for versioning the various objects like the mappings, workflows, sql scripts and Perl scripts.
• Participated in weekly end user meetings to discuss data quality, performance issues. Ways to improve data accuracy and new requirements, etc.,

Environment: Informatica Power Center 8.6, Informatica Power Exchange 8.x, Oracle 10g, PL/SQL Procedures, TOAD, Perl scripts, Rational Clear case, Tivoli Workflow scheduler, MS Visio

Confidential, Princeton NJ

Sr. Informatica Developer

Responsibilities:

• Involved in Requirement Analysis, ETL Design and Development for extracting from the source systems and loading it into the Datamart.
• Wrote Functional specifications for each of the ETL processes, working in close co-ordination with business users and development leads.
• Converted functional specifications to technical specifications (design of mapping documents).
• Developed complex mappings to load data from Source System (Oracle) and flat files
• Built re-usable mapplets using Informatica Designer.
• Used Informatica Power Center Workflow manager to create sessions and workflows to run the logic embedded in the mappings.
• Created different transformations like Source Qualifier, Expression, Router, Filter, Lookup, Sequence Generator, Normalizer transformations for loading the data into the targets.
• Wrote complex SQL scripts to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.
• Wrote scripts to ensure e-mails sent to respective people on Failure/Success, error handling, control/auditing of different processes.
• Migrated objects from the development environment to the QA/testing environment to facilitate the testing of all objects developed and check their consistency end to end on the new environment.
• Participated in weekly end user meetings to discuss data quality, performance issues. Ways to improve data accuracy and new requirements, etc.,
• Provided production support for Business Users and documented problems and solutions for running the workflows.

Environment: Informatica Power Center 8.x, HP UNIX, Oracle 9i, TOAD, Rational Clearcase, MS Visio

Confidential, McLean VA

Sr. ETL Developer

Responsibilities:

• Created different transformations to load data into targets using various transformations like Source Qualifier, Router, Joiner, Lookup, Expression, Aggregator, Sequence Generator etc.,
• Reused mapplets and transformations.
• Developed and modified mappings for Extraction, Staging, Slowly Changing Dimensions of Type1, Type2, Type3, Facts and Summary tables duly incorporating the changes to address the performance issues as stated in the Re-architecture specifications.
• Developed mappings for Slowly Changing Dimensions of Type1, Type2, Facts and Summary tables using all kinds of transformations.
• Scheduled Sessions and Batched on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Developed workflows and worklets for mappings using Workflow Manager to load data from source to target tables.
• Implemented performance tuning logic on targets, sources, mappings and sessions to provide maximum efficiency and performance.
• Designed, defined, and documented test cases and plans for testing and debugging the mappings developed.
• Used SyncSort to effectively reduce the elapsed time and speed up the ETL process.
• Involved in creating analytics workflows, On-Demand (Ad-hoc) and Scheduled dashboard reports using Power Analyser.
• Developed various reports using Power analyzer, like drill down, cross tab etc.,
• Interacted with users in troubleshooting problems reported.
• Tested data and data integrity among various sources and targets.

Environment: Informatica PowerCenter 7.1.1, HP-Unix 11i, Oracle 9i, IBM DB2 UDB 8, Microsoft VSS, TOAD, CA7 Scheduler, Test Director