Summary

Overview

Work History

Education

Skills

Timeline

Sujan Musunuru

Frisco,TX

Summary

Dynamic professional with over 22 years of experience in architecting and developing Business Intelligence applications, specializing in complex data integration and reporting solutions. Expertise includes data governance, master data management, and strategic contributions to organizational roadmaps. Extensive knowledge of a wide array of data warehousing and integration technologies, including OBIA, Oracle Data Integrator, Informatica, IICS, OBIEE, Tableau, and Business Objects. Proven success in integrating systems such as PeopleSoft, Oracle E-Business Suite, JDE, Salesforce, and various legacy systems across multiple domains, along with proficiency in migrating data from on-premise environments to Snowflake Cloud, MS Dynamics, AWS, and Azure Cloud.

Overview

years of professional experience

Work History

Snowflake Data Architect

Bayview Asset Management

Coral Gables, FL

02.2023 - Current

The Performance Reporting and Analysis (PR&A) team is to take on financial reporting needs to track Investor portfolio success and to provide reports for portfolio managers to communicate with clients on how policies have done over time.
Bayview Asset Management’s current sources of data are not centralized for PR&A team to utilize. The solution is designed around to have a data lake on Snowflake with flat files landing on Azure storage and then to snowflake staging area. A refined/modeled layer in Snowflake will consists of tables for reporting that will be populated with required data transformations using ADF pipelines.
Created a data lake solution using Azure data stage and Snowflake.
Created the Snowflake environment for Stage, Curated and Reporting layers.
Created roles and user access in snowflake to each layer to different users.
Converted the business logic after discussions with business owners into physical terms.
Created tables and data models in snowflake for the adf team to inject the data.
Designed the ETL logic and Source queries to populate curated tables in snowflake performing the required data conversion.
Worked on few ADF pipelines in azure to fix the As of Date (SCD 2) logic for dimension tables.
Involved in Vertical and Horizontal data validations based on the rules provided by the business.
Assist reports/dashboard creation in Power BI.

Sr. Data Architect

World Fuel Services

Miami, FL

06.2022 - 02.2023

The Cloud Data Platform (CDP) is an analytics environment where WFS can ingest, consolidate and report with magnitude improvements in speed, simplicity and quality of our management information.
WFS plans to migrate the existing Oracle 11i to R12 and need to retrofit all the existing objects in CDP for the changes and implement them inline to R12.
Architect the data flow to complement project’s internal team. Responsibilities include performing data analysis, defining ETL architecture, data modelling and implementing robust data pipelines in the cloud using AWS, IICS and Snowflake.
Retrofitted views that were existing on top of 11i tables to R12 raw tables for seamless usage by finance users.
Created views on raw layer to replace Alteryx workflows to CDP.
Demonstrated deep understanding of SQL, relational and analytical databases (Snowflake)
Designed and developed the ETL mappings in Informatica Intelligent Cloud Services (IICS) for the data flow.
Created data lineage using Informatica data catalog tool.
Applied the knowledge of Agile (Scrum) best practices in day-to-day tracking of the project activities and deliverables.
Leveraged the knowledge of ERPs (Oracle EBS, etc.) in understanding the analytical needs of the business and convert them to technical specifications.

Data Architect

DFW Airport

Dallas, TX

01.2021 - 05.2022

DFW Airport is in process of liberating the data from multiple systems into a unified cloud environment. Enterprise Data Liberation involves data modeling for various data marts, strategize the flow of data from sources to data lake and in turn to Datawarehouse in Redshift.
Informatica cloud is used to integrate and migrate the data along with Erwin for data modeling.
Architected the data movement strategy from various sources to data warehouse in AWS Redshift
Modelled the data marts to be created in Data warehouse for each subject area like Maintenance, Parking Yield Management, Airline Schedules and Financials.
Designed the IICS templates to be reused for each table from Source to data warehouse.
Created mappings and tasks in IICS for the data integrations and load into Redshift.
Optimized and tuned Redshift environment enabling queries to perform a lot faster in Tableau reports.
Taken care of IICS code migration artifacts.

Informatica Cloud Architect

American Airlines

Dallas, TX

03.2020 - 12.2020

