SUMMARY:

• 10+ years of Extensive experience in working with QRA/DSS tools and Business Intelligence (BI) Applications using Business Objects Product Suite.
• Experience in Designing Universes and development of reports both in Fat client as well as in Web Intelligence.
• Working experience with Business Objects modules such as Desktop Intelligence, Designer, Supervisor, Web Intelligence, Crystal Reports, and Broadcast Agent on UNIX and Windows platforms.
• Good Knowledge of Data Modeling extensively worked with relational data models OLTP/OLAP data models, Dimensional Data Modeling i.e. Star schema (ROLAP) and snow flake schema.
• Involved in release management and Complete Development life cycle of document from developing contents to moving them across multiple environments using Import wizard.
• Experience in using BO Data Integrator with HANA for ETL purpose using Business rules provided by clients.
• Involved in installation and deployment, upgrades, maintenance, clustering, and administrating the complete suite of SAP Business Objects tools in shared environment.
• Involved in Maintenance of repository, connections, Report Publishing, Scheduling, Monitoring, Users and Groups.
• Involved in migration from older versions to newer once using import wizard, also involved in report conversion using RCT from deski to webi.
• Experience in designing and implementing ETL process, Transformation Mappings and loading using Informatica 7.X/8.X./9.X.
• Good presentation, summarization, structuring and refinement skills. Proven track record of execution capabilities for strategic as well as tactical plans, both within and through functional boundaries.
• Designed executive level dashboards using QlikView 9.x, 10.x,11.x / Crystal Xcelsius/Tableau.
• Involved in User training, mentoring colleagues and coordinating with development teams.
• Strong verbal and written communication skills, also ability to work towards success of the project in fast paced tough environments.

TECHNICAL SKILLS:

Tools: SAP Business Objects 4.0, XI R3/R2/6.5 (Supervisor, Designer and Reporter), WEBI /DESKI /Rich client, Crystal Reports /SAP Crystal Report 2008/2011/2013/2016, Crystal Xcelsius, Live Office, Broadcast Agent Server (scheduler & publisher), Dashboard Manager, Informatica,SSIS,BODI 3.2, ORACLE,DB2,SQLSEVER

PROFESSIONAL EXPERIENCE:

Confidential

Lead SAP BI Developer/Accela Report Developer

• Designed and developed reports using SAP Crystal Reports.
• Created Crystal Reports using Crystal Reports using formulas, Grouping, Parameters, Selection criteria to handle the customer's requests from Tables, Stored Procedures, Views and Command Objects.
• Developed various charts and graphs like Bar chart (side - by-side, stacked), line graphs, Gantt Chart etc by using Chart Expert using Crystal Reports 2008/2016.
• Used new features of Crystal Report 2016 like Vertical Alignment and GetValueDescription() to show parameter value descriptions, Conditional formatting for line and Box properties, etc.
• Use of CMC to manage to upload report and control access for the users by applying security restriction.
• Used Central Management Console for deploying and managing the reports.
• Responsible for giving user access and setting restrictions to view the reports.
• Handle both dependent and stand-alone sub reports.
• Set filters, suppression formulae and used highlighting expert to show the data the users would like to see in a more concise and presentable format.
• Write several SQL and PL/SQL queries on both Oracle 11g and SQL Server 2012.
• Worked on WEBI Reports using IDT and UDT as semantic layer for canned and ad hoc reports.
• Created Requirement Specification document by interacting with business through questionnaire, JAD session etc.
• Work closely with business to get the requirement and provide them a mock report/dashboard.
• Created SQL commands, Views, Stored procedures and OLAP cubes as needed.
• SQL optimization to improve run time performance of reports using Hint and explain plan techniques.
• Created Adhoc Reports using Accela Tool.
• Used Accela Schema to create reports for DPL and ABCC, DCAMM, DLS reports.
• Work as Tire2 Support to fix and validate defects in Production.
• Work with EMSE Scripting for writing and debugging code for Batch jobs and updating configuration per the requirements.
• Work with Page Flow script and Expression Builder to Validate and run the test case.
• Used JIRA to update the Task assignment and status of the tasks.
• Used SVN to maintain version management.
• Worked on AWS Architecture (VPC,EC2,NAT,Security Groups etc.)

