Bi/azure Sql Server Developer Resume
Hammonton New, JerseY
SUMMARY:
- Over 15 years of experience in IT Industry working mainly as Azure SQL Server/BI Developer.
- Strong experience in developing Enterprise, Distributed and Web applications using MS - SQL Server, T-SQL, DAX, Power BI, SQL BI, Dashboard.
- Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, and dimensional modelling tools.
- Proficient in writing complex T-SQL (DDL, DML), new features like CTE, Ranking Functions, TOP(n), PIVOT queries.
- Experienced in complex T-SQL programming for writing DDL & DML queries, stored procedures, user-defined functions, Triggers, Cursors, Views setup.
- Experienced in Extracting, Transforming and Loading ETL data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
- Experienced in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures, Creation and maintenance of Databases, creating Roles and managing user permissions.
- Experience in monitoring and tuning SQL Server database performance using SQL Profiler, DMV's, Index Tuning Wizard and Windows Performance Monitor.
- Experience in Database Designing/ Modelling for new applications (OLAP & OLTP systems) and database changes to existing applications.
- Expertise in developing solutions using SSRS, SSIS, Power BI, Cubes and SSAS.
- Implemented complex business logic with User-Defined-Functions, Indexed Views and also created User Defined Data type, Clustered & Non-clustered Indexes .
- Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
- Worked on creating Azure Data Factory for moving and transforming the data and Azure Data Lake Store to capture data of any size, type, and ingestion speed in one single place for different operations.
- Skilled in handling various file types, files encoding and other data ingestion challenges.
TECHNICAL EXPERTISE:
Languages: T-SQL, Python, Java, C#, DAX, MDX
Databases: Azure SQL DB, MS SQL Server 2012, 2014, 2016, 2017, NoSQL, Postgres, Oracle, PL/SQL
Web Technologies: ASP.NET, MVC 3,4, HTML, JavaScript, CSS
ETL: SSIS, Azure DataFactory
IDE tools: MS Visual Studio, Spring Eclipse, STS, JSON
Visualization Tools: Power BI, Power Pivot, SSRS, Logi info
Version Control Tools: Github, Smartgit, Tortoise SVN
PROFESSIONAL EXPERIENCE:
Confidential, Hammonton, New Jersey
BI/Azure SQL Server Developer
Responsibilities:
- Used Azure SQL DB to create, update SQL Tables Stored Procedures, Functions and Views.
- Staged the JSON data into the Azure SQL table using complex T-SQL Queries.
- Wrote Complex T-SQL Stored Procedures that contained the business logic for Order flow, Order combinator, Split Orders
- Wrote SQL Scripts for the underlying logic of the System Management Console which provided User Interface to Exception Viewer, Order Status and Audit Flow consoles.
- Built SSIS solutions to extract, transform and load client’s sales data into Confidential Ordering system to the data warehouse.
- Used Table Valued parameters and User defined Table Types to cater for functionality to the User interface where user can upload an entire SQL table or changes to a table data.
- Created table Indexes and resolved the SQL deadlock issues by tweaking long running queries and focussed on Performance Tuning.
- Completed Integration Testing of every SQL Server Stored Procedure with Azure Logic App calling the module.
- Used GitHub to merge and promote the code changes and as code repository.
- Implemented Azure DB monitoring by getting the health check report of the database instance set up in Dev, QA and Production instance.
- Performed Azure SQL DB Performance testing by pushing up to 1500 Orders to the SQL database simultaneously and ensuring consistent database performance.
Confidential
Sr. BI Developer
Responsibilities:
- Gathered requirements from various business partners of Reach to develop custom T-SQL code implementations for Insight analysis, Sales data analysis and understand the source data complexities for clients such as RB, Colgate, Premier foods, Beiersdorf, J&J.
- Provided forecasting and Loss Sales value information to clients using complex T-SQL Stored procedures and views by joining multiple tables.
- Involved with the implementation of Microsoft Business Intelligence BI platforms including SQL Server Integration Services SSIS, SSRS, SSAS.
- Creating SSIS solutions to extract, transform and load client’s sales data into Reach’s database and data warehouse.
- Designed, built and maintained Datawarehouse for several clients with data consisting of EPOS, Coverage and Response.
- Built and automated the Cube deployment process for several client’s Datawarehouse including nightly refresh process.
- Utilized Azure Data factory to orchestrate data movement and transformation from Various Clients sales data
- Experienced in error handling, debugging, error logging for production support in SSIS.
- Developed different reports such as Sub Reports , Charts , Matrix reports , Linked reports
- Developed various operational Drill-through and Drill-down reports using SSRS.
- Reporting on ROI data, sales data and sales uplift information in custom templates using Power BI visualizations was created and presented to Clients.
- Involved with Query Optimization to increase the performance of the Report
- Experienced working with Azure SQL Database Import and Export Service
- Experienced in Monitoring, Job Scheduling, Troubleshooting, Back Up, recovery and system upgrading.
- Utilized Power BI Report Server to deploy reports on Premises.
- Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
- Underwent GDPR training at Reach to understand the responsibilities behind the complex Client data that I was working with and to understand its security and liability.
Environment: MS SQL Server 2014, MS SQL SSRS, SSIS, SSAS, Visual Studio 2015, Azure, Azure Data factory, Azure Databricks, Power BI, TSQL, DAX, MDX
Confidential
Sr. SQL Server/BI Consultant
Responsibilities:
- Translated complex Business requirements into Functional Specifications by implementing T-SQL code using stored procedures, triggers, views.
- Involved in a full SSIS package life cycle from creating to building, deploying and executing the packages in different environments (for e.g. Development and Production).
- Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
- Wrote PL/SQL code on Oracle 11g database using SQL Developer to create several Stored procedures and queries to implement business logic
- Managed the Datawarehouse of a complex domain of information using SSAS.
- Performed Data Analysis using SQL server and MS Excel to create and analyse data and create reports.
- Designed index and optimized queries by using execution plan for performance tuning of the database.
- Extensively used SSIS transformations such as lookup , merge , derived column , data conversion , conditional split and aggregate for creating SSIS ETL Solution.
- Dealt with Fine-tuning Stored Procedures to improve performance with a Query plan using SQL Tuning advisor
- Documented test plans, test cases, test scenarios and performed the functional testing as per the requirements of the system.
Environment: MS SQL Server 2012, MS SQL SSRS, SSIS, Visual Studio 2012, Oracle 11g
Confidential
Sr. Database Developer
Responsibilities:
- Created Index, Views, Complex Stored Procedures, Triggers, Cursors and appropriate User defined functions to implement the business logic.
- Created System level block diagrams, ER diagrams, Use Case diagrams to articulate the system flow
- Created an End to End process flow highlighting the System, external dependencies, data sources, web services and additional interfaces relevant to the scope of the Project using MS Visio.
- Extensively worked on SSRS and delivered complex reports from different data sources such as SQL Database and Cubes.
- Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
- Wrote SQL queries, procedures and triggers to perform data analysis and quality checks.
- Used SQL Profiler and Index Tuning Wizard for tracing slow running queries and stored procedures
- Developed SharePoint lists to expose the data inside the Ascent CRM through the portal for the management using MOSS and SharePoint Designer.
Environment: MS SQL Server 2010, MS SQL SSRS, SSIS, Visual Studio 2010, MS Sharepoint 2010, MS Dynamics.
Confidential, NJ
BI Developer
Responsibilities:
- Developed and owned the dashboard of suite of reports for Sales and Marketing group.
- Designed, deployed, and maintained various SSRS Reports in SQL Server 2008 R2
- Designed and Maintained SSIS Packages for Importing and Exporting Data Migration and Conversion from Legacy Systems to SQL Server 2005.
- Designed business process flows and enterprise architecture diagrams to depict the key flows for the system using UML diagrams like Use case diagrams, sequence diagrams and collaboration diagrams.
- Created document for Self-Service Deployment and execution process for SSIS packages
- Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
Environment: MS SQL Server 2008 R2, MS SQL SSRS, SSIS, Visual Studio 2008
Confidential, NJ
Programmer/Analyst
Responsibilities:
- Developed the dashboard of Hotel Booking System using Microsoft.Net Framework and Web technologies
- Designed, deployed, and maintained various SSRS Reports in SQL Server 2005
- Designed business process flows and enterprise architecture diagrams to depict the key flows for the system using UML diagrams like Use case diagrams, sequence diagrams and collaboration diagrams.
- Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
Environment: MS SQL Server 2005, MS SQL SSRS, SSIS, Visual Studio 2005
Confidential, Timonium, MD
Programmer/Analyst
Responsibilities:
- Involved in building the Confidential application for UPS
- Worked on building an automation test suite using Rational Robot with Visual Basic.
- Designed, deployed, and maintained various Crystal Reports.
- Designed business process flows and enterprise architecture diagrams to depict the key flows for the system using UML diagrams like Use case diagrams, sequence diagrams and collaboration diagrams.
- Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
Environment: MS SQL Server 2000, Visual Basic