Subholina Deb
Azure Data Engineer
Kolkata
Summary
Data Engineer || Microsoft Certified Azure Data Engineer || Databricks Certified Engineering associate (Data Lake House) || Architecture & Strategy Professional at Lexmark
Professional Experience: 13.3 yrs
Relevant Experience: 5 years
Microsoft Certificates : DP 900 (Azure Data fundamental), DP 200 & DP 201 (Azure Data Engineer)
Databricks Certificates : Lakehouse fundamentals,Data Engineer Associate
Overview
13
13
years of professional experience
9
9
Certifications
Work History
Architecture & strategy professional
Lexmark International Pvt Ltd
2 2022 - Current
- Working on implementing the data lake house in azure databricks Using PySpark and Spark SQL, hands on experience in Data analytics with Databricks, Databricks Workspace, Managing Databricks Notebooks for Bronze/Silver/Gold layer, Delta Lake with Python, Delta Lake with Spark SQL, Data Flow Orchestration Though Databricks jobs or Workflows, data governance through Unity Catalog, Working actively on SQL endpoint or warehouse in databricks for data validation activities
- Good Understanding in Spark Architecture in Databricks, Managing All purpose and Job Clusters in Databricks
- Following the CI/CD process through Azure Devops in Azure Databricks By creating Local Repo and branch, making the code changes, Doing Push & Commit to Azure Repo, Creating Pull request, Merging the changes Into Main Brach from the local branch etc
- Currently working on the Auto Loader in Databricks
- Working on multiple indigestions from various on-premises sources like SQL Server, Oracle, SAP BW Open Hub, and Cloud sources like SharePoint Through Azure Data Factory
- Following CI/CD process for indigestions through ADF
- Following Agile methodology for completing of deliverables through The tool Service Now
- Communicating with business stake holders to understand the Requirements and leading the delivery process within timeline.
Technical Manager – Data Analytics & BI
Embee Software Pvt Ltd
02.2016 - 02.2022
- Worked on Industries : Retail, Trading, Manufacturing, Airlines, Health Care, Electrical Power Generation and Export, Jewelry, Entertainment, Agriculture etc Profile & responsibilities : + Gathering Customer Requirement, mapping requirement into Project Scope, Designing the implementation plan as per the scope, Capturing the CRs (Change Requests) in between the project during UAT, Acting as a SPOC for customers during the project execution, ensuring seamless project delivery within the defined deadline, Executing the deliverables with the download team
- Working with systems vendors and internal technical support teams to gain access to business data, defining the technical requirements for data integration, and ensuring successful set up and testing of integrations
- Managing a team of 6-10 technical resources on the platform of BI and Analytics + Handling the BI technical team and all projects they undertake, analyze briefs, write progress reports, identify risks, and develop work schedules
- Working with the team,helping the team mates to solve critical technical challenges + Working in Business Intelligence platform with the Knowledge in Data Warehousing (DW) using MSBI Technology (SSIS & SSAS) both in on prem and Azure Cloud (Azure Data Factory, Blob, Azure Data Lake, Azure SQL DB, Azure Synapse, Azure Analysis Services, Automation Account, Runbook)
- Developing Power BI, MS Excel Pivot Tables, Power Pivot Reports and Dashboards
- Managing enhancements and ensuring their successful completion and the realization of value
- Providing support and resolving problems with the data warehouse load, semantic model and reports
- Conducting technical training to the stakeholders of customer if needed
Software Engineer (MSBI)
Data Core (India) Pvt Ltd
09.2015 - 02.2016
- Worked on ETL Architecture, Control Flow, Transaction and Data Flows in SQL Server Integration Services (SSIS),Involved in creating packages where data is driven using odbc connection from Hadoop(Hive Big Data Storage),Developed Stored Procedures, Views, Functions, and Triggers using SQL Server2014,Worked in query optimization, indexes, database design etc,Worked in Multi Dimensional Data Modeling, Cube development and manipulations in SQL Server Analysis Services (SSAS) from which reporting was done,Reporting was done with Dundas (fundamental knowledge)
Technical Consultant
Embee Software Pvt Ltd
11.2013 - 09.2015
- Developed Stored Procedures, Views, Functions, and Triggers using SQL Server 2005 and 2008/R2,query optimization, indexes, database design etc,worked on ETL Architecture, Control Flow, Transaction and Data Flows in SQL Server Integration Services (SSIS)
- Worked in importing data from different data source like MS-Access, Excel, XML file and CSV file,creating Jobs, Alerts, SQL Mail Agent, and Scheduled SSIS Packages.MDX queries (SSAS)
- Created hierarchy, calculated members, actions, partitions, KPIs, aggregations etc in SSAS for SAP B1 modules,experiencing in Crystal Reporting.worked in scheduling and deploying reports,creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages,Deployed sharepoint dashboard reporting using excel service and power performance
Software Developer
EDominer Systems Pvt Ltd
01.2012 - 11.2013
- Responsible for entire coding by doing software analysis (Front end is ASP.net,Back end is SQL Server),bug fixing in various modules of ERP software Worked In: Helpdesk, Emailing System, Human Resource, Configuration , Trading, Security, Transport, CRM, Export, Retail,Production,Inventory Implemented Barcode printing utility Program for TSC Series Barcode Printers as a windows application using C# and the .net framework compatible TSC Library dll Implemented Google Calendar API in the CRM Interaction Module,implemented a scheduler for system generated emailing and notifications as a windows application using c# Implemented a New Client Database creation and up gradation system in ASP.Net (By using VB.Net),done .Net framework up gradation of the total ERP Application from 2.0 version to 4.0 and handled the IIS issues Developed MS Office Outlook AddIn For Approve and Decline Mails (By Selecting The Mail and Then Clicking On The Customized Buttons) and Recorded The Informations accordingly Into A Specific File Or Database in VB.Net,Developed SQL Server Analysis Services Project (In SQL Server 2008) and added Three Cubes Sales,Purchase And Inventory and Their Dimensions Accordingly.It Is Deployed Successfully and The Records Can Be Displayed In MS Excel Pivot Tables
ASP.Net Developer
Rtech Solutions
03.2011 - 12.2011
- Involved in all aspects of the software lifecycle from analysis,design,development and testing of software prior to installation within a Microsoft development environment, specialised in ASP.Net(C#) and SQL Server technologies.
Education
MCA -
Sikkim Manipal University
Bachelor of science chemistry hons - undefined
Calcutta University
Higher secondary -
Madhyamik - undefined
Skills
Azure Data Tech Stack (Azure Data Bricks, Azure Data Factory, Azure Data Lake,Azure SQL)
SQL Query and Performance Tuning
Azure Analysis Services
SSIS, Power BI
SSAS
Certification
C & C++, Brainware Academy, 2007
Accomplishments
- Secured A+ Grade at All India Science Talent Research Organized By West Bengal State Council
- Secured 80% Grade at Annual Dance Exam in the 1st, 2nd and 3rd year
- Secured 85% grade in Sanskrit, Biology at 8th standard, 85% grade in Biology, Geography, Math at 9th standard and 80% grade in Biology, Physical Science, Geography, Math at 10th standard of school level
- Became Highest Scorer in Second, Fourth, Fifth and Sixth Semesters of MCA
- Became Winner of the Azure Track Session Organized by Microsoft
- Got two manager appreciation awards for 2022 and 2023 in Lexmark International Pvt Ltd
Secondary Skill Sets
Blob Storage, Synapse Analytics, Synapse Workspace, PySpark and Spark SQL, Delta Lake House, MDX/DAX, Power Query/M Query
Personal Information
- Date of Birth: 09/05/1985
- Gender: Female
- Nationality: Indian
- Marital Status: Married
Disclaimer
I here by declare that the above-furnished particulars are true to best of my knowledge and belief.
Timeline
Technical Manager – Data Analytics & BI
Embee Software Pvt Ltd
02.2016 - 02.2022
Software Engineer (MSBI)
Data Core (India) Pvt Ltd
09.2015 - 02.2016
Technical Consultant
Embee Software Pvt Ltd
11.2013 - 09.2015
Software Developer
EDominer Systems Pvt Ltd
01.2012 - 11.2013
ASP.Net Developer
Rtech Solutions
03.2011 - 12.2011
Architecture & strategy professional
Lexmark International Pvt Ltd
2 2022 - Current
MCA -
Sikkim Manipal University
Bachelor of science chemistry hons - undefined
Calcutta University
Higher secondary -
Madhyamik - undefined
Similar Profiles
PALLABI SAHAPALLABI SAHA
SOFTWARE TESTING SPECIALIST at LEXMARK INTERNATIONAL INDIA PVT LTDSOFTWARE TESTING SPECIALIST at LEXMARK INTERNATIONAL INDIA PVT LTD
Niloy MukherjeeNiloy Mukherjee
PP-MM Consultant at Lexmark International, IncPP-MM Consultant at Lexmark International, Inc
Jeffrey EhlertJeffrey Ehlert
Global Sourcing Process Improvement and Strategy Manager, Investor Relations Manager at Lexmark International, Inc.Global Sourcing Process Improvement and Strategy Manager, Investor Relations Manager at Lexmark International, Inc.
AVIJIT LAHAAVIJIT LAHA
Test Lead at HCL Technologies LtdTest Lead at HCL Technologies Ltd
Banasree DasBanasree Das
Sales Manager at Swarn Wellness Pvt. Ltd.Sales Manager at Swarn Wellness Pvt. Ltd.