SUMMARY

• Over 9 years of extensive experience as SAP BOBJ Techno - Functional Consultant with around 7 years of experience in Report Design, Development, Analysis, testing and implementation of various multi complex secure reports from multiple database environments using Crystal Reports, Excel, SQL Server Reporting Services, Oracle,DB2.
• Experience with Crystal enterprise 9.0/10,XI, SAP Business Objects 4.0, XI-R3.1/R2/6.x with Info view, Web Intelligence, Universe Designer, Desktop Intelligence, Crystal Reports 9/10/XI/2008, Xcelsius 4.5/2008, Dashboards 4.0, Central Management Console (CMC), Central Management Server (CMS), Central Configuration Management (CCM), Query as a Web Service, Live Office, BI Web Services, Query Browser, Publishing Wizard, Import Wizard, Report Conversion Tool and Broadcast Agent.
• Worked on various BO environments linking data from multiple sources, applying several functionalities, and using various Data Providers
• Excellent experience in designing Business Objects universes, complex BO reports in both Infoview and Web Intelligence Rich Client.
• Extensively used ETL methodology for Data Extraction, transformations, loading using Data Integrator.
• Extensive experience in creating reports with Charts (bar chart, Pie Chart, chart…etc), Cross-tabs and Subreports and Drill down Reports.
• Experience in Creating Summary and Detail Reports.
• Extensive Experience in Creating Dashboard Reports and Trending Reports for Executive Level data.
• Experience in retrieving data from Business Objects Universe, Personal Data Files, and Stored Procedures.
• Report development using Crystal Reports XI/10.0/9.0,SSRS,SSIS, Oracle, MS T-SQL and Stored Procedures.
• Experience in working with Reports where data has been shared across Subreports.
• Extensively worked on Oracle 10g/9i/8i, SQL Server 2005, SQL Server 2008 database tuning, triggers, stored procedures, data migration.
• Excellent experience in writing and implementation of the Packages, Triggers, Stored Procedures, Functions, Views, Indexes at Database level and Form level using PL/SQL T-SQL.
• Excellent Experience in SQL/PL SQL Query Optimization
• Experience in Scheduling Reports on Crystal Enterprise
• Experience in Crystal Enterprise Administration which includes security based on User Groups, Creating User Groups, Data Sources and managing Folders.
• Experience in Creating, Deploying and Scheduling SSIS Packages.
• Very Good Experience writing queries for Ad-hoc Report Requirements.
• Ability to understand and write SQL and Stored Procedures in Oracle and SQL Server
• Extensive Experience in gathering Requirements from Business Users and Convert those into Technical Specs for Report Design and Development.
• Experience in Documenting Report Specs and Business specs.
• Experience working as an Analyst at times Analysing requirements and translating those requirements between Business Users and report Developers.
• Excellent logical programming skills with a good understanding of business process and software development conceptual life cycle methodologies.
• Ability to Handle Multiple Projects,work independently and also in a team Environment to meet Project Goals and Objectives.

TECHNICAL SKILLS

Reporting Tools: SAP Business Objects 4.0, XI 3.1, R1/R2 6.5.x, Info view, CMC, CCM, CMS, Desktop Intelligence, Web Intelligence, Xcelcius 4.5/2008, Live office, QWAAS, BI Web Services, Crystal Report 9/10/ XI/ 2008, BEx Query, Business View Manager, SAP ECC 6.0, SAP BI/BW 7.0

ERP Packages: SAP ECC 6.0, R/3 4.7, 3.5, 3.1.

Datawarehouse: BI 7.0/7.1, SAP BW 3.5/3.1c/3.0b.

SAP Modules: SD, MM, FI, CO, HR, SCM, CRM, SEM-BPS, BPC, BOFC

Operating Systems: WINDOWS 95/98/2000/ NT 4.0, Unix, DOS 6.22

Databases/RDBMS: Oracle 11g/10g/9.x/8.x/7.x/5.x, MSSQL Server 7.0/2000/2005/2008, Sybase12.0, MS Access and DB2

Languages: C, VBScript, PL/SQL, ASP.NET, VB.NET

GUI: Visual Basic 6.0

Web Technologies: ASP 3.0, Java, JavaScript, VBScript, HTML, IIS 4.0/5.0

