SUMMARY:

• 9+ Years of experience in Information Technology as a with a thorough understanding of SDLC methodology and having in - depth knowledge in Architecture, Analysis, Design and Development of Data Warehouse and Business Intelligence applications.
• Extensively worked on all the phases of Data warehouse life cycle from Requirement Gathering, Infrastructure Setup, Analysis and Design to Project Support
• Expertise in BO 4.0, BO 3.1, BO-XIR2 & BO 6.5 (Architecture, Implementation, Universe Design, Reports Development & Administration) along with Crystal Report Design
• Have expertise in creating Interactive and for better Data Visualization Dashboards using Tableau 7 & 8, Xcelsius (Dashboard 4.0), MicroStrategy 9.3 and OBIEE.
• Hands on experience in SAP HANA modeling. Created multiple schemas and table definitions. Experienced in creating Attribute views, analytical view and calculated views.
• Analyze and understand business requirements, explore and evaluate various options, develop prototype using reporting and dashboard tools thereby validating the requirements, eliminating ambiguity and providing early visibility to business on the final solution
• Have experienced in Google Query and Google Analytics.
• Extensively worked on ITSM domain. ITIL V3 Foundation and Service Operations Certified.
• Extensive knowledge and experience in IT Service Operations.
• Excellent understanding and experience in Data Warehouse methodology & dimensional modeling.
• Experienced in designing the logical and physical Data Modeling/ER-Modeling using Erwin tool/ER Studio and designing the data warehouse using star schema/snow-flake schema and dimensional modeling.
• Have Expertise knowledge and experience in SAP Integration with Business Objects.
• Have expertise knowledge in creating OLAP universes and reports based on the OLAP Cubes (SAP-BI & MSAS), Infocubes, Multi providers and BEx queries using Business Objects.
• Have knowledge in creating a BI data model with InfoObjects (characteristics, key figures) and an InfoCube for storing data in the SAP BI system. Map the source structure of the data in the BI system and define the transformation of the data from the source structure to the target format. Loading the data in DataSource using InfoPackages
• Have expertise knowledge in designing/creating BEx Queries using SAP BW Tool (Business Explorer Analyzer).
• Experienced in customizing Business Objects code using BO SDK.
• Strong understanding of relational databases with hands on experience in SQL programming
• Have good knowledge in Operational Data Store (ODS), OLAP and ETL (Informatica and BODS).
• Experienced in doing Impact Analysis and Gap Analysis for business users.
• Experienced working as liason between IT and Business Users and supporting the users.
• Experienced working proactively in identifying the issues and escalating and communicating the issues to the business clients.
• Experienced in preparing test cases of the business process or application.
• Experienced in presenting s to the wider audience.
• Excellent experience in managing team (Onsite and Offshore model also) of any size.
• Excellent communication skills, Passion for analysis and reporting, Fast Learner; Dedicate, Hard worker and Good Team player.

TECHNICAL SKILLS:

Business Intelligence: Business Objects 4.0, 3.1, XIR2 & 6.5, Xcelsius (Dashboard), Tableau 7 & 8, SAP 7.1, SAP BW Front-End Tool (Business Explorer Analyzer), Crystal Reports 2010, Voyager, BODS, Informatica 8.6 &, Business Objects Mobile XI, OBIEE R11, Microstrategy 9.3

Databases: SAP HANA, Oracle, SQL Server, MSAS and MS Access 7.0

Data Modeling Tool: Erwin & ER Studio

Prog Languages: SQL.

Operating Systems: AIX, Sun Solaris, Linux, Windows

Front End Tools: TOAD, SQL developer.

Server Environment: IIS 5, Apache and Tomcat Application Software BMC Remedy ITSM, MS: Office Suite.

PROFESSIONAL EXPERIENCE:

Technical Lead

Confidential

Responsibilities:

• Held over all responsibilities of delivering the project to customer in both technical and management perspective.
• Design & Implement systems that meet the information delivery needs of business intelligence systems; perform technical and advisory functions in the development of business objects architecture and the creation of frameworks for reporting, dashboards, delivery, scheduling
• Work with the business management in gathering the requirements to ensure business objects and Microstrategy/Tableau are appropriately utilized for all required management and adhoc reports and Dashboards.
• Designed HANA model in SAP HANA and created the Attribute, Analytics and Calculation Views.
• Conducted Workshops on ITIL Metrics/KPIs and Industry best practices for reporting and dashboards.
• Designed Service Desk & GIO Global Performance using Tableau and eCommerce Dash using Microstrategy considering best practices for Data Visualization and Interactive.
• Providing guidance and mentoring a team of 7 in Business Objects, Tableau, Microstrategy, BODS and SAP HANA.
• End user Demo, & Documentation

