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, Crystal Reports, 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 Informatica and Data stage for 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 .

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 SQL Server 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,Milwaukee, WI Jan 12 – Present

Role: Sr. BO Developer

Responsibilities:

• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc. 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 several complex 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 universe using 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 Drill up/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, Ad hoc 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,Farmington Hills, MI Jul 11 – Dec 11

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 Charts etc. 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 several complex 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,Troy, MI Jan 10 – Jun 11
Role: Sr.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 Oracle and Teradata Database
• 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,Stamford, CT Dec 08 – Dec 09 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 user prompts, 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 ETL side) 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 Objects Web 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.