SUMMARY

• Sr. SAP Business Intelligence consultant with around 10 years of experience in 7 E2E implementation/support projects in leading, development, installation, configuration, best practices, administration and support for BI solutions on SAP BO 4.X/3.X, BI 7.0, BW 7.3
• 8+ years of experience with Front end reporting development using Web intelligence for ad - hoc/interactive reporting, Crystal reports 8/XI, Desktop Intelligence, Dashboard Designer XI4.0, Xcelsius 2008, BICS, and BEx Query. Good experience with BO Security, and CMC administration.
• Experience in Financial, Healthcare, Storage, Mining, Insurance, Retail, and Food & Beverages domains.
• Heavy working experience with BWise Governance-Risk-Compliance software. Developed almost 50 Webi reports using BWise BI solutions. The reports include Audit, Control, and Risk spaces.
• SAP BO implementation, Migration & Upgrade Projects, post-production support activities for XI3.1, 4.0 with gathering and analyzing business requirements, project scoping, functional requirements, and data specifications.
• Excellent working experience with Import Wizard, Promotion Management tool/Upgrade management tool, InfoView, CMC/Security/Users/Groups/Applications/Events, CCM, CMS, IDT, UDT, etc.
• Very strong experience in creating Webi reports and extensive knowledge in creating Universes on relational databases and OLAP systems such as BW 7.3 and BI 7.
• Working experience in creating Crystal reports and Webi Dashboards for Enterprise reporting.
• Experience in creating Stored Procedures/Functions with complex SQL Joins and use of Cursors, table relationships, mappings and definitions.
• Extremely good with performance tuning of Data warehouse generator by fine tuning of SQL Scripts, Adding extra logics, creating additional indexes or joins etc.
• Created and maintained complex universes supporting multiple levels of hierarchies for drill down and drill across reports.
• Extensively worked onBusiness Objects Architecture & Administration.CreatedUsers and Groups and setting the rights on them using Central Management Console (CMC). Creating/scheduling ad hoc Webi Reports in CMCon Daily, Monthly, Weekly basis.
• Good working knowledge on FI, G/L, SCM, Payroll, AP, AR, TM, SD, MM, HR, and CRM.
• Excellent knowledge on ETL tools such as SAP BODS by making various connections to load and extract data to and from third party databases or systems.
• Experience in building the Business objects reports using backend Oracle (SQL Developer), SQL Server databases, SAP BW as well as non-SAP systems. Experience in working with Universe Builder to build OLAP Universes from SAP BW data source like InfoCubes and BW Query.
• Extensively worked on building Crystal reports directly on SAP ECC system. Also Integrating SAP ECC data with Business Objects Xcelsius using XML data connections.
• Expert in working with Business Objects reporter and creating Dashboard Manager using Application Foundation and web intelligence.
• Strong experience in querying Oracle, SQL Server databases using SQL and/or PL/SQL. Also Worked on PL/SQL functions, Stored Procedures, Exception handling and Cursor statements.
• Proficiency with VBA and macros. Enterprise reporting with Business Objects, BEx Query Designer, Analyzer, Web Application Designer and implementing BEx Queries, security roles and profiles.
• Extensively worked with MS Office applications: PowerPoint, Access, Excel, Word, and Project.
• Good experience with databases (Oracle, SQL Server) queries creations, fine tuning, procedures, and database activities and ETL tools like SAP Data service 4.0. Created ABAP workflows and Dataflow and scheduled data load jobs to load data into SQL Server database from various source(s) like SAP R3.
• Experience in working with Business Managers, Architects, End users and all the stake holders in documenting requirements, providing estimates, creating High and Detail Level design specifications.
• Experience in training Business Objects and Users.
• Superior communication, people management, interpersonal skills, analytical and debugging skills.

TECHNICAL SKILLS

BO/BODS: SAP BO4.1/4.X/BO 3.1, 4.0/BODS 4.1

SAP BW/BI: BW 7.3, BI 7.0, BW 3.5

SAP ERP: SAP R/3 4.7/4.6, ECC 6.0, CRM

Reporting Tools: Webi, UDT, IDT, UMT, PMT, Import Wizard, BEx (Business Explorer) Analyzer, WADCrystal Reports 9/10/ XI, Xcelsius

Languages: ABAP/4, C, C++, HTML, SQL, C Sharp.NET

Database: Oracle, SQL Server, MS Access

PROFESSIONAL EXPERIENCE

Confidential - New Jersey

Senior Business Intelligence consultant

Responsibilities:

