We provide IT Staff Augmentation Services!

Etl Developer Resume

Indianapolis, IN

PROFESSIONAL SUMMARY

  • More than 7years overall IT experience in complete Software Development Life Cycle (SDLC) in Client/ Server, Database, Oracle Data Warehouse and Business Intelligence applications in Windows and Linux/Unix environments from initiation through design, development, deployment and post go-livesupport.
  • Proficient in Design, Development, Implementation, Administration and Support ofOBIEE10g/11g, OBIA 7.9.6.x, Informatica, DAC and Oracle Database.
  • Experience in building and configuring Repository, creating and managing OBIEE Intelligent Dashboards, OBIEE Answers, OBIEE Delivers, and OBIEE iBots.
  • Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, and Cache Management.
  • Expertise in installation, configuration, troubleshooting, performance tuning and administration of Oracle BI EE 10.1.3.x/11g.
  • Knowledge of Database architecture for OLTP and OLAP applications, Data Analysis, ETL, Reporting processes in developing Data marts and Enterprise Data Warehouse.
  • Experience with all ODI tools - Topology, Security Manager, Designer and Operator.
  • Experience in DAC (Data Warehouse Administration Console) with Importing Subject Areas, Creating Execution plans, registering the flows, Metadata management and Scheduling.
  • Exposure to Insurance, Banking, Financial, Healthcare, Industrial sectors and business with regard to Data warehouse development.
  • Worked on Financial Analytics, Procurement and Spend Analytics, Supply Chain and Order Management Analytics
  • Experience in Designing and developing Star, Snow flake and multi-dimensional Schemas.
  • Complete Knowledge of data warehouse methodologies (Ralph Kimball, Inman), ODS, EDW and metadata repository.
  • Experience in Performance tuning on different levels of OBIEE objects
  • Experience in Installation and configuration of Informatica Power Center 7.x/8.x/9.x and creating Mappings, Mapplets, Sessions and Workflows.
  • Troubleshooting production issues and gave post production support for couple of projects.
  • Good experience in Linux and writing shell scripts.
  • Excellent Interpersonal communication, documentation skills and experience coordinating with project Managers, Business Analysts, Architects, DBA’s and Developers.
  • Excellent Management skills, analytical and dynamic troubleshooting skills, Multi-tasking, Posses good communication skills, Quick learner and adapts to new environments easily.

TECHNICAL PROFICIENCY:

Reporting Tools: OBIEE 10.3.1.x/11g, BI Apps

ETL Tools: Oracle Data Integrato, Informatica Power Center9.x/ 8.x/7.x,

Business Intelligence: Oracle Business Intelligence Application 7.9.6.Sx

RDBMS: Oracle11/10g, 9/8i, MS SQL Server 2003/2000, Access7.0/2000.

Tools: Toad, SQL*Loader, SQL Developer.

Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C++

Operating Systems: Linux EL5, Windows NT/2003/2008, Windows 95/98/00/xp, Linux, Solaris.

Scheduling tools: DAC (Data Warehouse Administration Console)

Internet Technologies: HTML, XML, ASP, ASP.net, JSP, VBScript and JavaScript.

PROFESSIONAL EXPERIENCES:

Confidential, Indianapolis, IN

Role: OBIEE / ODI Developer

