Data Engineer / Database Engineer

CHAMPAKA

RAMACHANDRAN

LINKEDIN

https://www.linkedin.com/in/champaka-

ramachandran-6740a8117/

SKILLS

Languages & Tools: SQL, Python,

Power BI, SSIS, SSRS

•

Databases: AWS Redshift, DynamoDB,

SQL Server (including HA),

PostgreSQL, Snowflake

•

Cloud Technologies: AWS (Lambda,

S3, Glue, Kinesis Firehose,

EventBridge, SQS, Redshift Serverless,

Zero-ETL)

•

Deployment & DevOps: Git, Red Gate,

CI/CD for databases

•

Data Engineering & Integration: ETL

pipelines, materialized views, schema

design, performance tuning, disaster

recovery

•

CRM: Salesforce (Sales, Service,

Marketing Clouds), CData, Skyvia,

Braze

•

• Data modeling - Miro, draw.io

Data warehousing - Amazon Redshift,

Amazon Snowflake

•

Experienced with designing and optimizing data pipelines to ensure seamless data flow. Utilizes advanced SQL and Python skills to create and maintain robust optimized data architectures. Track record of implementing scalable solutions that enhance data integrity and support informed decision-making.

WORK HISTORY

June 2022 - Current

Data Engineer Croissant – Fintech Startup, Remote

March 2019 - June 2022

Database Manager PayPal Inc., Conshohocken, PA

October 2017 - March 2019

Database Engineer PayPal Inc., Conshohocken, PA

Built robust ETL pipelines on AWS to ingest and transform data from DynamoDB, S3, and Kinesis Firehose into Redshift

•

Normalized semi-structured blob data using Lambda functions and SQL stored procedures, and glue etl jobs

•

Improved query performance by 25% through schema redesign and materialized views in Redshift

•

Automated stored procedure executions via AWS EventBridge, Lambda, and cron jobs

•

Collaborated with analytics teams to optimize Power BI, AWS QuickSight reports and enable real-time business dashboards

•

Served as Redshift DBA: managed clusters, user roles, and cross- database Glue jobs, Leveraged AWS CDK (Python) for infrastructure-as- code deployments

•

Evaluated Snowflake as a potential alternative to Redshift with a proof of concept

•

Worked on zero-etl integration from dynamodb to Redshift leveraging materialized views for normalizing the data

•

Led a team of DBAs and developers (team of 5), while building and maintaining high-performance data systems

•

Engineered data workflows and SQL stored procedures, jobs to support PayCheck Protection Plan initiative during COVID-19. This involved third party software integration with SQL Server for amortization and other financial calculations

•

Architected and implemented data schemas and workflows for Salesforce integration

•

Regularly conducted performance tuning and optimization, educating development and other teams

•

• Mentored junior engineers and contributed to hiring initiatives Migrated and restructured 11+ SQL Server instances to AWS EC2 for scalability and reliability

•

CONTACT

Greater Philadelphia, PA 18976

484-***-****

*********@*****.***

March 2016 - October 2017

Database Administrator DrugDev (QuintilesIMS Company), Wayne, PA January 2004 - January 2015

Database Administrator / Developer VoltDelta Information Sciences

(acquired by Neustar), Blue Bell, PA

Enhanced system performance with advanced T-SQL tuning and automated audits

•

Leveraged custom ETL code to integrate salesforce and SQL server via DBAmp and wrote custom code for data-hygiene of salesforce data, archiving of salesforce data to save cost etc

•

Collaborated with DevOps for SQL Server patching, upgrades, and HA setup

•

Supported analytics and reporting team with their data requirements, scheduling jobs and scripts for data manipulation

•

Used a combination of snapshot and transactional replication on various databases

•

Migrated 7 SQL Servers to AWS EC2, improving infrastructure efficiency

•

• Administered all 7 SQL servers, SQL jobs

• Regularly tuned existing stored procedures optimizing them

• Developed SSIS packages,Wrote stored procedures

• Set up transactional replication

Worked with .NET developers to provide stored procedures for the front end

•

Deployed SQL objects using Red Gate, ensuring consistency across environments

•

• Started as a Data Analyst and slowly took over DBA work Developed and maintained SQL Server databases, optimizing queries and automating reporting

•

Post merger, data was migrated to DB2 and all the reporting scripts were re-written for DB2

•

EDUCATION

M.S. Software Engineering

University of Houston – Clear Lake, Clear Lake, TX B.S. Electrical and Electronics Engineering

University of Mysore, India

Contact this candidate