Siddhartha Sarkar

Dedicated professional with expertise in database management and ETL development. Excelled in implementing efficient data loading processes utilizing SQL Loader scripts, ensuring data accuracy through meticulous error handling.

• Handled Direct Communication with the clients and External Teams.
• Implemented a robust data loading process using SQL Loader scripts for flat data files, reducing data loading time by 40% and increasing data accuracy by 30%.
• Created staging tables based on mapping documents for subsequent processing stages.
• Developed SQL scripts for Chain of Trust COT process to ensure data integrity.
• Conducted meticulous count matching and error handling for data accuracy.
• Developed comprehensive SQL scripts for data loading, utilising joins from multiple tables.
• Analysed business requirements, created procedures, queries, DDL, DML in Oracle database, and managed ETL jobs for daily data processing, while providing support and troubleshooting during testing and production phases.
• Involved in producing visually stunning dashboards with cleaned data for the client.

Consistently delivers high-quality results and proactively improves processes to effectively meet and exceed project objectives

• Created interactive UI Dashboard report to show different Seller's KPIs in Power BI report to help clients for better business decisions
• Understand business domain and client requirements by asking open questions, blockers and issues in client calls
• Worked on different Microsoft technologies to create and deliver the project with utmost quality
• Analyzed and Implemented workflows for client during platform migration
• Deliver the workflows with utmost quality preserving the predefined structure
• Mapped tables and created schema during migration phase
• Created monthly and annual excel and power Bi reports for client which led to data driven business decision
• Utilized Power Query to clean, process and Transform data
• Created Excel automation using record script to automate e-mail and data transformation
• Used pivot tables to generate more data-oriented reports
• Handled big data transformation in SQL, utilizing joints, CTE's, Window function and DML
• Created relations within the database between different table to define the flow of Data

• Developed and maintained user-facing webpages using HTML, CSS, JavaScript and jQuery.
• Created custom responsive designs that optimized the website layout for various devices.
• Designed and implemented interactive user interfaces for websites and applications.
• Tested cross-browser compatibility of web applications in multiple browsers and operating systems.
• Debugged existing code to identify and fix bugs or performance issues.
• Monitored project progress on a daily basis through JIRA bug tracking system.
• Documented test results in defect tracking tools such as JIRA, Bugzilla.
• Designed interactive prototypes using Adobe XD or similar prototyping tools.