Prabhu Subramaniam Phone: 708-***-****

Senior Manager, Data Warehouse & Analytics Email: adf5nw@r.postjobfree.com Prabhu Subramaniam

Summary of Work Experience

About 13+ years of experience in designing, modeling, developing, and managing Data Warehouse, Analytics, Data Integration, Machine Learning, and Business Intelligence applications.

Experience in managing project scope, priorities, milestones, and deliverables to business partners and project team members.

Developed data strategy for several lines of business by working with key stakeholders to understand their data needs, create a roadmap, and deliver solutions that fit their evolving business goals.

Manage data-driven projects involving timelines, vendor relationships, and budgets to ensure projects are delivered with the highest quality and within specified timeframes.

Extensive experience in OLAP/Business Intelligence application designing and development using Tableau, Hyperion, Business Objects and Enterprise Data Warehouse (EDW)

Extensive experience building data product features for artificial intelligence, machine learning, and advanced analytics in partnership with business champions.

Implemented Sales Analytics, Workforce Analytics, Demand planning, Customer Journey Analytics, Finance Income statement (GAAP, Pro-forma) Dashboard, SGA Cost of Sales Dashboards, and COVID-19 Analytics.

Manage multiple project execution and prioritization in a fast-paced environment.

Experience in leading, mentoring, and motivating technical teams in high data volume environments and supported 3000+ users, 25+ different roles Analytics environment.

Manage a global team of 15-20 technical resources to design, develop, and maintain a robust enterprise data warehouse, advanced analytics, and business intelligence reporting solution.

Experience implementing Self-Service Analytics (SSA) capabilities for the business team to make better decisions with data.

Experience managing relationships with executive level stakeholders.

Working experience in both Waterfall and Agile environment, a good understanding of Software Development Life Cycle (SDLC) and Scrum.

Strong RDBMS data management, row-level security, masking, and replication skills (SQL Server, Oracle).

Technical Skills

Databases MS SQL Server 2019/2017, Oracle, DB2, Teradata ETL Tools SQL Server Integration Services (SSIS) 2019/2017, Informatica 10.x/9.x Business Intelligence

Tools

Tableau 10.5/9.x, Power BI, Hyperion Reporting, Business Objects, SQL Server Reporting Services (SSRS), SSAS, Hyperion Essbase Machine Learning Tools Python, Spyder, Jupyter, R Studio Programming languages SQL, PL/SQL, JAVA/J2EE, JavaScript, UNIX shell scripting Mobile iOS, Android, .Net Core, Xamarin, Syncfusion, Micro Services, JSON Platforms Windows NT, Azure, UNIX

Other Tools TOAD, SQL*Loader, MS Office, Excel, Power Point, Putty, SSH Client Prabhu Subramaniam Phone: 708-***-****

Senior Manager, Data Warehouse & Analytics Email: adf5nw@r.postjobfree.com Professional Experience:

PSAV, Schiller Park, IL [Jun 2019 – Present]

Senior Manager, Data Warehouse & Analytics

Roles and Responsibilities:

Experience in managing and leading end to end complex Data Warehouse and Analytics projects planning, execution, and delivery.

Partner with FPA, Revenue Management, Sales, Operation business owners to define strategy and delivery roadmaps for Data Analytics platform capabilities

Communicate project milestones, status, budget estimates, and project objectives to key business stakeholders.

Provided project updates to COE & department Business Champions on a monthly and quarterly basis.

Translate complex business problems into well-defined projects that result in benefiting organizational growth.

Experienced in managing project discovery, scoping, resource allocation, prioritize tasks, and scheduling.

Design and develop integrated information delivery strategies to meet the business objectives in alignment with organizational strategy.

Manage and escalate risks and issues to the development team and appropriate business team for resolution.

Manage Tableau Analytics team to develop dashboards, scorecards, charts, Pivot, Geographic mapping, and table reports using Tableau and Excel.

Implemented Sales Analytics, Workforce Analytics, Demand planning, Customer Journey Analytics, Finance Income statement (GAAP, Pro-forma) Dashboard, SGA Cost of Sales Dashboards, and COVID-19 Analytics.

Lead iPad Analytics dashboard app development which provides leadership KPI’s and metrics for C-Suite users.

