Hadoop/Tableau/PowerBI/SAP BusinessObjects

Summary

A highly experienced, results-oriented, technology leader, skilled enterprise data architect who over a 14-year career has demonstrated the ability to lead cross-functional teams of professionals in achieving mission critical results in a variety of highly competitive industries, cutting-edge markets, and fast-paced environments. A broad professional background and an excellent education provide a solid foundation to solving challenging business problems with innovative enterprise solutions that leverage and align IT capabilities with evolving business needs. Her experience includes IT, Retail, Sales, Finance, and Insurance (Claims, Life, Auto, Property, Investment Banking) domains. A result driven architect with rich experience working on end-to-end analytic solutions and delivering technology solutions and creating operational efficiencies.

Career Highlights

Manager & Architect

Responsible for managing projects including solution design, project, risk, and mitigation planning along with end to end execution. Utilized Agile, Scrum, and Kanban techniques while executing continuous delivery.

Led planning sessions with Product Owner, SME’s of functional areas and come up with strategic major & quick wins Use Cases. Assisted the development of initial business requirements. Developed a Data Management Process with work products and templates.

Responsible for developing information strategies and roadmaps, as well as, delivering analytical solutions to support the business. I was also responsible for promoting ways to use data and analytics to meet enterprise business needs best, and facilitating a consistent approach to developing, accessing, and applying data across the enterprise.

Worked with business stakeholders, other shared services organizations, development teams, corporate groups, and vendors to implementation of Enterprise Data Lake solution using Hadoop, Tableau, PowerBI, BusinessObjects.

Provided direction on the development of the Data Mart and Dashboards to support the operational and analytical reporting needs of the multiple functional business areas.

Subject Matter Expert in Data & Analytics with extensive hands on experience in conducting landscape assessment, Solution Conceptualizing, Architecting, Data and reporting solutions.

Implemented POC to determine if virtualization solutions would scale and work with the cloud as well as on-premises to hide technical complexity from data customers.

Provide timely and accurate project status information to our PMO team, escalate project issues appropriately, mentor cross-functional project team members, and identify and share implementation best practices with them.

Technologies and Skills

Data Warehousing and Analytics:

High Volume Data Integration (Analytic and Operational), Complex Data Analysis and Research, Data Quality and Data Profiling

Big Data Ecosystem & Automation Tools:

HDFS, MapReduce, Yarn, Pig, Hive, Sqoop, Spark, Scala, Zookeeper, RPA UI Path

Programming Languages and Reporting Tools:

Python, Spark, Scala, Tableau, Power BI, SAP BusinessObjects

SAP Platforms:

S/4 HANA, SAP HANA, SAP BO Profitability & Cost Management, SAP BW, SAP Analytics on Cloud, SAP BusinessObjects.

Storage Platforms:

DB2 (zOS, LUW), Oracle, SQL Server, HDFS, Postgres, SAP HANA, Windows File Systems

Data Governance Tools:

Informatica EDC

Professional Training: Problem Solving and Decision Making, Data Modeling, Requirements Modeling, Data Warehousing and Big Data Concepts, Project Management and Teambuilding Techniques, Project Methodologies (Iterative/Agile/Kanban and Waterfall), Conflict Management, Data Movement and Data Migration Methodologies, Vendor Management

Agile: Certified ScrumMaster.

Professional Experience

Cognizant Technologies Feb 2011 – Current

Role: Manager & Technical Architect

Manager & Technical Architect of Cognizant EAS Practice, actively working on various proposals for new/ existing customers, providing architectural solutions as per business needs, added value and thought leadership. Provide a technical solution to numerous internal and external customers, which aligns their business objectives with their IT capabilities. Handling Country Financial and BNYM accounts - resourcing, delivery, escalations as EAS Account Manager.

Client: Country Financial, Bloomington, IL

Role: Data Architect

Responsible for full development life cycle including requirements analysis and design. Authored technical specifications based on conceptual design and stated business requirements. Identified and evaluated new technologies/tools for implementation. Consulted with the end-users to prototype, refine, test, and debug components to meet needs.

