Data Management Entry

Sundar Panchapakesan

Contact: 281-***-**** (c), Email : ********@*****.***

Location : Houston-TX

LinkedIn: - https://www.linkedin.com/in/sundar-panchapakesan-5a475319 P a g e 1 o f 5

E x e c u t i v e S u m m a r y

I have over twenty-two years of experience in the information technology industry playing various roles like Lead Data Architect, Project Lead, Analyst, Data Management Specialist, Technical, Cloud Data and Project leadership in the small to large data and Information management program. I integrate IT skills with focused business analysis to deliver customer solutions that maximize business value.

I also have strong written and oral communication skills and works equally well independently as a lead, or as a member of a large team.

Data Architecture and Cloud Data Solutions Architect – Implementation experience of Optimized solution Architecture, Governance, and unique simple solutions for many industries. Solution includes Data Lake, Data Integration, Data Warehouse, Data Architecture, Dimensional Modelling, Cloud data ingestion/ optimization and Migration from on-prem to cloud. Establish detail study of requirements, in-depth domain knowledge on business processes, Source systems/data Analysis, Conceptual, logical dimensional models, Extract Transform Load process and development

Data Management and Lead – Having in-depth experience in various data management projects in planning, Work Estimating, Data Sizing, Data Security, Data Lake, Master and Meta Data Management, Data Quality Assurance, Migration, Integration systems for a cohesive solution. Experienced in creating roadmap for organization defining long term goal with milestones of various project phases, managing teams, risk mitigation plan, status presentation, project plan, define best practices, and work with business stake holders for better decision-making process. E d u c a t i o n a n d C e r t i f i c a t i o n s

Master’s Degree in Math and Computer Science

Azure Data Services, Azure Data Factory, DevOps, Modern Data Warehouse

AWS Cloud Certified Solutions Architect – Associate

InQuestra Certification - Eliciting Data Warehouse Requirements using Best Practices

Advanced Dimensional Modeling Techniques –TDWI

A r e a s o f E x p e r t i s e

Data Architecture and Management

Data Warehouse Architecture and Data

Exploration

Data Integration, Migration and Development

on Cloud, Data Streaming

Data Governance and Cloud Integration

Data Analysis, Data Mesh

E x p e r i e n c e a n d S k i l l s

SQL Server 2019, Oracle 12c, Netezza

4.6.6, Peoplesoft 9x, Tableau 9.2/9.3, 10.1,

PowerBI, SSIS, Salesforce CRM

Dimensional Modelling using Visio and Erwin

AWS DMS,S3, RDS,Data migration,

SnowFlake, Data Mesh, Lakehouse,

Analytics

Azure Services, Data Factory, DataBricks,

Data Migration Assistant, Data Lake,CI/CD,

DevOps

Start-to-Finish Project Life Cycle

development and Agile methodology using

Jira, Mural, Confluence and Lucid Charts

Informatica PowerCenter, Power Exchange,

Informatica Cloud Services (IICS), Data

Integration

A r e a s o f B u s i n e s s

K n o w l e d g e

Oil and Gas

Insurance

Retail

Utilities

Mortgate

Health Care

S u n d a r P a n c h a p a k e s a n

P a g e 2 o f 5

C h r o n o l o g y o f E x p e r i e n c e

American Advisors Group Sep 2020 to Present

Position: Data Solutions Architect and Project Lead Environment: SQL Server, Informatica IICS Cloud, Power BI, Salesforce CRM, AWS, DMS, S3 Data Lake, AWS Athena/Iceberg, Snowflake Data Cloud and Analytics Responsibilities:

Gap Analysis of an Existing Analytics Data Management process and documenting extraction Logic

Data Analysis and Profiling of Mortgage Leads, Opportunities, Applications, Loan and Appraisal processes

Working with Stake holders and executives to ensure vision statement is transferred into outputs

Involved in project planning on new Data Mart initiative and define Roadmap

