PROFESSIONAL SUMMARY:

• Having more than 8Yrs Experience in SAP BI/BO/HANA Consultant. Extensive knowledge in BI with Two full life cycle implementations, extensively worked on SAP - BW 3.5, SAP BI 7.3 & Business Objects 4.1. Effective team player and ability to learn and work in changing environment.
• SAP Business Objects 3.1 environment and knowledge on SAP BO 4.0, including End-to-End BO Implementation.
• Finance & Controlling - Vendor & Customer creation and invoice positing
• ABAP Internal Tables, Data Dictionary
• BO- Universe, IDT, Web Intelligence reporting.
• Experience in Business Objects Suite (XI/XIR2/XI3.1), Universe Design Tool(UDT),Information Design Tool(IDT), Deski, Webi, Webi - Rich client, and Import wizard.
• Experience in creating user profile and mapping user groups.
• Experience in developing, modifying and maintaining universes.
• Experience in Creating new Classes and Objects in the Universe based on Functional Specifications.
• Experience in creating Universes, resolving Loops, Traps and Testing the Universe.
• Experience in creating Derived Tables according to end user requirements.
• Experience in migrating Business Objects reports from XI 3.1 to XI 4.0 Version.
• Experience in changing Deski reports to Webi using report conversion tool.
• Experience in Developing Reports and Customizing reports using Alerts, Breaks, and Filters and Sorts etc.
• Experience in Developing various Charts, Graphs and drill down reports.
• Experience in creating reports using Web Intelligence, schedule the reports as per the business needs and supporting.
• Experience in Creating Crystal Reports XI/XIR2/2008.
• Experience in Creating Charts with Value-based alerts and setting up Drill down in charts using Crystal Celsius.
• Responsible for storing the information in various types of structures (e.g. Data Store Objects, InfoObjects and multidimensional structures called Info Cubes ).
• Experience in Data-Modeling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring.
• Expertise in design and development of Info Objects, DSO, Info Cubes, Multi Providers, Info Sources, Info Package, Transfer/Update rules, Communication Structure, Transformations, DTP.
• Data extraction from R/3 Systems and Flat file structures.
• Creation, Modification of the BEx Reports and Queries depending on end-user requirements.
• Involved in Migration of Data sources from BW 3.X to BI 7.X
• Maintenance and creation of SAP BI objects as per client requirements.
• Followed major organization standards to implement SAP Projects and ASAP Methodology where to give full satisfaction and support to clients.
• Creating universe and schemas, Report Generation etc. in BO(Business Objects4.0

TECHNICAL SKILLS:

Data Warehouse: SAP BI 7, 3.0B, 3.1C, 3.5, Informatica(ETL), HANA, BO

DataBase: Oracle, mySql, Ms-SQL

Languages: C, C++, Java, ABAP

ERP: SAP R/3 4.6C, 4.7, ECC, FICO

Operating System: Windows 9x/NT, Windows 2000, Windows XP & MS-DOS

PROFESSIONAL PROFILE:

SAP BI Consultant

Confidential, Atlanta, GA

Environment: SAP R/3(ECC6.0), SAP BI 7.0

Responsibilities:

• Handled the tickets of priority P1, P2 and P3 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.
• Involved in performing Production Support activities like Ticket Analysis report.
• Resource Utilization Report, Time sheet maintenance of the support team.
• Maintain list of all the activities for all the tickets until it is closed down.
• Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Monitoring of info packages and analyzing the reasons for frequent failures of info packages.
• Maintaining Reconciliation’s to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
• Maintaining the queue - related to the system generated tickets and customer generated tickets.

SAP BI Consultant

Confidential, Atlanta, GA

Environment: SAP BI 7.0, SAP R/3 ECC 6.0

Responsibilities:

• Enhancing the Data sources on R/3 Side which we have used in the LO Customizing Cockpit.
• Activation & Installation of Business Content Objects.
• Developed Master Data & Transactional Data as per the requirements.
• Creation of Custom Infocubes & DSO’s.
• Generated Reports by using Structures, Selections, Restrictions, Characteristic Filters, and Free Characteristics.
• Created aggregates and compressed info cubes for increasing the query response.
• Involved in creation of Info objects, Info cubes, data sources, info packages, DSO’s, etc. to load master data and transactional data as per the client’s requirements.
• Used Generic extraction to extract data from SAP R3 to BW.

SAP BW Developer

Confidential, Atlanta, GA

Environment: SAP BW 3.1, ABAP 4.6C, Windows NT, Business Explorer.

Responsibilities:

• Gathered information from end user based on their needs. Development of BW objects (Info Objects, Info Cubes, Data Sources, Info Sources) and responsible for data loading (Master Data and Transaction Data).
• Uploaded Master and Transactional data from flat files and SAP as the OLTP source. Worked on exporting of BW objects (Object Transport) to quality assurance and then to the production environment.
• Created Process Chains for the data loads and to automate it and optimized the process chains by dividing processes chains into level1 and level2 process chains in order to optimize the scheduling and loads in BW.
• Responsible for customizing and activation the Business Content Objects and Loading the data into ODS Object and Info Cubes. Scheduled Extract Jobs, Grouping of extract Jobs, Monitoring of Transfer and Update rules for data Loads, Monitoring of Status display and Load Statistics for Update Process.
• Worked on enhancing business content as per the requirement. Created Aggregates to Improve query performance. Extensively worked on standard and custom defined LIS and LO extractors. Extensively worked on BEx Browser, BEx Analyzer and Info set queries.

SAP BW Developer

Confidential, Valencia, CA

Environment: SAP BW 3.1, SAP R/3 4.7, Cognos 8.2/Impromptu, Powerplay 7, ReportNet MR 2, Windows NT, SQL Server.

Responsibilities:

• Gathered the requirements from End Users. Finalized all the reports that need to be developed in BI based on the existing reports in third party systems. Created no of conversion routines to fill the gaps like, routine to convert basic units of measure.
• Development of authorization plan based on user requirements and business requirements.
• Created Open Hub, Process Chains to automate the data load and data target administration. Worked with basis and system admin teams to define specifications for frequency and mode of data transfers and setup of batch jobs.
• Performed Logistics data Extraction using LO Cockpit. Extracted data for various Controlling - Cost Center Accounting, actual Line Items and commitment Line Items from R/3 to BI. Created CO-PA and Generic data sources.
• Schedule and performance monitor periodic data loads from SAP R/3 to BI.
• Working on complex Business Intelligence Reports using Cognos Report studio and Analysis Studio. Working on Cube data’s and developing many cross tab reports by using various MDX functions like Tuple, Children, Memberset and experienced in Query joining.
• Working on Management Reports for decision-making purpose. Creating many Cubes depends on the Reporting needs. Interacted with Business users and collected business information and their requirements for developing different type’s reports using Report Studio.
• Created Powerplay Models and Cubes using Transformer. Built Dimension Maps based on customer requirements for different cubes. Designed Multi Dimensional Cognos Power Play Cubes and reports. Configuring SAP GUI and Cognos Connection for reporting on Infoobjects, Infocubes and Queries
• Reporting on Infocubes from different Functional areas of BW combining data from multiple datasources. Using the BW Business Rules such as Security (roles), Query variables, Calculated Key figures, Structures into Cognos 8.
• Using Cognos 8 tools (Query Studio, Report studio, Analysis Studio, Metric studio, Event studio) for enhanced, customized and formatted reporting as per the end user requirements.
• Implementing multiple security levels in Cognos. Created and published packages in Framework Manager from various sources in ReportNet. Generated different kind of reports in Report Studio; created templates and multilingual reports.

BI/BO Report Developer

Confidential, Valencia, CA

Environment: Bex Reporting, Web Reporting, Report designer BI 7.O, Information Broad casting, Visual composer, Cognos 8i

Responsibilities:

• Created various Complex reports for billing cycle application.
• Created various 3D pie charts, Pie charts, Bar Charts, Line Charts.
• Used drill analysis in Business Objects which will allow the user to view data at a more detail level, than current level.
• Generated drill down reports using Business Objects at zone level, product level, borrower level.
• Created and use the variables on existing objects to customize the Business Objects reports.
• Extensively worked with alerts, filters and conditions in Business Objects.
• Created Master Detail, Cross Tab reports to view the data in analyzed way.
• Created templates to generate different styles of reports, which are not, belong to Business Objects standard documents.
• Created calculated data items, filters and prompts in universes to maintain the consistency in the reports created by other developers

SAP BI/BW BO Consultant

Confidential, Atlanta, GA

Environment: SAP BI 7, Business Objects Web Intelligence, Xcelsius, Crystal Reports, Data Integrator, and Windows NT.

Responsibilities:

• Implemented Technical design and Development for Production & Prices functional area. Created BEx queries to simulate/validate results achieved from Web Intelligence reports. Architected the Re-org of BW objects to maintain standards.
• Reconciled Inventory and purchasing data from BW to R/3 for existing Production reports. Created Info objects, DSO’s, and Cubes & Multi providers as per the data model. Defined several transformations as per the need.
• Assisted in configuring BO Data Integrator as a Source system and also used it to send transformed data from Oracle to BW. Created generic extractor to combine R/3 data into BW. Enhanced the extractor for Inventory Management and Purchasing under SCM project.
• Interacted with the SCM Business Users on a daily basis for their KPI & report requirements. Defined best practices on BW and BO data services integration. Data was transformed in both BW and BO Data Services. Managed, Configured and Performed Transports between multiple BW environments.
• Used Real Tech Transport Manager to perform transports. Leveraging existing function modules (Time (UTC) conversion, Master Data lookup etc.) for various transformations.
• Designed technical implementation of Timezone implementation for reporting over different timezones (MST, PST, EST, and CST). Maintained Ztables in BW to load Master data. Performed BW Master and transaction data loads on required basis.
• Created and scheduled Process chain for daily Delta loads. Troubleshooting data and technical issues related to SAP BW. Managed Client BW environment to co-ordinate development, testing and transports to Production.

SAP BOBJ/BW HANA Consultant

Confidential, Philadelphia, PA

Environment: SAP BW 7.3, Design Studio 1.1&1.2, Business Objects 4.0 Web Intelligence, Data Integrator, and Windows NT.

Responsibilities:

• HANA and Business Objects Development done across all the business Areas for the BI Projects: Developed all Technical Specifications based on Functional Specifications that outlines required Characteristics, Measures and Business Rules. The Technical Specification outlined the overall HANA design to meet and satisfy the Business Reporting Requirements.
• Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL Script to Join/Union the various Attribute and Analytic Views for report consumption with time dimensions.
• Developed data flows and work flow using BODS. Worked on RDS to implement ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL transformation.
• Setup Table Replication SLT for ECC and 3rd party table's real time into Hana. Data replication enhancements created for custom fields when required during replication.
• Using data provisioning methods like SAP SLT for real time data and Business Object Data Services BODS non sap data Flat file upload and direct extraction connection DXC to acquire the data into SAP HANA Data Mart.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool .
• Develop SQL scripts and functions for complex reusable scenarios in HANA.
• Consumption of HANA information Models in BW by creating Composite and Transient Providers.
• Developed multi-data source challenging reports by merging data from multiple Data Sources using Web Intelligence WEBI .
• Designed Web Reports Using Be Queries BICS Connection .
• Designed developed cross tab reports, reports with sub reports linked unlinked and charts using Crystal Reports.
• Had created reports using SAP BO Analysis Office 1.3 and 1.4 for multidimensional ad-hoc analysis of Headcount Analytics data from SAP BW and HANA in Excel.
• Reports Developed in this Project: Headcount Change in Staffing Level, Human Capital Management Monitor, Leaving Rate, Percentage Distribution of Leavers, Vendor spend analysis
• Worked with LCM Life Cycle Management Console to Transport the Objects In System Landscape Dev, QA and Prod
• Involved in developing and conducting extensive Unit testing, Integration testing FIT, Regression testing, User Acceptance Testing UAT and documentation.