American Airlines is modernizing the Sales Link Services application from Siebel to Microsoft Dynamics 365 as part of which it is leveraging Informatica cloud for data migration.
Along with the historical data migration from Siebel to Dynamics, it is required to re design few inbound and outbound services and processes from Siebel to Dynamics.
Performed extensive analysis to understand the data conversion mapping between Siebel and Dynamics.
Create IICS mappings for migrating data from Siebel to Dynamics for entities like Case, Account, program contracts, Passenger and Segment details.
Used alternate keys on Dynamics for Informatica cloud upsert operations in migration tasks.
Created inbound batch integration jobs in IICS to feed entities in Dynamics from external sources.
Created outbound batch integration jobs from Dynamics to external applications using IICS
Performed Unit testing and created QA test cases for QA data validations.
Taken care of IICS code migration artifacts.

Sr. Data Architect

World Fuel Services

Miami, FL

08.2019 - 02.2020

The Cloud Data Platform (CDP) is a new analytics environment where WFS can ingest, consolidate and report with magnitude improvements in speed, simplicity and quality of our management information.
It will replace the existing Data Warehouse and custom analytics silos.
WFS plans to migrate the existing Oracle DW to the Cloud as soon as possible for talent, performance, and cost reasons.
Architect the data flow to complement project’s internal team. Responsibilities include performing data analysis, defining ETL architecture, data modelling and implementing robust data pipelines in the cloud using AWS, IICS and Snowflake.
Demonstrated hands-on experience in BI and Data Warehousing including architecture, design, data modelling (Kimball methodology), ETL and reporting.
Strategized and Implemented a Cloud DW/Data Lake solution.
Demonstrated deep understanding of SQL, relational and analytical databases (Snowflake)
Designed and developed the ETL mappings in Informatica Intelligent Cloud Services (IICS) for the data flow.
Used Fivetran to replicate the data from databases like oracle and Sql server in real time.
Utilized the experience with AWS services (S3, Lambdas, etc.) to orchestrate the movement of flat files and data from Sources to data lake and data warehouse.
Applied the knowledge of Agile (Scrum) best practices in day to day tracking of the project activities and deliverables.
Leveraged the knowledge of ERPs (Oracle EBS, etc.) in understanding the analytical needs of the business and convert them to technical specifications.
Created external programs in python to automate snowflake and IICS code deployments as part of CI/CD.
Worked on a POC to determine the usage of Redshift as a target warehouse database.

Data Architect

Pinnacle Leasing and Management LLC(PLNM)

Alpharetta, GA

05.2019 - 07.2019

PLNM is an Atlanta based real estate development and brokerage firm concentrating in commercial estate developments, acquisitions, joint ventures and sales. The firm’s principals are transaction driven with specific expertise and focus on retail, office and land developments. The project is to provide data base support and architecture for the ongoing Real Estates Properties Portal.
Modifying existing databases and direct programmers and analysts to make changes.
Architecting and building BI applications, complex data integration and reporting solutions.
Specifying users and user access levels for each segment of database.
Responsible for architecture and design for complex initiatives.
Work with data suppliers to establish input and interface specifications.
Prepare logical and physical database elements and specify identifiers of database to management systems.
Provide support to the development teams during analysis, development and testing processes.

Sr. Practice Architect

JM Family Enterprises, Inc.

Fort Lauderdale, FL

01.2019 - 04.2019

The JMFE division known as Southeast Toyota Distributors, LLC, (“SET”) would like its Sales Planning and Incentive department to understand how they can use data to achieve better business outcomes. Currently it is unable to respond to changing market conditions and has limited capabilities to ingest new data for discovery and analysis. To transform data utilization, SET needs to conduct current state analysis and discovery on business processes and data sets/sources for Sales Planning and Incentive efforts related to the RAV4 vehicle. The objective of the project is to improve financial and sales reporting; reduce reliance on third-party analysis; and reduce manual data preparation, collection, and manipulation.
Performed current state analysis of Sales Planning and Incentives process
Performed fit/gap analysis on all the sources used for the Sales and Incentives program.
Defined future state architecture – high-level process and technologies to be used
Created the future state roadmap and strategy document
Created logical and physical data models needed for pilot implementation
Implementing RAV4 Pilot use case for Sales Planning and Incentives
Created dashboards for Sales and Incentives in tableau with various visualizations.
Created market share analysis and competitive analysis reports in tableau with data blending from multiple sources.
Loaded the data into AWS RDS and Redshift instances.

