SUMMARY

• About 9 years of extensive experience in Information Technology, as a consulting in System Designing, Analysis, Application Development, Maintenance & Implementation.
• Experience in Business Intelligence Technologies such as SAP BOE Product suite - BO XIR4.0, XI3.1, XIR2, Cognos Professional, SAP Xcelsius, Crystal Reports & in Data warehouse concepts.
• Experience encompasses a wide variety of industries including Investment, Finance, Health, Insurance, Transportation & Other Products.
• Solid understanding of SAP best practices and methodology for gathering requirements, generating and measuring business cases.
• Extensive experience in gathering and documenting user requirements, report development, setup security infrastructure at Data and Business levels as part of setting up reporting infrastructure.
• Experienced in interacting with Business users to analyze the Business process, requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.
• Experienced in creating and modifying functional (requirements) and technical (design) aspect. Also interacting in report design, test script creation, unit testing, UAT and end user training.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as Designing, Developing, Testing, Migrating, Administrating, Security Management and Production Supporting and also have successful track record in large-scale with two full life cycle global implementations.
• Expertise in all modules of SAP BusinessObjects suite (XIR4.0, XIR3.1, XIR3, XIR2 & 6.x) with experience in Central Configuration Manager (CCM), Central Management Server (CMS), Central Management Console (CMC), Desktop Intelligence, Web Intelligence, Info View, Universe Designer and Crystal Reports Enterprise.
• Experience in Migrating BusinessObjects 6.x/5.x applications to SAP BO XI R2 and to BusinessObjects XI R3/XI 3.1.
• Expert in writing canned reports, complex ad-hoc reports using SAP BOBJ Desk Top Intelligence (DESKI), Web Intelligence (WEBI), Designer, Import Wizard, Web Intelligence Rich Client, QaaWS, Publishing Wizard, Broadcast Agent, Live Office, BI Web Services, BI Widgets, Business View Manager tools and profound knowledge on Crystal Reports.
• Expertise in Cognos BI series 8 & 7 suites of tools which includes Report Studio, Query Studio, Analysis Studio, PowerPlay, Impromptu Web Reports.
• Strong experience in creating Ad-hoc queries, List Reports, Cross-tab Reports, Standard Reports, Dashboard Metrics, Chart Reports, Map Reports, Financial Reports & Repeater Table using Query Studio, Report Studio & Analysis Studio containing functionality such as conditional formatting, prompts, bursting and drill-through.
• Have clear understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL Tools of Informatica Power Center, Abinitio, Data Stage & SAP BODS.
• Good knowledge of Data Warehousing Models, RDBMS concepts, Data marts in Oracle and SQL Server, experienced of gathering requirements, Proof of concept, gap analysis, design, development, Testing and Implementation.
• Good exposure to Databases SQL, PL/SQL & JDBC/ODBC interfaces to Oracle, Sybase & Teradata.
• Excellent Inter-personal & Communication skills & ability to adapt quickly to different situations.
• Willingness to work under stringent deadlines with teams as well as independent.

TECHNICAL SKILLS

OLAP/BI Tools: SAP BusinessObjects XIR4.0, XIR3.1/XIR3, XIR2/6.x/5.x Suite (Desktop/Enterprise Server products suite), CMC, CMS, Broadcast Agent, Designer, Web Intelligence XI/6.x/2.x, Crystal Enterprise 10/9.0, Xcelsius 2008, Performance Management, Import Wizard, Business View Manager, Information Design Tool, BI Launch Pad, Web Intelligence Rich Client, QaaWS, Oracle Developer 2000, Cognos 8.4 ReportNet1.x, PowerPlay Transformer 7.3.

Security: Active Directory Server, Netegrity Siteminder, Netscape LDAP Server Modeling Erwin, Visio, Framework Manager 8.4.

ERP Modules: SAP R/3 (4.7) FICO, SD & MM.

ETL: Informatica Power Mart 8.5/4.6/4.1/5.1 , SAP BODS 3.0, SAP BW 3.5, Abinitio 1.15, Data Stage 8.5/8.1 & Other load utilities.

Operating Systems: Windows 98, Windows2003 and Windows NT, XP, AIX, UNIX

Database: Oracle 10g, 8i/9i, SQL Server 2008/05/00, MS-Access, DB2 V6, Sybase IQ, Teradata V2R5.1/5.0, Siebel CRM 8.1/7.7

Languages: C, C++, HTML, XML, Java, JavaScript, Visual Basic, TOAD 10.0/ 9.6/9.0

PROFESSIONAL EXPERIENCE

Confidential, Warren, MI

Sr. SAP BI/BO Developer

Responsibilities:

• Interacted with Business Analysts, Business Users and Managers in gathering business requirements for Dashboard and reports.
• Created an Information Design Tool (previously Universe) from scratch, maintained and updated the ‘Data Foundation’ & ‘Business Layer’ for the GDPM Application, based on Logical Model, linked other Database which has Employee & Department Names table’s information, by Data Foundation in Information Design Tool, by creating multisource Relations Connections, for the information using Business Objects XIR4.0.
• Analyzed specs and databases models to generate the reports for the sign-off specs.
• Created joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Created Custom and Cascading List of Values (LOVs) for better understanding of prompts by the end users.
• Detected/resolved data Cardinalities and loops, checked integrity of ‘Data Foundation’s in ‘Information Design Tool’.
• Maintained Business Layer with multi Data Foundations by using Advanced Parameter option & created folders based on User requirements.
• Based on User request, disabled LOVs & maintained Date format for some specific Time Change Objects.
• Created complex Condition Objects for easy reporting, Aggregate-Aware objects for better performance.
• Set up Aggregate Awareness in universe to retrieve data quickly.
• Used @functions (@select, @where, @prompt) to create predefined conditions and prompts to filter the data and for dynamic user selection.
• Created Dimension, Measure & Detail Objects that are needed for reporting following the business usability.
• Created Detail design documents for all the Reports, Data Foundations & Business Layer.
• Created different types of reports such as Master/Detail, Cross Tab and Chart, use of Filters, Conditions, and Calculations
• Created reports, setup alerts, ranking, graphs, and report level variables.
• Created complex reports using complex variables, multiple breaks, sorts, cascading prompts, decode objects etc. Used breaks for white spaces and sections for better navigability.
• Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in Web Intelligence Rich Client.
• Developed dashboards and scoreboards for detailed analysis using different analytics like Speedometer, Interactive Metric Trends, and Barometers.
• Extensively used SQL and PL/SQL scripts to test the reports and to create the reports.
• Created various SQL and PL/SQL scripts for verification of the required Functionalities.
• Prepared and documented the documents generated during the process were Requirements Specifications, Design Document, Project Planning, Change History, Unit testing documents and System testing documents.

Environment: SAP BusinessObjects XIR4.0 (Web Intelligence Rich Client, Information Design Tool (Data Foundation & Business Layer), Import Wizard, QaaWS), XCelsius 2008, Windows 2003, Oracle 10g, DB Visualizer, MS Office.

Confidential, Lansing, MI

Sr. SAPBI/BO Developer

Responsibilities:

• Designed and delivered seminar to introduce a team to Agile Work principles, practices and disciplines in an interactive fashion that assists in teambuilding and finding ways to apply Agile Work to existing problems.
• Interacted with Business Analysts, Business Users and Managers in gathering business requirements for Dashboard and reports.
• Created an Information Design Tool (previously Universe) from scratch, maintained and updated the ‘Data Foundation’ & ‘Business Layer’ for the GDPM Application, based on Logical Model, linked other Database which has Employee & Department Names table’s information, by Data Foundation in Information Design Tool, by creating multisource Relations Connections, for the information using Business Objects XIR4.0.
• Maintained Business Layer with multi Data Foundations by using Advanced Parameter option & created folders based on User requirements.
• Analyzed specs and databases models to generate the reports for the sign-off specs.
• Created joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Created Custom and Cascading List of Values (LOVs) for better understanding of prompts by the end users.
• Detected/resolved data Cardinalities and loops, checked integrity of ‘Data Foundation’s in ‘Information Design Tool’.
• Based on User request, disabled LOVs & maintained Date format for some specific Time Change Objects.
• Created complex Condition Objects for easy reporting, Aggregate-Aware objects for better performance.
• Set up Aggregate Awareness in universe to retrieve data quickly.
• Used @functions (@select, @where, @prompt) to create predefined conditions and prompts to filter the data and for dynamic user selection.
• Edited Joins, resolved the loops using aliases and contexts in the Data Foundation & Business Layer in Information Design Tool and exported to repository.
• Created Dimension, Measure & Detail Objects that are needed for reporting following the business usability.
• Created custom hierarchies for Multi-dimensional analysis.
• Exported Business Layer to the Repository for making resources available to the users and gave 24/7 Production Support.
• Created Detail design documents for all the Reports, Data Foundations & Business Layer.
• Created different types of reports such as Master/Detail, Cross Tab and Chart, use of Filters, Conditions, and Calculations
• Created reports, setup alerts, ranking, graphs, and report level variables.
• Created complex reports using complex variables, multiple breaks, sorts, cascading prompts, decode objects etc. Used breaks for white spaces and sections for better navigability.
• Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in Web Intelligence Rich Client.
• Developed dashboards and scoreboards for detailed analysis using different analytics like Speedometer, Interactive Metric Trends, and Barometers.
• Used QaaWs (Query as a Web Service) and Live office to feed data into Xcelsius.
• Provided Medical Practice & Medical Group Dashboards on Xcelsius.
• Extensively used SQL and PL/SQL scripts to test the reports and to create the reports.
• Created various SQL and PL/SQL scripts for verification of the required Functionalities.
• Prepared and documented the documents generated during the process were Requirements Specifications, Design Document, Project Planning, Change History, Unit testing documents and System testing documents.

