SQL Developer

Thrisha Singi

Email: advei8@r.postjobfree.com, Phone: 469-***-****

Professional Summary

Self-driven Software Developer with 7 years’ experience in developing SQL Server BI solutions. Successfully developed, delivered and troubleshooted application products for multiple clients. Delivered multiple Data projects at Capital One on time and an average of 10% under budget. Reduced costs of a retail chain by 15% by analyzing the operating data in Blackhawk Networks. Good experience with the phases of Software Development Life Cycle SDLC, STLC & AGILE such as requirement gathering & analysis, design, development, testing, implementation & maintenance. Seeking to advance my career by growing skill set in Data Analysis and Business Intelligence Solutions.

Over 7 years of IT Experience in System Design, Development, and Support of Microsoft SQL Server 2019/2016/2014/2012 in Development, Data warehouse, Test, and Production Environments on various business domains like Banking, Financial and ERP.

Expertise in writing complex SQL queries (Nested & Sub), Query Optimization, T-SQL, Joins, Indexes, Partitioning, Views, Normalization, Stored Procedure, Functions, Error Handling, Trigger, cursors, Derived Tables, CTEs and Temporary tables.

Efficient in upgrades and migration from MS SQL Server 2012 to MS SQL Server 2016/2019.

Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation, and loading.

Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS. Hands on experience in trouble shooting database issues.

Experienced in data loads, database integration/conversions, performance tuning and optimization.

Experienced in writing the MDX queries to develop the Key Performance Indicator (KPI) Objects, Calculated Members, and Actions and to get the data from the OLAP cube for the reporting purpose.

Expert in designing Enterprise reports using SQL Server Reporting Services generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS.

Experience in creating packages, jobs, sending alerts using SQL Mail and extended stored procedures.

Designed Scripts for Data Flow and Error Handling using Script component in SSIS.

Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and VB scripts.

Design of large-scale business applications and systems in a web-based multi-user environment.

Designed Scripts for Data Flow and Error Handling using Script component in SSIS.

Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.

Design of large-scale business applications and systems in a web-based multi-user environment.

Involved in development of web graphics and graphical (UI) Pages using HTML, Master Pages & ASP.NET Controls.

Designed Power BI data visualization using cross tabs, maps, scatters plots, pie bar and density charts.

Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security. Experience in developing User management reports using SSRS.

Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Crosstab, Conditional, Drill-down, Top N, Summary, Form OLAP and Sub reports, Parameterized, Custom reports and formatting them.

Knowledge on tableau, which is used to connect to almost any database, drag and drop to create visualizations, and share with a click.

Responsible for communicating with the data warehousing team to ensure the data on server is updated and accurate based on the most recent data received from the client.

Good team player, strong interpersonal and communication skills combined with self-motivation, initiative, and the ability to think outside the box.

Technical Skills

Database Technologies : T-SQL, SSMS, SSIS, SSRS, Query Analyzer, SQL Profiler

Programming Languages : X++, HTML, JavaScript, Shell Scripting

Cloud Tools : Amazon AWS, EC2

ETL Tools : SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SAP Data Services, Import/Export Wizard, Bulk Insert, BCP, Data Stage

RDBMS : HDFS ORACLE, SQL Server, Teradata

Business Intelligence Tools : Tableau, MSBI Stack, Excel, Power BI

Methodologies : Agile Scrum, Waterfall

Professional Experience

Sr SQL Server Developer May 2022 - Till Date

Selene Finance, Dallas, TX

Responsibilities:

Involved in Performance tuning and Query Optimization using execution plan.

Communicated and enforced report and data visualization standards.

Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, using defined objects, chart.

Scheduled reports with the help of standard/data-driven subscriptions in SSRS.

Designed, deployed, and maintained various SSRS Reports in SQL Server/ Report Manager.

Created custom reports and data sets for reports using global variables, expressions, and functions in SSRS.

Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and chart.

Design and implementation of print optimized reports in SSRS.

Developed various dashboards utilizing Power BI with multiple scorecards.

Creating SSIS Package Configurations and maintaining their tables by editing the values of the variables as per the requirement.

Worked on re-design of the few SSIS Package which involved very complex logic and more than a 100 tables and tasks and developed simplified version of the Packages.

Involved in data cleansing to remove unnecessary columns eliminate redundant and inconsistent data by using SSIS transformations.

Performed ad hoc analyses, as needed, with the ability to comprehend analysis as needed.

Worked on queries using statistics to calculate the mean and average of the sales.