Data Architect

T. Rowe Price

Baltimore, MD

06.2018 - 12.2018

T. Rowe Price is an American publicly owned global asset management firm that offers funds, advisory services, account management, and retirement plans and services for individuals, institutions, and financial intermediaries. The data modernization project is to re-architect the ADS Data Warehouse to meet Individual Investor (II) current business reporting and analytics requirements for IDM ADS and Retail Metrics. To optimize data storage and data movement to provide ability for fast analytics, speed to market and reduce unnecessary data redundancy. Needed to migrate all Individual Investor (II) analytics data and related processes to AWS and decommission existing II legacy analytics databases and supporting infrastructure.
Responsible for II Data Environment Migration into AWS Cloud Platform.
Involved in re-architecture of II’s Data Warehouse (ADS) from DB2 to Snowflake in Cloud.
Designed Analytic Batch Processing (ETL) in the cloud.
Designed Storage of data in cloud on AWS S3 to build out an Enterprise Data Lake.
Optimized the central storage of data from other source systems outside of ODS including Salesforce, Workday, Adobe Campaign and Adobe Analytics.
Strategized and provided roadmap for financial MDM

BI Architect

Noble Energy

Houston, TX

08.2017 - 04.2018

Noble Energy is upgrading the Oracle BI Apps(OBIA) from 7.9.6.4 version to 11.1.1.10.1. As part of the project phase the customizations for HR Analytics need to be migrated to new version. The custom code developed in Informatica need to be re developed in ODI. The reports that exists in OBIEE 11G need to be upgraded to 12C version. We used BI Accelerator tools at different phases of the implementation of the project.
Responsible for overall design and architecture of custom ETL migration from Informatica to ODI
Perform fit/gap analysis against EBS (HR module) and OBIA for extensions and customizations using BI Business Requirements Generator.
Provide direction in migrating data model extensions, data mappings and overall data load strategy
Lead the Technical Implementation and obtained the lineage using BI Path Finder tool.
Primary technical liaison between Noble Energy and offshore team
Created full data lineage from Source to analytical layer.
Provide technical guidance with upgrade issues, security set up, broken reports found using BI Assurer.

BI Architect

Intermountain Healthcare

Salt Lake City, UT

10.2016 - 07.2017

Intermountain healthcare (IHC) is upgrading the Oracle BI Apps(OBIA) from 7.9.6.3 version to 11.1.1.10.1. As part of the project the customizations for Financials, Procurement and Spend, Supply Chain and Contract Management Analytics that exists in old version need to be migrated to new version. The custom code developed in Informatica need to be re developed in ODI tool. The reports that exists in OBIEE 11G need to be upgraded to 12C version. Used BI Accelerator tools at different phases of the implementation of the project.
Responsible for overall design and architecture of custom ETL migration from Informatica to ODI
Perform fit/gap analysis against PeopleSoft, EBS and OBIA for extensions and customizations using BI Business Requirements Generator.
Provide direction in migrating data model extensions, data mappings and overall data load strategy
Lead the Technical Implementation and obtained the lineage using BI Path Finder tool.
Primary technical liaison between Intermountain and Company’s offshore team
Provide technical guidance with upgrade issues, security set up, broken reports found using BI Assurer.
Own technical design documents
Advise on critical show-stoppers and recommend solutions and workarounds.

Integration Specialist

DTCC

New Jersey, NJ

09.2015 - 08.2016

DTCC has been providing services to promote the stability and certainty of global financial markets for over 40 years. DTCC stands at the center of global trading activity, processing trillions of dollars of securities transactions on a daily basis. The project is to migrate on premise PeopleSoft data to HCM Cloud in phased manner with coexistence for a period of 2 years. Measured the quality of the deliverables using BI Assurer. Used Tableau desktop to create visualizations.
Designed the data mapping for downstream data from HCM to PeopleSoft.
Created POC for middleware to transfer files from HCM Cloud to on premise Server.
Provided solution to use Oracle Web Center Content Server as the middleware.
Implemented java based Web Center Content document transfer utility to import the files from HCM Extracts to PeopleSoft server.
Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots.

BI Architect

JDSU

Milpitas, CA

05.2015 - 08.2015

