Sql Server Power Bi

GOKULAKRISHNAN KRISHNAN

Email: **********@*****.***

Contact: 786-***-****

SUMMARY:

14+ years of IT experience in database development, design, analysis, support of MS SQL Server 2005, 2008, 2012, 2016 in development, testing and production environments with various business domains like Manufacturing, SCM, Finance, Energy Utilities & Life Science (Intellectual Property).

OLTP, SSIS, SSRS, SQL Server and exposure in SSAS

Exposure in Database Design, Data warehousing & Dimensional Modeling (OLTP & OLAP)

Database model with Snowflake schema (One fact table with multiple dimension table)

Created ER-diagrams and multidimensional data models, reports and diagrams.

Conduct data model reviews with project team members.

Expertise in scripting T-SQL queries, Complex Stored Procedures, User Defined Functions (UDF), Database Triggers, using tool like SQL Profiler.

Experience in Monitoring, Job Scheduling, Troubleshooting, Back Up, Recovery and Restoration in SQL.

Strong experience with analyzing query plans, managing indexes, Performance tuning of complex SQL queries, Normalization and Backup & Restore.

Expert in creating stored procedures for generating reports using SQL Server Reporting Services (SSRS) and expertise in creating complex reports using SSRS.

Automate the SSRS report using Subscription

Experience in creating parameterized, cascading parameterized, drill-down, chart, Indicators, drill-through and sub-reports using SSRS.

Expertise in using global variables, expressions and functions for the reports with immense experience in handling Sub Reports in SSRS.

Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into MSSQL Server

Created few dashboards in Power BI

Worked in power BI with different sources like Excel, SQL, CSV

Experience in working with script task with C# code (Entity Framework & EDMX)

Involved in creating Technical documents and analyzing Functional specification documents.

Experienced in working with Microsoft Visual Source Safe (VSS) and Team Foundation Server (TFS).

Effective in working independently and collaboratively in teams. A proactive learner with a flair for adopting emerging trends and addressing industry requirements to achieve organizational objectives.

Power shell script (have exposure, used for auto backup and restore purpose and sql batch scripts)

Education:

MCA from Madras University in 2004

B.Sc. Computer Science from KCAS Manapparai in 2000

Technical Summary:

Operating System

Windows XP, Windows Server 2003, 2008

Languages

Visual Basic 6.0

ETL Tools

SSIS (SQL Server Integration Services)

Data Modeling

Dimensional Data Modeling, Star Schema Modeling, Snowflake Schema, FACT and Dimensional Tables

Databases

SQL Server 2005/2008/2008R2/2012

Database skills

Views, Cursors, Stored Procedures, Functions, Joins & Performance tuning (Execution plans, SQL profiler), Indexing

Version Control Tools

Visual Source Safe, TFS

Scheduling Tools

SQL Server Job Agent

Reporting Tool

Microsoft-Excel, SSRS, Crystal 8.0

Documentation Tools

MS-Office 2016, Visio, MS Project

Domain Knowledge

Supplier Chain Management (SCM), Energy & Utilities, Life Science (Intellectual Property), Payroll Systems

Experience Summary:

ADP, Elk Grove Village, Illinois Jun 2019 to Present

Role: Senior SQL Developer (SSIS & SSRS)

Project: Celergo

Description: ADP is largest payroll outsourcing providers and it has 60000 clients all over the world.

Responsibilities:

Create and modify SSRS reports (Payroll Invoice, Data Ware house, Custom reports…)

Create SSIS packages to load from various sources like Excel, CSV and Text files to handle various Integration clients like Workday, Oracle, Ultimate, WFN, Success Factors and so on.

Create SQL agent job to run Auto file generation in SFTP path and also run few Automated SSIS package

Performance tuning improvements in existing queries or stored procedures (Lot of improvement done on reports)

Handling Integration clients and creating mapping for new labels (Workday, Oracle, Ultimate, WFN, Success Factors)

Involved in Requirement gathering with client and prepare BRD

Have client call if any technical clarification needed

Creating Index, Views, Complex Stored Procedures, and appropriate User defined functions to implement the business logic.

Created, Maintained & scheduled various reports in SSRS like Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.

Creating complex queries in SQL to fetch data from existing wholesaler distribution center tables.

Technology/Tools: SQL Server Data Tools (SSIS, SSRS)

COGNIZANT TECHNOLOGY SOLUTIONS, Chennai Nov 2014 to Jun 2019

Client: CareSource, Dayton, OH June 2018 – present

Role: MSBI Developer (SSIS & SSRS)

Project: Customer Focus & Claims teams

Description: CareSource is a nonprofit health plan providing member-centric health care coverage to a wide variety of consumers in Ohio, Kentucky, Indiana, Georgia and West Virginia. CareSource is one of the nation's largest Medicaid managed care plans, but today also offers a lifetime of health coverage to more than 2.0 million members including offerings on the Health Insurance Marketplace and Medicare Advantage plans.It is the largest Medicaid plan in Ohio and second largest in the United States. In 2018, the company had reached 2.0 million members in five states.

