Data modelling using SAP BW, SAP Data Service, Numerical analysis using MATLAB & Python, Data Science using Python Electrical Circuit analysis and implementation using semiconductor devices, Astrophysics and Space Science
SUMIT SARKAR
Kolkata
Summary
Results-oriented SAP Specialist with expertise in data warehousing, data modeling, and ETL processes. Delivers innovative solutions to complex challenges, ensuring effective data integration and optimized reporting through strategic collaboration. Demonstrates strong analytical skills and adaptability in fast-paced environments, contributing to successful project outcomes.
Overview
4
4
years of professional experience
Work History
Data-engineer
Cognizant Technologies Solutions
Kolkata, India
02.2022 - Current
- Designed scalable data architecture solutions to support evolving business needs and analytics demands.
- Developed and optimized ETL pipelines to enhance data processing efficiency.
- Utilized SQL and Python for data extraction, transformation, and loading tasks.
- Implemented data extraction processes from SAP ERP systems to streamline reporting efficiency.
- Implemented data quality checks, ensuring accuracy and consistency across datasets.
- Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
- Collaborated with cross-functional teams to identify data requirements and improve analytics capabilities.
- Led initiatives to automate reporting processes, reducing manual effort and increasing productivity.
- Increased process automation, reducing manual efforts through the creation of advanced ABAP routines in transformations and DTPs.
- Analyzed system performance metrics to identify areas for improvement and enhance data integrity.
- Mentored junior team members on best practices in data engineering and project methodologies.
Education
Bachelor of Technology - Electronics & Communication
Institute of Radio Physics And Electronics, University of Calcutta
Kolkata, India08-2021
Bachelor of Science - Physics Honours
Asutosh College, University of Calcutta
Kolkata, India06-2018
I.S.C. (Higher Secondary) - Science
Grace Ling Liang English School (CISCE)
Kolkata, India05-2015
I.C.S.E. (Secondary) - Science
Grace Ling Liang English School (CISCE)
Kolkata, India05-2013
Skills
- SAP HANA modeling
- Data integration skills
- SAP BW expertise
- Data architecture development
- Extracting data from BW systems
- SAP HANA modeling
- BEx Query designer & performance optimiser
- Understanding delta mechanisms
- Designing composite provider solutions
- Optimization of query execution
- Data visualization techniques
- Proficient in SQL and database management
- Python for data engineering
- Data analysis techniques
- Data interpretation
- Data-driven insights
- Understanding of data warehousing
- Process chain management
- Data source refinement
- SAP Analytics Cloud
- Big data technologies
- Data transfer techniques
- SAP material master management
- Big data technologies
Interests
PROFESSIONAL EXPERIENCE
- Working in BW project & completed the Hands-on SAP BW & HANA as a part of project end to end activities. Data Migration from SAP ECC (PEP) system to S/4 system. Data Modelling & Analysis using BW/4HANA Objects, CDS view extractor, creation of BEx Query to generate report as per user requirement, work with Calculation View in HDB.
- Tools used: SAP GUI, HANA Studio, BEX Query Analyzer, AFO in Excel.
- Project activities & task done: Created & enhanced Info provider (ADSO, Composite provider), Info Objects and transformations (Source to Target) from Data source to various layers in data flow. Implemented Includes in routines inside transformation to use logics and lookup while loading data from source to target. Fix data failure issue as applicable.
- Perform BW Object & Report testing in Quality environment in ALM tool and Data Validation for various target objects and queries. Created & monitored Process Chain and resolved errors. Also worked in JIRA for dashboard upgradation.
- Worked on IT Service tools to create Service Order, Incident, Change Document, Change Request to the concern team as per requirement. Also created and documented functional & design specification document with technical changes done in the system for various application.
- Basic overview of SQL, SAP and Database. SAP Analytics Data Management Track using SAP BODS. ETL process and Data Migration using SAP BODS. SAP Data Service Error handling & Recovery Management, Information Steward. Successfully completed the training program on SAP-Analytics with 89% score.
- Completed SAP ABAP Programming – Online training as apart of project technology.
- SAPBW4HANA 2.0 SP07 Masterclass | Hands ON Training.
- Complete Introduction to Microsoft Power BI, Master Microsoft Excel Macros and Excel VBA, MS Office-Advanced-Efficiency training.
- SQL Programming Basics, SAP Data-Service (BODS).
- SAP Quality Management, Sales Distribution and Material Management.
- SAP ABAP Programming.
- Online Summer School on Advances in Signal Processing and Machine Learning organized by Department of Electronics Science University of Delhi and NASI, IEEE.
- Online Short-Term Course on Python for Machine Learning from National Institute of Technology Warangal.
- Conference on Deployable AI Robert Bosch Centre for Data Science and Artificial Intelligence, Indian Institute of Technology Madras.
- C.K.M.M. Summer Workshop in physics organized by S.N. Bose National Centre for Basic Sciences.
- Presenting my project work “Calculating Dark Current and Photo Current in Graphene Photodetector” in National Level IEEE Project Competition.
- MATLAB Project Course on Massive MIMO, Cooperative Communication and Cognitive Radio for 5G in Visakhapatnam organized by IIT Kanpur.
- Online course on “Earth Observation for Carbon Cycle Studies” conducted by IIRS-ISRO.
- Workshop on Innovative Experiments organized by Department of Physics, Asutosh College in collaboration with UGC-DAE.
- Summer School Program organized by Indian Institute of Astrophysics.
- International Summer School on “The Interstellar Medium of Galaxies, from the Epoch of Reionization to the Milky Way”.
CONTACT
- PHONE: 9874318967
- EMAIL: sarkarsumit2929@gmail.com
JOURNAL PUBLICATIONS
P. Chattopadhyay, S. Sarkar, S. Das, “Practical Strategy for Efficient Crowd Management During Covid-19 Pandemic”, International Journal of Engineering Research & Technology, Vol. 11, pp. 19-21, 2022.
AWARDS
2016 Top 3 in Student-Youth Science Fair 2016 Kolkata District and qualified for state level of Science Fair 2016., 2021 1st Prize in Webinar and lecture competition organized by IEEE Photonics Society Kolkata Chapter., 2021 Top 3 in Co-Vigilance-PAN India Contest organized by IEEE AP-MTS joint Student Branch along with IEEE AP-S SIGHT Committee.
Timeline
Data-engineer
Cognizant Technologies Solutions
02.2022 - Current
Bachelor of Technology - Electronics & Communication
Institute of Radio Physics And Electronics, University of Calcutta
Bachelor of Science - Physics Honours
Asutosh College, University of Calcutta
I.S.C. (Higher Secondary) - Science
Grace Ling Liang English School (CISCE)
I.C.S.E. (Secondary) - Science
Grace Ling Liang English School (CISCE)