SUMMARY

• 8+ years of Information Technology Experience with specialization in Business Intelligence - Informatica and Business Objects.
• Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (PowerCenter/ PowerMart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects
• Implementation of full lifecycle in Data warehouses and Business Data marts with Star Schema and Snowflake Schemas.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using ETL.
• Expertise in Data Warehouse/Data Mart, ODS, OLTP and OLAP implementations teamed with project scope, analysis, requirements gathering, data modeling, effort estimation
• ETL design, development, system testing, implementation and production support.
• Used transformations like Joiner, Expression, Connected and Unconnected Lookups, Filter, Aggregator, Stored Procedure, Rank, Update Strategy, Java Transformation, Router and Sequence generator.
• Good experience in ITIL methodologies.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Extensively usedTeradata Utilities likeFast-Load, MultiLoad, BTEQ & Fast-Export.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Proficient in coding of optimizedTeradata batch processing scriptsfor data transformation, aggregation and load usingBTEQ.
• Varied experience in Designing and developing the complex mappings from various Transformations.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica
• Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Performed reverse-engineering from Informatica codes, UNIX shell scripts, Teradata BTEQ scripts, stored procedures, metadata to understand the existing process, data and relationships.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Exposure to Domains like Retail and Telecom.
• Possess excellent communication, decision-making, Problem Solving, Analytical, and Interpersonal skills with result oriented dedication towards goals.
• Capable of working as a Team Member or Individually with minimum supervision.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

TECHNICAL SKILLS

Operating System: Windows 2008/2007/2005/ NT/XP, UNIX, MS-DOS.

ETL Tools: Informatica Power Center 9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager Workflow Monitor, BTEQ, Repository manager and Informatica Server).

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, DB2 v8.1, Teradata.

OLAP Tools: Business Objects XI 3.1/3.0, XI R1/R2, 6.5, Web Intelligence XI 3.1/3.0/XI R2Universe Designer XI 3.1/3.0, XI R2, Desktop Intelligence, InfoView, CMC, Import wizard, Report Conversion Tool, Data Integrator 11.5/XI 3.0, Business Objects 4.x.

Languages: SQL, PL/SQL.

Database: Teradata, Oracle.

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

BI DW Developer

Responsibilities:

• Interact with the Business users for requirement gathering.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Analyzed the Source System and involved in designing the ETL data load.
• Developed the ETL Mappings with Complex Transformations.
• Developed joiner transformation for extracting data from multiple sources
• Working with Transformations like Source Qualifier, Lookup, Update Strategy, Aggregator, Router, Expression and Joiner Using Informatica.
• Involved in Enhancement of existing applications.
• Extensively involved in Unit testing and responsible for fixing the Program defects.
• Involved in testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Developed Informatica Mappings, Mapplets and Transformations to load data from relational and flat file sources into the data warehouse.
• Developed advanced reusable mapplets for SCD and fact loading.
• Created and Executed workflows and Worklets using Workflow Manager to load the data into the Target Database.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database.
• Loaded data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, Fastexport, Multi Load, Fastload and Informatica.
• Analyzed all the critical and High priority defects and fully responsible for fixing it.
• Scheduled, Executed and Monitored sessions by using Informatica Workflow Manager.
• Configured workflows with Email Task, which would send mail with session, log for Failure of a sessions and for Target Failed Rows.
• Modified and implemented the existing applications mappings, workflows, design documents and test cases for better performance.

Environment: Informatica Power Center 9.0.1/8.6, Oracle 11g, SQL Server 2008/2005, DB2, Teradata, Flat Files, CSV files, PL/SQL (Stored Procedure, Trigger, Packages), UNIX, Toad

Confidential, Dublin, OH

BI DW Developer

Responsibilities:

• Involved in full life cycle development including Design, ETL strategy, troubleshooting, reporting, and Identifying facts and dimensions.
• Prepared the required application design documents based on functionality required.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width), and Excel files to staging database and from staging to the target Teradata Warehouse database.
• Wrote Queries, Procedures and functions that are used as part of different application modules.
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
• Created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Involved in Dimensional modeling (Star Schema) of the Data Warehouse and used ERwin to design the business process, dimensions and measured facts.
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.
• Involved in cleansing and extraction of data and defined quality process for the warehouse.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Involved in migration of mappings and sessions from development repository to production repository.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Used Web Services for authentication of the end users.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
• Prepared low level technical design document and participated inbuild/reviewof theBTEQ Scripts, FastExports, MultiloadsandFast Load scripts, Reviewed Unit Test Plans&System Test cases.
• Wrote SQL queries, PL/SQL programming and Query Level Performance tuning.
• Conduct status meetings with project managers, escalate issues when necessary, conducts meetings for issues resolution.
• Interacted with Lead Developers, System Analysts, Business Users, Architects, Test Analysts, Project Managers and peer developers to analyze system requirements, design and develop software applications.
• Created new extracts for external vendors and use Informatica ETLs for new workflows to move data out of multiple data sources.
• Unit test coding changes, fill out required documentation such as installation instructions, and follow standards and procedures.
• Provided Tier l support duties for Informatica Production Support, including off hours and weekends. Keep the Production Support team management informed of any issues or concerns.

