CAREER SUMMARY

• More than 8 years of experience in Information System Development and Implementation, including 3 years of SAP Data Warehouse and Business Intelligence in Business Objects Environment.
• Extensive experience in gathering requirements, analyzing system and user needs to meet the needs of the organization.
• Experience using BI tools Business Objects XI R2, XI 3.X including developing WEBi reporting and Xcelsius dashboards.
• Excellent experience in Design, Development, Support and Operational activities of a Business Objects DWH environment.
• Strong knowledge of database technologies and data warehouse methodologies including data warehouse design and development.
• In depth Knowledge of data modeling, ETL and Integration Technologies
• Good analytical, organization and communication skills.
• Good understanding of SQL, database objects and query.
• Unites States Citizen.

INDUSTRY EXPERIENCE

Retail, Government, Healthcare.

EDUCATION AND TRAINING
Bachelor of Science Degree

• BS, Applied Science

Specialized Training / Professional Development

• Networking
• Mainframe Training
• SAP BI/BW/BO

ENABLING TECHNOLOGIES
SAP Applications and Tools

• SAP BI/BW. SAP BI 7.0, SAP R/3, ECC 6.0, SD, MM, FI/CO, Business Explorer (BEx) Analyzer, Web Application Designer, SAP Business Objects including Crystal reports, Universes, Web Intelligence and Xcelsius,
• CMC, Reporter/Desktop Intelligence, Central Management Console, Info view, Import Wizard, Universe Builder, Web Intelligence, Crystal Xcelsius 2008, Crystal Reports XI/2008.
• Microsoft suite: VISIO, MS Project, Word, Excel, PowerPoint, Outlook Express
• Oracle, PL/SQL, DB2, SQL Server 2005

SELECTED CAREER ACHIEVEMENTS

2012/Apr to Present
Business Intelligence Analyst, Confidential, Houston, TX
SAP BI/BO

• Interacted with business users and Subject Matter Experts to gather information to identify and develop business requirements and transform it into technical requirements.
• Identified source systems, connectivity, tables and fields, ensure data suitability for mapping.
• Lead joint workshops for all the stake holders and SME for projects.
• Created and modified Webi reports and Dashboards for different business units.
• Created various business requirement documents related to Utility business.
• Tested the data integrity and gap analysis among various sources and targets.
• Supported and maintained universes built in the current Development and Production environments.

2011/Nov to 2012/Apr
Business Intelligence Report Analyst, Confidential, Fort Wayne, IN
SAP BI/BO

• Interacted with business users and business analysts to gather information to identify and develop business requirements and transform it into technical requirements.
• Created/Modified Crystal Reports using the BEX queries.
• Maintain/modified most of the Financial reports and some Sales and Distribution too.
• Created Slice and Dice, Drill down and Cross Tab reports and used the formatting options like cross tab representation, section breaks, data sort options.
• Supported and maintained universes built in the current Dev and Production environments

2010/Sept to 2011/Jun
Business Intelligence BO Analyst, Confidential, Houston, TX
SAP BI/BO

• Interacted with business users and business analysts to gather information to identify and develop business requirements and transform it into technical requirements.
• Created/Modified Universes and linked with the existing Universes with Oracle backend and exported to repository
• Created Slice and Dice, Drill down and Cross Tab reports and used the formatting options like cross tab representation, section breaks, data sort options.
• Supported and maintained universes built in the current Dev and Production environments
• Recreated complex Deski reports into Webi using web intelligence tool.
• Created complex Xcelsius dashboards to reflect User Adoption Metrics
• Created Business Objects reports, Queries with constant interaction with the end users.
• Created Business Objects reports, Queries with constant interaction with the end users. Trained end users in understanding the reports.
• Involved in trouble shooting of various reporting errors.
• Created Unit Test Plan and Scripts.
• Provided end-user training and knowledge transfer on all aspects on the implementation process

2010/Jan to 2010/Sept
Business Intelligence BOBJ Analyst, Confidential, Rochester-NY
SAP BI/BO

• Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
• Involved in the designing and Building of Universes, Classes and objects.
• Worked on Master and Component approach during the linking of universes.
• Resolved loops and Traps using Contexts and Aliases while designing Universes.
• Set up Universe level conditions to restrict data based on report requirements.
• The project involved development of reports using Business Objects and WEBI to cater Ad-hoc reporting needs.
• Created reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's.
• Worked with Multiple data providers including Personal Data files, Stored Procedures and Freehand SQL to create reports.
• Used Filters and Conditions to achieve report functionality.
• Published Business Objects Reports to users and Repository.

2009/Feb to 2009/Dec
Business Intelligence Analyst/Report Developer, Confidential, LA, CA,
SAP BI/BO

• Involved in gathering and analyzing the business requirements with team.
• Designed and developed Universes for report generation by using Designer.
• Developed canned and ad hoc reports using web intelligence and publish them to Enterprise.
• Testing reports before posting them to the repository (Query optimization and performance).
• Created aggregate tables and used aggregate awareness functions in design for report performance.
• Universe tuning by creating join, contexts and aliases for resolving loops and checked the integrity of the Universes using Business Objects Designer.
• Used calculations, variables, breaks, sorting, alerts and drill down/up functionality for creating master detail reports related to the company marketing, sales, accounting and financial planning design and implement of reports.
• Involved in interacting with end-users.
• Performing Unit Testing of the Reports.
• Worked extensively on BEx tools, Analyzer and Web Analyzer, used Navigational attributes, Filters, Exceptions, Conditions, Hierarchy settings etc.
• Conducted training for End-users and developed business process documentation.

2008/Aug to 2009/Jan
Business Intelligence Analyst/Developer, Confidential, Dallas, TX
SAP BI/BW

• As BI analyst worked on data modeling of Billing, Delivery and Order Management business processes on SAP R/3 (FI-CO and MMS).
• Defined and documented majority of user data and reporting requirements.
• Mapped BW Business Content Datasources with To-Be Reports.
• Identified Sources objects, Volume of Data and retention requirements to map source system data.
• Defined, designed and configured Master Data Info Objects, ODS objects and Info providers.
• Identified the extractors on the R/3 OLTP systems and defined Transfer structures on the source and target systems using ETL tool.
• Analyzed business-reporting requirements that could be satisfied by Business Content info cubes.
• Designed and developed the INFOCUBES for custom Info structures in FI-CO and MMS.
• Configured and enhanced transaction data sources LO-Cockpit for Billing, Delivery and Orders. Filled setup tables and installed business content Infosources.
• Developed custom data sources for Service Entry and Purchase Order history information. Configured LIS Cockpit extractors for PO Header, Detail and Schedule.
• Provided support to business users on how to use the Analyzer and to interpret the contents of data.

1996/Dec to 2003/Feb
Programmer Analyst, Confidential
IBM Mainframe and Client Server Technologies

As programmer/analyst, worked on several IBM mainframe based projects (IBM Mainframe, COBOL, MVS, TSO, CICS, ISPF, REXX, JCL, SCLM, IMS, File-Aid, DB/2, SQL, QMF, SPUFI, PANVALET, INTERTEST) at different client sites, spanning across variety of industries like Inventory, Replenishment, Retirement System. Etc. the clients that I worked for are following.

• Confidential
• Public Employee Retirement System (PERS) of Ohio.