Helped to mature the data lake and other foundational platforms used for data science, advanced analytics, and reporting.

Responsible for Ingestion of data from different internal and external sources such flat files - column delimited and relational feeds- oracle and DB2 (on Mainframe / Unix / Linux) into Hadoop Data Lake using Scoop, performing a transformation on data on hive UDF. Repairing & cleansing data using pig. Developing a hive query for analysis. Ensure that the data model is extensible, scalable as per future customer needs.

Worked with Hive data warehouse tool-creating tables, data distribution by implementing Partitioning and Bucketing, writing, and optimizing the HiveQL queries. Job/workflow scheduling and monitoring tools like Oozie and Zookeeper. Created Python script which can connect with Git API for repository/project files and metadata. Responsible for high/low-level design documentation, source to target mapping document, and presenting the same in Arch review meetings. Accountable for developing scalable reporting solutions by creating/modifying BI universes, Tableau dashboards, which gets utilized via operational, analytics, ad-hoc/self-service reporting.

Ingested Claims, Life, Auto, Property, and Investment Bank data into Hadoop Data Lake for creating enterprise KPI as per business analytical and operational reporting needs.

Client: Country Financial, Bloomington, IL

Role: Data Engineer

As a Data Engineer was responsible for the following tasks:

Responsible for entity-relationship modeling for OLTP and dimension modeling for OLAP systems.

Responsible for collecting, aggregating, and analyzing data from multiple internal and external sources to drive insights into business performance metrics. Generated actionable reports that show key performance indicators to help business SME’s to identify areas of improvement into current operations and prepare root cause analysis for problems. Gather reporting requirement from all business SME’s and translate into functional and technical documents.

Helping business users to select correct reporting tools like Tableau, SAP BusinessObjects, Power BI, WebFOCUS for their operational and adhoc reporting requirements.

Extensively worked as an administrator for SAP BusinessObjects BI 4.0/4.1/4.2, Tableau 2019.4, WebFOCUS 7.7 perform various activities like installation, configuration, migrations.

Created advanced Tableau dashboards with quick/context/global filters, parameters, and calculated fields, etc. that allowed tracking Claim KPI’s like subrogation amounts. This helped the claim department to recover the subrogation amounts up to $1M.

Developed business-driven and actionable reporting solutions using Tableau, Power BI dashboard, and SAP BusinessObjects WebI reports for key stakeholders in Auto, claim, and Life domain. Developed and enhanced more than 20+ SAP BusinessObjects universes and 100+ WebI reports. Integrated the application with other third-party apps such as Policy Writers, Navigators, Password Vaults using SDK restful services and batch scripting, Informatica Enterprise Data Catalog. Stabilized SAP BusinessObjects, Tableau, WebFOCUS applications, which included upgrades to the latest version

Client: ULTA Beauty, Bolingbrook, IL

Role: BI Lead

Provided design and architecture diagram for future reporting solutions when the backend database layer migrated from “BW on RDBMS” to “BW on HANA.” Completed report rationalization, using inhouse build tools like “BusinessObjects Documentor” & “Rover tool” in Ulta environment, which would help to come up with a dimensional optimized data model for “BW on HANA” platform. List of challenges/limitation during the conversion of portal SAP BW workbook to SAP BusinessObjects WebI reports. Provide recommendation or workarounds, as per SAP best practices. Complete assessment analysis for migration of “BW on RDBMS” to “BW on HANA” and corresponding Bex, WAD migration.

Client: Applied Materials, Santa Clara, CA

Role: Sr. SAP Consultant

Responsible for the architecture of the SAP BusinessObjects BI platform, including version or patch upgrade, backup strategies, Implementing SSL, external load balancer, SSO as per ITS initiatives.

Configuration of the third-party tool, using java SDK or batch scripts to company portals and password vaults screens. Responsible for configuring the adaptive processing server as per best practice for better performance of the environment, creating the scripts to an automatic restart of the servers and services for the production environments.

