Summary of Qualifications

• Experience over 7 years in the field of Information Technology with the emphasis on Data Warehousing, BI, BW, Mobile BI, OLAP, ETL, SAP Business Objects Universe design and reporting module.
• Experience in various Business Domains like Finance, Insurance, Pharmaceuticals and Manufacturing
• Extensive experience inBusiness Intelligence ToolsusingSAP BusinessObjects XI R2/XI 3.1/4.0 Administration(Supervisor/CMC), Universe Design (Designer), Report development (Desk I/Web I), Info View, Import Wizard, Publishing wizard, Application Foundation, Performance Manager, Dashboard Manager,Broadcast Agent, Data Services, Crystal Reports and Xcelsius.
• Developed Crystal Reports (on demand, AdHoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-Down, Dynamic Grouping, Cross-Tab and Graphical).
• Experience in creating Dashboards and Business Presentations by importing data from Excel sheets using Dashboard Design (a.k.a. Xcelsius), QaaWS, Live Office, BICS and BIWS.
• Experience in SAP BW reporting working on different aspects of the presentation layer such as Business Explorer, Analyzer, Query designing, Filters, Variables, Conditions, broadcasting.
• Worked on various development platforms like Windows NT 4.0/2000/2003 Server/ XP/98/95, UNIX and RDBMS like Oracle, SQL Server, Informix, MS Access, Teradata, DB2 UDB and Sybase.
• Extensive experience and solid understanding of Data Warehousing, Data Marts, Star, Snow Flake Schema Modeling, Dimensional Modeling, Entity-Relationship Modeling, OLTP and OLAP concepts.
• Strong data analyzing experience for designing and implementing Universes using Business Objects Designer including gathering of report requirements from end users to developing test and usability cases.
• Experience in creatingDashboards,Metrics,Rules,AlertsandGoalsusingPerformance Manager (EPM) XIR2for useranalysis based on user requirements.
• Experience indeploymentof Business Objects Universes andreports from various sources likeOracle 8i/9i/10g, SQL Server, MS Access,Siebel, Excel, Sybase and Teradata
• Expertise in creation of simple/complex reports from various data sources likeUniverses, Free handSQL, Stored Procedures, Personal Data Files, XML Data Providers
• Verywell experiencedgood understanding of ANSI SQL,SQL,PL/SQL, My SQL,Stored Procedures, Functions, Cursors, Packages, Views and Indexes.
• An excellent team member with good interpersonal relations, strong communication skills and ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.

Education

• Bachelor of Engineering in Information Technology, Osmania University, India.

Professional Experience:
Confidential,
CA Sept ’11 to Current
Job Title: SAP Business Objects Developer

Description:
SAP - Apollo is a co-innovation initiative using mobility to connect retailers and manufacturers to consumers. It\'s a vision of taking mobile couponing to the next level, creating a personal "shopping assistant" that delivers contextual marketing information to consumers via mobile devices.

Responsibilities:

• Working on the software development life cycle of Business Objects Enterprise.
• Participate in Agile Scrum model software development life cycle.
• Worked closely with the Architect and supervised the team to ensure the implementation of Business Logic/Rules in the ETL Process.
• Designing Workflows and Data flows using Business Objects Data Services (BODS) to implement the conversion logic for Master Data and Transactional Data with large volumes of history data.
• Schedule and Monitor Batch Jobs using Data Services Management Console.
• Built and enhanced BW objects such as InfoObjects, InfoCubes, InfoSources/Data Sources, Master Data, Transformations, Update Rules, DSO, Extractors, Infosets, Aggregates, DTPs, User Exits.
• Created BEx queries for business users that are used for reporting.
• Analyze data for designing & implementing Universes using Business Objects Designer including gathering of dashboard requirements
• Involve and analyze creation of SAP BOBJ 4.0/XI 3.1 Web Intelligence Reports with different functionalities like cascading prompts, drill down, linking reports, charts and graphs, ranking, Scope of Analysis and alerts.
• Create complex reports in Web Intelligence using advanced functionalities like report level prompts, scope of analysis and ranking.
• Defining row level security at universe level as per user entitlements, enabling IT to create one report and make it available to global users based on their rights.
• Creating dashboards using Xcelsius to leverage interactive, reliable reporting and visually stunning, accurate dashboards.
• Integrating Query as a Web Service (QAAWS) and Xcelsius to convert the static presentations into dynamic and live visualizations
• Created multiple Flash variables in Xcelsius and used them to pass data from one dashboard to other.
• Imported data on to Xcelsius from XML extracts using XML data connector.
• Used Web Intelligence, Info View and reporter for querying, reporting and analysis of the tasks.
• Troubleshooting and debugging production issues, maintaining production systems around application and infrastructure outages, participating in development project teams as needed.
• Perform Unit Testing, System Integration testing based on the application and requirements.

