SUMMARY

• Overall 13+ years of strong IT experience in SAP Business Intelligence that includes requirement gathering, estimation, analysis, design, development & testing of Enterprise Data warehouse solution.
• Worked on various roles Sr. SAP BI Consultant & Administrator, Crystal Report Developer, SAP BODS/SAP BODI Administrator and SSIS Developer.
• Expertise on handling responsibilities as Tech lead/ BI Project lead/Subject Matter Expert (SME) exclusively in SAP BI space.
• Expertise in different SAP Business Objects (BOBJ) software versions - SAP BI 4.2/4.1/BO XI R3/R2.
• Experienced in Banking, Financial and Insurance domain applications.
• Expertise in administration activities installing, configuring, deployment and maintenance of SAP Business Intelligence applications using Launchpad, CMC, CCM, Web Intelligence(Webi), Desktop Intelligence, SIA, Information Design tool, Universe Designer, Import Wizard, Publishing Wizard, Report Conversion Tool, Query Builder, Live Office, QAAWS, Tomcat.
• Created reports using Key Performance Indicator (KPI’S) reports, Performance analytics and build custom PA dashboards.
• Immense understanding in SDLC , Experience in Requirement Gathering, Scrum , Sprints, Sprint Planning, UAT, Creating Stories.
• Created different types of reports like Adhoc-Reports & Bursting reports (Daily, Weekly and Monthly).
• Extensively worked on designing and developing complex universes, which has several hundreds of objects, contexts, and aliases, aggregate aware functions and cascading prompts.
• Extensively used various features like Joins, Alias and Contexts in Universe designer or IDT to overcome Loops.
• Extensively used advanced reporting functionality such as Sections, Breaks, Drill, Filters, Ranking, Alerts etc. and using report level variables to mimic user requirements.
• Customized reports based on user requirement using various features available in SAP Crystal Reports like running totals, parameters, grouping of data, alerts etc.
• Extensive experience in creating SAP Dashboard tool and Lumira by using QAAWS, Live Office and BI service.
• Hands-on experience in SAP BI Administration including creating User, User Group, Access Levels, managing SIA servers, Scheduling.
• SAP BI Administration including Installation, Service Pack and Fix pack Upgrades, security configuration, roles creation, Security Group design, authentication management using SSO and user provisioning.
• Expertise in upgrades, maintenance, Licensing and support of the SAP BI platforms and expertise in Migrating the Business Intelligence reports to latest versions.
• Well versed with Business Intelligence Authentications and Authorizations, Creating/Administrating Users & Groups, designated their Security Levels in CMC, assigned Roles, & Access Levels on the Applications and folders.
• Extensive experience in connecting reports with external front-end application through Open Docs and Restful Web service.
• Managed offshore Business Intelligence development team and delivered various projects on time, on budget with zero defects.
• Extensively used BODS & SSIS ETL methodology for Data Extraction, transformations, loading using Data Integrator.
• Experienced in Microsoft Visual Studio (Business Intelligence Development Studio) for SSIS ETL.
• Used SSIS to create ETL packages to validate, extract, transform and load data-to-data warehouse and data marts.
• Designed SSIS Packages to extract data from various data sources such as Oracle, SQL, Sybase, Teradata databases , Mainframe files, Excel spreadsheet, and flat files and load data into destination databases for further Data Analysis and Reporting.
• Connect to other external vendor data Sources through Rest and SOAP Web services
• Expert in tuning the performance of SQL queries and ETL process
• Worked in generating ETL jobs to configure Tidal & Stone branch monitoring tool.
• Good Knowledge of Data Warehouse Concepts including Schemas, dimensions and Facts.
• Strong database experience with different versions of Oracle, MS SQL Server, Sybase and Teradata databases.
• Experience in developing Stored Procedures, Triggers and Functions, Indexes, Views, Joins and SQL code for applications.
• Experience in optimizing, debugging and testing SQL queries in Oracle and Teradata.
• Expertise in working with Change Management System for deployments.
• Experience in working handling Production support Incident and Request tickets (Tier1, Tier2 & Tier3).
• Experience in writing system documents, technical documents, test cases and user documentation and writing training materials helpful for end users.

AREAS OF EXPERTISE

• Efficient Programming & Administration
• Data Analysis and Design
• System Architecture
• Leadership & Team coordination
• Manage Time and Improve Deadline
• Customer Focus
• Problem Solving

TECHNICAL SKILLS

BI Tools: SAP Business Intelligence 4.2/4.1/BOXI R3/R2

Development: Information Design Tool(IDT), Universe Designer, Web Intelligence(WEBI), DESKI, Launch pad, QAAWS, Restful Web service, Open Documents, Report Conversion Tool

Administrator: CMC, CCM, Import Wizard, Upgrade Management Tool(UMT), Promotion Management, Import Wizard

