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 teh migrations, promotions, testing, performance tuning for reports and Dashboards.
• Working as a Business Objects Administrator / Architect to design teh reporting solutions as per Business needs . design teh 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 teh 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 teh 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 teh 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 teh 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 teh Design on WEBI, Crystal Reports, Dashboards, Business views, business Intelligence layer (Universe) using BI 4.1 Suite tools .
• Work on Changes / Modifications in teh BI layer to accommodate business rules and to improve teh performance of Dashboards, Reports.
• Trouble shoot Performance issues -Work on bottle necks which causes to run teh 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 teh 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 teh business rules and requirements .Worked with business users to explain teh 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 teh detail Upgrade plan with study of BO 3.1 set up and teh 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 help business users for teh reports requirements.
• Oracle Database: Worked on data and reporting requirements to recommend and design solutions through teh creation of appropriate database structures, reports and query structures.
• Worked with Database design team to articulate teh reporting needs using teh DB tools and objects.
• Test Cases: Used proactive approach to develop teh test scripts; troubleshooting reports for teh 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 teh 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 teh detail Upgrade plan with study of BO R3 and set up and teh 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 teh business team for teh requirements gathering and other technical issues fixes in teh environment
• Worked on and release plans for teh applications, actively involved in Data center moves and teh disaster recovery failovers
• Migration scripts, implementation scripts for Business objects products.
• Bug fixes, guiding teh team for teh 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 teh BOXI Architecture in cluster and HA mode
• Business Objects: Laid out teh 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 teh software files, setting up teh environment files, running teh .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 teh contents with jar commands.
• Documented teh steps to follow for another installation on different server.
• Worked on creating Universes, Business Intelligence Layer for end users to develop teh on line reports and statements.
• Worked on Import and Export of teh Universes on teh BO XI server, with teh changes in Database Objects.
• Security setup for teh 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 teh Services in cluster Environment.
• Universe Design and development of Web intelligence reports, dis includes teh Financial statements for teh QA and Data analysis.
• Migration of Desktop intelligence reports to Web intelligence documents.
• Crystal Reports: Published reports and universes in different environments along with teh 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 teh universe design.
• Designed for teh universes with different data bases using DB connections.
• Worked on links and class objects in universe, Worked on integrity checks while refreshing teh universe for teh DB changes.
• Worked on Query designer to build teh reports in teh 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 teh 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 teh links.

Confidential, Bedminster NJ

Web Reports Analyst

Responsibilities:

• ASP.net: Developed ASP.net application for reports access on teh web.
• Written number of ASP.net pages to integrate teh crystal enterprise 10 report application server components.
• Written number of ASP.net pages to integrate teh crystal enterprise 10 report application server components.
• Written ASP application to view teh report in DHTML, JAVA, and ActiveX viewer. Also written ASP pages to export teh report in various formats like Excel, .PDF, text etc. and to download teh report on user desktop.
• Crystal Reports / CE 10: Worked on design of complicated reports using sub reports and grouping functions.
• Configured teh 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 teh 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 teh interface
• Worked on troubleshooting of different database connectivity, performance tuning. Optimized teh performance of teh 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 teh Application.