Candidates About

 

Vijay Kumar

SQL BI Developer/SSIS/SSRS/SSAS

·         Around 8 years of experience in Database design, data analysis and developing Business Intelligence using Microsoft SQL Server Analysis Services, Reporting Services and Integration Services.

·         Experience in writing complex T-SQL queries, Sub-queries, Dynamic SQL queries.

·         Knowledge and work experience in RDBMS concepts, Views, Triggers, Stored Procedures, User defined functions, Indexes, and Constraints.

·         Experience in development of Data Warehouse for both dimension tables and fact tables by initial load/ongoing load process using SCD/Merge/CDC, Parent/Child SSIS packages.

·         Experience with Normalization and De-normalization processes.

·         Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.

·         Experience in working with ETL operations between different sources like Oracle/Access/Excel etc., using SSIS, DTS.

·         Excellent in creating SSIS Packages for integrating data using OLE DB connection from various sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

·         Excellent hands on managing and automating Control flow, Data flow, Events and Logging programmatically for SSIS packages.

·         Hands on experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

·         Experience in creating the configuration files to deploy the SSIS packages.

·         Worked with report manager for deploying the reports across all the environments and intensively on Microsoft Office SharePoint Server (MOSS).

·         Extensive experience in developing several details, summary reports, trend analysis reports, sub reports using SQL Server Reporting Services(SSRS)

·         Hands on experience in generating complex reports such as Parameterized, Drilldown, Drill through, Cascaded, Matrix reports using SSRS.

·         Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.

·         Experienced in Qlik View Server and Publisher maintenance for Creating scheduled jobs for QVD extracts and report reloads

·         Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.

·         Expert in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.

·         Expertise in creating a Power Pivot data model for extremely fast aggregation and calculation.

·         Performed Technical Documentation for functional and business requirements.

·         Welcomes responsibility, executes multiple tasks at once, identifies and allocates resources appropriately.

·         Adaptability, Good team player, problem solving, communication skills combined with self-motivation and total commitment to the organization goals.

 

       Degree: Bachelor’s in Technology from JNTU, Hyderabad.

 

 

Databases	SQL Server 2016/2014/2012/2008R2, 2005 & 2000/7.0, MS-Access 2000/2003, Oracle 11g/10/9i, DB2
BI Tools	SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), BIDS, Tableau 6.1, Data Transformation Services (DTS), Visual Studio, OLAP, ETL, Crystal Reports, MS SharePoint Server 2008, QlikView 11.
Tools/Database Utilities	SQL Server Management Studio, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, XML, Power Pivot, Microsoft Office, Excel, Business Intelligence Development Studio (BIDS), Power BI Desktop , Excel Data Explorer, Microsoft Office Suite, Visual Source Safe.
Database Design Tools	ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, Fact & Dimension tables, De-normalization techniques, Kimball & Inman Methodologies
Languages	T-SQL, PL/SQL, Dynamic SQL, .NET, HTML C, C++, C#, UNIX, MDX, Visual Basic 6.0

 

Prospect Medical, Orange, CA                                                                                           Mar 2017 – Till Date

Sr. SQL Server BI Developer/SSIS/SSAS/Power BI

 

Responsibilities:

·         Responsible for coding SSIS processes to import large volumes of data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources (SQL Server, Oracle).

·         Analyzed long running queries and tuned the same to optimize application and system performance.

·         Upgrading and Installation, creating and managing databases, integrating MS SQL Server and upgrading SQL servers to 2016.

·         Extensively used SQL Server tools like Query Analyzer, Enterprise Manager, Profiler and Management Studio.

·         Hands on experience in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to assist efficient data manipulation and data consistency.

·         Convert the DTS packages to the SSIS packages.

·         Involved in validating and fixing the SSIS 2016 packages during migration from DTS packages.

·         Worked on the fixing the bad data in Legacy Tables in batches, Created a logic to validate the data before loading to the clean table and bad data will store in the separate table and in Excel Report and notify by emails and using expressions in SSIS Packages.

·         Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

·         Created detailed dashboards and Power BI Visualizations utilizing Microsoft Power BI desktop to improve analysis and decision making.

