Software Engineer Data

A Senior BI Solutions Architect possess ** years in the field of Business Intelligence & Applications and Data warehousing experience in IT cutting across OBIEE/ BIApps,ODIApps,ODI 12c,ODI 11g, OBIA,ODIA,Exalytics, Exadata, Exalogic, Data Modelling, Performance Tuning.

Professional Summary:

Highly competent Business Intelligence/Data Warehouse expert on OBIEE, ODI, ODIApps,OBIA (Out of the Box Prebuilt Applications), and Oracle BI tools, ERP’s, OLTP & OLAP Applications.

A dynamic professional with over 12 years of rich experience in Business Analysis, adept at QA methodologies, business process analysis & change management communication on complex projects.

Involved in end to end implementations of BI solutions for implementing Oracle Financial Analytics, Procurement and Spend Analytics, Human Resources, Supply Chain and Order Management Analytics, Project Analytics, Manufacturing analytics.

Implemented prebuilt solutions using ERP systems like Oracle EBS, PeopleSoft, and JD Edwards Enterprise One into Enterprise Business Analytics Warehouse (BAW).

Strong experience in Project methodologies, SDLC, DW and BI infrastructure and architecture using middleware OBIEE, OBIA, data loading, schedule and monitor workflows/jobs, and dimensional modelling using Star schema in Data warehouse life cycle.

Hands on experience on metadata modeling Architecting BI/DW projects, configuring Data Warehouse Administration Console (DAC), Informatica ETL Process and a technocrat with expertise in systems design, implementation and testing.

Responsible for the delivery of the DW/BI project and developing the solution architecture for the project.

Coordinate with the implementation partner and business functions to finalize the requirements and deliver them in a timely manner

Responsible for setting up the necessary infrastructure for the project and coordinating with various departments in IT for the interfacing requirements for developing the necessary extractions from source systems.

Installation & Deployments:

Installation on all the OBIEE components including ODI, Informatica, DAC, OBIEE, ODIApps, BIApps in Windows, Linux, AIX, HP Unix and Solaris environments with experience in 20+ projects.

Experience in OBIEE11g includes Weblogic and Enterprise Manager Configuration, Administration, implementing features like Mapviewer, Master-Detail events, KPIs, Scorecards and upgrading deployments from 10g to 11g.

Expertise in Merging, migrating the BI & ETL, ELT metadata and custom code, deploying Rpds and Catalogs between different environments and setting up, using Multi-user development environment.

Development and BI Server Architect:

Expertise in OBIEE Repository component includes making changes to Physical, Logical and Presentation layers in BI Apps or custom rpd’s to accommodate changes made to the data model.

Extensive experience in designing new rpd’s, data modeling in physical layer, creating different types of hierarchies, aggregate tables, calculated and time-series measures, creating variables, applying security and usage tracking.

Experience in ETL includes configuring and loading BI Apps data for different source systems, customizing the OBAW warehouse, Using ODI tools and Informatica .Creating new mappings to fetch data from source tables and load it in to modified target tables.

Experience in OBIEE11g includes Weblogic and Enterprise Manager Configuration, Administration, implementing features like Mapviewer, Master-Detail events, KPIs, Scorecards and upgrading deployments from 10g to 11g.

Experience in OBIEE Delivers configuration and creating and scheduling iBots/Agents for delivering reports to different targets including seeding cache.

Set up SSO authentication and LDAP configuration, OBIEE Integration with Siebel OLTP.

OBIEE Cache Management, OBIEE Performance Tuning, Architecting end state OBIEE Platform.

Troubleshooting and Performance tuning with Oracle BI servers.

Expertise in implementing Data security using Group and UI security with Web groups in OBIEE.

Implemented in Financials, Procurement and Spend, Supply Chain and Order Management, Project, Manufacturing modules on Exalytics, Exalogic and Exadata Servers.

Implemented ODIApps / BIApps Project on Exalytics,Exalogic,Exadata machines.

Hands-on experience in using SQL, PL/SQL, Oracle Stored Procedures, Packages and Object types to meet data integration and processing requirements.

Experience in handling Third party tools such as SQL Developer, SQL*Loader and Toad.

Knowledge on database design – Creation of data model, Tables, Indexes, Views, Materialized views, Synonyms, Sequences for better performance of the database.

Has Good knowledge on Oracle Data integrator, Oracle ADF and BI Publisher.

Experienced in communicating with Onsite teams, Clients and managing offshore project teams numbering up to 12 resources.

