SUMMARY

• Working as Sr. Business Objects consultant in Confidential .
• Around 8+ Years of experience in developing reporting solutions for Healthcare, Telecom, Financial, Manufacturing industries.
• Developed dashboards using Crystal Xcelsius 2008 using QAAWS and Antivia XWIS 2.5.
• Worked extensively in developing and implementing report solutions on Business Objects 4.0, XI 3.1, BOXI R2, Crystal Reports XI R2, Web Intelligence XI, and Business Objects Universe Designer.
• Working Knowledge in Tableau Version 9 / 8.1
• Act as a subject matter expert and technical lead for the BI reporting projects and support
• Involved in requirements study and analysis of the system.
• Worked on BI project work plan by creating Reporting Strategy and Vision; Creating requirement traceability matrices, fit gap analysis, data element matrices, and functional, technical, and interface design specifications.
• Extensive experience in interacting with end users (Business and technical users) to understand the report requirements,feasibility check for requirements, making necessary changes to schema objects to fulfill reporting needs, prepare POCs on the same and present it to users, get feedback from users and communicate the requirements in the team, verify the deliverables before delivering it to client.
• Expertise in designing Universe, migrating to different environments, designing WEBI documents and maintaining them on Business Objects 4.1
• Developed reporting solutions using @Agreegate Aware, Index Awareness, contexts, traps, loops,@Prompt, multiple DPs, hiding and un - hiding of blocks, Customize LOVs, alerter, Sections etc..
• Extensively used Dynamic Visibility feature in Xcelsius Dashboards to conditionally hide and un-hide components.
• Experience in interacting with business users on multiple projects.
• Active member of the Organization’s Knowledgebase group, involved into conducting the trainings/reviews for new joiners
• Experience in managing the resource’s skill building, utilization, task allocation, monitoring, and project planning with effort estimation and mentoring team, making sure they are learning/growing and contributing in to the project.
• Active team player and as an individual with Excellent Communication, Interpersonal skills, self motivated fast learner and good listener.

TECHNICAL SKILLS

Operating Systems: Windows 2000/NT, Solaris 8/9.

Languages: C,SQL

Reporting Tools: Business Objects XI 4.0,3.x, BOXI R2, Dashboard Design 4.0/Xcelsius 2008, Crystal Enterprise XI R2

ETL Tools: Informatica 7.1.4/8.1, Data Integrator

RDBMS: Sybase ASE 12.5/15.0,Oracle 9i,10g, SQL Server 2000, MySQL

PROFESSIONAL EXPERIENCE

Sr. Business Objects Consultant

Confidential, New York, New York

Responsibilities:

• Working as Senior BO Consultant, supporting various function areas within HR division such as ER, LMS, GLD, Campus recruiting.
• Develop and Support Xcelsius dashboards and reports based on Headcount, Hires, Attrition, Compensation, and Employee Relations.
• Developed Recruiting Dashboard using Xcelsius 2008, Crystal Reports 2011 which gives information on Total Number of Campus Hires Across All division, Region and Year.
• Received training sessions on Tableau Desktop and started working on some POC's using Tableau.
• Prepare and analyze the business performance dashboard for different stakeholders and sharing the same with the business management team.
• Work with Business Partner Solutions across divisions and provide reporting solutions which can be used globally and be consistent across firm’s other reports.
• Partner with HCM IT and HCM Business Partner Solution Team to perform data mining, validate and format quantitative data sets to measure different performance metrics across all division and overall firm’s performance which may affect the revenue.
• Design and automate processes for data capture, tracking, and reporting.
• Support creation of Monthly/Weekly HCM reporting deliverables including Headcount, Hires Dashboards, Attrition Trend analysis, Growth & Variance analysis.
• As a Team Lead, work with team of Analysts and Developers in US and Bengaluru office to work on different projects, guide developers on some of the complex requirements, review the report development before releasing them to Business.
• Interacting with end users (Business and technical users) to understand the report and Dashboard requirements, feasibility check for requirements, prepare POCs on the same and present it to users, get feedback from users and communicate the requirements in the team, verify the deliverables before delivering it to client.
• Prepared test case documents for BO XI 3.1 to 4.1 migration activity.
• Development, enhancement & unit testing of universe and Reports using Business Objects BO 4.1 as per the Client Requirements Performing enhancements for the change requests raised by the business and IT team on priority basis and helping them in their queries.
• Worked on the critical & important reports in terms of client’s business as well for implementation in BO with workarounds; report performance optimization and etc.
• Performed Quality check for the development performed by Offshore Team before being delivered to QA environment.
• Prepared UTC Document for all the development/Enhancement document and submitted the same to QA team in order to help/Understand the QA team about the new development/enhancement.
• Responsible for release management for the Universe and Reports from DEV to QA and then to PROD Environment.
• Guided team to develop universe user documentation guide and report definition document guide for the end users reference.
• Responsible for provide knowledge transfer to new comers in the projects; project KT for lateral joiner and BO training with KT for learners/fresher.

