SUMMARY

• 9 Years of experience in Report Writing, Client/Server, Web application development and Programming.
• Experience on SAP Business Objects(5.x/6.5/XI R2/3.0/4.0) including various modules of Business objects like Business Objects (Supervisor, Designer, Broadcast/Agent) including associated Server Products Web Intelligence 2.7/2.6/6.5, Data Integrator, Data Services, Xcelsius 2008, Crystal Reports 8.5/9/10/XI/2008 and Informatica 9.1.
• Working experience in designing and developing the “Universe” (business view of the database), developing canned/ad - hoc reports, scheduling the processes using Broadcast Agent and administering the BO activities.
• Expert in creating reports using Crystal reports and deploying them in Crystal Enterprise and BOXI Enterprise.
• Experienced in writing complex formulas in Crystal reports, SQL queries using Crystal Designer, conversion of Crystal reports in different versions.
• Involved in Business requirements meetings, interacted with the clients where I gathered Business information from the end clients.
• Experience in ETL (Extraction, Transform and Load) process using Data Integrator/Service and Informatica.
• Experience in writing, testing, and implementation of the triggers, stored procedures and functions at Database level and report level using PL/SQL.
• Exposed to Internet and Database programming with Java, Servlets, JSP, JDBC, XML, and EJB.
• Experience interacting with Functional & Business Analyst, Department Managers and different levels of users and developers.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of team.
• Experience in conducting trainings and leading team to coordinate in understanding business requirements and technical skills.

TECHNICAL SKILLS

Reporting: SAP Business Objects 5.x/ 6.5/ XI R2/3.0/4.0 (Designer, Desktop Intelligence, Web Intelligence), Crystal reports 8.5/9.0/10/XI R2, Xcelsius 2008, Cognos 8 BI.

Tools: Business Objects Data Integrator/Services, Informatica 8.1.1/9.1, SSRS, Quick Test Professional 8.2, Toad 9.1.

Databases: Oracle 7.3/ 8.x/9i/10g/11g, MS SQL Server 7.0/2000/2005/2008 , TSQL, Sybase12.0, Teradata, DB2, MS Access.

Languages: Visual Basic 5.0/6.0, Visual Studio, ASP .NET, Java, JSP, C, C++, SQL, PL/SQL, HTML, DHTML, XML.

Environment: MS Windows 2000/NT/98/XP/7/8, UNIX, LINUX, MSDOS.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

SAP Business Objects Senior Developer

Responsibilities:

• Involved in business interactions to understand the functional requirements of the customers to build the reports using Business Objects to meet their goals.
• Involved in designing universe and modifying existing universe based on new reporting requirements.
• Implemented row level and universe level security as part of corporate separation project.
• Remediated universe(s), Deski & Webi reports as part of the Oracle upgrade from DB2 database.
• Converted Deski Reports to Webi reports using Report Conversion Tool and fixed the partially converted reports.
• Created complex Webi reports using multiple data providers from multiple universe(s) and linked reports using open document.
• Implemented Security on the Reports by creating prompts to separate the corporate data to spilt Regulatory and UnRegulatory data.
• Involved in Business Objects upgrade project from 3.1 to 4.0.
• Created new Informatica Mappings and modified existing Informatica Mappings to add the new Objects/Tables in to the DataMart form ODS tables using Informatica Designer as per the reporting requirements.
• Worked in Agile/Scrum environment for the whole project to keep track of the projects using scrum fundamentals like Daily Standup, Sprint Planning, Story Card Creation, Retrospective etc..

Environment: SAP Business Objects XI R2/3.1/4.0 (Universe Designer, Web intelligence, Report Conversion Tool), Informatica Powercenter 9.1, Oracle 11g, ServiceNow, Windows 2008.

Confidential, Houston, TX

Sr. Crystal Reports /SAP Business Objects Developer

Responsibilities:

• Involved in Gathering the requirements and Designing the Reports using Crystal Reports 10/XI.
• Experience in Training and handling the Team to provide inputs in understanding the business requirements and trained on SQL and Reporting tools.
• Modified existing crystal reports to change data source from Tables to Stored Procedure and command objects.
• Published/Scheduled crystal reports using Business objects R3 Infoview.
• Trained users on SAP Business Objects XI R2/3.0 Infoview environment to run and schedule the reports.
• Created complex reports by creating multiple Sub reports as per the users requirement.
• Created reports from multiple data sources by using command object and writing stored procedures.
• Worked with BOXI Designer to modify existing universe for the Webi Reporting purpose.
• Developed Webi reports using BOXI R3 Webi reporting tool in the process of Crystal to BOXI conversion project.
• Extensively worked on creating stored procedures and command object based on the client’s requirement using SQL Server 2008.
• Designed the Sub-Reports to Access the Stored Procedures and passing the Parameters Dynamically.
• Created and maintained List of Values (LOV’s) using Business View Manger (BVM).
• Created recurring instances and publications using BOXI Infoview to deliver the reports output users as per their business requirement.
• Worked with off shore Team in daily sharing requirements and leading the team.

Environment: Crystal Reports 10/XI/2008, SAP Business Objects XI R2/3.0 (Universe Designer, Web intelligence, Business View Manager, CMC, and CCM), SQL server 2005/2008, Oracle9i/10g, Remedy, Windows XP/7/8.

Confidential, Lexington, KY

Sr. Business Objects Data Services/ETL Lead Developer

Responsibilities:

• Involved in Gathering the requirements and Designing the ETL modules using Business Objects Data Services.
• Created ETL process for different ETL modules based on the requirement.
• Worked with various transformations like Query, Lookup, Pivot, Reverse Pivot, Hierarchy flattening and Merge transformations.
• Designed ETL modules to implement security by creating User Role Hierarchy.
• Prepared UTP documentation and tested the Jobs, Workflows and mappings for each scenario as per the document.
• Created list and cross tab reports using Business Objects Web I.
• Worked with Business Objects Designer to modify the existing universe as per the Reporting and Sales Dashboard needs.
• Defined Classes & Objects of the universe and organized the data along dimensions and hierarchies to perform multi dimensional analysis (Slice &Dice and Drill).
• Extensively used Calculations, Variables, and Sorted inputs, Drill down, Slice and Dice for creating Business Objects reports.
• Created complex reports do display charts, alerts using Web Intelligence.
• Extensively worked on TOAD to create PLSQL scripts and migration of data.

Environment: SAP Business Objects Data Services, SAP Business Objects XI R2/3.0 (Designer, Web intelligence), Xcelsius 2008, TOAD 9.1, Oracle 10g, WinNT/2000/XP.

Confidential, Denver, CO

Business Objects XI/Crystal Reports Lead Developer

Responsibilities:

• Involved in Gathering the requirements and Designing the Reports using Crystal Reports 10/XI.
• Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
• Created Linked and UN Linked Sub Reports to improve the performance and readability of the report.
• Migrated reports from Crystal Reports 9, 10 to Crystal Reports XI Environment
• Defined Crystal reports with sub reports, link reports with drill drown functionality.
• Created parameterized Crystal reports and customized existing reports for presentations using Cross-Tab reports, Sub-reports, Visual Basic syntax to create formulas for the reports.
• Created Crystal Reports Repository objects (business views, reports template, commands)
• Designed the Sub-Reports to Access the Stored Procedures and passing the Parameters Dynamically.
• Extensively worked with command object as the data source in crystal to overcome the performance issues.
• Defined Classes & Objects of the universe and organized the data along dimensions and hierarchies to perform multi dimensional analysis (Slice &Dice and Drill).
• Created batch report schedules and published through Web Intelligence.
• Extensively used Calculations, Variables, and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Created complex reports using Web Intelligence and Desktop Intelligence.
• Implemented dynamic cascading prompts and defined business views
• Created complex Test cases and tested the mappings data-load in different environments.
• Extensively worked on TOAD to create PLSQL scripts and migration of data.
• Planned, coordinate and execute Crystal Reports deployment for End-users and documented the entire project.

