SUMMARY:

• Ten plus (10+) years of Total IT experience in Analysis, design, development and Implementation of Business Intelligence solutions using Business Intelligence applications on Windows.
• BW 3.5 / BI 7.0, BW 7.4HANA, 7.3 / Bex / BOBJ EXPERIENCE / CRYSTAL REPORTS / XCELSIUS / UNIVERSE DEVELOPMENT (UDT,IDT) / DASHBOARDS/Design Studio / Hana.
• Eight Plus (8+) years of strong experience in SAP BW 7.4, 7.3, BI 7.0 and BW 3.5. Four life cycle implementations involving design and development of BW objects, Transformations, Business Content configuration, planning using SAP ASAP.
• Involved in Requirement Gathering as a business requirements translating functional specs into technical specs to develop the report in the given time lines.
• Ability to manage and interact with small and medium team for development of the report as per business logic and deliveries on time.
• Involved in providing training to the end user for report execution and tool understanding for end user.
• Have very good functional knowledge of SAP R/3 application areas like SD(LIS Extractors), MM(LIS Extractors).
• Working Sales Data and Sale pricing Procedure in SD.
• Involved in creation of Custom extractors as per business requirement with ABAP code.
• Expertise in OLTP extractions from SAP R/3 using LIS extractors and Generic Extractions. Customizing extractors, creating Data Sources for DB Connect systems.
• Developed Transformations, Update Rules, Transfer Rules and ABAP routines for transaction & master data in start/end routines and routines for characteristics.
• Experience in creating Info Packages, DTPs, creating Process chains and Scheduling of data loading with Full/Initialization/Delta upload method.
• Designed queries in BEx Query Designer, creating structures, calculated and restricted key figures, character variables, formula variables and text variables.
• Involved in BW Transformation logics implementation through ABAP routines.
• Involved in automation of data loads to BW using process chains.
• Expertise in Data Modeling, Multi Dimensional/Star Schema and Extended Star Schema models. Strong knowledge of SAP BW architecture and SAP BW data model
• Creating Open Hub Destinations and APDs to transfer data outside BW system
• Involved in the production support, which required Load monitoring, handling load failures, resolving tickets, dump and reload activities, Info Cube management using Compression, Rollup, Reconstruction, Indexes and Partitioning and performance tuning using Aggregates, maintaining multiproviders and Info sets.
• Proven ability to work efficiently in both independent and team environment.
• Very fluent with business process documentation and end - users training/knowledge transfer.
• Demonstrated ability to complete multiple assignments simultaneously and maintain high standards of client organizations.
• Three Plus (3+) years of strong experience in decision support systems using Business Intelligence tools SAP BOBJ 4.1/4.0/3.1 / XI R3
• Expertise in Business Objects Enterprise products (Universe Designer, Infoview Web Intelligence, Web Intelligence Rich Client, Desktop Intelligence, Supervisor, Broadcast Agent, Central Management Console, Central Management Server, Central Configuration Manger, Xcelsius Dashboard, Crystal Reports).
• Experience in building Universes. Retrieving data using Universes, Personal data files, stored procedures, free hand SQL methods. Creating complex ad-hoc Reports using the Business Objects and Web Intelligence modules. Experience in gathering requirements from the business users and prioritizing those requirements, which have the highest business impact in terms of analysis and decision-making. Worked with Business users to analyze the business process and made necessary changes to the schema objects.
• Extensively Used CMC (Central Management Console) for user management, content management, and server management tasks and CCM (Central Configuration Manager) to manage local and remote servers.
• Proven track record of successful implementation of all project life cycle stages from requirements gathering through implementation and enhancements. System / Software Product implementation experience
• Experience in building Business Objects Universes, Stored Procedures, Free Hand SQL methods and creating Complex canned and Ad-Hoc Reports using Business Objects reporting application like Web Intelligent / Desktop Intelligent / Crystal Reports XI R2 and interactive Dashboard with visual effect using Xcelsius
• Expert in presenting any excel spreadsheet data in to interactive reports/Dashboard to remove gap between data analysis and visual presentation. Created extensive Xcelsius interactive Dashboard / What-if Scenario’s using special components like drill down charts, container, filters, list builders, tree maps and many of others and also advance use like dynamic visibilities, status list. Published Crystal Xcelsius reports using Live Office and QAAWS.
• Proficient in translating report requirements into detailed report specifications, confirm report design with business users and creating reports using Business Objects
• Good hands on Xcelsius 2008/4.5 / Business Objects XI 3.1 visualization component (What You See Is What You Get representation)
• Crystal Reports Expertise in creating Business Views (Creation of Connections, Dynamic Data Connection, Data Foundation, Business Elements and Business view) and Reports using Business Views.
• Created complex reports using Crystal Reports XI R2.
• Created Linked Sub Reports, Unlinked Sub Reports and On Demand Sub Reports.

