SUMMARY

• Over 6 years of experience in Information Technology with strong work experience asSAP BO Developer and SQL Developer.
• Extensive experience in Business Intelligence tools like Web Intelligence, Crystal Reports, SAP Lumira, Xcelsius dashboards, BO Universe, BEx query designer, BEx Analyzer, BO Explorer.
• Developed and Maintained Complex Web Intelligence Reports that involve Charts, drill down analysis, open document links, Input Controls, Report filters, Prompts, Element linking, Merge dimensions, Ranking, Breaks and Complex Variables that involve Context Functions.
• Expert in Writing Crystal Reports of Types Table based, SQL Command based, and Sub Reports in a Complex Reporting landscape.
• Well Versed in Writing SQL Queries, Stored Procedures, Database Views and UDF in SQL Server 2008 databases.
• Involved in developing stored procedures, triggers for the applications.
• Expertise in developing Dashboards using Xcelsius with QaaWs, Universe and SAP BEx query as a datasource.
• Using BO IDT 4.1, Developed and Maintained Single Source and Multi - Source Universes against Non-SAP systems like Siebel, oracle database, and MS SQL Server.
• Extensively used various features like Joins, Alias, Derived Tables, Index Awareness, Custom Lovs, Prompts, Row Level Security, Hierarchies, and Contexts in IDT in developing BO Universes.
• Excellent data-analysis skills and ability to translate specifications into a Dashboard using SAP Lumira, BO Explorer and Tableau.
• Very good understanding of Data Warehousing Design Methodology,Data Warehouse Concepts, Database design/architectureincluding bothOLAP & OLTP data.
• Experience in Business Requirement Gathering and preparing the Functional and Technical Specification documents.
• Provided Training to End Users on how to create and use the Web Intelligence Reports.
• Experience in Working in an Agile Methodology Environment and Effectively Meet The Project Deadlines.
• Possess excellent communication, decision-making, Problem Solving, Analytical, and Interpersonal skills with result-oriented dedication towards Project goals.

TECHNICAL SKILLS

Reporting Tool: Business Objects XI R3/R2, SAP Business Objects 4.0 & 4.1, Information Design Tool (IDT), Universe Design Tool (UDT), BI Launch Pad, Crystal Reports, Lumira, Web IntelligenceDashboards, BEx.

ERP: SAP R/3 ECC 6.0

Database: SQL Server 7.0, Oracle 11g, HANA SP9, Redshift

Query Tools: SQL*PLUS, SQL Workbench

PROFESSIONAL EXPERIENCE

Confidential, Lexington, KY

SAP BO Developer

Responsibilities:

• Responsible to provide production support to the defects logged by the Business users on a daily basis and provide resolution to the issue within the due date.
• Developed and maintained various Web Intelligence, Crystal, Dashboard and BEx reports on top of various source systems like SAP ECC, CRM, CC, CI, HANA, SAP BW and Siebel Applications.
• Developed highly interactive Executive BO Dashboards to view the open monthly invoices, Invoice Lead Time, Customer P&L, Open Orders Monitoring, Data quality Scorecards and Customer setup Dashboards.
• Extensively used QaaWS connectivity, SAP BEx queries in developing complex dashboards to measure business metrics to monitor day-to-day activities.
• Created and maintained several Web Intelligence and Crystal reports to support Asset management, Billing Management, Consumables Management and Vendor management business areas.
• Developed Web Intelligence Reports, which involved Complex Calculations, Variables, Drill down, Alerts, open document links, Element linking, Input controls, Cascading Prompts and charts.
• Developed reports by using Merge dimension in Web Intelligence to consolidate data from BEx query and relational Universe.
• Responsible for creating the complex Crystal Reports (Sub Reports, Drill-Down, Summary Field, Group Expert, Cross-Tab, Select Expert, Charts, Section Expert, Alerts).
• Developed and maintained many Crystal reports by writing complex SQL scripts in the command object, stored procedures and materialized views.
• Extracted, compiled and tracked data and analysed data to generate reports using tools SAP Lumira, tableau and Web Intelligence.
• Developed the Single source and multi-source universe using BI 4.1 Information design Tool.
• Worked with database connections, SQL joins Cardinalities, Short cut joins, Loops, Aliases, Views, Aggregate conditions, Index Awareness, Row level Security, parsing of objects, derived tables and Hierarchies in building universes.
• Extensively worked in designing the business layer, data foundation layer, prompts, list of values and hierarchies in developing BO Universes.
• Responsible to manage the Reporting Database by activities such as adding, altering or removing fields from tables, Views. Creating Materialized views, stored procedures triggers and UDF.
• Worked as a Core Team member to assist any Reporting issues or Requirements from the business users.

Environment: SAP BO 4.0/4.1, Siebel, SAP ECC 6.0, SAP BODS 14.2, AWS Redshift, Oracle 11g and HANA SP9.

Confidential, Wilmington, DE

BO Developer

Responsibilities:

• Developed and maintained complex reports using Business Objects Web Intelligence Rich Client & Crystal Reports for Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
• Created (Master/Detail, Cross tab, Chart templates) reports using Crystal Reports.
• Developed Scorecards in BO Dashboard to monitor the Order monitoring process.
• Developed Universes (.UNV) on top of oracle database to develop BO dashboards.
• Developed complex crystal reports using Business Views, table based SQL command objects, materialized views and stored procedures.
• Tuned and Enhanced Existing Reports or SQL Queries for the Report Performance and based on project requirements.
• Created many test cases and test scenarios for Unit testing, Integration testing of many BI reports.
• Planned the cut over activities before go live and performed the downtime activities.
• Investigate & resolve defects identified during testing or in production support.

Environment: Oracle 10G,SAP BOXI 3.1/SAP BOBJ 4.0/4.1, Web Intelligence, Info view, Crystal Reports, Publication Wizard, Import Wizard, Information Design Tool (IDT),Windows 2003 advanced server, Lotus Notes & Remedy ticket system.

Confidential

BO Report Developer

Responsibilities:

• Involved in report requirement gathering.
• Designed and maintained Universes and exported them to repository.
• Created Classes and Objects in the Universe.
• Created reports using standard company templates and few reports based on the requirements.
• Developed complex reports using multiple data providers, Union, Intersection, minus and master/detail.
• Involved in developing cross tab reports and sub reports in crystal reporting.
• Developed various charts and graphs like Bar chart, line graphs, Pie chart using chart expert in crystal reporting.
• Involved in user training.
• Created detailed Step-by-Step documentation.

Environment: SAP Business Objects XI R2, Crystal Report, MS SQL Server 2008, Windows 2000 Server.

Confidential

SQL Developer/ BO Consultant

Responsibilities:

• Designed Data Model and Implementing changes in the earlier phase of the project to meet the deadlines.
• Developed database objects such as SSIS packages, Tables, Triggers and Indexes using SQL Analyzer and Enterprise Manager.
• Responsible for writing the SQL queries for the data validation and testing the reports.
• Created Web Intelligence, Crystal reports and Lumira reports from various data sources.
• Created Web Intelligence reports with multiple data providers and synchronized the data using Merge Dimensions.
• Worked on Universe, Joining the Tables, parsing the Objects, Create Prompts and queries, apply Contexts and Alias Tables to remove cyclic dependencies.
• Performed extensive unit testing in the development environment for all the objects created.
• Interacted with the End Users, Business Analysts and responsible for Involved in training sessions to impart knowledge on designed universe and published reports.

Environment: SAP Business Objects XI R2, Audit, Crystal Report, Oracle Database, PL/SQL, SQL scripting and Windows 2000 server.