Created pivot tables to ease data visualization and research presentations. Forecast sales based on available data.

Providing production support for bug fixes and enhancements.

Identifying quality best practices and developing standard quality protocols that can be used in the Team

Created excel live views for business and auditing purposes.

Developed SSIS packages to extract transactional data from Teradata and load them into SQL server.

Creating SSIS Package Configurations and maintaining their tables by editing the values of the variables as per the requirement.

Worked on re-design of the few SSIS Package which involved very complex logic and more than a 100 tables and tasks and developed simplified version of the Packages.

Written several SQL Scripts such as finding tables with Identity Columns, tables that do not have primary key to streamline the process of replication.

Prepared various documents including technical specification documentation for the modules that are developed.

Environment: MS SQL Server 2019, SSDT, C#, SSIS, JIRA, Visual studio 2016, SSRS, DTS, T-SQL, Azure

SQL Server Developer Feb 2020 - May 2022

Capital One, VA

Responsibilities:

Created numerous simple to complex queries involving joins, correlated sub-queries and CTE's techniques for diverse business requirements. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.

Created Indexes for fast retrieval of the data and used string functions for space management in database.

Involved in Performance tuning and Query Optimization using execution plan.

Created excel live views for business and auditing purposes.

Developed SSIS packages to extract transactional data from Teradata and load them into SQL server tables.

Creating SSIS Package Configurations and maintaining their tables by editing the values of the variables as per the requirement.

Worked on re-design of the few SSIS Package which involved very complex logic and more than a 100 tables and tasks and developed simplified version of the Packages.

Involved in data cleansing to remove unnecessary columns eliminate redundant and inconsistent data by using SSIS transformations.

Performed the deployment of the developed Packages into various Environments and schedule them as Jobs through the SQL Server Agent.

Provided continued maintenance and bugs fixes for the existing and new Power BI reports.

Involved in Performance tuning and Query Optimization using execution plan.

Communicated and enforced report and data visualization standards.

Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, using defined objects, chart.

Scheduled reports with the help of standard/data-driven subscriptions in SSRS.

Designed, deployed, and maintained various SSRS Reports in SQL Server/ Report Manager.

Created custom reports and data sets for reports using global variables, expressions, and functions.

Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and chart.

Design and implementation of print optimized reports in SSRS.

Developed various dashboards utilizing Power BI with multiple scorecards such as average BOM processing times, sales trends, processing costs.

Created pivot tables to ease data visualization and research presentations.

Performed ad hoc analyses, as needed, with the ability to comprehend analysis as needed.

Worked on queries using statistics to calculate the mean and average of the sales.

Responsible for keeping track of decommissions of legacy reports.

Environment: MS SQL Server 2017, SSDT, C#, SSIS, JIRA, Visual studio 2016, SSRS, DTS, T-SQL, Azure.

SSIS/SSRS Developer Jul 2019 - Jan 2020

Blackhawk Network, CA

Responsibilities:

Migrated over 50 reports from Business Objects, Oracle Report Builder reports to SSRS.

Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Drill through, and Drill down Reports.

Designed Large number of reports using table filters, single value parameters, multi value parameters, dependent parameters, and Cascading Parameters

Converted complex PL/SQL packages, functions, procedures to SQL Server objects (T-SQL).

Report writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS) and Crystal Reports 9.0

Performed the development, maintenance and support of different Inventory Control and Finance reports.

Deployed and uploaded the SSRS reports to SharePoint Server and Report Manager in various phases of SDLC Process for the end users to look at them.

On a Regular basis Created Store Procedures, Indexes, User defined Functions, Constraints etc for the reporting using query optimization techniques.

Involved in Performance Tuning of the Store Procedures when needed, creating indexes, Hash Join, etc so that the report execution time is minimized and ensured that the Optimized Execution Plan is used.

Created Report Email Subscription using Data Driven and Time Driven Report Subscriptions

Deployed reports across Test, Development and Production Environments

Involved in Creating User Security and Roles in Reporting Services at both Parent and Report Level

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.

Designed packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, Derived Columns with Multiple Data Flow tasks

Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting, and cleaning the data from different Sources into Company Format.

Created Package Configurations, Event Handlers for On Error, On Warning, On Task Failed.

Designed Packages with Error Handling and Package Logging that stores the Logging results in SQL table

Developed Complex Packages to load data into Stage, ODS and Data warehouse systems

Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler.

Involved in code reviews, change control and auditing procedures

