SUMMARY:

• 10 Years of IT Experience including SAP BODS, HANA 1.0, SAP Business Objects, Actuate SAP Business Objects, Business Objects Data services, Salesforce.com, XCELSIUS, Crystal Reports, SAP Business Intelligence, SAP Business Warehouse, SAP ABAP Objects, Java, Design and Development of Universes and Reports using Business Objects Enterprise products namely - BI 4.0 and Business Object XI R3.1/R3/R2/6.5, Crystal Reports and Xcelsius.
• Diversified experience in implementation Business Objects report management with in Finance, Sales and Marketing, Pharmaceuticals and Telecommunication.
• Expertise in Universe designing/developing and generating reports with complex, business views, ad-hoc reports, dashboards.
• Expertise in using Import Wizard to migrate reports and universes between different environments like development, testing and production.
• Experience in creating users and user groups, restricted access of the users as needed using Central Management Console CMC . Involved in managing users, groups, folders and published reports using Central Management Console.
• Experience in Star-Schema Modeling, Snowflake Modeling, Fact, Dimension tables and Dimensional modeling
• Migrated Business Objects environment from Business Objects Enterprise 6x to XIR2 and also from XIR2 to XIR3.
• Experienced on creating dashboards using Xcelsius 2008/SAP Dashboards by importing data files to create the visualization utilizing QAAWS and Live Office connections. Expertise creating Executive dashboards for the Top Management showing summary metrics for the Key performance Indicators KPI's .
• Built, designed, and tested various levels OLAP and OLTP reporting systems using Business Objects product suite. Strong skills in interfacing Business Objects with Databases like Oracle, SQL Server etc.
• Experienced in interacting with Business Users to analyze the business process and requirements and transforming requirements into screens, designing/analyzing database and documenting.
• Articulate with excellent communication and leadership skills and the ability to develop creative solutions for challenging client needs.
• Proficient in 3-Tier SAP BW Architecture including ETL with BW backend development, Data/Metadata Administration and Reporting.
• Experienced in all phases of Software Development Life Cycle SDLC, quality management systems and project life cycle processes. Highly skilled in Salesforce.com SFDC development and implementation
• Skilled as a Business Analyst, worked on requirements gathering and app design
• Worked Extensively on CRM, SD, MM and FI reporting.
• Knowledge in Business Objects Predictive Workbench and Data mining.
• BW operations - Data load management, event processing, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading Full /Delta Up-Load, Monitoring, Remote Cubes, Data Mart and Open Hub Service, Performance Tuning, Aggregates, BW Transports.
• Proficient with planning, Gap analysis, design implementation
• Expertise of various data design models - Entity Relationship ER, Multi-Dimensional/Star Schema and Extended Star Schema models.
• Extensively worked on data modeling Designing custom info objects, info providers, info cubes, DSO objects, multi providers, infosets, info sources, source systems and dimension modeling.
• Proficient in 5 modes of extraction supported by SAP BW - DB Connect, XML, Flat files and extraction from 3rd party ETL tools.
• Performed extensive FI, CO-PA, LO Cockpit and generic data extractions.
• Customizations - Datasource enhancements, generic extractors, CMOD enhancements, user Exits and Logistics Cockpit configuration and customization, Data extraction from flat files for Master data and Transactional Data, update/transfer rules creation, Business Content Activation, Direct and Flexible update of Master data.
• Expertise in performance tuning using Aggregates, Rollup, collapse, Partition, Compression and query cache maintenance.
• Configured and implemented BW reporting using BEx analyzer/browser, BEx Broadcaster, WAS, XI, Enterprise Portals integration, iViews, Visual Composer, KM and Collaboration Rooms.
• Worked extensively on query development and formatting techniques in BEx, Crystal Reports, Xcelsius, Web intelligence and Web reporting. Has a hand on experience with BO Data integrator.
• Experienced in Business objects universe designing, Business Objects Desktop Intelligence, Business Objects Web Intelligence, Business View Manager, Info view, CMC and Business Objects Enterprise.
• Followed and implemented ASAP methodology.
• Ability to interpret and write ABAP routines.
• Involved in BW work for scheduling background jobs, creating BW/BI Security, user profiles, roles, authorizations and extensive performance tuning work on databases.
• Capable of developing, documenting, and enforcing guidelines for application development to ensure high standards for usability and customer experience.
• Involved in presentations, end-user training, documentation
• Strong planner and organizer with demonstrated ability to master new concepts quickly, incorporate the latest technology, and develop business solutions that increase efficiency, Productivity, and profitability.
• Excellent communication, presentation, and interpersonal skills.