Environment: Crystal Reports 10/XI, SAP Business Objects XI R2 (Designer, Reporter, CMC, and CCM), Web intelligence, Cognos 8.2/8.3, PowerBuilder 9/10, SSRS, SQL server, MS-SQL, TOAD 9.1, Oracle9i, TSQL, WinNT/2000/XP.

Confidential, Ann Arbor, MI

Business Objects XI/ETL Developer

Responsibilities:

• Involved in Gathering the requirements and Designing the Reports using Crystal Reports XI R2 and Business Objects XI.
• Defined business views & universes as per end user requirement.
• Defined Crystal reports with sub reports, link reports with drill drown functionality.
• Created Static and Dynamic Parameter fields for the filtering of the data.
• Developed complex dashboards including maps, multiple queries, drill-through, drill down/ups and conditional formatting using Dashboard Manager.
• Generated complex reports using Business Objects XI and Web Intelligence.
• Defined Classes & Objects of the universe and organized the data along dimensions and hierarchies to perform multi dimensional analysis (Slice &Dice and Drill).
• Created user conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Used SQL commands to generate business objects ad-hoc reports using free hand SQL as a data provider.
• Designed the Sub-Reports to Access the Stored Procedures and passing the Parameters Dynamically.
• Implemented dynamic cascading prompts and defined business views.
• Generated PDF reports from an application using an automated tool QTP.
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source Databases to target Data marts using Informatica Power Center.
• Extensively worked on TOAD to create PLSQL scripts and migration of data.
• Worked with offshore team to train and coordinate the project needs.
• Created requirement specifications and design documents for the various projects.
• Planned, coordinate and execute deployment for End-users and documented the entire project.

Environment: Crystal Reports XIR2, Business objects XI R2 (Designer, Reporter, CMC, and CCM), Web intelligence, Infomatica Client 8.1.1, TOAD 9.1, Quick Test Professional 8.2, DB2, Informix, UNIX server, Oracle 9i, WinNT/2000/XP.

Confidential

Software Engineer/Business Objects Analyst

Responsibilities:

• Created, modified and maintained Business Objects universes and metadata using Designer
• Tuned Universe by creating Joins, Contexts, and Aliases for resolving Loops and checked the Integrity of the Universes using Business Objects Designer
• Created reports like Reports by Product, Reports by Customer, Reports by Period, Demographic reports and Comparative reports
• Created various reports as per the user requirements using Business Objects functionalities like Slice and Dice, Drill Down, @Functions and Formulas etc
• Created the Universes with Default & Custom Hierarchies for multidimensional analysis and created reports with Multi-Level Scope of Analysis using drill down, drill across, drill u p and slice and dice.
• Implemented business rules and transforms associated with the publication of business intelligence data in the data warehouse
• Created Hierarchies, complex objects using various functions, aliases, contexts, Aggregate objects in the universe
• Used SQL commands to generate business objects ad-hoc reports using free hand SQL as a data provider.
• Created Aliases and Contexts for resolving Loops and checked the cardinality and Integrity of the Universe

Environment: Business Objects 5.X, Designer, Oracle 8, PL/SQL, Windows NT 4.0

Confidential

Software Engineer/ Database Developer- Intern

Responsibilities:

• Studied the project requirement and designed the project
• Created tables, views, synonyms and sequences
• Created Database Triggers, Stored Procedure, Functions and Packages
• Used SQL Loader for data loading
• Modified existing forms, reports, and graphs as per the enhancement
• Tested all the new and modified program units
• Extensively used Database triggers, PL/SQL procedures, packages and functions while developing the forms and reports

Environment: Oracle 8.1.7, Forms 6i, Reports 6i, PL/SQL, SQL*Plus, Windows.