Certified SAP Business Object professional in Business Objects Enterprise. Area of certification covers web intelligence, desktop intelligence, reporting tools, queries, Universe designer, CMC,CCM, QAAWS, and dashboards etc.
Summary

• 10+ years of total IT experience in requirement gathering, technical analysis, Estimation, design, development & implementation of business applications for Retail, Aerospace, Manufacturing, Transportation, Banking, Insurance, Oil & Gas, Utilities, Pharmacy, Hospital, and Finance sectors.
• Strong experience in Data Warehousing, Business Intelligence concepts & implementation.
• Extensive experience in developing data models in HANA 1.0 SP2
• Strong experience in Business Objects 4.0/XI 3.1/XIR2/6.x/5.x.
• Strong experience in Business Objects data services/Integrator XI/3.2/4.0.
• Proficient in Oracle 10g/9i/8i/8.0/7.x, MS SQL Server 2008/2005/2000/7.0, (database triggers, materialized views, Packages, stored procedures, functions, and database constraints), SQL Loader, SQL*Plus, SQL Navigator, PL/SQL and oracle DBMS Packages, oracle supplied utilities
• Expertise in building the Reporting Applications from scratch with OLAP/OLTP environments.
• Expertise in Installation, migration, maintenance, troubleshooting and overall administration of the Business Objects Suite. Involved in conducting strategic evaluation (Proof of Concepts) of the use of Business Objects XI R3.1/R2.
• Experienced in ETL Methodologies using Business Objects Data Integrator/ Services XI 3.1 with Data Quality & Rapid Mart and worked on Metadata Integration (BOMM-Business Objects Metadata Manager) and EPM(Enterprise Performance Management)
• Extensively worked on creating complex workspace and analysis of data using OLAP reporting tool Voyager.
• Extensively used Business Objects reporting functionalities such as Master Detail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Expert in Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values along with User Acceptance Test (UAT) and data accuracy test.
• Strong experience in carrying Functional, Integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products.
• Extensively worked in Crystal Reports for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, drilling reports, analysis reports, data reports along with Dynamic LOV using Business View Manager.
• Have good hands on experience in ETL and Data Cleansing applications using Infomatica Power Center, Oracle Warehouse Builder, Data services/ BODI, and PL/SQL.
• Ability to analyze existing systems, conceptualize and design new ones, and deploying innovative solutions with high standards of quality.
• Self-starter who takes responsibility and accountability.
• Excellent time management skills and documentation skills.

Technical Skills:

• Business Intelligence: SAP Business Objects 4.0/3.1/XI R2/ 6.5/ 6.1X/ 5.X, SAP BI, Oracle BI discoverer, Xcelsius, Data Integrator, Business objects Query for Excel, ZABO Infomatica 7.x, SAS business analytics framework( SAS 8 and SAS 9), Qlickview.
• RDBMS: IBM DB2, Oracle 10g/ 9i/ 8i, SQL Server 2000/2005, Teradata 8.5/ 12, Ms Access, SAP BW 3.5, 7.0, SAP ECC 5.0 .
• OLAP: MS SQL Analysis 2000, Business Object Designer 4.1/ 5.1.2/ 5.1.4/ 5.1.5/6.0/ 6.1a/ 6.1b, 6.5/ XI R2/Xi3.0, Cognos Transformer 6.5, ER studio, LCM.
• Data Modeling: Erwin 3.5.5/ 3.5.2, Star Schema Modeling, Snowflakes Modeling, FACT & Dimensions, ER Studio.
• Development Tools: Visual Basic 5.0/6.0, Visual Interdev, Developer 2000, Forms 4.5/ 5.0, reports 2.5/ 3.0, Crystal reports and Lotus Domino, SSRS ( SQL server reporting tool), TFS.
• Languages: C, C++, Java( J2EE), PL/SQL, SQL, Unix Shell Scripting, Perl, CGI Scripting, ASP.
• Internet Technologies: JSP, XML, HTML, Javascript, HTML, DHTML, ASP, VB Script, MTS, IIS, Java Web Server 2.0, Lotus Domino Server, EJB 2.0, Web Services.
• Operating Systems: UNIX, AIX, LINUX, Windows NT, Windows 98/XP/2000/2003, Mainframes (MVS/OS390),VM ware, Citrix.
• Project Management: MS Project, Oracle ADI 11.2, MS Access, MS Visio, MS Excel, and Lotus Notes.
• ETL Tools: Informatica, SQL Data Transformation Services, Cognos Decision Stream 6.0, SSIS, and Business Objects Data Integrator/Data services.

