Sql Server Data Analysis

Nadimpalli Sankeerth Varma Email: ad9l9l@r.postjobfree.com PH: +1-737-***-****

Data Professional with 9+ years of experience in designing, implementing and managing data related projects. Detail- oriented, organized and meticulous employee. Works at fast pace to meet tight deadlines. Bringing to the forefront a visionary mindset and understanding of product development lifecycle from research, requirement elicitation, solution design, implementation. Enthusiastic team player ready to contribute to company success. Experience across E- Commerce, Finance domains.

Professional Summary

Having 9+ years of experience in IT Professional career with extensive experience in MS SQL Server 2012/2014/2016, MSBI Technologies like SSIS & SSRS, Databricks, Autosys.

Highly experienced in conducting Market Research, competitive analysis & business case preparation.

Experienced in programming tasks-Stored Procedures, Views, Indexed Views, Functions, and Triggers using SQL Server 2012/2014/2016 with T-SQL.

Creating Maintenance plans and Scheduling jobs and sending mails when job success/Failure.

Domain expertise in various aspects of Ecommerce, Finance.

Expertise in SQL profiles.

Effective team player and excellent communication skills with insight to determine priorities, schedule work and meet critical deadlines.

Participate in the coordination and creation of product/service documentation and training

Leverage relationships and conversations to identify challenges and opportunities with stake holders.

Analyze the issues raised by users, assigning appropriate priorities and providing solutions to users.

Experienced in working Agile Methodology and waterfall methodology.

Knowledge of prevalent IT methodologies, management practices, architectures, system development lifecycles and best practices.

Proficient in writing complex SQL queries, stored procedures, functions, and views to extract, transform, and analyze data for various business needs.

Skilled in database performance tuning, query optimization, and indexing strategies to enhance system efficiency and response times

Demonstrated ability to collaborate effectively with cross-functional teams to understand business requirements and deliver scalable database solutions.

Strong problem-solving skills with a track record of resolving database-related issues and optimizing processes for improved performance.

Knowledgeable about database design principles, normalization, and relational database management systems.

Certification:

Azure Fundamentals.

Safe for Teams Courses (5.0) - Scaled Agile.

TECHNICAL SKILLS

Domains: E-Commerce, Finance

Database: MS SQL Server, Oracle

Tools: Azure Data factory, Power BI, Databricks

Methodologies: Agile, Scrum, Kanban

Operating System: Unix, Microsoft Windows Family

Programming Languages: SQL, Python

Professional Experience: (2015-Present)

S and P Global Jan 2019 to Present

Role - Senior Software engineer Responsibilities:

●Developed various modules of a Data Feed Management solution, based on user requirements, documentation and detailed design documentation.

●Worked on delivering proprietary data packages through Xpress feed to a number of clients subscribed to it.

●Designed data driven procedures, query performance tuning, developed underlying data modules and databases.

●Developed solutions to automate various parts of the development process.

●Supported the Xpress feed application on Production and handled all major incidents causing errors in the system.

●Designing logical and physical data models to represent business entities, relationships, and constraints, ensuring data integrity and normalization.

●Planning and executing data migration projects, including schema changes, data transformation, and data cleansing, while ensuring minimal downtime and data loss.

●Developing scripts and tools to automate routine database tasks, such as schema updates, data imports, and index maintenance, to improve efficiency and reduce manual effort.

●Participating in code reviews to ensure adherence to coding standards, best practices, and performance guidelines for SQL code written by peers.

●Providing guidance, training, and mentoring to junior SQL developers or other team members on SQL coding techniques, database design principles, and troubleshooting methodologies.

●Implement CDC on selected tables by enabling CDC at the database level and configuring CDC capture instances for individual tables using SQL Server Management Studio (SSMS) or Transact-SQL (T-SQL) commands.

●Develop and optimize SQL queries to extract data from Xpress feed databases.

●Design and maintain database schemas and structures for Xpress feed datasets.

●Implement stored procedures and functions for data manipulation and transformation.

●Work closely with stakeholders to understand data requirements and deliver solutions that meet business needs.

●Develop and maintain documentation for Xpress feed databases, queries, and processes.

●Optimize data models and database structures for scalability and performance.

●Develop data loading scripts and utilities to facilitate the import of external data into Xpress feed databases.

●Participate in testing and validation activities to ensure the accuracy and reliability of Xpress feed data and processes.

●Participate in software development lifecycle activities, including requirements gathering, design, development, testing, and deployment.

●Evaluate and recommend tools and technologies for SQL development and Xpress feed data management.

●Identify the tables and columns required to construct the views, considering data normalization, relationships, and business logic.

●Utilize appropriate indexing strategies to speed up query execution, including creating, dropping, or modifying indexes.

●Collaborate with system administrators and operations teams to integrate SQL jobs into Autosys for automated scheduling and execution.

●Collaborate with system administrators and operations teams to integrate SQL jobs into Autosys for automated scheduling and execution.

Pinion Infotech

Role – Software Developer March 2018 to Jan 2019

Responsibilities:

●Developing database scripts based on client’s requirement.

●Importing data using SSIS.

●Identifying issues with database and resolving them.

●Regarding GDPR regulations masking of data

●Processing the imported data to best fit in the tables.

●To deliver tickets on time and coordinating with client till the ticket closure.

●Creating extended properties and PII for the tables

●Handling different types of issues.

●Manage and maintain data.

●Design the structure and flow of the stored procedure, outlining the steps and logic required to achieve the desired outcome.

●Evaluate the potential use of indexed views (materialized views) for improved query performance, especially for frequently accessed or computationally intensive queries.

Ahead Race April 2015 to March 2018

Role – Software Developer Responsibilities:

●Developing database scripts based on client’s requirement.

●Collaborate with stakeholders to understand data requirements and translate them into technical specifications.

●Design and optimize database schemas, tables, and indexes to support efficient data storage and retrieval.

●Implement data validation and quality checks to ensure the accuracy and integrity of e-learning data.

●Create and maintain data pipelines for automated data ingestion and processing.

●Monitor database performance and troubleshoot issues to ensure smooth operation of e-learning applications.

●Document database designs, data models, and coding standards for knowledge sharing and future reference.

●Identifying issues with database and resolving them.

●Load the data from excel to SQL server and vice versa.

●Processing the imported data to best fit in the tables.

●To deliver tickets on time and coordinating with client till the ticket closure.

●Performing unit testing and integration testing.

●Handling different types of issues.

●Manage and maintain data.

●Develop and Deploy SSIS Packages.

●Develop SSRS Packages.

●Analyze requirements and specifications provided by stakeholders to understand the logic and functionality needed in the stored procedures.

●Design the structure and logic of the views, including selecting appropriate joins, aggregations, filters, and transformations to derive the desired result set.

●Rewrite SQL queries to improve efficiency, readability, and maintainability, considering alternative join methods, filter conditions, and index usage.

EDUCATION

Bachelors in computer science and engineering, JNTU-K, India, May 2014.

Contact this candidate