Senior Data Engineer

Srinivas Angalkudru

U.S. Citizen

*****.********@*****.*** 571-***-**** - Mobile

https://www.linkedin.com/in/sriniangalkudru/

Summary: Highly motivated and results-oriented Technologist with 25+ years of SDLC experience including leading and mentoring juniors. Proven expertise in designing, developing, and implementing robust and scalable data solutions across diverse domains. Adept at driving data-driven decision making by transforming data into actionable insights. Strong leadership, communication, and collaboration skills with a proven ability to build and maintain strong relationships with stakeholders across all levels.

Professional Experience:

Project Name Client Duration

ARDAP -GFIM

LMI Consulting LLC

01/23 – Present

USBP – Digital Transformation

LMI Consulting LLC

–

DaRT – Data and Rep Technology

Charles Schwab-100% Remote

01/22 – 01/23

Resource Management system (RMD)

Fannie Mae, Herndon, VA

05/09 – 11/21

HAMP

Fannie Mae, Herndon, VA

05/09 – 11/21

Compliance Reporting

Knight Equity Markets

09/08 – 04/09

Mantas – AML

Citi, NYC

07/07 – 07/08

Mantas – AML

Mantas, NYC

02/07 – 07/07

Mantas –TCM / AML

Credit Suisse, NYC

01/05 – 01/07

Corporate Actions Enrichment

Brown Brothers Harriman, NJ

03/04 – 12/04

USGAAP

Credit Suisse First Boston, NYC

05/03 – 02/04

RDS -TRAM Reporting System

Putnam Investments, Norwood, MA

04/00 – 05/03

Debit Card System

Worldwideweb Systems, Miami, FL

06/99 – 04/00

Technical Expertise:

Python – Pandas Boto3 NumPy cx_Oracle Matplotlib PySpark

Power BI Power Query DAX R

Project Management – JIRA

Cloud Platforms: AWS Azure

Cloud Analytics – Azure Synapse

Kubernetes: Deployment, Scaling, Networking, Security, Monitoring, Troubleshooting

CI/CD: Jenkins, GitLab CI/CD, Azure DevOps, Urban Code

Databases: Oracle, PLSQL, SQL Loader, Pl/SQL Developer, TOAD, SQL-Navigator

Sybase System 10 SQL Server MongoDB PostgreSQL Dynamo DB Aurora

Informatica PowerCenter

Knowledge & Experience of ETL – AWS Glue EMR

Autosys Crontab Control-M

Agile Methodology: Scrum, Kanban

Shell scripting, NT-Batch scripting

Perl awk sed

Power Builder

UNIX – Sun Solaris 5.8, sun4v, Linux – 3.0, 12-SP5 MS-DOS, Windows 95, NT, 2K, XP and 10

LMI Consulting LLC 01/23 – Present

Senior Consultant

LMI Consulting is a management consulting company providing professional Information Technology services to Department of Defence, Homeland Security, Health & Civilian, Space, Intelligence.

I led a key role in the LMI’s Digital Transformation effort in Homeland Security space.

Collaborated with the stake holders to define, execute the data engineering strategy and roadmap.

Played a key role in the design and development of data pipelines, data warehouses, and data lakes using AWS, Python, Spark.

Implemented data quality and governance frameworks to ensure data accuracy, consistency, and compliance.

Engaged with business stakeholders to understand their data needs and translate them into effective data solutions.

Developed complex Power BI reports from scratch.

Defined analytical approach, developed and optimized KPIs, and implemented scalable data processes.

Optimized Power BI Dashboard performance by implementing indexing and partitioning resulting in 30% reduction in load time.

Leveraged Python libraries NumPy, Matplotlib to create comprehensive data visualizations and reports.

Contributed to the development and implementation of data-driven decision-making processes.

Defined and conducted scrum and other software release and operational practices of the team effectively to support production cloud services.

Multi-team Agile practitioner skilled in Scrum and Kanban.

Conducted meetings at regular cadence with leadership to discuss the technical trade-offs in product development with engineers, quality assurance engineers and other stakeholders.

Also, worked in DoD space as a Data Engineer / Data Architect role.

I developed integration strategy of partner systems into one platform called GFIM-OE for the Army-ARDAP.

Dept of Defence – Army - ARDAP – GFIM PEO-EIS

Senior Data Engineer

Accomplishments:

Engaged with stakeholders and implemented Data Harmonization of GFIM (Global Force Information Management) data from approved data sources (S3 bucket, DBs) by developing ETL pipelines using AWS Glue to ingest, transform, and load data for custom reports as well as for business intelligence.

Developed and maintained AWS Glue crawlers to discover and infer schemas from approved GFIM data sources.

Created / Optimized AWS Glue ETL jobs using PySpark to perform data manipulation like transform, clean, and enrich.

Implemented data quality checks and monitoring using AWS CloudWatch to ensure data accuracy and reliability.

Transformed data is loaded into Redshift for analytics and reporting.

Used AWS Athena to query data within Glue Data Catalog.

Automated ETL pipelines by using Lambda functions to trigger Glue jobs.

Optimized Glue job performance by tuning Spark configurations and applying data partition region / base wise.

Engaged with data analysts and business stakeholders to understand data requirements and translate them into technical solutions.

Integration of Partner Systems:

oA larger effort to subsume all ARDAP-GFIM legacy systems into GFIM-OE (Global Force Information Management Objective Environment).

oAs part of that effort, I created an Integration process document of the following partner systems into GFIM-OE by identifying the Inbound / Outbound feeds (direct & manual):

cQuip/cProbe (Planning Programming Budgeting Business Operating System)

AESIP (Army Enterprise Systems Integration Program)

oConducted meetings with the legacy systems POC's and the end-users to identify / document the API endpoints with its authentication and authorization methods.

oConducted meetings with the development partner (BigBear.ai) to share, learn and document the API integration solutions.

Adopted Agile methodology.

Technologies Used: Python, Jira, SQL Server, AWS (Glue, Athena, Aurora), GitLab, Windows

USBP – Digital Transformation

Senior Software Engineer

USBP – DT effort is to automate the manual report generation process.

Accomplishments:

Adopted Agile methodology for automating Tactical Communication Devices Report.

Created a Single Source of Truth by unifying disparate data into a composite dataset by developing ETL pipelines using AWS Glue.

S3 bucket is the primary data lake for Glue ETL jobs.

Used Athena to query data within the Glue Data Catalog.

Loaded transformed data into Redshift for analytics and reporting.

Architected and implemented custom reports using python scripts.

Conducted meetings at regular cadence with leadership and other stakeholders to discuss / appraise the project status.

Recommended Data Observability and Monitoring Platform for Data Lineage, Data Quality (Work-in-progress).

Technologies Used: Python, Jira, SQL Server, AWS (Glue, Athena, DynamoDB), GitLab, Windows

Client: Charles Schwab, 100% Remote 01/22 – 01/23

DaRT – Data and Report Technology

Senior Software Engineer

DaRT – Data and Report Technology group generates various analytical reports of global trading data for business users.

Accomplishments:

Engaged in the process of upgrading from RHEL 6 to RHEL 8 - migrating python, Perl and shell scripts.

Analyzed, extracted, ingested and transformed large volumes of disparate global trading data using Azure Synapse analytics.

Implemented data pipelines within Azure Synapse Analytics, utilizing data ingestion, transformation, and analytical capabilities to process diverse data sources.

Optimized high-performing OLTP workloads using Azure Synapse Analytics dedicated SQL pool for improved query performance and reduced latency

Developed and deployed interactive Power BI dashboards and reports that provided actionable insights to stakeholders.

Proficient in utilizing Azure Synapse Analytics serverless SQL pool for efficient and cost-effective on-demand analytics.

Technologies Used: Python, PySpark, SQL Server, Oracle 19c, Bitbucket, Big Data, Azure Synapse, Power BI, RHEL-6, RHEL-8

Fannie Mae, Herndon, VA 05/09 – 11/21

Resource Management Database system (RMD)

Software Engineering Lead Associate

Resource Management Database system maintains and tracks all MHA (Make Home Affordable)

resource’s regulatory requirements. It provides regular feedback to the concerned departments about.

the individual’s compliance. The application is developed in python using Flask framework for UI and

running on Gunicorn server. It accesses a Microsoft SQL/Server DB and many feed files as

Excel Spreadsheets and uses Oracle as database.

Accomplishments:

Adopted Agile, WOW and P2P.

Developed scripts to extract data from SQL Server to Oracle using Python after thorough data analysis.

Developed scripts for data conversion, Build Processes, Reports and Utility scripts using Python.

Developed / Modified SQL Queries.

Developed UI application using Python Flask.

Technologies Used: Python, Jira, SQL Server, Oracle PL/SQL, ClearCase Version Control, LINUX – SLES 12-SP5, Windows, Autosys.

