Summary

Extensive Experience in Data Warehousing, BI and Decision support Systems and has wide Experience in implementing Data Warehousing solutions at large corporate clients in various verticals such as HealthCare and Retail.

• Around 10 years of IT experience in designing and developing Business Intelligence solutions and client server applications.
• Over 6 years of experience with expertise in various Business Objects Product Suite tools such as BO Reporter, Designer, Web Intelligence (6.X, 6.5), Broadcast Agent, Auditor, SDK (webI & Full Client) and Admin Console.
• Installation and configuration of Xcelsius, QaaWS Client Server Modules anddesigning complex reports and dashboards.
• Skilled in defining and implementing the various components of a data warehouse such as Operational source systems, Data staging, Data presentation and Data access tools.
• Over 2 years of strong experience in developing Business Intelligence applications (Web Intelligence, Crystal Reports, Desktop Intelligence Reports, Universes, Dashboards and Xcelcius) using Business Objects XI and XI R2.
• Good working knowledge of XIR2 CMC and Import wizard. Migrated universes and reports from one environment to other using Import Wizard of XIR2.
• Good working knowledge of web technologies like JSP, ASP.NET, XML, HTML and good at webI customization.
• Knowledgeable about Crystal & Business Objects XIR2 Architecture and implementation.
• Strong working knowledge in Microsoft Office Tools (Word, Excel, Access, and PowerPoint).
• Expertise in deploying OLAP tools, Materialized Views, and partitioning techniques for Decision Support Systems. Very good working knowledge of various web technologies like JSP/ASP, HTML, XML, CSS.
• Strong knowledge in Dimensional modeling techniques and multidimensional Analysis.
• Skilled in Converting the Business Logic into Technical Specifications and responsive to customer needs with strong communication skills and interpersonal skills.
• Very good team player, with attention to detail and ability to handle projects independently without supervision under tight deadlines.

Professional Experience

Confidential, Emeryville, CAJan’ 10 – Till date
Reporting/Data Analyst
Cartridge World is the largest cartridge refilling/remanufacturing retail store franchise with over 1000 stores open in over 20 countries.

Responsibilities:

• Customizations of reports run out of POS system.
• Integrating Quick books with the POS system.
• Used SDK QBFC to import Customer and Inventory info to MS Access for Ad hoc reporting.
• Identify opportunities for improvement on current acquisition initiatives and help create new initiatives based on demographics, statistical correlations, and mapping considerations.
• Slice and Dice data by Customer/SKU level to forecast business needs.
• Report sales demographically to identify mediums to run promotional offer coupons.
• Generate test data for IT group by masking production data based on Transformation rules.
• Mask confidential data when provided to external agencies for profiling.

Confidential, Oakland July’06 – Sep’09
Senior Business Systems Analyst / BO Developer

Confidential, is the largest not-for-profit managed health care company in the U.S. with nearly 8.6 million members across 9 states with operating revenue of more than $31 billion. Kaiser Permanente is undertaking a major initiative to standardize business processes and replace Financial and Supply Chain systems with an integrated state-of-the-art system that will be used throughout the Program.
The initiative, OneLink includes program-wide process standardization and implementation of a single PeopleSoft Financial and Supply Chain System. The transformation impacts the existing decision support systems.
Accounts Payable, Purchase Orders & Inventory are the subject areas covered in the initial phase of the new data warehousing initiative.

Responsibilities:

• Involved in the designing and configuration of the new warehouse accepting feed from Legacy systems and People soft enterprise modules.
• Performed extensive data analysis to support business decisions, provided data solutions by performing Risk and Gap Analysis.
• Participated in Requirement gathering and worked with various user groups to design process flows and create report specifications.
• Created several complex Web Intelligence and Desktop Intelligence reports to help various groups within procurement & Supply to track and monitor contract, commodity and price compliance.
• Created reports linking several universes for different subject areas like Purchase Orders, Accounts Payable, Pharmacy and Inventory for seamless reporting.
• Used advanced universe functionalities like Derived tables, Index Awareness, custom LOVs.
• Performed data analytics using MS Excel, MS Access as external data providers.
• Created user Prompts, Conditions and Filters to customize the report generation and used Alerts to improve the readability of the report. Extensively used Calculations, Variables, Drill down, Slice and Dice, Alerts, User Objects in the creation of reports.
• Involved in the installation, configuration and migration of Deski and webi reports from prior version to XI.
• Created dashboards and scorecards using Dashboard Manager and Performance Manager to empower users with actionable information to change performance outcomes.
• Recreated dashboards, charts,” What if “analysis, Trend Analysis in Xcelsius and QaaWS using Single Value components (Dial, Guage, Slider – Vertical and Horizontal) for designing.
• Key metrics ‘procure to pay cycle times’, ‘diversity spend’, ‘cash discounts captured and missed’spanning across different subject areas of the EDW have been re-created using Xcelsius.
• As a team involved in moving the organization from a de-centralized Desktop Intelligence environment to a centralized Webi configuration.
• Consolidation of reports by groups/regions and designing templates catering to the needs of sourcing/financial analysts & material and cost specialists.
• Providing support for the users on application usage and conducting training walk through of salient features of the application.

