We provide IT Staff Augmentation Services!

Sr. Business Objects Developer Resume

WA

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,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

Confidential,Bloomington, IL Apr 08-May 09

Sr.Business Objects Developer
ICRS (Insurance Credit Response System)

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.

Confidential,Milwaukee, WI Aug06 – Mar 08 Business objects Developer CCM (Commercial Contract Management)

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.

Hire Now