Summary:

• Business Object Developer with over 8 years of experience in implementing Full Cycle data warehousing from requirement gathering, designing, scheduling, developing and implementation using Business Object suite, and demonstrated abilities to analyze problems, respond to changing needs and forge strong working relationships with the peers.
• Over 4 years of extensive experience as Crystal Xcelsius Developer in creating highly interactive, user-friendly Dashboards and Scorecards.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX and Windows NT/2000/XP/98.
• Strong Advanced reporting skills in different industries including Education, Insurance, Banking, Healthcare and Automobile.
• Expertise in Designing/Developing the BO Universes, Ad-hoc/Canned Reports, Complex Reports using predefined conditions as well as Business Objects Full Client & Thin Client reports.
• Mastery in Import Wizard and Report Conversion Tool for migrating the Universes and Reports between different environments like Development, QA and Production.
• Extensively involved in Migrating the Universes and Reports from BO6.5 to BOXIR2/3.1.
• Immense experience in setting up Aggregate Awareness to enhance the performance of SQL transactions.
• Good Knowledge of Data Modeling using Entity-Relationship Model, Dimensional Data Modeling using Star schema and snow flake schema.
• Experience in creating several reports with Business Objects functionalities like Breaks, Alerts, Filters, Sorts, Query Prompts and Drill filters.
• Highly efficient in creating dashboards using dashboard manager and Crystal Xcelsius 2008 using Query as a Web Service (QAAWS) and Live Office.
• Strong Working Experience in HP Project and Portfolio Tracking Tool (PPM).
• Extensive experience in Scrum and Sprint environments.
• Knowledge of Informatica tool to design the source definition, target definition and transformations to build mappings.
• Ability to adapt to fast changing skills and work, able to work in-groups as well as independently with minimal supervision.
• Excellent Technical, Communication and Interpersonal Skills and Quick learner.

Technical Skills:

Languages : SQL, PL/SQL, C, C++
Databases : Oracle 8.x/9.x/10.x, MS SQL Server 2000, MS Access
Operating Systems : Windows (98/NT/XP), UNIX (Sun Solaris, AIX), LINUX, MS DOS
Reporting Tools : Business Objects 6.x/ Xi R2/ R3/R3.1, Universe Designer, Desktop Intelligence, Web Intelligence, Infoview, CMC, Crystal Enterprise 8.5/9.0, Crystal Xcelsius2008, 4.5.
Other Tools : Toad, SQL * plus, SQL Loader, HP PPM
Web Designing : HTML/ DHTML, Ms Office, Adobe Photoshop

Educational Qualification:

• Bachelors of Technology in Computer Science

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA Oct 11-Till Date
Sr. Business Objects Developer (Crystal Xcelsius)
NTD Projects Performance

The team here at the AT&T headquarters, keeps track of all the projects and performances of all the Project Managers throughout the country. The team uses the HP Project and Portfolio Tracking tool to manage the requests from different business users. The aim of this project is to develop reports and Dashboard that deal with Week over Week, Month over Month comparisons of Network and Project Health/status for all the Technology types, viz. Wireline, Mobility, Non-mobility, U-verse etc and with the performance of PMs, project cycle time. This Project mainly deals with Milestones (Decision Gates) in the Project Life Cycle. And shows how close the Actual milestone dates are with respect to the Forecast dates.

Responsibilities:

• Gathered the requirements from Business Users to build the reports and Dashboard by interacting with the various users regularly to identify the KPIs.
• Maintained the existing reports and scheduled them as per the demand of the Business users.
• Worked on the HP Project and Portfolio Tracking Tool (PPM) and HP Project Management and Tracking Tool (PMATT) to deal with the requests (PSRs) of various business users and made those changes required on the reports. Also dealt with all the report related issues requested on PMATT.
• Moved existing reports, Data-Providers/Queries from old Universe to new universe.
• Developed DESKI and WEBI reports which shows the different Milestone Dates and Average Number of Days for multiple Projects for Month-over-Month Comparisons.
• Identified the Outliers and removed those from the report to maintain consistency in the average number of days throughout the Year.
• Used Macros to enlist all the reports, their Data-Providers/Queries, universes used, Object Names and Class Names and documented them for reference.
• Integrated Crystal Xcelsius 2008 with Business Objects Universe using QAAWS.
• Developed highly Interactive Dashboard called ‘NTD Project Cycle Time’ completely based on dynamic user input.
• Wrote multiple new formulae at the universe level and query level to meet the changing requirements.
• Created users and groups and Implemented the security at row level and user level.
• Tested the reports and validating them by comparing with the results on the PMATT.
• Refreshed the Monthly Metrics and scheduled the reports to be refreshed on daily/weekly basis and send those refreshed instances to the users through the scheduled emails.

Environment: Business Objects (BOBJ) XI R3.1 Enterprise, XCELSIUS 2008, QAAWS, Live Office, WEBI, DESKI, HP PPM, PMATT, Oracle 10g, Microsoft Visio, Access 2000, Windows XP

