SUMMARY:

• Dynamic, competent and result - oriented professional with 15+ years of experience in Analysis, Design and Development of various Data Warehousing projects.
• Hands-on lead for an agile team working in a continuous delivery model and conduct design & code reviews, sign off code for push to production.
• Working with an Agile, Scrum methodology to ensure delivery of high-quality work with monthly iteration.
• Worked on multiple RFPs, kickoff meetings with stakeholders, track backlogs, cost and effort estimation, scope definitions and signoff deliverables.
• Have experience in various BI Reporting tools SAP Analytics Cloud, SAP Business Objects, SAP Lumira, SAP HANA Analysis, Crystal Reports, Microstrategy, Tableau, Power BI, QlikView, SAS, Cognos and Sisense.
• Have experience in various ETL tools SAP HANA, SAP BW, SAP Data Services (BODS), SAP BPC/EPM, MS BI SQL Server Integration/Analysis Services (SSIS, SSAS) and Pentaho Data integration/Kettle (PDI).
• Have experience in various databases Oracle, SQL Server, Teradata and Snowflake.
• Proficient in BO Installation, Migration, Administration and Development activities.
• Have rich experience in universe modelling, reports design and dashboards development using various BI tools.
• Good knowledge in SAP HANA Modeling and implementation for data modeling using Packages, Attribute Views, Analytic Views, Calculation Views and Analytical Privileges.
• Data modeling (Dimensional & Relational) concepts includingStar-schema modeling, Snowflakes modeling, fact and dimension tables.
• Designed, tuned and maintained Quires, Views, Materialized Views, Functions and Stored Procedures.
• Expertise in Business Objectsenterprise Products(Universe Designer, Desktop Intelligence, Web Intelligence, Info View, CMS, CMC & CCM)and its deployment.
• Used advanced universe functionalities like Derived tables, Index Awareness, custom LOVs, custom hierarchies to aid in Drill-Through analysis of Webi reports and built cascading prompts.
• Extensively used various features likeJoins,AliasandContextsin Universe designer to overcome varioustraps (Chasm, Fan)andLoops.
• Worked on creating OLAP universe in IDT and UDT using BEx queries, Multiprovider, Info Cubes and HANA Models in SAP BO integrated environments for reporting application.
• BEx Reporting- Expertise in front-end Business Warehouse components (BEx Analyzer, Query Designer) for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, and Web application designer.
• Created complex Crystal reports including sub-reports, graphical reports, and formula base well-formatted reports according user requirements.
• Vast experience on Extraction, Transformation and Load (ETL) strategy, BI Strategy, design and implementation. Includes ETL across different platforms.
• Extensively worked in end to end data migration processes such as ETL processes, analyzing and development of objects in SAP BODS 4.x Designer by cleansing and data enrichment, data profiling.
• Experience in various transformations like Validation, Case, Merge, Pivot & Reverse pivot, Data Transfer, Table Comparison, Row Generation, History preservation, SQL etc.,
• Used Pentaho Data integration/Kettle (PDI) to design ETL process to extract data from various sources live system and external files, cleanse and then load the data into target data warehouse.
• Strong experience with Power BI, QlikView application design, development and scripting.
• Create Tables, listings and graphs using the SAS datasets with procedures such as DATA STEP, PROC
• Developed and modified SAS stored MACROS that are used in SAS Programs that create Reports.
• Created SAS views from Oracle database tables using SAS/Access and writing SAS programs using Base SAS and SAS/Macros to create reports. Evaluating and Prototyping dashboards in Sisense and have knowledge on Elasticube, Live Connection, Alerts, Filers, Add-ons, Custom Visuals and Multisource Data.

TECHNICAL SKILLS:

BI Tools: SAP Analytics Cloud, SAP Business Objects, SAP Lumira, SAP HANA Analysis, Crystal Reports, Crystal Xelsius, Microstrategy, Tableau, Power BI, QlikView, SAS, Cognos and Sisense

ETL Tools: SAP HANA, SAP BW, SAP Data Services (BODS), SAP BPC/EPM, MS BI SQL Server Integration/Analysis Services (SSIS, SSAS) and Pentaho Data integration/Kettle (PDI)

