We provide IT Staff Augmentation Services!

Informatica/business Object Developer Resume

PROFESSIONAL SUMMARY:

12+ years of experience in developing BI Solution (Data Warehousing, Data analysis and reporting solutions) for Financial Institution (Commercial lending & Leasing) and HealthCare industry. Expertise in translating business needs into ETL code to load data into EDW and prepare access layer for front end consumption via Business Object for adhoc reporting and Tableau for dashboard capabilities to help business decisions making. Worked on all phases of data warehouse development and have strong experience on ETL and reporting/dashboard tools.

TECHNICAL SKILLS:

ETL

Informatica

Abinitio

Reporting/Dashboard

SAP Business Object

Tableau

Spotfire

Databases

Oracle

Teradata

SQL Server

Scheduling Tool

Control - M

Autosys

Apworks

PROFESSIONAL EXPERIENCE:

Informatica/Business Object Developer

Confidential

Responsibilities:

  • Prepare Mapping document for Data Sources loaded to Staging tables.
  • Developing maps and flowcharts of current/future business processes.
  • Analyzed workflow, session, event and error logs for trouble shooting Informatica ETL process.
  • Tuned the Informatica mappings for optimal load performance.
  • Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
  • Involved in migrating Informatica ETL application and Database objects through various
  • Parsed high - level design specification to simple ETL coding and mapping standards.
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
  • Involved in migrating Informatica ETL application and Database objects through various environments such as Development, Testing, UAT and Production environments.
  • Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
  • Performance tuning of Oracle Databases and User applications.
  • Define/Modify job dependencies for the future state, improve parallelism and achieve 50% estimated savings in overall Job execution time.
  • Used various transformations like Source Qualifier, Joiner, Lookup, router, Filter, Expression and Update Strategy.
  • Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
  • Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
  • Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
  • Documented Informatica mappings in Excel spread sheet.
  • Create technical validations for different source system to ensure data quality.
  • Gather functional and system requirements to use to address Regulatory and Management Reporting.
  • Supported Business Object (BO) reporting capability for 200+ users across finance and operations. Developed and maintained ~50+ Business Objects report created 5 new BO universes to support adhoc reporting.
  • Created complex reports using multiple queries and tuned the reports in order to increase the accessing speed.
  • Tested pre-defined filters, universe level grouping objects, join at universe level and reports.
  • Providing technical guidance to the team and built an excellent work relationship in the team.

SAP Business Object Developer

Confidential

Responsibilities:

  • Participated in project planning sessions with Project Managers, Business Analyst, SME’s and Business users to analyze and understand business requirements and outline the proposed SAP BO reporting solution.
  • Developed new SAP Business Object Universe using Information Design Tool (IDT) which include semantic layer, dimensions, measures, navigation path, @Prompt filters, derived tables, parameters, filters, LOV’s
  • Developed SQL stored procedures, views and functions at access layer to fulfill users reporting requirement without performance impact at SAP Business Object Universe level.
  • Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved
  • Enhance and maintain SAP BO Universe for supporting adhoc webi reporting.
  • Interacted with functional users to gather requirement and develop new webi and crystal reports and enhance existing reports.
  • Create BO visualizations using Lumira.
  • Create standard and adhoc reports using BO functionality’s like slice and Dice, Templates, Drill Down, @function, Cross Tab and Master Detail in reporting.
  • Developed training documentation and trained end users on how to request access on SAP Business Object Universe and prepare business object webi reports.

Business Analyst/ETL Developer

Confidential

Responsibilities:

  • Development of ETL stage design. Development of PL/SQL procedures/packages
  • Identified and tuned ETL performance issues
  • Developed a Conceptual model using Erwin based on requirements analysis
  • Involved in writing Teradata SQL bulk programs and in Performance tuning activities for Teradata SQL statements using Teradata EXPLAIN
  • Audited application SQL code with DB2 Explain prior to production implementation
  • Used PMCMD command to automate the Power Center sessions and workflows through UNIX.
  • Documentation of Informatica mappings in Excel spread sheet.
  • Developed and reviewed ETL workflows for multiple data sources like flat files, XML, Teradata, DB2, Oracle, SQL Server.
  • Involved in migrating Informatica ETL application and Database objects through various environments such as Development, Testing, UAT and Production environments.
  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
  • Writing of SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing Purposes.
  • Successful and rapid conversion of Legacy BO XI 3.1 Reports to BI 4.1 SP3
  • Used Informatica ETL to load data from flat files, which includes fixed-length as well as delimited files and SQL Server to the Data mart on Oracle database.
  • Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
  • Developed Oracle PL/SQL code to write DDL/DML statements and Stored Procedures for data transformation and manipulation.
  • Worked with Informatica Debugger to debug the mappings in Informatica Designer.
  • Involved in creating test plans, test cases to unit test Informatica mappings, sessions and workflows.
  • Supports and coordinates UAT, defining testing requirements with the QA & Testing team as well as the clients
  • Performs data analysis to support tasks as required
  • Monitored and maintained ETL Jobs in multiple database environments
  • Development of script, error handling strategy and implementation and build sessions and worklets and workflow
  • Data validation and verification.
  • Provide support during acceptance testing and release of the product into the production environment.
  • Technical issue discussion and Resolution between Onsite and Offshore.
  • Support for User Acceptance Testing.

