PROFESSIONAL SUMMARY:

• 12 + years of IT experience in design, analysis, development, documentation, coding, and implementation including Databases, Data Warehouse, ETL Design, Oracle, PL/SQL, Teradata, SQL Server databases, Informatica Power Center 10.x/ 9.x/8.x/7.x, SAPBI and OBIEE.
• Strong experience in Systems Analysis, Design, Development and Implementation of DWH projects as ETL developer and e xperience in working with Informatica Transformations and Teradata utilities.
• Expertise in the ETL Tool Informatica and have extensive experience in Power Center Client tools including Designer, Repository Manager, Workflow Manager/ Workflow Monitor.
• Extensively worked with complex mappings using various transformations like Filter, Joiner, Router, Source Qualifier, Expression, Union, Unconnected and Connected Lookup, Aggregator, Stored Procedure, XML Parser, Normalize, Sequence Generator, Update Strategy, Reusable Transformations, User Defined Functions, etc.
• Experience in all phases of Software Development Life Cycle (SDLC) including analysis, design, development, testing, documentation, data validation, systems integration, implementation support and maintenance.
• Expertise in Data warehousing concepts like OLTP/OLAP System Study, Analysis, and E - R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional, and multidimensional data modeling.
• Hands-on experience in Informatica upgrades.
• Experienced in mapping techniques for Type 1, Type 2, and Type 3 Slowly Changing Dimensions
• Strong experience in SQL, PL/SQL, Tables, Database Links, Materialized Views, Synonyms, Sequences, Stored Procedures, Functions, Packages, Triggers, Joins, Unions, Cursors, Collections, and Indexes in Oracle.
• Good exposure in SAP Business objects and OBIEE 11g/12c .
• Good experience in Confidential Reconciliation Tool (7.0, 7.4, 7.5 versions) Admin and Rich clients.
• Extensively used parallel hints , MOD functions in Informatica to improve the load performance. Used Constraint based load order in ETL’s to populate data into multiple target table in a single flow mapping where relation integrity exists (3 NF tables).
• Expertise in handling the Problem management, Release Management and the Change Management.
• Proficiency in working with Teradata utilities like (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, Teradata Administrator, SQL Assistant, PMON, Visual Explain).
• Good experience in Analyzing ERP systems GL,BV, QTC and CG1 data into TRECS, Cscore and HFM environments.
• Extensive and proven experience in writing simple and complex SQL queries using Joins, Analytical Functions, Inline views.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Involved in SDLC- software development life cycle (Water, Scrum/Agile) of building a Data Warehouse on windows and Unix Platforms and used Rally for user stories.
• Well versed with onsite/offshore project delivery model and experience in working with offshore teams.
• Performed the uploading and downloading of flat files from UNIX server using FTP.
• Supported in data refreshes for downstream testing like EA extracts from HFM to Oracle database and vice versa .
• Extensively used Tidal/Control M Scheduler to schedule Jobs.
• Excellent team player at all levels with ability to perform independently with exceptional communication, analytical, presentation and problem solving skills.
• Leading the project from Analyis phase until production delivery and contineous support.
• Responsible for day-to-day tasks like handling Service Requests, incidents and regularly smoke test.
• Monitoring the daily Data and Metadata Load and working on fixing Errors if there are any.
• Working on RCA’s for P1/P2 issues and PBI Management.
• Raising SR’s and working with oracle for Product Bugs and during technical issues.
• Analyzing and applying the patches suggested by TRINTECH for TRECS .
• Running Adhoc jobs to refresh Data during month/Quarter end activities for the Hyperion(HFM Applications) whenever there is a request after regular schedule .
• Providing evidences for Sox Controls Monthly & Qtrly.

TECHNICAL SKILLS:

Database: ORACLE, TERADATA, SQL SERVER

Business Areas: Applications & Systems Analysis, Design and Development, Capital and Marketing, Finance, Operations

Tools:: INFORMATICA, OBIEE, TRECS

Primary Skills: INFORMATICA, ORACLE PL/SQL, OBIEE

Secondary Skills: TERADATA, SAPBO, Hyperion FDMEE 11X, Core JAVA.

Third Party tools: APPDB, JAVA ECLIPSE, UDEPLOY, TIDAL, RALLY (User Stories), ART, ESP SERVICE NOW, CONTROL M.

Operating Systems: Windows XP,Unix/Linux

PROFESSIONAL EXPERIENCE:

Confidential, CA

Responsibilities:

• Analyze business requirements, Design and Develop ETL processes to load data from GL ERP systems to FDMEE, TRECS Systems by using Informatica ETL.
• Installation of TRECS 7.5 version (Upgrade from 7.0 to 7.5) in Windows and installation of s.
• Modifying the existing Java Jar files and deployed via Jenkins Build to other environments.
• Analyze Oracle ERP GL data for the new entities and new posted transactions before loading into TRECS.
• Collaborate with various stakeholders, including Project Managers, IT Team, Business End Users, Process Owners, QA Team, Database administrators, System Administrators for troubleshooting and resolving various complex issues within the given SLA.
• Worked with Connected and Unconnected Stored Procedure for pre & post load sessions.
• Designed and Developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Performing load testing via NEO Load with 100/200/300 concurrent users on TRECS 7.5.
• Monitoring the daily Data and Metadata Load and working on fixing Errors if there are any.
• Running Adhoc ETL jobs for both Data and OBIEE Reports whenever there is a request.
• Modifying existing PL/SQL procedure and triggers to accommodate the changes.
• Prepared Test Strategy and Test Plans for Unit, SIT, UAT and Performance testing.
• Replicating fail over scenario’s (from production) in lower environment with upgrade versions for UAT/BAT.

Environment: Oracle, Informatica, TRECS, OBIEE, TIDAL, UDeploy, APPDB, Unix and Windows

Confidential, CA

Responsibilities:

• Analyze business requirements, Design and Develop ETL processes to load data from GL ERP systems to FDMEE by using Informatica ETL.
• Used complex transformations like Lookup, Update Strategy, Sequence Generator and Stored Procedure while Developing Mapplets and Mappings using Informatica Designer Tool.
• Created primary keys, indexes, views, triggers for easy data retrieval as well as for data integrity.
• Perform unit testing and user acceptance testing to check whether the data being loaded into the target, which was extracted from different source systems according to the user requirement, is accurate. Involve in the execution of test plans for loading the data successfully into the targets.
• Perform code migration by providing quality deployment documentation .
• Collaborate with various stakeholders, including Project Managers, IT Team, Business End Users, Process Owners, QA Team, Database administrators, System Administrators for troubleshooting and resolving various complex issues within the given SLA.
• Proactively think and apply strategies for easy maintenance and debuggingTuned mappings for better performance and scheduled the ETL’s via TIDAL tool for daily, hourly and monthly basis.
• Developed various Complex Queries, Views for generating Reports.
• Performed SQL and PLSQL tuning and Application tuning using various tools like EXPLAIN PLAN.
• Deliver high quality project artifacts as per the requirements within the stipulated time frame.
• Managing customer expectations and keeping higher management updated via regular status updates.

Environment: Oracle, Informatica, OBIEE, TIDAL, UDeploy and APPDB, Unix and Windows

Confidential, CA

Responsibilities:

• Analyze business requirements, Design and Develop ETL processes to load data from various legacy sources by extracting Flat files, XML files from Source systems, apply complex transformations and load into Oracle Database.
• Used complex transformations like Lookup, Update Strategy, Sequence Generator and Stored Procedure while Developing Mapplets and Mappings using Informatica Designer Tool.
• Involved in Performance Tuning at mapping level and session level.
• Created primary keys, indexes, views, triggers for easy data retrieval as well as for data integrity.
• Followed up with admins to create new environment (Informatica folder), Unix Host, OBIEE Dashboard Console.
• Perform unit testing and user acceptance testing to check whether the data being loaded into the target, which was extracted from different source systems according to the user requirement, is accurate. Involve in the execution of test plans for loading the data successfully into the targets.
• Perform code migration by providing quality deployment documentation
• Collaborate with various stakeholders, including Project Managers, IT Team, Business End Users, Process Owners, QA Team, Database administrators, System Administrators for troubleshooting and resolving various complex issues within the given SLA.
• Proactively think and apply strategies for easy maintenance and debuggingTuned mappings for better performance and scheduled the ETL’s via TIDAL tool for daily, hourly and monthly basis.
• Developed various Complex Queries, Views for generating Reports.
• Involved in Unit testing of PL/SQL Stored Procedures, Functions and Packages.
• Performed SQL and PLSQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*Trace and TKPROF.
• Deliver high quality project artifacts as per the requirements within the stipulated time frame.
• Managing customer expectations and keeping higher management updated via regular status updates.

Environment: Oracle, Informatica, OBIEE, TIDAL, UDeploy and APPDB, Unix and Windows

Confidential, CA

Responsibilities:

• Involved in gathering requirements for the new enhancements and participated in database design changes and prepared documentation of the application.
• Co-ordinate with business and data analysts in reviewing the requirements, posing questions and translating business requirements to technical specifications.
• Responsible for Study, Analysis, Design, Development/Customization and Testing/Debugging of the application.
• Modifying the queries to reduce the time for performance issues.
• Designed and developed master tables, views, sequences and synonyms.
• Developed various Complex Queries, Views for generating Reports.
• Involved in Unit testing of PL/SQL Stored Procedures, Functions and Packages.
• Performed the uploading and downloading of flat files from UNIX server using FTP.
• Tuned mappings for better performance.
• Scheduled FINBI BO Report to get data in to flat file and used ETL tool to pull the data every day and used to send notification to the set of users once the data load and calculations were done.
• Initially Business team used to do calculations manually in excel and they used to apply monthly rates and yearly rates manually until we Automated the whole process.
• One of the most challenging project as users used to check each and every transaction amounts (Royalty amount to be paid).

