Profile Summary

• 5.2 years of total IT experience in areas of Software Development, Software Maintenance and Operations and Server administration
• Experience in complete Software Development Life Cycle SDLC - Requirement gathering and analysis, Software Design and development, Unit Testing and Project Implementation
• Primary specialization in Oracle Business Intelligence Enterprise Edition OBIEE 10g and 11g Administration and Application development and Informatica 9.0.1 and BOXI XI 3.1 SP4 - Administration
• Delivered innovative solutions with value added services across a variety of roles like Senior System Engineer, Technical Lead and Server Administrator
• Excellent leadership, team management and communication skills demonstrated in a variety of projects with team size up to 15

Skill Profile

Confidential

Business Intelligence BI Support Administration

a global power leader, is a corporation of complementary business units that design, manufacture, distribute and service engines and related technologies, including fuel systems, controls, air handling, filtration, emission solutions and electrical power generation systems. Headquartered in Columbus, Indiana, USA Cummins employs approximately 46,000 people worldwide and serves customers in approximately 190 countries and territories through a network of more than 600 company-owned and independent distributor locations and approximately 6,500 dealer locations.

Description / Objective

• ADSC BI Support Administration supports the BI reporting and ETL applications of the different Cummins business units namely Component Business Unit CBU , Power Generation Business Unit PGBU , Corporate Operations, Engine Business Unit EBU and Distribution Business Unit DBU . This project handles the day -to- day administration support of applications hosted in approximately 50 servers. The reporting application caters to the global user community supporting them in a variety of functionalities Sales, Finance, Distribution, Inventory, Order Management, Supply Chain Management, After Sales support, Warranty, Demand Planning, etc
• Technology OBIEE 10g, OBIEE 11g,Informatica 9.0.1 and BOXI 3.1

Roles and Responsibilities

• Playing the role of Server Administrator and Technical Lead completely responsible for the availability and stability of all the OBIEE, Informatica and BOXI environments
• Engage daily with complementary business units leads in ensuring efficient admin support to all of their support, projects and enhancements functions
• Report on status of the admin team activities to the ADSC management on a weekly, monthly, quarterly and yearly frequency
• Coordinate with a 10 member offshore team on a daily frequency on activities status, updates and clarifications/issue resolution
• Participate in escalation calls/meetings with ADSC delivery leads and resolve issues
• Extended Onsite weekend support to migration activities in close coordination with offshore team
• Communicate effectively to the different teams and clients on planned and unplanned server maintenance windows
• Initiate, strategize, execute, deliver and report innovative value adds to the customer on a monthly frequency

Confidential

The Confidential Tax Department is governed by Central Board of Direct Taxes CBDT and is part of the Department of Revenue under the Ministry of Finance, Govt. of India. Income tax is a key source of funds that the government uses to fund its activities and serve the public. The Income Tax Department is the biggest revenue mobilzer for the Government.

Description / Objective

• Centralized Processing Centre CPC is the Department of Income Tax for deploying information technology to the regular operations of tax computation and accounting. This is based on multiple Income tax rules and financials acts. This project is a gradual automation from the manual paper filing system to the fully automated online e-filing system. This is being implemented over different stages, in incremental phases. MIS Management Information System provides various categories of reports to CPC based on their day to day operations, gives insight about the operational statistics and thereby provides better capability for decision making. This application has about 40 existing reports which fall under different categories. These reports include executive dash boards, drill down reports and tabular reports. Management of MIS Reports involves development of new reports, support activities for existing reports, job monitoring and enhancements. The Reporting tool used is OBIEE 10g Siebel analytics with oracle 10g as back end.
• Technology OBIEE 10g Siebel Analytics , Oracle 10g

Roles and Responsibilities

• Served as Senior Developer and Tech lead for a team of four
• Requirement gathering through face face workshops with clients
• Consolidate the requirements and create detailed specification document
• Involved in designing of reports after thorough analysis of requirement
• Designing includes data mapping, data base objects creation, data flow logic creation using Stored Procedures and back end data preparation
• Data modeling using RPD Repository Meta Data
• Creation of OBIEE reports and pages using Answers and Dashboards
• Data Validation from back end, unit testing of reports and integration testing
• End-to-end analysis and solution of OBIEE issues
• Installation and configuration of OBIEE in Linux environment
• Participated in the Business Continuity Plan BCP setup and testing
• Performance Tuning through caching schemes and usage tracking
• Worked on the security feature like users, user groups and their roles
• Write back feature, Mouse over commenting, Narrative views, Pivot Tables, Bookmarks etc
• Deployed the reports at client environment both Testing and Production environments on Linux OS. Having very good experience in deployment which includes RPD migration, web catalog migration, Security settings, Dash board UI
• Documentation: Involved in tracking the data base changes, preparation of Unit test cases, review of System Test Scripts and Unit Test Cases, creation of Detailed Specification Documents

Confidential

BI Support and Enhancement

Description / Objective

• The Sales department at Nordstrom is responsible for tracking the company's sales across the US geography. This project helps customers in their analysis and decision making by delivering numerous reports. The technology used in this project is BOXI R2. This project is to manage the reporting application for Nordstrom Sales department for their analysis and decision making. Approximately 80 reports are delivered to the customers on a weekly frequency. Additional scope includes enhancements on the existing reports for added functionality and new report development. The reports are distinguished based on the business functionality which includes list reports, cross tab, drill-down reports etc
• Technology BOXI R2, Oracle 10g

Roles and Responsibilities

• Coordinated with business users for Requirement gathering development / new enhancements
• Requirement Analysis and design development approach
• Create new reports as per the design plan using Infoview
• Perform unit testing of the reports
• Publish the reports to the users
• Managing objects in the universe using BO Universe designers
• Creating filters at universe level
• Managing report schedule using CMC Central Management Console