SUMMARY

• Confidential is a talented senior business transformation consultant with exceptional and diverse background in IT, Finance, Sales, Marketing and Supply Chain billion dollars multinationals across Europe and USA.
• Confidential has 8+ years of leading implementation experience in SAP BI BO technology creating enterprise solutions that include Business Objects architecture, software deployment, infrastructure maintenance, administration, security, universe/report/dashboard development, documentation, UAT, production support and user training.
• BO Toolset experience in SAP BusinessObjects, Explorer, Universe Designer, Web Intelligence, Crystal Reports, SAP Dashboards, Xcelsius, SAP Lumira, SAP Design Studio, Live Office, Analysis for OLAP, Analysis for Office, and BICS connection
• Hands on experience and knowledge of SAP Business Warehouse BW 3.x/BI 7.x, Business Explorer (BEx) query design, SAP R/3, ECC 6.0, Netweaver, BPC, and BODS
• HANA platform experience and knowledge in HANA as a database, HANA Modelling in HANA Studio, connecting to other backend databases and frontend tools such SAP BO, Qlikview, and Tableau
• Experience with RDBMS databases such as Oracle 11g, MS SQL, DB2, also hands on experience on Oracle OBIEE, Seibel Analytics with ETL tools such as informatica etc.
• Have practical knowledge and have taken a training in the futuristic BI Tools and Technologies including BIG Data Analytics, Hadoop and Cloud computing
• Diversified domain experience in Consumer, Banking, Manufacturing, Automotive, Pharmaceuticals, Utility and Chemicals in US, and Europe such as Germany, France, UK, Netherlands and Ireland.
• Deep ability to understanding business requirements, documenting, developing, designing, implementing, testing and deploying BI solutions, articulating a vision, evaluating risks, defining roadmaps to build and strengthen BI capabilities, processes, infrastructure/system investments, and in full project life cycle management and methodologies.
• Track record of developing and building key relationships with a range of project participants including boards, executives, directors, managers, vendors, client stakeholders, and developers.

PROFESSIONAL EXPERIENCE

Confidential

SAP BI BO Consultant

Responsibilities:

• Responsible of implementation and delivery of frontend reporting solution for Marketing and Sales stream using SAP BusinessObjects BI 4.1 toolset.
• Supported Functional design requirement gathering process and helped business users refine the requirement to improve design and the functionality of the proposed reporting solutions.
• Categorized KPIs and eliminated redundancies and assigned to various reporting levels
• Supported SAP BW team in validating, streamline and optimize the BW backend data model, performance tuning and assisted in the BEx query design and integrate into the SAP BO frontend tools
• Segmented and formulated the reporting layers based on the usage and the audience, and categorized them within the SAP BusinessObjects tool set frame work for development.
• Developed BO Dashboards, OLAP Analysis, and Office Analysis for hierarchical user groups from senior directors to middle managers.
• Help identify and develop the security matrix required within the BW Role and aligned them with the fronted Dashboards within various global, local, functional and cross - functional user groups.
• Supported UAT process, resolved issues, implemented improvement

Confidential

BI BO Lead Consultant

Responsibilities:

• As a lead BO consultant, gather and analyzed requirements from the stakeholder, worked with the data owners and DB developers to create a mini data warehouse, Developed universes, developed and delivered 10 WEBI and Live office reports.
• Additionally, upgraded the existing older XI 3.1 system to BO 4.1 SP1, migrated users and securities, helped UAT, and implement improvements

Confidential

Business Intelligence Consultant

Responsibilities:

• Interacted with stakeholders to gather, analyze and record requirements/ specifications.
• Analyzed the DW, Developed KPIs, used BODS for ETL Data, oversee the installation and scaling and configuration and Administration of BO XI systems on Solaris with Tomcat on multiple environments
• Created and maintained multiple BO universes, derived Tables within the Universe using views and stored procedures to meet the WEBI Intelligence Reporting Requirements. Created Cascading Prompts on the Reports.
• Oversee the report development and provide support to developers report design issue, and carried out the UAT and approval process with the stakeholders
• Documented system and provided BO user training to multiple user groups.
• Prepared universe for Ad-hoc query functionality to educate users. Allowing them to run queries to create some reports using objects in the universe.

Confidential

Lead BI BO Consultant

Responsibilities:

• Lead the development effort on the finance transformation program FTP implementing a set of 100+ BO reports for Finance, Marketing, and Operational and HR department across six Business Units.
• Leveraged the BICS connection functionality on BOE 4.0 Service pack 5, to connect to SAP BI 7.3 for directly connecting to source system. Created and maintained the web services for data exchange between WEBI and Dashboards
• Created and maintained the reporting hierarchy for 7 BU across 5 different functional units in BOE 4.0 repository.
• Participated in the design and development of SAP BPC planning and consolidation templates and KPI design for the utilization in BO reports.
• Created and modified BEx queries on BPC and BCS data and utilized BICS connection to create WEBI reports
• Developing BO universes to handle the reporting commentary solutions, issues opportunities solutions.
• Created and managed BI workspaces, created Overview summary pages, designed the Waterfall charts in SAP Dashboards
• Managed the testing and transports between DEV and QA systems
• Carried out admin tasks in CMC, stopping running BO servers, scheduling reports, created users, and applied security setting matrix. Trained users provided demos and wrote Technical specs.

