Summary
Overview
Work History
Education
Skills
Accomplishments
Languages
Certification
Timeline
Generic

Barnali Mohapatra

SURREY,BC

Summary

Professional individual , enthusiastic in learning different technologies and methodologies. Possesses strong data mining,analytical skills, problem-solving abilities, and deep understanding of database technologies and systems. Loves collaborating with different teams for best project delivery and success of the business.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Data Engineer

Clearly, Essilor Group
08.2018 - 03.2024
  • Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.
  • Migrated legacy systems to AWS , improving performance and scalability while minimizing business disruption.
  • Evaluated various tools, technologies, and best practices for potential adoption in the company''s data engineering processes.
  • Collaborated with cross-functional teams and gathering requirements for seamless integration of data sources into the company's ecommerce business data ecosystem.
  • Integrated data from CRM ,ERP and other datasources (Marketing and Email Data ) for various analysis like customer retention , demand sales, product margin, supply chain, retail traffic and sale, etc
  • Designed curated data models to support business intelligence initiatives and self-service reporting needs.
  • Developed custom algorithms for advanced analytics, driving actionable insights from large datasets.
  • Increased efficiency of data-driven decision making by creating user-friendly dashboards that enable quick access to key metrics.
  • Automated routine tasks using Python scripts/AWS Step Function, increasing team productivity and reducing manual errors.
  • Implemented real-time data processing solutions for ,timely decision-making and improved end-user's experience .
  • Provided technical guidance and mentorship to team members within the organization.
  • Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.


System Engineer(SAS Programmer)

Tata Consultancy Services
04.2014 - 06.2017
  • Streamlined data analysis processes for credit card payment due date and listing delinquency customers by developing and implementing efficient SAS programs, resulting in increased productivity.
  • Optimized data quality and accuracy by validating, cleaning, and managing large data sets through meticulous programming techniques.
  • Enhanced project efficiency with the development of reusable SAS macros.
  • Collaborated closely with cross-functional teams to gather requirements, analyze data, and present findings in a clear and concise manner.


Assistant System Engineer

Tata Consultancy Services
09.2012 - 04.2014
  • Participated in IT projects that improved overall company processes including implementing a ticketing system for better issue tracking.
  • Increased response time for urgent issues by prioritizing tickets based on severity levels.
  • Worked with various departments on integrating new processes for software and manual usage.
  • Provided end-user support, resolving complex technical problems quickly and effectively.
  • Collaborated with cross-functional teams to ensure seamless integration of new technology solutions into existing infrastructure.
  • Optimized testing processes by identifying bottlenecks and implementing improvements in test automation frameworks.

Education

Master of Computer Application - Computer Applications Development

Manipal Institute of Technology
Manipal,Karnataka,India
05.2012

Bachelor of Science - Computer Science

St. Mira's College For Girls
Pune,Maharastra,India
06.2009

Skills

  • Data Curating
  • Data Modeling
  • Data Pipeline Design/ETL
  • Data Analysis
  • Report Development(Microsoft Excel with power query/AWS QuickSight/PowerBI)
  • Data Mining
  • Data Validation
  • SQL Expertise
  • Python/PySpark Programming
  • Pipeline Service : Upsolver
  • AWS Services ( Amazon Redshift, Athena,AWS Lambda,AWS Glue, Step Function , Event Bridge, S3 Bucket,Secret Manager,Data migration Services )
  • SAS
  • API (REST API)

Accomplishments

  • Recognized by Amazon AWS team for doing beta test and suggesting improvement on AWS Glue Studio in year 2021
  • Recognized twice MVP in Clearly

Languages

English
Professional Working

Certification

Certified in Base and Advanced SAS 9

Timeline

Data Engineer

Clearly, Essilor Group
08.2018 - 03.2024

System Engineer(SAS Programmer)

Tata Consultancy Services
04.2014 - 06.2017

Assistant System Engineer

Tata Consultancy Services
09.2012 - 04.2014

Master of Computer Application - Computer Applications Development

Manipal Institute of Technology

Bachelor of Science - Computer Science

St. Mira's College For Girls
Barnali Mohapatra