• Developed reporting solutions for GRC software, created 50 Audit, Loss database, Control, Risk, AML/Sanctions, RCSA reports in Webi.
• Extensively worked on the heat maps, data dump, questions and answers reports.
• Created top 5 miss, events realized, loss events reports.
• Worked on executive summary, risk assessment, action plans, and risk and control reports. Developed risk validation data dump reports for the customer.
• Created financial statement line items (FSLI), COSO reports, exception reports.
• Very thoroughly used the BI application to do data validations during report creation and fixes.
• Familiar with the background of source of backend data for Action management and Risk and control sections in the BWise application.
• Extensively worked with Information Design tool and its Data foundation and Business layers.
• Created historic universes as part of the project. Created lots of tables in the database using Oracle stored procedures and SQL statements.
• Designed the BI historic universe from the very start and this includes not less than creating the data foundations in the universe, inserting base tables, creating derived tables and aliases for some tables, creating inner, full outer, left outer, and right outer joins based on the user requirement.
• Created BI report design documents for the project scope. This includes the universes, tables, fields mapped, relations used, BWise modules used (ex: internal audit, risk management, control, risk etc.), calculated fields, data warehouse setup, incremental and full data updating and Webi report development.
• Extensively involved in creating merged column, multi tabbed multi query reports for SAD analysis.
• Heavily used combined queries, sub queries, scope of analysis, hierarchies/LOVs, report level filters, query filters.
• Developed fully featured reports and these included: multiple data provider reports, additional tabs for Query summary, report filter summary and prompt summary, query calling another query, input selectors, advanced filter options etc.
• Made use of sections, breaks, Alerters, graphs, horizontal tables, vertical tables, forms, merged dimensions, cross tabs, formulas/functions etc.
• Extensively worked with function tool bar to create headers, titles and footers. Also, created logos, hyperlinks in the reports.
• Wrote Oracle stored procedures to transpose rows into columns in the report. Created question and answer columns through stored procedures and created objects in the universe as additional fields to the tables.
• Dealt with special character issues by including Ascii character set parameters in the universe. Also added new parameters to the existing list of parameters.
• Fixed data truncation issues by adjusting universe parameters. Created custom LOVs in the universe for the required fields and included them in the reports with hierarchical view.
• Data duplication issues are resolved by removing columns in the report. Excluded division specific fields and data population was correct. Grouping controls by risks by sorting risks.
• Aggregated controls for presentation purposes in a few reports. Adjusted filters in reports to exclude certain data in the report. Used breaks properties for advanced report analysis.
• Used advanced functions to implement filtering values in the report based on some conditions, Ex: IN, foreach functions. Also used count, count all, distinct functions in the reports.
• Created left outer, right outer joins in the universe with 1:M, M:1,1:1 cardinalities. Also manually created SQL expressions for ease of use.
• Worked extensively with SQL script and made a lot of changes at the report level such as optional prompts, DISTINCT keyword and query customizations.
• Universe level query views and custom query creations based on the objects.

Environment: SAP BO 4.1/XI 3.1, IDT/UDT, Webi, Oracle, SQL developer, Windows 7, UMT, Import Wizard, CMC, InfoView, CCM, CMS, Microsoft Office tools.

Confidential, Pennsylvania

Sr. SAP BO Reporting developer

Responsibilities:

• Identifies the top 20 employees who requested exceptions to set limits and/or restrictions.
• One click to generate an excel of all sections
• Identifies the top 10 GOs who received gifts, meals, and/or beverages for which exceptions were approved
• Identifies all HCP Government Official recipients for whom the pre-approved spend exceeded $200 for any domestic meeting.
• Setup and validate BOE Connection for Trend Reporting in Production.
• Reporting all non-HCP GO recipients of Consultancy engagements for the year.
• Provide details on each Corporate Sponsorships associated with each of these Recipients

Environment: SAP BO 4.1, IDT, Webi, SQL Server 2008, Windows Server 2008, Crystal reports, Microsoft Office tools.

Confidential - Dallas TX

SAP BOBJ Consultant/BI Lead

Responsibilities:

• Worked extensively in developing about twenty (20) Financial (FI), SRM, HCM, Payroll, and Sales related reports such as Balance sheet per Project, Income & Expenditure, Bank reconciliation, Budget variance, Retirement expenses allocation, Cost allocation, With Hold Tax (WHT) schedule, etc.
• Developed Cross Tab Reports, Sub Reports by usingWebi reports.
• Created the Reports using the Universes as the main Data providers and wrote complex queries including Sub Queries.
• Strong experience in BOBJ development on Non-SAP systems such as Oracle and Integration ofBODSwithSAP modulesandNon-SAP data sources.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Used Analysis, edition for Officeadd-in to perform multidimensional ad-hocanalysisofOLAPsources in Excel.
• Created Stored Procedures/Functions with complex SQL Joins and use of Cursors in PL/SQL, and SQL Server.
• Have the ability to consume BW data providers using SAP BOBJ.
• Graphical representation of data, and manipulation of data from multiple sources.
• Experience in usingBODSas an external system for ETL betweenECCandBI.
• Created complexJobs, Work Flows, Data Flows, and Scriptsusing variousTransforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
• Strong experience in cleansing the data usingData Qualitytransforms.
• Extensively usedData Services Management Consoleto schedule and execute jobs, manage repositories and perform metadata reporting.
• Installed and Configured Business Objects Enterprise Suite, Business Objects Data Services in Development & Production Server.
• Created Local, Central and Profiler repositories in SQL Server 2008 R2 and configured Local and Profiler repositories with Job server and Management console.
• Configured the Data services to connect to the SAP R/3, and BI.
• Developed workflows to load data into SAP Financials Master Data and SAP General Ledger (GL) transaction data from source systems.
• Developed jobs to load the source system data by referencing SAP GL, AP, AR, CC jobs.
• Moved the projects from DEV to ST, ST to UAT and UAT to Production.
• Scheduled the jobs, managed users and repositories in Management Console.
• Drill down the Analytics to the detail level data.
• Participated in detailed report design and created design specifications documents at report level.
• Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements.
• Performed SAP Data Migration by using Business Objects Data Services as the ETL tool

Environment: SAP BO 4.X/BOXI 3.X, BODS 4.1, FI, FI-GL, HR, Webi reporting tool, Xcelsius, Dashboard Designer, Crystal reports, Information Design tool (IDT), Universe Designer, SAP BW, SQL Server 2008/2005

Confidential, Bay Area, CA

Sr. SAP BOBJ Consultant

Responsibilities:

• Interacted with end users, business teams, Analysts and team members to analyze business requirements and outline the proposed solution.
• Served as Business Intelligence design expert, solution manager and collaborated with peer business intelligence and data warehouse leads and developers on solution design.
• Responsible for all technical design deliverables, system design document, and conversion of business requirements in business/technical requirement documents.
• Delivered 3 Environments, 100+ Reports (FI, SRM, TM, SD, and CRM), 4 Dashboards, 4 major universes with 100+ tables each.
• End to end responsibility of Administrations, Installation, configuration and support of BO environment.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using LCM and BIAR file methodology.
• Guided technical resources through design, construction, testing, and implementation of solution.
• Assisted technical resources in troubleshooting and tuning of reporting solutions.
• Involved in Tuning and server configurations for different environments and applied Service Packs and Fix packs to stabilize Server environments.
• Technical expertise in Analyzing, Design, Implementation and administration of security models with row level data security, role based security etc. in Business Objects Universes and Central Management Console (CMC).
• Created reports usingCrystal Reports9/10with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
• Designed, developed, deployed and maintained universes used Business Objects designer and IDT.
• Trained end users and developers on SAP BOXI3.1 and XI4.0 product tools.
• Experience with front end reporting tools such as BEx, Crystal Reports, Web Intelligence, and Xcelsius.
• Involved in daily BO 3.1/4.0 production activities such as Refreshing BO services, releasing Executive reports, User reports, and Dashboards, re-running failed reports, monitoring critical reports, etc.
• Extensively used Universe Designer (Information Design tool), Dashboards, and Web Intelligence. Actively involved in changes to BO Webi reports based on user requests.
• Worked on data validations for existing BO reports.
• Modified existingcrystal reportsand created new reports withcross tabs and sub reportsbased on the client requirements usingCrystal Reports.
• Created hierarchy for GL Balance sheet account group.
• Created reports using Business Objects functionalities like Cross Tab, Master Detail and Formula features.
• Formatted Reports as per the Users requirements using Business Objects which allows the users to analyse the operational data.
• Created reports from different data providers.
• Providing BO access for New BOBJ users, granting them accessing permissions when necessary.