Environment: SAP BOBJ 4.0 (Central Management Console, Web Intelligence, Universe Designer, Dashboard Manager), SAP BOBJ Dashboard Design (Xcelsius), Business Objects Data Services, QaaWS, SAP BW, SAP BI Modeler, SAP HANA, SQL Server 2008.

Confidential,
TX Feb ’11 to September ‘11
Job Title: Sr. Business Objects/Xcelsius Developer

Description:
SLM is a Service Level Management product/tool that is used to monitor KQIs (Key Quality Metrics) and performance targets against Service Level Agreements (SLAs) defined by the Texas Lottery Commission (TLC) . Along with monitoring, it is also used to manage the SLAs by defining thresholds that are more stringent than the Lottery to provide advance notification to GTECH and report these SLA violations based on the predefined reporting period set forth by the Lottery in form of weekly/monthly reports or per event/incident.

Responsibilities:

• Interacted with Business Users to know their business needs and effectively develop and modify Universes and Reports.
• Worked closely with the Data Architect Team to ensure the implementation of Business Logic/Rules in the ETL Process.
• Implemented System Development Life Cycle (SDLC) and Validation and Verification.
• Involved and analyzed in creation of SAP BOBJ 4.0/XI 3.1 Web Intelligence Reports with different functionalities like cascading prompts, drill down, linking reports, charts and graphs, ranking, Scope of Analysis and alerts.
• Created derived tables at the Universe level to satisfy the reporting needs.
• Created complex reports in Web Intelligence using advanced functionalities like report level prompts, scope of analysis and ranking.
• Defined row level security at universe level as per user entitlements, this enabled IT to create one report and make it available to global users based on their rights.
• Created complex Web Intelligence reports with calculation contexts and multivalve issues.
• Created Web Intelligence reports using Drill down functionality within different hierarchies.
• Integrated SAP BW with Business Objects and extracted data from SAPData sources
• Communicated to the client about Upgrading to SAP BW 7.02 for direct connection to SAP BW on Xcelsius.
• Worked on BEx Analyzer and BEx Browser.
• Imported data on to Xcelsius from XML extracts using XML data connector.
• Created multiple Flash variables in Xcelsius and used them to pass data from one dashboard to other.
• Implemented summary tables and performance tuning of the database objects to support a faster Xcelsius runtime.
• Interacted with the ETL and Database teams to create alternate views, indexes and summary tables as part of Performance tuning of the Universes
• Developed PL/SQL Packages, Procedures, Functions and Triggers for DB2 database and worked extensively on various database operations.

Environment: SAP BOBJ 4.0/XI 3.1 (Central Management Server, Web Intelligence, Central Management Console, Desktop Intelligence, Auditor, Import Wizard, Universe Designer, Dashboard Manager), SAP BW, Xcelsius 2008, DB2, ANSI SQL.
Confidential,
Alpharetta, GA Oct ’10 to Feb ‘11
Job Title: Sr. Business Objects Developer

Description:
­BizComp – Business Market Group (BMG) organization’s compensations system. It supports revenue based (Quarterly) and Unit based (Monthly) compensations. BizComp user interface provides easy access to create data setup for sales force in terms of Quotas, Weightings and Ramp etc.

Responsibilities:

• Interacted with Business Users to gather the requirements and Business logics/Rules.