Certifications:

• Business Objects 3.1 Certified Professional ( BOCP)

Education: MBA in Finance

Professional Experience:

Client: Confidential, Owego, NY Jan /2012 – Till Date
Role: BOBJ/HANA Architect

Confidential is known for building the finest military aircraft and is organized around core business areas of Aeronautics, Electronic Systems, Information Systems & Global Solutions, and Space Systems.

Responsibilities:-

• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.
• Strong experience in carrying Functional, Integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products.
• Assisted SAP Basis team in installing HANA 1.0 and solely integrated it with Business Objects 4.0 and BODS4.0.
• Established the best modeling and recommended strategies for BOBJ environment and architecture for SAP HANA.
• Installed BOBJ 4.0 and BODS 4.0 and configured SAP and Windows AD authentication for Business objects enterprise.
• Integrated BOBJ 4.0 and BODS 4.0 with SAP HANA1.0.
• Created Technical specifications and standard modeling documents for HANA.
• Developed testing scripts and performed UAT on SAP net weaver portal using Test ID’s for developers, super users, and end users.
• Worked on various Java sdk scripts to configure authentications, SSO, and web servers for HANA, SAP BW7.3 , BODS4.0 and BOBJ4.0
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Developed data models for the operations, PP, Global sustainment, Quality management tables in HANA.
• Created web services for querying HANA database from external end user report portal using real time jobs in data services 4.0 designer.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Integrated SAP Net weaver portal to Business objects content using Knowledge management, Iviews, work sets, portal roles.
• Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
• Developed Webi reports and dashboards for different operations and finance KPI’S like Project planning, quality management, warehouse management, Material management, Global Sustainment, Value management.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).

Environment:- BODS 4.0, BOBJ4.0, HANA 1.0 SP2, SAP BW 7.3, SAP ECC 6.0, Linux, Ms office, Visio, MS Outlook.

Client: Confidential, San Antonio, TX Sep/2011- Dec/2011
Role: BO/BODS SME

Confidential Provides financial and insurance products and services for well-being of members of the military and their families for generations to come.

Responsiblities:

• Analyzed and Assisted in Creating Data services ETL Jobs and Ad Hoc Universes for Consumer Lending, Mortgage, Deposits, Credit cards, Customer Product.
• Rebuild Four Dashboards Using QWAAS and optimized performance at Universe and Query level.
• Extensively in meetings and interviewing Business and Power users, to determine the flat file layouts, sources, data Layout, Business needs, and naming conventions of the column and table names.
• Experience in debugging execution errors using Data Services logs (trace, statistics and error) and by examining the target data.
• Tuned performance for large data files by increasing block size, cache size and implemented performance tuning logic on sources, workflows, and data flow’s.
• Implemented Server groups to use advance performance tuning feature such as parallel data flow, dividing dataflow in to sub dataflow and Degree of Parallelism.
• Involved in writing DI/DS scripts and also used some built-in functions like Search, Replace, Lookup_ext and Custom Functions like Sending Email whenever an exception is raised.
• Created Data Services mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc in Data flows.
• Installed and Configured BODS4.0, BO 4.0 and Job servers on Clustered windows 64 bit servers.
• Integrated Crystal reports to Sharepoint portal and updated Web.XML, BO Timeout sessions, Java scripts as per the installation requirement and business requirements.

Environment:- BODS 4.0 Clint and Server tools , BOXI4.0 Server and Client tools, Teradata 13.0, MS Outlook, Oracle 11g, IBM DB2 9.1. Teradata Client, Oracle
Client, DB2 Configuration Tools.

Client: Confidential, Vienna, VA July/11- Oct/11
Role: BO/BI Migration Lead

Confidential is the world’s largest credit union and an armed forces bank. Serving the Navy, Army, Marine Corps, Air Force, Veterans, and DOD.

Responsibilities:

• Migrated 1500+ Crystal, Webi reports, Universes, 60+ Dashboards and BOBJ applications along with their data sources.
• Administrated six servers for 3.1 environment and three servers for XIR2 environment.
• Enabled Windows AD authentications with Kerberos along with enterprise aliases for 3.1 and created aliases script for password same as user id for enterprises aliases.
• Installed and configured BOXI3.1 and updated it to SP4.
• Updated webs XML, aliases, add scripts, Tomcat, HTTP Scripts as per the requirements.
• Added Microsoft plug-in and java plug-in for 3.1 Environment.
• Configured SMTP, destination job servers, crystal reports servers, webi servers, RAS, Adaptive job servers, CMS servers in 3.1 dev and Production environments. Added commands and parameters in the server command line.
• Cloned WEBI servers, Crystal reports servers and Cache servers to enhance the performance in 3.1 environments.
• Customized 3.1 Infoview portals and created DSN for 32 bit and 64 bit OS.
• Developed technical documents and scripts for Migration Plan.
• Extensively used Import wizard for transporting objects and folders to new environment.
• Migrated Personal content, report instances and personal categories for 9600+ users.
• Migrated Xcelsius dashboards and deployed QWAAS to the new servers and fixed the hyperlinks and excel spreadsheet to be compatible in new environment.
• Used Query builder to query Repository and to recognize number of groups, users, active users, frequent users.
• Enabled auditors for XIR and XI3.1 and created auditing reports.
• Developed testing scripts and test cases. Extensively tested BOBJ reports, dashboards and other BOBJ Applications in new environment.
• Troubleshoot errors for reports, dashboards, and universes. Fixed them to work as per the business needs.

Environment: SQL Server 2008,IBM DB2 9.1,Oracle 11g, Teradata 12.0, BOXI 3.1 SP1, SAP BO Fix pack SP4, APOS, Xcelsius 2008, Crystal reports 2008, BO XIR2.

Client: Confidential, Schaumburg, IL Jan/11 – June/11
Role: BO/BI Architect

Confidential is the home of integrative and compassionate cancer care.

Responsibilities:

• Assist clients in managing project scope, risk, resources and budget. Developed Corporate and Hospital dashboards using Live office, QWAAS. Installing and configuring BOX13.1 SP3 and Xcelsius 2008 in windows environment.
• Importing user and rights in AD Authentication.
• Designed prototype for webi and dashboard. Solely performed UAT, integration and performance testing for webi and dashbords.
• Designed and developed Universes, Classes, Objects, and Hierarchies for Corporate account reporting process and Management reporting process.
• Maintaining the enterprise repository includes security of Users, groups, predefined settings, Universes, reports, domains, and categories in the CMC.
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).
• Created complex reports and user objects like measure objects by using @aggregate aware function to create the summarized reports.
• Created Report Level Variables, Objects and Formula to create new columns based on the result set.
• Experience in using QAAWS connections in Xcelsius with Refresh on Load option which enables pulling of live Data from Universes as well as Web Intelligence reports on Demand from Data base.
• Created and Customized Dashboards for users. Created various analytics like Speedometers, Interactive Metric Trends (IMT) and Barometers
• Extensively used the @functions and Aggregate Aware feature. Worked on back end functions, procedures, tables, views required by the business objects universes.
• Created and defined the Hierarchies for various reports based on the Business rule of the Organization.
• Implemented Object level security in the database level, which helps the universe to incorporate security for sensitive information.
• Created complex reports by linking data from multiple data providers, using free hand SQL and functionalities like Combined Queries.
• Applied most advanced Business Objects functionalities like conditional hiding, ranking, hyper linking, conditional sorts, alerter etc.
• Extensively used Alerts while creating the Xcelsius Dashboards and used Functions like VLOOKUP, IF ELSE Involved in Performance tuning of Universes by creating alternate views and indexes , ROUND, COUNT, CONCATENATE for while pivoting the Data to Xcelsius.
• Performed Load, UAT, and Integration testing for Dashboards.
• Solely implemented full cycle implementation for 5 Hospital and Corporate Dashboard.

Environment : SQL Server 2008, BOXI 3.1 SP3 , Xcelsius 2008, QWAAS, Live Office, CMC, CCM, MS Office ,MS Outlook.
Client: Confidential, Houston, TX Oct/10 – Jan/11
Role: BO/BI Lead 
A top-tier oilfield service company with a century-long track record, Confidential delivers solutions that help oil and gas operators make the most of their reservoirs.
Responsibilities:

• Interacted with Business Users, Business Owners to know their Business views in developing and modifying Universes, Reports, and Dashboards accordingly.
• Worked with the Users and clients to identify the priorities, to know the Business Critical and complex universes and reports
• Written DS Scripts for File existence check, Daily incremental read, Daily Incremental update, workflow level Script read, workflow level Script update, workflow level Error Handling and Job Dependency.
• Debugged exsisting mapping, mapplets, and dataflows in GL Rapid marts using breakpoints.
• Extracted and audited data for SAP Tables, functions, Idocs.
• Created various Universes using Bex queries connections.
• Developed multiple navigational dashboards for different KPI’s like HSE, Procurement, OTD, MVAR, Shipment, and Finance using Xcelsius 2008.
• Created 42 webi and crystal reports based on OLAP Universes.
• Involved in Creation of Alerter with various conditions. Created Dashboards using Xcelsius.
• Created reports with high end functionalities like drill down, slice and dice, Alerts, Charts, and Crosstabs.
• Designed and maintained Universes and exported them to the repository.
• Used various components and selectors to achieve navigation, dynamic visibility, and what if analysis in the dashboards.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
• Created Webi reports on FI, Copa, and Operational data extracted from ECC to the BI7.0.
• Created Webi reports for Profitability Analysis based on the COPA Data sources via Bex queries Universes.
• Created and Customized executive and performance Dashboards for users. Created various analytics and components like Speedometers, Interactive Metric Trends (IMT), Charts, Filters, Selectors, and Barometers.
• Used Business Objects Data Services XI 3.1 cleansing transformations for de-duplication, house-holding and address parsing.
• Used various transformations like Map Operation, Table Comparison, Row-Generation, Query History Generation, Key Generation, Pivot and Query.
• Extensively worked with CMC to migrated objects packages into QA and Production environments.
• Performed Unit testing and validated reports using BEX Analyzer.

Environment: SAP BW 7.0, Xcelsius 2008, SAP BO Client tools 3.2,webiInfoview, MS outlook, MS Office, Bex Analyser, Designer, VB Macros, QWASS, Live office, ECC6.0, BODS 3.1, GL Rapid marts, BODS 3.1
Client: Confidential, Jackson, MI Apr/10 – Sep/10
Role: Lead BO/BI Consultant

Confidential is the Michigan based second largest gas, and electric utility providing company.Providing services to more than 6 million Customers in the State’s and 10 million customers in 68 countries.

Responsibilities:

• Gathered, analyzed the requirement and build necessary specifications.
• Build the new universes as per the user requirements by identifying the required tables and defining the universe connections.
• Used management Console for administrative purposes in BODS Projects, jobs.
• Build dataflow, workflows, mapplets, variables, and customized functions in BODS Projects.
• Extracted data from flat flies, oracle tables, and performed cleansing and modeled using various transformations as per the requirement.
• Created reports using Business Objects functionalities like queries, Slice & Dice, Drill Down, Cross Tab, Master/Detail and Formulas etc.
• Designed Universe by creating the Business Objects Data Model selecting joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects like Dimensions, Details and Measures which are grouped into Classes and checked the integrity of the universe.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects
• Developed complex SQL, PL/SQL code to enable user queries to the database for data access, using triggers and stored procedures.
• Conducted end user training for basic and advanced reporting skills.
• Trouble shooting and Performance tuning of the reports and Universe.
• Used Info view for scheduling the reports, monitored and leaded the onshore team.
• Installed the SAP integration Kit and performed ETL on Oracle sources and SAP sources data on SAP authentications.
• Configured and enhanced the security of universes, Row level security, and provided privileges and rights to different users.
• Created complex views to overcome loops and contexts and Extensive analysis to design the Universes and assigned them to respective domains
• Implemented Row Level Securities and Object level security in the database level, which helps the universe to incorporate security for sensitive information
• Working on the SQL tuning and optimization of the Business Objects reports.

Environment: Oracle 11g, BOE Client tools 3.1 sp2, QC, Info view, MS Office, Lotus notes, Windows XP, WEBI, Service manager 7, SAP BW7.0, BODS 3.1.