Naveen Kumar Y

Mobile: +91-812******* Email: ac61ep@r.postjobfree.com

Profile Highlights

Software Engineer with a background that spans around 3.8 years in information technology industry with extensive IT operations experience emphasizing Requirements Analysis, Design, Development, Integration and maintenance.

Very good work experience on migration, development and production support.

Good working experience on Banking & finance, Transportation and Energy domain.

Mostly work on MSBI (SSIS and SSRS) with sophisticated technical skills in Design ETL and Reports.

Expertise in SSAS (SQL Server Analysis Services), SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), Power BI and Power Pivot.

Experience in SQL Server Analysis Services (SSAS) including building cubes and writing MDX queries.

Experience designing Real-Time cubes with superior performance.

Automated Deployment of a Data warehouse, Automated processing of Partitions/Cubes.

Extensively involved in T-SQL, procedures, functions, views and implement best practices to maintain optimal performance.

Hands on experience in performance tuning of the queries.

Have Knowledge on configuring the Personal and Enterprise Gateways to Schedule refresh the Power BI Dashboards.

Worked on Power BI administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes in Power BI Service.

Published the Power BI dashboard to different workspaces and provided security to stake holders.

Refreshing the Power Pivot data by manual and schedule refresh.

Good Knowledge in identifying relationship between different aggregates and attributes.

Work with DB developers, MSBI and systems support personnel in elevating and automating successful code to production.

Involved in the deployment process of SSIS/SSRS and MSSQL objects for different environment (SIT/UAT/PROD) and maintaining/monitoring on Higher to lower level environment server.

Worked on optimization in T-SQL programming to optimize Stored Procedures, Functions/indexes.

Good knowledge in DBA Skills (Backup, Restore & SQL Jobs configuration). Database Performance/optimization Tuning, index rebuilding and reorganize etc.

Good at installation and configuration of SQL Server 2014/2016 and SSRS.

Career Graph

INFOSYS, HYDERABAD FROM JAN 2015 TO TILL DATE

Successfully, Implemented ETL Packages to load Data in Data warehouse and optimized OLTP database and design reports on SSRS.

Actively involved in the development/deployment of ETL packages in MS SQL 2014 to load OLTP Data.

Involved in formulated queries in T-SQL in meeting reporting needs.

Formulate Implementation Design/technical document, and mapping document base on business logic.

Benefitted handling brainstorming discussions design, development process and deployment of SSIS projects.

Supporting multiple projects, assigning the tasks to team and being responsible for coordinating with onshore.

Responsible for deciding the goals based on the designation.

Key Projects:

General Electric Energy Management System

Environment: SSIS, SQL Server 2016, and Power BI

Industries Vertical: Energy and Utilization

Client: GE Energy (Georgia), U.S.A

Work Outline:

Involved in reviewing the Investments application and interacting with business users to understand the user requirements.

Gathered user requirements and analyzed and designed software solution and database.

Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.

Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2012.

Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.

Used scripts and variables, email notifications for ETL process using Data Integrator.

Worked on the Power Bi reports & dashboards with SQL Server/Tabular SSAS sources.

Used Table, Matrix, Bar, Card, Gauge, Slicers visualizations.

Worked on Custom Visualizations like multi slicer and Hierarchy slicer.

Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.

Created New Calculated Column and Measure using DAX Expression.

Responsible for implementation of creating complex SSIS packages using proper control and data flow elements with error handling.

Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.

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

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.

Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.

Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).

Designed and Implemented various reports using Crystal Reports and responsible for the migration to SSRS.

Designed and build the OLAP cubes using Star schema and Snow Flake Schema using native OLAP Service Manager.

Stored Procedures, User Defined Functions, Views, TSQL scripting for complex business logic. Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.

Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.

Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.

Used SQL Profiler for troubleshooting, monitoring, optimization of SQL server 2012 and SQL code.

Optimized the database by creating various clustered, non-clustered indexes and indexed views.

Taking Database full Backup, Transaction log backup & differential backup in daily Routine.

Strategic Marketing Implementation Tool (SMIT)

Environment: SQL Server (SQL Server Integration Services 2008 R2 / 2014, SQL Server Database 2008 R2 / 2014, SSRS), SSRS

Industries Vertical: Banking, Financial Services and Insurance

Client: PNC Financial Services (Pittsburgh), U.S.A

Work Outline:

Lead the team of 6 people and responsible for the complete end to end deliverables.

Extensively worked on data migration for the upgrade in extracting, transformation and loading the data from SQL Server into ODS and DWH from SQL Server 2008 R2 to 2014.

Understand Report Specification document.

Designing the reports based on Report Specification document.

Deploying the generated reports on production server.

Generated the reports weekly and monthly wise as per the client requirements.

Published the dashboard reports to Power BI service for navigating the developed dashboards in web.

Created Customized and interactive dashboards using multiple data sources.

It is a broad-range project that contains several visualizations, calculations, ranking, percentages and percentiles, top N and bottom N reports and reviews, scorecards etc

Verifying columns and rows data. Applying Data Source Filters if required.

Creating operational reports, dashboards, and scorecards using Microsoft Power BI like Power Pivot, Excel pivot tables, DAX.

Having Strong Knowledge on DAX Functions like Time and Date Functions, Logic Functions, Aggregate Functions etc.

Responsible for scheduling the reports based on the subscriptions defined.

Generated and formatted Reports using Global Variables, Expressions and Functions, designed and implemented stylish report layouts.

Created drill through and drill down reports.

Responsible for all activities in preparing High Level Design document and Technical Design documents.

Involved in enhancement activities of ODS, DWH & DAX including performance tuning of the ETL’s.

Done performance tuning for the packages.

Worked on Visual Source Safe while creating SSIS Packages.

Wrote Unit Test Cases and done Unit testing after loading the data using SSIS Packages to validate the data quality checks.

Accountable for building Package deployments and package Configurations.

Monitoring Daily SQL Server agent jobs on production server as part of the production support.

Involve in designing the reports with month, weekly and daily home loan metrics for Analytics and Reporting team.

Education summary

B.Tech (Electrical and Electronics Engineering ) from JNTU, Hyderabad in 2013

Personal Particulars

Date of birth: 30th April 1991; Languages Known: English, Telugu and Hindi

Contact this candidate