PROFESSIONAL EXPERIENCE:

Confidential, Illinois

SR. SAP BW / BOBJ DEVELOPER/Analyst

Responsibilities:

• Responsible for solution design for the SAP BW Implementation flows.
• Responsible for reviewing Functional Specification, Technical Design specifications and providing corrections in the design.
• Extensively worked on LIS and custom extractors to meet the business requirement.
• Identifying gaps in the system to stabilize the BI System.
• Involved in Requirement Gathering as a business requirements translating functional specs into technical specs to develop the report in the given time lines.
• Ability to manage and interact with small and medium team for development of the report as per business logic and deliveries on time.
• Involved in providing training to the end user for report execution and tool understanding for end user.
• Involved in different BW releases to handle the enhancements in BW and creation of custom extractors as per the report requirement.
• Involved in Performance & Tuning activities.
• Involved in development of Real Time Cubes, Planning sequences, Aggregate levels and Input ready queries for Integrated Planning.
• Developed Sales and Profit Planning Model in BI-IP.
• Involved in Order to Cash backend & frontend development activities in BW area including Pricing Tables.
• Developed real time Infocube, Aggregation level, Planning functions. Filters, Planning Sequence.
• Input Ready Query, Characteristic Relationship, Locking Table and Manual Planning .
• Involved in Extraction and enhancement of standard Sales Document Conduction Data sources for pricing.
• Involved in Extraction and enhancement of standard billing Conduction Data sources for pricing.
• Creating Custom Data sources from pricing tables for customer Pricing Procedure.
• Involved in automation of data loads to BW using process chains.
• Involved in BW Transformation logics implementation through ABAP routines.
• Involved in System refresh activities.
• Responsible for maintenance of system consistency across the landscape.
• Identifying performance improvement areas to improve the Flexibility, Maintenance of the BI System.
• Responsible to meet the SLA to deploy the objects in the production environment.
• Responsible for implementation of security activities in the BW system
• Involved in End user support to fulfill the requirements.
• Analyzed business model and created BI Architecture plan, created Business Functional Specifications, Functional Design Specifications, and Detailed Design Specifications
• Analyzed the business requirements for reporting needs and Developed ETL dataflow to Load the data in to the fact tables, dimension tables and measures of DSO’s, Info Cube’s.
• Created New Universes and maintained Universes by Interacting with Business Analyst, Data Architect to make more efficient universes and tested them on the reports.
• Designed, Developed and Maintained Universe in BOXIR3 Designer by defining joins and indicating cardinalities between tables in snowflake schema (fact and dimension table) from data warehouse, creating Aliases to resolve the Loops, subdividing into Contexts to remove cyclic dependencies. Created the objects, which are grouped into classes for convenience in Business Objects Designer. Created custom List Of Values. Used @Aggregate Aware, @Where, @Select, @Variable, @Prompt when required
• Defined Access Restrictions in the universe for Confidential, Non Confidential and Highly confidential User groups and applied to the groups defining the priorities for different Access Restrictions. Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure
• Designed the Universe with the ability of adhoc reporting for users
• Handled query performance by created conditions in Universes and optimizing it at the Database level
• Created complex conditions (Dates), Prompts and free hand custom SQL to create Derived tables in universe. Defined logical classes and objects and hierarchies for analysis and drilling on hierarchies in the WEBI reports
• Created Derived tables on the universe to develop complex reports.
• Assisting the client, through analysis of their existing system, challenges, and business needs
• Documented the reporting requirements by thorough interactive sessions with Business users by building prototypes for developing the interactive executive level dashboards.
• Involved in Working with Enterprise Architect tool in Data Modeling
• Built and modified complex reports in Web Intelligence.
• Applying Drill Filters, sorts, breaks and multiple Tab reports with charts, crosstabs format, master/detail report.
• The reports are built using Webi Rich Client and exported to CMS and scheduled instances of WEBI reports in Info view
• Unit Testing is performed Reports and Universe using HP Quality Center and updated the results in HPQC.
• Resolved Issues like Isolated Joins, Loops, Contexts using Aliases and Contexts where ever appropriate.
• Created Self-joins, Complex Joins between tables in the Universe for efficient query performance.
• Worked with Linked universes and created new contexts for them accordingly.
• Evaluated the Use of Aggregate Tables and worked with Data Architect for creating them in the Database.
• Extensively used @Prompt, @Variable, @Select in the Design of the Universe.
• Worked on CMC server for customizing scheduling and publishing reports.

