SUMMARY:

Over * years of extensive experience in IT that includes Database/BI Development and support.

Extensive experience in analyzing, designing, and developing database applications, reports, data analysis using MS SQL Server, SQL Server Integration, Reporting; Analysis Services (SSIS, SSRS, SSAS), and Power BI.

Experience in Data Extraction and Transforming and Loading (ETL) using SSIS packages to manage SQL Server databases and SQL Server objects between instances of SQL Server

Strong in SQL Server DDL, DML skills with an understanding of writing efficient queries and troubleshooting complex queries

Expertise in Enterprise Reporting includes generating reports using linked reports, subreports, and filters, charts in SQL server reporting services (SSRS).

Created Worksheets using Window function, playback functionality, Data Blending and Conditional Formatting. Expertise in generating reports using SQL Server Reporting Services (SSRS) and MS Excel spreadsheets and Power Pivot.

Proficiency in creating different types of reports such as Parameterized, Cascaded, Dynamic, Linked, Drill-through, Drill-down reports, Subreports and formatting them using SSRS.

Expertise in writing complex Transact SQL (T-SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.

Programming in SQL Server - Using the stored procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs) etc.

Experience in tuning the performance of stored procedures and large T-SQL Queries using Clustered indexes, and database activities like maintenance and performance monitoring and tuning using tools such as Index Tuning Wizard, SQL Profiler and other troubleshooting and monitoring tools.

Experience in Data Marts, Data warehouse, Data Modelling like Dimensional Data Modelling, Star Schema Modelling, Snowflake Modelling, FACT and Dimensions Tables, OLTP Relational Schema and OLAP Dimensional Modelling, process/data modeling using Erwin.

Develop Reports using Microsoft Power BI

Trained in Informatica Power center (10.1)

Trained and having thorough knowledge on JAVA.

Great at working and coordinating with the Developers, Requirements analysts and Users, onsite-offshore coordination.

Excellent interpersonal communication skills and technical documentation skills.

Exceptional ability to quickly master new concepts and capable of working in teams as well as independently.

PROFESSIONAL EXPERIENCE:

Client: Golden Corral Raleigh, NC March 2017 till date.

Role: SQL/BI Developer

Description: Golden Corral is an American family-style restaurant chain, serving breakfast, lunch, and dinner in buffet and grill. This system has modules meant for online Reporting related to Policy Management System and Financial Management System as well as it provides the Interface to set the parameters of the Report.

Responsibilities:

Providing assistance in developing solutions that meet the business requirements.

Involved in modifying existing SQL Server objects like tables, Views, Functions, stored procedures.

Creating and maintaining/modifying T-SQL queries, tables, views, stored procedures and functions that are required for front end business logic and report generation.

Developing and maintaining/modifying complex T- SQL queries, stored procedures and SSIS packages to load the data into the warehouse.

Creating and maintaining SSIS package that uses different control flow (Sequence Container, Execute SQL task, Script task, etc.) and data flow tasks required for business development using SSDT.

Developing SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.

Extensively used SSIS Import/Export Wizard, for performing the ETL operations. Performed ETL mappings and ETL task by using SSIS from sales database.

Used the SQL Server Profiler tool to monitor the performance of SQL Server – particularly to analyze the performance of the stored procedures.

Published reports using Power BI

Developing various types of complex reports like Drill Down, Drill through, Cross tab reports.

Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.

Designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements using T-SQL, stored procedures in SSRS.

Coordinating with front-end developers for implementing business logic in stored procedures, Triggers, and functions using T-SQL.

Working on all types of report types like tables, matrix, charts, subreports etc.

Creating and scheduling SQL server agent jobs and alerts, scheduled reports for daily, weekly, monthly.

Communicating with various users’ groups, research teams, and Business Intelligence teams to gather requirements for the reports required by them based on current and existing patterns.

Environment: T-SQL, PL/SQL, MS SQL Server 2008R2 and 2012, Tableau, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS), Windows XP.

Client: Bala Woolen Mills Pvt. Ltd. Oct 2010 to Aug2016

Role: IT Analyst (Information Management & Reporting)

Description: Bala Woolen Mills Pvt. Ltd makes fine quality yarn for carpet purposes. The IT department was responsible for supporting ordering, production, inventory and financial processes along with reporting requirements.

Responsibilities:

Actively involved as part of a team for gathering and analyzing the needs of End-User Requirements, analyzing and designing software solution and database.

Utilized querying relational databases using T-SQL and Microsoft SQL Server Integration Services to pull and integrate data from various sources.

Involved in designing and creating Tables, Views, complex Stored Procedures and Indexes using T-SQL.

Lead the implementation of ETL processes with SSIS packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, Text files, etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.

Developing various types of complex reports using SSRS

Defined report layouts including report parameters and wrote queries for Drill down, Drill through reports as per business client's requirements using SSRS 2008.

Created subscription of reports in different formats like pdf, excel to be executed automatically on daily, weekly and monthly basis, and also deployed and configured the reports in the Report Server. Translated analytic insights into concrete and actionable recommendations for business or product improvement Performance tuning and maintenance of a report.

Production application support

Environment: T-SQL, PL/SQL, MS SQL Server 2008R2 and 2012, SQL Server Integration Services (SSIS),

SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), ERWIN, Mainframes, DB2.

EDUCATION:

Bachelors of Engineering (B. Tech.) in electronics and telecommunication, Azad Institute of Engineering and Technology, Lucknow (U.P. Technical University).

Diploma in Java.

TECHNICAL SKILLS:

Databases SQL Server,2016,2014,2012, 2008 on Linux/Unix/Windows.

Tools SSRS, SSIS, SSAS, DTS, Tableau, Crystal reports, Informatica.

Operating Systems Win 8/7/XP/2003/2000 MS-DOS.

Miscellaneous Visual Studio Online, Visio, MS-Office, Excel

Languages SQL, PL/SQL, T-SQL.

Contact this candidate