Environment: SAP BusinessObjects XIR4.0 (Web Intelligence Rich Client, Information Design Tool (Data Foundation & Business Layer), Import Wizard, QaaWS), XCelsius 2008, Windows 2003, Oracle 10g, DB Visualizer, MS Office.

Confidential, Ann Arbor, Michigan

SAP BI/BO Consultant

Responsibilities:

• Gathered requirements from the Business Users by actively participating in JAD sessions.
• Designed and developed complete universe by creating joins, contexts, aliases, hierarchies, classes and sub-classes.
• Created documents like Business Requirements Specification, Technical Requirements Specification, Universe Design Document and Report Maintenance Document.
• Provided Business Objects Universe design changes to address performance, usability and data reliability issues.
• Followed Best Practices throughout the project for complete life cycle in designing the Universe, Reports & Dashboard.
• Worked with Project Manager, Business users and other developers in creating mock ups beginning from excel report designs till the complete design and development of the Web Intelligence reports about Departed Employee information on Sensitive & Non-Sensitive information.
• Created complex Web I reports by linking objects from different data providers and using Merge Dimension Option.
• Created complex reports using complex variables, multiple breaks, sorts, cascading prompts, decode objects etc. Used breaks for white spaces and sections for better navigability.
• Created complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Used different components like list box, list views, Bar charts, filters, Combo box, Pie charts and stacked column charts.
• Extensively used Drill down capabilities and report linking from summary to detail reports.
• Involved in Security setup of the Report folders and user groups restrictions with BO admin.
• Developed new reports and provided Technical support for the report development team in all reporting tools.
• Trained Users for adhoc reporting capabilities and trained them to use the new advanced functions of XI3.1 & 4.0.
• Unit tested Web Intelligence reports before pushing them to complete testing phase and wrote complete report specs.
• Helped the testing team in understanding the report specs and reports.
• Fixed issues found during testing and actively involved in meetings with business users for UAT approval.
• Completed the project well before schedule and went live with the reports and also participated in JAD sessions with Business Users for report enhancements.

Environment: Business Objects XI 3.1/XI R2, Web Intelligence, Rich Client, Central Management Console (CMC), Central Configuration Manager (CCM), Informatica Power Center 8.5, Oracle 11g, SQL plus, PL/SQL, Toad, SQL Developer, Unix Shell script, UNIX, Business View Manager, Microsoft Sharepoint, Microsoft Excel, Microsoft Access.

Confidential, Lansing, Michigan

Sr. Business Objects Developer

Responsibilities:

• Prepared the following Business/Technical Requirements, Design Templates, Development Standards document and detailed design documents.
• Created Functional Requirement Document (FRD) and technical specifications for universe and reports.
• Involved with Development team for Migration of SAP BusinessObjects from XIR2 to XIR3 version and also involved in CMC to provide the User Security settings and Creating User groups in Rich Client 3.1.
• Created 4 Universes (Activity, Account, Contact & Opportunity); resolved Loops & traps using Contexts & Aliases and Implemented Aggregate awareness.
• Provided SD functional support for business users and resolved issues requiring system and procedural enhancements.
• Configured Shipping Points, Shipping Conditions and Shipping Point Determination.
• Involved in functionalities like Material determination, Listing and Exclusion and Item proposal.
• Defined cardinalities, Performed Check integrity, Resolved Loops by creating aliases and contexts to remove the cyclic dependencies.
• Fine tuning the performance of Universe and Reports.
• Modified the Universes, add additional Dimension, Detail and MeasureObjectsaccording to the requirements.
• Defined and created dimension objects, conditions, user and measure objects to capture complex formulae.
• Created joins, cardinalities between tables applying contexts and alias tables.
• Developing detailed technical specifications for application administration on a shared inter agency server environment; developing a solution for managing and maintaining BI metadata.
• Designed, Developed and Maintained Universes for supporting Ad-hoc and canned reports.
• Designed the Universes and exported them to the Repository.
• Performed the migration of all the Content & Resources from Source to Destination repository using Import Wizard.
• Created Web Intelligence Reports (canned & Ad-hoc) that include functionality like Sections, breaks, Grouping, Sorting, Drill-down, Variables and Slice and Dice using Universes & SQL as Data Providers.
• Extensively used breaks for white spaces and sections and also created user information in the footer level for better navigability.
• Scheduled Web Intelligence reports and Events in Infoview.
• Scheduled the reports using the Scheduler tool.
• Deployed Universes & Reports from Development to Production in a shared Inter agency server.
• Involved with Business Users one to one session of all Reports and pointed to defects log for any formatting issues, data issues and any other changes or performances issues and validated Reports.
• Involved in Unit Testing, Integration Testing and Performance Testing of reports and Universes.
• Trained the End users on the Ad Hoc reporting and on navigating the BusinessObjects tool.
• Functioned as UNIX SME to review all the shell scripts developed by the entire team and provide technical guidance on UNIX related activities.