Environment: SAP BI/BW/HANA, SAP ECC (LIS and Generic Extractors), BeX Designer SAP BOBJ 4.1,4.0/3.1, APO,Web Intelligence 3.1, Universe Designer, Analysis Office Webi Rich Client, Design Studio Import Wizard, Central Management Server (CMS), Central Management Console (CMC), Central Configuration Manager (CCM),MS Visio, MS Project, Crystal .

Confidential, Pleasanton, CA

SAP BW / BOBJ DEVELOPER/Analyst

Responsibilities:

• Responsible for solution design for the SAP BW Implementation flows.
• Responsible for reviewing Functional Specification, Technical Design specifications and providing
• Corrections in the design.
• Identifying gaps in the system to stabilize the BI System.
• Responsible for different BW releases to handle the enhancements in BW and creation of Custom Extractors..
• Responsible for Performance & Tuning activities.
• Responsible for Transportation repackaging activities to transport the objects in cross environments.
• Responsible for System refresh activities.
• Involved in Requirement Gathering as a business requirements translating functional specs into technical specs to develop the report in the given time lines.
• Extensively worked on LIS and custom extractors to meet the business requirement.
• Ability to manage and interact with small and medium team for development of the report as per business logic and deliveries on time.
• Involved in providing training to the end user for report execution and tool understanding for end user.
• Created Real Time Cubes, Planning sequences, Aggregate levels and Input ready queries for Integrated Planning.
• Developed Sales and Profit Planning Model in BI-IP.
• Involved in Order to Cash backend & frontend development activities in BW area including Pricing Tables.
• Responsible for maintenance of system consistency across the landscape.
• Identifying performance improvement areas to improve the Flexibility, Maintenance of the BI System.
• Involved in Current State Vs Target state system analysis.
• Responsible to meet the SLA to deploy the objects in the production environment.
• Responsible for implementation of security activities in the BW system
• Responsible for End user support to fulfill the requirements.
• Environment: SAP BI 7.0, SAP ABAP, SAP BO 4.0, SAP ABAP, SAP ECC 6.0
• Created New Universes and Modified existing Universes by Interacting with Business Analyst, Data Architect to make more efficient universes and tested them on the reports.
• Created Derived tables on the universe to create customized prompt objects from them.
• Analyzed business model and created BI Architecture plan, created Business Functional Specifications, Functional Design Specifications, and Detailed Design Specifications
• Assisting the client, through analysis of their existing system, challenges, and business needs
• Documented the reporting requirements, dashboard design requirements by thorough interactive sessions with Business users by building prototypes for developing the interactive executive level dashboards.
• Created the objects, which are grouped into classes for convenience in Business Objects Designer. Created custom List Of Values. Used @Aggregate Aware, @Where, @Select, @Variable, @Prompt and @script functions when required
• Defined Access Restrictions in the universe for Confidential, Non Confidential and Highly confidential User groups and applied to the groups defining the priorities for different Access Restrictions. Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure
• Designed the Universe with the ability of adhoc reporting for users
• Handled query performance by created conditions in Universes and optimizing it at the Database level
• Created complex conditions (Dates), Prompts and free hand custom SQL to create Derived tables in universe. Defined logical classes and objects and hierarchies for analysis and drilling on hierarchies in the WEBI reports
• Created supporting WEBI reports for dashboards with multiple data providers and synchronized the data using merge dimension option in BO XIR3.1, and using combined queries to union hierarchical geo-dimensional data and using Chart, Sub-queries.
• Applying Drill Filters, sorts, breaks and multiple Tab reports with charts, crosstabs format, master/detail report.
• Developed View on Demand and Canned reports with Date functions, Drill Filters, Breaks, grouping data, custom sorts Displaying data in Free-standing cells
• The reports are built using Webi Rich Client and exported to CMS and scheduled instances of WEBI reports in Info view
• Built Dashboards with high variation of data using QAAWS, Live Office and BI Web Services.
• Built Dashboards with various functionalities like passing parameters by selecting parameters from drop down list, also passing prompts from dashboard to WEBI reports.
• Created Reports using Crystal Reports.
• Extensive use of drill down capabilities, drill through capabilities, dynamic visibilities, dynamic filtering, scorecard components, containers, combo boxes, list views, complex excel logic, highly formatted excel model with defined naming conventions for design of these complex dashboards
• Resolved Issues like Isolated Joins, Loops, Contexts using Aliases and Contexts where ever appropriate.
• Worked on SQL Querying, Tuning and Optimization of reports.
• Created Self-joins, Complex Joins between tables in the Universe for efficient query performance.
• Worked with Linked universes and created new contexts for them accordingly.

