SUMMARY:

• Over 7 years of strong experience in IT Industry as T - SQL /BI/ Tableau developer in Finance, Banking, Manufacturing & Distribution, Telecommunications and Health Insurance domains.
• Full Software Development Life Cycle (SDLC) experience including Analysis, Design and Review of Business and Software Requirement Specifications.
• Highly experienced in MS SQL Server 2008/2008R2/2012/2014 to run T-SQL commands with Business Intelligence in SSIS, SSRS & SSAS.
• Broad experience with Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP and OLAP as per business needs.
• Highly proficient in creating T-SQL DDL, DML and DCL queries, Stored Procedures, User Defined Functions (UDF's), Views, CTE's, Database Triggers, Cursors, Indexes, Views, Sub queries and SQL joins to simplify complex queries involving multiple tables.
• Experienced in tuning Long running SQL queries for better performance.
• Used Query Analyzer, Execution Plan and Indexes to optimize SQL Queries.
• Extensive experience in extracting, transforming and loading (ETL) data from OLTP databases and other data sources, including heterogeneous and homogeneous sources into Data Warehouse, in SSIS using various tasks and transformations.
• Expertise in developing complex SSIS Packages including C# scripting to extract data from heterogeneous data sources.
• Hands on experience in Microsoft Reporting Service (SSRS) 2008/2012/2014 with Report authoring, Report management, Report delivery and Report security.
• Strong experiences to Design, deploy, and maintain various SSRS Reports in SQL Server.
• Created many Drill Through, Drill Down, Parameterized, Cascading reports using SSRS.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, and Pie Charts.
• Develop, maintain and document highly visualized comprehensive healthcare dashboards using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau.
• Experience in using Tableau functionalities for creating different Filters, Charts, Interactive dashboards.
• Extensive experience in preparing dashboards using calculated fields, parameters, table calculations, groups, sets and hierarchies in Tableau.
• Experience in implementing Data blending, replace references, Customized queries and advanced visualizations in Tableau desktop.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Experienced in developing and modifying cubes and dimensions in cubes using SSAS.
• Skilled in developing Data Warehouses, Data marts using Star Schemas and Snow Flake Schema.
• Experience in analyzing Dataware house by creating & customizing cubes using SSAS and writing MDX queries.
• Involved in creating test case document and performed Unit testing, integration testing, regression testing & System testing.
• Created different schedules for report delivery to e-mails and shared directories, enabled snapshots, subscriptions, caching to improve the response times and reduce traffic to the report server.
• Collaborated TFS (Team Foundation Server) for code check-in and check-out and manage different versions of complicated code and distribute them to different teams in the organization.
• Strong working knowledge in software development methodologies like Agile, Waterfall across the span of various projects.
• Excellent problem solving, analytical, technical, interpersonal and communication skills with strong leadership abilities and an extremely diligent strong team player with an ability to take new roles.

TECHNICAL SKILLS:

DATABASES: MS SQL Server 2008/2008R2/2012/2014, Oracle, Teradata

PROGRAMMING: T-SQL, PL/SQL, C, C#, HTML, MDX.

WEB TECHNOLOGIES: Active X, Internet Information Services (IIS), JavaScript, jQuery.

ETL TOOLS: DTS, SQL Server Integration Services (SSIS).

OLAP TOOLS: SQL Server Analysis Services (SSAS).

REPORTINGTOOLS: SSRS, Report Builder, Micro Strategy, QlikView, Tableau, Power BI

VERSION CONTROL: Team foundation Server (TFS), Visual Source Safe (VSS).

OPERATING SYSTEMS: Windows XP/2007/2010

DATAMODELLING TOOLS: Erwin, MS Visio, Balmasiq MockUp

AGILE TOOLS: Rally, JIRA

SQL SERVER TOOLS: SSMS, SSDT, Query Analyzer, Profiler, Performance Monitor

PROFESSIONAL EXPERIENCE:

Confidential

Sr. SQL/Business Intelligence Developer

Responsibilities:

• Designed and developed Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Reviewed SQL queries and modified as needed in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Created dashboard using dynamic parameters, sets, groups and table calculations and also created dual-axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Designed and developed ETLs using SSIS to load data into data warehouse from various source systems.
• Involved in fine tuning of Complex Stored Procedures and Performed T-SQL query tuning and optimization which are taking long time to render data using MS SQL Profiler, Updating Statistics and Index Tuning Wizard.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Involved in building Oracle environment & upgrading SSIS packages.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created and maintained different kinds of reports like Sub-Reports, Drilldown-Reports, Summary Reports, Parameterized Reports and linked reports.

Environment: SQL Server 2014, SSIS, SSRS, Tableau, SSAS, Report Builder, Visual Studio, APE Framework, JIRA, Toad, SQL Developer, Teradata SQL Assistant, Balsamiq Mockup.

Confidential

Sr. SQL/Data Integration Developer

Responsibilities:

• Responsible for requirement gathering from Business users.
• Worked in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets, Oracle, Salesforce and heterogeneous data to and from SQL Server.
• Improved query performance by adding covered indexes, adding file groups etc.
• Developed and implemented web applications using HTML, JavaScript, and SQL server stored procedures.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Developed advanced ETL import packages using SSIS, T-SQL Scripts, T-SQL scripts for Execute SQL task and Expressions in ADO.NET sources to transform and import raw index data into database tables and to staging by executing business logic, rules and client requirement.
• Created packages in SSIS with error handling using various data transformations.
• Created and deployed Reports utilizing SSRS to design complex reports.
• Created cascading parameters for SSRS reports as well as drill-down, drill through, sub reports and interactive sorting capability.
• Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions, and functions.
• Implemented subscriptions and snapshots in the SSRS Report Manager, report security, report delivery. Integrated reports from SSRS with SharePoint.
• Deployed the reports and Created subscriptions for the reports in report manager.
• Implemented report subscriptions and methods for report distribution based on agreed timelines and according to specifications.
• Created dashboard, scorecards, and KPIs.
• Migrated existing SSIS packages and SQL Server databases to new HIPPA server for security compliance.
• Used Tableau Desktop to develop data analysis multiple data sources to visualize the reports.
• Created Interactive dashboards on Health Care data using different Visualizations in Tableau.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Worked closely with Micro strategy team for data requirements.
• Scheduled Jobs to run SSIS package using UC4/Atomic scheduler.

Environment: SQL Server, SSAS, SSIS, SSRS, MDX Cubes, Tableau, UC4/Atomic, Rally.

Confidential

Sr. SQL/Business Intelligence Developer

Responsibilities:

• Analyzing the problems in the production environment and try to develop new procedures and methods for monitoring the problems and send alert messages to take pro-active action.
• Created new database objects like Procedures, Functions, Packages, Indexes, complex queries and Views using T-SQL in SQL Server2008.
• Worked on Client tools like SQL Server Management studio to administer SQL Server.
• Data conversions and data loads from various databases and file structures.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Modified existing codes and developed PL/SQL packages to perform certain specialized functions / enhancement on oracle application.
• Created SSIS Packages to load the data from different carriers like Verizon, sprint and AT&T.
• Developed SSIS master package which include number of child packages.
• Developed parameterized, caching, sub and Ad Hoc reports using SSRS.
• Designed and developed Drill down and Drill through reports using SSRS.
• Created Parameterized reports and Linked reports which navigates to other report.
• Scheduled reports for Daily, Weekly, Monthly reports for various categories and regions based on business needs using Reporting services (SSRS).
• Formatted the reports using the global variables and expressions in SSRS, deployed the generated reports on to the Reporting server.

Environment: SQL Server, Oracle, SSIS, SSRS, SSAS, Team Foundation Server (TFS), Internet Information Server (IIS).

Confidential

Sr. SQL/Business Intelligence Developer

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle.
• Written complex oracle SQL queries with complexity using inner/outer joins, union all, intersect& minus set operators.
• Developed and maintained Oracle Table Partitioning and Partitioning Indexes.
• Generated Monthly and quarterly Reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.
• Generated pivot tables using the cube data in SSAS and delivered reports using SSRS by using the connection string as SSAS.
• Involved in building of OLAP cubes with SSAS and in adding calculations using MDX
• Involved in creating Data mappings in SSIS and created data models using ERWIN tool.
• Use DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Wrote custom T-SQL stored procedures, indexes, cursor, functions and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

Environment: SQL Server, SSAS, SSIS, T-SQL, SSRS, Erwin, Oracle, Report Builder.

Confidential

SQL Server Developer

Responsibilities:

• Involved in design of the database and tables.
• Built table relationships and wrote stored procedures to clean the existing data.
• Coordinated with the front-end developer to put in the business rules.
• Wrote procedures to check some of the rules at the backend at the time of entering data.
• Wrote SQL stored procedures to implement business logic.
• Developed and coded Different database objects Views, Triggers in T-SQL.
• Performed unit testing, regression testing.

Environment: SQL Server, T-SQL, Visual Studio.