Shivam Kumar Jaiswal

Project - Central Board of Indirect taxes and Customs

• Designed and implemented SQL queries for creating 3 different Live dashboards for different modules such as Import and Export and IGM.
• Taking requirements from client, analyzing it and implementing it using feasible and effective way.
• Built databases, table structures and different objects for web applications.
• Conducted testing, performance tuning, and optimization of Data Warehouse and data pipelines to deliver high-quality, reliable, and efficient solutions.
• Increased efficiency of data fetching by approximately 30% using query optimization and indexing.

Project - Analytics and Insight

• Generated insights and identified potential machine failure causes significantly reduced downtime from 10% to 2%.
• Utilized Hive and Py spark to craft real-time reports and dynamic dashboards from vast datasets, enabling active analysis and informed decision-making.
• Identified, analyzed and interpreted trends or patterns in complex data sets for different testing machines to analyze failure trends and reduced Defect rate from 200 ppm to 30ppm.
• Developed complex and customized Stored Procedures and queries for implementing business logic and process in backend.
• Conducted comprehensive case studies to develop new models for predicting market responses, tailored to specific regions. These models empower data-driven insights and strategies for effective market targeting and expansion.

Project - MES (Manufacturing Execution System)

• Directed MES project with 24 -person team
• Analyzed business reports for prompt communication, follow-up and ongoing support.
• Developed complex and customized Stored Procedures and queries for implementing business logic and process in backend.
• Work Closely with business teams to implement efficient solution to meet their needs.
• Designed and implemented SQL queries for reporting and complex solution development.
• Resolved complex business issues, proposing long-term solutions to avoid repeat problems.

Project - MES (Manufacturing Execution System)

• Developed multiple stored procedures to generate data driven dashboard and reduced manual analysis by 80%.
• Perform SQL Queries using Joins, Sub Queries and correlated sub-Queries to retrieve data from database.
• Supported projects enabling delivery efficiencies and technical resolution.
• Resolved complex business issues, proposing long-term solutions to avoid repeat problems in more than 10 new mobile phone models.
• Developed custom database objects, stored procedures and delivered application support.