Responsibilities:

  • Created ETL for sourcing the data received in Excel files for tracking error logs
  • Created new models for the data sources – flat files, MS SQL server, Oracle.
  • Did SQL and PL/SQL programming for ODI and oracle.
  • Created ODI packages, scenarios using interfaces, variables.
  • Used ODI commands like ODIFile Move, ODI FileAppend, ODI Filecopy etc
  • Performance tuned the ODI interfaces.
  • Optimized the knowledge modules to improve the functionality of the process.
  • Conducted code reviews and planned the knowledge transfer to client.
  • Worked closely with Business users. Provided options and alternative solutions to Business during data anomalies etc
  • Participated in all the phases of project – development, testing, deployment and support.
  • Worked extensively with ODI Designer, operator and metadata Navigator.
  • Good understanding of ODI architecture and installation of Topology, Security Manager, agents, Designer, Operator, Master repository and Work repository.
  • Facilitated the development & documentation of additional data quality test cases.
  • Experience in analyzing the processes while considering Key Performance Indicators (KPI’s).
  • Develop, test & document data feeds / cleansing using ODI for top 10 KPIS including skills transfer to INPRS team
  • Delivered ODI packages to support the 10 identified KPIs, documentation and skills knowledge transfer to INPRS personnel.
  • Developed, initially tested& documented OBIEE scorecards content for top ten KPIs.
  • Support testing and debugging including skills transfer and support transition to INPRS.
  • Involved in documenting, tracking and resolving issues during testing and skills/knowledge transfer to INPRS personnel.

Environment: Oracle Data Integrator 11g,Oracle EBS, OBIA 7.9.6.x, BI Apps 11.1.1.7.1 , Oracle Business Intelligence 11g, Oracle 11g, Oracle DB, Windows XP/ NT/2003, UNIX, Linux, Shell scripting, TOAD

Confidential , Novato, CA.

Role: OBIEE / Informatica Developer

Description: Enhancing the reporting capabilities on Oracle BIEE as part of eHCP Aggregate Spend Phase- II

Responsibilities:

  • Created ETL for sourcing the data received in Excel files for vendor processed payments
  • Worked on creating reports using the existing/ extending metadata content to fulfill the report requirements.
  • Automated the feed transfer inbound/ outbound between BioMarin and Concur.
  • Worked on the creation of the dashboards for the reports developed in step 2 to provide easy access to the data.
  • Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
  • Loaded the flat files data using Informatica to the staging area.
  • Involved in the ETL design and its documentation.
  • Involved in monitoring the workflows and in optimizing the load times.
  • Used debugger to debug mappings to gain troubleshooting information about data and error conditions .
  • Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables .
  • Extensively used workflow variables, mapping parameters and mapping variables.
  • Created SHELL SCRIPTS for generic use.
  • Configured DAC (Data Warehouse Administration Console) for Creating Execution plans, Metadata management and monitoring the Informatica ETL Process.
  • Closely worked with ETL team to configure Informatica connections, source DB connection and target DB connection in DAC .
  • Knowledge on configuring new customized mappings and work flows in DAC for new customized subject area.
  • Experience in configuring DAC to run nightly data loads on daily basis.
  • Used workflow manager for session management, database connection management and scheduling of jobs

Environment: Oracle Business Intelligence 11g, BI Analysis, DAC, Oracle 11g, Oracle DB, BI Apps 7.9.6.4, Windows XP/ NT/2003, UNIX, Linux, Shell scripting, TOAD

Confidential , Novato, CA

Role: ETL Developer

Responsibilities:

  • Modified SDE,SIL mappings of financial analytics to Extract the data from Oracle EBS into EDW
  • Fixed the invalid mappings and troubleshoot the technical problems of the database.
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
  • Modified existing mappings for enhancements of new business requirements.
  • Using Informatica Power Center Modified mappings and Mapplet to transform the data according to the business rules.
  • Prepared migration document to move the mappings from development to testing and then to production repositories.
  • Documented Informatica mapping specifications in Excel spread sheet.
  • Implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
  • Extensively used SQL scripts/queries for data verification at the backend.
  • Designed and Developed UNIX Shell Scripts, Data Import/Export.
  • Observed configuring DAC environment created and scheduled execution plans.
  • Involved in adding all the newly developed Dimension, General , Aggregate and Fact tables in to DAC and creation of new Subject Areas.

Environment: Oracle EBS, OBIA 7.9.6.x, DAC, BI Apps7.9.6.4, Oracle Business Intelligence 11g, Oracle 11g, Oracle DB, Windows XP/ NT/2003, UNIX, Linux, Shell scripting, TOAD

