SUMMARY

• Over 22+ years of experience in Analysis, Design, Development and Maintenance of SAP Business Intelligence Applications.
• Over 18years of experience in providing Data Warehousing Reporting Solutions to Financial, Health, Retail, Telecom and Manufacturing Domains
• Over 13 years of experience in Administration, Installations, configuration and migration of Business Objects Reports, Universes and Repository Objects from BO 5.x/6.x/Crystal 9.x/10.x, BO XI R3.x/BI 4.0/4.1/4.2 environments
• Experienced in migrating and configuring SAP BOBJ products from on Premises to Microsoft Azure (Hybrid) platform including Firewalls and Load Balancer
• Over 18 years of experience in developing Business Objects universes and WEB Intelligence reports
• 5+ years of experience in designing and developing Data Visualizations/Dashboards using Tableau 8.0
• 2+ years of experience in creating Reports and Data extracts from Salesforce
• Over 5 years of experience in developing Crystal Reports from OLAP and OLTP data sources
• 5 years of experience in creating OLAP universes/Reports from BW queries and Infocube based on HANA Data sources
• 4 years of experience in creating cubes and reports using COGNOS 8.1
• Strong experience in requirement gathering from various business units and prepare Report specification and System Design documents
• Expert in Trouble shooting various Report and Universe issues occurred during development and migration
• Strong experience in creating multi - source enabled universes using Information Design Tool
• 3 years of experience in development of Xcelsius Dashboards using Query as a Webservice (QAAWS), Live office connector and XML Maps.
• Strong Experience in all phases of the Project life cycle and Train End users in various Business Intelligence Tools.
• Work closely with Database and ETL teams in preparing the Logical & Physical data models and ETL Processes
• Strong ability in translating business requirements into technical solutions

TECHNICAL SKILLS

Architecture: SAP BW, Client-Server, Data Warehouse, Business Objects Product Suite

Database: Oracle 7.x/8.x/9.x/10g/11g, Teradata V2 R5/R6, HP Neo View 2.0, MS SQL Server, Red Brick 6.x, Netezza, Sybase, SAP BW 7.x/HANA

GUIs/Reporting Tools/CASE Tools: Business Objects Product Suite, Crystal Reports 2012,Web Intelligence 3.1/4.2SAP GUI, Xcelsius, BEx Query Designer, Tableau 8.0, Salesforce Reporting

Methodologies: Dimensional Modeling, DW Methodologies

Operating Systems: Windows 2000/ NT/2008, UNIX

Warehousing Tools: Informatica, Data Integrator, Ab Initio, Erwin Data modeling

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Intelligence Administrator and Developer

Responsibilities:

• Implemented SAP BI Deployment and Sizing Methodology.
• Identified Users, Data Sources, Document Size and SAP Application Performance Standard (SAPS) Rating.
• Installed and configured Server sizing and Load balancing for BOBJ applications on Azure Cloud platform
• Followed SAP Standards Steps Resource Usage Estimator, Intelligence DB tier, Intelligence Tier, Application Tier, Processing Tier, Sizing Analysis and Scale-Out and Deployment and Monitoring.
• Calculated required number of CPU’s and Memory based on SAP SAPS.
• Work with various Business units in identifying the requirements for universe design and report development
• Create reports for various Marketing campaigns using Salesforce
• Develop Universes using UDT and IDT (Information Design Tool)
• Setup Business Objects security for accessing applications
• Migrate universes and reports between environments
• Troubleshoot data issues in Salesforce, Teradata and Siebel
• Train Business users in report development and Dashboards using Salesforce and Tableau
• Monitor Performance of Business Objects servers.
• Monitor Land desk tickets on a daily basis and help resolving data issues with a quick turn around
• Implemented Single Sign On ( SSO ) to BI Launchpad and Salesforce applications
• Define and Implement development standards for Universe design, Report development and BI Dashboards

Confidential

Business Objects Analyst/Technical Lead

Responsibilities:

• Architect, design and develop Deployment strategies
• Create Proof of Concepts and turning them into real time solutions
• Define and Implement development standards for Universe design, Report development and BI Dashboards
• Plan and Manage upgrade and migration of projects
• Work with Management team in planning and leading the migration of Business Objects 3.3 environment to BI 4.1
• Perform Product Installation and configuration of BI 4.1 Server and Client components
• Work with Business Units in identifying the Universes and Reports for migration to BI 4.1
• Analyze the existing reports to determine the Migration strategy & Timelines
• Promote the WEBI & Deski reports using RCT
• Analyze the business requirements and create Data Visualizations using Tableau 8.0
• Responsible for design, development and maintenance of Business Objects Universes, Webi and Crystal Reports
• Perform the Backup of the system content, maintain and install Fix packs
• Setup the Security model for accessing the Business Objects content based on the project requirements using CMC (Central Management console)
• Responsible for troubleshooting issues occurred during content migration and Report
• Train End users in creating the Adhoc reports and Data Visualizations

Confidential

Business Objects Technical Analyst

Responsibilities:

• Responsible for analyzing business requirements and compiling system specification to generate documents and schedule BusinessObjects, Crystal Reports and Web Intellgence Documents to Senior Executives (C-levels), Managers and Local Sales teams of Domestic and International firms on weekly basis to monitor Inventory levels and for broadcasting sales to accomplish specific revenue goal.
• Responsible for design, develop and maintain Business Objects Universes, Webi Reports, scheduling report and security for PVH group related to Retail sales management.
• Designed, developed and managing PVH CRM universe - Transaction Level, PVH Barcode Universe, PVH Barcode Universe with sql and PVH Barcode Universe with Oracle Stored Procedures.
• Implemented complex retail sales management for business users by creating dynamic tables and auto calculated fiscal date derived tables in the universe to accomplish the client requirements and maintain efficient data management.
• Created Executive Dashboards and Data Visualizations for users to monitor historical and current business information performance using drill down in SAP Businessobjects Dashboard solution to discover critical patterns and to spot trends in data toenable users to align goals and inform decision making.
• Responsible for creating and maintaining many complex retail sales, marketing analysis reports by products on WTD, MTD, QTD & YTD with multiple tabs for clients and helped business users to track the sales and maintain client profits to the meet expected levels.
• Actively participated in giving user training, Workshops, Webinars on Web Intelligence Reports,and thus contributed in improving project enhancement requests activities by proactively developing business relationships with both business users and project team.
• Developed many SQL queries and PL/SQLfunctions and stored procedures to validate data. Used the same queries to compare Business Objects Reports against the database.
• Perform Health check of the environment and perform server sizing, capacity planning when required
• Install and Configure Server Components and Client Components
• Planning and migration of the Business Objects environment from XI R2 /XI 3.1 to BI 4.0 platform
• Perform the Backup of the system content, maintain and install Fix packs
• Setup the Security model for accessing the Business Objects content based on the project requirements using CMC (Central Management console)
• Responsible for troubleshooting issues and implementing disaster recovery, load balancing and fail over features for the production environment.