SUMMARY

• Over 9 years of IT experience in Analysis, Design, Development, Testing and Implementation of Business Intelligence (BI) solutions using Data Warehouse/ Data Mart, OLAP, Client Server Technologies and Web - based Applications
• Over 7 years of hands-on experience of all SAP Business Object Enterprise components, including but not limited to, Designer, Web Intelligence, Crystal reports, Desktop Intelligence, Import Wizardand CMC
• Strong experience in Design, Development, Deployment, and Testing of Universes using Business Objects Designer against Oracle, SQL Server and Teradata
• Proficient in all phases of the Software Development Lifecycle, including Requirements gathering, Analysis, Data Modeling, Design, Development, System Implementation, Testing and Production Support
• Hands-on experience in data analysis, data modeling, development,query optimization,performance tuningand trouble shooting
• Extensive experience in writing functional specifications, translating business requirements to technical specifications, creating / maintaining / modifying data base design document with detailed description of logical entities and physical tables
• Strong understanding of Data Warehouse concepts, OLAP, Star Schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, Fact & Dimensions tables, Physical & Logical Data Modeling
• Expertise in Crystal Enterprise Architecture (Web component server, Automated process scheduler, File repository server, Event server, Page server, Cache server, Job server)
• Strong technical background and possess excellent interpersonal and communication skills, efficient time management and organization skills, ability to handle multiple tasks and a good team player

TECHNICAL SKILLS

Reporting Tools: Business Objects XI 3.1/R2/R1/6.x/5.x (Designer, CMC, Web Intelligence (WebI) Rich Client and Desktop Intelligence), Crystal Reports XI /2008, Xcelsius 2008, Live Office, Query as a Web Service (QaaWS), Import Wizard and Metadata Manager

Databases: Oracle 11g/10g/9.x/8.x, MS SQL Server 2008/2005, Teradata, MS Access, MySQL and Sybase

Operating Systems: Windows 7/Vista/NT/2000/XP, UNIX, Linux and MS DOS

Languages: PL/SQL, SQL, PHP, Java Script, VB Script, XML, HTML and ASP

Tools: & Applications SQL Server Management Studio Express, Salesforce CRM, ERWin 4.1, Misys Loan IQ 6.0, Toad, SQL developer, Teradata SQL Assistant, MS Visio, MS Office and MS Project

PROFESSIONAL EXPERIENCE

Senior Business Intelligence Developer / Architect

Confidential, New York NY

Responsibilities:

• Involved in Requirements study, interact with the end users and responsible for gathering the reporting requirements
• Documented the creation and maintenance of the Business Objects Metadata Universe/Reports and Standard Operating Procedures
• Designed, Developed and Maintained Universes for supporting Ad-hoc and canned reports
• Created Derived tables/In-Line views in Universe to support complex business requirements
• Initiated meetings with users to document report requirements and analyzed report requirements to identify opportunities for consolidation of similar report requests
• Installed Xcelsius 2008, Live Office, QaaWS on test environment and created Xcelsius dashboards for senior management and sales executives using Live Office, QaaWS and static excel sheets
• Provided Business Objects Universe design changes to address performance, usability, and data reliability issues
• Created Custom and Cascading List of Values (LOVs) for better understanding of prompts by the end users
• Developed new reports and provided technical support for the report development team in all reporting tools
• Extensively used Salesforce CRM to monitor the data workflow, involved in data migration, and validate data
• Created joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Created complex Condition Objects for easy reporting, Aggregate-Aware objects for better performance
• Created Complex WebI reports using OpenDocument functionality
• Used Complex EXCEL formulas like Vlookup, Hlookup, SumIF and CountIF to generate excel sheet as source to Xcelsius Dashboards
• Developed custom hierarchies to support drill down reports
• Tuned SQL and Universe objects for trouble shooting of reports for data accuracy and reports for better performance using SQL Explain plan
• Created documents like Business Requirements Specification, Technical Requirement Specification, Universe Design Document, and Report Maintenance Document
• Involved in Unit Testing, Integration Testing and Performance Testing of reports and Universes
• Provided the highest level support for Web Intelligence reports, Xcelsius Dashboards and Universe issues for the company

Environment: Business Objects Edge XI 3.1/R2 (Web Intelligence, CMC, CMS, Designer), Xcelsius 2008, MS SQL Server 2008/2005, Windows 7/XP, Salesforce CRM, MS Office 2007/Visio 2007 and Project 2010

Business Objects Architect / Data Analyst

Confidential, New York NY

Responsibilities:

• Participated in requirement gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project and shared / discussed all requirements with offshore development team.
• Participated in creating and reviewing the conceptual model for the Data Warehouse with business users, business analysts and offshore development team.
• Analyzed the source system (Misys LoanIQ / DB2) to understand the source data and LoanIQ table structure along with deeper understanding of business rules and data integration checks.
• Interviewed, helped select, and mentored new Business Objects team and directed their task.
• Participated in development, testing and maintenance of logical and physical ERWin data model, along with corresponding metadata, to support Confidential Data Warehouse (based on Misys LoanIQ).
• Created ETL source to target mapping.
• Worked on data profiling and data validation to ensure the accuracy of the data between the proposed data warehouse model and source system.
• Created Business Objects Universe Design document and charted out the classes/objects structure.

Environment: ERWin 4.1, DB2, Misys Loan IQ 6.0, Embarcadero Rapid SQL 7.5, DB2, Business Objects XI 3.2 (Web Intelligence, CMC, CMS, Designer), Windows XP, and MS Office 2007/Visio 2007.

Senior Business Objects Consultant

Confidential, New York NY

Responsibilities:

• Designed the architecture to support full-lifecycle development of Business Objects universes and reports.
• Migrated Business Objects reports & Universes from 6.5 to XI-r2.
• Studied the existing data model, participated in design phase of new data model and implemented the new model in Business Objects Universe.
• Analyzed all existing reports and discussed and documented redesign approach for all the existing reports to improve the performance and presentation.
• Provided guidelines, assistance, and best practices for report and universe creation and architecture and helped developers on how to implement those best practices.
• Debug existing Universe and suggest ways to improve performance by utilizing the best industry practices.
• Designed and developed Xcelsius dashboards from Universe / WebI reports viaQaaWS and Live Office.
• Create Universe design document, Report requirement specification, flow charts and dataflow diagrams for documentation and training.
• Perform unit testing of reports and universe and logging all the defects and solution in Quality Center.
• Design and Develop canned report and template for ad-hoc reports.
• Defined the CMC Security Skeleton of the Business Objects Enterprise XI 3.1 right from the Scratch.
• Train users on how to use the new reports and how to create ad-hoc reports.

Environment: Business Objects 3.1 (Web Intelligence, WebI Rich Client, CMC, Designer), Oracle 11g, Xcelsius 2008, Oracle SQL Developer, HP Quality Center 9.2, Live Office, QaaWS, Windows XP, and MS Office 2007/Visio 2007.

Business Objects Consultant

Confidential, Memphis TN

Responsibilities:

• Responsible for Gathering, Analyzing and Documenting Business Requirements, Functional Requirements and Data Specifications for Business Objects Universes and Reports.
• Involved in planning, designing, developing, distributingandmaintaining UniverseswithSAP BWas a data source.
• Architected and developed complex Reporting and Adhoc universe for Confidential - Revenue Accounting.
• Headed the team of Crystal Reports Developers, developed the reports as well as got them done by team on time for the releases.
• Architected, developed and maintained multiple Universes on various projects including linked universes. Applied Row level and Object level security in the Universes to make the sensitive data secure.
• Imparted training to Revenue Accounting users on Infoview, report scheduling, Adhoc universe and Adhoc report creation.
• Created parameterized Crystal reports and customized existing reports for presentation using Cross-Tab reports, sub-reports, Running Totals, Sorting, Alerting, and also used Visual Basic syntax to create formulas for the reports.
• Migrated Business Objects 6.5.1/R2 reports to Business Objects XI R3.1 and Crystal Reports 9.0 to Crystal Reports 2008.
• Architected and proto-typed report scheduling work flow on BO Linux environment.
• Created Linux shell scripts for BO Program objects.
• Created BO File based events, Schedule based events, Program objects and Server groups using CMC (Central Management Console).
• Created document templates for Universe design document, report user document and report design document.
• Involved in using Crystal Xcelsius to Transform Microsoft Excel spreadsheet data into interactive flash media files for the upper level management.
• Created documents like Business Requirements Specification (Adhoc reporting), Technical Requirement Specification, Universe Design Document, Universe User Document, Universe Maintenance Documents, Report User Document and Report Maintenance Document.
• Involved in Unit Testing, Regression Testing and Performance Testing of reports and Universes.
• First level support on Production issues

Environment: Business Objects XI R2 (Web Intelligence, Desktop Intelligence, CMS, Designer), Crystal Reports 2008/XI, Xcelsius 2008, SAP BW 3.5, Oracle 11g, TOAD, TeraData, Teradata SQL Assistant, Sybase, Windows XP and MS Office.

Technical Analyst / Sr. Business Objects Developer

Confidential, St. Louis MO

Responsibilities:

• Involved in extensive designing and functional specifications for all modules of business objects.
• Generation ofOLAP UniversefromSAP BW/Multi-provider/ODSdata model in Universe Designer on which the reports are generated.
• Interacted with business users regarding data structure, report format/presentation, and potential issues.
• Involved in designing, developing, testing and deploying BO Universes for report generation.
• Designed and developed reports using Web Intelligence XI, Crystal Reports XI, and Desktop Intelligence.
• Created summary and detail reports that allow for in-depth drilling on specific data and created On-Demand links between reports using OpenDocument.
• Created Crystal Reports against Stored Procedures and transactional databases.
• Involved in tuning of SQL queries and Universes for better performance.
• Created Reports using universe, stored procedures, and freehand SQL as Data providers and writing the complex queries including Sub Queries, Unions, and Intersects.
• Created graphical representation of reports such as Bar charts, Pie charts etc as per the business requirements.
• Developed Xcelsius dashboards for presentations, live data dashboards with alerts, Calculators, Historical data comparisons, what if analyzers for real time understanding of changes in business and embedding of dashboards into webpage.
• Designed reporting Test Plans and Test Scenarios.
• Designed, developed and maintained a database using MS Access 2000 for the Production report tracking system.

Environment: Business Objects XI (Web Intelligence, Crystal Reports, Desktop Intelligence, CMS, Designer) Xcelsius 2008, PL/SQL, MS SQL Server 2005, Oracle 10g, TOAD, SQL Server 2005, SQL Server Management Studio Express, MS Access, Windows XP and MS Office.

Reports Developer / I.T. Consultant

Confidential, Chesterfield MO

Responsibilities:

• Involved in requirement gathering and data analysis for reporting from different business teams.
• Plan and design reports according to business development flow based on user requirement.
• Worked on SQL and PL/SQL, and Toad to study the data in different systems and to validate reports.
• Created complex Stored Procedures using Oracle to be used in the reports.
• Created parameterized Crystal reports and customized existing reports for presentations using sub-reports, Running Totals, Sorting,Alerting, Visual Basic syntax to create formulas for the reports.
• Plan and design reports according to business development flow based on user requirement.
• Implemented dynamic cascading prompts in Crystal Reports.
• Involved in distribution/scheduling of the reports to the users through CMC (Central Management Console).
• Created Multi Dimensional reports using Master/Detail, Cross Tab, Slice and Dice, and Sub Queries.
• Created Technical training document and presented to the developers.
• Designed Test Cases based on the requirements and worked with Business Analysts to test the reports.

Environment: Business Objects XI (Crystal Reports, Designer, Web Intelligence, CMC) Oracle 10g/9i, PL/SQL, TOAD, Windows 2000 and MS Office.

Business Analyst / Business Objects Developer

Confidential, St. Louis MO

Responsibilities:

• Involved in requirement gathering and data analysis for reporting from different business users.
• Involved in writing the High-level and Detail-level documentation of the project.
• Migrated business objects 6 reports to Business Objects Enterprise XI using import wizard
• Recognized ad-hoc data access requirements of the user community and recorded them in the form of candidate classes and objects.
• Mapped objects to data, identified qualifications & hierarchies, resolved loops.
• Implemented advance features such as aggregate awareness, contexts, and aliases.
• Conducted pilot testing (proto-cycling) and deployed universes.
• Responsible for Creating and Maintaining Users/Groups, Universes, Repositories, Connections and Security Policies.
• Responsible for Creating Complex and Multi Dimensional reports using Master/Detail, Cross Tab, Slice and Dice, and Sub Queries.
• Used Alerter, Filters, Breaks, Sorts and Rankings in the reports
• Interacted with other Business Analysts and end users to design Standard and Ad-hoc reports according to functional specification.
• Defined the Custom Scope of Analysis for the Development of Drillable Reports.
• Used Business Objects Web Intelligence tool for deploying analysis reports on Internet.
• Designed complex reports and created various objects using built-in @functions (like @prompt, @select, @where, @aggregate), complex SQL queries and joins
• Involved in distribution of the reports to the users through Broadcast Agent Server.
• Supported the users with their Business Objects related problems.

Environment: Business Objects 6.1 / 6.5, Web Intelligence, Oracle 9i, PL/SQL, TOAD and Windows NT.

Programmer/Analyst

Confidential

Responsibilities:

• Analyzed the existing system and testing the designed screens.
• Providing Technical support.
• Involved in system analysis, requirement determination, feasibility study, documenting existing system and entity identification.
• Involved in writing reports using Crystal Reports.
• Involved in creating Database triggers, Procedures and Functions.
• Code walkthrough of screens of other modules.
• Involved in writing year-end processes to calculate interest and account validation.

Environment: Oracle 7.3, Crystal Reports 2.0 and MS Windows NT.