Environment: Oracle 10G, Business Objects XI R2, Web Intelligence and Infoview XI R2, Desktop Intelligence, Crystal Reports XI R2, CMC, Import Wizard, WebI SDK, VBA, Java script, PL/SQL Developer, Windows 2003 advanced server.

Confidential, Miramar, FL Jan ‘04 – Jun ‘06
Business Objects Developer

SWS is USA’s largest wholesale distributor of wines and spirits. They have number of reporting and analytical tools and they wanted to converge into a single reporting and analytical solution and Business Objects is their choice after careful evaluation of vendors operating in the Business Intelligence tools area.
Sales, Inventory & Depletions are the subject areas covered in the increment – I of this new data warehousing initiative. Developing a data warehouse on SQL server, extracting data from various sources, designing a fully functional ad-hoc query oriented universe and around 30 Web Intelligence and Business Objects reports using this universe is part of this initiative.

Responsibilities:
Requirements Gathering:

• Conducted user interviews and reviewed existing reporting / analytical solutions to understand the client’s specific reporting needs
• Functional requirements Document & Reporting requirements document

Designed the data model for the warehouse and the data marts:

• Data warehouse modeling
• Data mart model

Installation & configuration:

• Installed & configured three environments (Dev/QA/Prod) with Business Objects 6.5.1 with Apache and Tomcat. as web and app servers on windows servers

Security and Administration:

• 250 users & 20 different connection for the sales universe
• Security in three steps
• Database – views restrict the data based on the user defined in the connection
• Application – What a user can do in Infoview
• Object level – Restriction by objects

Universe Design:

• Designed the universe with all three main subject areas of the warehouse.
• Different connections used for different user groups.
• Aggregate awareness to encompass the aggregate logic using summary tables.
• Custom Hierarchies according to dimensional hierarchies while considering the client’s reporting habits.
• Extensive use of contexts and aliases to make a functionally foolproof ad-hoc reporting universe.
• Extensive testing & Documentation

Reporting:

• Refresh on open and scheduled reports using Broadcast Agent Server.
• 30 Distinct reports (both business objects and Web Intelligence)
• 25 refresh on open & 5 scheduled (19 copies of each for different site level groups)
• More emphasis on WebI reports with extensive usage of drill down option.

User Training:

• Prepared user documentation for hands on training of end user community.
• 9 Training session conducted for site user groups
• Emphasis was on the tool as well as the SWS universe during training.

Environment: Business Objects 6.5.x; SQL Server 2000; Data Stage, Windows 2003 Enterprise

Confidential, India Apr ‘98 - Apr ‘03
Software engineer

Responsibilities

• Involved in development of Client Server and Object Oriented Applications using Microsoft platforms and open source Modules.
• Developed E-Commerce portals including customization of open source e-commerce solutions as OsCommerce, MIVA cart.
• Worked on Payment gateway integrations for accepting secure online payments using payment gateways PayPal, Authorize.NET, Verisign, ePDQ, 2CO.
• Involved in development and maintenance of various Applications in content development for different websites and implementing scalable code.
• Managed and prioritized multiple projects and held responsibility for scheduling by deadlines.
• Participated in analysis design, development implementation, quality control testing and deployment and integration.
• Preparing user manuals and technical documentation.

Environment: Windows 95/98/2000/NT, IIS Server, Apache, ASP, PHP, MS Access, MySql, MSSQL

Education

• PGDCA
• Bachelor of Engineering