Vinay

Email: ad4s20@r.postjobfree.com Phone: 832-***-****

Around 7 years of IT experience in SQL Server development, SSIS development, Database Modelling, Data Analysis, Design, Testing, and support of MS SQL Server in production.

Experience with all stages of software development life cycle (SDLC), Agile/Scrum and Project management methodologies.

Involved in Requirements gathering/analysis from business users, performing data mappings and documentation.

Experience in working with different RDBMS and NoSQL DB such as Oracle, MS SQL Server etc.

Experience in Power BI for designing Interactive Reports with multiple drill though pages and visualization using DAX, M query in Power Query.

Configured Dynamic Row Level Security (RLS) to provide secured data access to wide range of users using UPN (User Principal Name).

Configured Static Row Level security (RLS) to create multiple roles with different sets of rules to provide secured access to wide range of users.

Created and maintained Azure Active Directory groups (AAD groups) to provide secured access to the reports/workspaces.

Created a Power BI app to provide access to different views or reports to different users under a single workspace.

Created complex DAX measures and calculated columns to support business needs.

Created paginated reports using Power BI report builder using cloud and on-premises data sources.

Strong experience in developing and debugging SSIS packages.

Experience in designing ETL data flows, creating mappings/workflows to extract and migrate data from various heterogenous sources like flat files, CSV, Excel, MS Access, Oracle, XML, and various RDBMS using SQL Server Integration Services (SSIS).

Expertise in writing SQL Queries, Dynamic-queries, sub-queries, Stored Procedures, Triggers, User-defined Functions, Views, Indexes, Triggers and Cursors.

Experience in generating complex Transact SQL (T-SQL) queries, Sub queries, Dynamic SQL queries, DML, DDL involving multiple tables and exception handlers.

Experience in creating, updating clustered and non-clustered Indexes to keep up the SQL Server Performance

Experience in creating and managing indexes to achieve better query performance, and expertise in performance tuning and query optimization.

Extensive experience using Microsoft SQL Server Reporting Service (SSRS) with report designer, report manager and report server for generating drill down, drill through, parameterized reports, Cascaded reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS.

Proficient in generating reports and Dashboards with Quick filters, Parameters and sets to handle views more efficiently.

Self-motivated to take responsibility and contribute to be a productive team member. Strong team building, mentoring skills, and excellent leadership capability.

Excellent communication and inter-personal skills.

Reporting tools

Power BI Desktop, SSRS, Excel

Programming Languages

TSQL, PL/SQL, Java

RDBMS

Oracle 9i/10g/11g, MS SQL Server 2014/16, MS Access, Teradata

Methodologies

Agile Modeling, Scrum Model, SDLC model,

Machine Learning

Linear Regression, SVM, KNN, Naïve Bayes, Random Forest, SVM, Logistic Regression, K-means Clustering

Statically Programming Languages

Python, R

Client: State of Tennessee, Nashville, TN Nov 2021 – Present

Power BI Developer

Responsibilities:

Gathered, analyzed, and requirements from business users to provide interactive and insightful reports.

Involved in creating Views and Stored procedures for the purpose of complex business reports.

Worked on creating, managing, and optimizing performance for Views, Procedure, Triggers, Table and Functions.

Involved in sprint/scrum meetings, daily standups, and release planning sessions.

Used Data Analysis Expression Language (DAX) for creating different calculated measures, columns in Power BI Desktop for complex business requirements.

Performed Power BI Desktop Data modeling, which cleans, transforms, mash up Data from multiple sources.

Configured gateway to refresh and schedule refreshes for reports in Power BI service thereby showing real-time ServiceNow reports for users.

Created paginated reports using Power Report Builder.

Performed wide variety of data transformation using M query in Power query to transform the source data into desired format required for reporting.

Created Static, and Dynamic Row Level Security roles using UPN to provide secured access to the data in the report for huge number of business users.

Created and maintained Azure AD groups to provide access to the report and security to the data for business users.

Acted as Power BI admin to create, maintain, and provide access to workspaces in Power BI Service.

Cleaned and maintained workspaces and reports to get rid of decommissioned reports and dashboards by using promotions to endorse the reports.

Implemented report certification to make sure all reports are up to the organization standards.

Following the best practices and up to date technology user Experience (UX) viz and dashboards.

Environment: MS SQL Server 2016/2012, SSIS/SSAS/SSRS, T-SQL, Visual Studio 2012/2015/2017, C#, SQL Server Profiler, Power BI, Power Query, SSMS, Business Objects, SharePoint 2012.

Client: Health Stream, Nashville, TN Aug 2020 – Nov 2021

Power BI Developer

Responsibilities:

Developed and maintained ETL mappings for loading fact tables, aggregate fact tables, SCD and staging tables.

Gathered, analyzed, and documented requirements for generation of reports and ETL development.

Involved in creating Views and Stored procedures for the performance of the complex business reports.

Developed SSIS templates which can be used to develop SSIS packages such a way they can be dynamically deployed into Dev, Test, and Production Environment.

Executing data validation stored procedures in SSIS packages using Business Intelligence Development Studio.

