Summary
Overview
Work History
Education
Skills
Personal Information
Timeline
Generic

Bikash Mohanty

Barcelona

Summary

  • Experienced Data Analytics Engineer with decade's worth of comprehensive development in Data Engineering coupled with Business Analytics.Hands-on Experience in PostgreSQL, Snowflake , AWS, Azure,Python, Dbt , Looker/ Tableau.
  • Identified efficiencies and problem areas within data streams, while communicating needs for projects.
  • Bringing forth the ability to synthesize quantitative data points by building data pipelines to enterprise data lake/warehouse(s).
  • Proven track record of creating Insights & KPI Reports for senior management to assist on their monthly and quarterly audit and compliance reporting.
  • Effective Risk Management of the application modules developed.

Overview

11
11
years of professional experience

Work History

Senior Analytics Engineer

Affirm
07.2022
  • Responsible for creation and maintenance of data models in Snowflake and data pipelines using (Dbt/Five Tran/Snowpipe)
  • Improved data quality significantly by creating alerts by leveraging Dbt's elementary packages
  • Removed obsolete & redundant models and implemented 'DRY' techniques in Dbt & Looker by creating standardized models for KPI metrics, which led to $100K worth annual costs savings in Snowflake
  • Orchestrated complex data pipelines and task launches and created schedules to monitor CI/CD workflows in Airflow
  • Streamlined ETL processes across billions of rows of data which reduced turnaround time workload by 33%
  • Designed and implemented incremental data pipelines to transform and aggregate large datasets, resulting in 25% improvement in processing time and compute costs
  • Analyzed marketing data metrics such as (engagement rate, impressions, Gross rating points, churns Reach, Frequency etc.) using SFMC data in Looker
  • Analyzed data quality by creating SQL post hook tests to proactively identify anomalies and limit data discrepancies by 26%.

Senior Data Engineer

Cognizant Technology Solutions
11.2020 - 07.2022
  • Managed and led migration from SQL Server to SAP BW migration using SSIS and SAP BODS to implement enterprise DWH resulting in annual cost savings of $200K
  • Provided high quality output and explanation of newly proposed data architecture for SAP BW model and proactively identified improvements
  • Maintained Tableau dashboards to visualise metrics and improve decision-making at various levels within Finance Org
  • Created and maintained ETL pipelines on Azure Data studio
  • Analysed large datasets with SQL to identify trends and draw insights, resulting in 29% increase in operational efficiency
  • Managed 3 direct reports and performed Change Management, Stakeholder Management and Program Management.

Data Engineer

Frontiers SA
05.2020 - 08.2020
  • Maintained and optimized DB objects and SP's feeding Data sources
  • Replaced old excel reports with Tableau workbooks which was used by high level management to compare OKRs and KPIs
  • Optimized many time consuming existing SPs' which slashed turn around time by 40%.

Senior Specialist

Merck Sigma Aldrich Chemical India Pvt Ltd
06.2019 - 05.2020
  • Worked with Business & end users to create and enhance existing Tableau reports
  • Optimized & redesigned bulky & slow running portfolio reports thereby reducing turnaround/loading time from 15 sec avg to 3 sec avg
  • Built User KPI dashboards by utilizing Tableau metadata tables in PostgreSQL
  • Optimized ETL processes by enhancing python/R scripts
  • Was responsible for data ingestion and tracking phases of drug trials via Tableau for Covid vaccine being developed by Merck
  • Managed external vendors who were involved in project and provided technical guidance

Senior BI Analyst

Goldstone Technologies (client: Nutanix Inc)
11.2017 - 04.2019
  • Worked with end users to gather business specifications and translated them into analytical solutions
  • Automated many time consuming manual processes which slashed ETA by 30%
  • Generated reports and provided Analytics on Mfg, marketing and Products to Senior management, resulting in improved sales and forecasting
  • Worked with data scientists in tandem to help establish visualize data models (linear Regression),and clustering techniques
  • Worked on Large scale Enterprise data warehouses and managed all phases of data warehouse development life cycle, from gathering requirements to testing, implementation, Reporting and Post Go live support
  • Worked with cross functional teams to establish a data downstream from their applications Salesforce/Netsuite) onto Enterprise warehouse in PostgreSQL which was migrated to Snowflake.

