PROFESSIONAL SUMMARY:

• Over 7+ years of IT experience in various phases of Software Development Life Cycle (SDLC) which includes Requirement gathering,analysis, design, development, testing and implementation of data warehouses as ETL Developer using Informatica.
• Experience in Business Intelligence Application using Oracle Business Intelligence (OBIEE).
• Good Understanding of data warehouseconcepts using Bill Inmon and Ralph Kimball Methodologies.
• Having good knowledge on Data Warehousing and Business intelligent concepts with emphasis on Extraction, Transformation and loading data of a business process including requirement development, testing and implementation.
• Extensive experience in Database Modeling/Designing using Erwin to design Conceptual/Logical/Physical Modeling, Forward/Reverse engineering and publishing data model and fully attributed Model(3NF) for both OLTP and OLAP systems.
• Extensive ETL experience using Informatica Power Center Client tools (Power Center Designer, Workflow Manager, Workflow Monitor, Repository Manager), Power Center Designer tools (Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer).
• Extensive experience in designing and developing mappings,mapplets, transformations and reusable transformations using Informatica Designer.
• Proficient in designing, scheduling and creating sessions, workflows and worklets using Informatica WorkflowManager and monitoring using Informatica Workflow Monitor.
• Good knowledge of Extraction, Transformation and Loading of data from heterogeneous source systems like Flat files, Excel, XML, MySQL, Oracle, SQL Server .
• Experience in working on Entity - Relationship concepts, Facts and dimensions tables, slowly changing dimensions, Dimensional Modeling (Star Schema and Snow Flake Schema), Normalization and De normalization Concepts.
• Good experience in documenting the entireETL process flow for better maintenance and analyzing the process.
• Implemented performance tuning techniques by identifying bottlenecks in source, target, transformations, mappings and sessions levels to improve performance and resolving various components.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector, global and local Filters) using OBIEE and gaveEnd User .
• Experience On Informatica Administration tasks like Informatica Installation, Start/Stop,and Restore/Back up Informatica repository services.
• Experience in provingOn Call Support for Production Problem Resolution.
• Excellent communication, interpersonal and problem solving skills with the ability to work in a team or independently.

TECHNICAL SKILLS:

ETL Tools: InformaticaPower Center 9.x/8.x, Power Exchange, Data Analyzer, Oracle Warehouse builder.

Reporting Tools: Business Objects,OBIEE, Siebel Analytics, Crystal reports.

Databases: Oracle 9i/10g/11g, SQL-ServerDB2 and MS Access, My SQL.

Tools: and Utilities: Erwin 4.0/3.5.2, MS-Visio, TOAD,SQL Developer, SQL Server Management Studio, SQL* plus,Autopsy s.

Languagesand Web Technologies: HTML, XML, XSD, JavaScript, SQL, PL/SQL,C, UNIX Shell Script, Perl Script

Operating Systems: Windows 7 /vista /XP/98/2000,UNIX, LINUX.

PROFESSIONAL EXPERIENCE:

Confidential, Little Rock, AR.

Sr.ETL Developer.

Responsibilities:

• Involved in the requirements definition and analysis and creation of high level and detailed design and mapping documents.
• Worked with high volumes of datasets from various sources like DB2, text files, and relational tables.
• Created the Repository, maintained source definitions, transformation rules, and target definitions using Informatica Repository Manager.
• Created Mapplets, Reusable Transformations and used them in different mappings.
• Created Workflows and used various tasks like Email, Timer, Scheduler, Control, Decision and Session in the Workflow Manager.
• Invoked stored procedures to perform database operations as a part of post-session and pre-session commands.
• Extensively used the transformations such as router (for creating multiple data pipelines), lookup connected & unconnected, update strategy (to define insert/update/delete/reject), aggregator, and sequence generator (for generating surrogate keys).
• Responsible for tuning ETL mappings and sessions via source qualifier/lookup overrides to optimize load and query performance.
• Used the feature Explain Plan to find out the bottlenecks in a given query for improving the performance of the job.
• Defined parameters and variables to increase their usability in mappings.
• Created multiple partitions in sessions to allow the data to be loaded concurrently.
• Involved in Unit Testing and System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Tracked issues that occurred during integration testing, which were then fixed and deployed to concerned environment.
• Developed Unix Shell scripts as part of the ETL process to schedule tasks/sessions using Autosy’s.