Environment: Crystal Reports 2008/2016, SAP Business Objects XI R 3.1 & SAP Business Objects 4.1, Accela, Oracle 11g, and JIRA.

Confidential,Wilton,CT

SAP BI Developer/SAP Crystal Report Developer

• Involved in migrating SAP Business Objects XI 3.1 to 4.1 using Upgrade Management Tool (UMT) with incremental approach.
• Replicating Actuate reports in SAP BO using Webi and Crystal report 2013.
• Used Crystal Report 2013 to develop reports for different clients by using Highlights experts, Select Expert, Record Select, sub reports, static and dynamic parameters.
• Improve the performance of existing crystal report using Perform Grouping on Server, Report Bursting Index etc on the report level and use indexes and hints techniques on the database level.
• Used Business View Manager (BVM) for centralizing LOVs using Dynamic Cascading prompts and LOVs (List of Values) in Crystal Report 2013.
• Created Data Mart Universe for Invoicing project resolve chasm trap and fan trap in the universe by defining context and Alias and created complex objects using case and decode scripts.
• Use Promotion Management Tool to move reports from DEV to QA and from QA to Prod environments by creating jobs.
• I am working on the Code Migrations to different environments (From DEV to QA,From QA to UAT and From UAT to PROD).
• Worked with Actuate and decode the reports for SAP BO 4.1.
• Worked closely with DBA to write the complex business logic SQL for invoice reporting.
• Designed executive level dashboards using QlikView 10.x,11.x.
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.

Environment: SAP Business Objects XI R3.1 & SAP Business Objects 4.1, Oracle 11g, Actuate 8, using QlikView 10.x, 11.x.

Confidential

SAP BI Developer/ETL Developer

• Involved in creating specification document and requirement gathering for What-If analysis, Scheduling, Accounting, and Agreement.
• Involved in migrating SAP Business Objects XI 3.1 legacy reports to BI 4.1 using the Upgrade Management Tool (UMT).
• Involved in creating the BIAR files and moving them to support the migration.
• Used Crystal Report 2011 to develop reports for different clients by using Highlights experts, Select Expert, Record Select, sub reports, static and dynamic parameters.
• Used Business View Manager (BVM) to fix issues with Dynamic Cascading prompts.
• Used dummy groups, Shared variables, Underlay section to achieve different type of complex requirement.
• Improve the performance of crystal report using Perform Grouping on Sevrer, Report Bursting Index etc on the report level and use indexes and hints techniques on the database level.
• Created Agreement Universe for Accounting and Scheduling projects resolve chasm trap and fan trap in the universe by defining context and Alias and created complex objects using case and decode scripts.
• Modified price matching, contract by defining new context and setting cardinalities between tables.
• Used Webi Rich Client 4.1 and BI LaunchPad to create reports using Alerts, Groups, Element Linking with context ForEach,ForAll and complex logic.
• Worked on the SAP BW with crystal report using Fact, Measure and dimensions.

Environment: Windows Server 2003, SAP Crystal Report 2011, SAP Business Objects XI R3.1 & SAP Business Objects XI 4.1 Oracle 11g, Informatica 9.1 HP

Confidential

SAP BI Developer/ SAP Crystal Report Developer

• Involved in migrating SAP Business Objects R2 CRDW legacy reports to BI 4.0 using the Upgrade Management Tool (UMT).
• Involved in creating the BIAR files and moving them to support the migration.
• Migrated Deski reports to Webi 4.1 handling free hand SQL, Links to the new system along with formatting, charts, multiple break on dimensions issues etc.
• Involved in creating and executing test cases for SIT and UAT (User Acceptance Test) using ALM.
• Involved in testing the Data in the report vs. Vertica and Report layout validations of Crystal report mostly.
• Fixed the Layout issues,Formulas using Crystal report 2011 and Sql by checking in both Oracle and Vertica during migration from XIR2 to SAP BO 4.1.
• Testing Applications, reports using review checklists, Data quality for quality assurance before delivering to the end users.
• Experience in complete project life cycle including documentation, analysis, and development and testing.
• Always worked in close association with customers and a single point of contact for many major implementation projects.