COMPUTER SKILLS:

• ERP: SAP R/3 4.7, 4.6c, 4.6b, 4.0b, and 3.x, ECC 5.0, 6.0, SD, MM, HCM, FI/CO.
• Data Warehousing: SAP BI NW04s BI 7.0, BW v 3.5., BODI 3.0, BODS 3.2, BODS 4.1 and BODS 4.2
• Reporting Tools: Bex and web reporting, Web Application Designer, Visual Composer, Crystal Reports 2008.2011,4.0, BOXI 3.0, Web Intelligence 3.0, Rapid Marts
• Databases: HANA1.0 SP6, Oracle 9i/8i/8.0/7.x, SQL Server 7.0, Teradata, MS SQL Server 2000 and MySQL.
• Programming
• Languages/Protocols: ABAP/4, C, Java, C, SQL, PL/SQL, HTML/DHTML and JavaScript.
• Operating Systems: AIX, UNIX, Windows NT/XP/2000/98/95.

PROFESSIONAL EXPERIENCE:

Confidential

Environment: SAP BODS 4.1 and SAP BODS 4.2, SAP BI 7.3, SAP BOBJ 4.1,HANA 1.0, SAP ECC 6.0, HR, Teradata, SQL Server 2008 and 2005, Information steward 4.0,Information Design tool, WEBI and Crystal Reports enterprise 4.0

Role: SAP BODS/BOBJ Architect. Team Size - 12

Responsibilities:

• Requirement Gathering and Analysis on the requirement from different countries like Columbia, India, Egypt, Russia Brazil, South Africa etc from SAP ECC, BPCS, SAP BW, SQL server and Excel Source Systems.
• Provide Recommendation on Hardware Sizing and Architecture
• Involved in Design and development of EIM Master Data Migration...
• Interacting with Client, Managers, SME's, BA and Database team.
• Extensively in meetings and interviewing Business and Power users, to determine the sources, data Layout, Business needs, and naming conventions of the column and table names.
• Involved in Developing WEBI and Crystal reports
• Involved in Developing Universe and Parameters in IDT.
• Performed complex troubleshooting, root cause analysis, solution development and implement reporting systems to address the issue.
• Loaded excel data to HANA and reported on top of HANA database.
• Involved in migration from SAP BODS 4.1 to SAP BODS 4.2
• Coordinate with Linium Team and web methods team to ensure availability of Source Files and mapping files
• Data Modeling, Designed Logical, Physical models using DBDesigner and MySQL.
• Defined Technical Design document.
• ETL Design use of Complex ETL routines to extract data from DSO converting business functional specifications into mappings/workflows .
• Meeting with Business users and Business Analysts regarding requirements.
• ETL Design converting business functional specifications into mappings/workflows and testing
• Performance tuning for large data files by working on excel block size.
• Error handling in scheduling in Production. Challenge in Handling OLE error
• Performance tuning using Recovery mechanisms.
• Implemented Server groups to use advance performance tuning feature such as parallel data flow.
• Involved in writing DS scripts and also used some built-in functions like Search, Replace, Lookups and Custom Functions for ETL audit process.
• Involved in System integration testing along with other team members of BW and Teradata using various source data scenarios.
• Involved in code enhancement, Create CR and testing based on change request CR from end users.
• Experience in debugging execution errors using Data Services logs trace, statistics and error and by examining the target data.
• Worked with security teams to setup user access levels, and server sizing based on country and Package level access.
• Guiding the development team right from requirement to deployment.
• Leading a Team of 6 in both IBM onsite/ Offshore.
• Involved in ETL end to end implementation.

Confidential

Environment: SAP BODS 4.1 and SAP BODS 4.2, SAP BI 7.3, SAP BOBJ 4.1, SAP ECC 6.0, HR, Teradata, SQL Server 2008 and 2005, Information steward 4.0,Information Design tool, WEBI and Crystal Reports enterprise 4.0

Role: SAP BODS/BOBJ Architect. Team Size - 8

Responsibilities:

• Interaction with the Business Users to analyze the source data and gather requirements, technical specifications in migration of the data to the target SAP BW system and Teradata
• Staging the source data into Data Services Engine from SQL server, flat files and Excel spread sheets implemented necessary transformations to transform as per the target SAP architecture and loaded into the SAP BW system
• Worked extensively in Data Analyzing, Data Profiling, Data Validation and data reconciliation.
• Involved in Data Cleansing, De-duplication and Data Enhancement activities to enrich the Master and Transactional data.
• Created complex source to target data mappings as a part of building the design according to the mapping requirements.
• Built and Unit tested the jobs for migrating objects using SAP Business Objects Data Services best practices to load Master and Transactional data objects into SAP ECC.
• Extensively used Lookup ext, Lookup seq and also created custom functions.
• Used Global variables, Local Variables and Parameters between Work flow and Data flow as per mapping requirements.
• Performed the Correctness test by running the DS jobs and validated the results by comparing the data from the test results of original legacy data.
• Tuned and monitored Data Services Jobs and Transformations for the better performance of jobs.
• Migration of jobs between different Central repositories and executed from Central Management Console as a part of different loads.
• Involved in error Handling, development of custom scripts.
• Leading a Team of 3 in Capgemini onsite/ Offshore.
• Involved in transports of DS objects to QA and PROD.

Confidential

Environment: SAP BODS 3.2,SAP HANA 1.0 SP6 SAP BI 7.3, SAP BOBJ 4.1, SAP ECC6.0, SD, MM, FI, OM, HR,Teradata,SQL Server 2008 and 2005, Universe designer, WEBI.

Role: SAP BODS/BOBJ/HANA Architect. Team Size - 8

Responsibilities:

• Designing the Database to extract data from different database.
• Mapping the legacy database fields to SAP ECC
• Worked on modeling of SAP ECC data in SAP HANA and loading data through SAP BODS.
• Created universe on SAP HANA database.
• Created Model and developed EIM Master Data Migration using SAP BODS.
• Created WEBI reports on Universe and launched the reports to infoview.
• Worked with MDM team and highlight any issues / dependencies Customer Master, Employee Master, Product Master, Sales Align Data, Distributor master, Contract Master
• Modeling the Database on Teradata and SQL Server 2008.
• Experience with Standardizing and customization of Master Data
• Worked in ABAP in developing the ABAP dataflow in BODS
• Extracting the data using BODS from the legacy system and SAP ECC to Teradata and SQL Server 2008.
• Designing and Modeling the SD, MM, FI, OM and HR SAP Modules to fit the legacy system to SAP System.
• Developing the Rapid Marts for Reporting
• Developing the Universe using the Universe Designer 3.1 on the Teradata Database
• Developing WEBI Reports on universe designer.
• Involved in Data Cleansing Data Validation

Confidential

Environment: SAP BODS 3.1,HANA 1.0 SP6,SAP BI 7.3, SAP BOBJ 4.0, SAP ECC6.0, SD, FS, OM, Crystal Reports 4.0,Crystal reports 2008 Universe designer, WEBI.Oracle, SQL 2005,Teradata

Role: Lead SAP BI/BO/HANA Consultant. Team Size - 12

Responsibilities:

• Working on information Design tool IDT to create universe from multiple data source.
• Working on Multiple Data source like Oracle, SQL server, Teradata, BW and ECC to extract LMS and GWS data.
• Worked in development of ABAP function module to extract real time data from SAP ECC to build universe.
• Working on Crystal reports direct connection to function module of ECC through Information design tool.
• Working on Arcos State Regulatory reports using web intelligence.
• Worked on Client work - List for Collections Billing reports in both BEX and Crystal report.
• Worked in Customer Build /Update reports using Crystal reports
• Worked on migration of universe and reports from BOXI.3.1 version to BOBJ 4.0.
• Extracting the data using BODS from the legacy system and SAP ECC toTeradata.
• Worked in returns Count report using web intelligence
• Worked on creating universe on SAP HANA
• Created WEBI reports on universe and published to Launchpad.
• Worked in EDI vs. Manual by Customer type report using Crystal reports
• Worked on Client sales recap report using Xcelsius
• Worked on Creation of generic extractor using view for Credit and release report.
• Worked on Price Override Audit report
• Worked in migration of teradata to HANA through Data services.
• Worked on Customer Master Report Using Crystal reports
• Worked on Credit s and Debits reports using Crystal reports
• Involved in performance tuning of reports in crystal reports.
• Involved in Installation and trouble shooting of Business Objects 4.0 and Crystal reports from the service market place.
• Developed Universe connecting to SAP ECC system using the Data Federator.
• Developed reports in WEBI using Universe designer.
• Involved in Production Support and post Go-Live
• Working in Universe designer BOXI reports and upgrade to BOBJ 4.0
• Worked both in Relational and OLAP database.
• Worked in UNV UNX conversion.