SUMMARY:

• Over all 8+ years of experience in Study, Design, Analysis, Development and Implementation of Software Application Development under different environments including 7 years of experience in using DSS/OLAP (Data Warehousing) tools i.e., Business Objects 4.0,XI R3,XI R2, BO 6.5and BO 5.5, Performance Manager, Dashboard Manager, Voyager, Xcelsius, CrystalReports, BEx Web and BO Java SDK.
• Experience in Designing/Developing the User-Interface (Universe/Data-Model), Developing Canned/Ad-hoc Reports, Scheduling and processing of reports using Broad Cast Agent and Supervisor.
• Hands on experience in ETL tool like Informaticaand Data stagefor Extraction, Transformation and Loading.
• Experience in Client/Server Technology and RDBMS. Involved in Data Conversion such as Analysis, Design, Development, Mapping, Testing and Implementation with various customers.
• Hands on experience using Oracle 8i/9i/10g, SQL Server 2000, 2005 and 2008 extensive experience in writing SQL Queries, PL/SQL, Stored Procedures, Functions, Triggers, Exception Handling, Cursor, Database Objects and Collections.
• Proficient in various features of ERWIN like forward engineering and reverse engineering.
• Confident, independent, good decision-making power gained over all 7 years of IT experience and ability to adapt to new technologies very quickly.
• Able to work within an aggressive and demanding project schedule and environment.
• Excellent analytical, time management, interpersonal skills and a good team player with excellent oral and written communication skills.
• Expertise in Developing Full Software Cycle which includes Design, Development, Report Generation, Testing, Debugging, Support and Maintenance.
• Proficient in creating Classes and Objects using the available Tools and existing designs in Business Objects Designer.
• Extensively worked with Business Objects Web Intelligence (Web I) and Desktop Intelligence (Desk I) in generating reports and analyzing them.
• Expertise in handling various Business Objects Administrative tools such as Central Management Console (CMC), Info view, Import Wizard, Report Conversion Tool and Central Configuration Manager (CCM).
• Scheduled and published reports using the Business Objects Enterprise Server and provided access to different user groups through Info view.
• Designed reports with complex formulas and custom functions.
• Designed reports in Crystal Reports XI and 2008 with complex command objects to optimize response time and performance of the reports.
• Design reports with conditional formatting, suppressing, sorting and alerts.
• Designed parameterized reports with Dynamic Cascading Prompts and hierarchical groupings with summaries.
• Designed reports based on Business Views and Universes with parameters, summaries and running totals in Crystal Reports XI.
• Implemented Cross-Tab reports with Drill-down Charts.
• Customized and performed troubleshooting on existing reports for specific requirements on an on-demand basis.
• Designed efficient database in Oracle and MS SQL Server to suit reporting needs of the organization.
• Tested the performance of Crystal Reports for reports based on Business Objects Universes.
• Designed unlinked sub-reports and linked sub-reports based on user selection.
• Created new stored procedures and modified existing ones using PL/SQL.
• Created and managed reusable/shared repository objects.
• Performed troubleshooting of scheduled reports that failed or produced errors while they were run.
• Interacted with end users and business analysts to gather the reporting requirements.
• Evaluated different reporting strategies to determine the best fit solution for the business.
• Assisted the end users in UAT procedures and understanding the reports and the associated desktop/web-based applications.
• End to end development and deployment of Crystal Reports on a Java-based web application.
• Created forms and report viewers in JSP for Crystal Reports running off Java Stored Procedures.
• Created database migration scripts to deploy database and reporting changes across the different environments from Development to QA and UA.
• Assisted the database and Business Objects teams in troubleshooting issues.
• Assisted Business analysts and end users with understanding and clarifying business requirements vs. design issues.

EDUCATION:

BS in Information Technology Confidential, India

SKILLS SUMMARY:

Operating System: Windows 98/2000/NT/ 2003 Server, XP, UNIX and Sun Solaris BI Tools: Business Objects Suite, BO Designer, BI Tools Business Object XI R3, R2 /6.x/5.x, Dashboard Manager, Performance Management, Voyager, Xcelsius, Crystal Reports 9.x/XI, Business Explorer

