Data Management Software Engineer

Ganesh Nagarajan

*******@*****.*** 630-***-**** Ashburn, VA

Summary

Ganesh Nagarajan is a Senior Software Engineer, Enterprise, Data, and Solution Architect with over thirty years of expertise in strategy development and implementation. He has demonstrated proficiency as a leading individual contributor and innovative thinker, utilizing Open Group Architecture Principles in project execution. Among his notable innovations is the creation of a reference data hub during cloud migration to mitigate data crowding. Ganesh possesses strong capabilities in data management across enterprise applications, leveraging contemporary platforms. With extensive experience across the data management spectrum, he provides both hands-on and strategic leadership to ensure data availability across systems. He has a proven track record of leading diverse teams, both local and global, in delivering advanced technology solutions. Ganesh is an expert in deploying data solutions across various public cloud service providers and is skilled in Green Field data architecture, modeling, metadata, and data interfaces. He champions solution excellence through the implementation of test data management frameworks and consistent solution delivery via Agile and Waterfall methodologies.

Technology Proficiency

Cloud Providers Azure, GCP, OCI, AWS

Operating Systems Linux, Unix, Windows

Database Platforms Databricks, RDS (AWS), SQL Server, Oracle (Enterprise, Exadata, ExaCS, Cloud, Autonomous), SQL Server (on-prem, Azure), DB2, Informix, PostgreSQL, MySQL, BigQuery, Redshift

Data Management Data at rest, in compute, in motion (across cloud providers), Enterprise Architecture, Data Architecture, Solution Architecture, Technical Architecture, Data Analysis, Metadata Management, Master Data Management Agile Methodologies Agile, SAFe, Kanban

Frameworks TOGAF (9.0)

Business Areas

Healthcare (Health Insurance, Public Healthcare), Banking, Financial Services, Insurance, Mortgage Banking, Government, Federal Services, Retail, Energy, Utility, Cooperatives Professional Experience

Internal Revenue Services, 10/2023 – Present

IT Specialist (ENTARCH), Information Technology, Enterprise Services, Enterprise Architecture Role: Lead Cloud Domain Architecture, and Cloud Architecture design and development

• Developed TOGAF-driven hybrid technical architecture, implemented using ARIS (SoftwareAG).

• Led cloud architecture reviews for hybrid cloud environments, including EPaaS applications like Pega.

• Created an architectural blueprint for multi-generational data across platforms, providing a unified data source for hybrid cloud apps.

• Served as Cloud Domain Lead and Co-Lead for Cyber Security within Enterprise Architecture.

• Represented cloud applications in presentations to Cloud Center of Excellence executives. Represented cloud domain architecture development board.

• Guided projects in adopting Unified Visibility Architecture for data integration into observability ecosystems.

• Developed a component for cloud development tools to filter application criteria and receive platform recommendations.

• Led cloud delivery standards for Development Operations, focused on CI/CD for current and future projects.

• Directed Enterprise Architecture Guidance for Cloud and Infrastructure development. Deloitte Consulting, 05/2020 – 10/2023

Specialist Master, Cloud and On-Prem Data Architecture, Delivery Lead Role: Lead, Solution and Data Architect

● Explored Oracle 23, JSON Duality, and Multimodal database on VM and OCI for modernization.

● Architected and led data transformation from on-prem Oracle to Azure (SQL MI, ADF, Synapse), including transactional data and data lakes/hubs.

● Defined multiple migration architectures using ADF, Azure DevOps, Azure SQL, SQL-MI.

● Architected, modeled, and led data flow using Informatica-based data load patterns (OCI- Oracle, Teradata).

● Defined and implemented a process to harvest COVID data from various sources to an AWS container.

● Developed and implemented data wrangling and hydration of a COVID data lake for advanced analysis using multiple CSPs and data management techniques (AWS, Python, MySQL, Postgres, Unstructured).

● Applied TOGAF principles-based data architecture.

● Developed test data management platforms and repositories for QA, UAT, and pre-deployment validation.

Accenture Enkitec Group, 10/2019 – 05/2020

Senior Manager, Cloud and On-Prem Data Architecture, Delivery Lead Role: Program Lead and Architect

● Led cloud transformation for the Department of Veteran’s Affairs (VA) from On-Prem Oracle to AWS (Redshift) for decision support analytics and machine learning.

● Led delivery of Informix-based data/applications to Azure/AKS.

● Led data transformation to streamline customer and pre-GIS geospatial data to Salesforce ARCGIS format.

● Developed architecture components for a government project RFP, including migration of land and customer data from Informix to the cloud.

● Defined data-at-rest and data-in-motion patterns for data movement between on-prem and cloud systems.