• Designed Functional Specification for report creation based on the initial business requirements.
• Integrated Query as a Web Service (QAAWS) and Xcelsius 2008 to convert the static presentations into dynamic and live visualizations
• Developed Web Intelligence Reports which involved complexities like linking, and multiple data providers
• Created Drop Downs, List boxes in dashboards (Xcelsius 2008) providing User Selection.
• Involved in using Xcelsius to transform Microsoft Excel spreadsheet data into interactive Flash media files.
• Managed users and groups and also defined the security in Enterprise XI 3.1 using CMC

• Administered Crystal Reports (along with their copies in different folders) in CMC and scheduled them as required by the user wherever required
• Responsible for writing SQL queries to validate the data in the UAT phase.
• Comprehensively Unit Tested and Documented the results for each report.
• Mentored the team in various issues related to Universe designs and Report Development.

Environment: SAP Business Objects XI 3.1/ R2, CMC, Designer, Desktop Intelligence, Web Intelligence, Import wizard, Crystal Reports XI, Xcelsius 2008, Oracle 10g, DB2, SQL Server 2005, TOAD.
Confidential,
TX Jul ‘10 to Oct ‘10
Job Title: Sr. Business Objects /Xcelsius Developer

Description:
SECO – State Energy Conservation Office. The mission of the State Energy Conservation Office (SECO) is to maximize energy efficiency while protecting the environment. SECO administers and delivers a variety of energy efficiency and renewable energy programs that significantly reduce energy cost and consumption in the institutional, industrial, transportation and residential sectors.

Responsibilities:

• Interacted with Business Users and Business Analysts to gather the Requirements and Business logics.
• Actively participated in Data Modeling team meetings and helped in generating the star schemas required for reporting.
• Successfully migrated from SAP Business Objects XI R2 version to Business Objects XI 3.0
• Installed & Configured BO Enterprise XI 3.0 on Windows 2003 server
• Successfully imported Business Objects Universes, Users and user groups from Version R2 to Version XI 3.0 using the Import Wizard and migrated full-client reports to Web Intelligence reports using the Report Conversion Utility
• Created standard reports, cross-tab reports, Mailing reports & OLAP reports.
• Sourced data from SAP Business Warehouse and Operational Data Source
• Used BODI tool to ensure integrity of data, maximize developer productivity, and accelerate data integration performance
• Extracted data from legacy systems and transformed the data, loaded into the Data warehouse (Marts) using Data Integrator.
• Managed Production, Test and Dev environments including installation of service packs and access controls
• Extensive reporting was done using Business Objects functionality\'s like Slice and Dice, Drill Down, Cross Tab, Master Detail, Alerters, calculation contexts etc
• Defined Metrics, Rule, Alerts, Analytics and Created Dashboard using Dashboard Manager.
• Worked on Xcelsius to transform Microsoft Excel spreadsheet data into interactive Flash media files.
• Created Logical and Physical models for Staging, Transition and production Warehouse using Erwin 3.0
• Worked with the ETL team to create Automated Daily Load Status Check reports to validate the data between source and target data marts.
• Performed ETL operations with Data Integrator and extracted data from Flat file and XML file.
• Created customized LOV’s and cascading prompts for easy access to business users
• Created customized Shipment Scan Dashboards
• Created reports using Desktop Intelligence, Web Intelligence and distributed these reports using corporate documents
• Troubleshooting and fixing issues in existing Business Objects/Crystal Reports applications.
• Create and manage tickets with Business Objects Technical Support to track and resolve technical issues

Environment: SAP Business Objects XI 3.0/R2 (Desktop Intelligence, Web Intelligence, Central Management Server, Central Management Console, Auditor, Import Wizard, Universe Designer, Dashboard Manager), SQL Server 2005, ANSI SQL, Xcelsius 2008/4.5, Erwin 3.0, SQL Tools SQL Advantage.
Confidential,
NY Mar ‘10 to Jul ‘10
Job Title: Sr. Business Objects /Xcelsius Developer

Description:
B-SMART isMasterCard’sbusinessSalesManagementAndReportingTool. It is the central repository for customer management related data including account plans, forecasts, call reports, agreement compliance templates, etc. b-SMART has been designed to tightly integrate with the other sales tools and complement their functionality to provide a comprehensive approach to customer relationship management.