Data Modeling: Erwin 3.5.2
ETL Tools: Informatica 5.x/6.x/7.x.
RDBMS: Oracle8x/9x/10g, MS SQLServer 2000/2005, DB2 UDB, My SQL
Languages: C/C++, Basic, SQL, Java, Shell Scripting
GUI Tools: VB 6.0, .NET, HTML, VB Script, JavaScript

EXPERIENCE:

Confidential, Minneapolis, MN Aug 12 Present

Role: Sr. BO Developer

Responsibilities:

• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Chartsetc. by using Chart expert of Crystal Reports 2008.
• Worked on crystal complex reports that require running totals, sub-totals, sub-reports, hierarchies,cross-tab,multiple groups and conditional display of groups, fields, and messages.
• Developed severalcomplex reports (include multiple groupings, drilldowns, parameter fields, formulas and retrieving data from more than one database) using Crystal Reports.
• Created Dashboards using Crystal Xcelsius.
• Created BW cubes and Query design, with a good understanding of BW.
• Worked in the development and support of reporting solutions within the mixed BW/BOBJ environments.
• Worked on Business Objects with BW cubes and query design.
• 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 in SQL server for faster execution.
• Created Web Intelligence and Desktop Intelligence reports with multiple data providers like Universes, Personal Data Files and free-hand SQL.
• Built queries to retrieve data in SQL Server and Teradata through a universe and set up query conditions.
• Worked closely with Business Analysts to produce reports based on the requirements.
• Converting high-level design specifications to detailed functional and technical specifications.
• Designed, developed, modified and maintained Business Objects universeusing Designer 6.5 for ad hoc and canned reports.
• Created joins, indicating cardinalities, checked integrity of the universe and resolved loops and traps using aliases and contexts.
• Created Hierarchies, complex objects using various @functions, Aggregate objects in the universe.
• Designed Cascading prompts in the universe to filter the list of account names based on the business units.
• Tuned universe for efficient query performance.
• Imported and exported universes, reports to and from Repository.
• Migrated Business Objects from 6.5 to XI R2.
• Created queries to extract data from database for multi-dimensional analysis using Slice & Dice and Drillup/down functionality.
• Used stored procedures, Free Hand SQL, and excel files as data providers for creating reports.
• Created users, user groups and maintained user access rights for BO universes and reports.
• Provided training to end users to use various functionalities of Business Objects thick and customized thin client.
• Created scripts for Oracle Tables, Indexes, Roles, views and Stored Procedures and Functions.
• Created and maintained Business Objects reports in Web Intelligence Info View. Scheduled Reports using via Scheduler/ Broadcast Agent.
• Involved in Design, Development and Implementation of Reports using Crystal Reports Developer XI.
• Responsible for creating the Complex Crystal Reports (on demand, Adhoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-Down, Dynamic Grouping, Cross-Tab, Graphical, Aging Reports).
• Created Parameter driven reports to restrict volume of data and to make the report user friendly.
• Created complex dashboards using Xcelsius 4.5 professional which enhanced decision making.

Environment:Business Objects 4.0,WEBI,DESKI, Central Management Console), Crystal Reports 2011, Designer, Oracle 12g, TOAD, LDAP, Import Wizard, Java Script, HTML, SAP BW, SQL Scripts, ERWIN, Shell Scripting, UNIX IBM AIX Server, MS Office 2003,.Net, MS Project 2003

Confidential,Milwaukee, WI Jan 12 Jul 12

Role: Sr.Business Objects Consultant

Responsibilities:

• Involved in all phases of Software Development Life Cycle (SDLC).
• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications to generate the reports.
• Involved in Working with Erwin tool in Data Modeling (both Physical and Logical Design).
• Worked as an Administrator in creating users, folders and managed the access privileges in Windows.
• Created universes, classes, objects, complex measure objects, prompts, pre-defined conditions.
• Created universes for the users to do ad-hoc Reporting.
• Created Dashboards in Crystal Xcelsius2008 using Charts, Selectors, Gauges, Maps, Arts and Background and Web Connectivity.
• Resolved loops by either creating aliases or contexts or by defining shortcut Joins.
• Created Universes using @functions like @select, @where and @prompt in the process of building the universes.
• Created design for running multi flavor reports like Date, Weekly and monthly as well.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
• Migrated several reports/universes from BO XIR2 to XIR3 using Import Wizard and converted them to WEBI reports using Report Conversion tool.
• Created Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Applied slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Created financial reports, charts using Universes as the main data provider. Reports such as Quarterly variance, Regional, Actual vs. Forecast, Balance sheets etc. were developed.
• Created graphical representation of reports such as Bar chart, Pie chart etc. as per the end user requirements.
• Created BI schema with cold backup and done BOBJ integration with BI.
• Created number of formulae, conditional display of fields for complex calculations and used them in different sub reports.
• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Chartsetc. by using Chart expert of Crystal Reports 2008.
• Worked on crystal complex reports that require running totals, sub-totals, sub-reports, hierarchies,cross-tab,multiple groups and conditional display of groups, fields, and messages.
• Developed severalcomplex reports (include multiple groupings, drilldowns, parameter fields, formulas and retrieving data from more than one database) using Crystal Reports.
• Created Dashboards using Crystal Xcelsius.
• Created BW cubes and Query design, with a good understanding of BW.
• Worked in the development and support of reporting solutions within the mixed BW/BOBJ environments.
• Worked on Business Objects with BW cubes and query design.
• 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 in SQL server for faster execution.
• Created Web Intelligence and Desktop Intelligence reports with multiple data providers like Universes, Personal Data Files and free-hand SQL.
• Built queries to retrieve data in SQL Server and Teradata through a universe and set up query conditions.
• Developed, tested and implemented new PL/SQL Packages, Functions and Stored Procedures, Triggers etc.
• Responsible for SQL tuning and optimization using Explain Plan, TKPROF, Indexes and optimizer hints.
• Worked with Central Management Console (CMC) to manage groups, users, set security levels, Publish and schedule reports.
• Scheduled the report by setting the run-time parameters and charted by customizing the options.
• Developed UNIX shell scripts to kick off back end PL/SQL, SQL.
• Assisted in the preparation and distribution of internal financial reports, including division reporting.
• Worked as a part of a team and provided 24x7 supports when required.
• Lead the offshore team.

Environment: Business Object XIR3, Crystal Reports 2008, Crystal Enterprise XI, Crystal Xcelsius, Designer, Desktop Intelligence, Web Intelligence, Info View, CMC, CMS,Informatica 8.1, SAP BW,Oracle 9i/10g ,SQL, PL/SQL,SQL Server 2008, TOAD, Erwin 6.1,.Net, Windows 2000/XP.

Confidential,Farmington Hills, MI Jul 11 Dec 11
Role: BO Developer

Responsibilities:

• Designed, developed and tested reports in Web Intelligence, and Crystal Reports 2008.
• Conducted training for end users for using various functionalities to use in Crystal Reports
• Managed Crystal Reports Explorer, Designer, Desktop Intelligence, Discussions, Info View, and License Information.
• Designed and developed dozens of reports for various modules of legacy application (MDDB & Trial works) using Crystal 2008 for comparison of migrated data and for application documentation purpose.
• Administered Business ObjectsXIR3, User/group security, application security, data row level, object level security, scheduling and distribution strategies
• Gather detailed requirements & write functional specifications.
• Created Dashboards in Crystal Xcelsius2008 using Charts, Selectors, Gauges, Maps, Arts and Background and Web Connectivity.
• Tested and Validate Crystal Reports data for accuracy in UAT environment.
• Worked on the most complex problems where analysis of situations or data requires evaluation of intangible variance factors.
• Administered user management tasks such as setting up authentication and adding users and groups
• Published, organized, and set security levels for all the Business Objects Enterprise (BOE).
• Created Dashboards in Crystal Xcelsius2008 using Charts, Selectors, Gauges, Maps, Arts and Background and Web Connectivity.
• Gathered, Analyzed & Documented business requirements, functional requirements and data specifications for Business ObjectsXIR3 Universes and Reports.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
• Responsible forSQL tuningand optimization using Explain Plan, Indexes and optimizer hints.
• Planned and performed as the escalation point for the most complex platform designs, coding, and testing.
• Responsible for creating new users and giving them access to the required documents.
• Performed Application Analysis, Design and Programming inBusinessObjectsdevelopment
• Performed coding tasks inBusinessObjects, SQL queries with Oracleand TeradataDatabase
• Involved in unit Testing and System Integration testing per user/business requirements
• Involved in fixingpost production
• Trained clients onCrystal Reports, Reporting Services and Framework services.
• Worked oncrystal complex reportsthat require running totals, sub-totals, sub-reports, hierarchies, cross-tab, multiple groups and conditional display of groups, fields, and messages.
• Developed Advanced Business ObjectsXIR3 universes using @Aggregate Aware, used derived tables, measures using complex functions and developed complex reports require multiple data providers
• content
• Created accurate and detailed project documentation, estimates, functional and technical specification documents, and product configuration throughout the solution delivery process
• Involved in bug tracking and bug fixing.
• Conducted user training sessions, prepared training material and tips. Trained users on how to use the Info view and using WEBI for building Ad hoc Reports
• Involved in Data Modeling of the Data mart tables using ERWIN.
• Created BW cubes and Query design, with a good understanding of BW.
• Worked in the development and support of reporting solutions within the mixed BW/BOBJ environments.

Environment:Business Objects XIR3,WEBI,DESKI, Central Management Console), Crystal Reports 2008, Designer, Oracle 10g, TOAD, LDAP, Import Wizard, Java Script, HTML, SAP BW, SQL Scripts, ERWIN, Shell Scripting, UNIX IBM AIX Server, MS Office 2003,.Net, MS Project 2003

Confidential,Louisville KY Jan 10 Jun 11 Role: Business Objects Developer

Responsibilities:

• Interacted with Business Users, Business Owners to gather their requirements in developing and modifyingUniversesandReportsaccordingly.
• Designed Universes by creating the Business Objects Data Model, selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects like Dimensions, Details and Measures which are grouped into Classes and checked the integrity of the universe.
• Resolved Chasm traps, Fan traps& Loop problems.
• Created Hierarchies for providing drill down options for the end-user.
• Created Derived Tables in the universes.
• Applied Objects / Data Level Security in universe level.
• Excellence in Fine Tuning and improving Performance of Universes and Reports.
• Created the reports using Business Objects functionalities like Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Made the Reports user friendly by implementing userprompts, conditions and filters.
• Extensively Worked on Migration of Full Client Reports of Business Objects XI R2 to XI R3 Reports.
• Created User/Group Level Security in CMC.
• Interacted with Risk Managers and Analysts for Universe and Reporting Query costs.
• Development of the Informatica Mappings, lookups, reusable components, Sessions, Work Flows etc. (on ETLside) as per the design documents/communication.
• Created Dashboards in Crystal Xcelsius2008 using Charts, Selectors, Gauges, Maps, Arts and Background and Web Connectivity.
• Involved in creating reports on the web using Business ObjectsWeb Intelligence. Exported the Business Objects reports to web I to be viewed by all users on the Web. Customizing the user interface using Web Intelligence SDK and JSP.
• Designed and developed Test Scenarios, Test procedures, Test Cases, and Test Data according to requirements.
• Developed reports using CrystalReports XI R2 that includes extraction of data from SQL server to satisfy standard reports, ad-hoc requests, developing databases, spreadsheets, and other applications to manipulate data.
• Troubleshooting and fixing issues in existing Business Objects/Crystal Reports applications.
• Developed and maintained files forversion controlusingVSS. Createdtechnical documentationon every process and procedure implemented.
• Created BW cubes and Query design, with a good understanding of BW.
• Worked in the development and support of reporting solutions within the mixed BW/BOBJ environments.
• Developed variousPL/SQLstoredprocedures,cursorsandfunctionsfordata input to theCrystalReports.
• UsedQAAWSand created a prompt that is used as an input parameter for the dashboards.
• Created a button component to refresh the QAAWS on click.
• Created dashboards using Crystal Xcelsius 2008 by using the different components.
• Defined Metrics, Rule, Alerts, and Analytics & Created Dashboards using Dashboard Manager.
• Created dashboards to show financial statement report to show the statements of income.

