SUMMARY

• Over 7 years of extensive experience in Database Design, Development and Administration of applications wif MS SQL Server versions 2016/2 R 2/2008/2005/2000 using Integration Services (SSIS), Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) in diverse industries.
• 3+ years of Experience in Tableau Desktop/Server, creating highly interactive Data visualization Reports and Dashboards using features such as Data Blending, Calculations, Filters, Actions, Parameters, Context Filters, Sets, groups etc.
• Extensive experience in working wif Tableau 8.0/9.0/9.2 Workbooks.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues wifin Tableau Server and Reports.
• Involved in all teh stages of Software Development Life Cycle (SDLC) including Requirements, Analysis and Design, implementation, integration and testing, deployment and maintenance.
• Highly proficient in teh use of T - SQL for developing complex stored procedures, triggers, tables, user profiles, relational database models and data integrity, SQL joins and query writing.
• Hands on experience in installing, configuring, managing, monitoring SQL Server 2008/2005/2000.
• Experience wif Fragmentation and Query analyzer for SQL Server 2005/2008/2012/2014/2016 and experience wif Database Tuning Advisor and SQL Profiler for tracing, auditing and Performance Tuning.
• In depth noledge in T-SQL (DDL and DML) statements, RDBMS, data dictionaries.
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support teh existing applications.
• Experience in Database Backup, Recovery and Disaster Recovery procedure.
• Created and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
• Created complex expressions using teh MDX scripting to solve complex designs.
• Hands on experience working wif SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Experience in creating Reports from Web Services and used MDX on Cubes to create reports in SSRS.
• Strong technical noledge in MS SQL Server development including DTS, Microsoft Analysis Services, Reporting, Designing logical/physical databases and Troubleshooting.
• Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting teh data, Defining Data sources and Subtotals for teh reports using SSRS 2008/2005.
• Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2005/2008 (SSRS).
• Experience in Integrating SQL Server Reporting Services (SSRS) wif Microsoft Office Share Point Server (MOSS 2007).
• Good understanding in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling, Fact and Dimensions Tables using MS Analysis Services.
• Experience wif job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.
• Involved in Database Design, Data Modeling (Relational and Dimensional) using Erwin and Microsoft Visio for logical and physical data models.
• Good team player wif strong analytical skills.

TECHNICAL SKILLS

Programming Skills: T-SQL, PL/SQL, C, HTML, Confidential,, ASP.NET, VB, C#

RDBMS: MS SQL Server 2016/2 /2005/2000 , MS Access,Teradata.

Database Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables. SQL Query Analyzer, ETL, SQL Enterprise Manager, Solution Explorer, Analysis Manager, Reporting Server.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio 2005/2008/2010/2013 Crystal Reports

Operating Systems: UNIX, LINUX, Windows7 Vista/XP/2003/2000, NT & Windows 9x and MS-DOS

Systems familiarity: OLTP,DSS,OLAP,MDX

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Business Intelligence Development Studio (BIDS)

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE

Confidential, Bethesda, MD

Sr. SQL Developer

Responsibilities:

• Involved in Database design & Data modeling various databases.
• Developed all teh required stored procedures, user defined functions, triggers using T-SQL.
• Created and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
• Worked wif Database DDL, and DML operations in SQL Server, stored procedures.
• Effectively using various control flow and data flow tasks provided by SSIS such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension, Merge and Union all.
• Scheduled and maintained various daily, weekly and monthly ETL packages and jobs through SQL Server Agent in SSMS.
• Created new database objects like Tables, Procedures, Functions, Triggers, and Views using T-SQL.
• Responsible for teh creation of SQL procedures, triggers, temp tables, and views for teh development of Reports.
• Understanding Customer requirement via interaction and writing functional specification.
• Wrote complex stored procedures and cursors to implement various business logics as per teh client requirements.
• Created different KPI using calculated key figures and parameters
• 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.
• Involved in writing Transact SQL utilities to generate table insert and update statements.
• Generated Script files of teh databases whenever changes are made to stored procedures or views.
• Experience working in agile environment and supported iterative testing methodology.
• Worked in on site/ off shore/ off site environment; coordinated my activities by proactively communicating wif my counterparts in teh other teams.

Environment: SQL Server 2008R 2/2012/2014/2016 , SSRS 2014, SSIS 2014, T-SQL, Windows 7, SQL Server Data Tools, Power Bi, Power pivot

Confidential, Atlanta, GA

SQL Developer/DBA

Responsibilities:

• Designed multiple stored procedures for teh report data sources.
• Designed, developed various SSRS reports for client data which involves Merchant Transactions and Merchant Actives.
• Interacted wif teh business users to gather information about teh report.
• Developed complex SQL Queries, Joins, Sub Queries, Stored Procedures, Functions, CTE s, Views, Constraints, Cursors wif best execution plan in SSMS to implement teh business logic.
• Worked on Report Migration to move SSRS reports from one Environment to other environment.
• Designed ETL SSIS packages involving business logic to generate CSV files for Merchant Transactions and Merchant Actives data.
• Perform administrative tasks, including teh creation of database objects such as database, tables, and views, using SQL DCL, DDL, and DML requests.
• Used WinSCP client to transfer CSV files to SFTP Server.
• Scheduled and monitored these data pull jobs via UC4 job scheduler.
• Created databases, tables, views on Hive to load Merchant Insights and MIS data into Hadoop File System.
• Used PuTTY application to access UNIX terminal from Windows operating system.
• Created automation scripts using Unix Shell Scripting to move data into Hadoop File System.
• Worked under Agile Methodology throughout teh project, performed decisive role in developing and planning as well as coordinating wif assigned tasks.
• Experienced working on production support during code deployment.
• Reviewed many T - SQL issues using management studio for better performance and working on performance tuning for slow running queries using Profiler.
• Experienced in writing UAT scripts for code deployment on Development, Staging, and Production environments.

Environment: SQL Server 2008R 2/2012/2014/2016 , PL/SQL, SSRS 2014, SSIS 2014, T-SQL, Hive .13, UNIX, WinSCP, Windows 7, SQL Server Data Tools

Confidential, Atlanta, GA

Sr. MS SQL SERVER/ SSIS/SSRS/SSAS Developer

Responsibilities:

• Analyzed teh client requirements and translate them into technical requirements.
• Extensively worked on T-SQL for creating stored procedures, indexes and functions.
• Performance Tuning of SQL queries and stored procedures using SQL Profiler.
• Managed index statistics, Tables, Views, cursors and optimized queries by using execution plan for tuning teh database. Implemented different types of constraints on tables.
• Extensively worked on designing reports using SQL Server Reporting Services (SSRS)
• Worked onSSRS2008 to generate about 30+ reports for various user groups and developer groups.
• Developing Tabular Reports, ad-hoc Reports using SSRS Report Designer. Generating several types of drill down and drill through reports using SSRS.
• Developing complex SSRS reports using multiple data providers, global variables, expressions, user defined objects, charts, and synchronized queries.
• Designing and implementing parameterizedand cascading-parameterized reports using SSRS.
• Deploying reports, creating report schedules and subscriptions. Managing and securing reports using SSRS.
• Created ETL packages wif different data sources (SQL Server, Flat Files, Excel source files, XML file) and then loaded teh data into destination tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Extensively worked on Data Flow tasks like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Used various control flow tasks like FTP, Bulk insert task, Conditional Split, Multicast, Merge task and different data flow tasks.
• Extensively involved in teh SSAS storage and partitions, and aggregations, calculation of queries wif MDX, Data Mining Models, developing reports using MDX and SQL.
• Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split and many more.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Successfully migrated SSIS packages from development to test and Production environments using SSIS Configuration files and deployment wizard.
• Created and scheduled SSIS Jobs usingSQLScheduler,SQLServer Agent for daily, weekly and monthly loads.

Environment: MS SQL Server 2016/2014/2012 , SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS),SSAS,DB2, MS SQL Profiler, Crystal Reports, SQL Query Analyzer, Teradata, SQL Server Index Tuning Wizard, Visual Studio 2005, Cognos,Windows XP,MDX C#, ASP.NET,, XML, Erwin v4.1, MS Office 2013.

Confidential, Atlanta, GA

Sr. MSBI Developer

Responsibilities:

• Developed all teh required stored procedures, user defined functions, triggers using T-SQL.
• Created Data Connections, published on Tableau Server for usage wif Operational/Monitoring Dashboards.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Created Cascading dashboards, data extracts Action filters for better performance of Tableau.
• Used data sources like SQL, SSAS cubes and files to generate reports in Tableau.
• Creation and maintenance of SSIS Packages (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
• Effectively using various control flow and data flow tasks provided by SSIS such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension, Merge and Union all.
• Scheduled and maintained various daily, weekly and monthly ETL packages and jobs through SQL Server Agent in SSMS.
• DevelopedMulti-dimensional Objects(Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Created business critical key performance indicators (KPIs) using SQL Server Analysis Services. Wrote MDX queries according to teh business requirements.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for teh SSAScubes.
• Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes.
• Created new database objects like Tables, Procedures, Functions, Triggers, and Views using T-SQL.
• Responsible for teh creation of SQL procedures, triggers, temp tables, and views for teh development of Reports.
• Prepared technical documents like High Level Design
• Involved in Business Analysis & Requirement collection. Designed and developed ETL process wif SCD (slowly changing dimensions) wif T-SQL, SSIS and VBScript
• Loaded data from heterogeneous sources to databases using various tasks and transformations using SSIS.
• Migrate teh data from an Access database to SQL Server 2008.
• Developed web application for reporting portal using .NET, ASP.NET, C#, VSS.
• Used VB.Net Code to create embedded functions in SSRS.

Environment: MS SQL Server 2014/2012, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), MS SQL Profiler, SSAS, SQL Query Analyzer, SQL Server Index Tuning Wizard, MDX, Erwin v4.1, MS Office 2013, Tableau Desktop 9.0/8.3, Tableau Server

Confidential, St.Louis, MO

SQL Server Developer

Responsibilities:

• Performed server installation and configuration using SQL server2012.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views Rules, Defaults and complex SQL statements
• Extensively used Tableau features like Data blending, Extracts, Parameters, Filters, Calculations, Context Filters, Hierarchies, Actions and Maps etc.
• Built complex formulas in Tableau for various business calculations.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extensively worked and Managed on OLAP cubes using SSAS.
• Designed Cubes wif Star Schema using SQL Server Analysis Services 2008 (SSAS). Created several Dashboards and Scorecards wif Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS).
• Involved in designing calculated measures using Multi-Dimensional Expression (MDX).
• Implemented custom SSRS Reports to Internal operation team by reading data from teh QNXT Database.
• Implemented ETL Application to load Claim Payment information to QNXT Financial tables and provided access to financial team by creating custom roles in teh security management.
• Creating, Approving and Modifying PA in both Portal and QNXT and also Involved in Adding Contracts to teh Provider in QNXT and associating Providers in Portal while creating claims.
• Developed teh SQL programs and Involved in optimize stored procedures and queries for faster retrieval and server efficiency SSAS and SSIS.
• Involved in mock testing and Unit Testing and Integration testing in SSIS, SSAS.
• Performance tuning of SQL queries and stored procedures using server Profiler and Index Tuning Wizard in SSAS and SSIS.
• Used multiple transformations in SSIS to meet teh business requirements by extracting data from heterogeneous source systems, transform and finally load into teh Staging Data base.
• Extensively worked in ETL and data integration in developing ETL mappings and scripts usingSSIS, Worked on Data transfer from a Text file toSQL Serverby using bulk insert task inSSIS.
• Involved in SSIS ETL Transformation for de-normalization of data sources using UNPIVOT and UNION.
• UsingSSIS, loaded XML data to teh Database tables and Extracting Data usingSSISinto Excel Files for Marketing purpose.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Planned Backup strategy based on projects requirements.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Environment: MS SQL Server 2014/2012, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), Crystal Reports, SSAS, Oracle 9i/ 10 g; DB2, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2005, MDX,Windows XP, C#, ASP.NET, BizTalk Server, QNXT, JavaScript, XML, Erwin v4.1, MS Office 2013, Tableau Desktop 9.0/8.3, Tableau Server.

Confidential, Bethesda, MD

SQL Server BI Developer

Responsibilities:

• Involved in Database design & Data modeling various databases.
• Developed all teh required stored procedures, user defined functions, triggers using T-SQL.
• Created and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
• Effectively using various control flow and data flow tasks provided by SSIS such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension, Merge and Union all.
• Scheduled and maintained various daily, weekly and monthly ETL packages and jobs through SQL Server Agent in SSMS.
• Involved in writing MDX Scripts for teh OLAP CUBES.
• Created new database objects like Tables, Procedures, Functions, Triggers, and Views using T-SQL.
• Responsible for teh creation of SQL procedures, triggers, temp tables, and views for teh development of Reports.
• Analyzed business requirements, transformed data, and mapped source data using teh Teradata Financial Services Logical Data Model tool, from teh source system to teh Teradata Physical Data Model.
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Understanding Customer requirement via interaction and writing functional specification.
• Wrote complex stored procedures and cursors to implement various business logics as per teh client requirements.
• Optimizing existing queries and fixing query performance issues.
• Actively interacted wif end user to gather business requirement, system specification and enhancement.
• Involved in writing Transact SQL utilities to generate table insert and update statements.
• Generated Script files of teh databases whenever changes are made to stored procedures or views.
• Experience working in agile environment and supported iterative testing methodology.
• Worked in on site/ off shore/ off site environment; coordinated my activities by proactively communicating wif my counterparts in teh other teams.

Environment: SQL Server 2008 R2/2012, SSIS, SSAS, SSRS, Erwin, .Net Frame Work, XML, MDX, MS Access, Excel, C#, ASP.Net, Crystal Reports, Teradata, ER Studio, Performance point Server.