◆ Developed ETL solutions to migrate data from existing on-Prem solutions to AWS services to create and maintain a cloud based Data Warehouse for storing business data for analytical reporting. ◆ Designed pipelines using tools such as AWS Glue, AWS DMS, Kinesis and customized Python scripts to implement business rules, logic, cleansing for ingesting data on S3 buckets and Amazon Redshift and Snowflake. ◆ Created and maintained Databricks notebooks for collaborating with business users and developers to provide robust analysis and setting up an environment for machine learning. ◆ Responsible for transforming raw data into flattened files using ETL and SQL stored procedures. ◆ Developed and maintained reusable Spark scripts to be used with AWS Glue for ETL implementation. ◆ Automated and monitored the ETL processes run by Python queries using Airflow. Developed a robust alerting system to make sure issues are fixed in a timely manner. ◆ Created BI Dashboards using AWS Quicksight and Power BI. Conducted Proof of Concepts for other potential tools such as Tableau which can be implemented at the organization level in the future. ◆ Designed data models for consumption on Redshift from sources such as Salesforce and NetSuite. ◆ Responsible for sizing, configuring, launching, and administrating Amazon Redshift clusters to host data for business analytics.

Amazon | Dec 2020 - May 2021

Business Intelligence Engineer

◆ Analyzed technical and business requirements for reporting requirements for the Transport Risk and Compliance team. ◆ Built ETL pipelines for data extraction, transformation, loading, and integration, using internal ETL tools such as Datanet, AWS Glue and Hammerstone. ◆ Worked on architecting the ETL transformation layers and wrote spark jobs for big data processing. ◆ Implemented Apache Airflow for authoring, scheduling and monitoring Data Pipelines. ◆ Responsible for developing and maintaining data services and data movement infrastructures. ◆ Developed Power BI dashboards to visualize metrics to identify risks and ensure compliance with policy requirements. ◆ Collaborated with third-party vendors to ingest data which helped Amazon keep in compliance with regional regulations. ◆ Participated in the full software development lifecycle with requirements, solution design, development, QA implementation, and product support using Scrum and other Agile methodologies. ◆ Prepared associated documentation for specifications, requirements, and testing.

Tata Consultancy Services | Client: Microsoft | Jan 2020 - Dec 2020

Data Warehousing Specialist

◆ Designed, built, and tested data pipelines leveraging Azure Databricks and Azure Data Factory. ◆ Experienced in developing spark applications using spark sql and pyspark in Databricks for analyzing data from multiple data sources. ◆ Hands-on experience with various Azure data storage solutions such as Azure Cosmos DB, Azure Data Lake Storage, and Azure Blob Storage. ◆ Developed advanced analytical reports using machine learning tools for customer segmentation and forecasting. ◆ Responsible for estimating the cluster size, monitoring, and troubleshooting the Spark Databricks cluster. ◆ Part of Microsoft Gaming Data Services team responsible for building Data Marts & creating, enhancing and supporting reporting and analytical needs of the client for customer behavior analytics. ◆ Designed and developed data models, reports and scorecards for various analytical needs across various products and services of Microsoft such as Xbox and PC Gaming. ◆ Maintained data acquisition platform system for Gaming Data Services team and provided the desired data in an efficient way from various sources like Multidimensional cubes, Tabular cubes, SharePoint, Excel, Flat File, etc.

Blue Lotus | Nov 2019 - Jan 2020

Data Analyst

◆ Developed and implemented Cloud infrastructure using various platforms for customers. ◆ Implemented fact-dimensional modeling (Star schema, Snowflake schema), transactional modeling and SCD. ◆ Developed KPIs for customers in retails to report on stock inventory and P/L statements. ◆ Created and maintained data reports in Cloud visualization tools such as Tableau and Power BI. ◆ Implemented migration of on-premises infrastructure to cloud solutions such as AWS and Azure. ◆ Developed Proof of Concept for migrating customer data to Cloud platforms including AWS and Azure.

Amazon | Jan 2019 - Sep 2019

Data Engineer/BI Developer

