Business Intelligence Sql Server

Vikas Rohilla Address: **-** Colden Street

Mobile: +1-929-***-**** Apt-15G, Flushing

*********@*****.*** New York, US

Professional Overview

I am aspiring to obtain a challenging and rewarding position in a dynamic Organization where my education and experience will be in tandem with the company goals.

Good communication skills with proficiency in grasping new technical concepts and utilizing the same in a productive manner. Efficient team player organized and well-structured at work is count as my strength.

I have started working as Oracle PL/SQL Developer and worked on multiple projects and then changed my technology with moving trend towards Business Intelligence and working on MSBI tools since then.

Technical Responsibilites

MSBI and Oracle Certified Associate with over 16+ years of experience in Designing SSIS Packages, Creating Reports and Database development using T-SQL and PL/SQL.

Writing and testing complex SQL queries to extract data from source systems and perform complex transformations.

Developing and maintaining database objects like tables, views, indexes, and sequences.

Massive expertise in writing packages, stored procedures, triggers & queries using joins using T-SQL and PL/SQL.

Designing and developing ETL packages to extract data from multiple sources, transform it into a format suitable for analysis, and load it into a data warehouse or other destination using Microsoft SQL SERVER Integration Services (SSIS).

Performance tuning and optimization of ETL processes to ensure efficient and timely data delivery.

Troubleshooting and resolving issues related to data integration and ETL processes.

Experience in designing customized reports using Microsoft SQL SERVER Reporting Services (SSRS).

Conduct Change Management assessments and statistical analyses to improve efficiency and effectiveness of code.

Extensive Experience in Code Optimization to achieve performance enhancements . Exclusive debugging and troubleshooting skills.

Experience in creating and implementing physical databases from logical data models.

Responsible for collaborating with business for gathering requirement and documenting the technical specification for providing

I also handle complex customer issues and escalations, ensuring timely and effective resolution within designated SLA.

Collaborate with other vendors to provide a seamless customer experience and achieve business objectives.

I am responsible to build and maintain relationships with stakeholders, including customers, and team members. This may involve communicating with them on a regular basis, providing updates on the progress of the project, and addressing any concerns that they may have.

Experience with managing DB Scripts on Configuration Management System [CVS/SVN]

Experience in designing Data Models using ERWin Tool

Being a senior team member, I mentor junior team members and help them with technical expertise

Basic knowledge of Machine Learning using Python Programming language

Certifications

Microsoft Certification

Microsoft Business Intelligence (MSBI)

ORACLE Certification (ORACLE Certified Associate)

Introduction to Oracle 9i SQL.

Programming with PL/SQL.

SKILL SET

Languages

T-SQL, PL/SQL

Databases

SQL Server 2019/2016/2014/2012/2008 R2/2005, MySQL, Oracle 9i, Oracle 10

IDEs

Visual Studio, SQL Server Data Tools, Business Intelligence Development Studio, SQL Server Management Studio.

Operating Systems:

Windows XP/Vista, Windows 7/8/10/11, VM

Reporting Tools:

Integration Services (SSIS), Reporting Services (SSRS), SQL Service Analysis Services (SSAS), Informatica, Power BI, Crystal Reports,

Domain

Fast Moving Consumer Goods (FMCG), Airport Security System

Version Control Tool

TortoiseSVN

ITIL Tools

Service Now, TEC Now

Other Tools

MS Office, MS Project, SQL Profiler, SQL Enterprise Manager, Query Analyzer

ORGANISATIONAL EXPERIENCE

Organization

Start Period

End Period

Tata Consultancy Services

Oct-14

Till Date

CMC Ltd

Jul-07

Sept-14

Current Assignment:

Port Authority New York New Jersey Apr’22 – Till Now.

Sr. SQL BI Developer

Responsibilities:

Collaborated with business to thoroughly understand project requirement and conducted detailed requirement analysis. Led the design and implementation of technical architecture for the project.

Managing co-ordination of the partners and working groups engaged in project work.

Monitored the progress of the project closely, tracking milestones and timeliness and provided regular updates to customer.

Resolving cross-functional issues at project level.

Working closely with users to ensure the project meets business needs.

Involved in Agile methodology by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems, completed work in designated time period.

Developed the ETL strategies to load the data from different sources into warehouse.

Involved in creating complex stored procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.

Used various transform in SSIS to load data from flat files and Excel files.

Create and maintained logins, roles and permissions on the SQL instance and databases and provide required privileges according to user’s requirements.

Work and lead the team in all phases of project development.