Environment: Windows Server 2003, SAP Business Objects XI R2 & SAP Business Objects XI 4.0, HP ALM, Oracle 11g, Informatica 9.1 and Vertica

Confidential, Albany,NY

SAP Crystal Report Developer/BI Developer

• Designed and developed reports using Crystal Reports 2008 version.
• Created Crystal Reports using Crystal Reports formulas, Grouping, Parameters, Selection criteria to handle the customer's requests from Tables, Stored Procedures, Views and Command Objects.
• Developed various charts and graphs like Bar chart (side-by-side, stacked), line graphs, Gantt Chart etc by using Chart Expert using Crystal Reports 2008.
• Used Central Management Console for deploying and managing the reports.
• Responsible for giving user access and setting restrictions to view the reports.
• Handle both dependent and stand-alone sub reports.
• Set filters, suppression formulae and used highlighting expert to show the data the users would like to see in a more concise and presentable format.
• Write several SQL and PL/SQL queries on both Oracle 11g and SQL Server 2010.
• Created SQL commands, Views, Stored procedures and OLAP cubes as needed.
• SQL optimization to improve run time performance of reports using Hint and explain plan techniques.
• Created Adhoc Reports using Accela Tool.
• Worked on the support of Data extraction, layer architecture, automated jobs along with QlikView Server Administration
• Performance monitoring and system optimization
• Developing reports in QlikView for different State Agencies (AGM,DOS etc).

Environment: Crystal Reports 2008, Business Objects Enterprise XI R3, Accela, Oracle 11g, Qlik View10/11, Qlikview Publisher

Confidential,Mt Laurel, NJ

AP Business Object Architect

• Interacted with business analysts, data architects and application developer to develop a data model.
• Set up the SAP BO 4.0 Server architecture with Full life Cycle from Installation to patch’s upgrade and configure the SSO with AD Server using Kerbose Authentication.
• Used the Upgrade Management Tools to migrate from XIR2 to SAP BO 4.0 with Live to Live Option for each Module using incremental approach.
• Responsible for developing, support and maintenance of Crystal Report Server 2011.
• Created and manage users in BOE XIR2 and SAP BO 4.0 servers.
• Used Crystal Report 2011 to develop reports for budget section by using Highlights experts, Select Expert, Record Set, subreports, static and dynamic parameters.
• Created and manage users in BOE XIR2, 4.0 servers and use import wizard and Upgrade Management Tool for migration from Live to Live and LCM(Promotion management) for backups.
• Used ADO.NET for connectivity with Sql Server 2008 using functionalities like Connections String, Dataset, Data Adapters, DataTable, DataRow and DataColumn etc.
• SQL optimization to improve run time performance of reports.
• Debugged Informatica mappings using the debugger and also incorporated various error handling techniques in maps such as audit tables, which would help in identifying error’s accurately.

Environment: SAP Business Objects 4.0, XI R2 (CMC, Designer), Web Intelligence XI R2 (Info view),MS SqlServer 2008, Xcelsius 2008,Informatica 9.1, Windows XP, Windows 2003 Server.

Confidential,San Antonio,TX

SAP Business Object /ETL Developer

• Used Informatica Designer to create complex mappings, transformations, source and target tables.
• Administer the repository by creating folders and logins for the group members and assigning necessary privileges.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Designed Universes using IDT with Multi source data sources using connection Layer, Data Foundation Layer and Business Layer and publish it.
• Implemented rules for different Level of Coverage’s on the base of LOB’s in database.
• Created row level security for various users and groups in universe designer.
• Created conformed dimensions in order to share the objects for the slice and dice controls in Loss level reports for each state.
• Use Aggregate Awareness functionality to improve the performance and adjust the incompatible objects.
• Use prompts, blocks level filters and removed char level fields in reports for the better performance of the old property universe base long sheet reports.
• Developed Corporate Dashboard in Infoview for ADS DATA MART.
• Use of Squirrel for creating queries for crosscheck against the infoviewSql.
• Defined Alias and context to solve the loop problem in ADS Data Mart Universe.