● Led a multi-location team to discover, analyze, plan, architect, and deliver data from legacy systems to Salesforce and ARCGIS on AWS.

Tools: MuleSoft, Python, Oracle, Informix, AWS, Azure, Salesforce Cloud Role: Cloud Migration Architect

● Worked on migration initiatives from on-prem to Azure or GCP, defining database and data migration strategies.

Tools: Oracle, Dataflow, Nifi, BigQuery, Bigtable, Python Archmasters LLC (Co-founder and Chief Data Officer), 02/2019 – 02/2020 Role: Enterprise Architect, 04/2019 - 11/2019

Client: NRECA

Principal Enterprise Architect, Consultant supporting multiple applications and working on enterprise architecture strategy, developing API specifications using Swagger docs.

● Developed data management strategy, including:

● Glossary and Metadata management

● Customer data integration from multiple sources (Master Data Management and Data Engineering)

● EA Principles based on TOGAF recommendations

● Test data management for multiple delivery streams Role: Enterprise Solution Architect, 02/2019 - 04/2019 Client: Freddie Mac

MicroStrategy Platform Upgrade: analyzed the current state and decided on OS, Network, and MSTR, Tibco, and Kafka.

NTT Data Federal (DOJ), 09/2018 – 02/2019

Role: Enterprise Data Architect, Senior Manager

● DOJ-PAAS: Implemented a new notification system based on off-the-shelf software from Blackberry for Identity and Access Management.

● Led cross-functional teams to integrate data from all sources and implement the system.

● Integration model: XML, JSON, Microservices.

● Created and managed test data for USACCESS data domains. Environment: TOGAF, SQL Server, Blackberry AtHoc, XML, SSIS, Web Services, JSON, ETL, Warehousing Sense Corp - Consulting, 03/2018 – 09/2018

Role: Enterprise Solution and Data Architect

● Led architects and analysts in delivering solutions in IOT, Telecom, and Data Governance.

● Developed an IOT-based data management strategy for sensor-based data.

● Developed a data lake/hub for analysis of parts to predict maintenance/replacement needs for gas pipelines.

● Developed Reference Data/Master Data architecture strategy for Eyeglass manufacturers.

● Managed telecom services usage by hydrating and analyzing devices and service usage across state departments.

● Domain Lead for data management.

Environment: TOGAF, SQL Server, Oracle (On-prem and Cloud), Big Data, ML, Visio, MySQL, Informatica MDM, XML, XSLT, JSON, AWS (S3, Hive, Impala), Cloudera, AWS Fannie Mae, 06/2015 – 03/2018

Role: Enterprise Data Architect, Engineer, Data Warehousing and Data Governance

● Developed data architecture patterns and dimensional models (Kimball, Inmon) for loan and securitization warehouses, marts, and MDM projects.

● Worked on data architecture models and patterns for multi-source data integration hub, EDW, and reporting subject areas.

● Drove data and solution architecture for transition of legacy data warehouses to an Enterprise Data Warehouse.

● Defined data-at-rest and data-in-motion management architecture.

● Evaluated products for big data management.

● Delivered ETL Architecture on Informatica and Ab Initio.

● Built MDM concept and proposed course correction in MDM implementation.

● Led data, application, and solution architects.

● Delivered platform for reporting on MicroStrategy, Business Objects, and Tableau. Environment: AWS, Hive, HDFS, Impala, S3, lifecycle policies, Oracle, PL/SQL, Netezza, Informatica (IDR, ETL and MDM), TOGAF, XML, JSON, CSV, Collibra

Accenture Federal Services (CMS), 03/2014 – 05/2015 Role: Manager, Data Engineer and Solution Architect Project: Small Business Health Options Program, FFM-Financial Management Tower Healthcare administration.

● Led data architecture team.

● Worked on solution integration from internal (NoSQL, File, relational data) and external systems.

● Supplied solution approach, architecture, and estimates.

● Owned FF-SHOP COTS model review, presentation, and delivery of the data model.

● COTS Model review and revision.

● Developed data models for transformation and extensions.

● Established and supported coding standards.

● Provided guidance on database and solution architecture best practices and ran audits. Environment: TOGAF, Oracle, PL/SQL, Netezza, AWS, MicroStrategy, Business Objects, Ab Initio, Informatica

(IDR, ETL and MDM), XML, JSON, CSV

Infosys Limited, 05/2012 – 03/2014

Role: Senior Technical Architect

Clients: PricewaterhouseCoopers, BP, Shell Trading, SCI, Etisalat, Southern California Edison. Engagements:

• Enterprise Application Rationalization: Developed a process for application and data rationalization, prepared a roadmap (Metadata analysis, data management process development), and implemented movement of legacy applications to modern platforms.

• Solution Architecture: Developed an Enterprise Data Hub for the Oil and Natural Gas industry, analyzed enterprise data and prepared a model for data consolidation, developed an Enterprise Recruitment Platform strategy and architecture, and developed an enterprise platform and solution strategy.

• MDM for Services industry major: Hub data load and optimization (Strategy Solution and Execution).

• Database Architecture: Developed conceptual, logical, and physical data models for OLTP, ETL and MDM Schemas and an Enterprise data model as Enterprise Database SME for a multi- system Energy distribution environment using Spatial and non-spatial data across ERP, Distribution and Task management.

• Performed gap analysis and developed patterns to migrate legacy solutions with extended functionality.

Environment: TOGAF, Oracle, PL/SQL, Business Objects, Informatica (IDR, ETL and MDM), XML, JSON, CSV Accenture, 01/2011 – 05/2012

Role: Manager, Enterprise Data Architect, Test Data Management Architect Client: Shell Trading

- Performed gap analysis and developed patterns to migrate legacy solutions with extended functionality.

- Analyzed Oil Data Warehouse, developed mitigation plans for storage, ETL, and reporting issues.

- Reviewed and changed data models, and developed a blueprint for reporting using MicroStrategy. Client: Wal-Mart Corporation

- Managed database design, data flow, and QA data management.

- Provided technical and functional leadership in Information Architecture and test data management.

- Built and managed a test lab for enterprise applications.

- Developed repeatable processes for environment management.

- Managed infrastructure and DBA teams.

- Collaborated with client and development teams to create a rich test data bed and support the enterprise data model.

- Mentored application development teams and created 3NF data models.

- Analyzed data requirements for data modeling and flow. Environment: TOGAF, Oracle, PL/SQL, Business Objects, Informatica (IDR, ETL, MDM), XML, JSON, CSV Environment: TOGAF, Oracle, PL/SQL, Business Objects, Informatica (IDR, ETL and MDM), XML, JSON, CSV

Multiple Roles and Organizations (07/1992 - 01/2011)

- Purisma (A D&B Company): Principal Consultant

- Sears Holdings: Enterprise Data Architect, Delivery Manager

- DoubleClick Inc.: Data Architect, Solution Architect, Project Manager

- British Petroleum: Data Analyst/Team Lead

- JP Morgan Chase: Database Development, Team Lead

- Acxiom Corporation: Industry Solutions Architect Roles: Data Warehousing, private cloud data store with RDBMS Index, Grid base data load, process and data flows, Mart Build and Report build requests, C programs to manage IBM Big Endean data, DTS Scripts, stored procedures.

Environment: Microsoft Project, ERWin, Perl, Informix, DB2 (SQL, SQL-PL, Perl, DB Workbench), AIX, Linux, Oracle, DB2, Perl, Shell, SQL Server, Linux, Grid Computing, Data Stage, C, MS Project Environment: Microsoft Project, ERWin, Perl, Informix, DB2 (SQL, SQL-PL, Perl, DB Workbench), AIX, Linux Multiple Roles and Organizations, 07/1992 - 01/2011

• Purisma (A D&B Company): Principal Consultant

• Sears Holdings: Enterprise Data Architect, Delivery Manager

• DoubleClick Inc.: Data Architect, Solution Architect, Project Manager

• British Petroleum: Data Analyst/Team Lead

• JP Morgan Chase: Database Development, Team Lead

• Acxiom Corporation: Industry Solutions Architect Roles: Data Warehousing, private cloud data store with RDBMS Index, Grid base data load, process and data flows, Mart Build and Report build requests, C programs to manage IBM Big Endean data, DTS Scripts, stored procedures.

Environment: ERWin, Oracle, DB2, Perl, Shell, SQL Server, Linux, Grid Computing, Data Stage, C, MS Project Education & Training

Master’s degree in electrical communication engineering Indian Institute of Science

Bachelor’s degree in physics

University of Delhi

Training

TOGAF, PMP, High Impact Presentations

Technical Skills

● Cloud Platforms: AWS, Azure, GCP

● Programming & Databases: SQL, Python, Oracle

● Big Data & Analytics: Kafka, MicroStrategy, IoT

● Data Management: Data Warehousing, ETL, API Development

● Enterprise Tools: Informatica, Salesforce, Linux, ARIS, Alfabet Professional Summary Statement

I am a forward-thinking data engineering specialist with a proven track record in cloud and enterprise architecture. Passionate about leveraging cutting-edge technologies to drive innovation and streamline data integration for high-performance organizations.

Contact this candidate