Provide technical Oversight, Data Governance and Guidance during client engagement execution

Leading design architecture on Enterprise Data Warehouse, Data Mart, and implementation

Leading the team to achieve quality deliverables, working with business for Demo

Working on Conceptual model using Visio/Lucid/Mural and creating data dictionary and process document

Working on Agile methodology in conjunction with Jira / Confluence

Providing help on Project Leadership activities like estimation, Tracking milestones, and planning

Create Strategy for Migration, designing solution using AWS DMS, S3 and Streaming, Data Validation, DevOps

Define Data Lake Architecture Design principles for CDC load, AWS Athena Iceberg Integration

Define Cloud Data Migration and target state Roadmap

Architecting Hybrid solution with AWS for integrating Salesforce data with other data sources

Working with DataMesh Architecture proving business domain solution with distributed Lakehouse implementation

Provide the architectural guidance, policies, standards, recommendations for Enterprise Data and Lakehouse solutions

Involving in start-to-finish solutions that includes o Detailed data analysis, Leading Design Architecture for EDW data repository o Dimensional Modelling and Overarching Strategy and solution on Enterprise Data Exploration o Leading and mentoring teams, ETL/ELT Data extraction and Pipelines o Cloud Data Migration and Informatica Data integration

Worked in Power BI Model on Data visualization and Data Steward for data ownership

Involving in creating SQL Coding using T-SQL and leading data development processes and procedures

Implemented Dim and Fact tables star schema on Snowflake EDW Environment

Working on migrating existing SQL to Snowflake, onboard new users with fully ANSI SQL-compatible support.

Involved in automatic query caching, planning, parsing, and optimization on Snowflake.

Create and share the insights to the business users with the integration of snowflake data with Data visualization. Involved in analyzing profile queries to understand the execution details to troubleshoot.

Helped the data exploration team with the optimized SQL query for quick decision-making process HARRIS COUNTY PUBLIC HEALTH Apr 2018 to Aug 2020

Position: Lead Data Architect

Environment: SQL Server 2019, Informatica 10.2, Power BI, Azure Cloud Data Service/Data Factory and Analytics, Azure Databricks, Python 3, EPIC/Caboodle, MDM

Responsibilities:

Plan, Design, coordinate and deploy data warehouse solutions of multiple projects.

Obtained in-depth domain knowledge on various business processes namely, S u n d a r P a n c h a p a k e s a n

P a g e 3 o f 5

o EPIC HealthCare, Environment Public Health, Vector Control, Dental Enrollments, Flu Portal data

Worked with business Stake holders to identify requirements and Gap analysis

Established detailed analysis on all source systems, data elements, Integrity, and Profiling

Design Conceptual and Logical model using Visio and define best practices for data architecture and load

In-Depth Knowledge on Informatica Transformations, mapplets, mappings, Integration service, jobs

Develop an optimized extraction mapping solutions and load Process using Informatica

Implemented a design solution on Informatica MDM and initiated best practices

Involved in implementing Azure Databricks as an extension of Data Factory to ingest and integrate GIS Geo Coding data, unstructured and structed data loading using Databricks pipeline into SQL server database

Help Power BI team with seamless access to SQL Cloud database for reporting and Dashboard

Worked with business analyst and report writer on Power BI dashboards validation for Executives

Developed and Maintained CI/CD pipelines for code deployment using GIT

In-depth knowledge and experience on Azure DevOps services, pipeline runs, repos, Triggers and Monitor

Worked with GIS team on implementing address cleaning transformation process using Python and SQL scripts

Created Python scripts for data science team on Vector Control and Environment Public Health analysis

Designing Data management architecture framework and prepare data lineage model and other documents

Implementing SQL procedure, Complex query optimization, testing and ensuring the standards are followed

Quality deliverables are kept in TFS along with Documentation on all rolled out projects for all phases.