Database: Oracle, SQL Server, Teradata and Snowflake

Domain: Banking, Healthcare, Information Media & Entertainment, Manufacturing, Retail, Hospitality and Life Science

PROFESSIONAL EXPERIENCE:

Confidential

STP BI DEVELOPMENT PROJECT

Responsibilities:

• End to end ownership of deliveries to production - including analysis, planning, model, design, develop, code, test, debug, document and push to production.
• Developed Power BI and QlikView models using query editor, reports and dashboards.
• Expertise in writing complex DAX functions in Power BI, Power Pivot and load data into QVD file in QlikView. Used various sources to pull data such as Teradata, SAP HANA, Snowflake etc..
• Worked on creating OLAP universe in IDT and UDT using BEx queries, Freehand SQL and HANA Models in SAP BO integrated environments for reporting application.
• Maintain project schedules, tasks, identify problems and formulate alternative solutions.
• Hands-on lead for an agile team working in a continuous delivery model and conduct design & code reviews, sign off code for push to production.

Environment: SAP BO 4.2, Power BI, QlikView, SAP HANA, Snowflake, Teradata

Confidential

COGNOS TO BOBJ CONVERSION PROJECT

Responsibilities:

• Involved in End to End full life cycle of project right from the assessments, proposal, scope, requirements, understanding the customer project needs, deliverables, backlogs and weekly status.
• Worked on IDT to replicate the Cognos catalog into universes without missing any similarities.
• Provided to the business about the conversion activity about the universes.
• Documented the backlog items such as reports, securities defined on Cognos for approval from business leads to proceed with the next phases of the project.
• Documented folder securities for roles setup of business super users and end users.
• Folder and User Security defined based on business leads requests.
• Webi reports development of converting existing Cognos impromptu reports by identifying the SQL present in Cognos along with tables, joins, columns etc. The end results compared with both Cognos and BO reports.
• Advanced conducted to Canada business users on BOBJ reports for each groups.
• Run retrospectives, daily stand ups and continually improves processes, sprint plan prepared and coordinated with the team for the tasks timeline to the completion and worked with business leads for UAT sign off.

Environment: SAP BO 4.2, SAP Analytics Cloud, Cognos Impromptu, Microsoft SQL Server, Oracle

Confidential

BO MIGRATION PROJECT

Responsibilities:

• Involved in migration of BO 3.1 SP3 into New environment with similar setup for Learning Services.
• Cloned BO Servers with Clustered multi node environments using the Zerto replication tool.
• Configuration of IIS, Server, SMTP, Input/output FRS, Recurring Schedules and DB connection setup.
• Worked on User securities for developers and support team members for various Groups.
• Involved in BO system integration testing and universe and reports validation.
• Mass reports schedules, DB connections and Email notifications updated using JDK.
• IIS server configured for BI Launchpad both internet and intranet users by hitting the intermediate relay server.

Environment: SAP BO 3.1, SAP BW, Microsoft SQL Server, Oracle

Confidential

BODS UPGRADE PROJECT

Responsibilities:

• Involved in End to End Project tasks and understanding the customer project needs.
• Involved in upgrade of DS 4.0 SP4 to DS 4.2 SP09 version with compatible version of IPS 4.2 SP4
• Full Installation with Clustered multi node environments in Development, QA and Production.
• Configuration of Windows AD, System Configuration, Substitution Parameters, RFC Connection setup.
• Involved in Users Local Repo’s and Central Repo setup and Check-in all jobs.
• Worked on User securities for developers and support team members for designer and monitoring roles.
• Involved in generating batch jobs execute batch scripts for Tivoli third party schedules.
• Worked ondebugging of Jobs, Workflows, Data Flows, Formats, Data Store and Scripts.
• Worked on BODSAdministrationtasks like Repository Configuration, Job Server configuration, Local Repository configuration, Central Repository configuration, Job Scheduling, Monitoring.
• Scheduled the jobs, managed users and repositories in Management Console.
• Created theUsersandGroupsfor setup the user security as for business by usingIPS CMC.
• Involved in BODS system integration testing and batch jobs validation.
• Worked with business users for UAT approvals and signoff from business leads.
• Created and maintained the Cut-Over Plan and Go/No Go Live checklists.
• Ensured process measures are identified, tracked and prepared weekly status reports for reviews.