Responsibilities:

• Interacted with business users, business owners to know their Business views in developing, modifying universes and report development.
• Analyzed the existing database and created/modified the Universes using Business objects Designer Module.
• Created new Classes, Objects and Conditions. Detected Cardinalities and Loops. Resolved the loops by creating Aliases and Contexts and checked the Integrity of the Universes.
• Exported the universes to the Repository to make the resources available to the users.
• Used the functionality of linking universes so as to have the flexibility to use the objects defined in one universe in another.
• Created standard Full Client and Web I reports based on business requirements with drill down functionalities.
• Reports were formatted according to the user requirements using Business Objects functionalities like Breaks, Calculations, Slice and Dice, Drill Down and Variables.
• Organized data in the reports using Filters, Sorting, Ranking and highlighted data using Alerter.
• Managed the Servers using the Central Configuration Manager (CCM).
• Responsible for setting up the Users/Groups, assigning the privileges to the Users using Central Management Console (CMC).
• Used Import wizard to import existing User accounts, Groups, Categories, Universes, Web I Reports, Connections and Universe restrictions to BO XI R2 environment.
• Created complex reports in Web Intelligence and Desktop Intelligence using advanced functionalities like report level prompts, scope of analysis and ranking.
• Created Web I reports with multiple data providers and synchronized the data using Merge Dimensions option in BO XI R2.
• Linked reports using Open Document syntax to link master report to a detail report by creating hyperlink objects in the Universes and Reports.
• Created Crystal reports using Business Views and Universes as data providers.
• Created new Universes specifically designed for creation of Dashboards.
• Responsible for creating Dashboards, Metrics, Rules, Alerts and Goals using Performance Manager (EPM) XIR2 for user analysis based on user requirements.

Environment: SAP Business Objects XIR2(CMC, CMS, CCM, Designer, Desktop Intelligence, Web Intelligence, Info View, Performance Manager, Dashboard Manager, Import Wizard, Scheduler Manager), Crystal XI, Oracle 9i, SQL Server 2000, TOAD, SQL, PL/SQL, Windows 2003 Server.
Confidential,
TX Mar’09 to Mar ‘10
Job Title: Sr. Business Objects /Xcelsius Developer

Description:
The Comptroller is the chief steward of the state’s finances, acting as tax collector, chief accountant, chief revenue estimator and chief treasurer for all of state government. The Unclaimed Property Division of the State Treasury was merged into the Comptroller\'s Office, after Texas voters approved a constitutional amendment which officially dissolved the State Treasury as an agency and placed all its functions under the State Comptroller.

Responsibilities:

• Involved in Full project life cycle (requirement gathering to implementation phase) and gathered requirements for Business Objects Universe to support Ad hoc report needs and report requirements for Standard Reports from the users.
• Created mock-up reports for initial user presentation in the process of designing Technical Specifications.
• Implemented Row/Object level restrictions according to different Business group requirements.
• Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.
• Developed custom hierarchies to support drill down reports for in-depth analysis.
• Created complex reports using user defined functions and condition objects.
• Generated Business Objects Reports by using Free Hand SQL as a data provider when universe did not contain necessary data.

Migration BO6.5.1 to BOXIR2:

• Involved in migration from existing 6.5.1 systems to BO XIR2 in Development Environment.
• Imported Users/Groups, documents (Web I and Desk I), Universe, Document, and folders and objects using Import Wizard.
• Added/deleted, enabled/disabled various BO servers using Central Configuration Manager.
• Created users/ groups and defined their roles and set privileges using the CMC.
• Created universes XIR2 and applied Row-Level and Object-Level security on different groups and users.
• Created reports using Desk I, Web I from multiple Data providers and used the merge dimension option to synchronize the Data in Web I reports.
• Used the schedule manager to schedule reports in the Web I module of XIR2.
• Developed Business Views and exported Business Views to repository and created Crystal Reports in Business Objects XIR2 for better format and presentation.

