Sql Server Data

UDAY

Contact Number: 219-***-****

SQL/BI developer

************@*****.***

Summary

Around 3 years of professional experience in SQL Server database and Tableau development, extensively worked in Production, Test, Development, Replication & Cluster Server Environments & development databases as a Developer.

More than one and half year of extensive Tableau Experience in Enterprise Environment, in Tableau 7.0, 8.0,8.1, 9.0,9.1 and 10.0 as a Developer and Analyst.

Well versed in Normalization/Demoralization techniques for optimum performance in relational and dimensional database environments.

Experience with Finance, Sales, Health Care Domain like Insurance, Claims, Enrollment, and Credit Card tracker.

Hands on experience in creating indexed Views, Complex Stored Procedures, Functions, Triggers, CTE’s to assist efficient data manipulation and data consistency and used DDL, DML commands for various business applications.

Efficient in upgrades and migration from MS SQL Server 2000/2005 to MS SQL Server 2012/2008.

Hands on experience working with SSIS, for ETL Process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.

Created SSIS packages with complicated transformations like Lookup, Derived Column, Condition Split, Multicast, Sort, Union All, Cache Transform, and Conditional Split, Fuzzy Look-ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc.

Great Expertise in event handlers, Package Configurations, Logging, and Check points, Package Securities and User Defined Variables for SSIS Packages.

Experience in enhancing and deploying the SSIS Packages from development server to production server.

Experience in Reporting Services, Power BI (Dash Board Reports), Crystal Reports, Tableau using MS SQL Server and in supporting services MDX technology of the analysis services.

Expertise in designing, supporting complex reports like Drill-Down, Drill-Through, Parameterized, Matrix, and formatting Reports using SQL Server Reporting Services SSRS) based on client requirement.

Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).

BI Integration with SharePoint like Power View, Power Pivot and Power Query, Excel Service, and Reporting service.

Proficient in Data warehousing and SSAS skills: MDDB/MDX, KPIs, Calculated Members, OLTP, OLAP (MOLAP, HOLAP, and ROLAP), Relational and Dimensional Modeling skills (star schema and snowflake schema).

Developed several PL/SQL Batch programs implementing transaction management using oracle features like SAVEPOINT, Rollback and Autonomous transaction on UNIX.

Good knowledge on creating the MDX cubes and Designing and Building the Dimensions and cubes with star schema and pre-calculating the same in SSAS2005/2008/2008R2.

Having good experienced on BI Share Point like SharePoint 2013, SharePoint 2010 and Good Exposure with Microsoft Office System like MS Word, MS EXCEL, MS PowerPoint, MS Access, MS office Tools

Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.

Quick learner and proactive team member with effective communication skills and Leadership capabilities.

TECHNICAL SKILLS

Languages

: C, T-SQL, PL/SQL, JavaScript, C#, Java.

RDBMS

: SQL Server 2014/2012/2008/2005/2000, 7.0, MS-Access.

Front End

: MS Visual Basics 6.0.

Web Technologies

: HTML, XML, JavaScript, PHP, Shell Scripting.

Version Controlling Tools

: Visual Source Safe, Clear Case, GitHub.

SQL Server Tools

: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio, SSIS, SSAS, SSRS, Data Transformation Services, EDI.

Data Modeling Tool

Reporting Tools

: erwin r7.3/7x/4.0, MS Office Visio 2003/2007

: Tableau 8.0,9.0,9.1 and 10.1, Qlik.

Operating System

: Windows Server 2012 r2, Windows 2000, Windows Server 2003, Windows NT, Windows 95/98/2000 XP/Vista/7/8, Unix.

Methodologies

: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization.

PROFESSIONAL EXPERIENCE

Client: Northwell Health August 2016 – Present

Location: New Hyde Park, NY

Role: SQL/Tableau, BI developer

Responsibilities:

Analyzed business requirements and build logical data models that describe all the data and relationships between the data.

Developed SSAS Cubes with Star Schema.

Designed SSAS cube to hold summary data for Tableau dashboards.

Created aggregations, partitions, KPI’s and perspectives for a cube as per business requirements.

Created roles using SSAS to restrict cube properties.

Created usage based aggregations in cube to minimize time for query retrieval from client tool Tableau and Qlik view.

Was involved in developing Tableau Dashboards using both relational and Multidimensional data.