Created custom packages to load slowly changing dimension tables (for type 2 and type 3 loads.

Wrote Parametrized Queries for generated tabular reports, Formatting report layout, creating reports using Expression, functions, sorting of data, defining data source and datasets, calculating subtotals and grand totals for the reports using SSRS tool.

Involved in developing new reports and Changes in Existing report from data warehouse.

Improved the performance of SSRS reports by tuning the stored procedures and T-SQL queries using various join conditions.

Improving Performance by index creation, index removal, index modification, file group modifications, and adding scheduled jobs to rebuild/reorganize and update statistics in databases.

Deploying and troubleshooting the SSIS Packages.

Given recommendations on database products, services, protocols, and standards.

Environment: Microsoft SQL Server 2016, TSQL, SSMS, SSRS, Crystal Report

Previous Assignment:

PepsiCo International, Project One database Aug 20 – Mar 22.

Sr. SQL BI Developer

Responsibilities:

Collaborated with business to thoroughly understand project requirement and conducted detailed requirement analysis.

Creation of Design Document for the solution definition document. Translation of business requirements into technical specifications.

Wrote T-SQL (DDL and DML) queries, stored procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.

Developed the ETL strategies to load the data from different sources into warehouse.

Developed incremental load solutions into warehouse.

Performed data profiling, data analysis to identify legacy data that needs to cleanse prior to the migrations using SSIS data profiling task, data profile viewer and T-SQL queries.

Implemented advanced data cleansing in SSIS using Derived Column, Fuzzy Lookup, Fuzzy Grouping and worked with various data transformations like Merge, Sort, Conditional Split and Multicast

Worked of migration of SSIS package in 2008 to 2012.

Involved in Performance Tuning of SSIS packages by using Row Transformations, Block and Unblock Transformations

Involved in creating complex stored procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.

Responsible for designing the facts and dimensions for the data warehouse.

Worked and lead the off-shore team in all phase of project development.

Involved in supporting and developing new reports from data warehouse.

Migrating the two different databases in one data warehouse.

Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly, and monthly loads

Created SSIS packages by using various Transformations, Containers to import and export data.

Environment: Microsoft SQL Server 2016, TSQL, SSMS, SSRS, VB.Net, Tortoise SVN

PepsiCo India, Project Route Performance Management Apr’19 – Jul 20

SQL BI Developer

Responsibilities:

Participated in requirement gathering and analysis working with the business analysts and the PM team.

Responsible to create detailed design and technical specification documents.

Worked with T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Primary Keys Foreign Keys.

Migrated data from legacy system text-based files, Excel spreadsheets, and Access to SQL Server databases using DTS, SQL Server Integration Services SSIS to overcome the transformation constraints.

Created SSIS packages to validate, extract, transform and load data to data warehouse databases.

Worked with SSIS tool suite, designed, and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and derived Column.

Created TSQL stored procedures, functions, etc. and tuned them using query analyzer and explain plans.

Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.

Developed many Tabular Reports, Matrix Reports, Drill down Reports, and Dropdown Reports, Sub Reports using SQL SSRS 2010/2012.

Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.

Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly, and monthly loads.

Environment: Microsoft SQL Server 2008 R2/2016, TSQL, SSMS, SSRS, VB.Net, Tortoise SVN

PepsiCo India, Project GST Implementation Dec’18 – Mar’19

SQL BI Developer

Responsibilities:

Worked with business users, business analysts, IT leads and developers in analysing business requirements and translating requirements into functional and technical design specifications.

Worked with T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Primary Keys Foreign Keys.

Create database objects schemas, Tables, Indexes, Views, User defined functions, Stored Procedure, Constraints and Rules.

Developed complex store procedure using SQL and Dynamic SQL having good performance.

Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.

Managed project version and source code changes by check in and checkout using source control tool like visual source safe.

Developed Sub-reports, Parameterized reports, drill down report using SSRS.

Used complex expressions to calculate KPI’s, groups, parameterize and format of the report.

Maintained SQL scripts for creation of database objects.

Work with Application developer to support development activities and archive optimal efficiency.

Monitoring and scheduled existing and new jobs on production environment.

Environment: Microsoft SQL Server 2008, R2, TSQL, SSMS, SSRS, VB.Net, Tortoise SVN

PepsiCo India, Project Claim Automation Distribution Jan’17 – Nov’18

SQL BI Developer

Responsibilities:

Involved in complete Software Development Life Cycle SDLC process by analyzing business requirements and understanding the functional workflow of information from source system to destination system.

Used ETL SSIS to develop jobs for extracting, cleaning, transforming, and loading data in data warehouse.

Create new database objects such as Tables, Views, Indexes, Functions, and Triggers using T-SQL in Development and Production environment for SQL Server.

Develop jobs for extracting, cleaning, transforming, and loading data in data warehouse.

Involved in designing, developing, and deploying reports in MS SQL Server environment using SSRS 2008 and SSIS in Business Intelligence Development Studio BIDS and SQL Server Data tools 2008.

Extensively used SSIS transformation such as Lookup, Derived column, Data conversion, aggregate, condition split, SQL task, Script task and Send Mail task etc.

Performed operations like Data reconciliation, Validation, and error handling after Extracting data into SQL Server.

Wrote Parametrized Queries for generated tabular reports, Formatting report layout, creating reports using Expression, functions, sorting of data, defining data source and datasets, calculating subtotals and grand totals for the reports using SSRS tool.

Creating Tabular Reports, Matrix Reports, Drill down Reports, and Dropdown Reports, Sub Reports using SQL, SSRS.

Creating reports using SQL Reporting Services SSRS for customized and ad-hoc Queries.

Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly, and monthly loads.

Performed database health checks daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor on Development and UAT environments.

Environment: Microsoft SQL Server 2008, R2, T-SQL, SSMS, SSRS, VB.Net, SQL Server Management Studio, Business Intelligence Development Studio BIDs.

PepsiCo India, Supply Chain Management Jan’16 – Dec 16

SQL BI Developer

Responsibilities:

Collaborated with business to thoroughly understand project requirement and conducted detailed requirement analysis.

Creation of Design Document for the solution definition document. Translation of business requirements into technical specifications.

Developed ETL programs using informatica to implement the business requirement.

Develop the mapping using needed transformation in informatica tool according to technical specifications.

Create new mapping using various tool in informatica designer like source Analyzer, Warehouse designer, Mapplet designer and Mapping designer.

Wrote T-SQL (DDL and DML) queries, stored procedures and used them to build packages.

Changes in Existing Package as per the requirement.

Involved in creation of dimension and fact tables based on the business requirements

Create new database objects such as Tables, Views, Indexes, Functions, and Triggers in Development and Production environment.

Optimizing performance tuning at source, Target mapping and session level.

Automated the informatica Package for daily, weekly, and monthly loads

Environment: Oracle 10G, Oracle 10G Report builder, Informatica 8.6.1

PepsiCo India, Sales Automation Management Feb’12 – Dec 15

SQL BI Developer

Responsibilities:

Worked with business users, business analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.

Responsible of implementing the ETL Extract Transform and Load process.

Responsible for creating new Packaging and maintaining exiting SSIS packages which is used for data load.

Developed SSIS packages to export data from Excel Spreadsheets to SQL Server, automated all the SSIS packages and monitored errors using SQL Job daily.

Used ETL SSIS to develop jobs for extracting, cleaning, transforming, and loading data in data warehouse.

Create new database objects such as Tables, Views, Indexes, Functions, and Triggers using T-SQL in Development and Production environment for SQL Server.

Worked closely with the team in designing, developing and implementing the logical and physical model for the Data mart.

Identify and resolve database performance issues, database capacity issues and other distributed data issues.

Wrote Parametrized Queries for generated tabular reports, Formatting report layout, creating reports using Expression, functions, sorting of data, defining data source and datasets, calculating subtotals and grand totals for the reports using SSRS tool.

Creating Tabular Reports, Matrix Reports, Drill down Reports, and Dropdown Reports, Sub Reports using SQL, SSRS.

Created custom packages to load slowly changing dimension tables (for type 2 and type 3 loads).

Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly, and monthly loads.

Developed SQL queries to fetch complex data from different tables in remote database using joins and formatted the result.

Environment: Microsoft SQL Server 2008, TSQL, SSMS, SSRS, ASP.Net, SQL Server Management Studio, Business Intelligence Development Studio BIDs, T-SQL, MS Excel.

Delhi Govt. India, VAT (online Application) Sep 10 – Jan 12

SQL Developer

Responsibilities:

Responsible for preparing the requirement, specification and technical documents and reviewing the documentation.

Creates script to Create new tables, views, queries in the application using SSMS tool.

Worked on SQL server development including writing T-SQL Queries and creating SQL server object like Procedure, User-defined function, Views, Triggers

Extensively used joins, CTEs, Table Variables, Global and Local temp tables.

Created views to retrieve data from one and more tables.

Creating index on existing table and update the existing indexes over a period of time.

Finding bottle necks in queries and stored procedures and fine tuning.

Testing the bug fixing before moving the application to production.

Effectively handled hacking and SQL injections attacks on database application.

Environment: Microsoft SQL Server 2005, T-SQL, PHP, SQL Server Management Studio, ASP.NET, MS Excel, Text Pad. Window XP/2003

Delhi Govt. India, Value Added Tax Jul 07 – Aug 10

Oracle PL/SQL Developer

Responsibilities:

Worked with business users and developers in analyzing business requirements and translating requirements into functional and technical design specifications

Involve in the continuous enhancement and fixing of production problems.

Creates script to Create new tables, views, queries for new enhancement in the application using PL/SQL developer.

Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, SQL*Trace.

Extensively involved in using hints to direct the optimizer to choose the optimum query execution plan.

Used Bulk Collections for better performance and easy retrieval of data.

Creation of database objects like table, view, materialized views, procedures and packages using oracle tool like Toad, PL/SQL developer and SQL*Plus.

Create new database objects such as Tables, Views, Indexes, Functions, and Triggers using T-SQL in Development and Production environment for SQL Server

Environment: Oracle 10G, Oracle 10G Report builder, informatica, SQL*Plus, TOAD, SQL developer, UNIX, Windows XP.

Academic History

Completed Bachelor of Engineering in Computers Science from Institute of Engineering & Technology College from Dr. Bhim Rao University, Agra, India in 2005.

Contact this candidate