Investor Reporting – Home Affordable Modification Program

Software Engineering Lead Associate

Fannie Mae is doing the HAMP initiated by Treasury department. IR application collects mortgage loan

information from servicers for eligible borrowers. It calculates compensation for servicers, borrowers and

investors for staying ‘Active’ in the program.

Accomplishments:

Engaged with relevant stakeholders for requirements gathering as well as design discussions for on-going releases.

Developed / Implemented various modules like loan correction / cancelation / compensation by implementing Bulk Collection features for handling large volumes of loan data.

Developed UT (Unit testing) packages to test various loan modules.

Engaged in peer-2-peer code reviews.

Engaged with System / UAT testing teams for test cases evaluation.

Shifted from waterfall to Agile way of working in 2017.

From 2014 onwards I was leading a dedicated team of 4 including myself to implement production hot / bug fixes after business hours

oEngaged with business stakeholders to identify / analyze the root cause of production issue.

oEngaged with PM to generate / track the hot / bug fix ticket creation to its conclusion.

oApplied the hot / bug fix in lower environment before pushing to production.

oConveyed the hot / bug fix to development team to add it to the next release.

oDeveloped backout plan as a risk mitigation strategy.

Technologies Used: Oracle PL/SQL, ClearCase Version Control, UNIX – Sun 0S sun4v, Windows, Autosys.

Knight Equity Markets, L.P., Jersey City, NJ Senior Oracle Developer 09/08 – 04/09

Developed Reports using Oracle Procedures & Functions.

Automated trade execution extractions and loading process.

Technologies Used: Oracle PL/SQL, 10g, SQL Loader, Shell Scripting GNU Linux 5.2.1, Windows.

Affusion Inc. 07/07 – 07/08

Client: Citi, Wall Street, NYC, NY 07/07 – 07/08

Anti-Money Laundering – CBNA (Citibank North America Business)

Anti-Money Laundering – CPB (Citi Private Banking)

Did query optimization, wrote data mapping process.

Developed scripts to extract and load large data feeds.

Technologies Used: Oracle PL/SQL, SQL Loader, Shell Scripting, UNIX Sun 0S 5.8, Windows NT, Informatica PowerCenter.

Mantas 02/07 – 07/07

Anti-Money Laundering

Performed professional service to implement, trouble shoot Mantas applications at various client’s site.

Technologies Used: Oracle PL/SQL in 9.2, SQL Loader, Shell Scripting, UNIX – Sun 0S 5.8, Windows, Informatica PowerCenter.

MGL Americas Inc. (Formerly Fortuna Technologies Inc.) 06/99 – 02/07

Client: Credit Suisse, NYC, NY 01/05 – 01/07

Mantas - Trade Compliance:

Developed processes to extract and load 5M equity & fixed income trade,

Developed mapping process using Oracle procedures & functions.

Client: Brown Brothers Harriman, Jersey City, NJ 03/04 – 12/04

Corporate Actions Enrichment:

Implemented query optimization on existing SQL queries using HINTS

Developed data extractions & transformation scripts for large volume using Oracle procedures & functions.

Client: Credit Suisse First Boston, NYC, NY 05/03 – 02/04

USGAAP (Generally Accepted Accounting Principles in United States)

Developed Oracle procedure & functions for data mapping.

Automated report delivery process.

Client: Putnam Investments, Norwood, MA. 04/00 – 05/03

Risk Decision Support (RDS) System

Developed extensive stored procedures & functions in this data warehouse application.

Client: Worldwideweb Systems, Miami, FL. 06/99 - 04/00

Debit Card System

Designed the system through Entity-Relationship diagrams. Used Oracle Forms / Reports to implement business logic.

AWS Certified Solutions Architect – Professional

Issue Date Jan 04, 2025

Expiration Date Jan 04,2028

Candidate ID: AWS02461422

Number: 3QPX91HLMBQE19KV

Certified SAFe 5 Government Practitioner

Issue Date March 21, 2024

Expiration Date March 21,2025

Number: 899*****-****

Certified Scrum Master (CSM)

Issue Date April 18, 2024

Expiration Date April 18, 2026

Number: 001639882

SNOWPRO Core Certified

Issue Date April 15, 2024

Expiration Date April 15, 2026

Number: S0029632

SY0-701-CompTIA Security+

Issue Date November 14, 2024

Expiration Date November 14, 2027

Candidate ID: COMP001022640426

Contact this candidate