Accountable for performance tuning of the BI platform. Designed security model as per business requirements.,

Support the existing solution (which included 400+ analytical reports developed using SAP Business objects WebI reporting tool 4.0 and 70 + SAP BusinessObjects Dashboard 4.0.

Client: Philips, Bangalore, India

Role: Sr. SAP Consultant

Worked closely with the data modeler in designing logical and physical data models, identifying data sources, data extraction procedures, and data mapping for BW/BOBJ OSA project. Develop, Tested, and implemented BW/BI reporting solutions using BEx Analyzer/UDT / IDT and BICS.

Deliver an IT solution that enables the business to further embed OSA in sales and supply processes. Enable OSA functionality & reporting, a key feature of CL Business processes - Build OSA solution & Reporting, Historical OSA score migration & analysis, BO Reporting (Sell In & Sell Out, Root Cause), Anchor OSA reports in Sales Cockpit. Played COE role for SAP BW/BOBJ Cognizant innovations in the Lab.

Client: PepsiCo, Bangalore, India

Role: Sr. SAP Consultant

Responsible for design, develop and deployment of SAP BusinessObjects Universe & Reports. Develop a Global Scorecard solution that enables transparency on performance for new global horizontals, multi-source fact base for analytics and strategy development, and a brand management toolkit to drive functional excellence.

Capgemini Dec 2008 – Jan 2011 Client: Capgemini, Paris, France

Role: SAP Consultant

Implementing Resource Unit Model using SAP BusinessObjects Profitability and Cost Management Tool so that billing to the end customer will be services base instead of FTE based. Design a basic model. Load XML Source files using the data bridge tool. Implemented the business rules by writing the VBA Script. Design, develop, implement reporting solutions using the book viewer. Developed and implemented a pilot phase for OPTIMUS (Operational performance through International methods of Unit-based services) model for GDC – India and Poland.

Client: BMC Analytics, Mumbai, India

Role: SAP Consultant

Using the BMC Remedy tool created, updated, modified the Incident, explore the underline tables and their joins using the admin console, modify the BMC Analytical Universe and reports as per the needs. Good knowledge of Remedy ITSM Asset, Incident, Problem, Change Management, CMDB module.

Client: Capgemini, Bangalore, India

Role: SAP Consultant

Created and maintained SSIS ETL packages to extract data from different systems and load a variety of large volume data into the data warehouse from various sources like flat file, Excel file. Configured the loading of data into slowly changing dimensions using SCD wizard. Designed, developed, implemented reporting solutions using SSRS. Worked collaboratively with other team members to define ETL & Reporting framework for the Data Management Factory project.

Hewlett Packard Mar 2007 – Nov 2008

Client: HP, Bangalore, India

Role: Technical Financial Analyst

• Responsible for designing, building, and delivering Business Intelligence reporting and data analysis solutions using reporting tools like WebI, Crystal reports, SAP Dashboards / Xcelsius. Responsible for Migrating the report from SAP BusinessObjects 6.5 to XIR2. Successfully delivered reporting solutions such as Supply in Retail, Aspen: Reseller Sell-Out Performance, Daily Shipping Sell-through supply reports.

Vertex Software (NTT Data), Pune, India Jun 2006 – Mar 2007

Client: Yahoo, Inc., Pune, India

Role: Team Lead

The objective is to create a robust automated excel based VBA application that will collect ‘per click’ statistic from the website. VBA Application is build using ADO Objects, Excel Object Model, various excel based macros.

IBH Publications, Mumbai, India Apr 2005 – Jun 2006

Client: PWC, Mumbai, India

Role: Software Tester

Review FRD, prepare test plans, test cases, and execute the same. Responsible for creating VBA macros as per requirement. Used testing tools like Edgarbiz, Epsolon, Validator, DeltaVeiw.

Education and Certifications

B. Tech in Electronics with Distinctions from Mumbai University

Contact this candidate