Improved the performance of calculated measures in cube by modifying MDX queries in an efficient manner.

Developed Aggregations, advanced aggregations and usage based aggregation in order to improve the query time performance.

Created bottom count, top count, cross join and log MDX queries for creating Calculations and KPI’s on a cube.

Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

Created parallel period, filter, ancestors and cross join MDX queries.

Developed Aggregations, partitions and calculated members for cube as per business requirements.

Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.

Used SSAS MDX to extract data from cubes and Created MDX script for representing Cube Calculations.

Created calculated fields with MDX code to meet additional measures need that are calculated from existing measures.

Implemented member properties, virtual dimension, dimension custom rollups, write back, action and drill through.

Conceptualized and Designed Logical and Physical Data Models using Erwin.

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

Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets.

Effectively used Data blending feature in Tableau.

Administered user, user groups, and scheduled instances for reports in Tableau.

Executed and tested required queries and reports before publishing.

Converted metric insight reports to Tableau reports.

Create, customize & share interactive web dashboards in minutes with simple drag & drop.

Involved in installation of Tableau desktop and Tableau Server Application software

Involved in gathering client requirement.

Responsible for creating reports on Tableau desktop.

Environment: SQL Server 2012, 2014, Windows Server 2008 R2, 2012, Management Studio, Business Intelligence Development Studio (SSIS, SSAS, SSRS), visual studio 2010, 2013, Tableau, Microsoft Office Share Point Server, OLTP, OLAP, MOLAP, XML, Tableau Desktop 7.0, 8.0, 8.1, 9.0, 9.1 and 10.0, Tableau server / Administrator, tabcmd.

Client: ATS TransLogic Systems Pvt. Ltd June 2014 – Dec 2015

Location: Hyderabad, India

Role: MS SQL Developer /SSIS DEVELOPER

Responsibilities:

Involved in all the phases of SDLC.

Developed Data warehouse logical and physical data model using Erwin tool.

Built Star Schema data model DW.

Designed Customized logging along Error handling.

Used Staging tables to cleanse the data and to transform data wherever required.

Used for Each Loop Container to load multiple files at a time into the table and archived the loaded files.

Deployed SSIS package to different environments and scheduled the packages using SQL Server agent job and monitored the deployed packages on the production server.

Tuned the Performance of the SSIS packages by avoid the Blocking transformation, by configuring the Default Buffer Size and Default Buffer Max Rows, by using Column Store index wherever necessary.

Production Support for deployed SSIS packages.

Developed SSRS reports as per the business requirements.

Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).

Developed various operational Drill-through and Drill-down reports using SSRS.

Worked Business Data Catalog to display the sale report data.

Developed Reports for business end users using Report Builder with updating Statistics.

Created Master package to call all the child packages using Execute Package Task.

Used Sequence container to execute the packages in order Dimension are executed first then followed by Fact.

Wrote, tested and implemented Teradata Fast load, Multiload and Bteq scripts, DML and DDL

Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).

Developed different kind of reports such a Drill-through and Drill-down, Sub Reports, Charts, Matrix reports, Linked reports.

Migrated all SSRS Reports from Visual Studio 2005 to 2008/2010/2012.

Developed BI Letters in Visual Studio 2010 and 2012.

BI Integration with SharePoint like Power View, Power Pivot and Power Query, Excel Service and Reporting service.

Worked on Excel Sheet Macros, gave connections for MDX to create Power Pivot Reports.

Cracked SAP code to SQL Code to Develop SSRS Reports.

Environment: Teradata SQL Assistant, Visual Studio 2010,2012,2013, Erwin TOOL 9.0, GECS Scheduler, MS SQL Server Management Studio 2008, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).

Company: RCI May 2012 - June 2012

Location: Hyderabad

Role: Project Intern Trainee

Responsibilities:

Involved in Analysis and Design, developed User interfaces using HTML, DHTML, PHP and validation using Java Script and Designed the Web pages and all the front-end applications for the application "Optimal Bandwidth Assignment for Multiple-Description Coded Video".

Modified and Created Joins to in the Database.

Learnt how to set up a SQL server database.

Loaded data from ODS to Data Warehouse using SSIS packages.

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing distinct kinds of transformations using SSIS packages.

Education:

Master’s in Information Technology from Valparaiso University

Contact this candidate