Dashboard Tools: SAP Dashboard, Xcelsius, Lumira, Tableau

ETL Tools: Microsoft SSIS, SAP Data Services(BODS), SAP Data Integrator(BODI)

Databases: Oracle, Teradata, Microsoft SQL Server, Sybase, MySQL

Monitoring Tools: 360 Suites Modules- Eyes, Bind, Univ, Cast, View, Plus TIDAL, Stonebranch

Languages: PL SQL, Microsoft Visual Studio, C#, VB Scripts

Web services: SOAP, REST

Web Servers: Tomcat

Version Control: SVN, GIT

Utilities/Other Tools: SQL Developer, TOAD, Management Studio, Notepad++, SOAP UI, JIRA

Operating Systems: Windows & UNIX

PROFESSIONAL EXPERIENCE

Confidential, FL

Sr. SAP Business Intelligence Administrator/Tech Lead

Responsibilities:

• Installation, configuration, security implementation, disaster recovery for SAP Business Objects Enterprise Product Suite platform. Plan for growth, deployment architectures, sizing based on requirements and extending existing infrastructure
• Strong technical background in networking, operating system, system administration and performance monitoring
• Perform testing of Business Objects support packages and patches
• Support on day-to-day activities like Monitoring, User Onboarding and User tickets.
• Expert in configuring SIA servers based on the user load, cores and licensing(Job servers, Processing servers, File processing servers, Web Intelligence servers)
• Expert in using Promotion manager to promote reports, universes, connections and other objects from lower to higher environments.
• Perform installation, migration, configuration, maintenance, technical support and troubleshooting of Business Objects implementation
• Maintaining knowledge of reporting processes and assisting end users with access and data issues
• SAP Business Objects Upgrade from BI4.1 to BI 4.2 and responsible for applying service pack and fix pack to BO installation and deployed WAR files after upgrade.
• Configure ODBC &JDBC connectivity and Oracle TNS listeners.
• Expert in consuming 360 Suite application for Backups, Restores, compare reports output and design layouts using Bind tool, Promotion to different environments, Administration activities.
• Installation and testing of Business Object and Data services application on sandbox
• Employ best practices for design, development, unit testing and test plan development
• Successfully migrated from older version of Business Objects to latest version.
• Actively worked on all the deployment activities from lower to higher environments (DEV, QA, UAT & PROD)
• Root cause Analysis (RCA) will be done for each incident issues and later it will be documented.
• Migrated Business Object Tomcat and SIA from Physical blade servers to VM
• Query the Business Object Repository database using Query Result.
• Automated process through SSIS job to load Users and User groups to Business Objects on weekly basis.
• Created Dot Net utility to pull all the business Objects details from Repo database.
• Worked on configuring Disaster Recovery (DR) system for production servers.
• Conduct performance tuning and capacity management
• Support changes in server configurations and troubleshooting of Business Objects SDLC environment
• Expertise in Resolving the Daily issues in the Daily Production Environment.
• Created repository and security domain with user groups and security implementation.
• Ensured all the environments are in synchronization and checked supported environments and hardware requirements from the Products Availability Matrix document for the new installation.
• Expert at using Information Design Tool IDT and Universe Designer.
• Open SAP ticket and work with them regularly.
• Work with Change management Board (CAB) and other teams during deployment.

Environment: SAP BI 4.2/4.1, SAP Business Objects XIR3, SAP Crystal Reports, SAP Lumira, Oracle, Teradata, SQL Server, 360 Suites.

Confidential, FL

Sr. SAP Business Objects Developer/SME

Responsibilities:

• Worked towards the Requirements gathering, design, development and testing out business intelligence solutions, which can be leveraged by key users and end-users.
• Participate in the requirement meetings/activities, Joint Application Development (JAD) sessions carried out to understand and plan the programs to be developed for Business Analyst team . Ensure no flaw in the design and testing is discovered at later point.
• Involved in Agile project team planning session every week to discuss on the backlog items. Understand business requirements through interacting with data analysts and end-users.
• Created Webi reports using Universes, stored procedure and Free hand SQL as Data providers.
• Created the Crystal report on two different data sources using sub reports also.
• Created various classes and objects with different object qualifications such as measure, dimension and detail objects.
• Developed SAP Business Object (BI) Reports, Dashboards and writing database scripts in development/testing environments.
• Worked on optimizing the performance of the dashboards.
• Created data models, visualizations, charts, tables, and other report part objects for use by non-technical users in self-service reporting tools such as BI Webi Intelligence Reports, Crystal Reports and Dashboards.
• Created Ad-hoc Reports, Canned report, Summary Reports, Sub Reports, dynamic grouping, Cross-Tab, graphical, etc) for Business users using Webi and Crystal reports
• Created different level of reports such as Ad Hoc, Bursting reports, Summary reports, and Sub Reports and Cross Tab reports to serve the user needs.
• Worked on almost all 360 Suites Modules to manage and monitor BI application- Eyes, Bind, Univ, Cast, View, Plus
• Worked on Scheduling and managing SAP Business Intelligence reports to process data files in Excel or PDF format. Processed files are then injected into client based analytics tool ReportVue application for users to download it.
• Worked with functional and operational areas / personnel to identify and analyze problems and propose solutions
• Create or modifying the existing universe class and objects.
• Integrated customer’s front end Billing Invoice web (BIW) application with SAP Business Object system using Open documents and REST Web service.
• Resolve complex issues assigned during projects execution. JIRA task will be assigned by project manager for the new bug fixes.
• Provide detailed analysis, design, tuning, testing, implementation and documentation of the business intelligence system and data warehouse.
• Reports are made user friendly by implementing user prompts, conditions and filters.
• Generated various reports with the Features like Drill down, Alerts, Data Suppressing and Change Highlighting.
• Worked extensively with the major functionality of SAP Business Intelligence like Breaks, Sections, Ranks, Block Filters, Report Filters, Input Controls, Alerts, Variables, and Formulas.
• Synchronized various queries in Web Intelligence using Merge dimension according to the user specifications.
• Resolved the loops using Aliases and contexts and checked the Integrity of the Universes.
• Responsible for BO Universe & Reports in different testing methodologies like Unit, System, UAT, Performance, Updating the defect logs, finding solutions, conveying messages between the Development and the QA teams.
• Worked on troubleshooting of different database connectivity issues, user issues and report performance issues and trained the End Users regarding the Tool and the reports.
• Production Support- Bug fix and enhancement.
• Working on the SQL tuning and optimization of the Business Objects reports.
• Created Low level design documents & Test case documents.
• Compare the report output with database data by writing SQL queries.
• Troubleshoot reports if any issues/errors that occur during upgrade and fixed them to work as per the business needs.
• Created View, Materialized views, functions and stored procedures in oracle database.
• Create query tracker sheet for any clarifications or questions.
• Manage the team and made proper coordination with front end application team and database team.
• Coordination with Offshore Team and provide solution whenever needed.

Environment: SAP BI 4.2/4.1, SAP Business Objects XI R3, SAP Data Services (BODS), SAP Data Integrator (BODI), Crystal Reports, SAP Dashboard, Lumira, Tableau, Oracle, Teradata, SQL Server & 360 Suites.

Confidential, FL

Sr. SAP Data Services (BODS) Administrator

Responsibilities:

• Installation, configuration, and upgrades of SAP BODS applications on all existing and supported versions with continuous experience and skills working with and troubleshooting associated issues and keeping current with all related emerging software enhancements, security patches and bug fixes
• Implement procedures to maintain, monitor, backup and recovery operations for ETL environment.
• Architect the SAP data migration solutions for a large-scale system/data migration.
• Configuration of Local Repo and Central Repository for Multi User Environment.
• Check-in, Check out and Label the code versions in Central Repository.
• Provide development support to ETL application development teams.
• Modifies, installs, and prepares technical documentation for system software applications
• Worked on migrating jobs from Data Integrator to Data Services.
• Troubleshooting, debugging & fixing BODS specific issues, while maintaining the health and performance of the ETL environment
• Establish projects, roles, users, privileges in different ETL environments (DEV, QA, UAT and PROD).
• Configuring Job Servers with repositories. Creating Users and providing access to them.
• Expertise in BODS security setup, promotions, data store configuration & backups
• Proactive gathering of requirements from Customers to provide technical/functional support and resolution to incidents and service requests
• High availability for QA and production environments including Installation, upgrade, migration, User management, back/restore, code promotion
• Maintain different Databases in data sources of SAP Business Objects Data Services
• Promoting jobs from different UAT to PROD environment during deployment.
• Schedule and monitor the jobs in Tidal and Stone branch monitoring tool.
• Record and maintain ETL software and operational procedures.
• Resolving the tickets within a specified SLA time. Troubleshooting day to day technical issues.

Environment: SAP Data Services 4.2, SAP Data Integrator, Tidal, Stone branch, MS SQL Server, Oracle 11g and Teradata.

Confidential, FL

SSIS/ SAP BODS ETL Developer

Responsibilities:

• Worked on preparing the technical specification documents for all the services that to be implemented.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSIS in Business Intelligence Development Studio (BIDS).
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Developed, deployed, and monitored SSIS Packages.
• Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project.
• Worked on SSIS Package, DTS Import/Export for transferring data from different database (Oracle and Text format data) to SQL Server.
• Used Execution Plan , SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases .
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Involved in deploying the changes to QA, Staging and Prod environments.
• Managed off shore team in Report migration project.

Environment: Microsoft BIDS, SAP BODS Designer, MS SQL Server, Management Studio, Oracle, TOAD, UNIX, TSQL and Dot Net.