Environment: SAP Business Objects XI 3.1 (Web Intelligence Rich Client, Info view, Designer, Import Wizard), SAP R/3 4.7 SD & MM, Siebel CRM 8.1/7.7, Oracle 10g, SAP BODS 3.5, Toad9.6, AIX, XML 1.0, Windows 2000, MS Office.

Confidential, King of Prussia, PA

Business Objects & Crystal Reports Consultant

Responsibilities:

• Created Dynamic and cascading prompts in Crystal Reports. Used this new feature to populate prompt values from values in a database and also arranged the prompts in a cascade.
• Explored the functionality of storing a single prompt definition in the repository and sharing among multiple reports, improving both runtime scalability and design-time productivity.
• Implemented Parameterized sorting wherein the reports had the sort values driven by a formula.
• Used the label screen to select a commercial label type to generate mailing labels and also defined a customized layout of rows and columns for a multi-column style report.
• Involved in multiple repository management tasks including Setting up folders for the repository, Adding report objects to the repository, Adding repository objects to a report and Updating report objects in the repository.
• Created Complex formulas using CASE, IF STATEMENTS and STRING CONVESRION and DATE CONVERSION functions.
• Involved in testing reports to compare the row count, response time in 6.5 and XIR2.
• Used the Report Conversion Tool to migrate the existing Desktop Intelligence reports to Web Intelligence. Tested the migrated reports for any cosmetic modifications.
• Created a wide variety of charts like pie chart, 2D and 3D charts reflecting the current information versus the forecasted information.
• Created Hierarchies to provide the drill down functionality to end-users.
• Extensively used ranking, Alerters, Filters and prompts in reports.
• Created highly complex reports using Desktop Intelligence and ad-hoc reports using Web Intelligence.
• Created various report formats such as Sub Reports, Cross Tab Reports, Standard Reports, OLAP Reports and Master Detail Reports.
• Created customized LOV's and cascading prompts for easy access to business users.
• Developed Shell Scripts on Aix Server for upgrading the Jobs.
• Performed various operations like publishing and retrieving reports from corporate documents.
• Trained Business users in creating Web Intelligence reports and other common issues.

Environment: Crystal Reports 10/9.0, Business Objects XIR2, 6.5, Desktop Intelligence, Data Stage 8.1, AIX, Windows 2000, MS-Office, XML 1.0, SQL Server 2005 & MS-Access.

Confidential, CINCINNATI, Michigan

Crystal Report Developer

Responsibilities:

• Involved in creating and redesigning existing reports in crystal reports.
• Developed various reports including sub-reports, cross-tabs, standard reports. Worked with groups and drill down reports.
• Wrote SQL queries to pull the data for ad-hoc Crystal reports.
• Developed reports with formulas, expressions and hyperlinks to link different reports.
• Involved in Report Validation for the generated reports to test and sent it to the production.
• Developed procedures, functions and database triggers using PL/SQL.
• Created Entity and relationships in logical data model and converted them to physical data model. And created Database tables using ERWIN.
• Create Ad hoc Reports using End User module in Crystal reports.
• Create different types of reports like Master/Detail, Cross Tab and Chart.
• Use Drill mode and Slice and Dice techniques to modify the reports in accordance with the user’s analysis needs.
• Use Broad Cast Agent to schedule Crystal reports.
• Impose several Joins, Filters, and Alerts to restrict the unwanted data and highlight the required data.

Environment: Crystal reports 10/9SQL,PL/SQL, Windows NT, Toad, Oracle 8i, SQL*plus,, Windows 2003/2000 server.

Confidential

Oracle Developer

Responsibilities:

• Involved in analysis and development of Database.
• Created Stored Procedures, triggers, functions, temp tables for data manipulation & reporting.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Programming with SQL for data manipulation, used for Crystal Reports based on SQL Queries, Procedures, Tables and Triggers.
• Worked with Toad to validate and manipulate data. Involved in Query Optimization.
• Implemented Full Text Search on MS SQL Server tables.

Environment: Oracle 8i, SQL,PL/SQL, Windows NT.