Olap Tools: Cognos Power Play 6.0, Data Stage

PROFESSIONAL EXPERIENCE

Confidential, Portsmouth, NH

Business Objects Developer

Responsibilities:

• Interacted with Business Clients and gathered requirements, designed the layout of the project, worked closely with the data architect and worked on development, validating and migrating onto production environment to go live.
• Scheduled Workflows Using Workflow Manager & Workflow Monitor.
• Developed test plans, test cases and conducted Unit testing to check for the expected results.
• Synchronized reports using data from multiple data providers in Web Intelligence 4.0 by merged dimensions functionality.
• Used Derived Tables, @Aggregate Aware, @Index Aware, in the Universe using views to meet the Reporting Requirements.
• Encountered issues in Universe with Chasm Traps, Fan Traps and Loops and resolved the issue by using context or alias table.
• Developed web intelligence reports for different set of requirements in Info view. Worked on merged queries and created new variables in order to obtain calculations for different set of row types.
• Extensively used Calculations, Variables, Breaks, Sorters, Alerts, and Drill Downs for creating Business Objects reports.
• Worked on complex web intelligence reports to create variables using different @functions, @page functions.
• Generated BI Web Services link through Web Intelligence Rich client tool, from the generated web intelligence reports.
• Used BI Web Services links in xcelsius 2008 and used as a web connection to connect web intelligence reports as source data.
• Linked the WSDL links to particular trigger cells and assigned them to the data blocks.
• Developed 3 different dashboards which show the performance of the financial revenue the company generates on the daily basis depending upon the current year, prior year transactions and sales volume for the actual, forecast and projection data.
• Developed dashboards on drill down scale using the accordion menu for filtering deep into the data for particular sectors.
• Created Dashboards for using performance manager to enable and execute track progress and compare current and historical performance against established targets.
• Created single or multi line chart for showing tendency over a period of time particularly used in revenue history using Xcelsius 2008.
• Involved in Maintenance of Business Objects universes and reports, WSDL links and dashboards from Server to Server on the deployment.
• While migrating the dashboards, had to recreate all the WSDL links pointing to production server and re-map them to the data blocks.
• Maintained two same versions of dashboards for production and test environment for better performance of dashboards.
• Involved in enhancing the performance of the slow running reports.
• Deployed Business Objects Universes, Reports and Dashboards in a Secure Environment from One Server to Other Servers using Import Wizard and BIAR files
• Excellent knowledge in analyzing system needs, discuss desired function with upper management, and successfully interchanged programs to meet the needs of the organization and project deadlines.
• Used JIRA for tracking the issues and bugs that surfaces during the development phase.

Environment: SAP Business Intelligence 4.0 suite, Dashboards 4.0, LCM, Query Browser, Crystal Reports 11.5, and 14.0/ 2011, Crystal Reports Enterprise suite 9..0, Oracle 12c, MS-Access, PL/SQL, IBM ISeries, MS SQL Server, JIRA, GIT, Stash, Source Tree, SVN Tortoise, Eclipse, Toad, Jaspersoft Reports, Web Logic, WebSphere, WebServices, SOAP, REST

Confidential, Albany, NY

Business Objects Developer

Responsibilities:

• Interacted with Business Users to determine the requirements and problems with the fully converted reports.
• Involved in Analysis, Development, Testing, and Maintenance and Resolved problems during Migration.
• Provided technical assistance/support to analysts, business users and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
• Created user defined objects including dimensions and measures for complex financial calculations.
• Prepared user documentation for hands on training of end user community and maintained clear documentation on the progress of the project.
• Synchronized reports using data from multiple data providers in Web Intelligence 4.0 by merged dimensions functionality.
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, master/detail, cross tab, charts and alerts for creating Business Objects reports.
• Checked the integrity of the Universe schema for any errors in objects, joins, conditions, loops and cardinalities of the Universe which were causing the reports to be partially converted.
• Enhanced reports which included standardizing format of report content, redefining query filters and prompts, linking summary report to a set of detail reports.
• Used @Functions such as @Prompt to restrict return values and to enter prompt, @Select- to reuse the select statement of another object, @Variable- to restrict the currently logged user etc.
• Migrated Universes/Reports from Development to Test environment and finally into Production environment after UAT (User Acceptance Testing) using LCM.
• Scheduled the Web Intelligence reports using the CMC by creating event based triggers.
• Used Query Browser connections in Dashboards 4. 0 as source data.
• Linked the WSDL links to particular trigger cells and assigned them to the data blocks.
• Worked on mobile dashboards for BI 4.0 using HTML 5, and SAP app on iPad
• Created components compatible only on mobile for the mobile version.
• Developed dashboards which show the performance of the financial revenue the company generates on the daily basis depending upon the current year, prior year for different set of top 25 clients.
• Developed dashboards on drill down scale using the accordion menu for filtering deep into the data for particular sectors.
• Involved in Maintenance of Business Objects universes and reports, WSDL links and dashboards from Server to Server on the deployment.
• Use of JIRA for tracking the issues and bugs that surfaces during the development phase.

