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, Looker, Google Analytics (GA4), Looker, Tibco Spotfire and Cognos.

Have experience in various ETL tools SAP HANA, SAP BW, SAP Data Services (BODS), SAP BPC/EPM, MS SQL Server Integration/Analysis Services (SSIS, SSAS) and Pentaho Data integration/Kettle (PDI).

Have experience in various databases Oracle, SQL Server, Teradata, Big Query and Snowflake.

Proficient in BO Installation, Migration, Administration and Development activities.

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 including Star-schema modeling, Snowflakes modeling, fact and dimension tables.

Designed, tuned and maintained Quires, Views, Materialized Views, Functions and Stored Procedures.

Expertise in Business Objects enterprise 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 like Joins, Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops.

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.

Experience in Google Analytics (GA4), Universal Analytics, Google Tag Manager (GTM), Looker Studio

Used LOD (Level of Details) functions like Fixed, Include and Exclude in Tableau.

Proficiency with Cognos Report Studio, Analysis Studio, Query Studio, Framework Manager, Transformer.

TECHNICAL SKILLS

BI Tools: SAP Analytics Cloud, SAP Business Objects, SAP Lumira, SAP HANA Analysis, Crystal Reports, Crystal Xelsius, Microstrategy, Tableau, Power BI, QlikView, Cognos, Google Analytics (GA4, GTM), Looker and Spotfire

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

Database: Oracle, SQL Server, Teradata and Snowflake, Google Big Query

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

CERTIFICATION

C_ACTIVATE_13: SAP Certified Application Associate - SAP Activate Project Manager

C_SAC_2021: SAP Certified Application Associate - SAP Analytics Cloud

C_SACP_2021: SAP Certified Application Associate - SAP Analytics Cloud: PLANNING

C_EPMBPC_11: SAP Certified Application Associate - SAP Business Planning and Consolidation 10.1 and 11.0

PROFESSIONAL EXPERIENCE

ELEMENT TECHNOLOGIES INC DATES AUG 2022 – PRESENT

Client: CBRE Group, Inc. Sep 2022 – Present

Project: DIGITAL MARKETING PROJECT – Customer Intelligence Initiative San Antonio, TX

Maintain, and continually improve digital analytics systems via Google Tag Manager, Google Analytics, Google Data Studio (Looker), Power BI and other digital analytics technologies.

Implement analytics configurations for Google Analytics including GA4 via GTM.

Developed reports and dashboards using Power BI and written effective DAX formulas and expressions.

Used various sources to pull data into Power BI such as flat files, Snowflake, Big Query and GA4.

Working on Big Query to validate data against GA4 and transform data into Snowflake for the Power BI.

Working on Snowflake scripts, stored procedures and Tasks to automate the dashboard process.

Responsible for the documentation of the automation which includes Snowflake and Power BI.

Created Looker studio dashboards using Google Analytics website traffic data.

COGNIZANT TECHNOLOGY SOLUTIONS DATES OCT 2007 – JUL 2022

Client: 3M Company Apr 2021 – Jul 2022

Project: STP BI DEVELOPMENT PROJECT Saint Paul, MN

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 S/4HANA CDS views, BEx queries, Freehand SQL and HANA Models in SAP BO integrated environments for reporting application.

Developed reports and dashboards using Power BI and written effective DAX formulas and expressions.

Implemented several DAX functions for various fact calculations for effective data visualization in Power BI.

Hands-on lead for an agile team working in a continuous delivery model and conduct design & code reviews.

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

Client: Cargill Inc. Apr 2020 – Mar 2021

Project: COGNOS TO BOBJ CONVERSION PROJECT Saint Paul, MN

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 training 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.

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 training conducted to Canada business users on BOBJ reports for each groups.

TIBCO Spotfire reports developed and converted few reports into Webi reports.

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

Client: Pearson & Learning Services Dec 2019 – Mar 2020

Project: BO MIGRATION PROJECT Saint Paul, MN

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

Client: Levi Strauss & Co. Aug 2019 – Nov 2019

Project: BODS UPGRADE PROJECT Saint Paul, MN

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 on debugging of Jobs, Workflows, Data Flows, Formats, Data Store and Scripts.

