Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Surendra Mukkamalla

Ashburn,VA

Summary

Over 18 years of experience as Information technology leader with a combination of leadership skills and deep hands-on expertise in cloud architecture, data engineering, application & platform development, and agile transformation. Over 5 years of experience with people management, provide strategic technical leadership on projects, directing team efforts towards successful completion while meeting organizational goals. Over 4 years leading digital transformations & AWS Cloud migrations with IICS (Informatica Intelligent Cloud Services), streaming, Talend, Snowflake, Hadoop, PySpark, and monitoring expertise. Over 12 years of experience in Data Warehouse, Data Marts, Business Intelligence, Data Governance, technology strategy development and execution, organization building, application, and data portfolio management. My success is driven by my ability to leverage broad and deep technical knowledge with exceptional business management skills to achieve consistently higher levels of success while creating relationships of trust and confidence with users, colleagues, and management. An AWS Certified Solutions Architect Professional with experience strategizing and leading cross functional teams in successfully implementing strategic IT initiatives through insightful, well architected solutions on latest platforms and technologies. Known for innovative approaches in solving complex technical and business problems. Extensive experience with Cloud computing (SaaS, PaaS, IaaS), Hadoop, NoSQL (MongoDB), Big data technologies. Significant experience in deploying DevOps methodologies to swiftly enhance technical agility, minimizing service delivery timescales from days to minutes.

Knowledgeable [Desired Position] with solid background in leading development teams to successfully deliver high-quality projects. Proven ability to guide cross-functional teams and streamline development processes, resulting in improved efficiency and product quality. Demonstrated expertise in software architecture and agile methodologies.

Experienced with leading development teams to create impactful software solutions. Utilizes agile methodologies and best practices to ensure efficient project delivery. Strong understanding of software architecture and team collaboration.

Professional with robust experience in software development and leadership. Skilled in driving project success through strategic planning and problem-solving. Strong focus on team collaboration, adaptable to changing needs, and results-oriented. Proficient in agile methodologies, coding standards, and fostering innovation. Reliable, with proven track record in delivering high-quality solutions.

Overview

19
19
years of professional experience
1
1
Certification

Work History

Chief Development Lead (Data Modernization)

FREDDIE MAC
09.2021 - Current
  • Led the creation of Freddie Mac's first CloudNative Data Warehouse in Snowflake to allow for efficient and scalable for analytics and reporting
  • Established the architecture for IDMC and configured CDI/IICS orgs with distinct secure agents to facilitate support for both on-premises applications and cloud-based analytics
  • Implemented data pipelines using IICS, utilizing mapping tasks, mappings, and task flows to seamlessly extract data from on-premises and AWS RDS cloud sources, feeding into Data Lake and Snowflake
  • Developed complex data mappings for enrichment, implemented data quality measures, and automated scheduling with Control-M for precise analytics and reporting
  • Implemented Collibra API integration via IICS for database and flat file ingestions
  • Data ingestion initiates only upon registration of all databases, flat files, and tables
  • Designed the product base data & semantic model for analytics; ETL layer to ingest data & convert to canonical model on Snowflake Cloud Native Data Warehouse for front-end querying
  • Created Secure Data Share with role-based access control to enable Snowflake objects for other accounts and consumers
  • Implement MongoDB Atlas schemas and collections in accordance with organizational data models, employing document-oriented design principles to ensure seamless integration and scalability for both structured and unstructured data
  • Employ Apache Spark to process and transform data, seamlessly integrating it into MongoDB Atlas collections for scalable and real-time analytics
  • Utilize Spark's robust APIs and MongoDB Connector to efficiently ingest and load data from various sources into MongoDB Atlas collections, ensuring high-performance data processing and storage

Tech Lead (Freddie Data Platform - Data Lake)

FREDDIE MAC
10.2018 - 08.2021
  • Developed proof-of-concepts for S3 buckets in Data Lake applications, streamlining data ingestion, cleansing, connectivity, and movement processes to modernize legacy assets
  • Led hands-on efforts to modernize the legacy Big Data Analytics Platform (BDAP) for operational optimization
  • Successfully migrated legacy assets to AWS Cloud, establishing a Data Lake on S3 infrastructure
  • Managed development of Spark based framework, Enrichment Pipeline with Hive to migrate data from HDFS (BDAP) to Data Lake S3 to support transactional data for analytic users
  • Engineered Splunk Dashboards by extracting log data from CloudWatch to verify completeness and accuracy
  • Built ingestion and consumption capabilities for both real-time and batch processes and implemented tools (Talend, IICS, Attunity) that will support corporate strategy
  • Responsible for design and development to build data enrichment by using PySpark, IICS, Talend Studio, and AWS Transfer sFTP
  • Partnered with product and architecture to implement multiple zones concepts within Data Lake
  • Responsible to develop the solution architecture for the Data Management Stream (Collibra to AWS integration) of the Data Lake program, Data Privacy Management and Enterprise Technical Catalog setup for migration
  • Managed to Capture Metadata and Data Lineage (Collibra, Glue), Data Classification and Explicit Access Policies, Data Access Mgmt access control (Dremio) for initiatives