Environment: Business Objects 3.1, Tableau 8, Microstrategy 9.3, SAP HANA 1.0.5, BODS, Oracle, Remedy AR System 7.6.04 for ITSM

Senior/Lead Consultant

Confidential, San Jose, CA

Responsibilities:

• Conducted Product demos at Customer sites
• Conducted Workshops on ITIL Metrics/KPIs and Industry best practices for reporting
• Performed Server Sizing for Business Objects Installation in Dev, QA and Prod.
• Installed BOXI3.1 and BMC Analytics.
• Set up user security for system access as per customer requirements
• Gathered requirements from the End Users to identify the Reporting needs
• Translate the functional requirements to high level design and build technical specifications document
• Created custom charts and Dashboards to display the impact of system health and performance on business
• Designed custom derived tables and universe customizations to meet the reporting requirements.
• Designed Analytics Reports as per requirements
• Performed data validation
• Provided Production Support
• Performed Business Objects deployment troubleshooting.
• Trained the end users to create new dashboards, analytics reports and BOXIR2 / 3.1 administration activities
• Documented the BMC Analytics & Dashboards Customization and Design

Environment: Business Objects 3.1, Xcelcius (Dashboard 4.0), Tableau 7, Oracle, BMC Analytics 7.6.01, BMC ITSM 7.6.04, Remedy AR System 7.6.04 for ITSM, BMC Dashboard for BSM 7.6.03

Business Objects Lead

Confidential, Palo Alto, CA

esponsibilities:

• Participate in design of Data warehouse data model and provide input and feedback from a Business Intelligence tool perspective.
• Worked on the Impact Analysis for all the 30 Universes and 159 reports.
• Re-designed all the Universe and reports.
• Gathered the complex business requirements and did business analysis to write functional specification document for new reports
• Involved in setting up the environments for OBIEE including installation.
• Created and Developed theRepository (rpd)and dashboard for ORA POC.
• Trouble shooting the issue (Development related) which arises during the time of UAT.
• Involved in the performance tuning of reports using indexing, partitioning etc.
• Involved in documenting the business process by identifying the requirements.
• Documenting all the Data Mapping documents, Design documents, Test Plan Documents.
• Worked as Business Objects Lead and allocated work to junior team members and guide them for successful of same.

Environment: Business Objects XIR2, Oracle 10 g, Oracle Apps R11, Jira

BI Technical Lead

Confidential, Madison, MS

Responsibilities:

• Worked directly with the business users and capture simple, moderate and complex business requirements.
• Gathered the complex business requirements and did business analysis to write functional specification document for new reports
• Assisted in defining the scope of the project, technical and business specifications
• Worked in the data mapping, designing phase and deploying the 4 Universe and 200 reports.
• Working on building new BO reports with BDW, POS, IPS and ODS2 universes.
• Creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Developed Cross-tab and Tabular reports from multiple data providers or data sources.
• Designed 2 dashboard using Xcelsius 2008 using Query as Web Services.
• Presented s to the higher managements using PowerPoint.
• Trouble shooting the issue (Development related)which arises during the time of UAT.
• Involved in the performance tuning of reports using indexing, partitioning etc.
• Involved in documenting the business process by identifying the requirements.
• Documenting all the Data Mapping documents, Design documents, Test Plan Documents.
• Worked as BI Technical Lead and allocated work to junior team members and guide them for successful of same

Environment: Business Objects XI 3.1, Xcelsius 2008, Query as Web Services & Oracle 10 g

Business Objects Technical Lead

Confidential, Shelton, CT

Responsibilities:

• Understanding requirement of generating the reports out of Cubes, BEx queries / multi providers.
• Involved in creation of Info Areas, Info Objects, Info Cubes, and DSO’s, and created required Transformations and DTP to load data into Data Targets.
• Involved in creating the generic data sources.
• Involved in uploading Master Data and Transaction Data from Different Source systems.
• Created an OLAP universe out of the BEx queries / Multi providers in Business Objects designer by connecting to the SAP Source.
• Designing and Reviewing the Security Structure following the best practices to enable a high secured Environment
• Maintaining and monitoring the Application Audit Reports.
• Maintaining the BO Servers and performance tuning of all the BO servers
• Created Variables, hierarchies and custom prompts based on these hierarchies.
• Once the universe was developed, tested and exported to the repository, created WebI reports from them to view in Business Objects Mobile XI
• Worked as Business Objects Technical Lead and allocated work to junior team members and guide them for successful of same

Environment: Business Objects XI 3.1 and SAP - BW, Business Objects Mobile XI 3.1

Business Objects Lead

Confidential, Shelton, CT

