EXPERIENCE SUMMARY:

• 12+ years of experience in BI reporting, as a Lead software developer involved in the design, development, maintenance and support of SAP Business Intelligence Applications including SAP Business Objects XI 4x/3x/XIR2/6.x, Xcelsius, Dashboard Designer, Design Studio, Lumira, Tableau and SQL as a part of the Decision Support Systems (DSS) initiatives.
• Proficient in all phases of the Software Development Lifecycle(SDLC(Water Fall & Agile methodology)) including Requirements gathering, Analysis, Design, System Implementation, Performance Tuning, Testing and Support.
• Excellent experience with DW Concepts such as Star schema, Snowflake Schema, Fact, Dimensional tables, physical and Logical data modelling.
• Well versed in SAP Business Objects XI 4x/3x/XI R2 Enterprise Suite (Universe Designer, Information Designer tool (IDT)), Web Intelligence, Promotion management/ LCM, Central Management Console (CMC), and Import Wizard.
• Experience in building Universes, Free Hand SQL methods and creating Complex and Ad - Hoc Reports using SAP Business Objects.
• Experienced working with Universe Designer and Information Designer Tool.
• Experienced in Migration process of the SAP Business Objects 3.x to 4.x.
• Extensive experience in interacting with business users, business owners for requirements gathering, analyzing business process and making necessary changes to schema objects to fulfil reporting needs.
• Experience in using various RDBMS like Oracle 11g/9i/8i, SQL Server 2005/2008.
• Involved in designing Databases and data marts on Oracle/Access. Widely used TOAD (Oracle) and SQL Server Management studio to write complex queries to check for data quality, performance of reporting queries and tweaked them to reduce run time.
• Created Indexes, Partitioning tables and executed the explain plan to check the statistics.
• Experience in defining best practices for Tableau report development.
• Experience in Developing Score cards, Prompts, Drills, Reports/Dashboards.
• Extensive experience in designing/Support for Tableau dashboards.
• Experience in Business Analysis, Data Migrations, Data Processing, Quality Analysis and Project Management.
• Well versed in developing Dashboard designer and Xcelsius.
• Experience in front-end Business Warehouse (BW) Components like Queries, Calculated Key figures, Restricted Key figures, Structures, Variables, Exceptions, and Conditions.
• Designed and Developed universes using SAP BEx Queries, Multiprovider and relational sources.
• Knowledge and understanding on SAP HANA, and hands on experience on HANA studio.
• Successfully implemented SAP HANA (Proof of Concept).
• Experience on Prototyping the new technologies like SAP Lumira, SAP Design Studio and SAP BO Mobility (Proof of Concept).
• Experience in creating SAP BEx Queries using calculated and restricted key figures, variables, structures, Exceptions and conditions.
• Experience in building SAP BO Universes with DB Stored Procedures as a data source
• Expertise in configuring Distribution Services to enable Subscriptions to be delivered to file/e-mail.
• Hands-on experience working with Query optimization and Performance.
• Involving in Estimates and project plans.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Keen interest in learning new technologies.

TECHNICAL SKILLS:

Business Intelligence: Business Objects XI R3.1/R2/XI/ 6.5/6.1/6.0/5.1 (Designer, Desktop Intelligence, Web-Intelligence Rich Client, Infoview, Web-Intelligence, Xcelsius, Web-I SDK, Broadcast Agent, Import Wizard, Publisher, Auditor, Application Foundation Dashboard Manager, Report Writer, BO Set Analyzer, Query as Web Service, Business View Manager, Query Builder, Report Conversion Tool, Application Foundation & Dashboard Manager),Crystal 2008, Business Objects SDK. Informatica Power Center 8.6.1/8.1/8.0/7.1.2 , (Designer, Repository Manager, Workflow Manager, Workflow Monitor),Data Services, ETI, Data mart, OLAP, OLTP,Mapplet, Transformations, SQL*Plus, SQL*Loader, BW, Bex, Netweaver 7.x Tableau, SAP Lumira,SAP Design Studio.

Business Analysis: Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, Data Analysis, Requirements Analysis, Design, Data Modeling, Data Architecture, Data Flow, Data Cleansing

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.5/4.0/3.5/3.2 , Oracle Designer, Visio and Sybase Power Designer.

Databases: SAP HANA, MS SQL, MS ACCESS, Postgres SQL, MySQL, Oracle, DB2,Teradata

Servers: Windows Servers, Linux Environment, Unix

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Project Lead

Responsibilities:

• Worked on the projects for Data Segregation for Confidential . Which includes Data Security for Multi-Tenant Organizations
• Worked on Gathering requirement from the Multi-Tenant Stake Holders and providing the Data Segregation for the Business Objects Reports and Tableau Dashboard.
• Worked on creating new reports and Universe with multi data source universe.
• Designed and developed universe in both IDT and UDT.
• Worked on creating complex reports with multiple data providers
• Created Custom SQL and Free Hand SQL reports based on the Requirements.
• Worked on CMC, CCM, PMT and other Admin tools and have delivered Admin activities.
• Analyzing end to end business requirement and converting it into project scopes with technical and Functional Specifications
• Have developed and have done enhancements to Crystal reports.
• Worked with ETL teams in converting the Data from different data sources to support same business applications.
• Worked on creating ETL jobs for data scope for ODS environments.
• Worked on Creating the PL/SQL views and Procedures to implement data security.
• Have worked on Oracle Hash Functions and Replication DB for the MPP system implementation for better performance of the Oracle.
• Worked on ITIL models for Operational activities.
• Worked on Row Level security in the Business Objects Universes
• Involved on Onsite - Offshore coordination in giving continuous project deliveries.
• Doing proper unit testing/UAT on the project scope for the business
• Worked on creating Tableau Dashboard and Stories with interactive charts.
• Have done multiple POC’s and Wireframes for the business and have done the Dashboards for the business.
• Worked on Implementing SAP BO on AWS Cloud systems and managed BO Clustered environment

Environment: Business Objects 4.2, BODS, SSIS, Tableau, MSSQL, Oracle 12G, AWS

Confidential, Cincinnati, OH

Technical Leader - Business Intelligence

Responsibilities:

• Managing Onshore and Offshore teams for the Business Intelligence Activities which includes Business Objects, Tableau and DataStage ETL
• Worked on Coordinating the Onshore/Offshore teams conducting regular meetings
• Concentrating on Project development and Incident Management for the Consumer Business Intelligence Group for the Bank for BO, Tableau and ETL
• Involved in Business Objects Universe Developments, Universe Enhancements, Auditing Users and Groups, Creating Webi Reports for the Stakeholders
• Migrations of Business Objects 3.1 Environments to 4.1 Environments
• Connected Business Objects universes in Oracle Essbase Cubes and have created reports
• Worked on Complex reports with Multiple Data Providers
• Worked on Data Modeling in Erwin Tools.
• Worked on Performance Optimization of BO Reports and made considerable optimization using Aggregate awareness and Index.
• Enhancement on the reports for various business requirements.
• Worked on Critical project Deadlines and Deliverables.
• Creating and Supporting Xcelsius dashboards
• Created various Tableau Reports for Internal and Business needs with different chart representation.
• Acted as a Tableau Site Admin for the whole team.
• Created Tableau Visualization for Monitoring the ETL job flows.
• Worked on IBM Information Server (Datastage) and have created jobs and monitored the jobs and the job flows.
• Supported the ETL jobs by the time of the Job aborts
• Created Tableau reports on the data flow of the ETL and tracked the Jobs.

Confidential, Minneapolis MN

Business Objects Lead

Responsibilities:

• Managing the Team and coordinating the Business Activities.
• Have Done POC for the Customer based on the requirement.
• Created Data Flow Diagrams (DFD) to define the data element flow to the most granular level to translate data requirements to ETL processing
• Worked in Agile methodology, had regular Status calls with the Client.
• Done ETL implementation Jobs for mapping database for transactional purposes.
• Have Done Design Documentation including High Level and Low Level Documents.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Created Universe with Complex functionality Including aggregate awareness and Conditional Filters.
• Cleared Fan/Chasm Traps with various trap clearing methods such as Short Cut joins, Context and Alias
• Created Reports in BI Launchpad with Multiple Data provider.
• Created complex report with applying logics for multiple variables for a high calculation reports.
• Worked on Date functionalities to change the data formats.
• Worked extensively on performance management for reports.
• Created Xcelsius Dashboard with multiple functionalities and tabs to retrieve data.
• Created Tableau Visualization Reports.
• Integrated Tableau and BO universe with Toreo Data Tool
• Created various Cache reports for the Dashboards.
• Developed various Charts and Graphs like Bar chart (Side By Side, Stacked), Line graphs, Pie -Charts etc by using Chart expert of Reports.
• Have done Unit testing, done Bug Tracking and have also created Test cases for the same.
• BO Support Activities.
• Installed Tableau Server and Desktop.
• Worked on creating BO reports on Teradata Systems.
• Creating Users and Groups.
• Scheduling the Reports.
• Windows AD SSO configuration and Management.
• Worked in BO Backup and restore activities through Promotion Management tool.
• Maintain Audit/CMS database.
• Communicating with SAP Support for Product support.
• Consulted on Tableau server performance enhancements; upgrades from version 8.1.5 to 9.2 and server reconfiguration based on workbook complexity and data extraction
• Customized the Tableau landing page with site listing as icons and descriptions
• Constructed the reports page for internal strategy group with standardized custom right and left side sections within Tableau

