Sr. Business Intelligence Consultant

Professional Summary:

•          11+ years of strong and rich Business Intelligence experience with exposure of some versatile, medium to large scaleDatawarehousing implementations

•          Have Analyzed, Designed and created Data Structures/Architectures/Models for various Data Warehouses.

•          Have implemented various Custom and Pre-Packaged Datawarehousing Projects primarily using reporting tools like OBIEE, Business Objects, Brio etc and ETL tools like Informatica, DAC.

•          Have successfully handled various Project Roles such as Developer, Sr.Developer, Team Lead, Offshore Lead, Consultant,Sr.Consultant, Onsite Lead and Technical Lead

•          Have worked on various Domains like

Finance, Manufacturing, Oil and Gas, Insurance, Banking, Telecom, Utlities etc.

•          Proficient with all phases/stages of Software Development Life Cycle (SDLC), Software Engineering Techniques, Data Management etc.

•          Incorporated the project delivery methodologies AGILE and SCRUM in tracking daily project deliverables.

•          Have implemented Development, Enhancements and Production Support for following BI-Apps modules: Supply Chain Management (Inventory Analytics) , Procurement and Spend Analytics, Human Resources Analytics, Finance Analytics, Custom Built Analytics

•          Have worked extensively and designed BI Solutions in OBIEE. Worked in MUDE environment, RPD Development & Customization, Dashboards, BI Answers, BI Publisher, OEM and Weblogic.

•          Have designed ETL lanscapes (Physical and Logical models), worked extensively and designed ETL solutions in Informatica. Worked on Informatica Client tools and well versed with IDQ, MDM. Used Oracle EBS R12, JD Edwards, Siebel ERP applications as sources for ETL.

•          Well versed with ETL tools Datastage, ODI and ad-hoc reporting tools like BRIO/Hyperion Interactive Reporting Studio, Siebel Analytics for ad-hoc reporting analysis and reporting. Proficient in Business Objects XI and Tableau 8.1.

•          Extensively performed Performance Tuning of BI, ETL and Database artifacts using best practices and industry standards.

•          Extensive experience in Data Modelling and Dimensional Modelling using visio.

•          Have worked extensively on DAC. Created various DAC objects like Containers, Execution Plans, Subjet Areas, Tasks etc and scheduled loads accordingly.

•          Have provided Daily/Weekly status reports, Estimates for deliverables, prepared Project Plans etc.

•          Have worked in Onsite/Offshore model and led small to medium sized development teams successfully.

EDUCATION:

Bachelor of Technology in Electronics and Communications Engineering from a well reputed University in India.

TECHNICAL SKILL SET:

Application Tools: OBIEE 11.x, OBIEE 10.x, Tableau 8.1,Informatica 9.x, Informatica 8.x, BI Apps 7.9.6.3, DAC 10.3.4.1, BRIO 8, Hyperion Interactive Reporting Studio, Business Objects XI, Cognos Reportnet, Oracle Enterprise Manager (2.1.0), Siebel Analytics 7, Siebel 7.8, Oracle EBS R12, JD Edwards
Databases & Tools: Oracle 11g/10g/9i/8, DB2, TOAD, SQL Navigator, SQL*PLUS, SQL* Loader. SQL Developer
Scripting Languages: Unix Shell Scripts
Languages: SQL, PL/SQL
Operating System: Unix, Linux, Windows 7/2003/2000

 

WORK EXPERIENCE:

Amazon Inc, Seattle – WA Jan 2015 – Current Date

Sr. Data Warehouse Consultant

Contributions/Responsibilities:

•         Have designed Warehouse Architecture and all the Data Models for VT BI Finance Module.

•         Primarily responsible for Virtual Trader Inter Company Transfers BI Finance Module – Phase 1, 2 and currently working in Phase 3. Have designed and implemented Reporting and ETL design for these modules.

•         Have also worked on other Enhancements – Input VAT OFA report, Spain Form 347 Reports etc

•         In detail, have worked on following:

1.      Requirements Gathering, Analysis and documentation

2.      Data Modelling and Dimensional Modelling, preparing SQL DDL, DML scripts. Writing SQL queries andPL/SQL procedures as per the requirements.

3.      Solution Designing for BI (Reports, Dashboards, RPD) and ETL (Mappings, Workflows, Scheduler Jobs)