Worked on BODS Administration tasks 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 the Users and Groups for setup the user security as for business by using IPS 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.

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

Client: CSL Behring Jan 2019 – Jul 2019

Project: CSL PACE SAP IMPLEMENTATION King of Prussia, PA

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

Client: BNY Mellon May 2018 – Dec 2018

Project: Private Work Bench Portal Enhancement Chicago, IL

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 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.

Client: PepsiCo, Inc. Jun 2017 – Apr 2018

Project: BI Team Lead – BIS-GPS Chicago, IL

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.

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.

Tableau visualizations using filter actions, highlight actions, parameters and calculated sets etc.,

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 BO WEBI Reports, Universe handling issues. Planning of resources work involved in assigning the projects to the team members. Estimates size of backlog items and Implementation of backlog items.

Manage project timelines and communicate with client to ensure project progress satisfactorily.

Environment: Business Objects XI R4.2, IDT, Tableau, Sisense, SAP HANA, Teradata, Rally, Borland Start Team

Client: Allergan Oct 2016 – May 2017

Project: BI Team Lead – Call Center Reporting Austin, TX

Lead the offshore team and responsible for the deliverables and reviewing the code developed by the team.

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.

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.

Webi reports developed using Input Control and dimension linking 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.

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

Client: Houghton Mifflin Harcourt (HMH) Jun 2011 – Sep 2016

Project: BI Team Lead Orlando, FL

Used Query builder to query Repository and to recognize number of groups, users, active users, frequent users.

Created JDK utilities for BO mass recurring schedule change, DB update, destination update.

Created complex Crystal reports including cascading LOVs created using Business View Manager.

Used derived tables in universe for complex logic and use context and alias tables to solve the loops and traps.

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 to cleanse and manipulate source data.

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.

Created different schema objects like Attributes, facts using MicroStrategy Architect.

Recreated or convert few Spotfire reports to Business objects reports.

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

Client: United Healthcare (UHG) Oct 2007 – May 2011

Project: Senior BI Consultant - CMS Data Warehouse Chennai, India

Develop stored procedures/queries and design the report layout using Crystal reports.

Cascading LOVs created using Business View Manager for Crystal reports.

Developed linked sub reports using shared variables, cross-tab, drill down and hierarchical reports.

Expertise in Business Objects enterprise Products (Universe Designer, Desktop Intelligence, Web Intelligence.

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.

Used various features like Joins, Alias and Contexts in Universe designer to overcome traps and Loops.

Worked on creating OLAP universe in IDT and UDT using BEx queries, Multiprovider, Info Cubes.

Designed SSIS Packages Monitor SSIS scheduled jobs in Autosys and performed necessary troubleshooting.

Designed Dimensional Modeling using SSAS packages for End-User and created SSRS Reports.

Involved in design, Analyze, build and testing of OLAP cubes in SSAS and adding calculations using MDX.

Created the Cube using SQL Server Analysis Services (SSAS) for BO Voyager (OLAP) reports.

Created DB Objects, Tables, Indexes, Views, functions, Triggers, Stored Procedure, materialized views.

Environment: BO XI R3.1, Voyager, Crystal Reports, Business View Manager, SSIS, SSAS, SSRS, Autosys

MMTECH SOFTWARE PVT LTD DATES FEB 2006 – SEP 2007

Client: Jafza (Jebel Ali Free Zone) & Tatweer (Dubai Holding) May 2007 – Sep 2007 Dubai, UAE

Client: National Bank of Oman (NBO) Feb 2006 – Apr 2007 Muscat, Oman

EDUCATION

Master of Computer Applications, SCSVMV(Deemed University), Kanchipuram, TN, INDIA

Bachelor of Science in Mathematics, Madurai Kamaraj University, Dindigul, TN, INDIA

EMPLOYMENT SUMMARY

ELEMENT TECHNOLOGIES INC August 2022 – Present

COGNIZANT TECHNOLOGY SOLUTIONS October 2007 – July 2022

MMTECH SOFTWARE PVT LTD February 06 – September 2007

Contact this candidate