Sql Server Developer

Professional Summary

An astute professional having 5yrs of experience as a SQL Developer/BI Analyst in Database Analysis, Data Warehousing & Business Intelligence Solutions to monitor their Sales growth, Operational activities and numbers in Finance.

Experienced in documentation of end user requirements for data capture, data analysis, understanding internal functionality of the system

Hands on experience in various BI tools and Good Knowledge of Relational Database Management Systems, & Database Design and Development

Involved in Requirements Gathering from end users, experience in data modeling process and data mapping, data analysis, understanding internal functionality of the system

Analyzing and Mining business data to identify patterns and correlations among various data points

Knowledge in DWH Concepts & Dimensional Data Modeling using Star and Snow Flake Schema

Efficient in creating Tables, Indexes, Views, User defined functions (UDFs), Cursors, Triggers, Rank Functions, Stored Procedure, Constraints

Hands on experience in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Data Validation issues

Involved in creation of SSIS packages using different kinds of Sources and Destinations

Creation of work flows with Data flow Task, Execute SQL Task

Knowledge at Data Transformations like Lookup, Derived Columns, Conditional Split, Sort, Data Conversion, Union All, Merge Join and OLEDB Command to load data into SQL Server destination

Well versed in generating multiple Enterprise reports using Tableau/SSRS from SQL Server Database, Oracle Database

Involved in creating various reporting features such as drill downs, drill through, sub-reports, parameterized reports

Thorough understanding on the SDLC phases

Core Competencies

Experience in SQL Server 2012/2014 Knowledge on T-SQL queries, stored procedures, views

Database Design/Backup/Retrieval

Good Knowledge on SDLC models like Waterfall and Agile-Scrum

Thorough knowledge in Tableau Desktop, Tableau Server, SSRS, SSRS Server BI Tools

Client Support and Maintenance and Implementation.

Interpersonal, Analytical and Liaison Skills

Adaptability and Challenging Stance

Technical Summary

Data Bases : SQL Server 2012/2014, MySQL, Oracle10g/11g

Reporting Tools : Tableau Desktop 10/9.1.2/9.2.2/8.3, Tableau Server

10/9.1.2/9.2.2/8.3, Power BI, SSRS 2012/14,

SSRS Server 2012/14

ETL Tools : SSIS

Web Technologies : Knowledge on HTML, CSS

Operating Systems : Windows 2000/2003/XP/Win 7/ Win 8/Win10

Documentation Tools : MS Office Suite

Modeling tools : MS-Visio 2007

Education Credentials

Master’s in Business Administration

P.G. Diploma in Computer Applications

Bachelor of Science

Professional Experience

DART : Dallas - Texas (March 2018- Nov 2018)

Role : SQL Analyst

Environment : SQL Server 2014, Tableau

Dallas Area Rapid Transit (DART) is a public transit service. It Operates Light Rail, Trinity Railway Express commuter rail, bus routes and paratransit services & moves more than 220,000 Passengers per day. Developed Finance, Human Capital, Payroll system, Driver Analysis, Ridership assessment, TVM assessment dashboards.

Responsibilities:

Involved in Requirements Gathering from end users & data mapping from various sources

Managing and designing the reporting environment, including data sources, security and metadata

Worked with management team to create a prioritized list of needs for each business segment

Analyzed source system data to determine the data model that will meet business requirements

Optimized Stored Procedures and Triggers to be used in production

Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing

Created SSIS Packages by Pivot Transformation, Derived Columns, Condition Split, Multicasting

Worked on dimensional data modeling using star and snowflake schemas for fact and dimension tables

Experienced in new KPI generation based on business line

Worked on Proof of Concepts POC presentation & review with project lead along with Tableau Dashboards

Defined the report layout and identified datasets for the report generation

Created reports utilizing features like hierarchy, calculated fields, line graphs, bar graphs, Geographical graphs, Bubble graph

Used Data Blending effectively

Generated Dashboard with Quick Filters & Parameters to handle views more efficiently

Created Dashboards with Drill-down feature for detailed reports

Prepared Tableau Reports for Finance, HR, Payroll, IT & Operations, BUS OTP that provide clear visualizations for effective decision making

Tested the Dashboards against database tables by running custom SQL & monitored the performance of the reports before publishing to server

Executed Test Protocols for System Integration Testing (SIT) and User Acceptance Testing (UAT)

Client : Buyers Barricades - Texas (Aug 2017 – Feb 2018)

Role : SQL Developer

Environment : SQL Server 2014, SSRS

Buyer’s Barricades are Texas Expert in Traffic & Construction Safety. They are involved in creating a traffic control plan, determining what traffic safety equipment is needed. It involves the monthly Sales and Operation Planning (S&OP) process, Claims, Payroll system, Weekly communications of updates & forecast changes, Distribution Replenishment Planning processes, Capacity Planning and Inventory Management.

Responsibilities:

Worked with Business analyst, Data architect and business users to understand business processes

Designed data structure with multiple facts and dimension tables to hold the source data to be used for building new reports with SSRS.

Optimized SQL queries for improved Performance and availability

Create database objects such as tables, views, stored procedures etc.

Worked on database skills with DDL, DML, Stored Procedures, Joins, Functions and Indexes

Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc

Identify columns for Primary Keys, Foreign in all the tables at the design time and mapped accordingly

Created functions to provide custom functionality as per the requirements

Defined the report layout and identified datasets for the report generation

Developed reports using complex T-SQL queries, user defined functions & stored procedures

Developed queries and created Indexes to improve the performance

Data Analysis and Mapping of data as per the client requirements

Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production