4.      Implementation/Development of BI (Reports, Dashboards, RPD) , ETL objects (Mappings, Workflows, Scheduler Jobs) and Database Objects (Tables, Index, Partitions etc) using SCRUM and AGILE methodologies.

5.      Code migration, Integration Testing, UAT of BI and ETL code

6.      Schedule and Monitor jobs in DJS (Scheduling Tool)

7.      Design, Code Walkthroughs to Users and team

8.      One-on-one Coordination/Interaction with Functional team, Users, Admin Team, other BI Team members

9.      Creation and Maintenance of documentation in sharepoint

10.  Performance Tuning of BI(Reports, RPD), ETL (Mappings, Mapplets) and Database objects (Indexes, Partitions, Constraints, Views, Materialized Views etc).

11.  Follow SCRUM and AGILE methodology for development activities to ensure effective and prompt deliveries.

 

Environment: OBIEE 11.1.1.7.x, Informatica 9.x, DJS ETL Scheduling Tool, Oracle 11g, Oracle SQL Developer, Unix, Oracle Applications (Finance module) R12

 

Allegion, Indianapolis-MI June 2014 – Dec 2014

Sr. Data Warehouse Consultant

Contributions/Responsibilities:

1.       Development and Enhancements:

a.       Responsible for Data Modelling and Dimensional Modelling for new Development tasks.

b.      As part of development activities, creating new objects like Reports/Dashboards/iBots in BI Answers and BI Dashboards.

c.       RPD development is carried in an MUDE setup.

d.      Created and maintained Informatica Artifacts (Mappings, Workflows and DAC Execution Plans). Database side changes as per the requirements are also in scope.

e.       Unit Testing of individual objects created/modified as part of development/enhancement

f.        Migration of objects from one environment to another environment.

g.       UAT – getting objects ready for UAT and coordinating with Users for User Acceptance Testing.

h.      Code deployment in Production:

i.   Coordinate with DBA teams, Users and Business Analysts for Code deployments in Production.

ii. Code Migration (OBIEE, Informatica and DAC migrations) from UAT to PROD environments and post-migration validations before handing over to Users for their validations.

i.         Documentation: Capturing design, development and testing results in documentation and maintaining the documentation in dedicated Sharepoint folders.

2.       Data Loads Support: Provided production support for Data loads ranging from Daily, Weekly to Monthly frequencies. There are 4 loads that run daily, 2 Weekly loads and 2 Monthly loads.

3.       Ticket Management: Creating/Handling/Processing tickets based on tools Remedy and ServiceNow. There are 2 types of tickets – UMS and IRMS which stand for User Management and Incident Resolution Management.

4.       User Access Management: Managing User authentication profiles i.e., Creating new User Profiles, Modifying existing User Profiles and Deleting Outdated Profiles using a custom home-grown user interface. The authentication flow is designed using External Database Table Authentication and LDAP.

5.       Direct Client Interactions: Interact directly with clients on requirements and tickets. Follow up with Clients on User Access tickets, incidents/issues on an On-Demand basis and make

6.       Offshore Interaction: Interact daily with offshore team members to discuss on deliverables.

7.       Actively Organize Weekly Status Meetings, Code Review meetings, Monthly Deployment Plan meetings etc.

 

Environment: OBIEE 10.x, Informatica 9.x, Tableau 8.1, Oracle Datawarehouse Administration Console, Oracle 10g, Oracle SQL Developer, Unix, Remedy, ServiceNow

 

 

Weatherford Inc., Houston-TX Jan 2013 – June 2014

Sr. BI Consultant/Tech Lead

Contributions/Responsibilities:

1.       Project Management: Managed all project management activities like Project Scoping, Preparing Project Estimates, Project Plans and Project Roadmap, Understanding Client Expectations and driving project deliverables.

2.       Team Leading: Led 2 teams of sizes 4 and 3 associates respectively. First team of 4 is a BI Development and Production Support team and the second team being an Informatica ETL team for code conversion from Datastage to Informatica.

3.       Planning and Coordination: Was responsible for Gather Requirements, Planning and communicating daily activities/deliverables of team members, Coordinating with different teams, Investigations of UAT/Data Issues reported by Users, Preparing and Presenting Weekly Status Reports during the Weekly Status Meetings.