·         Created measures, calculated columns, conditional column, custom columns in Power BI. 

·         Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to Power BI Service.

·         Use DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.

·         Created groups, roles, users and assigning access privileges to users.

·         Created user defined data types and added them to model database for future purpose.

·         Setting up database backup and recovery procedures for production, development and staging.

·         Implemented and introduced control process, security policies and procedures.

·         Coordinated with back-end .net programmers in writing stored procedures, implemented referential integrity by using triggers, performance and tuning.

·         Developed a robust ETL process to extract data from internal databases, transform it as per the business requirements and load it into Essette (newly adapted application) database majorly utilizing SQL server BI tools SSIS.

·         Designed and implemented comprehensive Backup plans and disaster recovery strategies.

 

Environment:

SQL Server 2012/2016, SSIS (2012), Power BI Desktop, VB.Net, Visual Studio (2012/2015), C#, Team Foundation Server 2013, Visual Source Safe.

 

Epson, Long Beach, CA                                                                                                       Jan 2016 – Feb 2017

Sr. SQL Server BI Developer/SSIS/SSRS/Power BI

 

Responsibilities:

• Assisted with the design, implementation & support a multi-terabyte point-of-sale Data warehouse, performing Database design, implementation, creation & tuning of Data Aggregation mechanisms.
• Knowledge in designing and developing Data Warehouses, Data marts and Business  

               Intelligence using multi-dimensional Data models such as Star Schemas.

• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.

·         Worked on Data modeling as part of building databases using Database Diagrams in SQL Server management studio.

·         Worked on implementing Client Onboarding process steps as part of ETL from All scripts Pro & touch works source systems to our Centralized Data warehouse using SSIS.

·         Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.

·         Worked on different types of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion, when creating SSIS packages to satisfy the business requirements.

·         Worked on Error handling mechanisms by using Event Handlers for different executable in SSIS packages.

·         Created SSIS packages for File Transfer from one location to the other using FTP task.

• Created shared Data sources and developed data models to create Ad hoc Reports.
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS)

·         Developed various operational Drill-through and Drill-down reports using SSRS. 

·         Designed and implemented parameterized, cascading parameterized reports, Sub Reports using SSRS. 

·         Scheduled the delivery of various SSRS reports utilizing standard and data-driven subscriptions..

• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs. 
• Wrote calculated columns, Measures query's in power bi desktop to show good data analysis techniques.
• Scheduled Automatic refresh and scheduling refresh in power bi service.

·         Connected to different various data sources like SQL Server, Oracle, SAP BW and flat files to create and schedule different complex reports.

·         Managed reports/data sources, schedule report execution, and delivery.

 

Environment:

MS SQL Server  2014/2012, SSIS(2012), SSAS, SSRS(2012), Power BI Desktop,  Visual Studio 2012/2010, C#, MS Excel, Oracle 10/11 PL/SQL, Teradata.

 

 

UHG, Minneapolis, MN                                                                                  Jun 2013 – Dec 2015                    SQL/ SSIS/Tableau Developer

 

Responsibilities:

·         Responsible for writing T-SQL code for creating cursor and handling the data validations.

·         Developed complex T-SQL code for the application.

·         Managed indexes, statistics and optimized queries by using execution plan for tuning the database.

·         Experience in SDLC (Software Development Life Cycle) like gathering requirements, design, development, implementation and testing of projects before moving to production.

·         Successfully migrated SSIS packages from development to test to Production environments using SSIS Configuration files and Deployment Wizard.

·         Extracted Data from various Databases such as SQL and Teradata database, flat files to SQL server using SSIS.

·         Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server, for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

·         Used various SSIS transformations such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into Production tables.

·         Scheduled SSIS packages for running monthly and weekly feeds from various departments and multiple servers and resources to Development Servers.

·         Used SSIS to create ETL Packages to validate, extract, transform and load data to Data warehouse databases, Data mart databases.

·         Managed and performed all technical functions associated with ETL, database management and BI reporting within enterprise-wide data warehouse under Epics reporting data model.

