Resume

Sign in

Sql Server Data

Location:
Old Bridge, NJ
Posted:
October 29, 2018

Contact this candidate

Resume:

Professional Summary

Over * years of Business Intelligence professional experience with MS SQL Server 2014/2012/2008/2005 and worked extensively on Integration services (SSIS), Reporting services (SSRS), Analysis services (SSAS), Tableau and Power BI.

Implementation and Support of various applications in OLTP, Data Warehousing, and OLAP applications.

Experience in installation, up gradation and configuration of MS SQL Server database.

Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity.

Experience in developing Custom Reports and different types of Tabular, Matrix, Ad-hoc and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) also expertise in working with Crystal Reports.

Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor

Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.

Experience in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).

Experience in creating packages to transfer data between Oracle, MS Access and Flat files to SQL Server using SSIS.

Experience with Adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.

Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2008.

Worked extensively with Data migration, Data cleansing, Data profiling, and ETL Processes features for data warehouses.

Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, Star Schema / Snowflake Schema, FACT and Dimensional Tables.

Experience in creating Stored Procedures, Triggers, Views and Functions.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.

Preparing Dashboards using calculations, parameters in Tableau.

Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow.

Flexible, enthusiastic and project oriented team player with excellent communication and leadership skills to develop creative solution for challenging client needs.

Technical Skills

Languages

SQL, T-SQL, PL/SQL. C, C++, C#

Databases

SQL Server 2005/2008 R2 /2012, Oracle 10g/11g, DB2, MS Access

Reporting Tools

SQL Server Reporting Service (SSRS), Tableau, Power BI

ETL Tools

SQL Server Integration Services (SSIS)

Analysis Tools

SQL Server Analysis Services (SSAS)

Operating Systems

Windows Vista/7/8/10, Unix

Project Experience

T-Mobile, Parsippany, NJ Jun ‘13 – Till Date

Sr. MS SQL/BI Developer

Responsibilities:

Created Stored Procedures, Triggers, Views and Functions for the application.

Written T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries and Stored Procedures.

Worked on SSIS Package and coordinated with ETL developer’s team to ensure data extracted, transformed and loaded according to the specified requirements.

Used Import/Export wizard to move data into multiple servers.

Created batch files for the SSIS packages to execute from the command line.

Scheduled SSIS packages to run on a scheduled basis using Windows scheduler.

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

Developed several Complex Reports using SQL Server Reporting Services (SSRS).

Created Ad-hoc Reports, Drill-Down Reports, Pivot and Tabular Reports.

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

Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).

Experience in generating reports using linked reports, sub reports and filters in SQL server reporting services.

Trouble shooting of Reports by cross checking the Report Layouts, Datasets, Stored Procedures and SSIS Packages.

Created Technical specification documents for each SSIS package developed.

Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).

Created snippets to maximize the efficiency in writing the code.

Developed Tableau visualizations and dashboards using Tableau Desktop.

Developed Tableau workbooks from multiple data sources using Data Blending.

Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables in tableau.

Utilized Microsoft PowerBI for data modelling and building dashboards.

Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI.

Defining data warehouse (star and snowflake), fact table, cubes, dimensions, measures and ETL structure.

Environment: Microsoft SQL Server 2012 Enterprise Edition, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Management studio, Power BI, Tableau, SQL Server Integration Services (SSIS), C#.net.

4G Identity Solutions, Hyderabad Dec ‘11 – May ‘13

Programmer Analyst

Responsibilities:

Involved in the Data modeling, Physical and Logical Design of Database.

Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.

Modified the existing mapping SQL scripts as per the client needs.

Created SSIS packages to import/export sales data to/from the excel sheets, flat files, XML files or other databases as per the user requirements.

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

Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).

Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters, Debugging Parameter Issues, Matrix Reports and Charts.

Created Ad-hoc Reports, Drill-Down Reports, Pivot and Tabular Reports.

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

Created reports with Analysis Services Cube as the data source using SSRS.

Environment: Microsoft SQL Server 2005, Management Studio, Windows XP, MS Access, Oracle 10g, Excel, PL/SQL Developer.



Contact this candidate