Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic
Shobhit Singh

Shobhit Singh

Greater Noida

Summary

Results-driven SQL Developer and Data Analyst with 5 years of experience specializing in designing, developing, and optimizing data solutions and financial reporting systems. Proficient in leveraging SQL, data modeling, and advanced analytics to deliver actionable insights and drive strategic decision-making. Adept at collaborating with cross-functional teams to understand business requirements and translate them into technical solutions. Proven track record of enhancing data accuracy, automating reporting processes, and improving performance through effective query optimization and data integration techniques. Experienced in using tools like SQL Server, SSRS, Power BI, and Excel to deliver high-quality, reliable, and timely data-driven solutions. SQL Developer with Number years of progressive experience in System, databases and application programming. Dedicated to building customized technical solutions in alignment with operational needs and objectives. Critical thinker, analyst and problem solver known for continuous delivery of quality products across diverse business environments.

Overview

6
6
years of professional experience

Work History

SQL Developer

INFOSYS BPB
05.2024 - Current
  • Developed and optimized complex SQL queries for accurate and timely financial reporting, enhancing report generation efficiency and reliability
  • Designed and managed comprehensive data models and ETL processes to maintain the integrity and consistency of financial data across multiple reporting platforms
  • Collaborated with finance teams to understand reporting requirements, translating business needs into technical specifications to deliver tailored reporting solutions that aid strategic decision-making
  • Applied performance tuning and query optimization techniques, achieving a 30% reduction in report processing times and improving overall system performance
  • Automated financial reports and dashboards using ART (Aladin Report studio), ACR (Aladin Client Reporting) reducing manual data entry and report generation time by 40%
  • Conducted rigorous data analysis and validation to ensure data accuracy and compliance with financial regulations, enhancing audit readiness and data quality

Data Analyst

BT GLOBAL SERVICES
03.2019 - 04.2024
  • Identified and reported inventory discrepancies, resulting in improved inventory management
  • Monitored inventory levels to ensure product availability and accuracy of inventory records
  • Created a business case to justify a major capital investment and presented it to senior management for approval
  • Developed a reporting system that provided real-time insights into customer satisfaction and product performance
  • Collaborated with cross-functional teams on projects to ensure alignment of objectives and outcomes
  • Analyzed customer feedback to identify common trends and develop recommendations for improvement
  • Created an automated system to monitor customer data and alert stakeholders to potential issues in a timely manner
  • Conducted market research to identify customer needs and develop strategies to meet them
  • Wrote, maintained, and executed SQL queries to validate the integrity of the database
  • Optimized database performance by creating and tuning stored procedures and SQL queries
  • Used data analysis tools to identify trends and anomalies in financial data
  • Resolved data discrepancies and anomalies by performing complex data analysis
  • Created an automated data pipeline that reduced data processing time by X%, allowing for faster analysis and decision-making
  • Implemented an inventory tracking system, resulting in improved asset management and cost savings
  • Implemented a system for inventory management and tracking of IT assets, resulting in improved asset management and cost savings
  • Developed and implemented an inventory system for tracking hardware and software, resulting in improved asset management

Education

Bachelor of Technology - Computer Science

10.2018

Skills

  • Finance Reporting
  • SQL Developer
  • Data Modeling
  • Business Intelligence
  • Performance Improvements
  • Database Development
  • Stake Holder Management
  • RDMS Development and SQL
  • Data Validation
  • Report Writing
  • Business Needs Analysis
  • Technical Analysis
  • Data Analysis
  • Tableau
  • Comparative Analysis
  • Power BI
  • Data Visualization
  • Aladin Report Studio
  • Aladin Client Reporting
  • SQL development

Projects

Finance report development, Blackrock, 05/01/24 - Present, Generate finance reports using SQL queries and visualizing through client tools., Using SQL create multiple column by using multiple filter, multiple Case statement, multiple calculation and creating final table as per the given logical document., Creating multiple report on Finance, Attribution, Client invoicing, Accounting, Portfolio Management and Insurance., Once report is created then to visualize it by creating table, Text, Chart, Profile., Creating final report using different template including multiple Table, Chart and Graph and publishing it. Inventory Management, British Airways, 04/01/19 - 03/31/21, Led a project to improve inventory accuracy by 95% by implementing a new inventory counting system., Developed and implemented a new inventory training program for all warehouse employees, which resulted in a 50% reduction in inventory errors., Worked with vendors to improve the quality of incoming shipments, which reduced inventory discrepancies by 25%. Dashboard Creation, NBS, Nestle, 04/01/21 - 04/30/24, Led a team of developers to create a new Power BI reporting system that reduced reporting time by 50%., Developed and implemented a Power BI dashboard to track customer churn, which helped the company reduce churn by 10%., Created interactive Power BI dashboards to visualize employee engagement data, which helped the company identify areas for improvement., Used Power BI to analyze social media data and identify trends that helped the company develop more effective marketing campaigns., Trained a team of sales representatives on how to use Tableau to create and deliver data presentations to clients., Developed Power BI dashboards to visualize Inventory data, resulting in a 15% increase in conversion rates.

Timeline

SQL Developer

INFOSYS BPB
05.2024 - Current

Data Analyst

BT GLOBAL SERVICES
03.2019 - 04.2024

Bachelor of Technology - Computer Science

Similar Profiles

CREATE PROFILE
Shobhit Singh