Swapnith Gangasani

Data Engineer

https://www.linkedin.com/in/swapnith-g-8a34a4146/

929-***-****

ad4xtg@r.postjobfree.com

4+ years of experience as a Data Engineer with a demonstrated proficiency in implementing robust data solutions and optimizing Business operations. Skilled in utilizing a wide array of cloud services across AWS including AWS EMR, EC2, S3, Redshift, RDS, Lambda, DynamoDB, EKS, and GCP services like Google Cloud Storage (GCS), Google Cloud Dataflow, Google Cloud Functions, Google Cloud Composer, Google Cloud Data Catalog, and Google Kubernetes Engine (GKE). Expertise in programming languages such as Python, SQL, and Shell Scripting, coupled with experience in managing both NoSQL databases like DynamoDB and traditional databases like RDS and Redshift. Proven track record of implementing end-to-end data lifecycle management, automating ETL processes, and building real-time data pipelines to enable faster analytics processing. Proficient in utilizing visualization tools like QuickSight, Power BI and Tableau for insightful data representation and analysis. Possessing an MBA in Operations and Supply Chain Management, Certified AWS Data Engineer Associate and complemented by certifications in Lean Six Sigma, Power BI, SQL, and Tableau. Committed to driving continuous improvement and achieving operational excellence through strategic data-driven insights and cross-functional collaboration.

Skills

AWS: EMR, EC2, S3, Redshift, RDS, Athena, Lambda, DynamoDb, EKS, Glue

GCP: BigQuery, Dataflow, Dataproc

Programming Languages: Python, SQL, Shell Scripting, Pig Latin, HiveQL

NoSQL Database: DynamoDB, MongoDB

Hadoop: Sqoop, Hive, HBase, Spark, MapReduce, Oozie

Database: RDS, Redshift, MySQL, Oracle, MS SQL SERVER, Snowflake

Visualization: QuickSight, Tableau, Power BI

Data Warehouse: Redshift, Snowflake

API: API Gateway, Lambda, DynamoDB, Rest API, Django, Flask

Certifications

AWS Data Engineer Associate(861587ce20e34f1abbbea68c63e729ba), Lean Six Sigma Yellow Belt (HXno8GrrDL), Power BI Essential Training, SQL for Data Analytics, Tableau Essential Training, Advanced Excel and Formulas - LinkedIn Learning

Work History

Data Engineer 2022-03 - Current

TimeSquare IT Inc

●Implemented secure and scalable data lakes on both Google Cloud Storage (GCS) and AWS S3, optimizing storage and access for raw and processed data across platforms.

●Automated ETL processes using Google Cloud Dataflow and AWS Glue, resulting in significant reductions in manual efforts and enhanced data processing speeds.

●Built real-time data pipelines using Google Cloud Functions with Cloud Composer orchestration and AWS Lambda with Step Functions, reducing data latency and enabling faster analytics processing.

●Established comprehensive data lineage and metadata tracking systems using Google Cloud Data Catalog and AWS Glue catalogs, ensuring trusted data pipelines and simplified dataset discovery.

●Utilized native services from both Google Cloud and AWS to efficiently handle increased data volumes, enabling scalable data infrastructure without compromising performance.

●Implemented data lifecycle management best practices on both GCS and S3, resulting in substantial cost savings on data storage across platforms.

●Integrated Snowflake's data warehouse capabilities and Databricks for advanced data processing and analytics tasks, improving overall efficiency and scalability of data operations.

●Developed CI/CD pipelines for infrastructure-as-code using both Google Cloud Deployment Manager and AWS CloudFormation, automating deployments and enhancing release velocity.

●Collaborated with vendors and suppliers to optimize delivery options and drove cost reduction efforts across the supply chain, ensuring alignment with annual operations targets.

●Oversaw end-to-end supply chain processes, from purchase order to delivery to invoicing, ensuring 100% end-user satisfaction across platforms.

●Integrated NoSQL databases like MongoDB and DynamoDB to handle semi-structured data efficiently in data processing pipelines.

Sr. Associate, Business Operations 2021-08 - 2022-03

United Scientific Supplies, Libertyville, IL

●Efficiently utilized Oracle NetSuite ERP system to monitor and manage B2B sales orders, inventory levels, and reorder points, reducing fulfillment cycle times by 15% through streamlined order workflows.

●Implemented ABC analysis methodology to classify products based on importance and profitability, leading to strategic cost reduction initiatives and resource prioritization, resulting in an 8% increase in Return on Invested Capital (ROIC).

●Collaborated closely with the warehouse team to optimize order fulfillment processes, enhancing warehouse efficiency and reducing fulfillment cycle times, contributing to overall operational improvements.

●Utilized Magento 2 e-commerce platform to streamline online B2B sales processes, resulting in increased conversion rates and customer satisfaction, thereby enhancing the overall shopping experience.

●Conducted comprehensive data analysis and forecasting to determine optimal inventory levels, minimizing stock outs and overstock situations, ultimately improving working capital efficiency.

●Led supply chain improvement efforts by managing carrier relationships, overseeing customs activities, and implementing international security measures, ensuring a reliable and cost-effective shipping process.

●Negotiated prices and terms with shipping companies and supply vendors, worked closely with suppliers to manage schedules, specifications, and quality compliance, contributing to overall supply chain optimization.

Sales Operations Intern 2021-01 - 2021-04

Similarweb, New York, NY

●Utilized Salesforce Lightning to customize and optimize the user interface, enhancing user experience and productivity for the sales operations team.

●Developed and executed advanced SQL queries and scripts to extract, transform, and load large datasets, enabling data-driven insights and reporting for sales performance analysis.

●Created complex data models in Salesforce, utilizing custom objects, fields, and relationships to improve data accuracy and support advanced reporting requirements.

●Designed and maintained Tableau dashboards and reports, providing interactive visualizations for sales metrics, pipeline analysis, and forecasting, facilitating effective decision-making.

●Collaborated with stakeholders to define key performance indicators (KPIs) and build automated reports and dashboards in Tableau, streamlining data analysis processes and enabling real-time monitoring of sales performance.

●Conducted data profiling and cleansing activities using SQL, ensuring data integrity and consistency across multiple systems and databases

Business Operations Specialist 2018-01 - 2019-07

Amazon India, Hyderabad, India

●Managed seller accounts, overseeing FBA inventory updates, audits, and supply chain performance for optimal operational efficiency.

●Utilized SQL queries and data analysis techniques to evaluate seller inventory data, extracting insights to optimize costs, identify trends, and enhance forecasting strategies.

●Utilized Tableau for data visualization, creating dynamic dashboards to present supply chain metrics and inventory trends, enabling informed decision-making processes.

●Automated seller support workflows using Excel macros, VBA, and SQL scripts, streamlining processes and increasing efficiency by 25%.

●Regularly reconciled inventory and customer orders, employing SQL queries and data analysis tools to monitor product availability, identify discrepancies, and ensure seamless operations.

Education

MBA: Operations and Supply Chain management 2019-08 - 2021-05

New York Institute of Technology - New York, NY

Bachelor of Science: Mechanical Engineering 2014-09 - 2018-05

Jawaharlal Nehru Technological University - Hyderabad, IN.

Contact this candidate