Deepak G. Email & Phone Number

Chicago, Il, Us

Denver, Colorado, United States

- Built and Managed Pipelines: Developed ELT/ETL pipelines using AWS, dbt, Snowflake, and Airflow, streamlining data integration with Looker and Tableau.- Enhanced Data Quality: Improved data quality by 23% using dbt, Jinja macros, and Monte Carlo Data Observability, ensuring accurate and reliable data.- Improved Performance: Enhanced Spark job efficiency on Amazon EMR, reducing processing time by 20% through advanced partitioning and caching.- Automated API Data Integration: Automated the extraction and transformation of JSON data from REST APIs using Python, increasing data integration efficiency by 27%.- Designed Real-Time Solutions: Developed real-time AI/ML pipelines with DynamoDB, Kinesis, and SageMaker, ensuring timely insights for machine learning models.- Cloud Data Migration: Led the migration of cloud data to a more reliable source of truth, optimizing data pipelines using AWS services, Snowflake, and dbt to ensure better accuracy and performance.- Boosted BI Productivity: Managed self-service BI tools for 1,200 users, increasing productivity by 25% with Looker and Tableau dashboards.- Agile Adoption: Improved team productivity by 20% through the implementation of Agile practices using JIRA and Confluence.

- Spearheaded the development of automated data pipelines using AWS S3, PySpark, and Snowflake, reducing manual processes and increasing the efficiency of NCREIF financial data handling by 20%.- NLP Model Development: Designed and deployed a Natural Language Processing (NLP) model using Python (NLTK, Spacy) to cluster over 2 million unique text records, providing deeper insights into market research and client data.- Scalable Data Pipeline: Built a scalable data pipeline using dbt and Snowpark, combining tenant financial, property, and churn data. Developed machine learning models and visualized insights in Hex, enabling proactive tenant retention strategies and improved decision-making.- Custom Data Applications: Built custom data visualization and reporting tools using RShiny, enabling portfolio managers to interact with complex datasets and make more informed investment decisions.- Utilized R (Tidyverse) and Python (pandas, Janitor) to clean, manipulate, and structure large datasets, ensuring data quality and accuracy for downstream analytics.

San Antonio, Texas, United States

- Automated Data Integration Processes: Built automated data pipelines using AWS Glue, dbt, and Python, significantly improving the speed and reliability of data ingestion and transformation for enhanced analytics.- Improved Operational Efficiency: Enhanced process efficiency by automating manual workflows, resulting in a 20% reduction in process turnaround time, which allowed the team to focus on higher-value analytical tasks.- Financial Data Integration: Integrated Bloomberg financial data into Snowflake using Python and BLPAPI, enhancing the accessibility of real-time market insights for portfolio managers.- Data Warehousing Optimization: Designed and implemented scalable data pipelines using AWS Glue and Snowflake, improving the speed and efficiency of large dataset transformations and reporting.- Collaborated closely with data scientists and portfolio managers to align data engineering solutions with business needs, facilitating faster access to critical financial insights.

- Resolved Critical System Issues: Diagnosed and fixed a major bug in Yardi’s Voyager 7s, reducing client-reported data issues by 30% and significantly improving system reliability.- Optimized Data Processing Workflows: Developed SparkSQL queries to automate data extraction and reporting, resulting in a 20% boost in processing performance and improved workflow efficiency.- Led ETL Pipeline Development: Spearheaded the creation of ETL pipelines on Azure Databricks, enhancing data integration with Azure Synapse and improving overall reporting performance.- Improved Data Validation: Developed automated data validation scripts using Python and SQL, identifying data anomalies and ensuring consistency across ETL pipelines.- Tailored Client Reporting Solutions: Collaborated with clients to design and develop customized reports using Power BI and SSRS, enabling real-time data visualization and actionable insights aligned with their business goals.- Client-Focused Issue Resolution: Acted as the primary point of contact for troubleshooting data-related issues, resolving critical client concerns swiftly and improving overall satisfaction with Yardi Voyager 7S.- Cross-Functional Team Collaboration: Partnered with internal and external teams, including business analysts and client stakeholders, to design data integration solutions that addressed real-time data access and reporting needs.

Built and Optimized SQL queries within SQL Server Management Studio (SSMS): Improved data extraction and query performance for business intelligence reporting, which allowed for faster insights and better decision-making across teams. This optimization was achieved through deep analysis of query plans and making key changes to indexing and query structure to minimize performance bottlenecks.Developed, and sustained ETL processes using SQL Server Integration Services (SSIS): Designed and implemented highly efficient ETL processes that automated the flow of data between multiple systems. This transformation reduced manual data handling by 40%, enabling better accuracy, timeliness, and operational efficiency across departments, particularly in sales and finance.Collaborated with business analysts and stakeholders to design and implement custom SSIS packages for data migration: Played a pivotal role in ensuring seamless and accurate data transfers during system upgrades by designing and building custom SSIS packages. By closely collaborating with business analysts and stakeholders, I gathered critical requirements and ensured the migration process met all functional and technical specifications.Created and optimized Power BI dashboards with advanced DAX expressions, custom visuals, and real-time data tracking: Built highly interactive Power BI dashboards incorporating advanced DAX functions and custom visuals to deliver actionable insights across sales, operations, and finance teams.

Master'S Degree, Information Managment

Bachelor Of Engineering - Be, Information Technology