Environment: SAP Business Objects 4.0,XI 3.1 (CMC, Designer) Web Intelligence XI 3.1 (Info view),, Informatica 8.6, Windows XP, Windows 2003 Server.

Confidential,Birmingham,AL

Lead BI Developer

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial system for Business Objects Universes and Reports.
• Worked on PowerInsight Universe design inpatient and lab reports.
• Understanding flow of clinical events in Cerner system(Firstnet,Surgnet and Lab data)
• Migration of content from the BO XI R2 system to XI R3 using the Import Wizard.
• Designed metrics like Total Delay in ED, Total Surgery time, Total patient time admit to discharge etc for Emergency dept in WEBi.
• Responsible for creation of various reports which includes weekly reports, bi-weekly reports, reports by Group, reports by Product and Sub-product.
• Created Ad-hoc reports using Business Objects functionalities like Cross Tab, Master Detail, Slice & Dice and Drill Down, etc.
• Extensively used Inforamtica 8.5.1 transformations like router, aggregator, lookup, source qualifier, joiner, expression, aggregator and sequence generator transformations in extracting data in compliance with the business logic developed.
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.

Environment: SAP Business Objects XI 3.1 (CMC, Designer) Web Intelligence XI 3.1 (Info view),Crystal Report, Cerner, Oracle 10g, MS Excel 2007,Informatica 8.5, Windows XP, Windows 2003 Server, Unix.

Confidential,NY

Lead BI Developer / LEAD Crystal Report Developer

• Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation.
• Developed various Charts and Graphs like Bar chart (Side By Side, Stacked), Line graphs, Pie Charts etc by using Chart expert of Reports.
• Have sound knowledge in Excel -- Created graphs using Pivot tables and written VB scripts for macros.
• Developed reports implementing Dynamic & Cascading Parameter field feature in Crystal Reports 2008.
• Responsible for Validating and testing the Design Considerations document with instructions.
• Worked on CASA CASE AUDIT application using ASP.NET and SQL SERVER 2005.
• Used Access to validate data for the CASA Audit.
• Used SSIS and SSRS for Reporting.

Environment: Business Objects XI 3.1 (CMC, Designer) Web Intelligence XI 3.1 (Info view),Crystal Report, Business Objects XI 3.1, Live Office, QAAWS, Xcelsius 2008,Crystal Report 2008, Oracle 10g, Informatica 8.1, MS Excel 2007, Windows XP, Windows 2003 Server.

Confidential,Syracuse, NY

BI Developer

• Involved in productions support of existing environment, resolved daily issues and tickets assigned.
• Transformed MS Excel spreadsheets into interactive data presentations and shared them via PowerPoint, Adobe Pdf and Infoview.
• Developed a universe using relational data model as per business requirement specification.
• Created Derived Tables, Classes, Objects, Dimensions, Measures, Details, Conditions, Joins.
• Resolved Loops using Aliases and Contexts, verified integrity of the universes.
• Used Slice and Dice, Drill Down, Filters, Master Details, Cross-Tabs and developed Hierarchies to support drill down reports.
• Created training manuals for users for Infoview, CMC and Xcelsius.

