SUMMARY

• A Data Architect and Business Intelligence professional, with a proven track record for blending Business Strategies with Information Technology, Strong background in Business Intelligence and Analytics across various functions of the business Management, Consulting and Technical Leadership experience in Database Management, Business Applications and Systems Integration.
• Over 15 years’ experience in Business Applications - including Business Intelligence, Analytics, Data modeling, metadata management, system upgrades and migrations.
• Extensive experience to plan, manage Business Intelligence systems on Oracle OBIEE, Hyperion and BI Apps systems, unit, integration and user acceptance testing strategy and procedures
• Well versed with both commercial and Open source tools.
• Extensive experience in Data Repository, ETL, Design, Development, installation, configuration and troubleshooting
• Experienced in Global Delivery Model (Onsite/Offshore). Coordinated activities onsite & offshore towards meeting project timelines.
• Architected Implemented Data warehouses at different PLC phases like concept, design, requirements, production etc.,
• Advocated and conceived a Data Quality initiative by engaging a group of top level executives and communicating the benefits of such an initiative. Identified software vendors in the data quality arena and submitted Requests for Proposals to gauge costs associated with implementation
• Introduced the benefits of business intelligence within Sales and Marketing by demonstrating the high level of visibility that would be achieved through dashboards and reports
• Extensive exposure to defect management, identification, reporting using different tools like Test Director, Clarify, Bugdb etc
• Identified, compared and acquired software and hardware to facilitate development, productivity and end user satisfaction
• Exposure to application development life cycle including requirement analysis, detailed design, development, testing and implementation management.
• Communicate and present ideas, concepts and complex targeting models to associates with varying levels of technical knowledge
• Experience in implementing financial applications and reporting systems.
• Expert Level knowledge in ERP/CRM modules specifically in TCA, Campaign Management, Oracle Service, Quote & Opportunity Analysis, Order Management.

TECHNICAL SKILLS

Languages: PL/SQL, UNIX Shell Scripts, SQL*PLUS

RDBMS: Oracle 9.x/8.x, MS-SQL Server 7.x/6.x,DB2

Application Servers: Apache, WebLogic 11g,Tomcat

Tools: Informatica 9.0, Hyperion 7.x.,9.x,11.x, Oracle Discoverer, Express Server, OWB, Pure Integrate, Designer, Seibel Analytics, BI Beans, Forms, ReportsOperating Systems Sun Solaris, Unix/Linux, Windows NT

PROFESSIONAL EXPERIENCE

BI Apps Architect/Administrator

Confidential

Responsibilities:

• Interacted with the business analyst and business users to understand the customer requirement documents.
• Installed and Configured OBIA 7.9.6.3 and patches
• Involved in Analysis and Design of the BI data warehouse.
• Configure the initial configurations for Finance and Project Analytics.
• Diagnosing and troubleshooting BI Reports ability to articulate configuration and technical issues.
• Worked on OBIEE 11g tool evolution and recommendations.
• Tuned weblogic application server and its managed servers to run deployed applications fast.
• Analyzed reporting requirements for dashboard reports and adhoc reports.
• Implemented security by creating users & groups, creating Session Variables and Initialization Blocks and associated catalog objects
• Working on POC to implement Hadoop solution for smartgrid data.
• Create scripts to extract data from RDBMS using Sqoop.
• Using HIVE queries transfer back data to RDBMS for reporting purpose.

Data Warehouse and BI Lead

Confidential

Responsibilities:

• Responsible for Sales, Marketing & Finance Apps
• As part of the CRM upgrade, OBIEE was upgraded to 10.1.34 to 11g
• Responsible for hiring and training of technical resources for production support & project implementation.
• Co-ordinated with off-site team with delivery of BI projects

Senior Data Warehouse Engineer

Confidential, San Jose, CA

Responsibilities:

