SUMMARY

• Around 10+ years sap experience which includes SAP BOBJ & HANA .
• Excellent Experience working on Business Objects 4.0, Releases XI R2/3.1/4.0 SP2, SP4 and SP5 (CMC, CCM, CMS, LCM, Promotion Management, Information Designer tool, Business Intelligence Consumer Services (BICS), Universe Design (Unv and Unx), Web Intelligence 4.0, Business Intelligence Web Services (BIWS), Report Conversion Tool, Crystal Reports 2001, Dashboard Design using Xcelsius, Live Office, Query As a Web Service (QaaWS), SAP Business Objects Explorer, Good understanding of BEX.
• Expertise in Business Explorer Suite - BEx Query Designer, BEx Analyzer and BEx Web Analyzer.
• Strong work experience in Dimensional Modeling, and designing Star and Snowflake Schemas, Fact and Dimension tables.
• Experience in using Information design tool (IDT), to create universes using multiple Data Sources.
• Created connections to BEx queries and BW Info providers using Business Intelligence Consumer Services (BICS) in IDT.
• Reports created for different business areas like FICO,MM, COPA,SD etc..
• Experience in Designing/Developing Universes/Data-Model, Developing Canned/Ad-hoc Reports, Scheduling and processing of reports.
• Excellent skills to develop reports using Web Intelligence Rich Client 4.0.
• Developed WEBI reports on SAP BW Queries using BICS.
• Modified BW queries in to generate WEBI reports in BO to meet user requirements.
• Expertise in creating Xcelsius Dynamic Dashboards using SAP BI data/ BEx Queries. Valuable Knowledge on Dashboard Designer Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.
• Proficient in Business Objects Reporting using Crystal Reports, WEBI Rich Client 4.0, Live Office and Xcelsius for both SAP and Non SAP sources.
• Strong knowledge In creating connections using Data Connection manager like Query Bowser, Live Office, Query As A Web Service (QAAWS), Flash Variables, SAP BI connectors, UD connecters, DB connectors.
• Knowledgein CMC Administration activities like creating and managing repositories, monitoring/granting, permissions and rights to users, user groups through Central Management Server.
• Strong experience in SAP BI/BW 7.0 - Business Objects 3.1/4.0, SAP BW-BO Integration, Creation of BI Queries(BEx) and Reports and Dashboards on top of BI/BEx Queries.
• Creation of Bex queries on BI 7.0, 3.5 (Reporting).
• Involved in teh configuration of SAP HANA SLT from SAP R3 to HANA.
• Involved in teh configuration of Data Services (BODS) and replicated teh data fromsource system to SAP HANA system
• Create Custom Attribute views, Analytical Views & Calculation Views in SAP HANA.
• Good understanding on Data Services 4.0/3.2/BODI 3.1 concepts which involves creating of complex Jobs, Work Flows, Data Flows, Writing Scripts and using different Transformations to successfully load data from multiple sources into a desired target.
• Good understanding of ABAP Data-flows, BW extractors, IDOCs, Templates and RFC (as a remote function) to read and write data from SAP sources.
• Good understanding of relational database management systems like Oracle, DB2, and SQL Server and extensively worked on Data Integration for teh Extraction transformation and loading of data from various database source systems.
• Data Modeling & Data Analysis experience using Dimensional Data Modeling and Relational Data Modeling, Star Join Schema/Snowflake modeling, Fact & Dimensions tables, Physical & Logical Data Modeling.
• Work closely wif various levels of individuals to coordinate and prioritize multiple projects. Estimate, schedule and track ETL projects throughout SDLC.

PROFESSIONAL EXPERIENCE:

Confidential, KY

BOBJ/Hana Developer

Responsibilities:

• Implementation project as per ASAP methodology - Project preparation, Business Blue Print, Realization, Go -live
• Conducted workshops wif users to gather requirements and to understand teh workflow of teh as-is system, analyzed workflow to design To-be solutions, documented teh findings, assessed scope of studies.
• Preparation of teh technical specification by understanding business functionality from teh functional specifications, according to teh client's requirement.
• Understand and document teh requirements based on teh source and target systems and also created data mapping documents and Developed Specifications data mapping and Unit Test Plans for each of teh Conversion Processes.
• Creation of Attribute views, Analytic views and Calculation Views based on replication data using HANA modeler.
• Worked on Restricted, Calculated Measures, Variables and Input Parameters in Analytic views.
• Created Store Procedure using SQLScript.
• Creation of Analytic privilege to apply restrictions on teh Information views.
• Restricted access to data by assigning relevant roles to users based on user profile.
• Created Information spaces in explorer based on HANA Information views.
• Worked on SAP SLT Configuration and Monitoring Dashboard to create schema, monitor tables, monitor connections, monitor statistics of tables.
• Worked on Hana studio to load, replicate, stop replication suspend and resume tables in Server based table data provisioning screen.
• Creating different types of jobs in SAP SLT like Real time job, schedule by interval, schedule by time. Managing teh Replication Process Using teh SAP HANA Studio.
• Worked on SAP SLT complex table structure changes (change data type or length, add or delete key fields) teh trigger and logging table has to be dropped and recreated. Also on HANA side dropped and recreated to ensure data consistency.
• Developed Data Services job to pull data from SQL and Oracle into HANA database.
• Worked wif various transformations like Query, SQL, Key Generation, Merge, Case, Map Operation and Table Comparison in Platform and DI Transforms and extracted data according to teh business rules and Technical Specifications.
• Developed processes to meet teh goal of 100% clean data in an environment of zero tolerance for duplicate records.
• Used SAP BODS to pull data from SQL into SAP HANA.
• Involved in design and development complex ETL mappings and stored procedures in an optimized manner.
• Developed Data Services job to pull data from Flat & Excel files into HANA database.
• Integration between BODS & BW.
• Used teh ABAP data flows to read data from SAP to SQL Server for reporting purpose.
• Developed complex mappings as per teh requirement using almost all transformations and effectively used Debugger for identifying errors and resolving them.
• Used query, match, validate transforms and look up function for data integration purposes.
• Preparation and review of test cases.
• Involved in creating Data foundation and Business layers as per teh requirements.
• Resolved loops and Traps using Contexts and Aliases while designing Universes.
• Set up Universe level conditions to restrict data based on report requirements.
• Developed and created classes wif Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports
• Knowledge on Derived tables in teh Designer to enhance teh capabilities and performance of teh universe.
• Customized Universe level Prompts as per Functional Requirements.
• Check teh integrity of teh Universes, and export teh universes to Repository for making available to users.
• Teh project involved in teh development of reports using Business Objects Web Intelligence to cater Ad-hoc reporting needs.
• Created reports using Business Objects functionality's like Queries, Drill Down, Cross Tab, Master Detail and Formulae's.
• Created Standard Reports utilizing all teh features on Web Intelligence in BOE XI 4.0 like Optional Prompts, Functions, Alerts etc.
• Created Breaks, Filters at Different Levels of teh reports and applied ranking in teh Webi reports.
• Extensively worked wif formatting teh reports according to teh user requirements.
• Used Web intelligence to create, edit and set different options for teh corporate documents.
• Provide support for teh Operations Risk Department workflow enhancement efforts includes Data issue identification and analysis, data mapping, data contents of reports and source of data contents.
• Created Breaks, Filters at Different Levels of teh reports and applied ranking in teh Webi reports

Environment: SAP ECC 6.0, SAP HANA, SLT, BI/BW, SAP Business Objects 4.0 XI,IDT Tool,SQL, HP Quality Center, SAP Crystal Reporting.

Confidential CA

Team Lead & BOBJ

Responsibilities:

• Interacted wif teh management and business Decision-makers to identify business requirements.
• Interacted wif offshore team to provide requirement clarification and issue resolution.
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for creation of teh universe wif Classes, Objects and Condition Objects.
• Created Aliases and Contexts to resolve teh Loops and Traps (fan traps and chasm traps).
• Modified BW queries in to generate WEBI reports using BI Launch Pad in BO to meet user requirements.
• Developed WEBI reports on SAP Bex Queries using BICS in Webi Rich client.
• Created monthly and summary reports in WEBI 3.0 for teh different domains like Finance, Marketing and HR domains.
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
• Created WEBI reports & Crystal reports and deployed them through BI Launch Pad wif Bex as source.
• Created Marketing and Finance Dashboards for FP&A, Inventory Management and Cost Center Accounting data.
• Created complex dashboards on Bex Queries using Query Browser in Dash board designer.
• Created Dashboards for FP&A using BIWS and QAAWS in Dashboard Designer
• Exclusively used QAAWS and Live Office to import data to spreadsheet and develop visually rich dashboards.
• Worked on optimizing teh performance of teh dashboards. Reduced teh dashboard loading time by scheduling teh backed source webi reports and by selecting teh filter option changing wif refresh on trigger option to pick from teh latest instance.
• Created Dynamic Dashboards using SAP BI data/ BEx Queries. Has Valuable Knowledge on Xcelsius Dashboard Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.

Environment: SAP BO 3.0, Netweaver 2004, SAP BW 7.0, ECC 5.0 Business Areas: FICO, COPA MM (Purchasing), SD, BEx, WEBI, IDT, XcelsiusDashboard Design Tool.

Confidential, CT

Sr.BOBJDeveloper & Team Lead

Responsibilities:

• Interacted wif teh management and business Decision-makers to identify business requirements.
• Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in teh Query Designer.
• Experience in creating universes using UDT .
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for creation of teh universe wif Classes, Objects and Condition Objects.
• Created Aliases and Contexts to resolve teh Loops and Traps (fan traps and chasm traps).
• Modified BW queries in to generate WEBI reports using BI Launch Pad in BO to meet user requirements.
• Developed WEBI reports on SAP Bex Queries using BICS in Webi Rich client.
• Created monthly and summary reports in WEBI 3.0 for teh different domains like Finance, Marketing and HR domains.
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
• Created WEBI reports & Crystal reports and deployed them through BI Launch Pad wif Bex as source.
• Created Marketing and Finance Dashboards for FP&A, Inventory Management and Cost Center Accounting data.
• Created complex dashboards on Bex Queries using Query Browser inXcelsius Dash board designer .
• Worked on optimizing teh performance of teh dashboards. Reduced teh dashboard loading time by scheduling teh backed source webi reports and by selecting teh filter option changing wif refresh on trigger option to pick from teh latest instance.
• Created Dynamic Dashboards using SAP BI data/ BEx Queries. Has Valuable Knowledge on Xcelsius Dashboard Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.

Environment: SAP BO 3.0, Netweaver 2004S, SAP BW 7.0, ECC 5.0 Business Areas: MM (Purchasing), SD, BEx, WEBI, UDT, XcelsiusDashboard Design Tool.

Confidential, Philadelphia PA

BOBJ Developer

Responsibilities:

• Interacted wif teh management and business Decision-makers to identify business requirements.
• Document reporting needs of teh Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in teh Query Designer.
• Experience in creating universes using information design tool 4.0 and also connecting to multiple data sources.
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for creation of teh universe wif Classes, Objects and Condition Objects.
• Created Aliases and Contexts to resolve teh Loops and Traps (fan traps and chasm traps).
• Modified BW queries in to generate WEBI reports using BI Launch Pad in BO to meet user requirements.
• Developed WEBI reports on SAP Bex Queries using BICS in Webi Rich client.
• Created monthly and summary reports in WEBI 4.0 for teh different domains like Finance, Marketing and HR domains.
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
• Created WEBI reports & Crystal reports and deployed them through BI Launch Pad wif Bex as source.
• Created Marketing and Finance Dashboards for FP&A, Inventory Management and Cost Center Accounting data.
• Created complex dashboards on Bex Queries using Query Browser in Dash board designer 4.0
• Created Dashboards for FP&A using BIWS and QAAWS in Dashboard Designer 4.0.
• Exclusively used QAAWS and Live Office to import data to spreadsheet and develop visually rich dashboards.
• Worked on optimizing teh performance of teh dashboards. Reduced teh dashboard loading time by scheduling teh backed source webi reports and by selecting teh filter option changing wif refresh on trigger option to pick from teh latest instance.
• Created Dynamic Dashboards using SAP BI data/ BEx Queries. Has Valuable Knowledge on Xcelsius Dashboard Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.

Environment: SAP BO 3.0, Netweaver 2004S, SAP BW 7.0, ECC 5.0 Business Areas: MM (Purchasing), SD, BEx, WEBI, UDT, Dashboard Design Tool.

Confidential

BI Developer

Responsibilities:

• Involved in Modifying teh existed Fact tables and Dimension tables in teh Business Model and Mapping
• Modified reports, filters and charts in Answers and added them to Intelligence Dashboards
• Involved in Modifying teh Columns at BMM and Presentation layers by using existing joins.
• Created dashboards, pages, reports wif various views me.e. table, pivot, charts, narrator, column selector etc. and various report prompts
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in teh reports.
• Responsible for teh administration and migration of user reports or repositories between various environments

Environment: Oracle Business Intelligence 10.1.x, Oracle 9i/10g, PL/SQL, Sql server. Siebel 8.0,HP QC

Confidential

Actuate Reports Developer

Responsibilities:

• Understanding teh user requirement and developing teh technical documentation.
• Creating teh reports in Actuate eReporting Professionals 7 based on teh user requirements like parameterized reports, master detail reports and graphical reports etc
• Generating Actuate library (.rol) from Siebel tools.
• Configuration of Application for report specific changes.
• Design and Develop New Reports
• Execute and test teh converted report.
• Customizing teh reports as per functional requirement in Actuate e. Report Designer Professional
• Execute and test teh report in multiple languages.
• Involved in developing teh Critical Actuate Reports using data sorter .
• Uploading teh ROX files to Server by using Actuate Management console
• Involved in Extensive Configuration and customization of creating applets, views, Business components
• Export and import teh .SIF files
• Involved in Unit Testing and debugging teh Bugs.

Confidential

Actuate Reports Developer

Responsibilities:

• Creating teh reports in Actuate reporting Professionals 7 based on teh user requirements like simple reports, parameterized reports and master detail reports
• Generating Actuate library (.rol) from Siebel tools.
• Configuration of Application for report specific changes.
• Creation of joins
• BC and Applet Creation for parameterized reports
• Design and Develop New Reports
• Execute and test teh converted report.
• Uploading teh ROX files to Server by using Actuate Management console
• Involved in Unit Testing and debugging teh Bugs.
• Export and import teh .SIF files.