Highly skilled and analytical software engineer with over 8 years of experience. Demonstrated ability to excel in high-pressure situations and consistently deliver optimal results. Strong written and verbal communication skills, enabling effective collaboration both independently and within a team setting. Extensive expertise in writing stored procedures, functions, and views, as well as tuning complex sub-queries, SQL stored procedures, functions, and triggers. Proven track record in requirement analysis, coding, and testing across various modules within the software development life cycle. Solid experience in SQL design, normalization, and query optimization of databases. Proficient in DBMS/SQL/Advanced SQL/Stored Procedures and DB Scripting (PL/SQL, TSQL, etc.).
As an SQL Developer, specialized in designing, developing, and optimizing SQL databases and queries. Responsible for data modeling, database management, and implementing stored procedures and functions to enhance application performance. Proficient in performance tuning and executing complex queries for data analysis and reporting.
As an ETL Tester and Query Designer, responsible for validating data extraction, transformation, and loading processes to ensure data integrity and accuracy. Developed and optimized SQL queries for data analysis. Conducted performance testing and troubleshooting to enhance ETL processes and support business intelligence initiatives.
Developed and supported stored procedures (SPs) and change control requests (CCRs) for distribution and accounts as part of an internal project. Worked on the Geojit back-office application utilizing SQL Server Management Studio (SSMS), Delphi, and ASP.NET.
Developed comprehensive database solutions including database design, ERD creation, and normalization for B.Tech and M.Tech projects. Utilized C# and .NET for software development, alongside Android technologies for mobile applications. Focused on delivering tailored solutions for students in the UK and Australia, leveraging SQL Server Management Studio (SSMS) for database management and development.
SQL
Name:Wynn La-Data Mod Phase 2-FEB 2
Industry: Travel & Hospitality
Client: Wynn
Role: Developer
Technologies: Snowflake, DevOps (User stories and Repos)
Project Description:
Wynn Las Vegas, often simply referred to as Wynn, is a luxury resort and casino located on the Las Vegas Strip in Paradise, Nevada, United States. It is owned and operated by Wynn Resorts.
Roles/ Responsibilities:
• Create new scripts.
• Update Scripts for resolving Bug.
• Manipulate Tables and Columns.
• Summarize Data for Reports and Do analysis on Tables.
• Creating and Updating user stories in DevOps.
• Do check-ins and create build for releases.
Cricket