SUMMARY

• 10+ years of IT experience in Application Support, Data Warehousing, Data Analytics, ETL, OBIEE, OBIA, ODI, Informatica, Oracle and MSSQL Server and Hadoop.
• 6+ years of concentrated experience in US Health Insurance and pharmaceutical industry and working experience with major clients like Confidential ’s.
• Working experience in Oracle BI tools (OBIEE / OBIA / ODI) Strong experience in designing data warehouses using Oracle data integrator.
• Experience working in OBIEE ( 11.1.1.7.1 ) & ODI on Exalytics Serversand TIMES TEN environment.
• Extensively worked on Pre - packaged (Vanilla) OBIA modules like Financial Analytics, HR analytics, Supply Chain Analytics, Projects and Procurement and Spend with source as Oracle EBS R12.
• Familiar with data architecture including data ingestion pipeline design, Hadoop information architecture, data modeling and data mining, machine learning and advanced data processing. Experience optimizing ETL workflows.
• Implementation of Oracle Financials. (GL, AP, AR, CM, FA) Implementation of Oracle Inventory & Purchasing. Development experience in Oracle HRMS, Payroll. Administration and implementation of Oracle Business Intelligence using OBIEE, OBIA, ODI.
• Working in design, development and configuration of RPD, Dashboards, Reports, Analysis & Interactive Reporting, OBIEE 11g new functionality and implemented Filters, Scheduled Reports, Prompting, Drill Thru, Multi-lingual reporting, Performed XML Manipulation. Design reports and dashboards using OBIEE11G dimensional hierarchies. Design And Develop ad-hoc queries, reports and dashboards.
• Expertise in Informatica Power Center Mapping Designer, Workflow Manager, Workflow Monitor, Repository Manager, Informatica Developer and Data Transformation tools.
• Technical Experience in developing Informatica Mappings / Mapplets and Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.
• Extensively used ODI (Oracle Data Integrator) to perform ELT from heterogeneous sources using ODI tools - Security Manger, Topology Manager, Designer and Operator.
• Excellent knowledge on the ODI Knowledge Modules such as LKM, IKM, CKM, JKM.
• Working experience in Creating ODI packages, scenarios using interfaces, variables, procedures and Topology including physical architecture, logical architecture.
• Extensively used BI Publisher 11.1.1.7 for generating various types of BI-pub reports that are sent to customers using several templates/notices that are sent to applicants in BI Publisher using RTF templates.
• Experience in configuring interactive Dashboards withdrill-down, drill across capabilitiesusing Filters and Dashboard Prompts, Setup groups, access privileges, Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports) and guided navigation links.
• Excellent knowledge and experience in data warehouse development life cycle, designing data marts, requirement analysis, dimensional modeling, implementation of STAR, Snowflake schemas; Incremental loads, Change Data Capture (CDC) and slowly changing dimensions.
• Exclusively worked on different flavors of UNIX /Linux and Windows operating systems and good Experience in UNIX shell scripting.

TECHNICAL SKILLS

Data Warehousing/ ELT/ETL: ODI 10g (10.3.5.6) and ODI 11.1.1.7, Informatica Power Center 9.x/ 8.6.1/8.1.1/8.0/7.1.2/7.1.1 , Power Mart, Informatica Power Analyzer, Informatica Power Exchange, Metadata Manager, Informatica Designer, Workflow Manager, Workflow Monitor, Repository Manager

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5/3.2 and Visio.

OBI Apps Modules: Oracle Financials GL, AP, AR, Oracle SCM OM, PO, INV

Oracle Manufacturing: OM, PO, INV, Sales Analytics, Procure and Spend Analytics, Human Resource Analytics.

BI Tools: OBIEE 11.1.1.7.x/ 10.1.3.1/3.2/3.3/3.4 , SmartView, Oracle HyperionEssbase OBIApps 7.9.5/7.9.6/7.9.6.4/11.1.7

BIG Data Eco systems: Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, pig

Databases: Oracle 11g/10g/9i/8i/8.0/7.x, IBM DB2 UDB 9.0/8.0/7.0, MS SQL Server 2000/7.0/6.0 , MySQL hive

Programming GUI: SQL, PL/SQL, SQL Plus, Unix, Perl, Shell Scripting, Transact SQL, ANSI SQL, Java/C++

OS Environment: Exalytics Servers, Red Hat LINUX, Sun Solaris, HP-UX, IBM AIX, MS DOS, Win 3.x/95/98/2000/XP/7, Win NT

PROFESSIONAL EXPERIENCE

Confidential, DEERFIELD, IL

OBIEE & ODI Architect / Lead

Responsibilities:

• Involved in the installation, configuration, customization and extension of OBIEE, OBIA, and ODI.
• Worked with Enterprise Manager for deployment and control of repository, web catalog and configuring parameters.
• Responsibilities included Building of RPD application design for Physical, Logical, and Presentation layers, configuration of those layers, development of Reports, Dashboards, Publisher and testing, and deployment
• Created proactive agents iBots and interactive Dashboards to alert the Administrative team about changes. Managed day-to-day Repository, Scheduler & iBots.
• Modified and created the ODI Knowledge Modules such as LKM, IKM, CKM, and JKM.
• Creating ODI packages, scenarios using interfaces, variables, procedures.
• Creating incremental loads, facts and dimensions, designed new data elements and tables for data marts
• Used BI Publisher 11.1.1.7 for generating various types of BI-pub reports that are sent to customers using RTF templates.
• Implemented Object Level Security for the objects like Dashboards and Reports, and Data Level Security for Principal and Teacher Evaluation dashboard.
• EnhancedQuery performance, byanalyzing & modifying SQL Query and Filters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution
• Responsible for migrating the web catalog and RPD from DEV, SIT, UAT and PROD environments.
• Installing and Configuring ODI 11.1.1.7 on all the environments with standalone agents for custom Data Warehouse project.
• Created Repositories, Agent, Contexts and both of Physical & Logical Schema in Topology Manager for all the source and target schemas.
• Created ODI Packages, Jobs of various complexities and automated process data flow.

