Siddhartha Sarkar

Dedicated professional with expertise in product improvement, database management, and ETL development.

Took care of chalking pain point for the client and responsible for Identified gaps in existing products, services, and processes through market research and analysis. Excelled in implementing efficient data loading processes utilizing SQL Loader scripts, ensuring data accuracy through meticulous error handling.

• Facilitated clear communication with clients and external teams to gather requirements and resolve issues.
• Analyzed BRD, created frd, created and mapped workflows to the new platform over the existing UI during data migration.
• Responsible for timely implementation of workflows as per the BRD
• Analyzed customer feedback and data to identify areas of improvement for the product.
• Tracked development health and velocity using agile tools to mitigate risks.
• Measured core success metrics to improve future product launch phases.
• Initiated discussion with production department to improve tools, workflow and analytical processes.
• Created detailed reports for management on product performance and user experience for client.
• Identified gaps in existing products, services, and processes through market research and analysis, which led to improvement in the existing product, causing a significant increase in customer acquisition.
• Created detailed reports for management on product performance and user experience.
• Recommended process improvements based on insights gained from data analysis.
• Tested prototypes of new products before launch by conducting usability studies with target users.
• Provided support for stakeholders throughout the entire product lifecycle from conception through launch.
• Optimized data loading processes, significantly enhancing efficiency and accuracy.
• 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.
• Crafted advanced SQL scripts to streamline data integration from diverse sources.
• Analyzed 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

• Designed and implemented engaging webpages, improving user experience and interface responsiveness.
• 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.