Environment: SAP BI/BW 7.4/7.3/7.4/HANA/APO / SAP ECC / BOBJ 4.1, 3.1/3.0/ XIR2, Web Intelligence 3.0/XI R2, Universe Designer, Analysis Office, Webi Rich Client, Xcelsius 2008, LIS Extractors, Import Wizard, Report Conversion tool, Publishing Wizard, Desktop Intelligence and Business Objects Enterprise Java Infoview, Dashboard Manager, Central Management Server (CMS), Central Management Console (CMC), Central Configuration Manager (CCM),MS Visio, MS Project, CMC.

Confidential

SAP BI/BW DEVELOPER

Responsibilities:

• Involved in managing team to take care of the daily deliverables of BW & BOBJ Implementation.
• Extensively worked on LIS and custom extractors to meet the business requirement.
• Responsible for coordinating with End users to gather the requirements and close the gaps.
• Identified the BW BEx reports & Info providers to build SAP BO reports for Pricing Data.
• Involved in Extraction and enhancement of standard Sales Document Conduction Data sources for pricing.
• Involved in Extraction and enhancement of standard billing Conduction Data sources for pricing.
• Creating Custom Data sources from pricing tables for customer Pricing Procedure.
• Creating custom Data source base on the requirement of the end user and handle delta extraction through info package with ABAP.
• Responsible for TUT Sign off activities.
• Extensively coordinated with the Security teams to design & implement Analysis Authorization for various Reports
• Maintaining Work History for all the tickets until it is closed down.
• Involved in product test by running the test scripts.
• Client Liaison & Documentation, Internal and External presentations.
• Technical mentor to team members.
• Understanding and ensuring implementation of quality standards (QMS)
• Maintaining the queue - related to the system generated tickets and customer generated tickets.
• Design & Development of Workbooks and publishing them as per Business Roles
• Responsible for smooth transition of project from Implementation to Production support team.
• Involved in End user training for BW BEx & BO Queries.
• Involved in meeting SLA for data loads & development.

Environment: SAP BI 7.1/, BEx Analyzer, SAP ECC, SD and MM, ABAP, ISU, BOXI3.1

Confidential

SAP BW Developer

Responsibilities:

• As a technical/functional consultant implemented the SAP BI solution and migration.
• Cross functional analysis, compiling and gathering data.
• Defined work packages and technical specifications for design, development, testing & roll-out.
• Monitored the development of data model to satisfy the various functional requirements by implementing queries and cubes using business content..
• The team configured Custom cubes, Transfer rules, Transfer Structures, Update Rules,
• ODS, Cubes, Aggregates, queries and workbooks.
• Worked with the users for defining the reporting needs and helped design/develop flexible queries and pre-calculated reports using BEX reporting features like variables.
• Involved in requirement gathering for the development of Custom Extractors base on ZTABLES, to meet the requirement Of the end USER.
• Worked extensively on BEx query Designer and Developed flexible queries using navigational attributes in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Enhanced customer exit variables in Reporting and also implemented the ABAP code in CMOD.
• Exception and conditions in Sales and Purchasing areas. Created SAP BI reports which include Plan/Actual revenue comparison, Order and sales value by sales representatives and Vendor delivery efficiency.
• Uploaded master data and transactional data from the source system R/3 and flat file.

Environment: SAP BW 3.x, BI 7.0, BEx Analyzer, SAP ECC, SD, FICO, MM, ABAP.