Environment: Business Objects XI 3.1 (CMC, Designer) Web Intelligence XI 3.1 (Info view, QAAWS, Xcelsius 2008,UNIX(bash shell), Oracle 10g, MS Excel 2007, Windows XP, Windows 2003 Server.

Confidential,Miami, FL

Senior SAP Business Objects Consultant

• Gathered Business requirements from Business Users and prepared BRS, functional specification and technical specification documents.
• Configured and managed Business Objects Enterprise XIR2 servers and security setup.
• Created nested Derived Tables to bring complex result set for specific queries based on client’s requirements.
• Created Classes, Objects, Conditions and multiple hierarchies to give the reports drill across functionality.
• Created reports in Deski by using free hand SQL as a source.
• Resolved Loops using Aliases and Contexts, resolved errors after the integrity check in the universe.
• Used @functions (@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions.
• Used aggregate navigation to select data from multiple tables dynamically.
• Developed Dashboards for top management using Crystal Xcelsius and published them to Infoview.
• Trained the users on Infoview and Live Office, mentored them to create ad - hoc reports in Infoview, and also trained users to schedule the reports using the Info view.

Environment: Business Objects XI R2 (CMC, Designer, DeskI), Web Intelligence (Info view), Hibernate, Oracle 10g, SQL Server 2008, MS Excel 2007, Windows XP, Windows 2003 Server.

Confidential,Cooperstown, NY

BI Developer

• Interacted with Business Users to understand requirement details based on project scope to develop Universes and Reports accordingly.
• Created complex business reports using custom formulas, context operators (Foreach, Forall)
• Merge dimension, combined queries and sub - queries.
• Created universe on top of data marts using star schema data model.
• Designed and Built the Universes, Classes and Objects in Business Objects XI R2.
• Created different types of reports such as Master/Detail, Cross Tab and Charts in Desktop
• Intelligence and Webi.
• Used conditional formatting for various reports in Crystal Reports and used Parameters, Graphics, Charts and other features in Crystal Reports.
• Written Free Hand SQL to write reports using FHSQL as a source and optimized queries written in derived tables and cross check against Teradata as source.
• Documented test cases and test scripts along with technical specifications.

Environment: SQL Server 2005,Teradata, SSRS, Business Objects XI R2, Xcelsius 2008, Crystal Reports XI, Web IntelligenceOracle 9i/10g, PL/SQL, HP Service Center, UNIX and Windows 2003.

Confidential,Colorado Springs, CO

SAP Business Objects Consultant/Crystal Report Developer

• Installed, deployed and configured Business Objects Enterprise on Windows NT server.
• Tested and deployed universes and documents across testing/production repositories
• Setup and administer the Broadcast Agent. Worked with BCA to schedule reports on monthly and weekly basis.
• Row level security is implemented in the supervisor to restrict the data to the respective divisions.
• Resolved Chasm Traps and Fan Traps using multiple SQL statement option and Alias and Context.
• Created different types of reports like Cross Tab, Charts and Master Detail using multi data sources.
• Hierarchies to support drill down reports.
• Used Crystal Report 9.0 to enhance the performance and functionality of existing crystal reports.

Environment: Business Objects 6.5/XI R2 (Designer, supervisor, Full Client), Crystal Reports 9.0, SQL Server 2005, Windows NT, UNIX

Confidential, NewYork, NY

SAP Business Objects Developer

• Analyzed the existing data warehouse and implemented changes to design, develop reports in the new format as per escalating user requirement.
• Involved in understanding the end-user requirements and business processes in creating new reports.
• Wrote technical and functional documentation for new universe and reports.
• Build universes, reports to keep track of the metrics on the Business Objects usage scheduled job statistics for the management.
• Involved in designing and developing universes for report generation from different databases (SQL Server, MySQL, and Oracle).
• Worked with Data Analyst in developing Universes based on data model, and reporting requirements.
• Validated the data and the joins in the Universe by running BO reports and exporting the output to the Excel Spreadsheets and again testing it against the data that was fetched from backend tables.
• Documented test cases for reports and universes.

Environment: SQL Server 2005, MySQL 5.1, Oracle 9i/10g, HP Service Center, Business Objects XI R2/ 6.5, Crystal Reports, XlCelsius, Data Federator, DB2 8.0, Java Script 1.5, PL/SQL, Business Objects XIR2, WEBI, Designer, HTML, XML, Windows 2003, UNIX.