Responsibilities:

Create SSRS reports for Customer focus and Claims team like (Prompt pay, Adjustment reports, Claim details, NCQA report, Outstanding payment report) – Tablix

Create SSIS packages to load from various sources like Excel, CSV and Text files

Create agent job with SSIS package to run in tidal job tool

Performance tuning improvements in existing queries or stored procedures

Grievance and Appeal dashboard in Power BI to show the Call detail count, Error count, Claim details by Provider, Claim adjustment amount by Member / Subscriber

Involved in Requirement gathering and documenting functional and technical requirements.

Creating Index, Views, Complex Stored Procedures, and appropriate User defined functions to implement the business logic.

Created, Maintained & scheduled various reports in SSRS like Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.

Creating complex queries in SQL to fetch data from existing wholesaler distribution center tables.

Responsible to tune ETL procedures and schemas to optimize load and query performance.

Worked few Power BI dashboard changes

Technology/Tools: SQL Server Data Tools (SSIS, SSRS), Tidal job

Client: Takeda Pharmaceuticals, Deerfield, IL Mar 2017 – May 2018

Role: SQL Developer with MSBI (SSIS & SSRS)

Project: IRIS application

Description: Takeda Pharmaceuticals U.S.A., Inc. (TPUSA) is among the top 15 pharmaceutical companies in the United States. TPUSA was founded in 1998 to accelerate Takeda's global expansion into the U.S. market. We are working for IRIS application, mainly involving in data migration for client data’s and Automation scripts in SQL.

Takeda dealing with IP (Intellectual property) as cases. Each vendor has different Trademarks and Patents. Based on their Patent rights will monitor the IP related information. Basically, IRIS application dealing all IP related information as cases and maintain the family level cases also. It will maintain the rules and laws based on country.

Responsibilities:

Create SQL scripts after migration

AdHoc queries based on client requirement

Performance tuning activities from already delivered procedures

SSRS reports – Created complex reports including Tabular & Matrix report - included HTML tags in reports.

Involved in Requirement gathering and documenting functional and technical requirements.

Creating Index, Views, Complex Stored Procedures, and appropriate User defined functions to implement the business logic.

Created, Maintained & scheduled various reports in SSRS like Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.

Creating complex queries in SQL to fetch data from existing wholesaler distribution center tables.

Responsible to tune ETL procedures and schemas to optimize load and query performance.

Technology/Tools: SQL Server Data Tools (SSIS, SSRS), C#.net (Entity Framework)

Client: Florida Power & Light (FPL), FL Nov 2016 – March 2017

Role: SQL Developer with MSBI (SSIS & SSRS)

Project: FPL

Description: Florida Power & Light Company, the principal subsidiary of NextEra Energy Inc., is a Juno Beach, Florida-based power utility company serving roughly 4.8 million accounts and 10 million people in Florida

Responsibilities:

SSRS reports – Created complex reports including Tabular & Matrix report - included HTML tags in reports

Involved in Requirement gathering and documenting functional and technical requirements

Creating Index, Views, Complex Stored Procedures, and appropriate User defined functions to implement the business logic.

Created, Maintained & scheduled various reports in SSRS like Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.

Using Try Catch to write logic separate action and error handling code

Creating complex queries in SQL to fetch data from existing wholesaler distribution center tables.

Responsible to tune ETL procedures and schemas to optimize load and query performance

Delivering the requirements to the offshore team mates and handled offshore.

Involved in preparing design document, functional requirements & specification document.

Involved in unit testing, system testing and beta testing with customers.

Mentoring team mates at offshore and reviewing their code.

Technology/Tools: SQL Server Data Tools (SSIS, SSRS).

Client: Direct Energy, Chennai Nov 2014 – Nov 2016

Role: SQL Developer with MSBI (SSIS & SSRS)

Project: Direct Energy

Description: Direct Energy is a North American retailer of energy and energy services. The company was founded in 1986. With more than six million customer relationships in Canada and the United States, it is the largest energy and home services retailer in North America. Direct Energy is a subsidiary of UK-based Centrica plc, an integrated energy company.

Responsibilities:

Involved in Requirement gathering and documenting functional and technical requirements.

Creating Index, Views, Complex Stored Procedures, and appropriate User defined functions to implement the business logic.

Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.

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

Experience in creating configuration files to deploy the SSIS packages across all environments.

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Implementation of MS SQL Server 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL.

Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

Developed, deployed, and monitored SSIS Packages.

Created, Maintained & scheduled various reports in SSRS like Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.

Using Try Catch to write logic separate action and error handling code.

Responsible to tune ETL procedures and schemas to optimize load and query performance.

Requirements gathered from clients and documented

Data warehouse concepts like Snowflake schema and Star schema