·         Also trained on the GE IDX system. 

·         Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.

·         Developed cubes by defining data sources and data source views and using SQL server Analysis Services (SSAS).

·         Created MDX queries to extract data from the Data Mart

·         Responsible to develop reports and dashboards using Tableau Desktop and publish them using Tableau Server.

·         Responsible to analyse and solve the data related issues in Tableau Dashboards

·         Responsible in Tableau Desktop and Server upgrade activities. 

·         Expert in using tools like MS SQL Profiler, Database Engine Tuning Wizard, Windows Performance Monitor and tuning SQL Server performance.

·         Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.

 

Environment:

SQL Server 2008 R2 Enterprise Edition, SQL, Enterprise manager, SSIS, Tableau 6.1, MS Access, VB.NET, Team Foundation Services.

 

Nationwide Insurance, Columbus, OH                                                                             June 2012 - May 2013                         

MS SQL Server /SSIS/SSRS Developer

 

Nationwide is a group of Insurance and Financial services companies.Worked as a report developer for financial Sector.

 

Responsibilities:

• Created SQL Server Reports using SSRS 2008.
• Identified the Data Source and defined them to build the Data Source Views.
• Developed Query for generating drill down reports in SSRS 2008.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2008.

• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Responsible for transferring the data using SSIS packages.
• Developed, monitored and deployed SSIS packages.
• Analyzed reports and fixed bugs in stored procedures.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Implemented different types of constraints on tables.
• Designed and applied entity and attributes description and definition for the models.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.

• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Monitored Scheduled jobs and alerts.

 

Environment:

MS SQL Server 2008 Enterprise Edition, MS SQL Server Reporting Services 2008, Erwin 4.1, Windows Server 2007, MS SharePoint Server 2008.

 

Innovative Minds, Hyderabad, India                                                                                  Oct 2011 – May 2012   

SQL Server Developer/SSRS/SSIS/T-SQL  

 

Responsibilities:

·         Used Workforce Central Management 6.1 version tied the SQL Database to the workforce management by using SSMS and verified the created 120 SSRS reports from user perspective to make sure right amount of data is processed.

·         Developed the reports using stored procedures by adding variables such as Language translation and Time zone by considering different scenarios according to business requirement and Executed to get the required output.

·         Worked on RDL’s of the reports and promoted those RDL’S to WFC portal.

·         Responsible for Debugging reports using Stored Procedures.

·         Created Cross-Tab, Drill-down, Drill-through, Parameterized and Sub-Report using RDL.

·         Promoted RDLs to Reporting Service Server.

·         Generated Reports using Global Variables, Expressions and Functions for the reports.

·         Evaluate current reporting infrastructure to find bottlenecks and recommend improvements.

·         Responsible for creating/migrating undocumented crystal/SSRS reports.

·         Created and modified efficient Stored Procedure and functions which implement necessary business logic to support the front end application to facilitate pulling data.

·         Developed and optimized stored procedures using input, output, table valued parameters and Query Analyzer.

·         Create new SSIS Packages to export flat file for customer.

·         Created and executed SSIS packages to populate data from the various data sources for different data loading operations for many applications.

·         Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

·         Created package to transfer data between OLTP and OLAP databases.

·         Assisted front-end C#.NET and ASP.NET developers using Visual Studio 2008 (C#, ASP.NET).

 

Environment:

SQL Server 2008, BIDS, SSIS, SSRS, Crystal Reports XI, Visual Studio, T-SQL, C#.NET, ASP

 

 

Pinnacle Blue Cyber Technologies, Hyderabad, India                                                     Sept 2010 – Oct 2011 SQL Server SSIS Developer

·         Developing T-SQL queries, triggers, functions, cursors and stored procedures.

·         Responsible for logical and physical design of SQL Server databases.

·         Used DDL and DML for writing triggers, stored procedures, and data manipulation and created views to   restrict access to data in a table for security.

·         Expert in extracting data using SSIS from OLTP to OLAP.

·         Performed Bulk data migration using DTS and SSIS from flat files.

<span style="font-size:12pt;font