PROFESSIONAL SUMMARY
Over 7 years of experience in analysis, design, development and implementation of Business Applications and client/server applications.

• Over 7 plus 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., BOXI R3.1.Business Objects 6.1, (Supervisor, Designer, Reporter, Broad Cast Agent, and Web Intelligence 2.6.3) and BOXI R2 (Designer, DESKI, WEBI, CMC), Xcelsius 2008, Performance Manager, Dashboard Manager, Crystal Reports XIR2, BOXI R3.1.
• Expertise in domains like Finance, Healthcare, Pharmaceutical, Government Services, Energy Oil and Gas.
• Experience in full SDLC from Requirements Gathering and Analysis, Evaluating Data Sources, Translating Requirements into Specifications, Business Case Development to Rollout, Production and Maintenance
• Experience in conducting project meetings, reviews, walk through, and customer interviews.
• Expertise in building Universes and creating reports using Web Intelligence and Business objects.
• Experience in conducting Joint Application Development (JAD) sessions and Joint Requirement Planning (JRP) sessions
• Expertise in User Accepting Testing (UAT), documentation of test cases and report generation to assure that all aspects of the project are in compliance with the business requirements.
• Strong experience in developing Test Scripts and Test Cases for Manual as well as Automated Testing.
• Design and review of various documents including the use of test cases, requirement traceability matrix (RTM)andtesting documents
• Expertise in providing Business Intelligence solutions using Business Objects, Cognos, Crystal Reports and other data warehousing tools in OLTP/Data warehousing.
• Experience in deployment of Business Objects/Web Intelligence from various sources like MS SQL Server, Oracle, and DB2.
• Hands on experience using Oracle 8i/9i/10g, SQL Server 7/2000, Teradata, Sybase and extensive experience in writing SQL Queries, PL/SQL, Stored Procedures, Functions, Triggers, Exception Handling, Cursor and Database Objects.
• Strong Knowledge in Logical/Physical Data model (LDM/PDM), with Normalized/Denormalized Databases on both OLTP /OLAP environment using Erwin.
• Expertise in implementing Business Objects Enterprise architecture with fail over, fault tolerance, security and disaster recovery.
• Confident, independent, good decision-making power gained over all 8 years of IT experience and ability to adapt to new technologies very quickly.
• Active in providing functional and technical support, detailed analysis, requirements gathering, data dictionary, testing and user training.
• Document all business processes, needs, flows and diagrams.
• Keep the project manager and supervisors informed of task accomplishment, issues and status.

EDUCATION Bachelors in Information Systems

TECHNICAL SUMMARY

ERP: SAP BW 3.1C/3.0B, SAP R/3 4.6C/4.7 
O/S: Windows NT/2000/98/95/XP, LINUX
RDBMS: Oracle 10g/9i/8i/7.x, SQL Server 2005,2008, Teradata,  and MS Access 2000 
Data Modeling Tools: ERwin 4.0/3.5.2, Visio2002.
ETL Tools: Informatica 6.x/7.x/8.x, PowerCenter/PowerMart, Business Objects Data Services( BODS)
Database Tools: TOAD 10.5, SQL Navigator, SQL Server (Management Studio Express)
BI Tools: Business Objects 6.1b/6.5.1/XIR2/R3.1 (Supervisor, CMC, Designer, Webi)  Web Intelligence 6x/XIR2, XIR3.1 Infoview, WEBI SDK, Xcelsius 2008, Live Office, Crystal XI, Crystal Reports 2008, SAP BW 3.5, SAP BI 7.0 , ECC 6.0
Languages: HTML, PL/SQL, SQL
GUI: Oracle Developer 2000, Visual Basic 5.0/6.0

Confidential, NYC
SAP BW/Business Objects Developer October’11 to Present
The project was to create/maintain OLAP universes and to generate Webi, Crystal reports from sales, purchase departments using SAP BW, Oracle, SQL Server as data sources. Interacting with end Users, to know their requirements and develop/modify Universe and Reports accordingly. 
Responsibilities