4.       Responsible for Data Modelling analysis and preparing physical schema’s using Dimensional Modelling technique.

5.       Code Migrations and Development Activity Tracking: Responsible for Coordinating with Admins for getting all migrations done from DEV to QA and from QA to PROD, and responsible for Tracking and Maintenance of the development tickets through TFSProcess (Development/Enhancements ticket tracking system)

6.       Process Improvement: Proposed ideas to introduce new processes and ideas to improve existing processes in the current Development Environment architecture. Designed/Developed process guides and document templates like Weatherford BI Introduction PPT, TFS Process Quick Reference, Weekly Status Report, Development Object Tracker, Consolidated BI Objects List, etc.

7.       Web Catalog Development and Customizations: Responsible for Design and Creation of new as well as customization of existing Dashboards/Reports/Dashboard Prompts/Agents(ibots) for Subject Area Supply Chain Inventory Analytics.

8.       Prepared Design of Custom Inventory Balance related Reporting requirements using BI Answers and BI Publisher

9.       Developed BI Publisher Data Models, Templates, reports and Dashboards

10.   RPD Customizations – Development of new objects as well as customization of existing objects of Physical Layer, Logical Layer and Presentation Layer(including new Session and Repository Variables, Projects etc). Responsible for RPD Patch file migration – patch file creation for migrating any modifications/additions to RPD

11.   ETL Development and Maintenance: Created new as well as customized existing SDE & SIL ETL mappings as part of enhancements and data fixes. Scheduling Data Loads in DEV, QA on demand basis. Data Load Monitoring, debugging ETL Load Failures by querying against the source which is Oracle JDE

12.   DAC Customization: Created new DAC execution plans from scratch (including creation of new Task Actions, Tasks, Subject Areas, Imported Tables/Indices from database etc)

13.   Documentation: All documentation relating to all development activities – Functional Requirements Doc, Technical Design Document, Migration Document, Unit Test Cases and Results

14.   Miscellaneous:

a.       Designed and Created a data model in RPD over DACADMIN schema to query and see all the DAC Loads details, Individual DAC Objects details etc on dashboards.

b.      Was responsible for analysis and leading 2 phases of the Data Load Performance Optimization activity. This involved identification of bottlenecks in Daily Data Loads, analysis of solution to bottlenecks and implementation of the same. We could achieve approximately 35% improvement in baseline and Incremental load times.

 

Environment: OBIEE 11.1.1.6.x, Informatica 8.x, Informatica IDQ and MDM, Oracle Datawarehouse Administration Console, Tableau 8.1, Oracle 11g, Oracle JDE, Win 2007, Toad

 

Mustang Engineering, Houston-TX Jan 2012 – Jan 2013

Sr. BI Consultant/ Tech Lead

Responsibilities:

•          Responsible for preparing Data Models and physical STAR Schemas using Dimensional Modelling technique.

•          Provided training, mentored and led a team of 4 for implementing OBIApps 7.9.6.3 from scratch

•          Participated in Requirements Discussions with Users/Clients/Business Analysts

•          Installation and Configuration of OBI Apps 7.9.6.3 Financial Analytics and HR Analytics in DEV environment

•          Provided support to Admins for Installation and Configuration of OBI Apps 7.9.6.3 in QA and PROD environments

•          Prepared Project Plan, Development Estimates and assigned activities to individual team members

•          Prepared Design of Custom Income related and Finance related Reporting requirements using BI Answers and BI Publisher

•          Developed BI Publisher Data Models, Templates, reports and Dashboards

•          Prepared and maintained documentation of Installation and Configuration processes and steps in Sharepoint

•          Responsible for documenting weekly updates and hosting weekly status meetings with stakeholders

•          Closely interacted with EBS team to identify and understand EBS R12 schema source database tables, EBS front end data entry process.

•          Interacted with EBS team to get High level knowledge in EBS suite & understanding EBS R12 database schema

•          Developed Custom OBIEE Dashboards, Prompts, Reports using various Pie Charts, Vertical and Horizontal Bar Graphs, Pivots, Tables(with hierarchy objects), Traffic Lights, Gauges as per the captured requirements

