SUMMARY:

• A detail oriented professional with over 9 years of experience in Analysis, Development, Testing, Implementation and Maintenance of Data Warehousing/Integration projects and knowledge on administrator part as well. Extensive experience in gathering and analyzing requirements, Gap Analysis, Scope Definition, Business Process Improvements, Project Tracking, Risk Analysis, and Change Control Management. Expertise in providing end to end BI solution by configuring metadata and building Analytics Repository, dimensional modeling design, building business models, generating reports and creating dashboards.
• Extensively involved in Informatica migration/upgrade of versions.
• Extensive exposure on Data warehousing domain with understanding of Dimensional Modeling, Star, Agile and Snowflake Schemas.
• Comprehensive knowledge of Software Development Life Cycle (SDLC), Waterfall development process, Agile - SCRUM development methodology, RDBMS, OLTP, ETL, OLAP, and DW Concepts.
• Experience in ETL methodology for supporting Data Extraction, Transformations and Loading process in a Corporate-wide- ETL solution using Informatica, SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
• Experience in Informatica PowerCenter - Mappings, Transformations, Workflow Manager, Workflow Monitor, data extraction, load process and Repository Manager.
• Identifying the bottleneck and involved in performance tuning and optimization of ETL loads both at the mapping and the session level and also at the database level.
• Proficiency in data warehousing techniques like Slowly Changing Dimensions and Big data concepts
• Experience working on PL/SQL development for multiple projects.
• Experience with ERP systems and Support.
• Data migration from different sources to Informatica.
• Involved in Enhancing & Supporting of critical applications. Closely worked with business users & provided resolution/clarification to issues during UAT phase.
• Extensively worked on scheduling tools like Autosys, Control-M for scheduling ETL workflows & assigning dependencies.
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouses.
• Experienced in Installing and Configuring Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning and developing ETL
• Informatica completed for Exam S PowerCenter 8 Mapping Design & Exam U Power Center 8 Advanced Mapping Design
• Extensive Experience in Release Management of Informatica / Oracle / UNIX packaging to Production System.
• Experience working on BMC remedies tools for Incident Management.
• Oracle EBS 11.5.10 along with Oracle BI Application 7.9.4 implemented Supply Chain Analytics.
• Extensively involved in testing activities of deliverables to production environment & supporting Go-live activities.
• Extensive exposure on Market Risk, Production support maintenance & Configuration management activities.
• Worked on developing various test cases for testing Informatica code.
• Excellent interpersonal, verbal & written communication skills. Worked extensively on onsite offshore model and proven customer management skills with business users.

TECHNICAL SKILLS:

BI Tools: OBIEE (10G, 11G), Tableau

ETL Tools: Informatica PowerCenter, Informatica MDM Multi-Domain

Scheduling Tools: Control-M, Autosys

Languages: C, Java, SQL, PL/SQL

RDBMS: Oracle, DB2, Teradata, SQL Server

Tools: /Utilities: Toad, Perl, UNIX Shell

Operating Systems: Windows, UNIX, Linux

Web Technologies: HTML, CSS, XML, JAVA SCRIPT

PROFESSIONAL EXPERIENCE:

Informatica Developer

Confidential, Plano, TX

Responsibilities:

• Working with business users and business analyst for requirements gathering and business analysis.
• Converted business requirement into high level and low level design.
• Designing and customizing data models for Data warehouse supporting data from multiple sources on real time.
• Extracted data from different flat files, MS Excel, MS Access and transformed the data based on user requirement using Informatica PowerCenter and loaded data into target, by scheduling the sessions.
• Worked on Informatica PowerCenter 9.5 tool - Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Developed Informatica mappings and also in tuning of mappings for better performance.
• Used Normalizer transformation with COBOL sources stored in DB2.
• Created reusable mapplets and Transformations starting concurrent batch process in server and did backup, recovery and tuning of sessions.
• Created sequential batches and concurrent batches for sessions.
• Developed PL/SQL procedures/packages to kickoff the SQL Loader control files/procedures to load the data into Oracle.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Created SSIS Packages to extract data from Excel Files, MS Access files using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse
• Written SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing Purposes.
• Supporting daily loads and work with business users to handle rejected data.
• Developed Interfaces using UNIX Shell Scripts to automate the bulk load & update Processes.
• Executing test scripts to verify actual results against expected results by using Power Connect for source (DB2) validation and Oracle for target validations.
• Stored reformatted data from relational, flat file, XML files using Informatica.
• Implemented data cleansing for files using Informatica and trillium.
• Done automation of file provisioning process using UNIX, Informatica mappings and Oracle utilities.

Environment: PowerCenter 9.5, Flat files, MS Excel Files, MS Access, SSIS 2008, Oracle 9i/10g, Erwin 7.3, Power Designer, MS SQL Server 2005/2000, PL/SQL, IBM DB2 8.0, Teradata V2R5, Mainframes, Toad, Perl, Unix scripting, Windows NT, Autosys, Microsoft Project Plan.