Experienced in Agile and Scrum Methodologies and Participated in the knowledge transfer process and share the knowledge with the client team

Environment: SSRS, SSIS, MS SQL Server 2016, SSDT, C#, JIRA, Visual studio 2016, DTS, T-SQL, Crystal Reports, Oracle, PL/SQL.

SSIS Developer Mar 2018 - Jun 2019

Sakar International, Inc, NJ

Responsibilities:

Developed various reports across all the modules in Microsoft Dynamics AX.

Worked in conjunction with offshore data architects/modelers on the backend data warehouse reporting solution running on SQL Server 2016.

Involved in Performance tuning and Query Optimization using execution plan.

Created and Modified Stored Procedures, Triggers, Tables, Views and making use of Merge Statements instead of Cursors in T- SQL Optimized queries by looking at Execution Plan for better tuning of the database.

Used SQL Profiler for monitoring and troubleshooting performance issues in SQL objects

Created Request for Change (RFC) for Change Management Request (CMR) for moving database/ tech changes from Development to Testing and to Production during sprints.

Designed and developed various complex reports for customer service team. Generated reports that can handle dynamic grouping and dynamic sorting.

Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, using defined objects, chart.

Scheduled reports with the help of standard/data-driven subscriptions in SSRS.

Designed, deployed, and maintained various SSRS Reports in SQL Server/ Report Manager.

Created custom reports using global variables, expressions, and functions in SSRS.

Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and chart.

Design and implementation of print optimized reports in SSRS.

Developed various dashboards utilizing Power BI with multiple scorecards such as average BOM processing times, sales trends, processing costs

Monitor data refresh into the data warehouse from various source systems, as well as into Power BI.

Supported architecture team in long-term planning and implementation. Also supported operations and assisted with troubleshooting activities as needed.

Environment: MS SQL Server 2017, SQL Server Management Studio, SSIS, SSRS, JIRA, Visual Studio, ZAP BI, Microsoft Dynamics AX, MS Excel, Power BI, Teradata, Team Foundation Server, MS Access, and Windows.

SQL BI Developer Jan 2017 - Mar2018

Gilbarco Veeder-Root, NC

Responsibilities:

Performed the process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.

Involved in the team that migrate the data from Teradata and SQL Server to snowflake.

Created excel live views for business and auditing purposes.

Developed SSIS packages to extract transactional data from Teradata and load them into SQL server.

Creating SSIS Package Configurations and maintaining their tables by editing the values of the variables as per the requirement.

Worked on re-design of the few SSIS Package which involved very complex logic and more than a 100 tables and tasks and developed simplified version of the Packages.

Experience in writing Teradata SQL Scripts for loading data to a hierarchical data model.

Strong experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata.

Created Metadata, created Data Lineage and overall, Data Quality Management. Performed data validation by utilizing Python and experience on Data Governance.

Troubleshooting and optimized the performance of queries with modification in T-SQL, normalized tables, established joins and utilizing SQL Profiling, execution plan, database engine tuning advisor.

Analyzed the current legacy code and converted to Snowflake code by reviewing the business intent.

Developed test cases to identify completeness and accuracy of the data.

Performed cell level validations using advanced excel and python to ensure 100% accuracy.

Created the presentation layer for Tableau Report.

Worked on SSIS Script component using Visual Basic Applications and C#, by creating generic C# components that can be used in the external packages in SSIS.

Automate SSRS data audit reports and source - destination reports.

Prepared the metadata and lineage documentation for the metrics created.

Partnered with Data Engineering teams to migrate code to production by leveraging GitHub.

Environment: MS SQL Server 2012, SQL Server Management Studio, SSIS, SSRS, Visual Studio, JIRA, MS Excel, Teradata, Team Foundation Server, MS Access, and Window 7.

SQL Developer Jun 2015 - Dec 2016

Sherwin Williams, OH

Responsibilities:

Monitor and build SQL reports supporting the new ERP Implementation.

Responsible for migration and re-design of legacy reports into new Oracle SQL environment.

Created partitioned tables and partitioned indexes to improve the performance of the applications.

Delivered statistical information through reporting to forge business decisions.

Improved database performance closely monitored usage and storage space.

Created PL/SQL packages to extract and transform legacy data.

Created new Procedures, Functions, Triggers, Materialized Views, Packages, Cursors,

Dynamic SQL, Table functions as part of Project/Application requirements.

Implemented all modules logic by using Triggers and Integrity Constraints.

Created Test Cases and Activity Diagrams, systems Flow Charts.

Contact this candidate