SUMMARY

• 7 years of IT experience as MS SQL Server 2008/ 2008R 2/ 2012/ 2014/2016 , Developer/ BI developer in Health Insurance & Networking.
• Technical experience in Microsoft BI technologies, SQL Server Integration Services (SSIS), Analysis Services(SSAS) and Reporting Services (SSRS).
• Experience in SQL Server Integration Services (SSIS) and DTS on designing a package, constructing and deployment.
• Extensive experience in building Data Integration and providing ETL solutions for data warehousingusing SSIS.
• Developed dashboard reports using SQL Server Reporting Services (SSRS), Ad Hoc reporting to deliver OLAP solutions.
• Experience in performance tuning and query optimization by using execution plan, SQL profiler and DBCC commands.
• Created shared dimension tables, hierarchies, measures, cubes, levels and aggregations on MSOLAP, SQL Server Analysis Services (SSAS).
• Experience in migrating the reports using SSRS from SQL Server 2012, SQL 2008 R2, SQL 2014.
• Extensive experience in analyzing and transforming the business requirement into real time data.
• Perform Data Analysis using various capabilities like vlookup’s, pivot tables offered by MS excel and aggregate functions in SQL Server.
• Experience in creating views, stored procedures, functions, triggers, joins in SQL.
• Worked with prod support in debugging the issues and performance tuning.
• Experience in tuning the T - SQL and PL/SQL queries, stored procedures, views, triggers, indexed views and error handling using Try-Catch blocks.
• Experience in designing SSIS packages using OLE DB connection from various sources like Excel, Flat file, Oracle, Teradata by using several transformations like Data conversion, lookup, Merge, MergeJoin, UnionAll, Bulk Insert.

TECHNICAL SKILLS

Database: Oracle, SQL Server 2008/ 2008R2/ 2012/ 2014, MS Access

Programming Languages: Transact SQL, PL/SQL, SQL, .NET, C, Visual Basic, VB.Net

Tool: Alteryx, Android Studio, Visio, Project 2013, MS Project, MS Excel, Bizagi

ETL Tool: SQL Server Integration Services (SSIS), DTS

Analysis & Reporting Tools: SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS)

Database Tools: SQL Server 2012 Query Editor, Management Studio, SQL Query Analyzer, Reporting Server, SQL Enterprise Manager

Operating Systems: Windows Server 2000/2003/2008/2012 , MS DOS

PROFESSIONAL EXPERIENCE

Confidential, Kansas

SQL Developer

Responsibilities:

• Interacted with Business Analysts and Users in requirement gathering, built complex queries using SQL.
• Developed Triggers, Joins, Cursors, Views and SQL on MS-SQL Server.
• Experience in Extracting and Transforming the data from various sources like Excel, Flat file and loading into various destinations like OLEDB, SQL server by using SQL Server Integration Services (SSIS) packages.
• Developed the ETL process in SSIS with control flow, Data flow tasks and Stored Procedures.
• Using SQL Server Agent, scheduled ETL packages to run daily, weekly or monthly.
• Worked with parameters for parameterized reports in SSRS 2014, 2016.
• Writing data validation scripts for data integrity using T-SQL.
• Developed query by generating drill down reports in SSRS 2014, 2016.
• Used aggregate routines for views, summary tables, materialized views, reports etc.
• Generating Reports using Alteryx Designer.
• Loaded Data into Oracle Tables using SQL Loader.
• Developed and deployed reports in SQL by using SQL Server Reporting Services (SSRS) to generate daily, weekly, and monthly.
• Designed Data Mart by creating tables, views, stored procedures in SQL.
• Perform data analysis tasks to support business users by writing SQL queries.
• Improving performance of the server by analyzing the long running queries and performance tuning them.
• Optimized long running stored procedures and queries for effective data retrieval.
• Worked on various tasks and transformations in SSIS like Execute SQL Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookup while loading the data into Destination
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• ETL process automation, Deploying SSIS packages using package configuration along with deployment utility.
• Configured ALWAYSON High Availability groups setup between different Datacenters and on Multi Subnet Cluster.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Used Analytical functions in SQL to compare various data sets.
• Identified data issues and provided recommendations for resolution to ensure optimal performance.
• Involved with production support and resolved many critical issues by providing emergency cleanup scripts.
• Generated sub-reports, drill-through, drill-down and parameterized reports using SSRS 2014.
• Migrated crystal reports to SSRS 2014.
• Strong experience in monitoring and tuning sql server databases for optimum performance and assistance in capacity planning of sql server database servers.
• Involved in developing and scheduling using cron jobs to load the data into the database and export/import mechanism for data migration for bulk upload.

