Bhumika Lalchandani

Data Engineer

Bengaluru, Karnataka, India5 yrs 7 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Expert in Data Engineering with strong ETL skills.
Proven track record in optimizing data pipelines.
Successful development of a high-traffic marketplace website.

Stackforce AI infers this person is a Data Engineer with expertise in Fintech and SaaS industries.

Contact

blalchandani357@gmail.com LinkedIn

Skills

Core Skills

Data EngineeringEtlWeb Development

Other Skills

AWS GlueAgile MethodologiesAndroid DevelopmentApache KafkaAzure DatabricksBig Data AnalyticsBusiness IntelligenceCSSCloud ComputingData ScienceData StructuresData WarehousingFeature EngineeringGitlabHTML

About

Hi, I’m Bhumika, a Data Engineer with a demonstrated history of working in Finance, Sales, Healthcare domains. A professional with technical and business handling skills who focuses on details and takes responsibility of E2E project development and delivery. Have worked on multiple projects involving Data warehousing and Business Intelligence solutions using ETL methodologies. Self-motivated professional with strong communication skills. I am an avid learner who loves to manage technology, lead teams and learn new technologies. Core Competencies: Programming Languages: Python, Java, SQL, Shell Scripting (Linux), Pyspark AWS Services: AWS Glue, S3, Lambda, Redshift, Amazon EC2, EMR, SNS, CloudWatch, Airflow Frameworks/ETL Tools: Snowflake, Databricks Reporting/Dashboarding: Tableau, Excel Utilities: JIRA, Confluence, Git-Github, GitLab, Postman Can reach out me or feel free to connect at ✉️: blalchandani1157@gmail.com Would be happy to respond!

Experience

Trinity life sciences

Data Engineer

Jul 2024 – Present · 1 yr 8 mos · Bengaluru, Karnataka, India · Hybrid

Topmate.io

Mentor

Jun 2024 – Present · 1 yr 9 mos

Infosys

2 roles

Digital Specialist Engineer (Data)

Jul 2022 – Jul 2024 · 2 yrs

Client:- Apple Inc
Responsibilities:
➤ Executed the implementation of file-based interfaces for discount pricing data across different regions, ensured seamless data flow from SAP to EDW
➤ Revamped the Batch ETL Pipeline to capture fields from source tables mapped to stage tables, business views for incremental loading.
➤ Devised a script integrating booking and billing procedures, leveraged strategic joins and dimensional data modeling to incorporate direct, semi-derived, and complex columns from dimension and fact tables
➤ Optimized long-running procedures’ performance by using Snowflake optimisation techniques to achieve cost savings, yielding 30% efficiency boost
➤ Enhanced Tableau dashboards with additional columns across five interfaces for Email alerts to teams. Integrated inbound activities from SAP HANA System into Enterprise datawarehouse
➤ Migrated data from onprem Teradata procedures to the Snowflake within the Finance track. Tested data validation across different environments of Teradata and Snowflake as part of it.
➤ Refactored spark jobs running in EMR EC2 cluster to serverless AWS Glue for transformation, which improved speed by 15%
➤ Applied CDC(Change Data Capture) and SCD(Slowly Changing Dimension) concepts to track historical
data changes.
➤ Documented technical concepts for internal platforms and mentored junior team members

SQLSnowflakeTableauAWS GlueData WarehousingETL+1

Data Engineer

Apr 2022 – Jul 2024 · 2 yrs 3 mos

Aligntogether solutions

Systems Analyst

Dec 2021 – May 2022 · 5 mos · Bhopal, Madhya Pradesh, India

Developed the Aligntogether marketplace website, focused on NextJS, ReactJS, HTML, CSS converted Adobe XD designs into functional UI components.Worked in collaborative startup team enviornment where website accumulated over 20,000 views and more than 1000 signups.

NextJSReactJSHTMLCSSWeb Development