Aniruddha Mukhopadhyay

E-mail: adc171@r.postjobfree.com

Phone: 732-***-****

Summary:

•A results-driven hands-on leader with experience in designing, developing and delivering complex Data warehouse, BI, Advanced analytics and Cloud solutions to support the strategic and tactical business goals of the firm.

•20+ years of experience in architecture, development and project management of Business Intelligence, Analytics, Cloud and Big Data solutions for business customers.

•Creating and implementing business analytics strategies and architecture to streamline business/IT processes and reduce cost using cloud and big data technologies.

•Leadership in client service delivery, project portfolio management, BI and Analytics technology management and new business generation.

Skills Profile:

Technologies:

Big Data & Cloud Solutions: AWS Analytics stack (Glue, S3 and Glacier, Athena, Lambda, Redshift Spectrum, EMR and Kinesis), Microsoft Azure solutions (Cortana Intelligence Suite, IoT Hub, Machine Learning); Google Cloud Platform (Big Table/Query, Spark, Hadoop).

Cloud Data Warehouse systems: Amazon Redshift Spectrum, Cassandra, Azure SQL Data Warehouse, Google (Big Query/Big Table, Mesa)

Machine Learning systems: Spark with Scala using ML Libraries, Python, R, R-Studio; SAS Enterprise Miner, Azure ML, Alteryx.

Reporting Tools: Power BI, Qlik View, Tibco Spotfire, Tableau, IBM Cognos, SAP Business Object, Oracle Hyperion Essbase, Advanced Excel tools (Pivot table, co-relation, regression and forecasting models using Data analysis plug-in)

Integration Tools: AWS Glue, Azure Data Factory, Polybase, Informatica PowerCenter/PowerMart/Integration Cloud, IBM Datastage, Microsoft SSIS, Talend DI, SAP BODS (Business Objects Data Services), SAP HANA Smart Data Access and Integration (SDA/SDI).

MDM Products: Reltio MDM, Kalido MDM; Talend MDM, Oracle MDM (Product and Customer Hub), Informatica IDQ, Informatica Cloud MDM, Golden Source EDM, Sungard INVEST ONE data platform, SAP Information Steward and MDG (Master Data Governance).

Data model design/CASE tools: Visual Studio Data Tools, SAP HANA Studio, CA ERWin, Embarcadero ER/Studio, Oracle Designer, Rational Software (Clear case, Clear Quest, UML, Project Console), Visio.

Project Management tools: Microsoft TFS/VSTS, Atlassian JIRA, Microsoft Office Project.

Education:

(2017 – 2018) MS in Business Analytics – University of Washington, Tacoma, WA

(2015 – 2016) Finance and Accounting foundational courses at Loyola University Chicago, IL

(1994 – 1998) B.E. (Electrical Engineering) from National Institute of Technology, Silchar, India.

Work Experience:

Senior IT Architect – Data & Analytics, Puget Sound Energy Corp.

May 2018 – Present

Enterprise Data and Analytics Architecture management

Reporting to the Chief Architect and CIO of Puget Sound Energy Corp. (PSE) and accountable for developing and maintaining the Enterprise Data & Analytics roadmap by engaging with the senior leadership, business leadership and technology management teams during strategic planning phase to influence and prioritize the capital investments for initiatives that align with PSE’s integrated strategic plan.

Managing and mentoring application and cloud technology architects, analysts to develop cost effective, scalable, reliable, performant, enterprise architecture frameworks, tools and solutions.

Leading Data and Analytics Solution Architecture at PSE by:

Collaborating with end-users, business partners and senior leadership to define and prioritize business use cases, benefits, KPI’s and metrics for Customer Analytics, Data Governance, AMI/Load Forecasting and Energy Trading business initiatives.

Developing future state designs based on the use case benefits, enterprise technology principles, best practices, research of emerging technologies, prototypes to recommend highly scalable, performant, flexible, secure and low TCO solutions.

Designing and overseeing implementation of end-to-end integrated solutions for data and analytics projects using AWS Glue, S3/Glacier, Athena, EMR, Redshift Spectrum, Lambda serverless cloud services and on-premise services such as SAP HANA SDA/SDI, Business Objects, Microsoft SQL Server, Power BI.

Designing reference and lambda architecture to ingest, transform, curate and present near real time and batch AMI/AMR meter data using AWS services. This framework significantly improved the delivery of accurate meter data telemetry to the load forecasting, energy trading businesses and reduced IT operational expenses of maintaining on-premise meter data Oracle systems.

Implementing metadata management framework for business glossary/data catalog; data lineage, hierarchy and taxonomy; policy/rules for data discovery, profiling, quality and workflow management using SAP Information Steward (IS). Developed metric and KPI dashboards for data governance adoption, penetration and data quality for customer and asset data across PSE.

Senior Manager BI & Analytics, Cap Gemini Corp.

June 2016 – May 2018

Client - Microsoft Corp.

Role - Azure Data Migration Architect

Worked with Microsoft's Data Migration Jumpstart (DMJ) for assessing client's data management requirements, perform POC, developing prototypes, database A/B testing and recommending migration roadmaps for client's on-premise Teradata, Netezza, Oracle and DB2 solutions to Azure SQL/DW/Data Lake/Blob Storage and Azure SSIS, Data Factory, SSAS, Power BI and ML.

Role: BI Solutions Architect

Developed contextual, conceptual, logical and physical architecture models for supporting the Windows Intelligence and Data (WIND) platform short, medium and long-term strategic plan.

Worked on re-designing WIND platform using Azure Data Lake, Data Factory, SSAS, SSRS and Power BI.

Managing the onshore and offshore delivery services for Microsoft Corp.

Client – Vertiv Corp.

Role: Oracle MDM Solutions Architect

