DBT (Data Build Tool) Course Instructor

Senior Data Engineer | HCLTech, Apple ProjectAt Apple, I've had the opportunity to work on ETL processes, where I contributed to maintaining data integrity and efficiency. I’ve utilized Airflow to help automate and monitor a few data pipelines, gaining valuable experience in workflow orchestration. My work with Snowflake involved managing data for analysis and storage, ensuring it was ready for use by the team.I also got hands-on with Python, developing scripts for basic data transformation tasks like cleaning and loading. Additionally, I worked with a Jenkins-like CI/CD tool, supporting the continuous integration and deployment of our data pipelines.Technologies: Airflow, Snowflake, MySQL, Hasura, Rio (Jenkins), S3, Docker, Kubernetes, Python, GitHub.

Senior Data Engineer & Tech Lead | TCS, Roche Canada ProjectTEAM LEADERSHIP & PIPELINE REDESIGN- Led a team of engineers in the redesign of all Informatica pipelines using dbt during the migration from Oracle to AWS Redshift, ensuring efficient data management and smooth transition.CLOUD PERFORMANCE OPTIMIZATION- Enhanced pipeline performance and reduced cloud costs through strategic implementation of sort key and distribution key techniques.ADVANCED DOCUMENTATION & DATA QUALITY- Improved project documentation using dbt docs, creating a rich, detailed resource. Implemented custom data quality checks, allowing stakeholders to define thresholds, resulting in improved data security and quality.TOOLS & PROCESS SIMPLIFICATION- Developed tools to monitor data quality and pipeline execution in ThoughtSpot, simplifying legacy processes and improving the customer experience.SALESFORCE INTEGRATION- Engineered a Python-based writeback engine using the Salesforce API for seamless integration of pub/sub processes into existing systems.CLIENT COLLABORATION- Partnered with the client to gather requirements and ensure our technical solutions aligned with business needs, delivering efficient, secure, and user-friendly data solutions.DATA VISUALIZATION DEVELOPMENT- Created and optimized multiple data visualizations and dashboards using QlikView, enhancing decision-making processes through clear and actionable insights.Technologies: dbt, Redshift, S3, Athena, Glue, Informatica, Python, Kubeflow, Docker, ThoughtSpot, QlikView, GitLab, Salesforce, Oracle.

Data-Driven Sales Analyst with Global Expertise in Power BI Implementation and Process OptimizationI was a seasoned data analyst with a proven track record of transforming raw data into actionable insights that drove sales growth across diverse international markets. My expertise lay in developing and implementing KPIs, workflows, and monitoring frameworks that empowered management with real-time visibility into sales performance and trends, enabling data-driven decision-making at the global level.Key Contributions:Spearheaded the development and implementation of KPIs and workflows for the sales area, contributing to increased sales efficiency across multiple countries.Designed and implemented insightful Power BI dashboards, providing management with real-time data-driven insights to support informed decision-making on a global scale.Conducted reverse engineering of product registration processes across multiple regions, streamlining registration procedures and enhancing operational efficiency worldwide.Developed and implemented a sales pipeline monitoring framework, ensuring data accuracy and reliability for effective sales forecasting across international markets.Played a pivotal role in the successful implementation of Power BI across plants in Argentina, Colombia, and Chile, facilitating seamless tool adoption and utilization, fostering a data-driven culture in each location.Technical Skills:Masterful in Power BI, SQL, and data analysis techniques.Proficient in ERPs such as Protheus and SAP systems and its data extraction methods.

My role involved developing tools and mathematical models that enabled the creation of the annual budget and bi-annual revisions of the filling plan. These models facilitated projections for production and shipment volumes from the factories to the sales units, as well as future stock projections based on historical data.I also contributed to the construction of internal control BI tools (using Power BI) such as: measuring deviations between the budgeted and actual performance, programming efficiency indicators, factory efficiency indicators, sales reports by volume, and daily maps (a key indicator that contains information for tactical/operational daily decision-making).My work in development spanned from business needs assessment to the technical aspects such as identifying SAP tables for migration to the Oracle database via Data Service, modeling data in the Oracle database, and creating Power BI applications that supported decision-making for other team members.My proficiency in developing mathematical models, constructing internal control BI tools, and facilitating data-driven decision-making has significantly contributed to my skills in data analysis, database management, and project management. I am eager to take on new challenges and contribute my expertise to an organization's success in the manufacturing industry.

I automated a few management reports, creating routines in VBA for quick update of KPIs. From then on, I also worked on the development of management dashboards using Qlikview (ETL, data mining and object orientation). I participated in the development of revenue, inventory and productivity demonstration dashboards. In addition, I carried out operational tasks related to S&OP such as production plan maintenance, demand analysis, stock utilization and rework, stock viability studies, and deadline evaluation and establishment.

I participated in the development of production and inventory management reports. I also performed production plan administration activities, such as demand allocation and stock utilization.