Involved in planning meetings for various projects, Estimation process, project look ahead meetings and organization’s roadshows

Estimate and define WBS/Tasks on TFS to plan and track it in the daily sprint meeting

Worked with Epidemiology team for COVID-19 response and providing on-time data delivery TEXAS DEPARTMENT OF STATE HEALTH SERVICES Sep 2016 to Dec 2017 Position: Sr Data Warehouse Architect

Environment: Oracle 12c, SQL Server 2016, Tableau 9x/10x, Informatica 9.6.1, IDQ, MDM and Amazon Web Services (AWS) Cloud computing using EC2, RDS Data Migration, Python Responsibilities:

Design and Implement Enterprise Data Lake, Data Integration solutions, Data Management Strategies, and roadmap

Lead a team of developers, resource planning, mentoring, quality, and timely deliverables

Involved in Business discussions with stake holders for data management requirements

Analyzing source data in Oracle and other systems to map the business to system requirements

Architecting Data collection and Validation processes and Metadata management

Creating comprehensive Dimensional model focusing on optimizing the structures for analytics

Design Logical Data Warehouse semantic layers, data view technologies and high-performance data integration and warehousing system

Implementing Data Migration strategies and process for Frozen historical Vital Events data

Designed Informatica Power Center mapping process like maintaining standards, mappings, mapplets and peer review.

Designing Data integration architecture and mappings using Informatica to load data into RDMS and to AWS cloud storage S3 and RDS.

Involved in data migration into AWS (Amazon Web Services) RDS for analytical solution on the cloud.

Created tableau visualization samples and upload into tableau server on AWS EC2 instance for business to access and analyze the trend on Cloud

S u n d a r P a n c h a p a k e s a n

P a g e 4 o f 5

OCEANEERING INTERNATIONAL INC. 2012 to 2016

Industry: Oceaneering International Inc. (Oil and Services Industry), Houston TX Position: Lead Data Warehouse and BI Architect

Environment: PeopleSoft 9x, Oracle 11g, OBIA, OBIEE, SQL Server 2012, Siebel CRM Cloud, Informatica 9.0.1, Tableau 9.2/9.3, Big Data Cloudera cluster Management, HUE Editor with HIVE and Hadoop HDFS Responsibilities:

Collaborate with IT teams and management to devise a data strategy that addresses business requirements

Analyzing the cross functional big data like market analysis data, opportunities, bids data from CRM, revenues, and Job Profit Margin from Peoplesoft, helping business to forecast better by service lines

Extensively worked on Data from Financials, Project Costing, Supply Chain Management, In house Applications Data like Remote Operating Vehicle data, Subsea Services, Asset Integrity, Umbilical data, LMS training management, Primavera and Enterprise Data Warehouse

Designed Solution Architecture enabling the business to analyze their subject areas like Financial AP, GL, AR Modules, Purchasing SCM, Project Costing, Remote Operating Vehicle (ROV) system and Maintenance analysis

Created and maintain project plan on Primavera and track it on daily basis

Created many presentations and Road map for organizations meeting their goals, milestones, achievements

Led the team and mentor them on technical and implementation throughout the life cycle of the project

Building an inventory of data consolidating Customer, Business Unit, Project and Service Line specific data for VPs and Stake Holders

Create a fluid, end-to-end vision of how data will flow through the organization

Designed data models leveraging multi-dimensional / star schemas and extended star schemas for Financials & project costing, Inventory and Purchase analysis

Designed architecture for data load process from Flat files, Oracle12c and SQLServer2012 using Informatica Power center and review teams code before deployments

Involved in designing and architecting data warehouses/marts and data lakes on regular Oracle high performance and big data (Hadoop - Hive) databases.

Design, document, construct data, extraction process / architectures and Mapping developments

Integrate technical functionality like scalability, security, performance, data recovery and reliability

Implement measures to ensure data accuracy and accessibility

