Profile
• Done Bachelor of Engineering in Electrical Engineering and have sixteen years of experience in IT.
• Strong skills and extensive experience in complete life cycle (System Analysis & Design, Data Modeling, Development, Testing and Implementation) of BI / Data warehouse Applications.
• Specialized in designing and developing Oracle BI EE 10g/11g repository with physical, logical and presentation layers.
• Excellent aptitude in Data Modeling, designing Star Schema / Snowflake Schema methodologies using OBIEE Administration tool.
• Specialized in designing and developing reports and interactive dashboards with intuitive drilldowns, drill-across and drillable charts, sub reports, guided navigation using Oracle Answers and Dashboards. Experience in BI Publisher.
• Specialized in writing Oracle PL/SQL, database design, development, query optimization, performance tuning, trouble shooting, writing database triggers and stored procedures/functions and packages and administrating database using Oracle Enterprise Manager.
• Experience in implementing Oracle BI security setup (Integration with LDAP, creation of groups and their privileges). Experience in implementing External Table authentication/authorization.
• Experience in implementing Usage Tracking, Write Back feature, UI Customization.
• Experience in performing end to end testing including Data Validation, Unit Testing and User Acceptance.
• Experience in OBIEE performance tuning using Aggregate Tables/Materialized views and by optimizing SQLs, cache management, purging cache after ETL completes, and seeding cache.
• Experience in OBIEE upgrade from 10g to 11g.
• Experience in installation and configuration of Oracle Business Intelligence Applications (OBIA) for Finance, Procurement and Human Resource modules.
• Experience in writing Unix shell scripts.
• Experience in working on Amazon Redshift Database. Exposure with cloud computing infrastructure solution such as amazon EC2, S3.
• Excellent analytical, programming and business-to-technical communication skills.
• Excellent interpersonal skills, ability to interact with people at all levels, good presentation skills, excellent team player, ability to meet deadlines.
• I have been involved in end-to-end implementation of medium-to-large scale projects particularly CRM Data warehouse for Hewlett Packard USA and Middle East clients.
• Seven years experience of working at onsite in US, Middle East and South Africa.
Qualifications
Bachelor of Engineering in Electrical Engineering
From Indian Institute of Technology-Roorkee (Formerly University of Roorkee – Roorkee).
Technical Skills
Operating Systems Unix, Linux, Windows Server Family, Windows XP
Languages SQL, PL/SQL, Unix Shell Scripting
Data Warehouse and ETL Tools Oracle Business Intelligence EE 11.x/10.x (Answers, Dashboards, BI Publisher & Delivers), Informatica 5.x/7.x/8.x, , Oracle Business Applications 7.9.6, Oracle Data Integrator, Oracle Warehouse Builder, Microsoft SQL Server 2005 SSIS, SSAS, SSRS
RDBMS Oracle 9i/10g/11g, Amazon Redshift Database, Postgres, SQL Server 2005
Data Modeling Oracle Designer, Erwin
Web/Application Server OC4J, Oracle Application Server
Version Control & Other Tools Visual Source Safe, Toad, SQL Tools, SQL Developer, Redwood Explorer
Career Summary
Nov 2013 – Present
Sears Global Technologies, Pune, India
(A Sears Holdings Corporation Company), NeuStar Inc, VA, US
Technical Specialist
Project Description – Business Analytics and Reporting
Neustar, Inc. is provider of real-time information and analysis to the Internet, entertainment, telecommunications, information services, financial services, retail, media and advertising sectors.
Neustar maintains data collected by its various OTLP systems and implemented data warehouse and reporting system to provide analytical solutions and KPIs to internal and external customers.
Responsibilities:
• Write and maintain ETL scripts written in Postgres and Redshift to pull the data from source systems and load into staging area and then into data warehouse.
• Schedule and monitor job chains created in Redwood explorer that calls the ETL scripts.
• Provide 24/7 support for any failures/issues in ETLs.
• Covert existing Postgres scripts into Redshift flavor and migrate to Amazon Redshift database. Eventually Postgres database will be decommissioned.
• Review the database design, table design in Redshift database w.r.t. distribution style, sort key and compression encoding to achieve optimum ETL time and best performance in reporting.
• Writing shell scripts to process source data files.
• Study and analysis of the business requirement and accordingly identifying reports and dashboards with client’s BA.
• Review the data model and make necessary changes in the database, data model, RPD and dashboards to incorporate new requirements or enhancements.
• Development of the reports, intuitive drilldown dashboards using Answers/Dashboards charts.
• Perform unit testing and worked with the business users at various stages of the UAT to ensure that measures have been implemented correctly.
Environment: Oracle BI EE 11g, Amazon Redshift Database, Postgre SQL, Stado, Redwood Explorer, Linux, Windows 7
Jan 2012 – Oct 2013
FCS Inc. (A TEKsystems Global Services), USA
New Breed Logistics, High Ponit, NC
Sr. OBIEE Consultant
Project Description – Supply Chain Business Intelligence
New Breed is privately held third-party logistics services provider that helps companies design and operate efficient supply chains. It manages millions of square feet of warehouse space across more than 50 distribution centers in the U.S. Services range from distribution center operations and transportation management and technology-focused solutions involving product assembly, vendor managed inventory, reverse logistics and repair, manufacturing support, and supply chain consulting.
This project is to implement various KPI’s and score card reports on supply chain business analytics and few operational reports for Verizon.
Responsibilities: Led team of 5 members and involved in following activities:
• Study and analysis of the business requirement and accordingly identifying reports and dashboards with client’s BA.
• Reviewed the data model and have provided best inputs as per industry recommended standards.
• Act as a primary technical contact to OBIEE 10g/11g for support and enhancement issues.
• Design the Dashboards with drillable reports, pivot, narrative, title, column selector, view selector views for user interface.
• Develop Repository by creating the connection pool, database schemas. Importing objects from the ODBC data sources and creating alias tables, joining the aliases tables, joining the aliases tables by appropriate physical and logical joins.
• Designing Repository with calculations, aggregations, security, time series functions, dimensional hierarchies, set drillable paths and set the content levels of the dimensions.
• Responsible for analyzing and performance tuning of highly complex SQL queries to achieve faster downloads of reports and meet the standards of reporting.
• Anticipate potential problems and proactively recommend solutions.
• Implemented the group level security in OBI EE to setup Access privileges for its corresponding users. Authentication/Authorization will happen using User/Group tables (External Table Security).
• RPD/Report review on daily basis on the development progressed.
• Co-ordinated very closely with the New Breed BI team on the deployments and had provided immediate fix for various deployment issues.
• Implementation of security to ensure that the Verizon users can view all the data whereas OEMs can view data pertaining to themselves only.
• Performed unit testing and worked with the business users at various stages of the UAT to ensure that measures have been implemented correctly.
• Worked on upgrade from OBIEE 10g to OBIEE 11g and performed following activities:
o Installed and configured OBIEE 11g on windows and Linux environment.
o Upgraded OBIEE 10g RPD and Web Catalog to OBIEE 11g and Fixed upgraded errors and warnings in RPD , Fixed Style and Skin related issues in Report/Dashboards.
o Applied patches as and when they are available.
o Compared OBIEE 10g reports/dashboards with OBIEE 11g reports/dashboards and fixed data and formatting issues.
o Opened several Oracle SR’s for product issues and regularly interacted with Oracle support team , development team and worked closely with Oracle in resolving product Bugs.
o Added new Tags and updated existing parameters in Instanceconfig.ini and NQSConfig.ini by manually and using Web logic Enterprise Manager.
o Regularly interacted with Admin team for Administration activities – migrating RPD and Web catalog to QA and Prod environment, External Table authentication/authorization and Object Level Security by creating roles & web groups using External tables and web logic console, Implementation of Usage Tracking, Customization of Login page and skin customization.
Environment: Oracle BI EE 11g/10g, Oracle Database 11g, Unix, Windows 7
Apr 2011 – Nov 2011
Frontline Consulting Services (FCS) Inc., USA
New Breed Logistics, High Ponit, NC
Sr. OBIEE Consultant
Project Description – Supply Chain Business Intelligence
New Breed is privately held third-party logistics services provider that helps companies design and operate efficient supply chains. It manages millions of square feet of warehouse space across more than 50 distribution centers in the U.S. Services range from distribution center operations and transportation management and technology-focused solutions involving product assembly, vendor managed inventory, reverse logistics and repair, manufacturing support, and supply chain consulting.
This project is to implement various KPI’s and score card reports on supply chain business analytics and few operational reports for Verizon.
Responsibilities:
• Study and analysis of the business requirement and accordingly identifying reports and dashboards with client’s BA.
• Reviewed the data model and have provided best inputs as per industry recommended standards.
• Implemented the group level security in OBI EE to setup Access privileges for its corresponding users. Authentication/Authorization will happen User/Group tables (External Table Security).
• Created iBots and scheduled the reports which would be delivered to the email id of business users.
• RPD/Report review on daily basis on the development progressed.
• Co-ordinated very closely with the New Breed BI team on the deployments and had provided immediate fix for various deployment issues.
• Implementation of security to ensure that the Verizon users can view all the data whereas OEMs can view data pertaining to themselves only.
• Performed unit testing and worked with the business users at various stages of the UAT to ensure that measures have been implemented correctly.
Environment: Oracle BI EE 10g, Oracle 11g, Oracle Application Server 10.x, Unix, Windows Server 2008
Sept 2010 – Apr 2011
Logic Soft Inc., USA
New Breed Logistics, High Ponit, NC
Sr. OBIEE Consultant
Project Description: – Supply Chain Business Intelligence
New Breed is privately held third-party logistics services provider that helps companies design and operate efficient supply chains. It manages millions of square feet of warehouse space across more than 50 distribution centers in the U.S. Services range from distribution center operations and transportation management and technology-focused solutions involving product assembly, vendor managed inventory, reverse logistics and repair, manufacturing support, and supply chain consulting.
This project is to implement various KPI’s and score card reports on supply chain business analytics and few operational reports for Verizon.
Responsibilities:
I was involved in following activities:
• Study and analysis of the business requirement and accordingly identifying reports and dashboards with client’s BA.
• Design and development of repository to create dimension hierarchies and facts.
• Development of the reports, intuitive drilldown dashboards using Answers/Dashboards charts using global and local filters.
• Implementation of security to ensure that the Verizon users can view all the data whereas OEMs can view data pertaining to themselves only.
• Performed unit testing and worked with the business users at various stages of the UAT to ensure that measures have been implemented correctly.
Environment: Oracle BI EE 10.0.3, Oracle 11g, Oracle Application Server 10.x, Unix, Windows Server 2008
July 2010 – Sept 2010
Logic Soft Inc., USA
Activision Blizzard, Santa Monica, CA
Sr. OBIEE Consultant
Project Description: – Impulse
Impulse is an implementation of Oracle Demand Signal Repository (DSR) and subsequently customization of the OOB analytics for Sales, Inventory, Shipping and Forecast modules. The application uses Oracle EBS as data source and built in and customized analytics help the client increase revenue due to lower out-of-stocks, reduced cost due to better demand planning and more streamed IT environment.
Responsibilities:
I led team of 3 members and involved in following activities:
• Customized out-of-the-box dimensions to remove/add hierarchical levels as per client’s business model.
• Created measures in the OOB facts – Sales, Inventory, Shipping and Forecast.
• Created new Materialized Views for better performance.
• Development of the reports, intuitive drilldown dashboards using Answers/Dashboards charts using global and local filters.
• Performed unit testing and worked with the business users at various stages of the UAT to ensure that measures have been implemented correctly.
Environment: Oracle BI EE 10.0.3, OWB, Oracle 11g, Oracle Application Server 10.x, Unix, Windows Server 2008
Jan 2010 – June 2010
Infogain India Pvt. Ptd., India
Urban Planning Council, Abu Dhabi
Technical Architect/Analyst
Project Description – BI & Enterprise Reporting System
The Abu Dhabi Urban Planning Council was created in 2007 and is the government funded agency responsible to initiate, drive and support Abu Dhabi’s urban development strategy.
The ADUPC has implemented the Oracle EBS R12 as an OLTP for Human Resource and Finance Department. The BI system would fetch the data from Oracle EBS and provide out of the box analytics solutions for “Human Resource – Workforce Profile and Learning Enrollment and Completion” and ”Finance – General Ledger and Payables” modules. Additionally the customized reports and dashboards for the mentioned modules would be developed which are not available out of the box. The system also contains some real time transaction reports built in BI Publisher integrated with BI analytics. The system is integrated with LDAP and appropriate user groups are created to ensure the specific set of reports and dashboards are available to the appropriate users only.
Responsibilities:
As Technical Architect/Analyst, I led team of 6 members and was involved in following activities:
• Study and analysis of the business requirement and accordingly identifying reports and dashboards with client’s BA.
• Designing of technical architecture of the system.
• Installation and Configuration of the system components (Oracle BI Intelligence, Oracle Business Applications, Oracle Database, Informatica, DAC and BI Publisher)
• Customized OTB repository (Physical Layer, Business Model & Presentation Layer) to include the provision of data extraction from external sources (excel files).
• Development of the reports, interactive dashboards using Answers/Dashboards.
• Integration of the application with LDAP for user authentication and subsequently creating user groups for security setup.
• Configuration of Alerts/iBot to deliver the scheduled reports through email and on user’s dashboard.
• Performed unit testing and worked with the business user at various stages of the UAT.
• Provided business user training (navigation and execution of reports, security configuration, building and managing ad-hoc reports, export reports to excel/pdf/html, scheduling reports generation(auto emailing), creating alerts ) to business users and technical training (security management, administration and configuration, monitoring data loads) to IT team.
Environment: Oracle BI EE 10.0.3, Oracle Business Applications 7.9.6, Informatica 8.6.1, DAC 10.1.3, Oracle 11g, Oracle Application Server 10.x, Linux 5, Windows Server 2008
July 2009 – Dec 2009
Infogain India Pvt. Ptd., India
AXA Gulf Insurance, UAE
Technical Architect/Analyst
Project Description: – MIS Reporting
The MIS Reporting System is the development and implementation of the reports and dashboards for the AXA Gulf Insurance, a leading insurance provider with 52 million clients offering life and non life products for personal and corporate customers.
The project included the development of the Key Performance Indicators generated from the written premiums, earned premiums, new policies, expired policies, claims outstanding, reinsurance premiums, recoveries and broker commissions. The KPIs, generated from complex formula applying on premium and claims data collected from difference transaction systems and external inputs, were presented in reports and dashboards.
Responsibilities:
As Technical Architect/Analyst, I led team of 6 members and was involved in following activities:
• Involved in the System Study, Architectural Design and Data Modeling of the system.
• Interacting with client’s BA to understand the KPIs formula and subsequently design and development of KPIs in the ETL.
• Involved in the functional testing of the system to ensure that KPIs have been implemented as desired.
• Involved in the user acceptance testing with end user.
Environment: Microsoft SSIA, SSAS, SSRS, SQL Server 2005, Microsoft Share Point Server, Window Server 2008
July 2007 – Apr 20009
Infogain India Pvt. Ltd., India
Medco Health Solutions, USA
OBI EE Consultant
Project Description: – MIS
Medco Health Solutions is a loading pharmacy benefits manager with the nations’ largest mail order pharmacy operations. Medco implemented Siebel e-pharma sales to maintain accounts, sales opportunities and service requests. The Management Information System (MIS) is the initiative to capture the data from legacy Siebel OLTP and generate analytics reports/dashboards for the management for better decision making.
Responsibilities
As an Analyst, I was involved in following activities:
• Created/Modified machinery and quality control management (MQCM) metadata repository (.rpd) using Siebel Admin tool.
• Developed and modified MQCM analytics repository at 3 levels.
• Created catalogs in presentation layers used for both ad-hoc and dashboard users.
• Created dimensional hierarchies, levels and implemented business logic by creating level based measures.
• Created OLAP requests in Answers and multi-level requests (drill-down and guided navigation).
• Developed dashboards using different analytic views (pivot, table, chart etc.), interactive dashboards with drill-down feature, charts using global and local filters.
• Worked on the analytics reports/dashboard level security by creating groups and users and setting up privileges.
• Worked on ETL (extract, transform and load) to drive necessary source data to load target warehouse objects.
• Creation/modification of Informatica repository.
• Developed Informatica objects (Mappings, Sessions, Workflows; used several transformations).
• Configuring Informatica for full and incremental load.
• Performed testing to validate report/dashboards functionality.
Environment: Siebel 7.8, Siebel Analytics 7.8.5, Informatica 7.1, DAC 7.8.5, Oracle 10g, Unix, Windows Server
Sept 2003 – Dec 2008
Infogain Corp., USA/Infogain India Pvt. Ltd., India
Hewlett Packard (HP), Palo-Alto, CA
Development Lead
Project Description – iCare / Customer Knowledge & Reporting Management
There are two sub-projects iCare & CKRM:
a) iCare, CRM application, is HP’s worldwide customer support system. The project involves the migration of Vantive Based WWCCS to PeopleSoft 8.4 CRM. WWCCS is Vantive implementation of Customer Support, Field Service and Sales modules. In the HP-iCare system the Customer support module has been migrated to PeopleSoft 8.4 CRM. The scope of the project includes the customization, enhancement and bug fixes in the existing system.
b) Customer Knowledge and Relationship Management (CKRM) is the worldwide CRM data warehouse initiative of the Imaging and Printing Group (IPG) at HP. This CRM data warehouse, known as CKMDW, serves as the repository of customer related data for a 360° view of customer profile information, product registration information, sales transaction information and click-through data from campaigns. CKMDW maintains current and historical data with the objective of providing customer business intelligence and knowledge management services to HP management and partners.
Responsibilities
As a Development Lead, I was involved in following activities:
• Impact analysis of enhancements, bug fixes in CRM application.
• Writing database scripts in Oracle PL/SQL for data correction which might have gone bad due to a bug in iCare application or have flown to iCare DB through iCare interfaces.
• Developing Informatica maps to migrate data from central server to regional servers. (iCare application is deployed on ten Regional servers. Apart from ten Regional servers there is one Central server which maintains Master Data for iCare application. Master Data is created on Central server and pushed to Regional servers using Informatica maps based on Region’s requirement.
• Coordinating with Regional Master Data Leads for adding/modifying Master Data based on specific Region’s requirements.
• Design and development of Informatica maps and workflow using mapping designer and workflow manager for pushing data from Operational data source to data warehouse and massaging the data to generate reports.
• Design and model of CRM Data Warehouse.
• Develop strategies of Data acquisition.
• Co-ordinate with business users to capture their reporting needs.
• Upgradation from Informatica 5x to Informatica 7x.
Environment: PeopleSoft CRM 8.4, PeopleTools 8.43, Oracle 9i, SQL, PL/SQL, Informatica 5x/7x, Unix shell scripting.
May 2003 – Sept 2003
Infogain India Pvt. Ltd., India
PeopleSoft Inc., Plesantan, CA, USA
Software Programmer
Project Description – Sustaining Engineering Services for PCRM
Worked as a Programmer Analyst in a team of 6 people.
PCRM Applications is a complete suite of web based software product that integrates Sales, Marketing, Call center, Help desk, Field service, Inventory, Collaborative selling, Quality management operations. The software is based on n- tier architecture model with a web client, web server, and application server and application database. A dual shore model Sustaining Engineering services project for all current and future releases of PCRM on SQL Server database.
Responsibilities
As a Programmer, I was involved in following activities:
• To resolve the bugs reported by the client of PeopleSoft on different versions of PeopleSoft CRM by making the changes in the code using PeopleTools as well as in the different RDBMS where the PeopleSoft CRM can be deployed.
Environment: PeopleSoft CRM 8.0/8.4/8.8, PeopleTools 8.41/ 8.42/ 8.43, SQL Server 6.5/7.0/2000, Web Logic 5.1/6.1, Tuxedo 6.5, UNIX.
Dec 2002 – May 2003
Birlasoft Ltd., India
GE Capital International Services, India
Software Engineer
Project Description – MFE Tool
The Mainframe Emulator Tool (MEF) validates the technical account bookings done in SICS software developed in Mainframe environment. The MFETOOL enables the user to connect to a host terminal from Visual Basic. Once the connection is successful, the mainframe terminal will be displayed on the screen. Application then pulls the data from various screens and validates all the Critical to Quality (CTQ) criterion at the time of booking entries to General Ledger. The definition of the CTQs is stored in SQL-Server, so that CTQs can be modified/added/removed.
Responsibilities
As a Software Engineer, I was involved in following activities:
• Study, design coding for the project.
Environment: Visual Basic, SQL Server, Attachmate E-Vantage Active X Control
Dec 2001 – Dec 2002
Zenux Software (Formerly Compunnel Software), India
Coca-Cola, India
Software Engineer
Project Description – OECMEC
The Operating Expense Control and Marketing Expanse Control (OECMEC) System has been designed specifically for the control of the budgets by the Finance department of the CCI.OEC maintains the records of expanses pertaining to day to day operations and subsequently it maintains the various OEC budgets. MEC maintains the records of expanses pertaining to the marketing and promotions of various brands of beverages and subsequently the budgets. Budgets are entered in the system at the beginning of the year. Commitments are made throughout the year against relevant budgets and payments are in turn compared to the respective commitment. Application generates MIS reports for expenses analysis against various budgets, records of purchase requisitions, purchase orders, payments against Pos with the type of payments (Advance, Invoice, Cash etc.).
Responsibilities
As a Software Engineer, I was involved in following activities:
• Development of transaction and aggregated reports in Crystal Report.
• Incorporating the additional features and changes required by the client into the OECMEC System.
• Client meeting and presentations.
Environment: ASP, VB-Script, Java Script, HTML, DHTML, Oracle-8 and Crystal Reports-7
Aug 1998 – Nov 2001
Zenux Software (Formerly Compunnel Software), India
Coca-Cola, India
Software Engineer
Project Description – Plant Performance Management System
PPMS is a browser based online application, aimed at the Coca-Cola India employees at their bottling plants, spread throughout the country. The users would at regular intervals log on to the application via VSAT and update the database at the centralized server on the day to day development (Production recording) taking place at their respective bottling plants. The application maintains plant wise records of various parameters like net production, rejections, breakages, savings, yields etc. for the various materials. Depending on these parameters, application generates MIS reports for the productivity analysis of the bottling plants. The reports can be generated as and when required by the corporate office/users at the plant as per their security level.
Responsibilities
As a Software Engineer, I was involved in following activities:
• Implementation of the application at the Pilot location and the subsequent User trainings
Environment: ASP, VB-Script, Java Script, Oracle-8 and Crystal Reports-7
Certifications & Training
• Oracle 9i DBA Fundamental-I, Fundamental-II and Performance Tuning
• Oracle BI Publisher
• Informatica 7 Architecture & Administration
• Informatica 7 Mapping Designer