EDUCATION

Masters in Computer Applications(MCA) from INDIA

TECHNICAL SUMMARY:

HighEnd Servers

Exalytics, Exadata, Exalogic

DWH ETL/ELT Tools

Informatica 8.6, 8.6.1, 9.0.1,9.1.0,9.5.0 ODI 11.1.1.X,12c,Scoop

Databases

Oracle Database 10g,11g, Teradata, MSSQL

Reporting Tools

OBIEE,BIPublisher,Tableau, TIBCO, Pentaho,Splunk

Application Servers

Tomcat, Weblogic, Resin, Openlazlo, JBoss,OHS,OC4J

Programming Language

C, C++, PL/SQL, Java,Shell Scripts, Bash Script

Development/Productive Tools

SQL*Plus, TOAD, PL/SQL Developer

OOPS

JDK 1.4,JDK 1.5, JDK 1.6,C++.

Applications & Languages

J2EE (Servlets, JDBC, JSP), HTML, DHTML and XML, java, C, JavaScript,Hadoop

Web Servers

Tomcat 5.0,Apache,Resin,Openlazlo,lightstreamer,OHS

Database Servers

Oracle 10g, 11g, MySQL server, MSSQl server

Operating System

Windows 2003,2008, XP,7,8,10, Linux, HP, AIX, Solaris

Tools

Dreamweaver, SSH,Putty,Toad

Certificates/Achievements:

OBIEE 11g Implementation Specialist

OBIEE 11g Presales Specialist

OBIEE 11g Support Specialist

OCA: Oracle Certified Associate

OCP: Oracle Certified Professional

BLUE CROSS BLUE SHIELD DETROIT MI NOV 2015 – TILL DATE

Role: Security Integration Architect / Sr Tech Lead / (OBIA with ODI11g)

Responsibilities:

Conducted meetings and Design sessions with Business Users, Analysts from OLTP and OLAP.

Installed and configured OBIA and ODI on different environments.

Involved in client interfacing and cross functional infrastructure teams in analyzing the system architecture and translate them into architectural design documents and involved in requirements gathering.

Documented the OBIA ODI technical architecture, physical components, requirements and delivery of the components.

Defined Data Standards, Guide Lines and Best Practices.

Integrated OBIA LDAP authentication with AD servers

Created prinicipal users and SPNs.

Defined Service Prinicipal names and integrated with JAAS API

Generated Custom Keytabs for SPN account

Integrated Authentication headers and negotiate headers with weblogic client and server

Configured Kerberos config as per AD and weblogic server

Defined Roles and privileges

Raised a new Oracle Product Enhancement requests for new SPN.

Did Performance testing in several phases.

Integrated applications based on Kerberos client / server authentication.

Troubleshooted all issues while in development and execution.

Migrated jobs in different environments.

Scheduled ODI jobs in auto mode.

Configured the Weblogic configuration and OBIEE Server configuration.

Deployed new customized applications

Redesigned new templates and configurations

Fixed metadata related issues in ODI11g.

Responsible for all activities related to the Implementation, administration, enhancements and support of ETL ODI processes including customization of several projects.

Environment: OBIEE 11.1.1.7.1, Oracle 11g, ODI11g, OBIA 11.1.1.9.1, OBAW, Web Logic Server, Linux, SQL, PL/SQL, LDAP,Kerberos,WNA,PeopleSoft, Dimensional Modeling.

CLOROX Dublin CA MAR 2015 – NOV 2015

Role: BI Architect /Sr Tech Lead / (Exalytics/Exadata/ODI12c)

Responsibilities:

Conducted meetings and Design sessions with Business Users, Analysts from OLTP and OLAP.

Installed and configured ODI on different environments.

Configured and Migrated ODI projects and metadata in different environments.

Involved in client interfacing and cross functional infrastructure teams in analyzing the system architecture and translate them into architectural design documents and involved in requirements gathering.

Documented the ODI technical architecture, physical components, requirements and delivery of the components.

Built Custom Projects based on custom business requirements.

Defined Data Standards, Guide Lines and Best Practices.

Built ODI Interfaces/mappings as per custom requirements

Built ODI Packages as per custom requirements.

Built ODI Procedures as per custom requirements.

Generated ODI Scenarios as per custom requirements.

Scheduled ODI jobs in auto mode.

Automated ODI Jobs in Control M Servers.

Defined ODI Models and Logical connections.

Defined Users Security in ODI 12c.