Constantly monitor, refine, and report on the performance of data integration and warehouse environments

Reconcile data from target to source and vice versa

Explore new opportunities for data acquisition within the organization

Maintain a corporate EDW repository of data architecture artifacts and procedures COMPUWARE CORPORATION as Sr Data Specialist and Practice Lead 2007 to 2012 Industry: IMS Health Inc 3 Years

Positions: Data Warehouse and Informatica Architect Environment: Informatica 8.6, Netezza 4.6, Oracle 11g, SQL Server 2008 and SSIS 2008 Received opportunity to extend existing system knowledge and experience to this conversion project to work on Netezza, Oracle and SQL Server environments involving in estimation, design, development, testing, and production deployment in line with best practices and processes. In parallel, managing the existing team handling EDW environment until the conversion project. Implemented optimal architecture to one specific client as they wanted to explore Netezza and its performance over BI reporting and analysis; later this can be extended to others by IMS Managed Market Analysis team depending on requirements. Architecting effective Dimensional Model, data automation process considering all limitations and features of the tools for better handshake with Netezza EDW. Worked closely with Data Modeler and DBA to design logical model, Mentoring, and supporting group for successful S u n d a r P a n c h a p a k e s a n

P a g e 5 o f 5

implementation. The data is HIPAA compliance ensuring physical, network, and process security measures are in place and followed. Received Achievement Award from IMS Health for Successful Project Implementation Industry: Insurance – West Bend Mutual Insurance 2 Years Position: Informatica Architect and Lead Analyst

Environment: SQL Server 2005, DB2, Mainframe VSAM file, Win XP Prof client, Win NT 2003 server Tools: Informatica Real Time Edition of 8.1.1 SP4 and 8.6, Power Exchange (PWX) CDC (Change Data Capture) and Web Services

Primarily worked as Architect and Analyst in “Machine – Unified Search” project as part of Data Services team in end-to-end project life cycle. This project helped WBMI perform customer centric search as one unified search eliminating existing Line of Business centric navigation which simplifies the process of giving easy access to data for internal users and external agencies. This data is made available for real-time access to see the latest changes for business to gain high productivity. To meet this requirement of capturing real-time data from various source systems, a Customer Master Data Store was built in SQL Server Database to provide customer centric information integrating customers, their policies and claims for a given agency. Involved in creating real-time mappings to obtain CDC and provide Web Services, also in Release Coordination with Informatica objects promotes between different environments and involved in testing the objects as part of Informatica 8.6 upgrade. WIPRO TECHNOLOGIES as an Architect and Project Manager 2000 to 2007 Clients: Insurance – USAA, Best Buy, Cadbury Schweppes, DrPepper7Up Implemented Data Warehouse Architecture, Design, BI solutions, In-Depth solution design and implementation from start to finish, Coordinated and tracked deliverables, schedules, resources, risks/issues with Mitigation plan and timelines. Set up regular status meetings with business users and escalated issues with mitigation plans and define major milestones. Conducted regular meetings and Look Ahead meetings with project team and created and tracked the metrics. Prepared status reports and managed project plans using MS Project. Interacted regularly with team to ensure process adhered to the standards for quality deliverables. Interacted with users and IT leads to understand requirements. Reviewed specification and design documents and assisted the project team on data mart design. Participated in all team discussions concerning the design of the logical/physical model. AWARDS, COMMENDATIONS and RECOMMENDATIONS

Received Customer appreciation and Reference letter from a Director, Cadbury Adams Canada.

Received ‘Feather-In-My-Cap’ certification for my performance in a complex project implementation.

Received Achievement Award from IMS Health for Successful Project Implementation.

Received an award for the Contribution towards reaching milestone of Retail, CPG and Distribution group from Wipro Technologies.

Received Recommendations given by peers on LinkedIn: - https://www.linkedin.com/in/sundar-panchapakesan-5a475319

Contact this candidate