Employed many Slowly Changing Dimension methodologies to maintain and update historical data.

Created new SSIS packages as per the requirement and assigned SQL Jobs through Job agent. Worked on providing Logging, Error handling for SSIS Packages.

Created SSIS package to Export and Import data from SQL Server to Flat files and Excel files.

Was involved in creation, managing, and optimizing performance for Views, Procedure, Triggers, Table and Functions.

Participated in bi-weekly project quality reviews and escalate any functional quality issues or concerns to PMO.

Involved in sprint/scrum meetings, daily standups, and release planning sessions.

Identify and solve performance bottlenecks in SQL Server.

Tune/optimize SQL queries and indexes.

Used Data Analysis Expression Language (DAX) for creating different calculated measures, columns in PBI Desktop.

Involved in prepping data from Azure Data Lake and Azure SQL database. The data is pulled into the Power BI service for in depth analysis.

Performed tasks in Power BI Desktop like Data modeling, cleaning, transformations, and mash up Data from multiple sources.

Following the best practices and leverage the latest features to provide best user Experience (UX) in reports and dashboards using Power BI.

Environment: MS SQL Server 2016/2012, SSIS/SSAS/SSRS, T-SQL, Visual Studio 2012/2015/2017, C#, SQL Server Profiler, Power BI, Power Query, SSMS, Business Objects, SharePoint 2012.

Client: Global Payments, Atlanta, GA Oct 2019 - Aug 2020

BI Developer

Responsibilities:

Created complex view using functions to fetch required data based on requirements for the reports. Minimized the time, increased the accuracy and efficiency.

Analyzing the client data and providing the legitimate insights over the businesses by creating ad-hoc and ongoing reports was one of the key responsibilities of my job.

Experience in SDLC lifecycle using agile methodology and scrum meetings with team.

Wrote complex DAX for calculated measures and columns, utilizing iterators, Parent-child Hierarchies, and Cardinalities.

Utilized Power BI gateway to keep dashboards and reports up to date with on-premises data sources.

Implemented Row-Level security to feed secure information to wide range of users.

Developed multiple dashboards with Power BI depicting differing KPIs for business analyses.

Adept in design and development of SQL Server Integration Services (SSIS) packages using various control flow task and data flow transformation.

Assisted in ETL processes like Bulk insert, BCP, data conversion, conditional split, merge, and union all.

Interacted with business users to collect and understand Business Requirements.

Translated Business requirements into BI application designs and solutions.

Extensively used set analysis to calculate/aggregate the fact data as per the requirements.

Knowledge of working on Spotfire and Informatica while getting the data from different resources.

Environment: SQL Server 2016/2014/2012, SSIS, SSRS, Power BI, Visual Studio, Excel

Aris Global, India June 2017 – July 2019

BI Developer

Responsibilities:

Gathered requirements and refined business requirements from the Team lead and Manager.

Written SQL queries, complex join condition, and subqueries.

Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.

Effectively interacted with Team in Analysis, Design and Develop database using ERDiagram, involved in Design, Development, and testing of the system.

Involved in the continuous enhancements and fixing of production problems generated in server-side scripts for data manipulation and validation and materialized views for remote instances.

Created indexes on the table for faster retrieval of the data to enhance database performance.

Creating and automating the regular Jobs.

Used SQL profiler to trace out problems in slower execution plans.

Rebuilt Indexes and Tables as part of Performance Tuning Exercise.

Involved in performing database Backup and Recovery.

Worked on Documentation using MS word.

Created complex SSIS packages using data transformations like conditional splitting, fuzzy lookup, multi cast, column conversion, fuzzy grouping, and script components.

Scheduled and monitored SQL Server Agent jobs to run the SSIS packages and stored procedures.

Designed complex packages with error handling and package logging that stores the logging results in SQL table and flat files on error, on warning, on task filed types.

Used SSRS to generate sub-reports, drill-down, drill through and parameterized reports.

Created Dashboards, Tabular, Matrix reports, charts, and graphs as per customer requirements using SSRS.

Customized reports by adding Filters, Calculations, Prompts, Summaries, and Functions. Created reports to retrieve data using Stored procedures that accept parameters.

Environment: SQL Server 2012, SQL Server Management Studio (SSMS), Business Intelligence Studio (SSIS, SSRS), T-SQL, MS Excel.

Client: InfoTech Enterprises Ltd, HYD June 2016 - June 2017

SQL Developer

Responsibilities:

Developed SQL triggers, Stored Procedures, User Defined Functions and Views

Resolved issues in existing code for various modules and adding new functionality upon the requirement.

Worked on workflow optimization to reduce the query execution time for better performance.

Developed scripts for Rules Based Notifications (RDN) for reducing the execution time of existing SQL queries that are used in Java coding.

Designed and implemented data access stored procedures and Triggers for automating tasks.

Developed, Monitored and Deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.

Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.

Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.

Performed job scheduling and alerts.

Resolved any deadlock issues with the databases/servers.

Environment: MS SQL Server 2008, SQL, SSIS (2008), T-SQL, Excel, Visual Studio

SUMMARY

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Contact this candidate