•          Customized RPD – Created new Dimension Tables and Fact Tables as required, Created new Level Based measures, customized existing hierarchy levels, created new variables, presentation tables

 

Environment: OBIEE 11.1.1.0, OBIEE 10.1.3.4.x, Informatica 8.x, DAC, Oracle 11g, Oracle EBS R12, Win 2003, Toad

 

Oracle (Utilities Division), Hyderabad-India July 2010 – Dec 2011

Sr. BI Consultant/Team Lead

Responsibilities:

•          Led a team of 4 to build a reporting platform for Oracle’s Utility applications

•          Delivered Training to team on OBIEE 10g/11g and mentored them throughout the project

•          Requirements Gathering and documenting Functional Specifications

•          Design complex Dashboards, Reports, KPI’s etc for applications like Work Asset Management(WAM), Customer Care & Billing (CCB), Metered Data Management(MDM), Outage Analytics and Mobile Workforce Management(MWM)

•          Bundled a consolidated BI solution for all the above applications called OUBI (Oracle Utilities Business Intelligence)

•          Installation of OBIEE 10.1.3.4.x, OBIEE 11g, Informatica 8.x

•          Migration of OBIEE 10g code to 11g version

•          Integration of spatial and operational analytics with OBIEE 10g

•          Planning, Organizing and coordinating activities of team members

•          Preparing estimates for project plans and development activities and maintaining them in Microsoft Project.

•          Designed and Created the Data Model and Database structure for the warehouse

•          Created new mappings to populate the dimension and fact tables

•          Maintained Informatica repository and metadata

•          Coordinated with DBA’s to identify and create Materialized Views and Aggregate Tables in Database to improve the performance of reporting

•          Analysis on performance improvement in OBIEE, Informatica and Database side.

Environment: OBIEE 11.1.1.0, OBIEE 10.1.3.4.x, Informatica 8.x, Oracle 11g, Win 2003, Toad

 

Applied Materials, Santa Clara-CA January 2008 – May 2010

Sr. BI Developer

Responsibilities:

•          Interacting directly with Users to understand requirements and resolve clarifications

•          Technical Design Documentation of Reports and Mappings

•          Development of new reports and dashboards in OBIEE

•          Development of new Informatica Mappings to extract source data, transform it and load into datawarehouse

•          Development of Custom RPD

 

Environment: OBIEE 10.1.3.4.x, OBIEE 10.1.3.2.x, Informatica 8.x, IBM DB2, Win 2003, Toad

 

Citibank, Englewood-NJ June 2007 – December 2007

Sr. BI Developer

Responsibilities:

•          Technical Design Documentation of Reports and Mappings

•          Development of new reports using a tool called Exstream Dialogue(now called HP Exstream)

Environment: Exstream Dialogue, Oracle 9, Unix, Toad

 

 

 

Agilent Technologies, Hyderbad-India December 2006 – May 2007

Sr. BI Developer

Responsibilities:

•          Siebel analytics 7 to OBIEE upgradation.

•          Development of new reports and dashboards in OBIEE using source as Siebel 7.8

•          Development of Custom RPD

•          Development of new Informatica Mappings to extract source data, transform it and load into datawarehouse

•          Technical Design Documentation of Reports and Mappings

Environment: OBIEE 10.1.3.2.x, Siebel Analytics 7, Siebel , Informatica 7.x, Hyperion Interactive Reporting Studio, Oracle 8, Win 2003, Toad

Blue Cross Blue Shield, Hyderabad-India December 2005 – November 2006

ETL Developer

Responsibilities:

•          Monitoring Production loads for Daily, Weekly, Fortnightly and Monthly Informatica Jobs

•          Debugging load failures, fixing them and completing the loads

•          Enhancements to Informatica mappings and code migration

•          Documentation of failures in error log

Environment: Informatica 7.x, DB2, Unix, Toad, Cognos Reportnet

 

Hartford Life Insurance, Hyderabad-India May 2004 – November 2005

BI Reports Developer

Responsibilities:

•          Development of new Universe, Query and reports in Business Objects 6.x

•          Conversion of ad-hoc reports from homegrown reporting tool to Brio 8

•          Enhancement and support of existing Brio 8 ad-hoc reports

Environment: Business Objects 6.x, Brio 8, Oracle 8, Toad, Windows 2000.