• Worked with several users, and interacted with them to gather requirements.
• Developed Webi reports, extensively used Calculation contexts, Variables, Drill down, Slice and Dice, Breaks, Sections, Ranks, Alerts, input controls.
• Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking and multiple data.
• Extensively used slice and dice, filtering and ranking to create cross tab and master/detail reports.
• Involved in formatting sections, tables, inserting and organizing multiple breaks.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors.
• Expert in preparingreport specifications, database designsto support the reporting requirements.
• Experience in building dashboards, score cards, metrics using CrystalXcelsius, Live Office for adhoc reporting.
• Created Cross Tab Reports and Sub Reports, insert sub reports, Share Formulas Between Main and Sub reports using Crystal Reports version 2008.
• Designed queries in Bex query designer and created workbooks in Bex Analyzer using conditions, structures, calculated key figures, character variables, formula variables and text variables
• Worked with business users for defining reporting needs, help design flexible queries, pre calculated reports using BEX reporting features like variables, conditions, exceptions
• Creation and maintenance of OLAP universes source from BEx queries.
• Writing and editing of SAP BEx queries using Query Designer.
• Writing of test scripts for accuracy, formatting, and performance.

Environment: Business Objects XI R3.1 (Designer, Desk I, Web I, Import Wizard, Publishing Wizard), Business Objects XI R2, Xcelsius 2008, SQL Server 2005/2008R2, Oracle 10g/9i, PL/SQL, Window 2003 Server/XP, SAP BW 3.x, SAP BI 7.x

Confidential, OK
SAP BI - BW/Business Objects Developer May’11 to October
Confidential is an international, integrated energy company. It is the third-largest U.S. integrated energy company, based on market capitalization, as well as proved reserves and production of oil and natural gas, and the largest refiner in the United States.
Responsibilities:

• Designed / developed Crystal reports from a number of different data sources with a number of formats including PDF, spreadsheet, or graphic using Crystal Report XI
• Developed Standard, Summary, Cross Tabs, SQL, grouping, sub reports, summary detail reports, linking sub reports, Custom Formatting Techniques in Crystal Reports Environment.
• Developed new reports using stored procedures, enhanced the existing reports for performance and data accuracy.
• Developed reports in Crystal XI with Oracle, SQL Server, Stored procedures, views, customized SQL,Universe.
• Coding and Design of User Interface, Business Logic, Integration Design Reports and Queries.
• Responsible for Integrating Business Objects with SAP BW with Portal Integration kit to publish the reports onto the Enterprise using BW/R3 portal.
• Worked with the business unit to define, develop prototypes for SAP BW reporting.
• Modified BW queries in the Crystal reports using BW query designer with Crystal XI R2 professional tool.
• Experienced in working with Business Explorer (BEx) and publishing the reports on web using Web Reporting tools.
• Extensively work on Query Designer and Web application designer to create Queries for financial reports, budget and delivery analysis using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.
• Developed queries from SAP Infocube using Bex Query Designer and applying filters, free characteristics for slice and dice techniques.
• Developed reports from SAP Infocube by using BEx Analyzer, applied filters, variables, parameters/prompts.
• Worked on transports of BW queries, objects from Development, Test and Production Environments.
• Responsible for developing test cases, business validation rules for verification and validation of data quality.
• Experience in building Dashboards using SAP Netweaver BW connection to create metrics, score cards, rules, alerts, goals and insightful analytics using Xcelsius.
• Strong Knowledge in SAP BW, ECC 6.0, SAPR/3

Environment: Business Objects XI R3.1 (Designer, Desk I, Web I, Import Wizard, Publishing Wizard), Business Objects XI R2, Xcelsius 2008, SQL Server 2000/2005, Oracle 10g/9i, PL/SQL, Window 2003 Server/XP, SAP BW 3.x, SAP BI 7.x ,

Confidential, ME
Business Objects AdminDeveloper February ’11 to May '11
Onpoint Health Data provides a wide range of client services, including designing and executing analysis using large, complex healthcare databases. Business Intelligence Concept of proof project is intended to develop a customer data warehouse using a small dataset to analyze inpatient and outpatient hospital utilization based on demographics, health status, payments, and cost, in support of improved decision making across the organizations and development of reports for the management.
Responsibilities