Confidential , Novato, CA

OBIEE / Informatica Developer

Description: The Objective is Concur- OBIEE integration for employee expenses reporting

Responsibilities:

  • Developed and implemented the ETL approach from staging to target which is common irrespective of source system using Informatica.
  • Created Shell Scripts for coping the files from Concur site to OBIEE server
  • Developed ETLs to source the data from SAE into EDW.
  • Created complex mappings which involved Slowly Changing Dimensions
  • Worked extensively with the connected lookup Transformations using dynamic cache.
  • Involved in extracting the data from the Flat Files and Relational databases into staging area
  • Monitored Workflows and Sessions using Workflow Monitor.
  • Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios.
  • Documented Informatica mappings in Excel spread sheet.
  • Tuned the Informatica mappings for optimal load performance.
  • Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer
  • Worked on the Multidimensional data model to store the data provide support for reporting
  • Created an RPD model for reporting through BI answers.
  • Involved in creating Dimensional Hierarchies to support drill downs.
  • Designed Security to provide controlled access to the data
  • Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
  • Worked on creating Reports and Dashboard to provide access to the employee level data.
  • Involved in Performance tuning at Informatica level and at Data base level.
  • Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment.
  • Re-organized pages & reports into new dashboards.
  • Monitoring Incremental & Full load through DAC.
  • Imported and Exported Execution Plan in DAC from one Instance to other Instance.
  • Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.

Environment: Oracle Business Intelligence 11g,BI Apps 7.9.6.4, BI Publisher, DAC, Oracle 11g, Oracle DB, Windows XP/ NT/2003, UNIX, Linux, Shell scripting, TOAD

Confidential, Minneapolis

Role: OBIEE Developer / ETL Consultant

Responsibilities:

  • Implemented OBIEE with Financial and Procurement & Spend Analytics against Oracle EBS
  • Gathered user requirements by conducting interviews, identifying ISW reports and created SR’s and CR’s from the gathered requirements.
  • Managed repository during the development using OBIEE 10.1.3.4 Admin Tool.
  • Worked on SDE and SIL mappings for different Source containers like Oracle R12
  • Worked on Core Modules like GL, AP, and AR.
  • Used flat files to source the data from flat files into DW using Informatica Mappings, Sessions and Workflows
  • Monitored performance by creating OBIEE’s Usage metrics. Improved performance by using aggregate navigation, indexes and materialized views.
  • Copied existing RPD’s from server into the local machine for testing and tuning of dashboards.
  • Created Metadata Dictionary for all the subject areas created.
  • Migrated RPD and Catalog changes from DEV to QA and PROD.
  • Received excellent feedback from Users, Accounting Manager and Director of Business Intelligence.
  • Restarting the BI Servers with RPD changes, Running Cache Scripts and Catalog Merging on Dev and QA environments on Linux.
  • Created Presentation catalogs, Folders in Presentation Layer, and Performed Global Consistency Check in Oracle BI Administration Tool.
  • Worked on Answers, Dashboards and Security for users. Worked on creating complex reports.
  • Worked on Single Sign On security for users based on LDAP Authentication type in Production and also other Authentication types (External table authentication and Database) in other environments.
  • Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository. Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
  • Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
  • Administered NQSCONFIG.INI and Instanceconfig.xml configuration files.
  • Involved in Logical and Physical Database design and Star Schema design, Snow flake Schema, Fact tables and Transaction tables.
  • Closely worked with ETL team to configure Informatica connections, source DB connection and target DB connection in DAC.
  • Knowledge on configuring new customized mappings and work flows in DAC for new customized subject area.
  • Experience in configuring DAC to run nightly data loads on daily basis.
  • Worked on Data Extraction Transformations, Loading, Conversions and Analysis.