Confidential, Frankfort, KY Oct 10 - Oct 11
Sr. Business Objects Developer (Crystal Xcelsius)
Strategic Agenda & Planning

The Council develops a strategic plan for Kentucky's postsecondary system which includes campus action plans for each public postsecondary institution and the Association of Independent Kentucky Colleges and Universities. The Council produces and submitsannual accountability reports to the Governor and the Kentucky General Assembly on the postsecondary and adult education system's progress toward meeting the goals of House Bill 1. The process will involve an assessment of the current strengths and challenges faced by the system, an analysis of the effectiveness of the public agenda, and the development of statewide and institution goals, implementation strategies, and performance metrics for the education and economic objectives articulated.

Responsibilities:

• Involved in the requirements gathering and Business logics from Business Users and prepared Business Requirements Document (BRD) and technical documents.
• Worked with the design team to create new report designs as per changing user requirements.
• Modified existing reports to meet user requirements.
• Exclusively Used QAAWS, Live Office, XML mappings as per the Dash board requirements.
• Did QAAWS Sizing on the servers to perform the Queries run fast and display the dash boards.
• Created multiple Flash variables in Xcelsius and used them to pass data from one dashboard to other.
• Involved in designing Aggregate Universe for all the Dashboards.
• Linked different WebI Reports from dashboard to Infoview.
• Developed Dashboard for upper level management using Crystal Xcelsius.
• Developed various Charts and Graphs like Bar Chart, Pie Charts, and Line graphs scatteredchart.
• Used Web Intelligence for web based query and reporting.
• Developed Reports with parameters based on data using Crystal Reports XI.
• Exported reports into various formats like PDF, HTML, and EXCEL by using WebI Reports.
• Generating reports on the performance of different partners considering different factors involved.
• The reports are generated on ad-hoc basis and also periodically on monthly, quarterly and annual basis.
• Publishing and Scheduling WEBI Reports in Infoview environment using BOE.

Environment: Business Objects (BOBJ) XI R3.1 Enterprise, XCELSIUS 2008, QAAWS, Live Office, WEBI, DESKI, Oracle 10g, Microsoft Visio, Access 2000, Windows XP

Confidential, Lincolnshire IL, May09-Oct10
Sr. Business Objects Developer (Crystal Xcelsius)
Retail Analytics

Walgreens provides mail service pharmacy, Retail drugstore and specialty pharmacy and home care services. Retail Analytics application defines Store wide sales information to higher level executives (Retail Mangers and VP levels) in Walgreens. Application is used by Business users to check the Pharmacy and retail sales information on a day to day basis. Retail Analytics also provides insight information about sales and drugstore information to managers and provide in time Dashboards for higher level executives. Application is a package of both Dashboards and WEBI reports.

Responsibilities:

• Worked with the design team to create new report designs as per changing user requirements.
• Created dashboards using Xcelsius 2008 to leverage interactive, reliable reporting and visually stunning, accurate dashboards.
• Integrated Query as a Web Service (QAAWS) and Xcelsius 2008 to convert the static presentations into dynamic and live visualizations.
• Created classes & Objects in designing the Universes, Importing/Exporting the Universe from/to repository to make it accessible to end users.
• Linked universes using kernel, and master approaches to share the common components.
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerter. Extensively used Supervisor Module for Managing user groups and users.
• Involved in the requirements gathering and Business logics from Business Users and prepared Business Requirements Document (BRD) and technical documents.
• Modified existing reports to meet user requirements.
• Exclusively Used QAAWS, Live Office, XML mappings as per the Dashboard requirements.
• Provided End-User training on Xcelsius Dashboards & Webi reports.
• Created multiple Flash variables in Xcelsius and used them to pass data from one dashboard to other.
• Did QAAWS Sizing on the servers to perform the Queries run fast and display the dashboards.
• Involved in designing multiple universes for reporting and dashboarding needs.
• Linked different WebI Reports from dashboard to Infoview.
• Developed Dashboard reports for each region for upper level management using Crystal Xcelsius and published them on Infoview.
• Generating reports on the performance of different partners considering different factors involved.
• The reports are generated on ad-hoc basis and also periodically on monthly, quarterly and annual basis.
• Publishing and Scheduling WEBI Reports in Infoview environment using BOE Scheduler in CMC.

Environment: Business Objects (BOBJ) XI R3.1 Enterprise, XCELSIUS 2008, QAAWS, Live Office, WEBI, DESKI, Oracle 10g, Microsoft Visio, Access 2000, Windows XP

State Farm Insurance is one of the oldest Insurance farms in the United States. The company uses Business Objects to power its Business Intelligence need through the extensive intranet setup. This system was built with an objective to help top-level management in decision making. I was involved in design, development and managing Business Intelligence (BI) solutions using Business Objects.
Responsibilities:

• Liaison with Business users to finalize the requirements and charting the business processes in to build the reporting application using Business Objects suite.
• Involved in creation of Universes, Classes, Objects and Hierarchies for multi dimensional analysis of database using Business Objects XI 3.0 for technical and sales departments.
• Worked extensively on modules CMC, Designer, Web Intelligence and Info view.
• Used @functions to create predefined conditions and prompts to filter the data and dynamic user selection.
• Prepared complex ad-hoc reports and canned reports using user defined functions and condition objects.
• Worked with the business users from different lanes to gather Systems requirements and data requirements.
• Study and understanding the Business Scenarios of the existing systems, understanding the data and validating the data by applying the current business rules.
• Involved in designing Credit Summary dash boards for higher level executives in State Farm using Crystal Xcelsius 2008/4.5.
• Used Crystal repository for reusability of formulas.
• Responsible for Designing reports and present Mock-ups to the users.
• Created test cases based on requirements and mapping for ETL and Reports.
• Developed several reports with consistent drill-down functionality including Drilldown Reports, Summary Reports and Master Detail Reports.
• Developed Custom Functions, Manual Running Totals, and Complex Formulae for Reports.
• Created variables and defined formula to capture user responses to a prompt and to display document information for WebI reports.
• Trained the users in viewing/scheduling the reports using the Info view.

Environment: Business Objects (BOBJ) XI R2 Enterprise, XCELSIUS 4.5 / 2008, QAAWS,
WEBI, DESKI, Oracle 10g, Windows XP.

Business objects Developer

This project gives the Contract Information of Products sold by GE. Custom reporting package for Sales information about GE products across different regions. Customized the existing universe and built new objects for custom reports.

Responsibilities:

• Understanding business requirements and preparing System Requirement Specifications.
• Involved in writing validation documents as per system requirements.
• Involved in writing validation docs as per Pharma industry Standard.
• Involved in Designing Sales reports, Submission reports, listing reports.
• Created extended universes for Report writer universe and customized the universe as per business needs for drug safety.
• Involved in Migrating reports from Custom based Java application to CCM Environment using SDK.
• Involved in writing unit test cases for Data validation.
• Involved in writing report requirements for CCM Application as per GE Standards.
• Used Webi as the interface to build the Drug Safety reports.
• Involved in Migrating reports from different environments (QA, Dev, and PROD).
• Involved in design of Technical Architecture, Data modeling and preparing ETL specifications.

• Involved in requirement gathering from Business users, Responsible for understanding end user requirement and convert into functional requirement and involved in Designing reports using Business Objects XI/R2 WEBI.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and the requirements of the end users.

Environment: Business Objects (BOBJ) 6.5/R2, WEBI, DESKI, Oracle 8i , Microsoft Visio, Access 2000, Visual Source Safe 6.0, Clear quest, Windows XP.

Business Objects developer Oscar Reporting - Global Supply Chain

Involved in Designing and developing a tool for the Endovascular Planning process that will collect data from multiple global sources and organize it in a manner that will enable the Global Supply Chain to prepare S&OP documentation, standard reports for tracking day to day business operations, and dynamic queries to assist in making business decisions. Data generated by the application could be used to update product mix in QAD, as well as providing reporting for Marketing, Manufacturing, and R&D.
Responsibilities:

• Involved in Designing Pipeline reports, Build Plan reports, Demand Plan reports and Inventory Reports.
• Involved in the collecting requirements, Interacted with prospective clients to gather their analytical requirements, which are very important to customer.
• Responsible for understanding end user requirement and convert into functional requirement and involved in preparing project plan.
• Designed, developed, maintained and tested universes for supporting ad hoc queries and canned reports according to the business requirements.
• Involved in migrating Business Objects 6.1 version to 6.5
• Designed hierarchies in universe for various reports and created user objects with calculations in universe
• Responsible for the Designing classes and objects by using the Business Object Designer
• Scheduled and monitored reports using Broadcast Agent (BCA).
• Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.
• Developed Reports with Analytics Alerts.
• Used various data sources namely Oracle 9i/8i,Sqlserver
• Worked extensively with SQL*Plus, TOAD for writing user defined queries, stored procedures, views, tables, Indexes and constraints

Environment: Business Objects (BOBJ) 5.1/6.5, Oracle 9i, TOAD, Microsoft Visio, Access 2000, MS SqlServer 2000, SQL Server Management Studio, TSQL, Visual Source Safe 6.0, Windows XP.

Glaxo Pharmaceuticals is one of the leading pharmaceutical companies in India. This company manufactures pharmaceutical products for human and veterinary use. The Project was mainly aimed to create a reporting infrastructure for studying and maintaining the sales variation and inventory of different products.

Responsibilities:

• Worked very closely with upper management to get detailed information on what information they require in each report.
• Created Universes, Reports, and Linked with existing Universe, Resolved Loops and Traps.
• Created Daily, Weekly, Biweekly and Monthly drill down reports using Business Objects.
• Trained business users to use Web Intelligence to create ad-hoc reports as well as view existing published reports.
• Scheduled reports using Broadcast Agent for refreshing.
• Tested the project on Business Objects 5.1 to make sure that it still functioned correctly.

Environment: Business Objects (BOBJ) 5.1.2, Web Intelligence 2.6, Windows 2000, SQL, Oracle 8.i, BCA.