Vaibhav Tyagi

Team Lead: Data Analyst, SQL Server Developer | Clearstream Financial.

Settlement Prediction Tool - Analyze data to determine the probability of achieving on-time resolution. Predicted on-time settlement likelihood by evaluating transactional patterns. Facilitated daily assessment of settlement efficiency by offering an extensive overview and utilizing Python for failure analysis.

Settlement Efficiency Report - Monitor and improve settlement efficiency. This report provides detailed insights into settlement activities, highlighting areas with high failure rates, and suggesting improvements. (SSRS)

Key Achievements:

• Played a pivotal role in improving data quality, reducing inconsistencies by 20%.
• Contributed to creating a sales performance dashboard that helped the team identify key areas for improvement.

Team Lead: Data Analyst, SQL Server Developer | Nestlé

• Constructed dependable ETL pipelines ensuring smooth source-target integration with SSIS.
• Orchestrated deployment of operational procedures.
• Boosted operational output by streamlining processes.

Team Lead: Data Analyst + SQL Server developer | Fishers Investment Capital Investment

• Utilized SQL Server and SSRS to generate ad-hoc reports and dashboards for senior leadership and department heads.
• Lead the development and maintenance of SSIS ETL processes to ensure smooth data migration and integration across systems.
• Designed and developed SQL Server Analysis Services (SSAS) cubes to aggregate large volumes of business data and enable complex analysis.

Key Achievements:

• Successfully automated data processes, reducing manual report generation time by over 50%.
• Created an interactive KPI dashboard that provided real-time insights into customer satisfaction and sales performance, improving response times by 20%.

Team Lead: SQL Server developer | Intel

• Corporation tuning and troubleshooting of SQL views, procedures, and troubleshooting of SSAS queries.
• Collaborated with business users to gather requirements and translate them into effective business intelligence solutions.

Team Lead : SQL Server developer | CISO-SOC

• The project is related to checking compliance and vulnerability of the internal and external assets.
• Writing and tuning SQL queries, and writing stored procedures.
• Development and management of SSIS ETL packages.

Project: Wells Fargo

• Enhanced reporting capabilities through the creation of performance-boosting multidimensional cubes via SSAS.
• Designed streamlined data structures to support KPI monitoring by stakeholders.

Project: Morgan Stanley Capital Investment

• ETL module enabled different feeds to process and transfer information into SQL database.
• Handled extensive project involving upwards of 20 packages related to database tables and report generation.
• Utilized SQL Server 2012, SSRS, and SSIS to meet specifications.

• Produced instantaneous updates assessing accounts and customer information.
• Employed SQL Server 2008 R2/2012 services to optimize database performance and safeguard data access.

Project: Quatrro Power BI Dashboard.

Transformed raw data from SQL Database, SSAS Cube, and Excel into visual reports using Power BI.

Responsibilities:

Employed SQL Server Reporting Services, Integrated Services, and Analysis Services for effective reporting tools.

Project: SCM-CTCA

• The SCM system is an application that deals with the day-to-day entries in the hospital.
• CTCA is a group of hospitals in the USA that handles or provides treatment to patients with cancer.
• Applied RDBMS concepts and constructed database objects including tables, indexes, stored procedures, views, user-defined functions, cursors, and triggers.

• CRisMac System is a distributed application that deals with the loan disbursement system of banks. The MIS and ETL module facilitate the extraction of existing customer and account data from the core banking solutions database, such as Finacle.
• Compiled over 500 reports, dashboards, KPIs, and OLTP cubes aligning with RBI requirements.
• Executed tasks involving stored procedures, functions, views, tables, and indexes within MS SQL Server.
• Maintained database objects such as stored procedures, functions, views, and tables while leveraging expertise in SQL Server Reporting Services.