• Worked with the Business analysts, end users, Data Modelers and the DBA for requirements gathering, business analysis, and testing, project coordination.
• Database structure, analysis of business rules/logic and design in coordination with DBA’s.
• Design and Recommend changes to Data warehouse design like Star and Snow Flake schema.
• Created reports using Oracle Databases and Personal Data File Providers.
• Worked with the Oracle DBA to improve the performance of SQL queries.
• Designed and developed Universes by using Business Objects Designer 3.1.
• Optimized the universe developing time and SQL Tuning to increase the query performance.
• Defined Customized Hierarchies in Universe level.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Resolved table-linking problems like Chasm traps and Fan traps using Aliases and Contexts.
• Created Dynamic Filters and Dynamic Conditions in universe level as per Business rules.
• Created several Classes, Objects, Conditions, and Measure objects.
• Used Calculation contexts, Variables, Drill down, Slice and Dice, Breaks, Sections, Ranks and Alerts in the creation of reports.
• Created Drill-Through Reports to provide users with more detailed information and query linking.
• Worked with the new features in XI 3.1 like Optional prompts, Else if functions.
• Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the common report.
• Migrated existing Crystal reports to Webi.
• Installed and configured Business Objects Edge 3.1 on Red Hat Linux environment. Installed client tools on Windows XP.
• Install, Maintain and Trouble shoot the Business Objects Enterprise Servers.
• Configure Business Objects 3.1 to work in Firewalls, Enable the port(s) needed like 6400, 6401 etc for Business Objects 3.1.
• Created user accounts, groups, applied complex security for each group on Central Management Console(CMC).
• Configured third party authentications like Windows Active Directory, LDAP and Enterprise.
• Created Dashboards in Xcelsius using Excel as Data providers.
• Mentoring/trained business users using Designer and create adhoc webi reports using Infoview.

Environment: Business Objects Edge 3.1 (Designer, Web I, Webi Rich Client), Crystal Professional XI R2, Xcelsius 2008, Oracle 11g/10g, PL/SQL, Windows XP, Tomcat Web server, Linux.

Confidential, ME September ’10 to January ‘11
Business Objects Developer
The need to enhance the Management Information Systems available to support the needs of the Bank’s business processes (Automated Clearing House (ACH) process, Risk Management, Credit Risk). Provide robust business MIS reporting solutions to Management. This project was to develop score cards, dashboards to enable executives get a bird’s eye view of the business performance. 
Responsibilities

• Involved in defining the scope and defining business rules of the project. Also involved in gathering business requirements, documented them textually or within models.
• Interview business owners and external vendors to understand and document expected outcomes of sessions.
• Increase management’s access to day-to-day and summary level information to assist in the evaluation and understanding of the risk and opportunities within the business.
• Assist in current or potential application users in identifying and describing problems or opportunities.
• Worked closely with the business to clarify goals and facilitated the discovery and prioritization of business requirements, including requirement risks.
• Heavily interacted with the Business Users to get a better understanding of client business processes and gathered Business Requirements.
• Business Requirements are analyzed according to System specifications and to evolve a measurable Plan for the complete group.
• Conduct workflow, process diagram and GAP analysis to derive requirements for existing systems enhancements.
• Organized many informal Sessions to widen an architectural solution that the application meets the business requirements, resolve open issues, and change requests.
• Worked closely with the project managers to monitor progress, and the deliverables for the project.
• Created Dashboards for senior management for business decision making.
• Created Metrics for using them in the Dashboards.
• Used multiple different types of different components in Charts, Selectors, Backgrounds and other components like Dials, History, Calendar, Refresh etc.
• Enabled drill down functionality in Dashboards from one component to another component.
• Linked the Web I reports/Crystal to the dashboards KPI’s using Open doc Syntax.
• Developed multiple dashboards allowing the users to navigate from one dashboard to the other using flash variables and Open doc Syntax.
• The Dashboards were linked to one another thus establishing the Parent Child Relationships. Summary Dashboards were linked to Web I Reports which comprised of detail data.
• Develop test cases to test the accuracy of data in reports by running queries against the Oracle database.
• Developed Dashboards and Scorecards for detailed analysis.
• Responsible for creating Analytics, Metrics, Corporate Dashboards and applied the alerts, rules using Dashboard Manager, these Dashboards will provide users a top-level view of key metrics and the ability to drill down from any metric to the operational detail.
• Created Dashboards in Xcelsius using Qaaws and Excel as Data providers.
• Created and Customized Application Dashboards using Xcelsius to meet the requirements of higher level analysis.
• Analyzed data from Clarity and developed reports for management.
• Responsible for documenting the whole process.

Environment: Business Objects XI R3.1 (Designer, Desk I, Web I, Import Wizard, Publishing Wizard), Crystal Professional XI R2, Xcelsius 2008, Clarity Systems, SQL Server 2000/2005, Oracle 10g/9i, PL/SQL, Window 2003 Server/XP

Confidential, CA July ’08 to July ‘10
Sr.Business Objects Admin/Developer
Involved in designing, administering and migration of Business Objects from XI R2 to XI R3; Worked closely with the DBA, architect in migration from XIR2/R3. Universe(s), reports were developed using XIR2/R3. 
Responsibilities