Environment: Business Objects 6.5.1( Supervisor, Designer, Info View), SAP BO XIR2 (CMS, CMC, Designer, Desk I, Web I, Import wizard, Scheduler Manager, Report Conversion Tool), Broadcast Agent 6.5.1, Crystal Reports XI R2, Oracle 9i/10g, MS SQL Server2000 and Windows 2003 Server.
Confidential,
IL Jan ’08 to Feb ‘09 Job Title: Business Objects Developer

Description:
Bank ORION provides the multiple banking products for online applicants, associates via the Online Banking Channel. Multi-product Decision Engine is developed to build a common and dynamic application interfaces to allow applicants to select, apply and receive a decision for multi banking products Deposits, Credit Cards, CRE Mortgagee, Brokerage accounts for various delivery channels E-Commerce, Banking center and partners site without the need to re-key information nor visit the individual product applications.
Responsibilities:

• Participated in gathering functional requirements and data specifications.
• Designed universe for standard reporting and ad hoc reporting requirements.
• Involved in developing both static and dynamic reports.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops, checked the Integrity and exported universes to Repository.
• Analyzed Data using Slice and Dice and Drill Mode, etc. and Formatting Reports
• Created Master/Detail Reports, Cross-tabs, Matrix and Charts etc
• Controlling Reports data by working with Universe and queries. Using Filters, Sorts and Rankings.
• Implemented row level restrictions according to different business group requirements.
• Created complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Responsible for maintaining the development, testing and production repositories and providing round the clock support during the production stage.

Environment: Business Objects 6.5 (Designer, Reporter, Web Intelligence, Broadcast Agent), TOAD, Visual Basic, SQL-sever 2000, Oracle 9i, UNIX, Windows 2000 server.
Confidential,
CT Apr ’06 to Nov ‘07
Job Title: Business Objects Developer

Description:
Sparta Insurance is a leading Insurance company with large client base and huge volumes of data for so many years. This project is intended to bring up their reporting application using Business Objects. Data extraction is done from various data sources, compiled into one standard format in oracle EDW (Enterprise data Warehouse). Reports are generated from this data source and distributed through the corporate Intranet. Some of the reports are being sent to high profile agents in various file formats for their lead generation processes.
Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects universes and reports.
• Involved in creating repository and setting up of groups and users for Business Objects users.
• Scheduled the Web Intelligence reports using Info View.
• Designed and built universes, classes and objects.
• Created Cardinalities, Contexts, Joins and Aliases for resolving loops and checked the integrity of the universes.
• Created hierarchy and conditions at the designer level.
• Exported the universes to the Repository to making resources available to the users.
• Involved in creating reports on the web using Business Objects Web Intelligence
• Created the reports using Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Functions and Master Detail etc.

Environment: Business Objects 6.1, Designer, Web Intelligence 2.7/Info View, Oracle 9i, SQL, SQL*Plus, UNIX, Windows NT/2000.
Confidential,
India Jan ’05 to Mar ‘06
Job Title: Database Analyst

Description:
The project is for development of Medical Services Administration, an MSA payment which mainly works for the clients of the health department where in they have to produce their bills for the reimbursement for traveling, car rental, lodging, this resulted in developing a system to keep track all of the payments using Oracle 7.3, Forms 4.5 and Reports 2.5. This application encompassed the equipment and software modules along with the relevant modules like the location, description and status codes.

Responsibilities:

• As an Oracle implementation team member, worked on writing custom forms and custom tuning the reports.
• Interacted with the end user to prepare system requirements.
• Worked as a technical support for a team that involved technical & quality reviews of program codes and PL/SQL blocks for optimization and maintaining standards & guidelines.
• Coded the Servlets for carrying user inputs and accessing the corresponding EJB.
• Developed and tested test cases for Java classes written using JUnit.
• Used Core Java for File Manipulation.
• Developed Database Triggers in order to enforce complicated business logic and integrity constraints, and to enhance data security at database level.
• Developed Custom forms to view edit the data in custom interface tables and event handling tables using template forms.
• Completed database architecture including developing stored procedures and functions in order to create shortcuts to frequently repeated tasks.
• Supported technical teams involved with Oracle issues and operations.

Environment: Oracle 8i, Developer 2000, Forms 4.5, Reports2.5, Java/J2EE, SQL, PL/SQL, Windows NT Client/Server.