Environment: Informatica9.X/Informatica PowerCenter9.5.1/8.6, Power Exchange, Teradata, Autosys, UNIX, Ultra Edit, WinSQL, WinSCP, MS ACCESS, Windows NT, Oracle 9i/10g, DB2, Teradata, Mainframe, ERwin 4.0, ILM-Data Archiving 6.1, SQL, PL/SQL, Confidential -SQL, TOAD, CARS, XML, Test link, HP Service Manager, Lotus Notes.

Confidential, Minneapolis, MN

BI DW Developer

Responsibilities:

• Involved in Analyzing the System requirements, implementation of star schema & Involved in designing and development of data warehouse environment.
• Gathered requirements with Business Users and converted them into project documentation.
• Performed unit testing, system integration testing, and supported user acceptance testing.
• Extensively worked with Informatica - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer
• Workflow Manager, and Workflow Monitor to develop various complex mappings, mapplets, reusable transformations, session tasks and Workflows.
• Led team of 5 and also worked with them in developing and delivering the project on time.
• Prepared ER Diagram to get DB Governance Approvals from DBAs to create new set of DB Structures and relations.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Responsible for Performance Tuning Confidential the Source level, Target level, Mapping Level and Session Level.
• Used Workflow manager to create and configure workflow and session task to load data. Used Informatica workflow monitor to create, monitor workflow in case of process failures.
• Developed Re usable Transformations, and Re-Usable Mapplets.
• Worked with Shortcuts across Shared and Non Shared Folders.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
• Created mapplets for reusing transformation logic in multiple mappings.
• Wrote the PL/SQL procedures for data extraction, transformation and loading.
• Extensively worked on Business Objects XI R3/6.5.
• Resolved loops by creating Aliases.
• Performed the Integrity check and finally exported to the repository.
• Generated various Full clients, thick client reports as per the requirement.
• Created reports using multiple data providers.
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, variables and Formulae etc.
• Modified reports according to the client’s requirement and deploying to the production.
• Resolved many issues faced during the Production support.

Environment: Informatica Power Center 8.6, Teradata, Repository Manager, Designer, Work Flow Manager, Business Objects XI R3/6.5, Business Objects 4.x, Oracle 11g/10g, SQL Server 2008/2005, DB2, Flat Files, CSV files, Toad.

Confidential, Dallas, TX

Informatica ETL-BO Developer

Responsibilities:

• Involved in taking the requirements from Client.
• Extensively worked with Informatica - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer
• Workflow Manager, and Workflow Monitor to develop various complex mappings, mapplets, reusable transformations, session tasks and Workflows.
• Prepared ER Diagram to get DB Governance Approvals from DBAs to create new set of DB
• Structures and relations.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Responsible for Performance Tuning Confidential the Source level, Target level, Mapping Level and Session Level.
• Used Workflow manager to create and configure workflow and session task to load data. Used Informatica workflow monitor to create, monitor workflow in case of process failures.
• Developed Re usable Transformations, and Re-Usable Mapplets.
• Worked with Shortcuts across Shared and Non Shared Folders.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter,
• Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
• Created mapplets for reusing transformation logic in multiple mappings.
• Wrote the PL/SQL procedures for data extraction, transformation and loading.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Established user groups and users, assigned privileges and deleted, enabled and disabled user accounts.
• Prepared the Detail design as per the client’s requirement and prepared Unit test plans, Unit Test Cases and uploaded to the Quality center.
• Created Universes from multiple databases using Designer module.
• As a part of universe development created Classes, different kind of Objects.
• Working with linked universes.
• Specified the Joins and checked the cardinalities.
• Resolved loops by creating Aliases.
• Performed the Integrity check and finally exported to the repository.
• Generated various Full clients, thick client reports as per the requirement.
• Created reports using multiple data providers.
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, variables and Formulae etc.
• Modified reports according to the client’s requirement and deploying to the production.
• Resolved many issues faced during the Production support.
• Performed sanity testing in the production.

Environment: Informatica - Power Center 8, MS SQL Server Integration Services (SSIS), Business Objects XI R3/6.5, Oracle and Teradata.