Summary
Overview
Work History
Education
Skills
Personal Information
Timeline
Generic

DEEPAK PRASAD

Austin,PA

Summary

Data Module Lead with 11+ years of experience in implementing data-intensive Business Analytics applications. Expert in designing scalable database solutions using Python, Oracle PL/SQL, Snowflake, and BigQuery, with a proven track record in transforming ETL workflows and optimizing performance. Adept at leading teams and delivering large-scale data-driven products, demonstrating strong leadership and innovative problem-solving skills.

Overview

12
12
years of professional experience

Work History

Solutions Architect

Wipro Austin
11.2023 - Current
  • Design 10+ solutions for royalty data processing using Python, Snowflake, Oracle, and APIs; ensure bug-free delivery
  • Resolve technical challenges, ensuring timely delivery of solutions
  • Collaborate across time zones to create self-sufficient CICD pipeline team
  • Optimize and automate existing processes for improved efficiency
  • Analyze complex technical requirements, providing strategic recommendations that optimize performance and support business goals
  • Responsible for delivery of solutions regarding processing of usage related data that enable to reduce number of jobs required from 30 to 6.

Data Module Lead

Datamatica Location
11.2022 - 02.2023
  • Involved in validation and performance tuning for multiple existing flows using google proprietary tools.
  • Directed validation and performance tuning of data flows using Google tools, enhancing system efficiency and reliability.
  • Collaborated with cross-functional teams to deliver scalable data solutions for sales and logistics, leveraging Python and Oracle PL/SQL.
  • Optimized complex Oracle PL/SQL procedures, improving data query performance and resource utilization.
  • Successfully automated data processing workflows, reducing manual intervention and increasing operational throughput.
  • Created tableau reporting for different business insights.
  • Worked with developers and engineers to realize technological solutions.
  • Maintained current and in-depth understanding of business processes, needs and objectives.
  • Streamlined complex Oracle PL/SQL procedures, significantly boosting data query performance and resource utilization.

Technical Lead - Implementation

Clearsense India Location
06.2019 - 09.2022
  • Led and mentored developers, delivering large-scale data products using Agile methodology, enhancing team efficiency
  • Streamlined pre-sales processes, delivering POCs that converted leads into clients, boosting sales success
  • Coordinated cross-functional teams for seamless data model integration, ensuring project success and collaboration
  • Mentored interns and junior developers, fostering continuous learning and professional growth
  • Pioneered new ELT techniques for processing HL7 data, significantly enhancing data accuracy and operational efficiency in Azure environments.
  • Improved systems with addition of new features and infrastructure.

Technical Analyst

Infosys Location
04.2015 - 06.2019
  • Developing and deploying multiple procedures and functions for data processing and integrated UI
  • Developing of ETL pipelines and implementing of DAGs to automate insurance related data processing
  • Analyzing different ETL processes and worked on fine tuning jobs with performance issues
  • Change legacy jobs(mainframe) into Informatica pipelines.

Software Engineer

Exilant Technologies Location
11.2012 - 04.2015
  • Developed and implemented reporting solutions using Oracle, Unix shell scripting, and Python, producing hourly metrics for orders, invoices, and deliveries
  • Engineered and optimized near real-time database solutions, enhancing data accuracy and processing speed for Apple's Global Sales Detail application
  • Managed and maintained the GSD application during NPI launches, ensuring zero downtime and seamless integration with new product data.
  • Delivered unit-tested systems within customer-prescribed timeframes.

Education

Bachelors in Technology - Science and Engineering

West Bengal University of Technology
West Bengal, India
01.2012

Skills

  • Scripting: Python, Unix
  • Tools: Infomatica, Pycharm
  • Database: Snowflake, Oracle, BigQuery, SQL
  • Reporting : Tableau
  • Methodologies: Agile, Waterfall
  • Big Data: Pyspark

Personal Information

Title: Solutions Architect

Timeline

Solutions Architect

Wipro Austin
11.2023 - Current

Data Module Lead

Datamatica Location
11.2022 - 02.2023

Technical Lead - Implementation

Clearsense India Location
06.2019 - 09.2022

Technical Analyst

Infosys Location
04.2015 - 06.2019

Software Engineer

Exilant Technologies Location
11.2012 - 04.2015

Bachelors in Technology - Science and Engineering

West Bengal University of Technology

Similar Profiles

CREATE PROFILE
DEEPAK PRASAD