Environment: Oracle, Informatica, BO, DollarU, Kintana, Unix and Windows

Confidential, CA

Responsibilities:

• Done analysis from Source to Target and Prepared TDD based on the existing process and prepared Unit Test cases and Deployment Documents.
• Used Informatica as an ETL tool to extract data from source systems(Teradata and Oracle) to load target systems(Oracle) .
• Good experience in understanding and creating sources and target definitions, Mappings, Transformations and working with sessions.
• Involved in creating mappings and modified existing as per the requirements.
• Created mappings using transformations such as Expression, Aggregator, Lookup, Joiner, Union, Router, Rank transformation.
• Used Parallel hints ,MOD functions and tuned mappings for better performance.
• Created Business Views for BO Reporting and added joins and tables in exiting universe and built Reports.

Environment: Oracle, Informatica, BO, DollarU, Kintana, Unix and Windows

Confidential, CA

Responsibilities:

• Done analysis from Source to Target and Prepared TDD based on the existing process and prepared Unit Test cases and Deployment Documents.
• As this is most crucial project in Cisco Capital and all the Customers will be Synched and stored at a single location as Single Source of Truth(The existing Data model contains only one Customer table but the new data model contains 6 tables as Data Model is very similar to 3 NF. Insertion and Updating made us very difficult, so used constraint based load order).
• Used Informatica as an ETL tool to extract data from source systems to load target systems.
• Good experience in understanding and creating sources and target definitions, Mappings, Transformations and working with sessions.
• Involved in creating mappings and modified existing as per the requirements.
• Created mappings using transformations such as Expression, Aggregator, Lookup, Joiner, Union, Router, Rank transformation.
• Used constraint based loading and Target Load Order and used Parallel hints and tuned mappings for better performance.
• Extremely worked on Dollar Universe for MIDAS and Project Connect projects.
• Cleansing and processing data from stage to data marts using informatica transformations.
• Extracted data from Teradata tables (Static tables like Time Hieratchy, Sales Hierarchy, Country and Fiscal Months Data) and to Flat files through ETL and Loaded into Oracle Tables.

Environment: Informatica,Oracle,Sql Server, DollarU, Kintana, Unix and Windows

Confidential, CA

Responsibilities:

• Reverse Engineered for the new columns which should be added in Report. Analysis and Impact Analysis for the new columns for their derivations.
• Involved in Designing technical design documents for the Enhancements and Development Projects.
• Involved in creating new mappings and modified existing as per the requirements.
• Created mappings using transformations such as source qualifier, Expression, Aggregator, lookup, joiner, router, Rank and Update Stratergy transformation and Good experience in understanding and creating sources and target definitions, Mappings, Transformations and working with sessions.
• Refreshed data from Production to Dev by ETL Informatica and Created and Monitored sessions using Informatica Workflow Manager and Workflow Monitor.

Environment: Informatica, Oracle, Teradata, DollarU, Kintana, Unix and Windows

Confidential, CA

Responsibilities:

• Created mappings using transformations such as source qualifier, Aggregator, lookup, joiner, router, Rank transformation
• Cleansing and processing data from stage to data marts using informatica transformations.
• Good experience in understanding and creating sources and target definitions, Mappings, Transformations and working with sessions.
• Extracted data from EDW through Fastexport and loaded into US Datamart by ETL Informatica for Bedrock testing and Current Conversation rates Data.

Environment: Informatica, Oracle, Teradata, DollarU, Kintana, Unix and Windows

Confidential, CA

Responsibilities:

• Modified existing mappings and created new mappings
• Executed the different application jobs to make the data synch to match with the Business Object reports
• Developed soft delete mappings and done Analysis for the columns which are coming from the BO Reports
• Prepared Test cases and Used Quality centre to execute the same.
• Participated in all migration activities from Dev to stage and prod.
• Prepared Impact Analysis documents.

Environment: Informatica, Oracle, DollarU, Kintana, Unix and Windows

Confidential, CA

Responsibilities:

• Involved in the development of ETL process using Informatica to load data from source oracle, sql server databases into the target oracle database and flat files.
• Designing and optimizing the Mapping to load the data in Slowly Changing Dimensions.
• Requirement Study and Preparing TDD(Technical Design Documents)
• Unit testing of the mappings. Migration from Dev environment to Test Environment.
• Closing the defects during UAT and invoved in deployement to production.
• Created database Objects like Tables, Views and applies Indexes and constraints on tables.
• Participated in data refreshes from Prod to stage for UAT.

Environment: Informatica, Oracle, DollarU, Kintana, Unix and Windows