Environment: Business Objects 4.1, Oracle 11G, Tableau 8.0, 8.1.5, 9.2, Informatica, Teradata

Confidential

BI Infrastructure Lead, Lexington, KY

Responsibilities:

• Gathering Business Requirements and documenting
• Migrating Business Objects 3.1 to 4.1
• Worked on HANA Installation in Amazon Web Service and Linux Suse Machine.
• Worked closely with SAP Technical team on implementing the First Customer's project on HANA.
• Involved in installation of SAP HANA 1.0.17 in two environments.
• Involved in installation and configuration of SAP Business Objects Data Services 4.0.
• Used SAP BW/SAP CRM/Oracle as source and HANA as target with SAP Data Services as the Integrator.
• Developed Jobs in SAP Business Objects Data services which do the ETL between BW/CRM/Oracle and HANA.
• Worked closely with WEBI Reporting team on the requirements.
• Involved in Support and Monitoring activities after go-live.
• Involved in enhancements of Data Services Jobs, HANA Models and applying Patches on HANA.
• Following the ITIL Concepts in the Change and Release Management
• Have Connected SAP BW/HANA as a source and have done BO reports.
• Worked Extensively in Universe Designer and Web Intelligence. Worked on Infocubes and Bex Queries.
• Installed Tableau Desktop
• Created Data Visualizations on Tableau.
• Have worked on Complex Reports with Multiple Data Providers.
• Worked on Data blending on Tableau
• Worked on Different Charts and Maps in Tableau

Environment: s: Business Objects 4.1, HANA 1.0.17, BODS 4.2, Tableau 8

Confidential, Houston TX

Application Specialist

Responsibilities:

• Working on BMC Analytics for BSM which is working on SAP BO.
• Working on ITSM universe and performing Installation, Migration, Creating Users and Other BO Administration for various Federal and Other clients in US through remote.
• Working on Functional Requirement at ITIL terms.
• Recommendations for ITSM installation with ITIL concepts.
• Done ITIL process management.
• Done interaction with the client in getting the Business requirements.
• Development of Reports and Universe based on ITSM needs.
• Backup Activities through BIAR UDT and PMT tools
• Done patches and Service Pack Installation.
• BO License Management.
• Configured Atrium SSO, Windows AD and LDAP
• Have worked on Linked universes.
• Worked extensively in the BO support activities.
• Has communicated with SAP support on various issues and have supported the End Clients.
• Worked on the Down times of the Server and making the system up and running.
• Worked on Creating User groups and Access restrictions.
• Have acted as Migration Specialist and have done migration from R3 to R4 versions.
• Interacting with the customers and helping them as per the Business needs of the customers.
• Performance Tuning Activities of the Universe, Reports & Servers.

Environment: Business Objects XI R3.1, 4.X CMC, CCM, MS-SQL 2012, UDT, IDT, PMT, UMT, Import Wizard

Confidential

Sr. Business Objects Counsultant, Indianapolis, IN

Responsibilities:

• Worked as a Business Objects Associate in a BO migration Project from Crystal Reports to BO
• Gathered Requirements from the Client and through Business Analyst.
• Documentation of reports which Includes HLD(High level Design) & LLD(Low Level Design)
• Analyzing Stored Procedures and converting into BO Reports.
• Created complex universe with Aliases Table and Derived table.
• Working on conversion of Enrolment and Disenrollment reports which was running on Crystal Report.
• Done complex reports with multiple query’s and multiple data providers.
• Have created many conditional objects in the universe.
• Have worked on Query level filters and Report filters.
• Migration Activities like Migration of the reports and universe from Development environment to Testing, UAT, Performance and Production.
• Supported the BO Admin team in terms of Admin activity.
• Leaded a team of 4 and made them to work independently on the tasks assigned.
• Motivated and trained the team in completion of the project.
• Have created Unit Testing Test cases and done unit testing.
• Creation of BO universe and reports
• Conducting reviews with the Client and Business users
• Coordinating with the BO Admin Team in Migration of reports & Universe to various environments.

Environment: Business Objects XI R3.1, Crystal Report, Webi, MS-SQL 2012

Confidential, Milwaukee, WI

SAP- Business Objects Consultant

Responsibilities:

• Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation.
• Gathered Customer, User and Owner requirements; analyzed and documented them.
• Created Data Flow Diagrams (DFD) to define the data element flow to the most granular level to translate data requirements to ETL processing
• Integrated with Business Intelligence ETL team to give out better performance.
• Extensively used Business Objects Designer to design and maintain Data warehouse Universe.
• Expertise in migrating, testing and troubleshooting the Business Object XIR2 to XI3.1 content and environment
• Setup, execute, and test the assigned programs utilizing BO XI3.1 Webi and DeskI tools.
• Worked on creating Universes using the Business Object Designer and connected to the database using ODBC. Resolved join problems, fan and chasm traps using aliases and contexts.
• Creation of reports like Reports by Product, Reports by Customer, Reports by Period, Demographic reports and Comparative reports, Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Developed ad-hoc and recurrent reports from a number of internal and external data sources like Oracle, MS ACCESS which has ODBC links from Data ware house.
• Created complex reports using WEBI, DESKI and WRC with multiple data providers.
• Developed various Charts and Graphs like Bar chart (Side By Side, Stacked), Line graphs, Pie -Charts etc by using Chart expert of Reports.
• Have sound knowledge in Excel -- Created graphs using Pivot tables and written VB scripts for macros.
• Used Complex EXCEL formulae v lookup and H LOOKUP to generate complex Dashboards.
• Experience on creating dashboards using Xcelsius by importing data file to create the visualization utilizing QAAWS and Live office connection.
• Created Dashboards in Crystal Xcelsius 2008using Charts, Selectors, Gauges, Maps, Arts and Background and Web Connectivity
• Scheduled and monitored reports using Broadcast Agent Console.
• Created, refined and delivered functional test materials collaborated with test cases, set up test plans, schedules and scenarios.
• Used Business Objects Central Management Console in creating and managing the users, giving access permission for Business Objects Reports.
• Responsible for designing many SQL queries, procedures, Cursor, Triggers.
• Written dynamic PL/SQL procedures, which were used for porting and generating data and responsible for optimizing SQL queries and Stored Procedures.
• Tuned Report Performance by exploiting the Oracle’s new built in functions and rewriting SQL statements.
• Created parameterized and summary Crystal reports and tested them thoroughly.
• Customized existing reports for presentations using Cross-Tab reports. Developed sub-reports, Running Totals, Sorting, Alerting, used Crystal syntax to create formulas for the reports.
• Involved in the creation of Cross Tab Reports and Sub Reports using Crystal Reports with different data sources like Oracle and MS ACCESS.9
• Designed, implemented and maintained enterprise-wide application via Visual Basic and SQL database.
• Enhanced server database with Stored Procedures, Indexing, Triggers and performance analysis functions.
• Trained end users in understanding the reports. Functionalities such as Slice and Dice, Prompt, Drill mode and Ranking were used for Multidimensional Formatting.
• Expertise in using Import Wizard and Report Conversion Tool for migrating the Universes and Reports between different environments like Dev, QA and Production and converting Deski reports to Webi

Environment: Business Objects XI3.1/XIR2/6.5/6.1,Data Integrator XI, Dashboard Manager, Web I 6.1, Deski, Windows 2000/NT, SQL, Oracle 10g, T-SQL scripts, TOAD,PL/SQL, MS ACCESS, DTS.

Confidential

Business Objects Developer

Responsibilities:

• Gathered Customer, User and Owner requirements; analyzed and documented them.
• Migrated Report, universes, user from XIR2 to XIR3.
• Troubleshooting BO XI installation and migration issues.
• Experience in Warehouse development, working with Data Migration, Data Conversion and Extraction/Transformation/Loading using Data Integrator and Data Services with Oracle PL/SQL.
• Experience in administration of Business Objects XI Enterprise Suite (Desktop Intelligence, Central Management Server, Central Management Console, Auditor and Dashboard Manager).
• Setup, execute, and test the assigned programs utilizing BO XIR3 WebI and DeskI tools.
• Extensively used Business Objects Designer to design and maintain Data warehouse Universe.
• Responsible for Universe Designing, Hierarchy Building for Data Analysis and applied conditions in Business Objects.
• Creation of reports like Reports by Product, Reports by Customer, Reports by Period, Demographic reports and Comparative reports, Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Developed standard canned, ad-hoc reports & crystal reports.
• Developed more than 25 Full client and thin client (WebI) reports for all modules and update to version 6.
• Use of BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Designed, developed, tested and maintained highly complex reports.
• Used query as a web services and live office for automation of Dashboards.
• Scheduled and monitored reports using Broadcast Agent Console.
• Deployed the development and QA domains to reduce the server loads and to increase the performance.

Environment: Business Objects XIR3/XIR2,Crystal Reports 2008, Data Integrator XIr2,Dashboard Manager, Xcelsius 2008, Web I 3.2, Deski, Windows 2000/NT, PL/SQL, T-SQL scripts, TOAD