JDSU required an enterprise level BI solution that included Financial, Supply Chain Order Management, Procurement and Manufacturing Analytics as part of OBIA along with few Custom analytics on Inventory. Leveraged BI Accelerator tools at different phases of the project.
Implemented OOTB Manufacturing Analytics with customizations.
Sourced data from 2 EBS instances (11i and R12.2.3).
Designed and involved in the development of custom data models for Inventory reports on Days of Supply, Excess and Obsolete, Min Max and LCM Analysis.
Defined and designed report layouts for custom report requirements using BI Business Requirements Generator.
Tested the quality of the reports using BI Assurer and Path Finder tools.

BI Architect/Manager

GE(Power and Water)

Atlanta, GA

06.2014 - 04.2015

Primary Objective of the Financial Data warehouse (FDW) project is to provide a centralized reporting solution for finance users to support the closing process, management reporting and analysis and to reduce the time required to do analysis and research issues during closing. FDW also provides a KPI based reporting environment to measure the effectiveness of ESGAP processes with Cross ERP (7 ERPs in final FDW) financial data.
Implemented OOTB Financial Analytics with customizations.
Sourced financials data from 2 EBS instances (R12.1.3 and R12.2.3).
Done the Fit Gap Analysis to conclude effort estimates and design for the customizations.
Used Extracts from DRM to populate the GL Segment hierarchies which are not defined in EBS Sources.
Defined and designed Application roles for data level security to restrict data between different ERP users.
Took care of all migration activities between environments.

BI Architect

VISA Inc

Foster City, CA

05.2013 - 05.2014

VISA ‘s Corporate Analytics strategic road map is to consolidate multiple departmental analytics installations into a single robust and scalable XADATA platform. The expected benefits of this new platform include simplified maintenance, reduced total cost of ownership, and ability to reuse common data across multiple business domains. This will bring the Procure-to-Pay (P2P), Financial Analytics, Client Support Services (CSS) and Global Customer Care Services (GCCS) data marts onto this platform, followed by the CyberSource data marts and ODS.
Implemented OOTB Financial and P2P Analytics with customizations.
Analyzed and designed GCP (legacy application) retrofitting into new BI platform.
Done the Fit Gap Analysis to conclude effort estimates for the customizations.
Prepared the Technical Design and Testing Strategy documents.
Migrating Siebel Analytics from BIApps 7.9.5 to 7.9.6.3 on top of existing P2P and CSS data.
Used BI Accelerator tools like BI Assurer and Path Finder for quality testing and to obtain data lineage.

Project Lead

WNS

Mumbai, India

09.2012 - 04.2013

WNS is a BPO services company dealing projects on wide range of Industry Verticals and Horizontals. This project includes the implementation and customization of BIApps Financial Analytics, Procurement and Spend Analytics and Project Analytics to Source from existing EBS 11i data (History) and R12 data going forward in line with their EBS migration strategy.
Involved in analyzing the reporting requirements from users.
Provided demos to Users on BIApps OOTB reports.

Project Lead

Riverbed

Santa Clara, CA

12.2011 - 08.2012

Riverbed is a technology services and products company for wide range of LAN,WAN and other high speed network solutions. This project mainly deals with the Services and Financial modules of their EBS and customizing out of the box BI Analytics for achieving the reporting requirements.
Involved in gathering the Technical requirements from Onsite team.
Designed the required data model for Asset and Service Contracts facts (Service Analytics).
Done the customizations to Financial Analytics (involving Revenue Facts).
Designed the Revenue Fact to load from Rev Pro Application.
Designed and involved in creating the ETL mappings and workflows.
Designed and Created Revenue Aggregates at monthly and Quarterly level.
Used DAC to configure the Informatica tasks and scheduled them.
Reviewed the reports developed in OBIEE and testing done by QA team.
Involved in migrating the code from DEV to QA/PROD environments.

Project Lead

California Water Services

San Jose, CA

06.2011 - 12.2011

