Sql Server Developer

Shivankari Singh

+1-408-***-**** **********.*****@*****.*** Cupertino, CA 95014

SUMMARY

Highly skilled and experienced Senior MS SQL Developer with over 16 years of expertise in designing, implementing, and maintaining complex SQL databases and applications. Proficient in optimizing database performance, writing advanced SQL queries, and ensuring data integrity. Strong analytical and problem-solving skills, with a proven track record of delivering high-quality solutions in fast-paced environments. Excel in problem-solving, collaboration, and adaptability to leverage technical skills in developing innovative data solutions across diverse environments. Experience in working in multiple domains: Healthcare, Retail, Banking and Finance. SKILLS

• Databases: Microsoft SQL Server, Sybase,

Oracle

• SQL: T-SQL, PL/SQL

• Tools: SSIS, SSRS, SQL Server Management

Studio (SSMS), Visual Studio, Azure Data Studio

• Programming Languages: Python, C#

• Data Modeling: Microsoft Visio

• Cloud Platforms: Microsoft Azure

• Other: ETL processes, Data Warehousing,

Performance Tuning, Stored Procedures, Triggers,

Indexing, Database Structures and algorithms.

EXPERIENCE

Senior Database Developer, IBM, March 2016-Current Subject Matter Expert in Enterprise Disbursement Application Database development and design

Revamped Premium Claim Application by enhancing and developing it, resulting in improved performance through optimized procedures and queries. Maintained optimal performance of MS SQL Server databases through the development and management of stored procedures, functions, triggers, views, and indexes. Performed regular evaluations of current database architecture and provided necessary recommendations for enhancements.

Designed and implemented SSIS packages for seamless ETL operations across diverse databases and systems.

Developed Python scripts to automate data processing tasks. Developed scripts using T-SQL language for updating large datasets efficiently. Leveraged expertise in handling various data structures including arrays, linked lists, stacks, and queues for optimizing algorithm implementation.

Developed and implemented database designs to support business requirements. Contributed to various initiatives in both Banking and Healthcare sectors. Lead Analyst, Bally Technologies, December 2015-February 2016 Spearheaded project leadership and effectively managed team responsibilities Managed and maintained the Casino Management System for multiple Australian casinos. Facilitated analysis sessions, obtained requirements, prepared specification as well as functional design documentation for improvements and customizations. Evaluated product impact through analysis.

Senior Database Engineer, Standard and poor's CapitalIQ, July 2013-November 2015 Led the Price and Index project as an architect and analyst. Gained expertise in understanding various asset classes including Equities, Funds, and financial market commodities

Aligned database design with identified business needs. Designed and implemented feed file ingestion process for the Cross-Reference Platform Enhanced the efficiency of existing stored procedures and introduced new ones for handling complex data loading tasks

Systems Analyst, Steria India Limited, February 2012-July 2013 Served as an individual contributor while representing Steria India at Commerzbank in Frankfurt, Germany for Anti Money Laundering Application. Created innovative technical strategies to address AML, GBL, and CTF challenges. Ensured the accuracy and reliability of a system used to load and generate reports on customer, account, and transaction data.

Systems Engineer, Tata Consultancy Services, November 2007-February 2012 Managed various positions and duties ranging from TSQL Developer to Team Lead. Designed and developed the data warehouse and DataMart Optimized existing SSIS packages by performing performance tuning activities like reducing redundant operations, replacing Lookup and Merge Join with Hash Match.

Optimized existing queries for better performance using SQL query tuning techniques. Analyzed business requirements and designed appropriate software solutions using C#, ASP.NET, and SQL Server.

EDUCATION

B.Sc. in Mathematics

Magadh Mahila College, IN

DIGITALCREDENTIALS

Enterprise Design Thinking Practitioner - 2016

AWS Partner: Accreditation (Technical) - 2022

LANGUAGES

English - Fluent

Hindi - Fluent

REFERENCES

References available upon request.

Contact this candidate