Environment: SAP BODS, SAP BW, SAP HANA, Microsoft SQL Server, Oracle, Tivoli

Confidential

CSL PACE SAP IMPLEMENTATION

Responsibilities:

• CSL BRIDGE is the foundational platform for Business Intelligence for CSL. Reporting, Analytics and Dashboards are available within the platform that will deliver business information to authorized end users via tools such as Web Intelligence, SAP Analysis for Office, Qlikview, Lumira and Crystal Reports.
• PACE is a global transformation initiative that fulfills our promise to Patients by aligning our processes and enhancing Collaboration to achieve sustainable business Excellence.
• Dashboard creation using SAP Lumira, SAP Lumira Discovery, Analysis for Office and Web Intelligence.
• Database sources as SAP HANA, SAP (BW) and Oracle Enterprise Data Warehouse.
• Developed dashboards using SAP Lumira Designer to include all the required KPI's.
• Created Global Variables, Bookmarks, Chart Picker, Excel Export, CSS and Filters in SAP Lumira.
• Performance enhancement on dashboards by applying Event Based trigger, Sequential and serial process.
• Involved in creating storyboards using SAP Lumira Discovery.

Environment: Business Objects 4.2, IDT, Webi, SAP Lumira, Analysis for Office, SAP Bex Queries, SAP HANA

Confidential

Responsibilities:

• To improve the user interface for the client portal for optimizing per FROG standards and to enhance BO reporting abilities in the client digital platform. Involved in various business enhancements initiatives that will cater to adding/improving functionality, reworking the reporting section thoroughly for all office users.
• Creation of new webi reports for replacing existing crystal reports to improve performance and Business View Manager Quires replaced by BO Universe.
• Worked on IDT in the creation of universe by understanding existing stored procedures and BV Quires.
• Worked on creating Groups/Users and assigned appropriate rights. Also worked on promoting objects across environment. Facilitating code movement into production and subsequent implementation support.
• Worked with support team to get the details of schedules of each report and provided with the required format that UI team expected to automate.
• Also worked with support team to perform load balance of each report using API to monitor the performance and documented the performance metrics.
• Worked with UI team for the reports parameters sync up to work properly from UI portal and bulk existing schedule creation from UI to avoid manual effort.
• Worked on collection of information on Preview and Edit functionalities of webi report from UI portal.

Environment: Business Objects XI R4.2, IDT, Crystal Report, Citrix, Jira, Oracle, SQL Developer, SharePoint.

Confidential

BI Team Lead

Responsibilities:

• Understanding the user Requirements and prepared Technical Specification documents for all the reports.
• Creating Dashboards using Tableau and publish, maintain the workbooks in different sites of Tableau server.
• Used Information Design Tool IDT to create connections to SAP HANA databases, Create data foundations and also created Business layer and publish these connections and layers to Repository.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards.
• Created complex formulas and calculations in Tableau to meet the needs of complex business logic.
• Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions, parameters and calculated sets etc., and published them to the web.
• Created complex data connectors and publish, maintain schedules on different sites in Tableau server.
• Creation of new reports according to user requirements and enhancements in BO universes & reports.
• Support of Business Object WEBI Reports, Universe handling issues. Planning of resources for the work involved in assigning the projects to the team members.
• Involve in knowledge transfer activity for newly onboard resource in the team.
• Evaluating and Prototyping dashboards in Sisense and have knowledge on dashboards, Elasticube, Live Connection, Alerts, Filers, Add-ons, Custom Visuals and Multisource Data.
• Estimates size of backlog items and Implementation of backlog items.
• Manage project timelines and communicate with client to ensure project progress satisfactorily.
• Facilitating code movement into production environment and subsequent implementation support.
• Worked with project managers and development team to resolve issues during the development cycle.
• Lead the offshore team and responsible for the deliverables and reviewing the code developed by the team.
• Review documentation and standards within the team and provide technical guidance to development teams.
• Call Center Operations data from three different environments CISCO, Salesforce and SAP (Calls, Cases and Orders data) into single target database transformed and loaded into SQL Server is a source for reporting.
• Imported data through flat files into SAP HANA and created schema and required tables.
• Used Information Design Tool to create Relational Connection, Data Foundation and Business Layer and accessed the data in HANA through Crystal Reports and Webi.
• Created Universes on top of HANA views and developed the Webi reports and dashboards.
• Created several complex Webi reports to help management to track and monitor Call Center activities.
• Created custom hierarchies to aid in Drill-Through analysis of Webi documents and built cascading prompts.
• Webi reports developed using Input Control and dimension linking functionalities. Also, the Dashboard built on Webi using drilldown and Hyperlink (OpenDocument) functionalities.
• Responsible for creating Derived Tables, Aggregated Tables using Aggregate Awareness concept, Custom LOVs, creating Indexes, views to increase the performance of the universe and reports.
• Worked with different data sources to combine data from different sources to generate a single report.
• Provided support for the users on application usage and conducted walk through of salient features.