Responsibilities:

• Involved in preparing the proposal on response of RFP for the SSS Metric Project. Gathered the requirement from the client and also provided the estimation to build 200 reports and universe.
• Worked closely to gather the requirement and suggested best possible design of Data Model based on the reports requirement.
• Worked in the data mapping, designing phase and deploying the Universe and 200 reports
• Extensively used Toad for database analysis, performance tuning and trouble shooting.
• Involved in data modeling of OLTP systems
• Implementing the Row Level and Object Level Restriction on the Groups.
• Designing and Reviewing the Security Structure following the best practices in BOXIR2 to enable a high secured Environment.
• Maintaining the BO Servers and performance tuning of all the BO servers.
• Presented s to the higher managements using Powerpoint.
• Trained the key users for usage of SSS Metrics Universe, developing the queries and usage of Info view module.
• Designed Xcelsius reports out of SSS Matrix Universe.
• Trouble shooting the issue (Development related) which arises during the time of UAT.
• Involved in the performance tuning of reports using indexing, partitioning etc.
• Involved in documenting the business process by identifying the requirements and also involved in finding the system requirements.
• Documenting all the Data Mapping documents, Design documents, Test Plan Documents and preparing best practice documents.
• Worked as Business Objects Lead and allocated work to junior team members and guide them for successful of same.

Environment: Business Objects XIR2, Xcelsius and Oracle 10g

BO Administrator Lead

Confidential, Shelton, CT

Responsibilities:

• Involved in preparing the proposal on response of RFP for the BOXI Migration Project and also gathering the requirement.
• Setting up the 3 Environments (Dev, Stage and Prod) where stage and production are horizontal clustered one.
• Configuring the SSO Siteminder with Business Objects Enterprise for Single Sign On.
• Designing, Implementing and Validating the Security Structure following the best practices in BOXIR2 to enable a high secured Environment.
• Designed a document for validating the security structure of the users, groups, folders and applications.
• Implementing the Row Level and Object Level Restriction on the Groups.
• Migrating the Content (Corporate/Personal Documents, Groups and Users etc) from BO 6.5 to BOXIR2 using incremental method.
• Involved in the understanding the requirement, designing phase and deploying the customized pages (as customized login, Logoff etc.) using BO SDK for user’s login into the BOXI.
• Involved in the understanding the requirement, designing, deploying the customized Automated User Addition Code using BO SDK for adding bulk of user into the BOXI.
• Customizing the BO code for achieving some functionality as per the functional user’s requirement. For example: - Send to Functionality, Disabling the Send options and discussion thread.
• Maintaining and monitoring the Application Audit Reports.
• Trouble shooting the issue (Admin/ Development related) which arises during the time of UAT.
• Maintaining the BO Servers and performance tuning of all the BO servers.
• Documenting all the functionalities and preparing best practice documents.
• Allocate works to junior team members and mentor and guide them for successful of same.

Environment: Business Objects XIR2 CMC, Infoview, Designer, Business Objects 6.5, Supervisor, BCA and Oracle 10g & 9i

Business Objects Support Consultant

Confidential, CA

Responsibilities:

• Understand functionality level and technical level of the issues.
• Troubleshooting all design and architectural issues of different Business Objects Products and version.
• Providing solution for universe, reports and administration issues.
• Replicate the customer issues by replicating the customer environment in house.
• Research on the customer issues through various BO informative sites
• Depending upon the issue, created different reports like DESKI, WEBI & Crystal.
• Online updates & Direct contact with the Customers.
• Extensively worked with people soft CRM.
• Resolved the issues related to different Business Objects Products and Versions.
• Installation & configuration of various Business Objects Products and Versions.

Environment: Business Objects 5x/6x/XI/XIR2, Web Intelligence 2.7.2, Crystal Reports and Oracle 8i/9i.

Business Objects Consultant

Confidential

Responsibilities:

• Involved in the design of the Universe, the metadata layer of Business Objects in the Designer module.
• Defined hierarchies of classes and subclasses into the model reflecting the business concepts.
• Created measure objects, which are derived from aggregate functions.
• Constructed management reports (flexible and standard) using Business Objects Reporter tool.
• Understand functionality level of business needs for Installation.
• Understand the compatibility of the Environment for the Business Objects Setup.
• Provide the Architecture suitable for the existing environment with best performance.
• Configured the cluster in all the four servers with primary nodes in each server.
• Configured the BCA in all the four servers.
• Configured the Auditor module in all the four servers with common Auditor Database (Repository).
• Performed the validation and UAT (User Acceptance Testing) for all the four servers, Universe and Reports.

Environment: Business Objects 5.x, Auditor, Oracle 9i