Environment: s: OBIEE 11.1.1.7.1 on Exalytics Servers, BIAppsFinancial Analytics), ODI 11.1.1.7 Oracle EBS 11i/R12, TIMES TEN,SQL*PLUS, SQL Developer, Toad, Windows XP.

Confidential, DC

BI & ETL Lead

Responsibilities:

• Responsible for system analysis, effort estimation, design, development, unit testing, Implementation and Maintenance of data conversion mappings and ETL processes.
• Responsible for creating HLD and LLD documents.
• Responsible for data modeling using Erwin,Star SchemaModeling andSnowflakemodeling, FACT and Dimensions tables, physical and logical modeling.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Worked on Informatica Power Center Mapping Designer, Workflow Manager, Workflow Monitor, Repository Manager, Informatica Developer and Data Transformation tools.
• Developing Informatica Mappings / Mapplets and Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.
• Extensive expertise at developing and scheduling ad-hoc and canned Analytics Reports using OBIEE/BI Answers, Dashboards.
• Responsibilities included Building of RPD application design for Physical, Logical, and Presentation layers, configuration of those layers, development of Reports, Dashboards, Publisher and testing, and deployment.
• Developed BI using the following tools: Oracle BI Administration, Oracle BI Answers, Oracle BI Dashboards.

Confidential, IL

Senior BI & ETL Developer

Responsibilities:

• Worked closely with Development managers to evaluate the overall project timeline.
• Gathering the requirements for the various projects and enhancements
• Participated in team meetings and proposed ETL Strategy and provide them best practices.
• Created incremental loads, facts and dimensions, designed new data elements and tables for data marts.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner etc.
• Extensively used Unix Scripting and Scheduled PMCMD to interact with Informatica Server from command mode.
• Monitor and communicate the availability of UNIX and Informatica Environment. Follow-up on problem tickets.
• Provided production support by monitoring the processes and Jobs running daily.
• Deployment of applications by following the SCM processes.
• Extensively used Dimensions for version controls and deployments.

Environment: OBIEE 10g, Informatica Power Center 9.5.1/8.6.1 , Oracle 11g, Dimension, Facets application, Facets data model, Serena NWR, Serena Team Track, UNIX Solaris, Mainframe OS 390, Lotus Notes, Microsoft Office, Windows XP Professional/2002, Windows XP/2000.

Confidential - New Jersey

Senior BI & ETL Developer

Responsibilities:

• Installing, maintaining and supporting Informatica PowerCenter tools.
• Creating repository and integration services, maintaining user privileges and deployment activities.
• Participated in team meetings and proposed ETL Strategy and provide them best practices.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner etc.
• Performed tuning of InformaticaMappings for optimum performance.
• Extensively used Unix Scripting, Scheduled PMCMD to interact with Informatica Server from command mode.
• Created Shell scripts to automate the Backups, ETL Execution.
• Monitor and communicate the availability of UNIX and Informatica Environment. Follow-up on problem tickets.
• Provided production support by monitoring the processes and Jobs running daily.

Environment: Informatica Power Center 9.1/8.6.1/8.1.1 , Oracle 11g/10g, Cognos, Erwin 4.5, Essbase 11.1.1, Business Objects xi, SQL Developer, Autosys, UNIX AIX 5L version 5.1, UNIX Solaris, Linux Red-Hot, Microsoft Office, Windows XP Professional/2002, Windows XP/2000, ClearCase

Confidential

ETL- Informatica Developer

Responsibilities:

• Responsible for Power Center and Power Exchange installations, configuring Power Center domain, nodes and integration services.
• Responsible for creating repository folders and giving access to the users.
• Played a role of Informatica Developer and Lead.
• Created mappings for various sources like Oracle, SQL server, flat files and XML files to load and integrate data to warehouse.
• Developed various mappings, Reusable transformations and validated the ETL logic coded into mappings.
• Scheduled sessions and work flows using Informatica scheduler and pmcmd command.
• Developed unit test cases and did unit testing for all the developed mappings.
• Provided production support by monitoring the processes running daily.
• Worked closely with reporting team and helped them whenever they had any ETL issues.

Environment: Informatica Power Center 8.1.1/7.1, Oracle 10g, Erwin 4.5, Crystal reports, EssBase, SQL server 2005, Transact-SQL, DTS, UNIX AIX 5L version 5.1, Windows XP Professional/2002, Transact-SQL, UNIX AIX4.2, Windows XP/2000.

Confidential

ETL Developer

Responsibilities:

• Responsible for creating repository users, user groups, giving privileges to the users, granting users with access to the repository folders.
• Responsible for migrations from Development repository to the QA and Prod repositories.
• Populated data into staging tables from flat files, XML sources, Cobol Copybooks and Relational Sources.
• Installed and Configured Informatica PowerCenter on Client and Server Machines and Configure Informatica Server and Registered Servers.
• Worked on Informatica Power Center 6.2/7.1 tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplets, and Reusable Transformations.
• Used Informatica Designer designed Mappings that populated the Data into the Dimensions.
• Worked extensively on transformations like Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator and joiner transformations.
• Developed Unix Shell scripts and Perl Scripts to extract and convert data from different legacy systems in databases.

Environment: Informatica Power Center 6.2/7.1, Power Mart, Erwin, Business Objects 6.0, Perl, UNIX Shell Scripting, DB2, Mainframes, Microsoft Office, COBOL, Oracle 9i/8i, SQL Server.