We have multiple Data marts and Data ware houses

Technology/Tools: SQL Server 2012 (SSIS, SSRS), SQL server, Toad for Oracle & Sybase

SAUDI ARCHIRODON LIMITED, Jeddah, KSA Oct 2013 – Sep 2014

Client: Saudi Archirodon Limited

Role: SQL Developer with MSBI (SSIS & SSRS)

Project: Saudi Archirodon Limited

Description: It is a construction company in Saudi Arabia. They have separate IT division. Earlier version was Foxpro. We newly developed in PHP with SQL server.

Responsibilities:

Created reports using SSRS & Crystal 8.0 & testing the reports based on the test cases.

Created Complex SSRS reports using functionalities like combined queries, sub queries, unions & intersections, slice and dice, drill down, cross tab etc. to help the management to track and lead the initiates to run the process smoothly.

Created SSIS packages to get source from various versions to SQL

Part of the ETL team to get the data loaded in the target systems. (SSIS)

Following the production implementation, I was involved in support & maintenance of the project deliverables. (DTS Defect tracking system, based on tickets)

Technology/Tools: SQL Server Data Tools (SSIS, SSRS), SQL server, Visual Foxpro

ADP SOLUTIONS LIMITED, Chennai Jun 2012- Sept 2013

Client: ADP, Chennai

Role: SQL Developer with MSBI (SSIS & SSRS)

Project: ADP

Description: ADP is MNC doing payroll activities in UK and US.

Responsibilities:

New Development and also Performance tuning activities

Developed Jobs for maintenance in terms of updating statistics, rebuilding indexes, scheduled

Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.

Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.

Experience in troubleshooting SQL Server configuration issues.

SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Worked on SSRS extensively to create and design reports. Used complex expressions to calculate, group, filter, parameterize, and format the contents of a report.

Involved in Report server set up and deploying, configuring and managing reports using Report

Manager and Report Builder.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files and Access)

loaded the data into target data sources by performing different

Technology/Tools: SQL Server 2008 (SSIS, SSRS)

Photon Infotech, Chennai, India Oct 2011 – Jun 2012

Client: Global Scholar, Chennai, India

Role: SQL Developer with MSBI (SSIS & SSRS)

Project: Great Books

Description: I have worked in client place Global scholar. They are doing software for US schools.

Responsibilities:

Involved in creating Stored Procedures and Table Designs

Performance Tuning

Technology/Tools: SSIS, MS SQL Server 2008 and 2005, T-SQL, SSRS, control-m, service now

Involved in the data analysis for source and target systems. Good understanding of DB concepts, Business Intelligence

Experienced in ETL using SSIS. Also, can perform SSIS package support activities.

Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)

Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.

Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (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.

Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.

Experience in Performance Tuning and Query Optimization.

Experience in knowledge management & training.

Proven ability to quickly adapt to customer’s project execution methodology and in building rapport with project stakeholders.

Excellent presentation, analytical, documentation and interpersonal communication skills

Excellent organizational skills including ability to multi-task and prioritize and manage increasingly complex issues.

Technology/Tools: SQL Server 2008 (SSIS, SSRS), ETL, T-SQL

Shipnet Software Solutions, Chennai Sep 2009 to Jun 2011

Client: InchCape Shippings

Role: SQL Developer with MSBI (SSIS & SSRS)

Project: Fleet Systems

Description: It is a big shipping base company and tie up with ISS inchcape. They are doing lot of shipping software.

Responsibilities:

Analyzed the business requirements, designed and developed the Web site.

Rebuilding Indexes and Tables as part of performance tuning exercise

Involved in database object creation like tables, indexes, triggers and stored procedures

Designed Reports in SSRS, using Shared data source and specified data source.

Involved in peer review and peer testing.

Written complex stored procedures and user defined functions, Dynamic SQL meeting the requirement

Created scripts for data transfers

Involved in Requirement gathering and documenting functional and technical requirements

Technology/Tools: SQL Server 2008 (SSIS, SSRS)

Ramco Systems, Chennai Apr 2007 – Aug 2009

Client: Preferred Meal Systems, Pete lien & Songs, Mara Customer Menu

Role: SQL Developer with MSBI (SSIS & SSRS)

Project: Ramco Virtual Works (RVW)

Description: I have involved in 3 projects (Mara Customer Menu, Preferred Meal System & Pete lien & Songs). PMS is a preferred meal system in US. They are dealing foods to schools.

Responsibilities:

Involved in developments like stored procedure, view, functions and Performance tuning activities

Specification analyzes and reviews with peers and doing development.

Mainly involved in Table design

Development/Testing/Scheduling of reports & the building of the functional & design documents.

It involved analyzing all the existing data loads to identify the cause of the performance issue and data inconsistencies and redeveloping the reports.

Technology/Tools: SQL Server 2000 & 2008 (Crystal Reports)

Contact this candidate