• Involved in requirements gathering session with the business for reporting requirements and Business logics.
• Architect, upgrade and set-up the existing datacenter Business Objects-BO XI production platform/environment and migrate the BO applications from XIR2 to XIR3.
• Involved in planning and migrating the reporting application from XI R2 to 3.1.
• Troubleshoot issues with reports on the crystal enterprise environments ( Development, UAT, Test and Production )
• Configured E-mail functionality (Outbound SMTP Relay) into the XI R3.1 Application and users will have the ability to send documents using E-mail and to send the output of the reports in PDF, excel or webi documents or as an link.
• Supported multiple Business Objects environments ( BO6.5, BOXIR2, BOXIR3.1)
• Applied latest patches, service packs on test and production environments under change management process by sending communication outages to users.
• Created user accounts, groups, applied complex security at the CMC level.
• Configured third party authentications like Windows Active Directory, LDAP and Windows NT.
• Configured FTP on Development and Production XIR3 servers to send report output to a shared network drive as pdf or excel format.
• Debug issues which resulted from Migration. Provide support in improvement and maintenance of the Reports and Universes.
• Created / Modified Universes, Reports from the underlying Databases for business modules.
• Created derived tables at the Universe level to reduce the complexity of the Universes.
• Involved in testing the migrated universes and reports and fixing the issues
• Developed Complex Reports that involved multiple data providers, Master/Detail charts, cross tab, bar charts, pie charts, complex variables and calculation contexts.
• Created Prompts, Conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Extensively used Calculation contexts, Variables, Drill down, Slice and Dice, Breaks, Sections, Ranks, Alerts and synchronized the data using Merge Dimensions in the creation of reports.
• Created Drill-Through Reports to provide users with more detailed information and query linking.
• Preparing and running SQL scripts on TOAD for Data Analysis and tracking errors.
• Developed dynamic and static Dashboards in Xcelsius 2008 ,Live Office and Excel Data, for various Business groups.
• Coordinating with the team for quality data and analysis
• Implemented workflows, scripts, data flows, transformations in Data Services.
• Assist with user testing of systems, developing and maintaining quality procedures, and ensure that appropriate documentation is in place. Responsible for all project documentations.
• Developed test plans for data accuracy, analysis and load validation.
• Responsible for knowledge transfer to end-users and trained them on various functionality using Infoview and Designer.
• Business Objects/Crystal Enterprise, and supported the users with their issues / problems.

Environment: Business Objects XI R3.1 (Designer, Desk I, Web I, Import Wizard, Publishing Wizard), Business Objects XI R2, Data Services XIR3.2, Xcelsius 2008, Business Objects 6.5 (Supervisor, Designer, Reporter),SQL Server 2000/2005, Oracle 10g/9i, PL/SQL, Window 2003 Server/XP

Confidential, CA July ’06 to June ‘08
Business Objects Admin/Developer
Involved in designing and integrating three different source systems into the Health Client Data Store for the Health Department in San Mateo County, using Business objects as front end and Oracle as back end. Collaborated closely with client managers, architects, DBA's and Business users. Reports were created using the Reporting Tool Business Objects.
Responsibilities

• Involved in requirements gathering from the business users to build the reporting application.
• Installed and configured Business Objects XI R2 on Development, Test and Production Environments.
• Enabled/Disabled different servers in Central Configuration Manager and Central Management Console.
• Created users and groups and applied row level and objects level securities using Central Management Console.
• Installed and configured Business Objects XI R2 using Tomcat and Apache as Application and Web Servers.
• Applying latest patches, service packs onto the testing and production environments under change management process by sending communication outages to users.
• Worked with System Administrators to troubleshoot the Business Objects Services after the application patches have been applied.
• Managed and Configured Servers (File Repository Server, Report Application Server, Web Intelligence Server, Destination Job Server, Program Job Server, Event Server)
• Worked with End-To-End implementation with Data warehousing team and Strong understanding of Data warehouse concepts Star Schema, Snowflake Schema and Multi-Dimensional Models for query and analysis requirements.
• Experience in building Universes, retrieving data using Universes, Personal data files, Stored procedures, Free hand SQL methods and creating complex ad-hoc Reports using the Business Objects and WebIntelligence modules.
• Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.
• Resolved table-linking problems like Chasm traps and Fan traps using Aliases and Contexts.
• Created several Classes, Objects, Conditions, and Measure objects
• Involved in migration and deployment of the universes and reports across multiple domains.
• Creating Full client and WebI reports.
• Involved in requirements study, design reviews and analysis of input/output flow.
• Provided end user and production support after deploying the application into the production environment.
• Contributed to Quality Assurance (QA) test design
• Designed Metric Universe for Performance Management products.
• Created metrics, goals and analytics for display in corporate dashboards for business user consumption.
• Developed dashboards and scoreboards for detailed analysis.
• Worked with QA and User Acceptance Testing (UAT) managers to determine requirements for test environment and UAT planning.
• Responsible for UAT execution process including test planning, Defect Tracking, Defect assessment and impact analysis
• Business Objects Enterprise authentication, scheduling, publication and automation of reports.
• Responsible for creating training documentation.
• Coordinated and participated in the successful implementation of the application and performed validation in production environment prior to the users, to ensure the validity of code, tables, views, reports and user interface.
• Documenting the production and development environment changes made on the web servers.
• Used the Import wizard to import existing user accounts, groups, categories, WebI documents, universes, connections and universe restrictions to BO XI environment.
• Created reports prototypes using Web Intelligence XI for user presentation.
• Trained the Business Users in report creation and also new features of Business Objects XI R2.

