Data Developer

raProfessional Summary:

** ***** ** ****** *** rich Business Intelligence experience with exposure of some versatile, medium to large scale Datawarehousing 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 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 done Requirements gathering, Design, Development, Implementation, Migration, Testing for various ETL implementations using Informatica. Worked extensively and designed ETL solutions using sources like Oracle EBS R12, JD Edwards, Siebel ERP

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

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

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

Well versed with data extraction from Essbase and creating reports in Interactive Reporting Studio.

Extensively performed Performance Tuning of BI, ETL and Database artifacts using industry best practices and 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:

Informatica 9.x, Informatica 8.x, OBIEE 11.x, OBIEE 10.x, Oracle BI Publisher 10.x/11.x, BI Apps 7.9.6.3, DAC 10.3.4.1, Essbase 9, BRIO 8, Hyperion Interactive Reporting Studio, Business Objects XI, Cognos Reportnet, Oracle Enterprise Manager (2.1.0), 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

Awards and Achievements:

Company:

Award Details:

Infosys Ltd

Received Bravo award twice in 2013 for Performance Excellence

Mahindra Satyam Ltd

Pat-on-back award for Project Performance Excellence

WORK EXPERIENCE:

Baker Hughes (Infosys is implementation partner), Houston - TX April 2016 – May 2016

Sr. ETL Support Consultant

Contributions/Responsibilities:

Production Support:

Worked for D2 project to facilitate the Informatica Enhancement activities

Source systems was SAP and Target system was Hyperion.

Enhancement1: The data in oracle db D2BI(Materialized Views) was extracted in separate jobs into data files(.csv) and further used to load Master data and dimensions in Essbase Revenue Cube.

Enhancement2: Created ETL Informatica mappings/workflows to extract data from SAP and Data Files, process and load into D2BI datawarehouse tables. The data from these tables is extracted into .csv format reports(4 reports) which is then intended to be used by the Business Users.

Environment: Informatica 8.x, Oracle 11g, Oracle SQL Developer

Nintendo, Seattle - WA Jan 2016 – March 2016

Sr. Data Warehouse Consultant

Contributions/Responsibilities:

Development/Enhancements:

Interacted with users and gathered Requirements for a new development activity for Inventory Transaction Register.

Analyzed and Designed Star Schema for Material Transactions Data using Kimball Dimensional Modelling techniques

Designed the complex Full Load and Incremental ETL logic for populating the Fact and Dimension tables

Development of ETL SDE, SIL mappings using Informatica 9.5

Populate data by scheduling Data Loads using DAC

Configure RPD to create new subject area, logical dimensions/facts, import physical tables etc for the new data model.

Create Inventory Transaction Register report using OBIEE 11g and Testing/Data Validation of same.

Unit Testing and Code migration to Test/UAT environment

Documentation of Design, Test Cases, Migration etc.

Work on other enhancements as per the priority of tasks assigned using AGILE methodology.

Performance Tuning of ETL mappings using best practices.

Production Support:

Monitor the daily Data Loads

Debug any data load failures, fix and make sure the loads are completed on time

Work on the defects logged in by users in servicenow

Provide solutions, unit testing for defects and facilitate UAT

Migrate code from Dev to Test, Test to UAT

Environment: Informatica 9.5, OBIEE 11.1.1.7.x, DAC ETL Scheduling Tool, Oracle 11g, Oracle SQL Developer, Unix, Oracle Applications (Finance module, Inventory, Material Transactions) R12, Servicenow

Amazon Inc, Seattle - WA Jan 2015 – Jan 2016

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 ETL design for these modules and Reporting modules as well.

In detail, have worked on following areas on a high level:

1.Requirements Gathering, Analysis and documentation

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

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

4.Implementation/Development of ETL objects (Mappings, Workflows, Scheduler Jobs) and Database Objects (Tables, Index, Partitions etc) and BI (Reports, Dashboards, RPD), BI Publisher (Dashboards, Data Models, Report Templates, Reports, Bursting),

using SCRUM and AGILE methodologies.

5.Code migration, Integration Testing, UAT of ETL code and BI 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: Informatica 9.x, OBIEE 11.1.1.7.x, Oracle BI Publisher 11.x, DJS ETL Scheduling Tool, Oracle 11g, Teradata, 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.Enhancements and Maintenance of existing BI Publisher 10g reports and dashboards, Data Models, Templates etc.

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

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

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

i.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.

j.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.sUser 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, Oracle BI Publisher 10.x, Informatica 9.x, Oracle Datawarehouse Administration Console, Oracle 10g, Essbase 9, Interactive Reporting Studio, Oracle SQL Developer, Unix, Remedy, ServiceNow

Employer: Infosys (empid: 147614)

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 TFS Process (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 achieve approximately 60% improvement in baseline and Incremental load times.

Environment: OBIEE 11.1.1.6.x, Informatica 8.x, Oracle Datawarehouse Administration Console, Oracle 11g, Oracle JDE, Teradata, 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

Created BI Publisher artifacts: Data Models, Dashboards, Report Templates, Reports etc for Financial reporting – Tax Forms and Income Statements reports.

Used Bursting feature to email Reports as per timely schedules to the required audience. Sources included BI Datawarehouse and JD Edwards source tables too.

Integrated BI Publisher reports with EBS R12 tool.

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, Oracle BI Publisher 11.x, 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)

Integrated Map Viewer with OBIEE 11.x for Outage Analytics dashboard.

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

Employer: Mahindra Satyam

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.

Contact this candidate