Environment:Business Objects XI R2 /XI R3 (Designer, Web Intelligence, Performance Manager, Data Integrator), SQL Server 2005/2000, V2R5, Informatica Power Center 7.1, SAP BW, Xcelsius 2008, Oracle 11i, Tomcat 4.0, Crystal Reports XI/12, Window XP.

Confidential,MI Dec 08 Dec 09
Role: Business Objects Developer

Responsibilities:

• Analyzed business requirements, functional requirements and data specifications for Business ObjectsXI R2 Universes and Reports
• Responsible for developing BI reports, universes, dashboards, and supporting Business Intelligence platforms and applications
• Resolved several Universe andReport issuesin the process of migration.
• Performed day-to-day administration tasks for the Business Objects XI R2 environment
• Synthesized the requirements and reporting capabilities into functional and technical specifications
• Converted Full Client VBA Macro Reports which were developed for the purpose to leave parameters blank when refreshing the reports, using the complex features DESKI/WEBI
• Created Web Intelligence and Desktop Intelligence reports with multiple data providers like Universes, Personal Data Files and free-hand SQL.
• Developed and prepared logic tests, unit tested the final product. The solution includes ad-hoc query, drill-down, slice and dice capabilities, static reporting, and managed queries
• Created Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report
• Created number of formulas, conditional display of fields for complex calculations and used them in different sub reports.
• Developed new Business Objects Reports along with modifying existing reports to support new and additional business requirements. Used prompts, filters, alerts, drill down analysis, row level securities and aggregative awareness as per the end user requirements.
• Created and Tunedcomplex stored proceduresin SQL server for faster execution.
• Responsible forSQL tuningand optimization using Explain Plan, Indexes and optimizer hints.
• Worked with Central Management Console (CMC) to manage groups, users, set security levels, Publish and schedule reports.
• Executed, migrated, and automated existing Business Objects reports to support day to day requests
• Resolved technical problems and Help Desk tickets
• Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures and Triggers.
• Created BW cubes and Query design, with a good understanding of BW.
• Worked in the development and support of reporting solutions within the mixed BW/BOBJ environments.
• Scheduled the report by setting the run-time parameters and charted by customizing the options.
• Reviewed and updated existing reports to comply with Business Intelligence & Reporting standards
• Collaborated with the ETL development team to ensure reporting requests can be supported by the underlying data source
• Performed analysis to investigate and troubleshoot data inconsistencies and data integrity issues
• Identified and resolved bugs in Business Objects reports.
• Assisted in the preparation and distribution of internal financial reports, including division reporting.

Environment:Business Objects 6.5 (CMC, CCM, CMS, Designer, Info View,Web I, DeskI), SAP BW,Crystal reports 10, Dashboard Builder,Oracle9i, ERWIN, SQL Scripts, .Net, Shell Scripting, UNIX Server.

Confidential, Aug 04 Sep 08
Role:Data warehouse Developer

Responsibilities:

• Interacted with Business Users and Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Involved in the designing and Building Universes, Classes and Objects.
• Resolved loops using Contexts and Aliases.
• Exported the Universes to the Repository to make resources available to the end users.
• Created reports for various Portfolios using the Universes as the main data Providers.
• Created the reports using Business Objects functionalities like queries, slice-and-dice, and drill-down, Cross Tab, Master Detail and Formulae etc.
• Created Schedulers to monitor Broadcast Agent.
• Set up groups and users for Business Objects deployment.
• Designed, developed and tested the reports based upon data generated by Enterprise transaction, financial, and customer information systems using Business Objects connected to Oracle 9i data source.
• Created and tested classes and objects to organize the Universe.
• Published and scheduled Business Objects Reports to users using Scheduler.
• Created and developed stored procedures, Packages using PL/SQL.

Environment: Business Objects 6.0/5.1.7, Designer, Supervisor, Desktop Intelligence, Broadcast Agent Server, Oracle 9i, Windows NT.