Environment: Business Objects XI R2 (CMC, Designer, Desk I, Web I, Import Wizard, Publishing Wizard), Business Objects XI R2 Integration kit with SAP, Crystal Professional XI R2 (Supervisor, Designer, Reporter), Business Objects XI R3.1, Oracle 10g/9i, Tomcat 4.0, Apache server 1.3, PL/SQL, Window 2003 Server/XP

Confidential, IL Sept ’05 to June ‘06
Business Objects Developer
Employee Repository Report Management
The projects scope is to develop reports for Employee Repository for their Human Resources Department. The project involved developing universes, building reports and co-ordinate with off shore team to ensure report synchronization. Interacting with end Users, to know their requirements and develop/modify Universe and Reports accordingly. Collaborated closely with client managers, architects, DBA's and business users. Helping in maintenance work related to reports.
Responsibilities:

• Interacting with end users, to know their requirements and develop/modify Universe and Reports accordingly.
• Collaborated closely with client managers, architects, DBA's and business users.
• Involved in the creation of Universes, Classes, Objects, and Hierarchies for Multidimensional Analysis for Production, Technical, and Human Resource departments of the company.
• Exported the universes to the Repository making resources available to the users.
• Developed various Table/ Cross tab reports, Developed Adhoc Reports on some universe.
• Worked on Canned reports with multiple sections.
• Build complex reports with free hand SQL, VBA, personal data providers with multiple data providers.
• Used features like ranking, alerters, user objects, UNION, INTERSECT, MINUS query operations.
• Declared complex formulae and local variables at the report level.
• Designed complex reports based on discussions with user groups and created various objects using built-in @functions (like @prompt, @select, @where, @aggregate), complex SQL queries and joins.
• Converted reports to external formats like PDF, txt, .CSV for further analysis and emailing as attachments.
• Involved in testing the database for the queries that are generated and handled the performance issues effectively.
• Responsible for troubleshoot/debug existing report/template objects and universes.

Environment: Business Objects 6.5.1(Supervisor, Designer, Reporter), Web Intelligence 6.x, ZABO, Broad Cast Agent, Oracle 8i/9i, Teradata,MS SQL Server 2000, PL/SQL and Windows 2000, UNIX.

Confidential, OH Dec'04 to Sept ‘05
Business Objects Developer
Pharmaceutical Distribution Report Management
The project was to create/maintain universes and to generate reports from the Pharmaceutical Distribution department Data warehousing databases. 
The project was to develop a Reporting system to generate annual reports and to monitor the customer's aging profile, customer transaction processing. Data is loaded to a central database from existing operational databases. 
Responsibilities:

• Involved in collecting the user requirements.
• Designed new universe and maintained existing universe according to the user requirements.
• Created and managed users/groups and assigned privileges using supervisor module.
• Created Multiple Universes in Designer using different databases like SQL Server, MS Access and DB2.
• Exported the universes to the Repository making resources available to the corporate users.
• Improved system performance in data access by fine-tuning SQL statements and joins.
• Created user specific classes and objects and maintained object level security at the designer level.
• Developed complex SQL code to enable user queries to the database for data access, using triggers.
• Involved in full life cycle of Business Objects reporting applications.
• Created Master-Detailed reports using Drill down/up functionality for the Decision Support System regarding the company’s products.
• Created complex prompts and conditions in the Universe using @Functions and CASE statements.
• Created complex reports using various functionalities as prompts, slice and dice, drill down, break, formulae, calculations, cross tab and master details.
• Created Webi Reports and deployed them using Info View.
• Trouble shooting and tuning of the Existing Reports.

Environment: Business Objects 5.1.5 (BO Reporter, Designer, Broadcast Agent, Supervisor, Web Intelligence 2.6, Info View), MS SQL Server, DB2 UDB, Windows 2000.