ETL Developer

Confidential

Responsibilities:

  • The design of processes to extract, transform and load data from different file source systems via Informatica mappings into the staging area.
  • Creating a upsert and CDC mappings for history maintenance
  • Write a bteq scripts as a part of ETL process.
  • Developed processes on both Teradata and Oracle using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata) and SQL*Plus, SQL*Loader (Oracle).
  • Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs.
  • Used Informatica as an ETL tool to extract data from sources systems, loaded the data into the ORACLE database.
  • Preparing the Project Plan estimates and update the status of the Project to the client with progress and achievements regularly.
  • Support UAT and preparing UTP scripts for testing the deliverables.
  • Job/Workflow creation, monitoring, and scheduling.
  • Provide support during acceptance testing and release of the product into the production environment.
  • Analyzed workflow, session, event and error logs for trouble shooting Informatica ETL process.
  • Involved in migrating Informatica ETL application and Database objects through various
  • Communicate client’s business requirements by constructing easy-to-understand data and process models.
  • Draft and maintain business requirements document(BRD) and align them with functional and technical requirements document (FSD and TDD).
  • Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
  • Technical issue discussion and Resolution between Onsite and Offshore.
  • Reviewing code and preparing change control documents.
  • Documentation of Informatica mappings in Excel spread sheet.
  • Analysis of user queries and solving their data issues.

ETL Developer

Confidential

Responsibilities:

  • Create POC (FRD) - Proof of Concept Mapping design
  • Development and testing of ETL Mappings
  • Creating test cases and test scripts, performing unit testing and integration testing.
  • Analyzing the bugs raised concerned with the ETL jobs and subsequently fixing of the same
  • Sequenced the different ETL components (Informatica workflows/Oracle SQLs/UNIX scripts) and enlisted in a list file; further created a data load regulation program by writing a parent UNIX shell script that executes the components within the list file sequentially. Invoked Informatica using “pmcmd” utility from the UNIX script and Oracle using “sqlplus”.
  • Created Informatica transformations/mapplets/mappings/tasks/worklets/workflows to load the data from source to stage, stage to dimensions, bridges, facts, summary and snapshot facts.
  • Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
  • Experience in integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
  • Creating project deployment process document for the release management team to release the code to production.
  • Involved in reviewing the code & the deliverables prepared by the team.
  • Developed and reviewed ETL workflows for multiple data sources like flat files, XML, Teradata, DB2, Oracle, SQL Server.
  • Review existing code, lead efforts to tweak and tune the performance of existing Informatica processes
  • Extracted data from Oracle database transformed and loaded into Teradata database according to the specifications.
  • Production Support (As this project is migrated from Abinitio to Informatica work with onshore counterparts on production issues (L3 Support) to understand the application)

ETL Developer

Confidential

Responsibilities:

  • The design of processes to extract, transform and load data from different file source systems via Informatica mappings into the data warehouse.
  • Scheduling of Informatica Mappings for the daily/weekly load.
  • Data Analysis and Reconciliation.
  • Performing extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the dimension tables and fact tables properly.
  • Created Dimension Tables and Fact Tables based on the warehouse design.
  • Wrote Triggers and Stored Procedures using PL/SQL for Incremental updates
  • Integrated various sources in to the Staging area in Data warehouse to Integrate and for Cleansing data.
  • Developed Mappings and Workflows as per the requirements.
  • Created the Source and Target Definitions in Informatica Power Center Designer
  • Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.
  • Created Reusable Transformations and Mapplets to use in Multiple Mappings
  • Developed and updated documentation of processes and system.
  • Migrated mappings from Development to Testing and from Testing to Production.
  • Created various Documents such as Source-to-Target Data Mapping Document, and Unit Test Cases Document.

Hire Now