◆ Analyzed the business and technical environment for data requirements at EHS using established compliance guidelines. ◆ Built and scaled out cloud environment in AWS using services such as Redshift, Lambda, DMS and Airflow to help migrate from existing AWS cloud accounts. ◆ Implemented analytical data projects to create ETL pipelines from third-party databases to local redshift clusters using AWS Glue and AWS DMS services for reporting on compliance and action tasks assigned to site workers thus saving at least 20 hours of manual work every week. ◆ Provided recommendations to reduce costs of existing AWS services by 30% and streamlined the data-pipelining process. ◆ Performed gap and impact analysis to identify dependencies, roadblocks & risks in the implementation of agile methodology. ◆ Enabled decision-making for global fulfillment centers around storage, transportation of hazmat and disposal of waste by implementing projects on compliance regulations i.e. OSHA, EPA, and WEEE. ◆ Improved data quality in source systems by establishing a feedback mechanism between source teams and data brokers. ◆ Developed reporting process for Amazon's donations to charities in lieu of disposing to landfills thus reducing compliance vendor bills.

Cable & Wireless Communications | Aug 2018 - Dec 2018

Data Analyst

◆ Analyzed and implemented complex data and business processes to create process maps to implement a customer targeting model for promotions and rewards cycles. Increased the revenues for the last quarter by 30% compared to last financial year. ◆ Partnered with business consultants to implement projects for visualizing customer behavior, trends and identifying KPIs to reduce customer churn by 20%. ◆ Implemented ETL projects using Informatica and RDS to migrate 25 TB data from vendor application to local Redshift storage. ◆ Delivered visibility into customer demographics across 8 countries to develop customized marketing campaigns by reporting on KPIs. ◆ Reduced ETL cost on AWS by 30% with reusable data pipeline design and optimizing around MPP capabilities of AWS Redshift.

Shutterfly, Inc. | Jan 2018 - Aug 2018

Business Intelligence Consultant/Developer

◆ Developed scope, processes and alternatives to optimize fulfillment strategy for the client and third-party sellers. ◆ Guided the users with expertise to select a BI solution between Tableau, Domo and Incorta. Engaged with each vendor and created proofs of concept for the client to choose the tool best suited to the underlying technology stack. ◆ Defined KPIs to show trends for business costs, the volume of products, profits and analyzed competition to provide actionable insights. ◆ Developed ETL pipelines in Informatica to extract data from transactional systems and load it onto redshift for reporting key metrics for evaluating third- party sellers that led to an increase of 30% in order fulfillments. ◆ Reduced run times of Tableau Dashboards by 80% by optimizing SQL queries and implementing Python scripts for data loads.

NYU Stern School of Business | Aug 2017 - Dec 2017

Graduate Teaching Fellow

◆ Tutored Stern students in the course Web and Mobile Application Development. ◆ Helped to formulate a plan to implement technology projects pertaining to different industries. ◆ Graded and helped students understand multiple quizzes and mid-term tests.

Thando's | Jan 2017 - May 2017

Data Analytics Intern

◆ Developed a brand communication and expansion strategy using data analytics for the client new to the US market. ◆ Leveraged a variety of internal data sources to better understand and visualize shopper behaviour and drive value for the client. ◆ Handled complete website migration to an e-commerce solution called Shopify.

Accenture | Dec 2012 - Dec 2015

BI Consultant/Data Analyst

◆ Developed a financial asset data solution for a client bank for portfolio/risk management and trade settlements. ◆ Analyzed the business requirement and created ETL logic to extract data from flat files and relational tables coming from vendors, transform and load data in the data warehouse. ◆ Successfully migrated 15 TB referential data from legacy systems to Informatica in three phases with 99.9% data accuracy. ◆ Defined business and functional requirements of the client to create business rules, data models and ETL data flows. ◆ Delivered multiple client projects gathering, integrating, and analyzing financial data for reporting to end-users for risk mitigation. ◆ Developed SQL queries for ad hoc reporting on portfolios for financial advisors necessary for daily settlements. ◆ Optimized dashboard refresh times by 30% through performance tuning on SQL queries and dashboard visualizations. ◆ Worked with the client team to resolve defects of user acceptance testing and data issues for client handover.

Seasia Infotech | May 2012 - Dec 2012

Data Analyst

◆ Conducted analysis and reporting of inventory turnover, promotions and supply chain optimization for a retail client. ◆ Developed, built and automated dashboards tracking KPIs related to Growth, Engagement and Revenue using R and SQL. ◆ Assisted the Revenue Operations team in providing key stakeholders with actionable insights.

My Education

Take a look at my formal education

Master of Science, Information SystemsNew York University | 2018

Bachelor's degree, Computer ScienceGuru Nanak Dev University | 2012

Create Your Data Portfolio for Free