Environment: SQL Server 2016/2012/2008 R2/2008, SSRS 2008, SSIS 2008, C#.NET, Power Pivot, Tableau, ETL, crystal reports, Alteryx, .NET, XML, XSLT, MS Office and Visual source safe, Visual Studio 2012.

Confidential, Jacksonville, Florida

SQL BI Developer

Responsibilities:

• Involved in SDLC to gather requirements from business users and perform development and testing in DEV environment.
• Configured and managing SQL server 2014 transactional replication and automated transactional replication.
• Worked on SSIS packages to implement data load strategy.
• Involved in the Extracting, Transforming and Loading the data from one source to another destination using SQL Server Integration Services (SSIS) tool.
• Optimized long running stored procedures and queries for effective data retrieval.
• Experience in maintaining the database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Worked on debugging the errors by updating the code and mappings in the Data flow tasks.
• Deployed the SSIS packages in DEV, UAT (test) and Production environment using deployment utility.
• Worked on writing views, complex stored procedures, functions, joins and triggers.
• Scheduled SQL Server jobs daily, weekly or monthly to load the data into Development, Test, and Production environments.
• Designed Data Warehouse and provided the mappings from Source to destination tables.
• Worked on Performance tuning of SQL queries by using SQL profiler and Index Tuning in SSIS.
• Strong experience in monitoring and tuning sql server databases for optimum performance and assistance in capacity planning of sql server database servers.
• Created dashboards that consists of charts, grids and reports.
• Customize the output formats from SSRS to Excel, CSV and PDF.
• Created UDM for cubes in SQL Server Analysis Services (SSAS).
• Created dashboards against SSAS cubes using SSRS.
• Generated pivot tables using cube data in SSAS and delivered reports using SSRS with the help of connection string as SSRS.
• Generated sub-reports, drill-through, drill-down and parameterized reports using SSRS 2008R2.

Environment: MS SQL Server 2012/2008R2, SSIS Package, SQL BI Suite (SSMS, SSIS, SSRS, SSAS), XMLMS Excel, MS Access 2007 & Windows Server 2008, SQL Profiler, Erwin r 7.3.,Net 4.0/4.5.,TFS 2010/2012.

Confidential, KY

BI Developer

Responsibilities:

• Extensively worked on T-SQL for creating stored procedures, indexes and functions
• Designed Enterprise reports using SQL Server Reporting Services (SSRS 2008) which make use of multiple value selection in parameters pick list, cascading prompts, drill thru reports, drill down reports, matrix reports and other features of reporting service.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Improving performance of the server by analyzing the long running queries and performance tuning them.
• Responsible for all the Tableau and PowerBI changes.
• Developed Power BI reports and dashboards from multiple data source using data blends
• Designed Power BI data visualization utilizing cross tabs,maps,scatter plots,pie,bar and density charts.
• Worked on SSRS 2014 to generate about 30+ reports for various user groups and developer groups
• Developing PowerShell scripts to automate DBA maintenance tasks.
• Managing Disaster Recovery Solutions Log Shipping and DB mirroring for BCP/DR servers
• Responsible for DB deployments and code reviews.
• Deployed all the reports to reporting server, Excel & PDF.
• Developed Charts, Pie-Charts, Bar-graphs, series on SSRS.
• Managed security on Production and Development environments.
• Developed custom reports and deployed them on server using Power BI
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML file) and then loaded the data into destination tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for designing the SSIS packages to export data of flat file source to SQL Server Database
• Involved in enhancement of existing SSIS packages.
• Good knowledge in deploying SSIS packages to various environments.
• Implemented in unit testing and created unit test document
• Supported system testing and helped the testing team in execution of SSIS Jobs.
• Used various control flow tasks like FTP, Bulk insert task, Conditional Split, Multicast, Merge task and different data flow tasks.
• Provided many supporting documentations for the project.

Environment: MS-SQL Server 2014/2012/2008/ R2 Management studio, T-SQL, MS Excel, SSIS, SSRS SSAS, MDX, Unix, Linux, OLAP, ETL, Tableau, Power BI.

Confidential

Jr. SQL Developer

Responsibilities:

• Upgraded to latest version from SQLServer 7.0 to 2005.
• Developed User Defined Functions for giving Scores and views for the application
• Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database
• Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS
• Wrote various Stored Procedures for application development
• Tuned SQL statements (e.g.: using Indexes) and Stored Procedures
• Worked on replication of data (Transactional method used)
• Designed and implemented data access stored procedures and triggers for automating tasks
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder
• Formatted the reports using the Global variables and expressions
• Performed job scheduling and alerts
• Designed and implemented user log in and security
• Resolved any deadlocks issues with the databases/servers on a real-time basis

Environment: MS SQL Server 2005/2008, Management Studio(SSMS), ETL, DTS, Azure, Notification Services, Crystal Reports9.0, Data Modeling, OLAP, Data ware Housing, MDX