Provided Oracle MDM Product and Customer Hub architecture best practices; Design, development, delivery to Vertiv Corp.

Created data models, source to target mappings, transformation rules, survivorship rules, data quality/validation rules and UI designs to integrate the current product and sales systems into future state Oracle MDM hubs.

Client - Medtronic Corp.

Role: Analytics Solutions Architect

Provided platform architecture best practices; Design, development, delivery timelines and commercial for different phases of the program to the IT and R&D leadership teams.

Technologies used for platform delivery: Microsoft Azure HDInsight Hortonworks Data Platform and Data Flow for integrating real time device data; Apache Kafka and Spark for orchestration and processing real time device data; Apache HDFS/HBase/Hive for storing devices datasets and Power BI for device reporting/analytics.

Client – Grant Thornton LLP.

Role: Analytics Lead/Architect

Worked with the Senior Leadership Team for new innovations and expanding current project pipeline and P&L of BI and Analytics solutions using SQL Server, Informatica (Power Center, Power Exchange, IDQ), Microsoft Azure, Microsoft Dynamics and SAP Business Objects.

Capgemini Regional Practice Leader - West Region

Led the Insights & Data practice for West Region and managing a dynamic and fast-growing team of BI and Analytics consultants.

BI Architect & Manager, Spins Inc.

May 2015 – June 2016

Reported to EVP of Operations and Product management to transform the current Advanced Excel (Pivots, macro) and MS-Access based business process for manufacture/retailer’s product reporting by designing and implementing a SaaS Master Data Management (Reltio MDM).

Responsible for architecture of Apache Hadoop infrastructure/compute components (such as HDFS, Pig, Map Reduce, Hive, Spark, Sqoop etc.) for retailer file integration; Google Cloud Storage for the store level measures and Qlik sense for retailer analytics and client onboarding reporting projects.

Led a team of onshore/offshore developers to design, develop and deliver MDM and store level reporting for Spins product management business team.

Senior Manager, Business Analytics, Abbvie Inc.

May 2014 – May 2015

Managed Kalido MDM, Commercial data warehouse on Oracle and provided reporting on actual, forecast for P/L, Balance sheet, sales and headcount Financial metrics to the Commercial finance business users using IBM Cognos TM1 Financial management platform and Qlik View.

Managed the roadmap, prioritization, plan, 10+ onshore/offshore team members and IT budget of $2+ million to deliver reporting and insights to the Commercial finance and sales organizations at AbbVie.

BI Solutions Architect, Bright Star Corp.

Aug 2013 – May 2014

•Managed the conceptual, logical and physical solution architecture, BI (SQL Server, Cognos/Qlik View) development and delivery of an automated Forward Logistics reporting/analytics platform (Supply Chain Control Tower) for Bright Star operations, supply chain and finance business teams. The analytics platform provided users with Logistics/Distribution KPIs such as: In Stock, Returns, Stock Outs, In/To Market, on hand inventory operational metrics.

Manager of DW & BI, Oppenheimer Funds Inc.

Aug 2010 – Aug 2013

•Spearheaded the discovery, vision, roadmap, prioritization, architecture, design and development of one true version of integrated, governed, stewarded Investments Data Warehouse (IDW) reporting platform for Risk, Trading, portfolio management, sales/marketing, investments operations business units at Oppenheimer Funds Inc. (OFI).

•IDW platform was built using SQL Server, SharePoint, Cognos, Denodo and Qlik View technologies and enabled the traders, portfolio/risk manager, sales/ marketing teams at Oppenheimer Finds with trading operations reports, fund performance metrics, ad-hoc reports, proxy voting reports, data discovery capabilities.

•Managed the IDW team of 30+ on-shore and off-shore data architects, developers; managed IT budget of $5+ million; Led the planning, prioritization and management presentation of investment data delivery schedules.

Managing Consultant, Bank of America Corp.

Aug 2009 – Aug 2010

•Provided advisory and technology services to the Global Wealth Management and Consumer Banking Group Technology teams for migration of financial advisory BI and reporting platforms of Merrill Lynch with Bank of America Corp.

•Developed conceptual, logical and physical models, metadata definitions, physical data structure and storage documentations for DBA, ETL and Cognos developers for seamless delivery of Bank of America – Merrill Lynch AML-KYC reporting initiative.

VP of Business intelligence, Marsh USA, Inc.

Feb 2008 – Aug 2009

•Led a global team architects to architect, develop and deliver Marsh Sales Opportunity Management reporting platform. This reporting platform enabled the Insurance Sales, Finance, Risk and Brokerage teams with daily, weekly and monthly sales operational metrics and opportunity management Business Object reports.

•Managed data management roadmap, budget of $1+ million, project prioritization, goals and year-end evaluations for the data management team.

VP - DW and BI systems, Merrill Lynch & Co.

May 2003 – Feb 2008

•Consumer Banking Group project: Led a team of developers to develop cards, payer, network, transactions and operations risk reporting solutions for Cash Management accounts, Signature Cards, Merrill Lynch beyond banking and Credit cards.

•U.S. Patriot Act FINRA initiative: Lead modeler and developer of AML - KYC (Know Your Customer) platforms (Oracle Mantas and Actimize) for financial fraud detection, issues reporting and resolution. Built rules engine, data integrations and reporting using both AML-KYC platform.

Technology Consulting:

July 1998 – May 2003

As a Senior DW/BI Consultant, designed, developed and delivered high quality data and BI solutions for financial, retail and Tele Com customers (Merrill Lynch, USAA, Walt Disney, T-Mobile and GE).

Developed Data and reporting solutions using Informatica, Cognos, business Objects, MS-Access, Excel Pivot tables, VBA and Visual Basic for the consulting engagements.

Contact this candidate