Implement and enhance processes and procedures for the development team to be productive.

Design a data pull/push strategy to connect various source databases (Oracle, MS Dynamics CRM, API, PostgreSQL, and SQL Server) and load into Enterprise Data Warehouse DataMart tables.

Manage machine learning project and guide team on the dataflow through, review algorithms, and evaluate the performance of the results.

Implemented machine learning projects forecast model for predicting revenue, sentiment analysis on a customer survey, and POC on workforce demand prediction. Environment: SQL Server Database 2019/2017,SQL Server Integration Services (SSIS) 2017/2014, Oracle 12c/11g, Erwin Studio, Tableau 10.5, Python, SQL Server Analytical Services (SSAS), Metadata Management, EDW, UNIX Shell Scripts, TFS, Azure, Windows NT, iOS, Android, .Net Core, Xamarin, Syncfusion, Micro Services, JSON. Prabhu Subramaniam Phone: 708-***-****

Senior Manager, Data Warehouse & Analytics Email: adf5nw@r.postjobfree.com PSAV, Schiller Park, IL [Jan 2017 – Jun 2019]

Manager Data Warehouse / ETL Architect

Roles and Responsibilities:

Work closely with the Data Warehouse Customers, Business Analysts, and Application Architects/Developers to gather and document requirements to support the data analysis needs of the organization.

Translate business and data requirements into logical data models in support of KPI driven dimensional data models and Ensure data design follows the prescribed reference architecture and framework.

Scrutinize functional requirements, specifications, and source to target mapping documents, identifying underspecified requirements, and other design challenges.

Partnered with Business and IT Stakeholders and developed Data Governance Roadmap, built Row Level Security (RLS) for Analytics dashboard which supported 3000+ users and 25+ different roles.

Participate in deep architectural discussions and design exercises to create best-in-class data and analytics solutions.

Technical leader with a deep understanding of business and project management principles as well as agile delivery methodologies.

Experience in developing dashboard wireframes based on requirement discussion with an understanding of technical and visual design considerations.

Define and continually challenge KPIs and metrics that are critical to increasing Sales, optimizing Cost, or Operation efficiency.

Ensure ETL quality through code reviews and throughout the inspection and best practice.

Responsible for enhancing the quality, integrity, usability, and availability of information for Enterprise Analytics and President Council reporting.

Maintain the performance of data warehouse by identifying and resolving data conflicts, optimizing databases, networks, and hardware.

Design and prototype Data science models that help solve business challenges through machine learning algorithms.

Develop fast prototype solutions by integrating various open source solutions into the data analytic ecosystem

Environment: SQL Server Integration Services (SSIS) 2016/2014, Oracle 10g, SQL Server 2016/2014, SQL, Erwin Studio, Tableau Reporting, SQL Server Analytical Services (SSAS), Metadata management, Data Warehouse, UNIX Shell Scripts, TFS, OLAP models, OLTP, MS Excel, Windows NT.

Prabhu Subramaniam Phone: 708-***-****

Senior Manager, Data Warehouse & Analytics Email: adf5nw@r.postjobfree.com PSAV, Schiller Park, IL [Jun 2016 – Jan 2017]

Employer: ECOM Consulting Inc.

ETL Architect

Roles and Responsibilities:

Design & develop the Data Integration framework using ETL tools such as SQL Server Integration Services (SSIS).

Create ETL Package, Procedures, Functions, Constraints, triggers using SSIS, and SQL Server Procedure Scripts.

Pull data using Change Data Capture (CDC) from various source databases (Oracle, SQL Server, flat files, API) and load into Enterprise Data Warehouse DataMart tables.

Perform exploratory source data analysis, write complex ad-hoc SQL queries, to proactively find and expose data quality problems or data that violate assumptions and business rules, and may cause unexpected output in the developed solutions.

Develops dashboards, scorecards, charts, pivot, geographic mapping, and table reports using BI tools such as SQL Server Reporting Services (SSRS), Tableau.

Automate code deployment of SSIS packages to various environments (Development, Testing, and Production).

Develop and maintain the Enterprise Data Warehouse Business Matrix Architecture.

Ensure dimension tables are conformed across all DataMart.

