EXPERIENCE SUMMARY

• Over 7 years and 7 months of IT experience, as a SAP Business Object developer, in designing and developing reporting solutions using SAP BusinessObjects Business Intelligence
• Proficient in working on SAP tools Information Design Tool IDT , Universe Design Tool formerly Universe Designer , Web Intelligence Desktop and Web Client , BI launch pad formerly InfoView , SAP Crystal Reports, SAP BusinessObjects Dashboards 4.0 formerly Xcelsius , Central Management Console CMC Web Client , Query as a Web Service QaaWS and Live Office
• Experience in creating Production and Enterprise reports using Crystal Reports Standard, Cross Tab, and Mailing labels
• Expertise in creating the adhoc reports tabular, crosstab, forms and charts using Web Intelligence
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drill Down, Filters, Ranking, Alerts, Sections, Breaks, and Input controls for interactive reporting
• Proven abilities in creating complex Crystal Reports, involving sophisticated report formatting like multi-page, multi-query, pixel-perfect reports , by linking data from multiple data providers, using free hand SQL, stored procedures, sub reports and functionalities like Combined Queries, and Sub Queries
• Expertise in Designing Universes UNV for Ad-hoc query, canned reporting and analysis using the Universe Design Tool and resolving join path problems like Loops and Traps in the universes using Aliases, Contexts, and Aggregate Awareness
• Experience in using Information design tool, to create universes UNX by extracting, defining, and manipulating meta-data from multiple data sources Relational and OLAP
• Worked on SAP dashboard tool for data visualization and the creation of dynamic, interactive dashboards linking dashboards to BO Universes using QaaWS and Live Office
• Expertise in creating the file, and schedule events to publish and schedule the BI documents using BI launch pad
• Knowledge in configuring the groups and users for Business Objects deployment and managing user profiles for publishing reports
• Experience in creating the profile targets and profile values for publication report bursting , creating the Dynamic Recipients in CMC to email reports to users, outside BO Enterprise
• Strong Knowledge in designing and developing Data marts, Data warehouse using multi-dimensional Models as Star Schema and Snow Flake
• Experience in using databases like Microsoft SQL Server, IBM DB2 Mainframe and Z/OS , MS Access, and Oracle
• Experience in writing Stored procedures, Materialized Views, Triggers, Complex Queries, Sub Queries, and PL/SQL
• Knowledge of all the phases of SDLC, Agile Methodologies Lean and Kanban and V methodology
• Experience in creation of Functional, Technical Specifications and Test Cases
• Experienced in Training Supporting end-user reporting needs using Business Objects
• Excellent interpersonal, communication, presentation and strong Problem solving skills
• Capable of working a s a Team Member or Individually with minimum

TECHNICAL SKILLS

WORK EXPERIENCE

Current Employer: Confidential

Project 3: Producer Incentive and Compensation System PIC

Client: Confidential

Role: BOBJ Senior developer

Specific Responsibilities:

• Involved in daily stand-up, on each day of a sprint, to provide the development status updates to the users
• Managing the team of 5 members coordination with Offshore team on daily basis
• On-call support member for BI reports and PIC web application, and batch processes
• Involved in collecting new requirements Interacting with prospective clients to gather/analyze/size their analytical requirements
• Was involved in migrating reporting from COBOL mainframe to Web based Reports using Crystal Reports and Business Objects
• Worked on implementing the Star Schema dimensional model to design the facts and dimension tables
• Involved in creating and managing the Universes for Accounting and Contest users and provided the training to users on generating the simple reports
• Creation of adhoc, and interactive analysis reports/charts using Web Intelligence and the reports like Agents Commission Statement and other reports, having complex layout and required multiple sub reports, using Crystal Reports 2008
• Used Universe Crystal Reports as a Data source in SAP dashboard 4.0 to build the dashboards and scoreboards for Management team created Dashboard, Chat and Containers, Selectors using the dashboard's components
• Created/Managed events File and Schedule and customized calendar in Business Objects and scheduling the BI documents based on events
• Set up groups and users for Business Objects in QA and managed user profiles for publishing reports
• Created Profile target and profile values for publication report bursting
• Created Dynamic Recipients in CMC to email reports to the Agents, who are outside BO Enterprise
• Created/Managed programs to run batch files in Business Objects
• Modifying and performance tuning of the existing reports by optimization of SQL queries, removing sub reports in crystal reports, and using Aggregate awareness, and index awareness in Universe
• Performed Integrity Checks to Universes to detect loops, traps, cardinalities and joins
• Implemented and managed Row Level Security/Restriction in BO Universe
• Responsible to interact with QA testing team on a regular basis to make sure the reports are working as desired and make changes if required
• Responsible for providing the production implementation and post production support and supports QA BOE Administration
• Supported and worked on existing batch process development, using core Java.
• Monitor the enterprise daily and monthly Production and QA jobs of Project using BMC Control-M
• Working on migratin g the reports database from DB2 Mainframe to Distributed DB2

Environment: SAP Business Objects XI REL 3.1, Crystal Reports 2008, SAP Dashboards 4.0, IBM DB2 Mainframe and Z/OS v9/10, Distributed DB2 and JDK 1.6, spring Batch framework

Achievements:

• Rewarded Key to Success award under CSC's Rewards and Recognition program for passionately pursuing the assignments special recognition to display of Purposeful, Passionate and Ingenious key attributes
• Rewarded Certificate of Appreciation under CSC's Rewards and Recognition program for excellent and innovative handling of reports requirement and extract analysis
• Rewarded Certificate of Appreciation under CSC's Rewards and Recognition program for the outstanding contribution in Design and Analysis of Star Schema and PIC Fact tables
• Appreciations from clients for diligently and innovatively pursuing the assignments to completion

Employer: Confidential

Project 2: Global Material Control System GMCS

Client: Confidential

Role: BO developer

Specific Responsibilities:

• User Requirements elicitation to create a functional requirements document, external design, program specifications test cases document
• Involved in migration of Crystal Reports 8 to Crystal reports XI
• Creation, development and deployment of new Crystal Report, and Universes for simple as well as complex reporting requirements
• Optimization of SQL queries for better performance
• Developed stored procedures to replace application inline queries to efficiently processes and retrieve data
• Involved in migration Database from SQL Server 2000 to SQL Server 2005
• Design and develop the different types of report such as multiple Sub Reports within Main report, Cross Tab Reports, Standard Reports, OLAP Reports, Master Detail Reports and Barcode labels report
• Definition of universe connections and creation of new universes based on the requirements
• Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the Integrity of the Universes
• Created static and dynamic dashboard reports for higher management using SAP Xcelsius
• Created Objects to prepare various kinds of Reports e.g. financial reports, MIS reports, standard/ad-hoc reports, universes etc.
• Created WEBI vs DESKI reports and published reports back to BO using CMC and scheduled the reports
• Rectification of issues on existing reports e.g. issues with scheduling, connection, Server failures, CR viewer problems, Database connectivity problems etc.
• Database development including programming procedures and triggers in SQL Server 2005
• Drafting of Functional and GUI test case
• Used prompts, alerts, drill down analysis as per the end user requirement
• Provided user/system documentation, user training and testing of reports for final deployment
• Front-end development in Visual Basic 6.0

Environment: SAP Business Objects XI REL 3.1, MS SQL Server 2000 and 2005, Crystal Xcelsius and Crystal Reports XI