Environment: Crystal Reports 11.5, and 14.0/ 2011, Crystal Reports Enterprise suite 9..0, Business Objects Suite 4.1,5.1, DB2, Oracle 11g, MS-Access, PL/SQL, IBM ISeries, MS SQL Server, JIRA, JAMA, ACCELA

Confidential, IL

Business Objects Developer

Responsibilities:

• Acquired a key role in the project to make it go live as promised.
• Involved in Gathering business requirements to create functional specification and technical specifications in turn developing various types of reports according to the business.
• Worked on Business Objects XI 3.1, built universes and created prompts using cascading prompts, developed various filters for current year transactions, projections and forecast of the financial data for different set of filters as, previous completed 3 months, current year, current month and as of today.
• Used Derived Tables, @Aggregate Aware, @Index Aware, in the Universe using views to meet the Reporting Requirements.
• Encountered issues in Universe with Chasm Traps, Fan Traps and Loops and resolved the issue by using context or alias table.
• Developed web intelligence reports for different set of requirements in Info view. Worked on merged queries and created new variables in order to obtain calculations for different set of row types.
• Extensively used Calculations, Variables, Breaks, Sorters, Alerts, and Drill Downs for creating Business Objects reports.
• Worked on complex web intelligence reports to create variables using different @functions, @page functions.
• Generated BI Web Services link through Web Intelligence Rich client tool, from the generated web intelligence reports.
• Lead a team of 3 reports developer.
• Assign the reports to team through ZETRACK software.
• Designed various types of reports, Accounting, Purchase, Exceptions, Promotions, Buy and Hold, Store, Vendor etc.
• Creating reports for daily, weekly and monthly analysis.
• Publishing and Scheduled reports Taking decision whether it should be on demand or scheduled.
• Involved in Re-designing existing reports.
• Developed various reports included sub reports, cross-tabs, standard reports.
• Involved in writing the stored procedures and improving the performance of some procedures to make the reports run faster.
• Involved in Performance tuning of the existing SQL.
• Developed reports with formulas and running totals for weekly and monthly utilities collections.
• Have done Report Validation for the generated reports to test and sent it to the production.
• Used PVCS to extract the reports to modify (check-in and check-out process).

Environment: Crystal Reports 11.5, and 14.0/ 2011, Crystal Reports Enterprise suite 9..0, Business Objects Suite 4.1,5.1, DB2, Oracle 11g, MS-Access, PL/SQL, IBM ISeries, TOAD, DB Visualizer 7.0.4.

Confidential, Atlanta, GA

Crystal Report Developer

Responsibilities:

• Designed various types of reports with Complex Formulas, Custom Functions, SQL Expressions, Parameters, Drill Down and Sub Reports
• Designed reports and Cross Tab Reports. Used complex formulas and functions in the reports. Also designed the reports with multi level of groupings
• Designed reports with Conditional formatting, Sorting and Running Totals Enhancing existing reports by adding computed columns
• Creating reports for daily, weekly and monthly analysis.
• Designed reports with linking sub reports to a master report, underlay formatting, and passing data between reports and integrated the report with hyperlink.
• Designed the Scheduled reports based on conditions and designed report with Alerts and Parameters Designed report with Group, Group by intervals, Groups selection and Hierarchical Grouping and Summary Group report
• Exported reports into various formats like EXCEL, PDF, HTML, and WORD for the user
• Designed Report Templates
• Published and scheduled reports in Crystal Enterprise 8.5 using Crystal Management
• Console and Crystal Publishing Wizard
• Created changes in the database according to the new requirements.
• Automated the Productions and Management reports and provided numerical consistency through Drill Down and multiple groupings.
• Interaction with the DBA and other team members on the regular basis to provide good output to the different departments.
• Developed Complex Financial reports using Stored Procedures and Sql Queries.
• Developed Transactional & Budget reports for financial team to post into General Ledger
• Enhanced DND Daily Activity report to get an additional Balance Pool for the Existing report
• In order to generate the Reconciliation data, modified SRR Weekly & Monthly Report’s