Lead Data Analyst

Fujitsu Consulting India Pvt Ltd
11.2016 - 10.2017
  • Liaised with clients for Requirement Gathering, Analysis, & BI Report demonstrations, thereby achieving high CSAT scores
  • Developed a data ingestion process to automate the transfer of data from multiple sources into SQL Server
  • Used Tableau as a data visualization tool to replace legacy SQL based query reports and automate quarterly business reports
  • Mentored junior developers by organizing brainstorming sessions whenever possible.

Senior Software Engineer (Data Analyst)

Xavient Information Systems
04.2016 - 11.2016
  • Worked in Business Intelligence and created complex dashboards/visualizations for clients in Tableau 9.3 as per business requirements
  • Liaised with cross functional teams to create data downstream from Datorama to Hive
  • Was a part of the Business Intelligence CoE for BI solutions
  • Used Datorama as tool for ingesting data w.r.t digital marketing (Facebook ads, twitter campaigns et al)

Technical Consultant

CSDC India Pvt Ltd
04.2015 - 04.2016
  • Worked with various databases as SQL developer and performed code maintenance & performance tuning
  • Developed and maintained database objects like stored procedures, views, triggers etc
  • Acted as liaison between business and team, while performing roles of Business Analyst, and offering proactive resolutions to client
  • Developed and managed relevant reports, dashboards, & visualisations using tools like Crystal reports XI and SSRS
  • Migrated SSRS reports onto Tableau 9.3.4 as part of updating Client Reports.

Associate Consultant

Wipro Infotech
11.2014 - 03.2015
  • Performed ETL from various external source systems using Informatica 9.1 as part of enterprise DWH
  • Maintained Enterprise Data Warehouse EDW for client
  • Developed analytical reports, dashboards/visualizations for client using SAS VA.

Software engineer

HCL Technologies Ltd
06.2011 - 10.2014
  • Database Developer for Pearson Publishing as client
  • Designed, implemented and maintained database code objects, including stored procedures and views
  • Performed Code Optimization & SQL Performance Tuning, thereby increasing application performance
  • Successful ETL implementation from Sybase to Oracle.

Education

Bachelors (Information Technology) -

VSSUT
Sambalpur, Odisha
05.2011

Skills

  • SQL(MYSQL/Postgres SQL)
  • Snowflake
  • Github
  • ETL(Informatica cloud)
  • Python
  • Amazon AWS(S3, Lambda, Glue,Redshift)
  • Dbt
  • Azure Data factory
  • Looker/Tableau
  • Pyspark
  • Databricks
  • Datorama

Personal Information

  • Date of Birth: 05/31/89
  • Nationality: Indian

Timeline

Senior Analytics Engineer

Affirm
07.2022

Senior Data Engineer

Cognizant Technology Solutions
11.2020 - 07.2022

Data Engineer

Frontiers SA
05.2020 - 08.2020

Senior Specialist

Merck Sigma Aldrich Chemical India Pvt Ltd
06.2019 - 05.2020

Senior BI Analyst

Goldstone Technologies (client: Nutanix Inc)
11.2017 - 04.2019

Lead Data Analyst

Fujitsu Consulting India Pvt Ltd
11.2016 - 10.2017

Senior Software Engineer (Data Analyst)

Xavient Information Systems
04.2016 - 11.2016

Technical Consultant

CSDC India Pvt Ltd
04.2015 - 04.2016

Associate Consultant

Wipro Infotech
11.2014 - 03.2015

Software engineer

HCL Technologies Ltd
06.2011 - 10.2014

Bachelors (Information Technology) -

VSSUT

Similar Profiles

CREATE PROFILE
Bikash Mohanty