Defined data sources, data source views, dimensions, measures, hierarchies, attributes, calculations & KPI's

Designed, Developed and Deployed SSRS reports that include; parameterized reports, drill down reports, drill through reports, Sub-Reports etc

Generated multiple Enterprise reports using SSRS from SQL Server Database and included various reporting features such as group by, drill downs, drill through, sub-reports, parameterized reports

Client : MediCode Medical Coding Solutions (MMS)

Role : SQL Developer (Feb 2015 - July 2017)

Environment : SQL Server 2012, SSRS & Tableau

Developed BI Solution for maintenance of health records in hospitals, ACO’s, physician's office, health departments data, health insurance data and other facilities that provide health care & maintenance of health records, Payroll, Employee benefits, Employee Working Hours, Employee Attendance. Analyze Hospital metrics and data to support operation teams. This is used to identify current and future information needs, in addition they may apply the science of informatics to the collection, storage, use and transmission of information to meet the legal and administrative records-keeping requirements of health care delivery.

Responsibilities:

Analyzing and mining business data to identify patterns and correlations among the various data points

Evaluating changes and updates to source production systems

Created Tables, Views, Stored Procedures, Rank Functions, User Defined Functions, Triggers and Other T- SQL statements for various applications

Involved in performing data conversions from flat files into a normalized database structure

Proven proficiency at Data Transformations like Lookup, Derived Columns, Conditional Split, Sort, Data Conversion, Union All, Merge Join, SCD and OLEDB Command to load data into SQL Server destination

Written stored procedures for querying the data dynamically by defining parameters

Experience in troubleshooting SQL issues by using execution plans, index tuning wizard

Experience in creating and managing fragmentation of Indexes to achieve better query performance

Worked in dimensional modeling with star schema and created the data source Views

Developed reports in the form of Charts, Stack bar graphs, Scattered plots, Gantt charts & Line graphs for Finance, HR & Executive Departments & Doctors Score Card

Designed and modified the data architecture for building KPI’s

Worked on Filters, Cascading Filters, Sorting features in reports

Developed different KPI’s like Payroll, Claims Processed, Claims rejected, Inpatient Units, Outpatient Clinics, Billed Claims, Patient Hours, Avg. wait time by Physician, Readmission by Diagnosis, Readmission by Gender, Charged Hours, Charged Amount, Patient Load by Physician etc. to name a few including drill through with filters and necessary tool tips

Building, publishing customized interactive reports and dashboards

Interacted with QA & Cross Functional teams to evaluate improvements of the existing system. Assisted in UAT.

Client : Old Mutual International/OIPA Implementation

Role : SQL /BI Developer (Sep 2014 – Jan 2015)

Environment : SQL Server2012, SSRS

OIPA is core insurance product. This project is OIPA implementation which is a highly configurable, rules-based system that helps insurers adapt, transform and grow their business by accelerating speed-to-market for products, enhancing service to customers and distribution through real time access to policy information and reducing risk while optimizing performance.

Responsibilities:

Analyzed business data to understand the business

Analyzed department technology usage and performed research to assist in development of project scope, define requirements and propose changes

Developing and implementing data analysis, data collection and other strategies that optimize efficiency and quality

Developed and maintained reports written in OIPA Application utilizing SQL Server 2012

Created scripts to create new tables, views, queries for new enhancement in the application using SSMS

Created indexes on the tables for faster retrieval of the data to enhance database performance

Used SQL Profiler and Index Tuning Wizard for tracing slow running queries and stored procedures

Worked with BCP utility and Bulk Insert to load data from different data sources to SQL Server.

Acquiring data from primary or secondary data sources and maintaining databases

Worked on Capacity planning involving in estimating and sizing of tables

Create functions to provide custom functionality as per the requirements

Analyzed & Written SQL queries to retrieved data to develop required KPI’s

Created action filters, parameters for preparing dashboards for respective insurance modules

Created Bar charts, Trend Lines, Pyramid charts, Score Cards & detail level summary reports and Dashboards

Used tools (Excel and SQL) to analyze, query, sort and manipulate data according to defined business rules and procedures

Designed and deployed SSRS reports such as Drill Down, Drill Through, Parameterized, Sub-Reports and Pivot reports with different formats to support and expedite business decision capability

Delivered on demand reports in different rendering formats using Standard and Data Driven Subscriptions

Configuring the reports in OIPA application and with client URL

Training end users on new reports and dashboards

Assisted in UAT

Client : CSSI (Nov 2013 – Aug 2014)

Role : SQL Report Analyst

Environment : SQL Server, SSIS, SSRS

It is mostly notable for the creation of VUE Software, which is insurance specific offering Suites & Modules to meet the unique needs of Life & Annuity, Health, Property Markets.

It is headquartered in Florida, including Technology Center in Hyderabad & Ahmedabad, India.

Responsibilities:

Reviewed the Business Requirement Specs, High Level Design Documents

Create database objects such as tables, views, stored procedures etc.

Worked on DDL, DML, Stored Procedures, Joins

Identify columns for Primary Keys, Foreign in all the tables at the design time and create them

Developing complex queries and create Indexes to improve the performance

Analysis and filtering the data as per the client requirements

Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.

Involved in performing data conversions from flat files into a normalized database structure.

Proven proficiency at Data Transformations like Lookup, Derived Columns, Conditional Split, Sort, Data Conversion, Union All, Merge Join, SCD and OLEDB Command to load data into SQL Server destination.

Generated multiple Enterprise reports using SSRS from SQL Server Database and included various reporting features such as group by, drill downs, drill through, sub-reports, parameterized reports.

Contact this candidate