Informatica Developer

Confidential, NJ

Responsibilities:

• Involved with requirement gathering and analysis for the data marts focusing on data analysis, data quality, data mapping between ODS, staging tables and data warehouses/data marts.
• Documented user requirements, translated requirements into system solutions and developed implementation
• Extensively used all the features of Informatica Versions 9.x and 8.x including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Migrated repository and mapping from Informatica 8.6.1 to 9.0.1
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica power center.
• Extract data from flat files, Oracle, DB2, and SQL Server 2008 & MS SQL Server 2005/2008 and to load the data into the target database.
• Extensively used Informatica to load data from fixed width and delimited Flat files.
• Worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor, also imported and created Source Definitions using Source Analyzer and Target Definitions using Warehouse Designer.
• Developed complex mappings using corresponding Source, Targets and Transformations like update strategy, lookup, stored procedure, SQL, sequence generator, joiner, aggregate, Java and expression transformations in extracting data in compliance with the business logic
• Querying and analyzing multiple databases and handling the errors as per the client specifications.
• Created server optimized database routing and mappings and focused on performance tuning.
• Handling larger database queries and applying transformations to make the business solution applicable to project.
• Involved in Performance tuning.
• Created Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Wrote stored procedures in PL/SQL and UNIX Shell Scripts for automated execution of jobs
• Identified the errors by analyzing the session logs.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed Debugged the mapping of the failed session to check the progress of data load.
• Involved in Unit and System Testing of ETL Code (Mappings and Workflows)
• Scheduled workflows using autosys job plan.
• Implemented best practices suggested by Informatica to simplify deployment Process.
• Created Test scripts and executed in the Test Director.
• Worked with PMCMD to interact with Informatica Server from command mode and execute the shell scripts.
• Wrote documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 9.0.1, 8.6.1(Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console), MSSQL Server 2005/2008,Oracle 10g, DB2, Flat Files.

ETL Developer

Confidential

Responsibilities:

• Created new mappings and updating old mappings according to changes in Business logic.
• Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
• UsedETL(Informatica)to load data from source toDWH.
• UsedInformaticaclient tools -Source Analyzer,Warehouse designer,Mapping Designer,Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• ImplementedSlowly Changing Dimensions - Type I & IIin different mappings as per the requirements.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Involved in performance tuning of Targets, Sources, and Mappings. Improved performance by identifying performance bottlenecks.
• Worked on different tasks in Workflows like sessions, events raise, event wait, e-mail and timer for scheduling of the workflow.
• UsedInformaticaWorkflow ManagerandWorkflow Monitorto schedule and monitor session status.
• Used Debugger to troubleshoot the mappings.
• Developed mappings inInformaticato load the data from various sources into the Data Warehouse, using different transformations likeJoiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier.

Environment: Informatica8.6, Oracle 10g, Erwin 4.5, Oracle Applications, PL/SQL, TOAD 9.0, SQL,UNIX, Quality Center 9.0

ETL Developer

Confidential, Cincinnati

Responsibilities:

• UsedInformaticaPower Center for extraction, loading and transformation (ETL) of data in the data warehouse.
• UsedInformaticaPower CenterWorkflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Created complex mappings inPower CenterDesigner using Aggregate, Expression, Filter, Sequence Generator, Lookup, Joiner and Stored procedure transformations.
• Involved in meetings to gather information and requirements from the clients.
• Involved in Designing the ETL process to extract, translate and load data from flat files to warehouse data base.
• Involved in reading and Translating logic from SQL Server Stored Procedure and Functions intoInformaticaDesign.
• Wrote SQL Queries, PL/SQL Procedures, Functions, and Triggers for implementing business logic and for validating the data loaded into the target tables using query tool TOAD.

Environnent: Informatica Power Center 7.1, ETL, PL/SQL Developer, Oracle, UNIX, Microsoft SQL Server, TOAD.

SQL Developer

Confidential

Responsibilities:

• Worked on the design of the database to fasten certain daily jobs, stored procedures.
• Active participation and interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Altered tables and fields as per requirements and recreation of indexes.
• Development ofSQLscripts to Insert/Update and Delete data in MSSQLdatabase tables.
• Creation of views as required by front enddeveloperfor easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
• Creation of complex stored procedures and functions to support efficient data storage and manipulation.
• Usage of DDL and DML for writing triggers, stored procedures, and data manipulation.
• Scheduling of database backup and performing full, incremental and differential backups of database and transaction logs.
• Documentation of all processes involved in maintaining the database for future .
• Providing support to development staff about database related issues.

Environment: Server 2005, T-SQL, Query Analyzer, Windows NT/2000