• Design & Architecture of the data warehouse
• Interfacing with different business teams for requirement analysis
• Implementation & support of OBIEE (Siebel Analytics), DAC (Data Warehouse Administration console), Informatica mappings as part of the Compass project.
• Manage CBU (Communication Dashboard Unit) project. This involves integrating Hyperion Essbase cubes & OBIEE reports involving different data sources
• Design and Development of Revenue cubes using Essbase (Revenue by End Market, Margin cubes, Sales, Channel) to give better segmentation analysis with different dimensions and attributes.
• Successfully lead the business requirements, Technical design of Data Warehouse Applications for implementing ‘XCM’ Confidential Customer Master. Key responsibilities included leading a Technical team to implement business requirements, Defining and validating the project scope, Creating and Maintaining detailed project plan, tracking progress, planning cut over activities and providing post go-live support
• Completed Hyperion 7.1 to 11.1.2 upgrade design, scope, requirements etc., and integration of Hyperion applications.
• Communicate with Stakeholders within Business, engineering and IT organizations about their reporting requirements and prepare project plans using industry best practices.
• Architect, Project Management & Delivery of Opportunity Revenue Cube. This cube is used for measuring design revenue to actual revenue and serves Sales & Marketing departments. This project involves Summary reporting from Essbase and Operational reports from OBIIE. Tuning MDX queries & modify Essbase configuration parameters
• Creating and supporting Web Analysis reports & Administration using EAS (Essbase Administration Console)
• Implementation, testing and support of OLAP Applications using Essbase and Integrate with Hyperion Enterprise Integration Services (EIS).
• Successfully implemented Discoverer Migration projects from 3.x,4.x to 10g.

Principal Software Engineer & Staff Engineer

Confidential, Redwood City, CA

Responsibilities:

• Designed and developed Data model for campaign reports for CRM product development (DBI). Proto typed the reports using oracle’s MOLAP and Oracle Warehouse Builder (OWB)
• Participate in project status reporting and release meetings
• Rollout applications to production infrastructure using SOX process and controls.
• Designed Oracle OLAP application using Analytical Workspaces for Marketing team to generating various reports like Revenue, Campaign, Events etc., Campaign statistics can be measured against various Dimensions like Campaign, Time, Product, Industry etc.,
• Integrated different Database structures for building Dashboards and different reports.
• Coordinated with UI Team for rendering the cross tabs and graphs using JDeveloper and BI Beans.
• As a technical lead responsible for Data model Design, Development & Review of Data transformation mappings including maintenance of Designer repository, design documents.
• Ensured adherence to data quality, integrity and procedures. Created Database stored procedures and APIs for data and lead management.
• Create mappings on Oracle Warehouse Builder(OWB) for MMD operators for address standardization and cleansing
• Implemented Database features like Table Partitioning, Analytical functions on VLDBs.
• Performance tuning of Database queries and optimization for faster retrieval of reports.
• Automate data refreshes using Database tools and Unix shell Scripts
• Design of Star and Snowflake schemas for Data Warehouse applications.
• Developed Campaign Analyzer application using Oracle Express Server to give statistics on Campaigns, Surveys, Landing Pad hits across different dimensions. This application is used for planning and budgeting purposes.
• Created Data Model for activity data captured from and created reporting infrastructure for Marketing Executives.
• Optimized ETL Scripts and created Materialized views for performance.
• Administered development infrastructure for custom eMarketing development systems.

Sr. Systems Analyst

Confidential, San Francisco, CA

Responsibilities:

• Created reporting infrastructure for Executive management to measure web site activity
• Administration of MS-SQL Server and Oracle Database Servers.
• Installation and upgrades of Enterprise Applications typically Baan IV and BAAN V
• Database configuration of 7.3.4 and 8.0.4

Customer Support Engineer

Confidential

Responsibilities:

• Installation and configuration of Operating systems like UNIX, HP-UX,
• Support for Enterprise Servers and applications
• Optimize Hardware and software for performance tuning