California Water Service Company (Cal Water) is the largest subsidiary of the California Water Service Group, which also includes Washington Water Service Company, New Mexico Water Service Company, Hawaii Water Service Company, and CWS Utility Services. As a whole, the Group provides high-quality regulated and non-regulated utility services to approximately 2 million people in 100 communities. The Project involves the development of BI Solution for various modules like Financials and Procurement Analytics, Laboratory Information System (LIMS), Revenue Management Systems (RMS), Engineering and Asset Management from PeopleSoft as a Source.
Involved in gathering the functional requirements from users and converting them to Technical requirements.
Leading the onsite and offshore handoff during the technical and functional discussions on daily basis.
Designed the data model for LIMS, Engineering modules and customizations to Financial and Procurement Analytics.
Designed and involved in creating the ETL mappings and OBIEE reports.
Used DAC to configure the Informatica tasks and scheduled them.
Reviewed the test cases and testing done by QA team.
Involved in migrating the code from DEV to QA/PROD environments.

Project Lead

Bare Escentuals

Santa Clara, CA

03.2011 - 05.2011

Bare Escentuals is a leading manufacturer and supplier of cosmetic products and services in US. The project involves upgradation of Oracle BI Applications(OBIA) from 7.9.6 to 7.9.6.2 version considering the simultaneous migration of their EBS source from 11i to R12.1.2. The typical part of the project is that the Oracle is migrating only the active dimensions and open transactions from old to new system. The challenge is to bring in only inactive dimensions & closed transactions from old DWH/EBS and active dimensions & open transactions from new EBS source.
Done extensive analysis in designing the active/inactive dimensions and closed/open transactions criteria based on the Oracle EBS migration logic.
Designed and involved in creating the ETL mappings for data migration.
Used DAC to configure the Informatica tasks and scheduled them.
Reviewed the test cases and testing done by QA team.
Involved in migrating the code from DEV to QA/PROD environments.

Project Lead

Chicago Public Schools

Chicago

12.2010 - 02.2011

CPS is a leading chain of education institutions in and around Chicago, US. The project involves development of Data model, ETL and reporting for Position Control related to HR analytics using Oracle BI Applications.
Designed a data model to fulfill the reporting requirements with position, staffing, employees and their Budget information.
Created the ETL mappings for loading the Dimensions and facts
Used DAC to configure the Informatica tasks and scheduled them.

Team Lead/ETL Developer

Bare Escentuals

07.2010 - 11.2010

Bare Escentuals is a leading manufacturer and supplier of cosmetic products and services in US. The project involves support for Supply Chain and Order Management Analytics using Oracle BI Applications.

Team Lead

GE-CIS

Hyd, India

04.2008 - 06.2010

Management Analysis and Reporting deals with Investor relations, Budgeting & Forecasting and Sec & Tax Reporting. This project is meant for the development of a unified model to bring Financial Services & Industrial businesses on single process & platform. Enable Intuitive ad-hoc querying, publishing and sharing of financial information.
Leading the offshore team consisting of 5 members
Involved in designing the dwh architecture and required ETL design using Informatica.
Administering the users, schedules and events in CMC.
Creating and managing the Universe on SDC database for MARS reporting.
Creating various standard and adhoc reports using Webi.

Functional Consultant

GE-Energy (E-sourcing)

Hyd, India

04.2001 - 03.2005

Supporting the GSDW application in E-Sourcing business using BO and other methods. This involves creating and testing reports using BO & supporting SMF applications.
Created and tested reports using BO and Webi.
Involved in SMF integrations and testing different test cases.
Responsible for UNSPSC integrations for the GE business.
Validating the DW integrations done using Informatica.

Education

Bachelor of Technology -

Sri Krishnadevaraya University

Anantapur, India

01-2000

Skills

ETL Tools: Informatica PowerCenter, IICS, Azure Data Factory, ODI 11g
Reporting Tools: OBIEE 11g/12c, Business Objects XI R2, Tableau, Power BI
Databases: ORACLE 10g/11g/12c, SQL Server, DB2, Teradata, Snowflake, Postgresql
Applications: DW/BI, Oracle BI Apps(OBIA), AWS Cloud Services
Languages: SQL, PL/SQL, C, Python

Project Management Tools: Microsoft Project Plan
Operating Systems: Windows, Linux, Unix
Methodologies: SDLC and Agile
Others: ERWin, DAC, Quality Center, BO Planning XI, Alation Data Catalog, Activebatch
AWS Services: S3, EC2, RDS, Redshift, Glue, Athena, Lambda, Appflow

07.2010 - 11.2010

Team Lead

GE-CIS

04.2008 - 06.2010

Functional Consultant

GE-Energy (E-sourcing)

04.2001 - 03.2005

Bachelor of Technology -

Sri Krishnadevaraya University