Migrated ODI customizations to different environments.

Fixed metadata related issues in ODI12c.

Upgraded Exalytics server applied patches for fixing issues.

Defined own custom shell / batch scripts invoked in ODI.

Debugged ODI issues during runtime errors and automatized sending alerts from ODI to business users.

Responsible for all activities related to the Implementation, administration, enhancements and support of ETL ODI processes including customization of several projects.

Environment: Exalytics OBIEE 11.1.1.7.1, Oracle 11g, Exadata, ODI12c, OBAW, WebLogic Server, Linux, SQL, PL/SQL, Exadata Oracle 11g, Dimensional Modeling.

AllegisGroup Inc Baltimore MD OCT 2014 – MAR 2015

Role: Architect (OBIA/ODI/Exalogic/Exadata)

Responsibilities:

Conducted meetings and Design sessions with Business Users, Analysts from OLTP and OLAP.

Documented the technical architecture, physical components, requirements and delivery of the components.

Defined Application tier, ELT and Database tier for OBIA architecture.

Configured BI APPS 11.1.1.7/8 (ODI/ETL, Configuration/Functional Setup Manger and OBIEE/RPD/Reports/Dashboards) on distributed environment and implemented Oracle out of the box Prebuilt Analytics.

Defined Data Standards, Guide Lines and Best Practices.

Customization and validation of all the OOB Dashboards: Financial and Project Analytics dashboards against PeopleSoft Source.

Configured BIACM components, Dimension and fact groups as per ODI Load plan.

Configured ODI Domain load only plan and Custom data plan for loading the data

Monitored and fixed the issues during the ODI full load and incremental Load.

Built ODI Yellow Interfaces, Blue Interfaces /mappings as per custom requirements

Built ODI Packages as per custom requirements.

Built ODI Procedures as per custom requirements.

Generated ODI Scenarios as per custom requirements.

Scheduled ODI jobs in auto mode.

Involved in client interfacing and cross functional infrastructure teams in analyzing the system architecture and translate them into architectural design documents and involved in requirements gathering.

Validated the Source data and Target warehouse data after loads.

Responsible for all activities related to the Implementation, administration and support of ETL ODI processes including customization of Prebuilt (OOB) Applications.

Environment: OBIEE 11.1.1.8.1, Oracle 11g, Exalogic, Exadata, ODI Apps, Peoplesoft 9.2, OBAW,

Web Logic Server 10.3.6, Linux, SQL, PL/SQL, Oracle 11g, Dimensional Modeling.

GE Power & Water Atlanta GA JUN 2014 – OCT 2014

Role: Architect (OBIEE/OBIA/ODI)

Responsibilities:

Conducted meetings and Design sessions with Business Users, Analysts from OLTP and OLAP.

Documented the technical architecture, physical components, requirements and delivery of the components.

Configured BI APPS 11.1.1.7/8 (ODI/ETL, Configuration/Functional Setup Manager and OBIEE/RPD/Reports/Dashboards) on distributed environment and implemented Oracle out of the box Prebuilt Analytics.

Documented the technical architecture, physical components, requirements and delivery of the components.

Defined Application tier, ELT and Database tier for OBIA architecture.

Configured BI APPS 11.1.1.7/8 (ODI/ETL, Configuration/Functional Setup Manager and OBIEE/RPD/Reports/Dashboards) on distributed environment and implemented Oracle out of the box Prebuilt Analytics.

Defined Data Standards, Guide Lines and Best Practices.

Customization and validation of all the OOB Dashboards: Financial Analytics dashboards against EBS 12R3 Source.

Built ODI Yellow Interfaces, Blue Interfaces /mappings as per custom requirements.

Built ODI Packages as per custom requirements.

Built ODI Procedures as per custom requirements.

Generated ODI Scenarios as per custom requirements.

Scheduled ODI jobs in auto mode.

Configured BIACM components, Dimension and fact groups as per ODI Load plan.

Configured ODI Domain load only plan and Custom data plan for loading the data

Monitored and fixed the issues during the ODI full load and incremental Load.

Defined Data Standards, Guide Lines and Best Practices.

Customization and validation of all the OOB Dashboards: Financial and Supply Chain Analytics dashboards against Oracle EBS Source System.

Involved in client interfacing and cross functional infrastructure teams in analyzing the system architecture and translate them into architectural design documents and involved in requirements gathering.

Responsible for all activities related to the Implementation, administration and support of ETL ODI processes including customization of Prebuilt (OOB) Applications.