Environment: Business Objects XI R4.2, IDT, SAP HANA, Cisco, SAP, Salesforce, SQL Server, SharePoint.

Confidential

BI Team Lead

Responsibilities:

• Effectively administered and supervised the Business Objects environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports.
• UsedQuery builderto query Repository and to recognize number of groups, users, active users, frequent users.
• Enabled auditing, created auditing reports, and maintained the enterprise repository includes security of Users, groups, predefined settings, reports, domains, and categories in the CMC.
• Created JDK utilities for BO mass recurring schedule change, DB update, destination update.
• Created complex Crystal reports including sub-reports, graphical reports, and formula base well-formatted reports. Cascading LOVs created using Business View Manager for Crystal reports.
• Applied advanced BO functionalities like conditional hiding, ranking, hyperlink, conditional sorts, alerter etc.
• Used derived tables in universe for complex logic and use context and alias tables to solve the loops and traps.
• Populated the tables using integrated data and perform auditing and cleansing jobs.
• Created complex Crystal reports including sub-reports, graphical reports, and formula base well-formatted reports according user requirements and Live office excel based reports created for Finance team.
• BEx Reporting, Expertise in front-end Business Warehouse components (BEx Analyzer, Query Designer) for Queries, workbooks, Calculated, Restricted Key Figures, Structures, Variables, Exceptions, Conditions.
• Used Pentaho Data Integration Designer to create ETL transformations. Developed ETL transformations that sourced from a variety of Heterogeneous sources including Text files, csv files, and json files.
• Made use of different transformations in PDI designer to cleanse and manipulate source data e.g. Database, Lookup & Join, Generate rows, Calculator, Row normalizer & demoralizer, Add constant, Add Sequence etc.
• Automated file transfer processes and mail notifications by using FTP task and Send Mail task.
• Created complex jobs in Pentaho using File encrypt/decrypt, slowly changing dimension concepts, json files types and lookup components like stream lookup, fuzzy match, check if column exists, Call DB procedure.
• Created batch files to schedule the Pentaho jobs based on trigger events using Windows Task Scheduler.
• Performed BO upgrades. Also performed Pentaho ETL upgrade to latest versions.
• Created different schema objects like Attributes, facts using MicroStrategy Architect.
• Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Custom Groups, Hierarchies, Templates and Reports
• Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
• Used project and user merge wizard to merge projects and merging users & groups in Object Manager.
• Lead Support and Development team activities and initiated weekly status review meetings with Customer.

Environment: Business Objects, Crystal Reports, SAP BW, Microstrategy, Live Office, Pentaho Data integration/Kettle (PDI), Salesforce, SQL Server, Oracle, Tortoise SVN, Service Now, SharePoint, Jira, Start Team, Toad, SQL Assistant.

Confidential

Senior BI Consultant - CMS Data Warehouse

Responsibilities:

• Working on the SQL tuning and optimization of the Business Objects reports.
• Develop stored procedures/queries and design the report layout using Crystal reports.
• Cascading LOVs created using Business View Manager for Crystal reports.
• Major responsibilities include getting requirements from the user, writing storedproceduresforreportsand developing reports usingCrystalReports.Maintaining documentation of the reports for future .
• Involved in writingstored proceduresto get data from database.
• Developed linked sub reports using shared variables,cross-tab,drill down and hierarchical reports.
• Created and maintainedUniversesupporting multiple levels of hierarchies fordrillreports.
• Created Joins, Contexts, and Aliases for resolving Loops and checked the Integrity of the Universe.
• Created Derived Tables in the Universe using views and stored procedures to meet the requirements.
• UsedTortoise SVNto store all the source code and its versions.
• Monitor SSIS scheduled jobs in Autosys and performed necessary troubleshooting.
• Designed SSIS Packages to extract, transfer, load existing data into target database from different sources.
• Created and Managed OLAP Cubes and Star Schema Cubes using SSAS.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases.
• DesignedDimensional ModelingusingSSASpackages for End-User.
• Involved in design, Analyze, build and testing of OLAP cubes in SSAS and adding calculations usingMDX.
• Created the Cube using SQL Server Analysis Services (SSAS) for BO Voyager (OLAP) reports.
• Created Database Objects, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Created aggregate tables and materialized views to improve query performance.
• Developedtest plans,preparingtest dataand performingunitandintegration testing
• Participated in designing and development of software using agile development practices.
• Review documentation and standards within the team and provide technical guidance to development teams.
• Responsible to maintain the documents on requirements, change requests and defect tracking.

Environment: Business Objects XI R3.1, UDT, BO Voyager, Crystal Reports, Business View Manager, SSIS, SSAS, SQL Server, Autosys, Tortoise SVN, SharePoint

Confidential

Senior BI Consultant

Responsibilities:

• Installed and configured Business Objects XI R2 with Enterprise Performance Management.
• Primary architect and developer for full life cycle of Business Objects Enterprise platform.
• Interacted with the Business Users to analyze the business process and gathered the requirements, made necessary changes to schema objects to fulfill their reporting and business needs.
• Used Dashboard and Performance Manager to create Metric, Goals and Used universes for analytics creation.
• Customized the dashboards and KPI’s for better manageability of overall performance.
• Applied security features of row level & object level security in the universe to make the sensitive data secure.
• Scheduled Metrics, Analytics and Rules through AF Schedule objects (Program Job server)
• Performed knowledge transfer and conducted user .

Environment: Business Objects 6.5, XI R2, UDT, Enterprise Performance Management, Crystal Report, Oracle, SQL Server, Visual SourceSafe, SharePoint

Confidential

BI Consultant

Responsibilities:

• Involved in the full life cycle of Business Objects Enterprise platform. Installed and configured the environments of development, QA and production.
• Created repository and security domain with user groups, security implementation and migrated BO servers from BO 6.5 to XIR2 using import wizard.
• Extensive analysis to design the Universes and assign them to respective domains. Created complex views to overcome loops, contexts and used aggregate awareness in universes.
• Created Auditor reports and Business Views for cascading Dynamic Prompts.
• Developed Deski and Webi reports on top of the OLAP universe and created various templates and reports using functionality of Business Objects like query prompts, Slice & Dice, Breaks, Filters, Alerters, etc.
• Migrated 1500+ Crystal, Webi reports, Universes, Dashboards along with their data sources.
• Enabled WindowsAD authentications with Kerberosalong with enterprise aliases for XIR2
• ConfiguredSMTP, destination job servers, CMS, crystal reports, Webi servers, RAS, Adaptive job servers
• Extensively used Import wizard for transporting objects and folders to new environment.
• Used Dashboard Manager and Performance Manager to create Metric, Goals.
• Customized the dashboards and KPI’s for better manageability of overall performance
• Created and Customized Dashboards for users. Created various analytics likeSpeedometers, Interactive Metric Trends (IMT) and Barometers using Enterprise Performance Management.
• Build dataflow, workflows, variables and customized functions in BODS Projects.
• Scheduled Metrics, Analytics and Rules through AF Schedule objects (Program Job server)
• Created Data Services mappings involved extensive use of complex transformations like Key Generator, SQL Query, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows.

Environment: Business Objects 6.5, XI R2, UDT, Enterprise Performance Management, Crystal Report, BODS, Oracle, SQL Server, Visual SourceSafe