Sql Server Data Warehouse
Resume:
PROFILE
Having over *+ years of versatile experience in various business and technical landscapes, specializing in the design, development, implementation, and support of relational databases, data analysis,
Optimizing data infrastructure for performance and scalability, adhered to Platform as a Service – Server less Azure Data Factory and AWS Data Pipeline Services.
Expertise includes working with T-SQL, Azure, Agile methodologies, and business intelligence tools like Power BI and DAX
Committed to ensuring high performance and data integrity through effective Data Modeling and Normalization techniques.
Strongly experienced on SQL Server as a Developer, experience includes Database Design and Development, Confidential BI Solutions,
ETL Development, Data warehouse Implementation, Report Development using SSAS, SSIS, SSRS and SQL.
Very good working experience of T-SQL.
Proficient on Relational database concepts and architecture, implemented Database, Data Warehouse and Data Marts using SQL Server 2022, 2019, 2017 and other legacy versions.
Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, well verse in ERWIN
Experienced in using SSIS for extracting, transforming the data using CDC, Lookup, execute
Good understanding of Data Marts and Data Warehouse concepts (OLTP, OLAP).Integrated and transformed data from different data sources like Excel, FTP Server, XML and
Expertise with ERP implementation and Data Conversions
Experience in Oracle E-Business Suite 11i and R12 and Oracle Developer Suite
Expertise in system integration testing, preparing design documents
Excellent Analytical skills to understand the business process and functionality, requirements and to translate them to system requirement specifications
Experience in various phases of SDLC like Exploring requirements, Analysis/Design, Development, Testing and deployment, Go-live and Post go-live support
Experience in preparing Test plans, Test Data and execution of Test cases to ensure application functionality meet the user's requirements
Well versed with Unix Scripts and Unix Shell Scripting
Experience in handling Production cases and escalations
Ensured Project compliance to Quality and Standard implementation methodology Drive QA processes for the project in the program, Participate in CMMI Level 5, Identify, communicate and implement opportunities for process/solution improvement Establish CMMI process to control defects and improved customer satisfaction
Have good experience in On site-offshore model execution of projects
Proficient in SQL Server and T- SQL (DDL and DML) in constructing Tables, Views, Constraints, Triggers, Types for handling complex business requirements.
Experienced in creating and using Stored Procedures, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.
Excellent documentation and presentation skills, great verbal and written communication skills
TECHNICAL SKILLS
Operating Systems: UNIX, Windows 95/98, Windows NT/XP, Windows Server 2019
Hardware: PC-Compatible, HCL
Web Technologies: Angular, Spring, HTML5, DHTML and XML, CSS3, Spring Boot
Languages: SQL, PL/SQL, T-SQL, Python, Shell Scripting, C#, Java 8 (JDK 1.7/1.8),
RDBMS: Oracle 9i/10g/11g, SQL Server 2019, Azure SQL Database
GUI/Development Tools: Oracle SQL Developer, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), Microsoft SQL Server Management Studio (SSMS), Toad.
Tools: Azure Data Factory, Flyway DB, Microsoft Excel, Power BI, DAX
OLAP: Business Objects v4.5/5.1
Design/Version Control: CVS, SVN, Git
CI/CD Pipelines: Docker, Kubernetes, Jenkins
EDUCATION
Bachelor’s Degree
EXPERIENCE
Bank Of Montreal - Brady, TX (January 2023 to Present)
SQL/ETL Developer
Designed and developed ETL processes and SQL solutions to support daily business operations and ensure integration with the current level of applications.
Created and optimized various SQL Server databases for data integration and development, focusing on maintainability and performance.
Set up and configured environments in Microsoft SQL Server 2019 Enterprise Edition, including database creation and security setup.
Translated business requirements into DAX calculations and expressions to drive business logic and analytics.
Leveraged SSRS expressions (like custom logic for conditional formatting, dynamic text, or calculations) to enhance report functionality.
Developed complex SQL queries, stored procedures, functions, and triggers to automate data processing and interface tasks.
Stay up to date with new features and best practices related to SQL Server and T-SQL.
Developed complex SQL queries using T-SQL to retrieve, insert, update, or delete data in a database.
Managed data loading processes, including validating flat files and ensuring data accuracy before processing.
Set up and configure report data sources to connect SSRS to SQL Server databases or other data providers.
Extensive experience in writing and optimizing complex T-SQL queries, stored procedures, triggers, and functions in SQL Server environments (SQL Server 2019, 2022).
Created and customized reports and dashboards using SQL Server Reporting Services (SSRS) to meet business requirements and user needs.
Developed and maintained ETL pipelines using SQL Server Integration Services (SSIS) for data migration and transformation.
Built and managed dashboards to provide users with access to relevant applications and data based on assigned permissions.
Provided 24x7 application support, addressing and resolving critical issues for users and business operations.
Scheduled and monitored various interfaces and processes to ensure successful data transfer and accuracy between systems.
Collaborated with functional teams in an agile environment, demonstrating strong meeting facilitation, communication, and presentation skills.
Utilized version control systems such as Git for source code management and collaboration.
Developed data migration scripts and managed database changes using tools like Flyway DB and ARM Templates.
Use DAX Studio and SQL Server Profiler to monitor and optimize the execution time of DAX queries.Hands-on experience with Azure Databricks for big data analytics, working on data processing, and machine learning models in a cloud environment
Worked with senior DBAs and support teams to address and resolve critical issues related to SQL Server and ETL processes.
Conducted analysis and design for project development phases, including performance tuning of SQL code and ETL processes.
Proficient in designing and developing interactive dashboards and reports, utilizing Power BI to deliver actionable insights from complex datasets.
Expertise in Azure cloud services, including Azure Data Factory, Azure SQL Database, and Azure Key Vault, with hands-on experience in building scalable data pipelines and cloud solutions.
Managed a team of developers, ensuring effective coordination and execution of tasks.
Created Functional Design Documents (FDD) and Technical Design Documents (TDD) for business approval and development.
Monitored and tracked performance, identified risks, and resolved issues within SQL and ETL environments.
Developed and maintained Data Mart reporting projects using Microsoft SQL Server technologies for higher management insights.
Ensured user activity tracking and access control within applications to prevent unauthorized access.
Migrated new or modified reports and ETL processes to production environments, ensuring accuracy and functionality through thorough testing.
Tested applications with various sample data in development, testing, and QA environments before moving to production.
Applied data normalization techniques to ensure efficient data storage, minimize redundancy, and optimize performance across various databases.
Developed and managed data integration solutions using Azure Data Factory, automating ETL processes and data workflows in the cloud.
Experience in implementing the Data Vault methodology for building scalable and flexible data warehousing solutions.
Proven experience working in Agile environments, contributing to sprint planning, daily stand-ups, and collaborating effectively with cross-functional teams to deliver high-quality software solutions.
Environment: Microsoft SQL Server 2019 Enterprise Edition, Azure Data Factory, Azure SQL Database, Azure Entra ID, Azure Key Vault, SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), XML, C#, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Windows Server 2019, Git, Flyway DB, ARM Templates, Python, YAML, Terraform.
Capgemini - Dallas, TX (July 2020 to December 2022)
SQL Developer
Proficient in designing and developing interactive dashboards and reports, utilizing Power BI to deliver actionable insights from complex datasets.
Provided support and maintenance for the enterprise applications, ensuring optimal performance and availability.
Ensured secure connections to databases and manage data source credentials using SSRS security settings.
Used DAX to transform data as it’s loaded into Power BI or other BI tools, enabled to manipulate, clean, and aggregate data before it’s displayed in reports.
Experience with Oracle database administration and SQL development, including writing PL/SQL scripts and managing data integrations.
Strong background in logical, physical, and dimensional data modeling to support efficient data warehousing and reporting solutions.
Extensive experience in writing and optimizing complex T-SQL queries, stored procedures, triggers, and functions in SQL Server environments (SQL Server 2019, 2022).
Developed SQL scripts to generate data for reports in SQL Server Reporting Services (SSRS) based on user requirements.
Created various types of reports (tabular, matrix, charts, and graphical reports) that meet business requirements using SSRS.
Develop complex SQL queries using T-SQL to retrieve, insert, update, or delete data in a database.
Hands-on experience in using Talend for data integration, ETL processes, and automation of data workflows across multiple sources.
Created and managed SQL Server database objects, including tables, indexes, views, and constraints, to meet new requirements and enhance functionality.
Hands-on experience with Amazon Web Services (AWS), primarily in using AWS Data Pipeline and other cloud-based tools to manage and optimize data workflows.
Designed and implemented SQL Server Integration Services (SSIS) packages to automate data integration and transformation processes for daily and incremental loads.
Supported Java-based front-end applications by maintaining and optimizing the SQL Server database backend.
Stayed up to date with the latest DAX features and functions to enhance the accuracy, performance, and capabilities of your data models.
Experience working with PostgreSQL databases, including developing SQL queries, managing tables, and ensuring data integrity and performance.
Proven experience working in Agile environments, contributing to sprint planning, daily stand-ups, and collaborating effectively with cross-functional teams to deliver high-quality software solutions.
Prepared and executed migration and deployment scripts for Development, UAT, and Production environments, ensuring smooth transitions and minimal disruptions.
Coordinated with application support teams to address and resolve issues, ensuring alignment with business needs and application performance.
Engaged in database design, programming, tuning, performance optimization, and troubleshooting to maintain high performance and reliability.
Created and scheduled SQL Server Agent jobs, ensuring they ran efficiently without affecting system performance; configured email notifications for job failures.
Collaborated with senior DBAs and application support teams to resolve critical issues and service requests related to SQL Server and SSIS processes.
Conducted analysis and design for project development phases, including requirements gathering, documentation, and data extraction.
Participated in project discussions, troubleshooting, problem-solving, and providing user support in an Agile development environment.
Expertise in Azure cloud services, including Azure Data Factory, Azure SQL Database, and Azure Key Vault, with hands-on experience in building scalable data pipelines and cloud solutions.
Designed and developed complex forms and reports using SSRS, incorporating advanced SQL queries and data analysis techniques.
Designed interactive reports and dashboards that make use of DAX measures to provide insights.
Utilized SQL Server's analytic and grouping functions to perform in-depth data analysis and create complex views for efficient data extraction.
Addressed performance tuning issues, optimizing SQL queries and SSIS packages to handle concurrent processes and improve execution speed.
Gathered requirements from stakeholders, documented processes, performed data cleansing, and developed reports as per specifications.
Ensured that all ETL processes and batch jobs functioned correctly, with data and performance considerations, and were available for business use as required.
Environment: SQL Server 2019, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Azure SQL Database, T-SQL, Microsoft Excel, Git, Python, XML, Azure Data Factory, Flyway DB.
R1 RCM Inc. - Murray, Ut (October 2019 to June 2020)
Junior Sql Developer
Assisted in the development and optimization of SQL scripts, including stored procedures, functions, and triggers, to support database performance and functionality.
Created and managed temporary tables to facilitate efficient data handling and simplify query processing tasks.
Hands-on experience with Amazon Web Services (AWS), primarily in using AWS Data Pipeline and other cloud-based tools to manage and optimize data workflows.
Developd efficient SQL queries used T-SQL for data retrieval, updates, inserts, and deletions.
Supported the automation of routine data tasks by writing SQL scripts, contributing to enhanced data management and processing efficiency.
Assisted in the creation of UNIX shell scripts for automated report generation and email distribution, including handling text attachments.
Conducted basic testing and validation of SQL code to ensure alignment with business requirements and data accuracy.
Used SSRS features like report caching or snapshots to improve report performance for frequently accessed reports.
Used version control tools (like Git) to manage and track changes to database code (T-SQL scripts, stored procedures, etc.).
Proven experience working in Agile environments, contributing to sprint planning, daily stand-ups, and collaborating effectively with cross-functional teams to deliver high-quality software solutions.
Collaborated with senior developers and team members to understand project requirements and assist in delivering effective solutions.
Supported the preparation of design documents and technical specifications based on project needs and client input.
Work closely with business analysts, data engineers, and other stakeholders to gather requirements for data models and ensure the DAX calculations meet business needs.
Participated in integration testing to ensure that SQL components functioned correctly within existing systems.
Reviewed SSRS logs to troubleshoot report rendering or execution issues.
Monitored and debugged SQL code under guidance to resolve issues and support database performance.
Engaged in end-to-end testing of SQL components to verify they met functional and technical specifications.
Assisted with database deployments, ensuring smooth transitions from development to production environments.
Experience in writing and optimizing complex T-SQL queries, stored procedures, triggers, and functions in SQL Server environments (SQL Server 2019, 2022).
Proficient in designing and developing interactive dashboards and reports, utilizing Power BI to deliver actionable insights from complex datasets.
Expertise in Azure cloud services, including Azure Data Factory, Azure SQL Database, and Azure Key Vault, with hands-on experience in building scalable data pipelines and cloud solutions.
Coordinated with team members to manage tasks and contribute to timely project completion.
Maintained and updated SQL scripts as required by evolving project requirements and feedback.
Documented processes and solutions clearly to provide comprehensive records for future reference.
Environment: SQL, PL/SQL, Oracle 10g, TOAD, UNIX, Oracle R12, SQL Server 2016, Microsoft SQL Server Management Studio (SSMS), Azure SQL Database, Git, Python, Data Factory, XML.
Mckinney, TX 75070
*************@*****.***
Jyoti Negi
SQL/ETL Developer
Contact this candidate