Environment: Oracle EBS, Oracle Business Intelligence 10.1.3.4, BI Apps, BI Publisher, DAC, BI Office, OBIA 7.9.6.x, Oracle 11g , Windows XP/ NT/2003, UNIX, Linux, Shell scripting

Confidential , Woodland Hills, CA

Role: OBIEE Analytics / ETL Consultant.

Responsibilities:

  • Modeled the Logical Layer based on the Business requirements in the Business Mapping and Modeling Layer and Developed the necessary Star Schemas.
  • Worked on Answers, Dashboards and Security for users and creating complex reports.
  • Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
  • Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.
  • Created various Static and Dynamic variables for different report and Security requirements.
  • Worked on security for users based on LDAP Authentication type in Production and also other Authentication types (External table authentication and Database) in other environments.
  • Re-organized pages & reports into new dashboards: CORE GL, AP, AR.
  • Administered NQSCONFIG.INI and Instanceconfig.xml configuration files.
  • Configured implicit fact columns. Enabled and administered Usage Tracking by using direct insert method.
  • Configured Delivers (iBots) to alert the users based on the user needs.
  • Worked on creating DAC tables, task definitions, Subject areas and indexes for tables and worked on change capture mechanism during incremental load for tables which were not part of OOB.
  • Deployed Informatica workflows to the DAC, created dependency and dependent hierarchical tasks and streamlined the Execution Plans with their respective tasks in DAC.
  • Monitored the daily Incremental Loads in Production environment and fix any issues during the Load.
  • Worked on Informatica OOB and customized SDE and SIL mappings for different Source containers like Oracle R11
  • Worked on the Time Series Wizard and implemented time comparison measures.
  • Used Column Filter Prompts and provided Dashboard Prompts appropriately to avoid excessive data showing up Reports.
  • Used various transformations Source qualifier, Aggregators, Connected & Unconnected lookups, Filters & Sequence for mappings based upon the requirement.
  • Created Custom mappings to update Facts and Dimensions and worked on performance tuning of various transformations.
  • Migrated Analytics RPD and Webcat from one environment to another.

Environment: Oracle Business Intelligence 10.1.3.3,BI Apps, BI Publisher, DAC, Oracle EBS R11,Oracle Financial Analytics 7.9.x, Windows 2k, DAC 10.1.3.4, OBIA 7.9.5, Oracle 10g , TOAD.

Confidential, INDIA

Role: Siebel Developer / Informatica Programmer

Description: Designed and developed education oriented games software called go4games. This is quite a comprehensive web site developed for both the Internet and Intranet. It provides information about the newly designed games and forth coming products and also provides online order form and shows various clients involved with it and their feedback and provides complete help of the games designed.

Responsibilities:

  • Worked with Informatica Power Center Source Analyzer, Data Warehousing designer, Mapping Designer & Mapplet, and Transformations for creating Mappings.
  • Extensively worked on Answers, Dashboards and Security for users. Worked on creating complex reports using Seibel.
  • Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
  • Developed and Scheduled workflows using workflow Manager created and modified parameter files according to the business requirements.
  • Used aggregator, sequence Generator, expression, transaction control, Normalize transformations.
  • Performed requirement gathering, scope analysis and finalizing the functional points.
  • Designed and developed design document for common functions and packages.
  • Created DDLs to create the staging, dimension and fact tables in the Data Warehouse.
  • Developed and tested PL/SQL procedures, functions and packages.
  • Designed and developed packages and PL/SQL programs to find the given word matches in the text stored in columns.
  • Developed wrapper programs using shell scripts.
  • Also, developed Perl programs for pattern matching utilities.
  • Implemented Materialized views, Bulk binding and Collections to achieve performance for PL/SQL programs.
  • Prepared technical specifications and common function manuals for the releases.

Environment: Informatica Power Center 5.1, BI Analysis, PL/SQL, Oracle 8.1, SQL Server 2000, XML, PL/SQL, Perl 5.6 and UNIX, Linux, Shell Scripting, TOAD.

Hire Now