Sign in

Sql Server Data

Atlanta, Georgia, United States
February 01, 2018

Contact this candidate


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; and Analysis Services (SSIS, SSRS, SSAS).

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 understanding of writing efficient queries and troubleshooting complex queries

Expertise in Enterprise Reporting includes generating reports using linked reports, sub reports 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, Sub reports 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 modelling using Erwin.

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.


Client: Golden Corral Raleigh, NC Aug 2015 – Sep2017

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.


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 warehouse.

Creating and maintaining SSIS package that use 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.

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, sub reports 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 Jul 2014

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.


Developing various types of complex reports using SSRS.

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

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

Production application support.

Assigned and follow-up duties to team members.


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

Diploma in Java.


Databases SQL Server 2012, 2008; 2005, on Linux/Unix/Windows.

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

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