Environment: Informatica Power Center 9.5, DB2, TOAD, IBM DT Studio, SQL, PL/SQL, Unix, and Windows.

Confidential, Santa Cruz, CA.

Sr.ETL Developer.

Responsibilities:

• Involved in the requirements gathering,designing,and development, deploying and testing phases of the Data warehouse.
• Actively participated in understanding the business requirements by partnering with business and application developers to create conceptual, logical and physical data models.
• Involved working with business analysts in understanding, translating the business requirements into functional requirements and documenting High Level Design’s (HLD) and Low Level Design’s (LLD).
• Participated in weekly end user meetings to discuss Data Quality, Performance issues and ways to improve data accuracy and new requirements.
• Involved in migration of ETL environment, database objects, Informatica mappings, workflows in all the phases (DEV,QA,SIT,UAT,PROD and Post Prod repositories ) of the Project.
• Responsible for creating the ETL mappings for all the dimensions and facts in the data mart.
• Extract and transform the data from multiple sources (Oracle, SQL Server, Flat File, XML) and load into Oracle tables.
• Developed numerous complex mappings using various transformations like Source Qualifier,Expression,Union,Aggregator, connected & unconnected lookup, Joiner,Filter,Router, sequence generator,etc.
• Implemented slowly changing dimensions (SCD’s) to maintain current data as well as the Historical data.
• Developed reusable transformations, mappletsto reduce the development time.
• Responsible for pest practices like naming conventions, Performance tuning and Error Handling.
• Used Informatica Repository Manager to create user groups and users, and managed users by setting up their privileges and profile.
• Worked on PL/SQL scripts as part of the process to develop scripts to handle different scenarios.
• Implemented various loads like Daily loads, Weeklyloads, Quarterly Loads using incremental loading strategy.
• Responsible for troubleshooting the failure loads using workflow logs, session logs and debugging the mapping using the debugger to test the data flow, handle the error and to fix the mappings.
• Involved in performance tuning at source,target,mapping, session and system level to identify and remove the bottlenecks.
• Performed Informatica Administrative jobs like to Start and Stop the Informatica Repository and server process, restore and back up the repository.
• Involved in coding UNIX scripts to automate multiples ETL jobs and to enable/disable ETL loads through Informatica Admin console.
• Worked with end users to develop and collect feedbacks in the User Acceptance Testing (UAT).
• Involved in production deployment,and was part of production supportteam.
• Experience in generating various reports using business Intelligence tool OBIEE.
• Worked on end user, guiding them in generating reports, designing dashboards and suggesting better ways of reporting in OBIEE so that the required information is visualized by end users.

Environment: Informatica 9.x/8.x,UNIX,OBIEE, Oracle 11g/10g, SQL Server, PL/SQL, Flat files, XML,Toad.

Confidential, San Jose, CA

ETL Developer.

Responsibilities:

• Responsible for gathering requirements from business analysts and documenting them into detailed functional and technical specifications.
• Participated in daily standup meeting to discuss on project updates and deliverables.
• Worked with data modelers in preparing logical and physical data models using Erwin.
• Responsible for creating User Folders and grant privileges to user to access the objects in the repository.
• Developed enterprise data warehouse system, including translation of source data into the target EDW.
• Developed mappings to extract data from various sources like Oracle, Excel Spread sheets,Flat files, SQL Server and load into staging area.
• Developed complex mappings from scratch and was responsible in tuning the coded mappings that were previously implemented.
• Performed data manipulations using transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions, Aggregator, Union transformations to pipeline data flow.
• Developed reusable transformation objects such as mapplets to avoid duplication of metadata and reducing the development time.
• Implemented Slowly changing dimensions - Type I & II in different mappings as per the requirements.
• Created sessions, work flows, worklets using Informatica workflow manager and scheduling them and monitoring the workflows using workflow monitor.
• Worked with reporting team to analyze what level of complexity to be handled by ETL.
• Worked on Performance tuning of the complex mappings,transformations, sessions and SQL queries to achieve faster data loads to the data warehouse.
• Responsible in handling the Unix scripts to schedule informatica jobs and Developed Stored Procedures, Functions, database Triggers and created Packages in PL/SQL to access databases.
• Involved in unit testing and integration testing of informatica sessions and workflows.
• Responsible for assigning work and scheduling meetings for coordinating with offshore team on the development activities.
• Created reports using Business Objects and worked on scheduling them.
• Developed of Business Objects Universe, which suits the standard, analytical and reporting requirement and Implemented Object level security and row level security in the Universe to restrict certain data to group of users.

Environment: Informatica8.x,UNIX, Business Objects, Oracle 11g, SQL Server, PL/SQL, Toad.

Confidential

INFORMATICA Developer.

Responsibilities:

• Involved in coordinating with business users, business analysts, DBA’s for requirement gathering and understand the needs and to implement the same in designing the data ware house.
• Prepared technical specifications based on the businessrequirements to develop Informatica mappings to load data into data warehouse confirming the business rules.
• Assisted with the data modelers in designing logical / physical data models using Erwin.
• Used informatica for extraction, transformation and load the data into the data ware house.
• Developed mapping using informatica designer to load the data from various source systems like Oracle, Excel Spread Sheets, Delimited Flat files etc.
• Prepared SQL queries to validate the data in both the source and the target systems.
• Extensively worked in manipulating the data by using various Active and Passive transformations like source qualifier,expression,union,joiner,aggregator, sequence generator, lookup, router, update strategy etc.
• Tuned the existing mappings and sessions to perform better using different logics to provide maximum efficiency and overcome the bottlenecks at various level.
• Created the sessions and the workflows and scheduling them on daily and weekly basis.
• Submitted status reports to the concerned business managers on weekly basis.
• Used UNIX shell scripts to automate daily and weekly runs and execute Pre and Post session commands.
• Involved in database development by creating PL/SQL functions,procedures, triggers and packages to increase the performance.
• Responsible in migrating the mapping, workflows and informatica objects in various environments and testing the process in each environments.
• Involved in Unit testing, integration testing and in User Acceptance testing at the client location testing with the users, interacting with the business users and handling the changes.
• Developed UNIX shell scripts, Perl scripts to format the session log files and to extract the information from error logs.
• Generating SQL scripts for database objects like creating tables,indexes,views, sequences in development and production environment.
• Worked with production support team in troubleshooting and load failure cases
• Interacted with end users and reporting team to ensure the correct data is presented in the reports.

Environment: Informatica8.x, SQL server,Oracle, SQL, PL/SQL, Erwin, UNIX, XML, TOAD.

Confidential

Oracle Developer.

Responsibilities:

• Designed and developed data tables to store employee payroll information.
• Involved in design and development of data models using ERWIN data modeler.
• Interacted with end users to prepare system requirements
• Identify the data and activities that need to be maintained.
• Created primary database storage structures (Table spaces) and Objects (Tables, Views, Indexes, Sequences).
• Developed Application programs usingOracle, PL/SQLPackages, Procedures, Functions and Database Triggers.
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR LOOPS, WHILE LOOPS while developing procedures.
• Generated daily, weekly and monthly based reports to designated managers and clients
• Solving user end issues for accessing applications.
• Monitoring daily loads to collect statistics, security trails and space estimates for new tables.
• Supported technical teams involved with Oracle issues and operations.
• Involved in Implementation and production Support of the system.
• Documented the whole process flow PL/SQL packages, locations and descriptions.
• Responsible for back up and restoration of SQL Reporting Service.

Environment: Oracle 9i,SQL, PL/SQL, Java, J2EE, UNIX, Forms and Reports.