Environment: BO 3.1/4.1, Xcelsius Dasboard 2008/Dashboard Design 4.0, Crystal Report 2011 SQL Server 2008, Tableau Desktop (8.1)

Sr. Business Objects Developer

Confidential, Feanklin Lakes, New Jersey

Responsibilities:

• Interacting with end users (Business and technical users) to understand the report and Dashboard requirements, feasibility check for requirements, prepare POCs on the same and present it to users, get feedback from users and communicate the requirements in the team, verify the deliverables before delivering it to client.
• Prepared test case documents for BO XI 3.1 to 4.0 migration activity.
• Developed 4 Xcelsius Dynamic dashboards using Antvia XWIS 2.5
• Successfully developed 2 static Xcelsius Dashboard with 5 levels of drills and number rows around 35000.(SAP recommended number rows is only 512 for Static Dashboard)
• Provide training to End user on Xcelsius Dashboard.
• Development, enhancement & unit testing of universe and Reports using Business Objects BO 4.0 as per the Client Requirements
• Performing enhancements for the change requests raised by the business and IT team on priority basis and helping them in their queries.
• Worked on the critical & important reports in terms of client’s business as well for implementation in BO with workarounds; report performance optimization and etc.
• As an Onsite/Technical lead responsible for development of 8 Universe for 6 different Applications and almost 300+ reports which spanned across 4 years.
• Performed Quality check for the development performed by Offshore Team before being delivered to QA environment.
• Prepared UTC Document for all the development/Enhancement document and submitted the same to QA team in order to help/Understand the QA team about the new development/enhancement.
• Responsible for release management for the Universe and Reports from DEV to QA and then to PROD Environment.
• Guided team to develop universe user documentation guide and report definition document guide for the end users reference.
• Responsible for provide knowledge transfer to new comers in the projects; project KT for lateral joiner and BO training with KT for learners/fresher.
• Creation of technical documents through active coordination with the team.
• Creation of technical documents through active coordination with the team.
• Used extensively Antivia components such Antivia Table, Antivia Cross Tab, Antvia Offline component.

Environment: BO 4.0/ XI 3.1,Xcelsius 2008 using Antvia XWIS 2.5, Oracle

Business Objects Consultant

Confidential

Responsibilities:

• Interaction with Product Managers, Project Manager and engineering team to understand requirement.
• Provided guidance to team member while developing logics.
• Guided team member in discussion while freezing requirements.
• Used aggregate aware functionality in universe for switching tables at query runtime.
• Used Multiple data providers, auto merge dimension and query on drill functionality as a workaround to cater clients requirement.
• Provided the security access management by creating users/groups and folders.
• Regular backup of BO development (biar) and BO repository which was on MySQL database.
• Developed test cases and data validation documents.
• Guided team to develop universe user documentation guide and report definition document guide for the end users reference.
• Installation of BOXI 3.1 on windows XP and Solaris.
• Involved in knowledge transfer process. Technical - Report development & Database schemes Functional- Business environment & processes
• Developed new reports using optional prompts and cascading prompts.
• Performed enhancements in already developed reports.
• Used Index aware functionality to improve the performance of reports.
• Implemented many workarounds and molded functionality of WEBI and Universe level functions to cater client’s requirements.
• Provided the security access management by creating users/groups and folders.
• Regular backup of BO development (biar) and BO repository which was on MySQL database. Developed test cases and data validation documents for all reports.
• Developed universe user documentation guide and report definition document guide for the end users reference.

Environment: BO XI 3.1, Oracle

ETL Developer

Confidential

Responsibilities:

• Implementing ETL solution using Informatica.
• Analyzing Source System data.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformations.
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Used most of the Transformations such as Source Qualifier, Aggregator, Lookup, Filter, Expression, Router, Update strategy etc.,
• Extensively used ETL to load data from Oracle and Flat files to Data Warehouse.
• Used Informatica Workflow Manager to create Sessions, Workflows to run with the logic embedded in the mappings
• Creating database tables, views and aggregates
• Checking the corrections of primary keys and referential integrity
• Assisting the Oracle DBAs in query tuning by building required indexes
• Taking the backup at the end of the day
• Reporting of the errors
• Monitoring ETL loads using Informatica Work flow Monitor
• Monitoring the BO scheduled job

Environment: Informatica 8.1, Oracle