Shamik Chakraborty

SAP BI/BW Development and Support: (Project-BAU)

• Developed, maintained, and enhanced SAP Business Warehouse (BW) objects including Info Objects, Info Cubes, Data Store Objects (DSOs), and Multi Providers.
• Designed and implemented data extraction, transformation, and loading (ETL) processes using SAP BW.
• Created and optimized BW data models to improve data retrieval and reporting performance.
• Developed complex BEx queries and workbooks to support business reporting requirements.
• Provided technical support and troubleshooting for BW systems, ensuring high availability and performance.
• Collaborated with business stakeholders to gather requirements and translate them into technical specifications.

S/4HANA Migration: (Project-S4 Go Live, ended on April,24)

• Actively participated in migration of ECC systems to S/4HANA.
• Conducted system analysis and identified potential migration issues.
• Assisted in transformation of existing BW objects to be compatible with S/4HANA.
• Worked on conversion of data models and ensured seamless data integration.
• Performed rigorous testing and validation post-migration to ensure data integrity and system functionality.

Employee Skill Enhancement Program:

• Completed courses in Python, SQL, and Alteryx to enhance technical skills and contribute to diverse projects.
• Applies new skills in Python for data analysis and automation tasks within SAP BW environments.
• Utilized SQL for advanced data querying and manipulation, enhancing data management capabilities.
• Leverage Alteryx for data blending, advanced analytics, and process automation.

Alteryx Developer (Secondary Project, 6 months): (Project-CYRUS, ended on Sep,23)

• Developed and maintained workflows in Alteryx to streamline data processing and reporting.
• Integrated Alteryx workflows with existing systems to automate repetitive data tasks and improve efficiency.
• Collaborated with cross-functional teams to understand data requirements and deliver Alteryx-based solutions.
• Conducted training sessions for team members on Alteryx functionalities and best practices.

Additional Responsibilities:

• Participated in regular code reviews and knowledge sharing sessions to promote best practices.
• Contributed to preparation of technical documentation and user manuals.
• Engaged in continuous learning and upskilling to stay current with latest SAP and data analytics technologies

Data Analysis and Reporting:

• Utilized Excel and Power BI to create, maintain, and enhance business intelligence reports and dashboards.
• Developed interactive and visually appealing Power BI reports to support decision-making processes.
• Conducted data analysis using Excel, including advanced functions, pivot tables, and data visualization techniques.

Microsoft SQL Server:

• Write complex SQL queries to extract, transform, and load (ETL) data from various sources into analytical models.
• Optimized SQL queries to improve data retrieval efficiency and report performance.
• Managed and maintained SQL Server databases, ensuring data integrity and availability.

Azure Data Lake:

• Worked with Azure Data Lake to store and manage large volumes of structured and unstructured data.
• Developed and executed data ingestion pipelines to load data into Azure Data Lake for further analysis.
• Implemented data governance and security measures within Azure Data Lake to protect sensitive information.

Collaboration and Stakeholder Engagement:

• Collaborated with cross-functional teams to gather business requirements and translate them into technical specifications.
• Worked closely with business users to understand their reporting needs and deliver tailored BI solutions.
• Provided training and support to end-users on Power BI and Excel functionalities.

Process Improvement:

• Identified and implemented process improvements to enhance data analysis and reporting efficiency.
• Automated repetitive data tasks using Excel macros and SQL scripts, reducing manual effort and minimizing errors.
• Monitored and ensured accuracy and consistency of data across various reporting tools.

Additional Responsibilities:

• Participated in regular team meetings and knowledge sharing sessions to stay updated with latest BI trends and technologies.
• Contributed to preparation of technical documentation and user guides.
• Engaged in continuous learning and upskilling to enhance proficiency in Microsoft analytical tools and cloud platforms.