Performance tune ETL mapping by creating the partition, parallel processing, SQL query tuning, and Database tuning.

Support application development through system testing and user acceptance testing, bridging the gap between business rules and technical implementation. Environment: SQL Server Integration Services (SSIS) 2016/2014, Oracle 10g, SQL Server 2016/2014, Erwin Studio, Tableau Reporting, SQL Server Analytical Services (SSAS), Metadata management, Data Warehouse, UNIX Shell Scripts, TFS, OLAP models, OLTP, MS Excel, Windows NT.

Exelon Corporation (Exelon), Chicago, IL [Oct 2008 – Mar 2013] [Nov 2013 – Jun 2016] Employer: Trinuc LLC

Senior Data Warehouse Architect

Roles and Responsibilities:

Involved in gathering user requirements and analyzed the system environment based on the user requirement.

Provided Level of Effort estimates for the application development project.

Created cubes on the customer data warehouse (CDW) on financial and usage data.

Design and develop Mapping, transformation, session, workflows using Informatica to load data from the Customer Information Management System (CIMS) (DB2) to CDW

(Oracle) database.

Prabhu Subramaniam Phone: 708-***-****

Senior Manager, Data Warehouse & Analytics Email: adf5nw@r.postjobfree.com

Data acquisition and data profiling techniques like null constraint check, change data capture (CDC) based on natural keys, duplication error check was implemented at various load and stage environments to ensure only validated and valuable information is passed into ODS tables.

Created various daily, weekly, monthly interactive dashboards, and operational reports using Hyperion.

Environment: Informatica Power center 9.x / 8.x, Hyperion System 9 BI+, Hyperion Essbase 11.x/9.3, Business Objects 6.5/5.1, Oracle 9i/10g, SQL Server 2005, DB2, JavaScript, MS Excel, UNIX, Toad 9.1, Windows NT.

Sirius XM Satellite Radio, Vienna, VA Jan 2008 – Oct 2008 Employer: Trinuc LLC

Senior Informatica / Hyperion Developer

Roles and Responsibilities:

Performed analysis of Business requirements and interpreted transformation rules for all target data objects.

Identified and tracked the slowly changing dimensions (Type2, Flag Versioning).

Worked on Performance tuning at various levels to achieve high-speed response times.

Created Stored Procedures and used them in the mappings by using them as Connected and Unconnected Stored Procedure Transformations in the mappings.

Used various lookup caches like Static, Dynamic, Persistent, and Non-Persistent in Lookup transformation.

Create various Business Objects reports for the ICM team. Created a partner settlement report using BO and deployed, scheduled, and maintained BO reports.

Worked on migrating Crystal Reports 9 to BO XI.

Tuned various BO reports for optimization while converting from crystal reports.

Worked on daily ODS data refresh to pull data from SCHEMS and portal.

Pulled data using the CDC concept from the source database and loaded it into DataMart. Environment: Informatica Power center 8.x/7.x, Hyperion 9.x, Hyperion Essbase 9.x, Business Objects XI, Oracle 9i/10g, SQL Server 2005, JavaScript, MS Excel, UNIX, Toad 9.1, Windows NT.

Brown Brothers Harriman, Jersey City, NJ Oct 2006 – Dec 2007 Employer: Trinuc LLC

Hyperion / ETL Developer

Roles and Responsibilities:

Worked with Business Analyst in gathering the business requirement documents from the end users.

Translated the requirements into process mapping for the DataMart tables. Prabhu Subramaniam Phone: 708-***-****

Senior Manager, Data Warehouse & Analytics Email: adf5nw@r.postjobfree.com

Create workflows, sessions, and also used various tasks like command, event wait, event raise, email to run with the logic embedded in the mappings.

Developed Error/Exception handling mechanism to enhance the data quality loaded to Data Warehouse.

Implement Type I, II changes in slowly changing dimension tables.

Developed Java programs for polling job.

Environment: Hyperion 8.x, Informatica Power center 7.x, DB2, Oracle 9i/10g, SQL Server 2005, JavaScript, MS Excel, UNIX, Toad 9.1, Windows NT. Education

Master of Science, Computer Science – Governors State University, USA Bachelor of Technology, Information Technology – University of Madras, India

Contact this candidate