Customized GL related stack as per business requirements.

Environment: OBIEE 11.1.1.8.1, Oracle 11g, Exadata, ODI Apps, ODI11g, Oracle EBS 12R23, OBAW, Web Logic Server, Linux, SQL, PL/SQL, Oracle 11g, Dimensional Modeling.

Sony PlayStation FosterCity CA OCT 2013 – MAY 2014

Role: Architect

Responsibilities:

Installation and Configuration, Upgradation with OBIEE 11g, BI Apps 7.9.6.4 on Linux 64 bit server.

Provided the OBIEE architecture with client specific design.

Designed packages and deployed as per the client EBS HRMS module.

Configured ETL Source files for HRMS and Financial modules. Designed and customized OBIEE RPD as per HRMS and Financial modules.

Done Fit Gap analysis to meet system and Business requirements

Integrated OBIEE11g, Informatica 901, DAC service components, High availability architecture, and custom development.

Worked on performance tuning of the custom reports.

Environment: OBIEE 11.1.1.7, Oracle 11g, BI Apps 7.9.6.4, EBS11.1.5.8, EBS12R13.

Activision Exalytics LA CA MAY 2013 – SEP 2013

Role: Sr BI Lead

Responsibilities:

Installed and upgraded OBIEE 11g, BI Apps 7.9.6.3, on Linux 64 bit Exalytics server.

Provided the OBIEE architecture with client specific design

Validated all the out-of-the box dashboards and resolved issues in configuration for the reports with errors.

Worked on reports Performance tuning.

Implemented object and data level security & custom Aging Buckets beyond the ones supported out-of-the box.

Implemented Usage Tracking and developed custom reports with new aging buckets.

Deployed and tested Financial, Procurement Spend, and Manufacturing Analytics.

Worked on performance tuning of the custom reports.

Integrated OAM SSO with OBIEE11g & PHP with OHS server and OBIEE11g.

Environment: OBIEE 11.1.1.6.9, Linux 64 Bit, Exalytics,Exadata, OBIEE 11g on Windows, BI Apps 7.9.6.3

Regal Beloit WI MAR 2013 – MAY 2013

Role:Sr BI Lead

Responsibilities:

Implemented Initialization blocks to populate Session and Repository variables which were used to default the reports for Current Quarter id, Current Month id etc.,

Created Conditional Agents to trigger Alerts and send email to users notifying the action to take. Dashboard Page which is used to get the Shipment details regularly.

Implemented Guided Navigation to let users see only relevant reports based on different business scenarios.

Worked on Agents to send alerts to the Managers.

Enables Caching for better performance and implemented Event Pooling for Automatic Purging of Stale data.

Environment: OBIEE 11.1.1.5, Oracle 11g, EBS AIX 64 Bit, OBIEE11g on Windows, BI Apps 7.9.6.3

Oracle India NOV 2012 – FEB 2013

Role:Sr BI Lead

Responsibilities:

Custom design from EBS Source identified the core area includes BOM, Material system Items, BOM resources, BOM standard operations, Material On Hand Quantities detail with Positive inventory and negative inventory.

Developed and delivered the below metrics definitions

Inventory Daily Balance Fact

Inventory Monthly Balance Fact

Material Transaction fact

Items Metrics

Resources Metrics

Standard Operations Metrics

On-Hand Inventory by Item Metrics

Production to Plan Metrics

Analyzed the Source qualifier queries from Informatica mappings SQQuery mapplets.

Picked up the Source qualifier queries, based on joins, builded Yellow interfaces and Blue interfaces.

Built custom Procedures and mappings/interfaces.

Based on lookups in Informatica converted the lookup data in the ODI mappings/ interfaces.

Built Packages based on flow control and check control.

Generated/ Built Scenarios for automated Load Plan.

Defined Mail alerts to business users based on Job flows.

Ran the ODI scenarios/Packages meet the existing processed data.

Verified and validated the data from one environment to other environment.

Automated ODI jobs based on task level.

Defined load plan executions.

Migrated custom code to different instances.

Environment: OBIEE 11.1.1.5, Oracle 11g, Linux 64 Bit, OBIEE11g on Windows, BI Apps 7.9.6.3, Informatica 9.0.1, ODI 11g

Chesapeake Energy MAY 2012 – OCT 2012

Role: BI Lead (OBIEE/OBIA)

Responsibilities:

Installation, configuration using OBIEE 11g, BI Apps on Linux 64 bit server using HR/Financial Analytics.

Provided the OBIEE architecture with client specific design

Integrated OBIEE11g, Informatica 901, DAC service components.

Implemented Security concepts like Authentication, Authorization and LDAP Configuration.

Implemented Usage Tracking.

Environment: OBIEE 11.1.1.5, Oracle 11g, PeopleSoft 9.0, Linux 64 Bit, Windows, BIApps 7.9.6.3

GE Capital DEC 2011 – APR 2012

Role: BI Consultant

Responsibilities:

Installed OBIEE11g and configured the new Rpd and catalog.

Implemented most of the OBIEE 11G features like Map viewer, Master Detail Hierarchies, Master Detail Linking, Slider functionality and etc..

Involved in Design and Development of OBIEE 11g Rpd and Reports.

Delivered robust technical solutions by leveraging the technical expertise.

Developed various Complex OBIEE reports using various report views.

Environment: OBIEE 11.1.1.5, Oracle 11g, Win 2003

BTC-CTB RDC Kinshasa SA NOV 2009 – OCT 2010

Role: Sr Software Engineer

Responsibilities:

Partnered with the OBIEE team in gathering and analyzing business requirements from various sources, ensuring the business needs and delivery feasibility.

Worked with the ETL team to design the Star Schema and populate the Data warehouse.

Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.

Configured Web Catalog Objects (Dashboards, Pages, Folders and Reports) and Implemented different views of report i.e. Pivot table, Titles, Graph, Filters etc.

Created Users, Groups and giving the permissions in Administration Tool and verified the permissions of the users in the OBI domain

Designed Interactive Reports & Dashboards and created dashboard prompts with multiple selections.

Integrated reports created in Oracle BI Publisher with Oracle Business Intelligence Enterprise Edition.

Environment: OBIEE 10.1.3.4, Oracle 10g, Win 2003

VODACOM RDC Kinshasa SA MAR 2008 – OCT 2009

Role: Sr Software Engineer

Responsibilities:

Understanding the Business requirements, Involved in Designing and OBIEE Repository as per Business Needs.

Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business, and presentation layer of the repository.

Performed Repository Testing and validation before exposing Business Models in the Presentation layer.

Creating the requests in answers and see the results in various views like title, table, compound layout, chart and pivot table.

Created Reports & Dashboard prompts and Page prompts for better understanding of the trends.

Environment: OBIEE 10.1.3.3, Oracle 10g, Win 2003

CLIC RDC Kinshasa SA NOV 2007 – FEB 2008

Role: Sr Software Engineer

Responsibilities:

Creating and maintaining the databases as per OFA Standards.

Participate with application development team to design Oracle Database.

Creating Tables, Indexes, Sequences, Constraints, Triggers and Procedures.

Security Management by allocating proper privileges.

Sizing Table space and rollback segments and undo table space.

Used Oracle Export & Import utilities to defragment, upgrade and copy database

Planning and scheduling backup and recovery procedures.

Refresh of production data into UAT by restoring and recovering databases for user tests and requirements.

Environment: Oracle 10g, Linux

ILTC, Manhattan, New York DEC 2006 – NOV 2007

Role: Software Engineer

Responsibilities:

Designed, Developed JSP Pages.

The JSP Form processing is implemented by the JavaBeans.

Presentation to the clients at various stages of the project.

Through testing of each module of the application.

Created, designed and implemented a Status e-mail management system using JavaMail and Servlets.

Environment: Windows 2000/XP, J2SDK1.4, Apache Tomcat 5.0, MySQL

Seacom Inc, New York APR 2006 – DEC 2006

Role: Software Engineer

Responsibilities:

Documented the existing code and made appropriate changes to implement new features in the application.

Performed coding in Servlets and JDBC to implement modules of the supply chain management system.

Installed and Configured Tomcat Application Server.

Deployed the application on the Application Server.

Handled application performance and some application monitoring issues.

Implemented SQL queries for data retrieval and storage in the database.

Environment: HTML, SQL, Servlets, JDBC, Jsp, Tomcat, Visual Age for Java, Windows 2003 Server

Glint, Edison, New Jersey APR 2005 – MAR 2006

Role: Software Engineer

Responsibilities:

Designed, developed Forms.

Presentation to the clients at various stages of the project.

Designing of User forms and reports

Through testing of each module of the application.

Environment: Windows 2000/XP, Visual Studio 6.0, MS SqlServer.

Contact this candidate