Confidential

DW BI BO Consultant

Responsibilities:

• Analyzed existing mainframe solution and participated in building a data warehouse collecting manufacturing sales, dealership data from legacy systems and other source system.
• Crated object data dictionary working with the sales, marketing, and finance users
• Designed an ETL process to load data into the data warehouse using informatica as a tool of choice.
• Recommended SAP BusinessObjects for creating the frontend solution, helped install BO 4.0 DEV, QA and PROD environments, created repositories folders, user groups, assigned securities, provided training to DB and ETL developers
• Create functional blue prints for BO universe design, designed dimensions and fact tables, resolved loops and traps, WEBI Reports, wrote technical design documents and developed the WEBI reports according to the specification
• Carried out
• Developed user training material and provided group training to multiple layers of users.

Confidential

SAP BO Consultant

Responsibilities:

• Lead a BO report conversion project, converting reports from Crystal Report into SAP BO XI WEBI reports
• Created multiple universes for various functional departments
• Created new set of objects in the universe giving visibility to more data to the finance, and supply chain areas of the company
• Added additional tables and mappings in the MS SQL Database
• Developed 15 WEBI reports replicating Crystal functionality as a part of drive to streamline reporting across all subsidiaries
• Trained user and groups on BO client tool set.

Confidential

SAP Dashboards Consultant

Responsibilities:

• Researched and documented the project scope, master data, existing reporting landscape, new key figures, cubes, DSO’s, hierarchies, Product and Region KPI’s.
• Developed Region and Product KPI’s, profit, Net Sales, Growth, Human Resources, in terms of Profit & Loss (income statements), Balance Sheets, Cash Flows, for Period, YTD, YEL (Year End Landing) variances against Budgets (AOP) and Forecasts
• Defined Data Model, maintained master data, defined product and region KPI mappings
• Developed 30 BW BEx based queries including designing new structures and additional reporting variables, as data feeds for Xcelsius logic
• Held regular team meetings with business interface involving them in the Xcelsius application and logic building process and receive their regular feedback
• As lead developer created functional design, technical design and delivered a corporate dashboard for the management leveraging SAP Xcelsius.
• Developed regional copies of the dashboards for various European local country directors.
• Used Add-ons to accomplish complex charting requirements like water-fall models and graphs using an add-on Graphomate for Xcelsius

Confidential, Chicago, IL

BW BI Consultant

Responsibilities:

• Maintained a list of reporting inventory of 400+ reports for various PepsiCo BUs
• Installed BO tools such as WEBI rich client, Crystal Reports, Xcelsius on local machines.
• Developed management dashboards for the BU managers and finance, sales, marketing directors.
• Built universes and maintained 30+ complex and ad-Hoc reports in Web Intelligence, Live Office, Crystal Reports and Xcelsius dashboards
• Developed and maintained BW BEx queries and workbooks.
• Frequently visited onsite team for gathering additional business requirements
• Analyzed SAP BW BI cubes data, dimensions, infoObjects, Characteristics, Key Figures, ODS and requested adding additional objects where necessary
• Documented BW multi-providers, created maps of financial and accounting info areas for all available infObjects for end user consumption.
• Created functional designs based on the reporting request from business and communicated to the BIS providing the extractors, dataSources, infoSources, ECC Fields mapping to BW provided details to the BIS BW functional team

Confidential, Lake Forest, IL

BW BI Support Analyst

Responsibilities:

• Installed and configured Business Objects XI R2 & XI 3, Web Intelligence, Crystal Reports, Xcelsius on server and client machines
• Develop and support reporting for marketing, sales and finance leadership teams and departments.
• Extracted data from CRM systems to create BO reports
• Developed BEx queries workbooks, gather requirements and passed on to BW functional team for the development of new CKF, RKF, variables, filters, replacement path variables, structures, and info objects etc.
• Developed master and meta data repository

Confidential, Des Plains, IL

BO Analyst, Sales Reporting Consultant

Responsibilities:

• Maintained & modified the existing Universes based on the business requirements.
• Created new events, folders, profiles, users and groups in CMC.
• Developed Deski & Webi reports, dimensions, details and measure object, published reports to different user, and assigned security to the folders, Universes and Reports.
• Solved complex issues in Reports by working with Business Objects team.
• Developed and maintained BW BEx Queries, Workbooks, CKF, RKF, Formulas, Conditions, Cell definitions, Structures, Variables, filters and exception for BEx queries

Confidential, Rosemont, IL

Reporting Consultant

Responsibilities:

• Develop and modify BO reports built charts, graphs and summary tables, built excel reports, BW BEx reports and workbooks and resolve customer issue running these reports
• Run daily weekly and monthly sales, finance and marketing reports and email to Senior leadership team
• Published reports using Info View, and training users for ad-hoc reporting.

Confidential

Data & IT Analyst

Responsibilities:

• Maintained and supported from FX, SWIFT and BIC payment systems of the bank.
• Monitored the flow of the cross border multi-currency payment in various databases and created reporting using SQL query language.

Confidential

Software Testing Lead

Responsibilities:

• Lead software testing teams for in-house and onsite projects for Microsoft X-Box Game testing division.