SOWJANYA MUKKA

SENIOR MANAGER, DATA ENGINEERING

919-***-**** ad2dy4@r.postjobfree.com www.linkedin.com/in/sowjanya-mukka-176aab119/

Visionary Senior Manager of Data Engineering with 18 years of demonstrated success in leading cross-functional, high-performing teams to deliver innovative software solutions to drive business growth. Solves complex business challenges and guides decision-making processes by transforming data into efficient solutions. Deep understanding of the software development life cycle with first-hand experience in building modern applications using cloud-native architectural patterns and services. Expertise includes data modeling, architecture, and integration on multiple on-prem and in-cloud data platforms. Guides teams to meet challenging deadlines while ensuring a high level of quality and customer satisfaction. Passionate technologist with strong leadership and communication skills.

CORE COMPETENCIES

Data Engineering Data Modeling ETL Data Analysis Data Visualization Team Leadership & Mentorship Stakeholder Communication Business Intelligence Decision Support Programming ERP Implementation Database Management Reporting & Metrics Project Management Agile Methodologies Training & Development Strategic Planning Business Development Digital Transformation Program Governance Vendor Management Cloud Migration Collaboration

CAREER HISTORY

Capital One January 2023 – Present

SENIOR MANAGER, DATA ENGINEERING

Hand-selected to lead and deliver key strategic products and programs, driving IT strategy, design, execution, governance, and operations.

§Transformed a 10-member team of data engineers into a self-sufficient team by eliminating knowledge bottlenecks and increasing productivity.

§Plan, prioritize, and manage data engineering projects to ensure they align with business goals and are completed on time and within budget.

§Improved delivery by utilizing the effort of senior developers, changing the delivery strategy, and implementing checkpoints and mid-sprint reviews to fine-tune the delivery process.

§Oversee the development of ETL (Extract, Transform, Load) processes to integrate data from various sources into a centralized data warehouse or data lake.

§Ensure data integration processes are reliable, scalable, and maintain data quality standards.

§Monitor and optimize the performance of data systems to ensure fast and efficient data processing.

§Manage the budget for the data engineering department, ensuring efficient use of resources and aligning expenses with organizational priorities.

§Recruited, managed, and empowered multiple high-performing technical teams to create revenue-generating platforms while leading through transformation and innovation.

§Managed program governance, strategy planning, data-driven decision-making, cyber security, risk management, cloud migration, legacy technology transformation, vendor management, programs, and key stakeholder relationships.

§Delivered strategic programs and led anti-money laundering investigations, risk technology, and data analytics platform sourcing initiatives.

Western Digital November 2017 – November 2022

SENIOR MANAGER, DATA ENGINEERING

Pioneered a next-generation analytics environment, providing a self-service, centralized platform for all data-centric activities to allow a full 360-degree view of customers from product usage to back-office transactions.

§Design and implement robust, scalable, and efficient data architectures that support the organization's data needs.

§Ensure data models and structures are optimized for performance, security, and flexibility.

§Communicate effectively with non-technical stakeholders to convey the value and impact of data engineering initiatives.

§Oversee the development of ETL (Extract, Transform, Load) processes to integrate data from various sources into a centralized data warehouse or data lake.

§Ensure data integration processes are reliable, scalable, and maintain data quality standards.

§Constructed data visualization using Tableau and accessed aggregations using SQL Clients PostgreSQL and SQL Workbench.

§Recommended optimal solutions and tailored applications based on business objectives and design feedback, collaborating with teams in an agile environment.

§Collaborate with other senior managers and executives to align data engineering strategies with overall business objectives.

§Provide training and support to team members and other stakeholders to ensure the effective use of data engineering solutions.

§Implement and promote continuous improvement initiatives within the data engineering team, optimizing processes and increasing efficiency over time.

San Francisco Police Department December 2016 – November 2017

ETL ARCHITECT

Interpreted data from primary and secondary sources using statistical techniques and provided ongoing reports using OBIEE.

§Designed and implemented a “Use of Force” data model to provide education on racial profiling and forces applied by police officers.

§Develop the overall ETL architecture and design scalable, efficient, and robust ETL processes.

§Define data flow, transformation logic, and error handling mechanisms.

§Consider performance, scalability, and maintainability aspects during the design phase.

§Design and implement data models for the intermediate and target data structures.

§Ensure that the data model aligns with business requirements and is optimized for reporting and analytics.

CAREER HISTORY CONTINUED

University of Chicago May 2016 – December 2016

ETL ARCHITECT

Analyzed large datasets to provide strategic, data-driven direction to the University, including quantitative analysis of research enrollment trends to guide financial funding decisions.

§Architected the dimensional model of the star schema and created the ETL interface and packages to automate the data flow.

§Designed ETL auditing steps to ensure data integrity and completeness of the ETL process.

§Developed slow-changing dimension interfaces of type I, II, and II flags and time stamps.

§Implement performance tuning strategies to optimize the speed and efficiency of ETL processes.

§Monitor and analyze ETL job performance, identifying and resolving bottlenecks.

§Establish metadata standards and manage metadata to document and track data lineage, transformations, and dependencies.

Mercedes Benz Financials January 2015 – May 2016

ETL/BI ANALYST

Implemented analytical data mart which involved ETL from multiple third-party systems.

§Gather data from various sources, both internal and external and ensure data accuracy and consistency.

§Use statistical methods and tools to analyze large datasets.

§Identify trends, patterns, and insights within the data.

§Merged cost data with production data to provide further insight into business operations.

§Create reports and dashboards to communicate insights to stakeholders.

§Use BI tools (e.g., Tableau, Power BI) to create visually compelling representations of data.

§Monitor key performance indicators (KPIs) and metrics.

Capgemini Consulting September 2012– Nov 2014

ETL developer

Implemented analytical data mart which involved ETL from multiple third-party systems.

§Gather data from various sources, both internal and external and ensure data accuracy and consistency.

§Use statistical methods and tools to analyze large datasets.

§Identify trends, patterns, and insights within the data.

§Merged cost data with production data to provide further insight into business operations.

§Create reports and dashboards to communicate insights to stakeholders.

§Use BI tools (e.g., Tableau, Power BI) to create visually compelling representations of data.

§Monitor key performance indicators (KPIs) and metrics.

Tata Consultancy Services September 2006– November 2012

SQL developer

Implemented analytical data mart which involved ETL from multiple third-party systems using SQL.

§Designing and creating database structures based on the requirements of the application or system.

§Developing database schemas, tables, and relationships to ensure efficient data storage and retrieval.

§Writing and optimizing SQL queries to ensure fast and efficient data retrieval.

§Analyzing and fine-tuning existing queries for better performance.

§Creating data models and diagrams to represent the relationships between different data entities.

§Working with stakeholders to understand data requirements and translating them into effective database designs.

§Implementing and maintaining database systems, including installation, configuration, and upgrades.

§Developing stored procedures, functions, and triggers to automate common database tasks and enforce business rules.

§Optimizing and troubleshooting existing stored procedures.

EDUCATION

Bachelor of Computer Science Engineering Oxford College of Engineering

TECHNICAL SKILLS

AWS (S3, EC2, DynamoDB, Lambda, OpenSearch, Snowflake, SNS, SDP) Oracle ERP Cloud ODI, DataStage, Informatica

SQL & Hive Python Spark Core, Spark SQL, Spark Streaming Oracle, Redshift, MySQL HBase Cognos, OBIEE, Tableau Jira, ServiceNow, GitHub

Contact this candidate