Environment: Business Objects XI 4.0 (Designer, UDT, Webi, Crystal Reports, Web Rich Client, Xcelsius, Dashboard Designer, Oracle, SQL Server, SAP BW, Apache Tomcat.

Confidential

Business Objects Sr. Developer

Responsibilities:

• Analyzingsystem functionality requirements, documents and scope of the work.
• Work included Developing, Testing and enhancing existingBusiness Objects Universes; work required modifying, testing and promoting to the Repository.
• Developed, Tested, Promoted and Maintained the WEBI Reports, also had modified the existing reports based on user requirements,Also solved any issues/errors encountered.
• Responsibilities required acting as the Key Person for maintainingUniverse's with creation of joins, Cardinalities, Contexts, and solving the loops, Testing, Data analysis etc.
• Have resolvedloops, Fan Traps and Chasm trapsusing context and alias and also have built custom hierarchies and predefined filters to facilitate easy drill down and addressed performance issues.
• Created reports using Business Objects functionalities likeSlice and Dice, Drill Down, Cross Tab, Alerts and Formulas usingWeb intelligence.
• Scheduling daily, weekly and monthly reports usingBO XI Scheduler using Events, creating Calendars. UpgradedBO XI R2 to BO XI R 3.0Enterprise Environment. Used Java SDK's.
• Formatted Reports as per the User requirements using extensively the functionalities in Business Objects, which allows the users to analyze the data.
• UsedPolestarfor better interaction with predefined data sets to generate quick visualized reports
• Extensively usedCalculations, Variables, Break points, and Sorted inputs, Drill down, Slice and Dice, Alerts etc.increating Reports, formatted old reports, generated charts, bars etc. as per user requirements usingCrystal Reports 2008, Xcelsius 2008 and integration as well.
• Designed interactive Dashboards such asPopup, Tabs etc.and many creatively styledXcelsius Reportsto best support needs using effectiveHCI Principles.
• Manipulating data through various presentation styles usingCrystal Reports 2008such ascharts cross tabs, slice and dice, user response, alerts, prompts, nested loops and filters.

Environment: SAP Business Objects XI 3.1/3.2, Xcelsius 2008, Crystal Reports 2008, Web Intelligence, Business Explorer, SAP BI/BW 7.0.

Confidential, Meridian, MS

SAP BO Consultant

Responsibilities:

• Designed, developed, deployed and maintained universes used Business Objects designer and IDT.
• Trained end users and developers on SAP BOXI3.1 product tools.
• Experience with front end reporting tools such as BEx, Crystal Reports, Web Intelligence, and Xcelsius.
• Involved in daily BO 3.1/4.0 production activities such as Refreshing BO services, releasing Executive reports, User reports, and Dashboards, re-running failed reports, monitoring critical reports, etc.

Environment: SAP Business Objects 3.1, Oracle, Webi, Crystal reports

Confidential

SAP BO Consultant

Responsibilities:

• Worked on ETL tool Informatica to create maps and transformations.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 9i.Configuring Repository Manager, created folders and managed objects in repository manager for Informatica.
• Involved in creation of sessions and scheduling of session.
• Developed various types of reports like cross tabs & chart and with the drill features.
• Created the Web intelligence reports.

Environment: Business Objects, Crystal Reports v9, Oracle 9i, Windows XP, Informatica 7.1.

Confidential

BOBJ Developer

Responsibilities:

• Created & ModifiedUniversesfor various functional areas of high level reports group using Designer.
• CustomizedLOVs in Universes for quicker performanceof reports.Created Joins, Contexts, and Aliases for resolving Loops & Universe Tuningand checked theIntegrity of the Universes.
• Used SQL against the database to check data retrieved.
• Changed the universe parameter settings to optimize the performance of universe.
• According to the customer information created complex report using Universe as main data provider.
• Exported theuniverses tothe Repository making resources available to the users.
• Created the reports using Business Objects functionalities likeQueries, Slice and Dice, Drill Down, Custom sorts, Cross Tab, and Formulae's etc.
• Created reports according to different requirements Such as Summary Charts etc. Using Wizards and Web intelligence2.x.
• Exported the Reports to theBroadcast Agentand used the Broadcast Agent server to Schedule and Monitor the Reports.

Environment: Business Objects (Designer, Reporter) 6.1, Broadcast Agent, Crystal Reports, Oracle 9i, PL/SQL, T-SQL, Web intelligence.

Confidential

BW developer

Responsibilities:

• Analyzed user requirements, finalized reporting structure, resource planning and cut over and project planning. Conducted workshops, created templates for testing and initiated user training. Identified users, roles, and formulated the realization strategy
• Identified key reports from business content. Installed and configured the extractors, Data sources, info sources, and info providers of Service analytics and Interaction center modules of SAP CRM. Extracted and loaded these objects with data from SAP CRM systems.
• Reviewed the complete existing design, data modeling and the process chain design. Create the cutover plan and support plan. Formulate the restate strategy and made recommendations to modify the design wherever required.