Tech Lead and Application Architect (Data Marts and Business Intelligence)

FREDDIE MAC
04.2012 - 09.2018
  • Led the design and development of complex Informatica workflows, mappings, and sessions to extract, transform, and load (ETL) data from diverse source systems into data marts, ensuring optimal performance and data integrity
  • Architected end-to-end data integration solutions using Informatica PowerCenter, incorporating best practices for efficient data processing and delivery to support business intelligence initiatives
  • Collaborated closely with business stakeholders and data analysts to understand requirements and translate them into scalable Informatica workflows and mappings, enabling actionable insights and informed decision-making
  • Optimized Informatica mappings and sessions for performance and scalability, leveraging advanced techniques such as partitioning, pushdown optimization, and incremental loading to meet stringent SLAs and accommodate growing data volumes
  • Designed custom shell scripts to automate Informatica workflows, integrating with Autosys for Unix-based data processing
  • Implemented advanced scripting for data preprocessing, validation, and error handling, boosting data integrity

Sr. Data Engineer (Corporate Data Warehouse and Data Assets)

FREDDIE MAC
12.2008 - 03.2012
  • Provide centralized, safe, and readily available historical and current data from disparate data sources into relational database to support reporting, trend analysis, modeling and data mining
  • Designed and developed complex ETL processes using IBM InfoSphere DataStage, leveraging parallel processing and job sequencing for efficient data extraction, transformation, and loading
  • Utilized Unix shell scripting to automate DataStage job execution, schedule job runs, and perform file manipulations, optimizing workflow management and enhancing overall system reliability
  • Collaborated with cross-functional teams to troubleshoot and resolve data integration issues, leveraging strong Unix skills to diagnose system-level issues and optimize performance in DataStage environments
  • Collaborated with project and business teams to create product roadmap, design the product architecture, instituted agile SDLC processes, delivered the product MVPs, implemented customer pilots
  • Implemented infrastructure changes into the DW operational environment to minimize critical services disruptions
  • Supported SOX and Financial Reporting activities related to ODS and CDW

ETL Lead/Architect

Ajilon Consulting
01.2006 - 09.2008
  • Worked with multiple clients for data processing experience in implementing Data Warehousing and Data Mart applications, mainly transformation processes
  • Expertise in leading, architecting, developing, testing, implementing, and Supporting information technology projects in private and public sector with particular emphasis on requirements gathering, data analysis, data mapping, data integration, data Migration and application remediation across different platforms enabling usage of Standard ETL platforms for improved processing power, standardized infrastructure, Auditing, and lineage tracking

Education

Post Graduate Program - Artificial Intelligence

The University of Texas at Austin

Post Graduate - Cloud Computing

The University of Texas at Austin

Post Graduate Diploma - Computer Applications

Osmania University

BS - Engineering

Gulbarga University

Skills

  • Leadership & Management
  • Strategic IT Planning
  • Enterprise Application Development
  • Data Governance & Security
  • Business Requirement Analysis
  • Data Architecture
  • User Experience Design
  • Data Modeling
  • Operations & Maintenance
  • Product Management
  • Change Management
  • Systems Integration
  • Leading Cross-functional Teams
  • Traditional & Agile Methodologies
  • ITIL & Dev Ops
  • Process & Quality Assurance
  • Technology Delivery
  • Analytics and Business Intelligence
  • Cloud Tools & Services
  • ETL Tools & Databases
  • Governance & Security
  • Operating Systems
  • Agile Methodology
  • DevOps principles
  • Cloud computing technologies
  • Software development expertise

Certification

  • SnowPro Core Certification
  • AWS Solutions Architect Professional
  • IBM InfoSphere DataStage
  • ITIL Foundation
  • ITIL Continuous Service Improvement
  • AWS Certified Solutions Architect Professional

Timeline

Chief Development Lead (Data Modernization)

FREDDIE MAC
09.2021 - Current

Tech Lead (Freddie Data Platform - Data Lake)

FREDDIE MAC
10.2018 - 08.2021

Tech Lead and Application Architect (Data Marts and Business Intelligence)

FREDDIE MAC
04.2012 - 09.2018

Sr. Data Engineer (Corporate Data Warehouse and Data Assets)

FREDDIE MAC
12.2008 - 03.2012

ETL Lead/Architect

Ajilon Consulting
01.2006 - 09.2008

Post Graduate - Cloud Computing

The University of Texas at Austin

Post Graduate Diploma - Computer Applications

Osmania University

BS - Engineering

Gulbarga University

Post Graduate Program - Artificial Intelligence

The University of Texas at Austin
Surendra Mukkamalla