SUMMARY

• 18+ Years of IT Experience in SAP Business Intelligence, Data Modelling, Visual Analytics, Reports, Dashboards, Data services, Lumira, Design Studio 1.6 and Tableau
• Extensive experience in SAP BI Technologies, Analytics tools: Lumira, Business Objects, Design Studio 1.6 .
• Expert in Conversion, Migration projects in SAP ECC, BW objects with ETL tools, Business Objects Data services, Informatica.
• Extensive experience in Architecture, Solutions design with Business Intelligence 4.1/2.
• Expertise in Oracle, SQL Server, Sybase, Remedy, Access Database.
• Ability to work as single resource as well as a great team player, excellent communication, organizational and leadership skills.
• Experience in Insurance, Finance, Pharmaceuticals, Supply Chain Functional Areas.

TECHNICAL SKILLS

BI Tools: Business Intelligence suite 4.1/4.0, Business Objects Data Services, WEBI SDK, Crystal Reports, SQR, Desktop Intelligence, BO Integrator, Crystal Reports, SQL Reporting Services, Active Reports, Actuate, Web Intelligence, Design Studio, Tableau 9.0, Lumira, SAP BW, BI, BEX.

Database: HANA 2.3.8, Oracle, MS SQL Server, DB2, MS Access, AWS.

ETL & Data: TDMS, Business Objects Data services, ALE, LSMW

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

SAP BI/ BO Reporting and Analytics Lead

Responsibilities:

• Install, Upgrade, Manage, Maintain Business objects servers and Environments for reporting and Analytics solutions .
• Work with Development teams to do the migrations, promotions, testing, performance tuning for reports and Dashboards.
• Working as a Business Objects Administrator / Architect to design the reporting solutions as per Business needs . design the security models for Data and Report access .
• Working on User interface and customization for reports access framework using .net and SAP BO SDK tools.
• Design new Analytical Dashboards, Reports using Business Intelligence tools such as BI 4.1, Design Studio 1.6, Tableau 9, Lumira 1.0
• Working on HANA views. design and created analytic, Calculation and Attribute views in functional areas like Finance, Supply chain, material and inventory management .
• As a part of development, work with business teams to gather and analyze the requirements .create functional and technical design documents.
• Work on prototypes, demos and presentation of dashboards created based on Design studio and Lumira tools.
• Working with test, quality and user acceptance test users to do the data, design and functionality tests.
• Work with change control and release management teams for deployments of new SDK code, dashboards and reports.
• Working on performance improvement and user security setup for data and object level security .
• Conversion /migration of Non SAP data (MS Sql Server) to SAP Data warehouse
• Build the Infocubes, Multiproviders, open hubs, HANA views based on Business functionality for reporting and analytical dashboards design

Skills: SAP BI 4.1/4.2, .net, SDK, BODS, HANA, Lumira, Tableau, Design Studio 1.6

Confidential, New Jersey

SAP BI Architect / Associate Manager.

Responsibilities:

• BI 4.1 Sp4 Patch 5 - Installations, Upgrades, capacity management in Windows and UNIX environment with Tomcat, Apache Configurations, firewall settings.
• Design User Security Setup with LDAP and AD authentication for reporting platform access, publish, and view.
• Development and implementation of WEB portal to access / view and run the reporting platform using SDK and .net framework.
• Worked on Promotion Management jobs, Scheduling, Publishing and Version Management in Business Objects.
• Planning and execution for failover, Disaster recovery, High availability environments.
• Help Guide and advise Development teams for the Design on WEBI, Crystal Reports, Dashboards, Business views, business Intelligence layer (Universe) using BI 4.1 Suite tools .
• Work on Changes / Modifications in the BI layer to accommodate business rules and to improve the performance of Dashboards, Reports.
• Trouble shoot Performance issues -Work on bottle necks which causes to run the reports slow in scheduling and on demand views.

Confidential, New Jersey

Senior BI / BO Architect

Responsibilities:

• Data Modeling: Designed Database for Reporting solutions in various functional areas like Medical Benefits, Child care, Retirement, using conceptual, logical, and physical Schemas. Used ERM for presentation of Data layer and Design
• Business Objects 4.0: Worked on BO XI (R2/3.x) Administration / Architecture, capacity planning, installation of BO 3.1 with SP, FP in secured environment on both Linux / UNIX & Windows platform.
• Support team for the Universe, reports development with functions, formulas, parameters.
• Worked on Reports Analysis, Design, Data Modeling, ETL processes.
• Worked on Consolidation of reports with combination of multiple reports as per the business rules and requirements .Worked with business users to explain the reports design and new layouts.
• Architect and Administrator: Handled Security setup for users, groups, folders and objects n BO for Ogilvy clients and group of users.

Confidential, New Jersey

BI / Business objects Tech Lead

Responsibilities:

• Business Objects Reporting Suite: Involved in planning, installations, integration, migration and development of BI layer. Laid out the detail Upgrade plan with study of BO 3.1 set up and the project plan for migration project for BOXI- r2 (SP4) to BO R3.
• Architecture and planning of Business objects 3.1 for DEV / Q and PROD environments. Worked on Disaster recovery and fail over architecture.
• Handled Memory consumption issues with configuration changes for WEBI servers such as MUT, MLT, and MMT.
• Worked with business users to define and understand data access and reporting needs and halp business users for the reports requirements.
• Oracle Database: Worked on data and reporting requirements to recommend and design solutions through the creation of appropriate database structures, reports and query structures.
• Worked with Database design team to articulate the reporting needs using the DB tools and objects.
• Test Cases: Used proactive approach to develop the test scripts; troubleshooting reports for the performance and better design by adding functions, parameters with subset of data.
• Documentation, report design templates for user training and information.
• Infrastructure Architect: Responsible for overall Business objects infrastructure maintenance, applying patches, SP, MHF to upgrade the BO environment.
• Performance tuning for scheduled and preview of reports. Worked on Security setup. roles, user folder security and other administration tasks
• Worked on 24/7 support model on rotation basis for BO environment performance and customer issues
• Laid out the detail Upgrade plan with study of BO R3 and set up and the project plan for migration project for BOXI- r2 (SP4) to BO R3
• Worked on Tomcat configurations and Web layer deployment of Business objects Infoview and CMC .Worked on Administration tasks of BO such as security setup, creation of BO objects (folders, groups, scheduling of reports etc.)
• Interacting with the business team for the requirements gathering and other technical issues fixes in the environment
• Worked on and release plans for the applications, actively involved in Data center moves and the disaster recovery failovers
• Migration scripts, implementation scripts for Business objects products.
• Bug fixes, guiding the team for the proactive approach and recommendations

Confidential, Oaks, PA

SAP BI / Data / Reporting Architect

Responsibilities:

• Cognos: Worked on two BI applications and systems built on Cognos and Business Objects.
• Cognos 8 BI (Framework Manager, Report Studio, Query Studio, Metric Studio, Analysis Studio and Cognos Connection) and Report Net1.1.
• Worked on Cognos Impromptu, Power Play Enterprise Server, and Transformer, upfront, Impromptu Web reports (IWR), Access Manager, and Visualizer.
• Informatica: providing Data warehouse solutions using Power Center and data modeling with ERWIN tool.
• Oracle: Worked on RDBMS,Oracle10g/9.x/8.x/7.x, SQLServer2005/2000, SQL, PL/SQL, T-SQL, DB Triggers, Stored Procedures, Functions and Packages.
• Prepared and Presented the BOXI Architecture in cluster and HA mode
• Business Objects: Laid out the plan for integration of BOXI-6.x reports and Universes in to BO XI environment.
• Administration and Architect: As Business Objects XI Administrator, Worked on Installations, Upgrade and Migration for BOXI 6.5 to BOXI - R1/R2.
• Successfully Installed BO XI - R1, R2 in UNIX, Windows environment. unpacking the software files, setting up the environment files, running the .sh scripts, silent install scripts, configuration of Auditing and CMS repository Database.
• Involved in development of reports, queries, and performance issues.
• Successfully deployed Interface of BOXI on web logic BEA server with deployment of .war files and extracting the contents with jar commands.
• Documented the steps to follow for another installation on different server.
• Worked on creating Universes, Business Intelligence Layer for end users to develop the on line reports and statements.
• Worked on Import and Export of the Universes on the BO XI server, with the changes in Database Objects.
• Security setup for the users using SSO, NT and enterprise type users, also Worked on creation of Users, Folders and BO XI objects.
• Performance management and High Availability Layout plan to share the Services in cluster Environment.
• Universe Design and development of Web intelligence reports, dis includes the Financial statements for the QA and Data analysis.
• Migration of Desktop intelligence reports to Web intelligence documents.
• Crystal Reports: Published reports and universes in different environments along with the links and objects.
• ASP.net: Development of application includes SDK for web intelligence applications.
• Actively worked with Database design team to add new business rules and logic for the universe design.
• Designed for the universes with different data bases using DB connections.
• Worked on links and class objects in universe, Worked on integrity checks while refreshing the universe for the DB changes.
• Worked on Query designer to build the reports in the Web intelligent.
• Scheduling and Publishing: Worked on scheduling of reports in different export formats such as .csv, excel, word, .pdf.
• Universes: Worked on adding new dimensions and rules in the universes for new business logic.
• As a part of development, actively involved in validation and comparison of Data in IT / QA and Prod applications.
• Worked on Universe performance by setting up indexes and by minimizing the links.

Confidential, Bedminster NJ

Web Reports Analyst

Responsibilities:

• ASP.net: Developed ASP.net application for reports access on the web.
• Written number of ASP.net pages to integrate the crystal enterprise 10 report application server components.
• Written number of ASP.net pages to integrate the crystal enterprise 10 report application server components.
• Written ASP application to view the report in DHTML, JAVA, and ActiveX viewer. Also written ASP pages to export the report in various formats like Excel, .PDF, text etc. and to download the report on user desktop.
• Crystal Reports / CE 10: Worked on design of complicated reports using sub reports and grouping functions.
• Configured the Crystal enterprise server on Windows 2000 server.
• Written number of stored procedures in Oracle 10g.
• Performance and tuning of reports using database technologies and reports functionalities.
• Prepared number of Ad- hoc reports request for the financial and leasing data analysis.

Confidential, Alpharetta, GA

Reports Analyst

Responsibilities:

• Crystal Enterprise Installations and Crystal reports Migration.
• ASP web based Front end tool for Web reports Access Application
• Worked as a Crystal Enterprise 8.5 Administrator for Creating folders, Users for reports Distribution, email notification, monthly report running package for various groups
• Developed reports based on EXCEL Spreadsheets.
• Worked on following setups for report files in Crystal Enterprise 1 Export to disk Storage 2 Export a report Via FTP 3 Email and Disk report formats.
• Design number of Web components, objects with Visual basic 6.0 for the interface
• Worked on troubleshooting of different database connectivity, performance tuning. Optimized the performance of the database queries
• Participated in business requirements analysis, database design and modeling, development of technical specifications, testing and implementation
• Designed data base tables for modules and analyzed data integrity.
• Fixed many critical bugs in the Application.