Profile

A seasoned IT Professional with more than 17 years of IT experience in building, managing and delivering Enterprise applications, Data Architecture and Business Intelligence solutions. Combine extensive hands on technical expertise with strong leadership and consulting skills to drive business focused strategy, align process, people, tools technology, operations portfolio/programs.

Qualification Highlights

Experience Summary

• More than 17 years of IT experience in consulting and enterprise roles delivering solutions in multiple verticals
• Extensive hands on experience with Oracle EBS, Data Warehousing and BI Platforms including Oracle ODW, OBIEE suite
• Successfully lead and implement more than 15 full lifecycle OBIEE Global Dashboard rollouts for various business organizations, across the company.
• Experience working with various domains like Financial, Marketing, Supply Chain Module and Order Management Analytics
• Experience configuring Interactive Dashboard with drill down capabilities using global and local Filters, OBI Security Setup Groups, access/query privileges Metadata objects and Web Catalog objects Dashboard, Pages, Folders, Reports
• Experience in creating aggregate tables, table partitions, indexes and cache management
• Experience in Security setup at both Object and Data levels, LDAP Authentication setup and configuration of Multiuser Development Environment
• Experience in design and development of Oracle BI Metadata Repository .rpd at all the three layers Physical, Business Model and Presentation Layer
• Experience in OBIEE Features i.e. Cache, Usage Tracking, Dimensional Hierarchy, Aggregate navigation, Variables/Initialization Blocks configuration etc. , converting Snow-Flake schema to Star schema, Physical and Logical data modeling.
• Experience in sending alerts via intelligence agents iBots to the dashboards for the end users.
• Experience in setting up Dashboard Action Links as well as Column level Interaction Action link to drill down to other dashboard pages or link to external intranet pages.
• Experience in writing Oracle PL/SQL stored procedures, table partitions, triggers, Materialized views, SQL queries, tuning.
• Expertise in analyzing business issues and providing possible reporting solutions to end users
• Expertise in providing end-to-end user training and support and provided detail documentation.
• More than 7 years of consulting experience implementing Oracle Applications as a technical expert, lead, solutions architect, database administrator and functional analyst.
• Experience in continuous improvement business process environment including Kaizen. Have implemented several systems enhancements initiatives in conjunction with the business improvement programs.
• Worked as a Team lead, Sr. ETL architect/Developer/Admin, Data Warehouse developer for over 7 yrs
• Have a MBA with distinction from Northern Illinois University

Work

Experience

Confidential

Lead BI / ETL

Responsibilities:

• Lead the team that works on the ETL process using Informatica Power Center 8.6
• Manage Data Loads for 25 different data sets
• Manager overall SDLC process flow
• Define, create, implement, communicate and enforce coding standards
• Participate in Project/Program planning, Execution and Management in tune with the core business objectives
• Responsible for day to day operation of the SAS BI Platform
• Responsible for recognizing opportunities for automation, cutting in redundancy
• Introduced APEX development tool for various adhoc data maintenance tasks as well as Project Management.
• Responsible for Designing, implementing and delivering new Data workflow in Informatica
• Responsible for redesigning Data Models for Web based applications
• Introduced Materialized views for improving performance.
• Coordinate the work performed by developers to deliver application systems on time with excellent quality by mentoring personnel assigned to the project and ensure quality of the job by early verification and validation.
• Working on the POC for OBIEE implementation

Confidential

Lead/Supervisor

Responsibilities:

• Plan, direct and implement enterprise business initiatives involving EDW, OBIEE, Informatica Cloud and APEX amongst other tools including integration to various platforms.
• Lead and Develop interfaces in Informatica to load data from Salesforce, SQL Server, Oracle Database, and Flat files into EDW.
• Developed over 20 dashboards and various reports to provide quick and timely insight to the business customers a 360-degree view of the customers' spend and behavior.
• Conceptualized, architected, and implemented DBW Danaher's enterprise data warehouse and analytics system that integrated all their data from over 30 countries and several localized business systems.
• Heavily involved in requirements gathering, interface design, and project and team management.
• OBIEE Reporting System was responsible for strategy development, solution architecture, application development and quality assurance.
• Developed data architecture to best meet the near-real time data plus fast response time, leveraging multiple caching approaches plus interactive, parameterized stored procedures.
• Data included all levels of business information from enterprise application such as Oracle EBS HR, Supply Chain, Order Mgmt, Financials, CRM , Salesforce.com several other legacy systems in 30 countries.
• OBIEE supported more than 1000 users across 30 countries, including many foreign language adaptations
• System was designed to provide timely and accurate information across several business domains including Sales, Finance, Planning and other dashboards.
• Data collected included closed and open orders, receivables, GL entries, receivables and competitive pricing data for better forecasting and providing critical insights to customer behaviors, purchase habits etc.

Achievements:

• Improve confidence of top management and the integrity and accuracy of our critical reporting by evaluating, designing and implementing OBIEE Oracle BI 11g as the enterprise Business Intelligence platform
• Reduce risk and cut report generation and consolidation timelines by 50 with the deployment of self-service reporting dashboards for the various functional groups
• Using insights from the new reporting abilities and insight into customer behavior, the sales teams were able to upsell, retain and cross sell products resulting in 25 additional revenues.
• Introduced Oracle APEX 4.0 to the team to manage and maintain Custom Applications including and not limited to OBIEE Security app, Project tracking App and various miscellaneous database based applications
• Developed and delivered several extensively used dashboards for making strategic decisions like GSA, Inventory, Collections, and Vertical Market etc.

Lead DBA Team Confidential

• Standardize DBA processes for change mgt., access controls, patch mgt., testing, tuning backup and upgrades
• Mentor and build strong onshore offshore DBA team to handle volume ability to support new initiatives
• Implemented the Oracle Sales and Proposals module and worked with Oracle to solve several issues with the core module.
• Implemented Load Balancing and redundancy by introduction Big IP load balancers
• Enabled the internalization function for Chinese character set and applied the necessary patch sets
• Implemented a comprehensive configuration and change management calendar to co-ordinate all Database ATG and CPU patching work.
• Design and develop the system interface from Oracle to several legacy manufacturing systems across group companies
• Enabled post script printing, bar code labeling features.

Sr. DBA Confidential

• Upgrade Oracle database from 9.2.0.1 to 10.2.0.1 and Oracle Applications database from 8.1.7 to 9.2.0.6
• Upgrade Oracle Applications from 11.5.8 to 11.5.10.2
• Performance tuning several dozen reports from Oracle that were bringing down the system.
• Implementing performance tuning standards for development team.

Software Programmer/Analyst Confidential

• Lead and drive the Oracle HR HCM module implementation including migration from the legacy application.
• Setup and Implement HR module on 11.5.8 Instance Both Technical and Functional
• Lead on implementing Finance Modules like AR, AP, Cash Recon for 11.5.8 implementation
• Design and develop the system interface from Oracle to ScanCode third party shipping module

Lead - Oracle Applications Consultant

Confidential

• After joining the company as a technical architect lead in the Financials side of the practice, I was responsible for working with a team of developers to implement Oracle ERP based solutions at various customer sites across several verticals.
• Key customer included Motorola, Louisville Gas Electric. Key responsibilities included:
• Partner with pre-sales to provide sales and lead generation support.
• Convert business requirements into technical specifications. Propose design architecture options and estimates.
• Lead the development team to code and implement changes to satisfy business specifications.
• Building a strong team with complimentary skill sets needed to staff all aspects of a project.
• Develop Custom Forms reports
• Create and customize Self-service web applications screens
• Developed several PRO C programs to interact with forms as well as the Data Ware House
• Interface and reconcile the Travel itineraries from AMERICAN EXPRESS CARDS to the Oracle Payables data
• Setup Multi Org modify custom tables to multi org

Confidential

Programmer/Software Engineer

• I was campus recruited by Satyam in my final year of BS in Electronics Engineering. After the initial training on open source systems and Oracle ERP, I have worked on several high profile projects for Satyam's clients. Typical activities included:
• Developing coding specifications
• Coding, code walk through and unit testing
• Integration testing
• Documentation and support

Technical Expertise