Environment: Crystal Reports XI R2, Crystal Reports Enterprise suite 9..0, Business Objects Suite 4.1,5.1, SQL Server 2005, Oracle 10g, MS-Access, SQL *Plus, TOAD, PL/SQL.

Confidential, San Diego, CA

Crystal Report Developer

Responsibilities:

• Involved in gathering Business requirements and standardization of reports. Developed several Complex Reports (include multiple groupings, drilldowns, parameter fields, formulas and retrieving data from more than one database) using Crystal Reports.
• Worked on complex reports that require running totals, sub-totals, sub-reports, cross-tab, multiple groups and conditional display of groups, fields and messages.
• Created various reports like the Combined Queries, Drill Down and Master Detail for easy analysis of reports.
• Involved in the operations for migrating legacy data from old system to Oracle database.
• Designed views and stored procedures using PL/SQL for quicker access.
• Created design for running multi flavor reports like - Date, Weekly and monthly as well.
• Wrote formulas and created parameters Fields and conditions depending upon selection criteria.
• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc by using Chart expert of Crystal Reports 10 for different reports.
• Involved integration of reporting portal with the company Intranet. Involved in creating the custom web pages using HTML, JavaScript.
• Developed and Deployed reports for Data Analysis.
• Involved in displaying data from legacy systems and relational databases and also in creating, modifying reports using tables, views, functions and stored procedures.
• Created and Tuned complex Stored Procedures for faster execution.
• Provided guidance/training to Application Users.

Environment: Crystal Reports 9.0, Crystal Reports Enterprise suite 9..0, Business Objects Suite 4.1,5.1, SQL Server 2005, Oracle 9i, MS-Access, TOAD, PL/SQL.

Confidential, San Jose, CA

Business Objects Developer

Responsibilities:

• Worked with customer service based group and involved in modifying existing Universe and created various canned and ad-hoc reports
• Involved in gathering end-user requirements to modify and create reports.
• Exporting & importing universes across different domains
• Created standard and ad-hoc reports and published the standard reports on to the repository.
• Used business objects functionalities like break, sort, alerter, filter and condition.
• Used aggregate awareness in universe to tune the performance
• Linked different data providers and used sub queries in reports
• Published and scheduled Business Objects Reports to users using CMC.
• Developed complex reports using @Functions like @Prompt (for user defined queries), @Where (for creating conditional filters), @Select and Cross Tab tables
• Analyzed reports using Slice and Dice, Drill down and Master Detail
• Worked with the customers to resolve various issues associated with the reports.
• Worked on various reports which involved developing and exporting reports to PDF, EXCEL and HTML format based on the end user requirements.
• Managed Reports From SQL Server Report Manager

Environment: Oracle8i, MS Sqlserver2000, Ms Access, Windows 2000,Visual Basic 6.0, ASP.NET, Crystal Reports 8.5 and Crystal Enterprise 8.5, SQL, PL/SQL

Confidential, OH

SAP BW Consultant

Responsibilities:

• Involved in the Data Modeling process for Sales Arena by identifying Characteristics for dimension tables and Key figures for the Fact Table and defined the display and navigational attributes for the BW Extended Star Schema.
• Maintained extract structures for Purchasing, Inventory and Sales & Distribution. Generated data sources & activated the extract structures for the above modules. Scheduled data uploads in cockpit.
• Designed and developed custom ODS objects, Info Cubes for Inventory data and activated Update rules for these data targets.
• Responsible for job schedules for loading Master data (Texts, Attributes and Hierarchies) for Materials and Sales arenas.
• Extracted the data using logistics from Sales and Billing Data Sources to populate the Custom Info Cubes that evaluates quantities and values for sales orders, deliveries and returns, and invoices.
• Worked on Inventory cubes for business content DS. Analyzed the requirements to implement Snapshot scenario for cumulative key figures. Worked on 2LIS 03 BX and 2LIS 03 BF Data Sources.
• Statistical Data upload to LIS info structures S260, S261, S262 & S263 for S&D module within SAP R/3 OLTP.
• Created Info Packages with Full Loads, Delta loads, Initialization with/without data transfer etc. Tested the data loadings, delta loads and verified data with R/3 side.
• Worked on creating start routines and end routines in update rules to ensure proper loading of data.
• Created Purchase order control report, this report will show the statuses of Purchase orders and Sales orders in particular the third party purchase orders and sales orders.
• Developed an interactive report to list the purchase orders details for a vendor that has interactive drill down options to give the details of vendor from vendor master.
• Designed making extensive use of the ODS capabilities, delta management functionality and optimal use of update rules keeping query performance in view.
• Extensively worked on Info Cube maintenance like Compression and Roll- ups.
• Worked on BEx Query Designer in designing queries using filters, variables, navigational attributes and structures to facilitate flexible, detailed drill down data analysis to required level of information.
• Extensively involved in production support issues involving data loading, monitoring, and batch issues.

Environment: BW 3.5, SAP ECC6.0, FI, SD, MM, SRM, APO, and Data Stage

Confidential, Fremont, CA.

SAP BW Consultant

Responsibilities:

• Customized/designed Data Flow right From R/3 to BW and further and Migrated data sources from BW 3.5 to BI 7.0
• Extensively Worked in R/3 Extraction of Financial, Co-PA and Logistics( Sales & Distribution), LO-Cockpit Extraction and customized extractors
• Extensively Worked in Moving Data from One BW system to another using Info-spokes and Open- Hub services
• Involved in the scheduling and monitoring of info packages to load data from R/3 and flat files
• Involved in creation of Data Sources, Info Sources and PSA for Data Extraction, Transformation and Loading from SAP R/3 system to SAP BW
• Designed custom ODS for the material movements, custom Sales order Info cube, created Multi-cube based on delivery and defined transfer rules and update rules and designed loading strategies
• Used Cell-Definitions, Structures, Exceptions, Conditions, and various User Exits in the Reports developed
• Involved in setting up roles, profiles and authorization objects and developed BEX XLS Queries and Workbooks by which BW data analyzed through navigation
• Used Restricted and Calculated Key Figures, Formula Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer
• Developed front-end queries using Query Designer and Web Application Designer (WAD) and publishing results on the web

Environment: SAP ECC 6.0, SAP CRM 5.0, SAP BW 3.5, APO, SCM, CO-PA, FI, SD, QM, BEx Analyzer, Query Designer, Web Application Designer

Confidential, Avon Lake, OH.

SAP BW Consultant

Responsibilities:

• Customized/designed Data Flow right From R/3 to BW and further and Migrated data sources from BW 3.5 to BI 7.0
• Conducted Gap analysis of the Data warehouse, assessed existing reports, and interacted with various business analysts to come up with good global designs for BW implementation.
• Involved in the design and development of Profitability Analysis (PA) Cube in Controlling (CO) and Profit Center Accounting (PCA) as part of SAP FICO BW implementation
• Created data sources using generic and application specific extraction (LIS) for SD and MM modules and loaded the business content
• Created different Reports in MM, SD, FI module such as product stock value available based on the product type, Best-selling products, Billed selling orders based on territory etc.
• Worked with FI Cubes to enhance the performance (Modeling, Data load) from other systems and did currency conversions for Country specific
• Activated and Customized profit center accounting, accounts payable cubes accounts receivable cubes and extracted Line Item data from GL (General ledger), AR (Account Receivables) and AP (Account payables).
• Developed BW reports using BEx Analyzer, created queries with Variables, restricted key figures, calculated key figures, conditions, exceptions etc.
• Used RRI feature to jump between the Queries to analyze the data efficiently
• Good understanding on Performance Improvements in areas like Change Run, Aggregate analysis, Compression techniques, Query Parallel processing
• Extensively used BEx analyzer, created queries with variables, filters. Used RRI feature to jump between the queries to analyze the data

Environment: SAP BW 3.5, SAP ECC 6.0, SD, MM.