PROFESSIONAL SUMMARY:

• 9 years of experience in the IT industry as a SQL Server Developer/Business Intelligence Developer.
• Expertise in the development, implementation and maintenance of SQL Server 2008/2008 R2/2012 including the MS SQL Server suite of products like SSAS, SSIS, SSRS.
• Proficient in creating Standard, Cross Tab, Drilldown, Sub - reports, OLAP, On-demand sub reports and Chart Reports, ad-hoc reports using SSRS. Well versed with design and development of ad-hoc reports.
• Expert in creation of Extract, Transform and Load (ETL) processes for large-scale Data Warehouses and SQL programming skills
• Highly proficient in migrating data from heterogeneous and legacy systems to SQL Server using Microsoft SSIS 2008/2008 R2/2012.
• Experience developing in Classic ASP/VBScript
• Proficient in ASP.NET, C# and SQL Server database design, development, and testing
• Expert in creation of complex SSIS packages that utilize script components, loops, Expressions, variables, constraints, error handling and logging and transformations like look-up and merge join.
• Proficient in developing Stored Procedures, Views, Functions, Triggers, XML and complex queries on SQL Server 2005/2008/2008 R2.
• Proficient in Database performance optimization, debugging and tuning using the query analyzer, SQL Profiler and SQL Server Debugger.
• Installing and Configuring of MicroStrategy suite including MicroStrategy Desktop, Administrator, Intelligence Server, Web, and Narrowcast Server on NT Servers and Sun Solaris Environments.
• Experience in Oracle supplied packages and PL/SQL Tables. Loaded Data into PL/SQL Tables using SQL Loader.
• Experience in Microsoft C# language writing Script Component in SSIS packages.
• Highly proficient in all aspects of database implementation including development, normalization, de-normalization and performance tuning.
• Experience in Database Backup, Recovery, and Disaster Recovery procedures.
• Experience in Managing Security of SQL Server 2008 R2 and 2012 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, create complex reports (ex: drill down reports using different objects) using SSRS.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Integration of SSRS Reports using various web parts into SharePoint (MOSS 2007) and various delivery mechanisms.
• Working experience with SQL Server 2008R2, 2012, 2014, or 2016 in developing, implementing, and supporting SQL server databases for web-based applications. Experience in SQL Azure is a big plus.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Worked extensively on Extraction, Transformation, loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
• Experience in .NET/C# application development environment to use SQL Server Databases.
• Good experience in creating OLAP cubes using SQL Server analysis services (SSAS).
• When the Stretch Database (also known as Stretch DB) feature is enabled for one or more tables of your local database, SQL Server 2016 can dynamically archive data in a secure manner from your local SQL Server database onto the Azure SQL database hosted in the cloud. Hence this version of SQL Server facilitates seamless migration of your data to Microsoft Azure sans any downtime.
• Experience in working with Database setup, partitions and maintenance.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MS Analysis Services.
• Strong knowledge on claim management process, well versed with Medicaid and Medicare services, HL7 message validation, ICD9, Electronic Health Records and Electronic Medical Records.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
• Experience in managing large data sets on MS Excel 2013
• Provided application security support for SQL applications with ADO.NET
• Expert in converting Crystal reports to SSRS Reports and vice versa. Also, migrated Crystal Reports to higher versions.
• Expert in creating reports using SQL Server Reporting Services (SSRS), sourcing OLAP cubes and data warehouses.
• Experienced in all phases of project life cycle starting from business requirement gathering, analysis, design, implementation, testing, and production.
• Extremely motivated, well organized and strong team player with an ability to adapt to new technologies quickly.

TECHNICAL SKILLS:

Microsoft Technologies: Microsoft .Net Framework, ASP.Net, Web Forms, Win Forms, ADO.Net

Programming Languages: C#, ASP.Net, UNIX Shell Scripting.

Development Tools: Visual Studio .NET 2008/2010/2012/2013/2015, TFS

Frameworks: Microsoft.Net 4.5/ 4.0/ 3.5/3.0

Databases: SQL Server 2012/2008/2005, PL/SQL, MS Access 2008,2010,2012,2014

BI Tools: SSIS, SSRS, SSAS

Database Tools: SQL Server Query Analyzer

MS: Office 2003/ 07/10/13

Operating Systems: Windows Win7/XP/NT/ 2000/2002/2008/2012, 10

PROFESSIONAL EXPERIENCE:

Confidential, Knoxville, TN

MS SQL/BI Developer

Responsibilities:

• Designed Contract Retention database using SQL Server 2008 technology
• Designed and developed data models for the data warehouse using star and snowflake schema.
• Developed data mapping documentation to establish relationships between source and target tables including transformation processes.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, Perfmon and DB Engine Tuning Advisor.
• Developed and implemented SSIS 2008 ETL processes to load data from source files to target table
• Created Data Flow Tasks with Merge Joins to get data from multiple sources from multiple servers, with Look Ups to access and retrieve data from a secondary dataset, with Row Count to have the statistics of rows inserted and updated and worked with Script Task to perform a custom code.
• Worked with Package Variables, with Event Handlers to react to the appropriate error conditions, with SSIS Parallelism, with Package properties to make package more proficient.
• Design/Setup & support HADR environments using Clustering, Mirroring & AG technologies, creating scripts for DR Drills and performing POC for SQL Server 2016/2014/2012/2008 R2 environments.
• Performance Tuning using tools like SQL Profiler, execution plan, optimizing indexes, Performance monitor, DMV's etc.
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Consolidate 3 major business environments into one consolidated environment and implemented Always on Availability groups for HADR using SQL Server 2016/201/2012 Enterprise Edition.
• Good understanding in performance tuning, Backup and disaster Recovery Process and tools.
• Developed, maintained and approved SQL Server Stored Procedures, SSIS Packages, PowerShell Scripts, and .NET code
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Expert MS SQL skills including experience with installing, patching, clustering and mirroring.
• Developed and deployed data transfers, scheduled packages using SSIS, also maintained the jobs running on Servers.
• Developed script components in SSIS packages using Microsoft C# language.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column.
• Ability to create scripts using Azure PowerShell during for automation and build process.
• Experience in automating day-to-day activities by using Windows PowerShell.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources.
• Developed Data Migration strategy for the customer to transfer enterprise legacy data to the newly developed ERP application. Reverse engineered various application to develop data mapping between the two applications and implemented PL/SQL migration scripts to load data across multiple table by maintaining data integrity
• Performed query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Programmed stored procedures, user defined functions, database triggers and packages and all the database objects needed in Oracle environment to implement business logic.
• Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
• Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.
• Use VBScript on intermediate ASP page to capture data from form elements, put them into tagged-variant array to be passed to a stored procedure in the database.
• Strong in Classic ASP/SQL Server web apps developing C# ASP.NET skills and SOAP/XML.
• Created, enhanced, maintained essential Crystal Reports for Operations and HR departments.
• Created additional ad-hoc reports using MS Access for Operations Director.
• Received MS SharePoint 2010 application development training covering Visual Studio 2010, SharePoint Designer 2010
• Designed logical and physical database for reporting tool, generating various monthly financial & end user reports and send them to the traders and end users. Also generated reports in different formats such as csv, pdf, rpt & txt etc.
• Creating Azure Backup vault and protecting required VMs to take the VM level backups.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, SQL 2016, OLAP, OLTP, MDX, C#, power shell, classic ASP, JavaScript, .Net, Data Mart, ETL, MS Office 2010, Performance Pint Server 2007, Team Foundation Server.

Confidential, Rosemont, IL

MS SQL/SSIS Developer

Responsibilities:

• Involved in designing, developing and deploying in MS SQL Server environment using SSIS in Business Intelligence Development Studio.
• Create source to target mappings and ETL design for integration of new/modified data streams into the data warehouse/data marts.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Prepared design document to migrate SQL server agent Jobs into Stonebranch.
• Created Stonebranch time triggers, workflow tasks, windows tasks and file monitoring tasks for SSIS packages.
• Created packages using SSIS for data extraction from OLEDB to SQL Server.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Document designs and architect data maps develop data quality components and establish and/or conduct unit tests.
• Create/maintain design related artifacts i.e. data models, Mapping documents, architecture diagrams, data flow diagrams.
• Proactive and diligent in identifying and communicating scope, design, development issues and recommending potential solutions.
• Perform Data profiling and analysis of structured and unstructured data.
• Used Team Foundation Server (TFS) as the source control to maintain the source code
• Integral is demonstration presentations with team members and business users for the feedback.

Environment: MS SQL Server 2016, T-SQL, SSIS, Stonebranch, TFS, vb.net, C#, MS Excel, Query Analyzer, Visual Studio, JavaScript, MS Access, MS Excel.

Confidential

MS SQL/SSIS Developer

Responsibilities:

• Involved in complete SDLC life cycle. Extracted, Transform and Load source data into respective target tables to build the required data marts.
• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Performed DBA tasks like Backup, restore of tables and Stored Procedures and Refreshing Database on weekly basis.
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Implemented different types of constraints on tables.
• Experience in working with Medicare and Medicaid insurance data, Medicare parts A, B, C and D. Insurance pricing, Insurance Claim Adjudication.
• Participated in ICD 9 to ICD 10 codes mapping sessions as well as status meetings and provided necessary suggestions on challenges.
• Designed and applied entity and attributes description and definition for the models.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Worked on different sources in SSIS (XML, Flat file, Excel, OLEDB Source).
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Develop/Build/Deploying all the database and ETL objects using TFS.
• Responsible for gathering business requirements to create business user reports.
• Developed optimal stored procedures and queries to create data sets for reports.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Performed unit and system testing, troubleshooting and bug fixing in Prod and QA environments.

Environment: MS SQL Server 2016, T-SQL, SSIS, SSRS, TFS, ASP.Net, MS Excel, SQL Profiler, Query Analyzer, MS Access, MS Excel.

Confidential, Secaucus, NJ

MS SQL/BI Developer

Responsibilities:

• Developed Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management
• Created logins, users and configuring permissions and assigning roles to users.
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Implemented high availability using Portal, PowerShell on Azure Resource Manager deployment models.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Developed and deployed data transfers, scheduled packages using SSIS, also maintained the jobs running on Servers.
• Created and implemented ARM templates from a deployment, deployed the template using the portal, PowerShell, and using Azure quick start templates.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column.
• Create the Virtual Machine cluster and load balance for VM's using PowerShell in SQL & Windows Environment
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Created Ad-Hoc Reports, Sub-reports, Drill-down reports, Drill-through reports, Chart reports, Summary reports and Parameterized reports in SSRS.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL Queries for improved performance and availability.
• Created SQL scripts for tuning and scheduling.
• Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and worked extensively on widgets.
• Validated end user requirements using MicroStrategy tools.
• Worked on programmatically connecting to all the FTP servers to download the files and load into database on daily basis.
• Experience in downloading files from curl scripts and save them into database using C# loaders.
• Worked on scheduling Email trigger jobs to raise an alert to download the files when an email attachment triggers the mail box.
• Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Converted DTS 2000 to SSIS 2012 for the new Data warehouse
• Created Ad-Hoc Reports, Sub-reports, Drill-down reports, Drill-through reports, Chart reports, Summary reports and Parameterized reports in SSRS.

Environment: SQL Server 2012, Visual studio 2013, SQL Server Management Studio, SVN, power shell, Javascript, Reporting Services Configuration, SSRS, Excel, MS Access.

Confidential, Louisville, KY

SQL Developer

Responsibilities:

• Actively participated in gathering Business Requirements and System Specification from system users.
• Efficiently involved in developing physical and logical design of database, incorporating new business requirements, and implemented the new design into SQL Server 2008.
• Created new tables, written stored procedures for Application Developers and some user defined functions, indexes, views etc.
• Designed ETL process to load data from different sources like text file, excel or various database. Performing migration of the data from text file or database to staging and from staging to data warehouse.
• Designed expense report with the use of the fact and dimension table model. Also, designed the aggregate table for the usage summary reports.
• Defined parent and child relationship by using common table expression.
• Using a slowly changing dimension to load the data in to DW and maintain the historical data. Using different control such as for loop container, lookup, merge and union all.
• Responsible for the design of the SSIS package for the updated expense amount from OLTP database.
• Maintained nightly and weekly data loads by scheduling the corresponding ETL job in SQL Server Agent.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Generated server-side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
• Executed stored procedures using BATCH files.
• Developed stored procedures and functions for designing various reports.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Used Batch Files to Import Data from other Data Base.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to retrieve data from Legacy sources and to retrieve PII user data from the Flat files on monthly and weekly basis.
• Expert in SSIS Deploying and Scheduling
• Identified and Defined Key Performance Indicators in SSAS 2005/2008.
• Process SSAS cubes to store data to OLAP databases
• Optimized queries and did performance tuning using various MS SQL Server tools such as SQL Profiler, SQL Performance Monitor and execution Plan and Index Tuning wizard.
• Performed backup/restore of database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.

Environment: SSIS, MS SQL Server 2008, Windows server 2003/2008, Query Analyzer, SVN, SQL Profiler, Index Tuning Wizard, MS Access, MS Excel, SQL Server Business Intelligent Development Studio

Confidential, Houston, TX

SQL /SSRS Developer

Responsibilities:

• Involved in Daily Status meetings with the team members.
• Generated Dash Board Reports for Internal Users using SQL Server 2008 R2 Reporting Services.
• Created Triggers, Stored Procedures, Functions, define User Defined Data Types, TSQL, and Create and maintain physical structures.
• Extensively used Joins and sub-queries for complex queries involving multiple tables.
• Implemented database population with complex SQL Queries, Stored procedures, Tables, Views, and other SQL Joins in Microsoft SQL Server 2008
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Optimized queries and did performance tuning using various MS SQL Server tools such as SQL Profiler, SQL Performance Monitor and execution Plan and Index Tuning wizard.
• Created SQL Server Integration Service (SSIS) packages between enterprise databases and Third-party data source to transfer data
• Created SSIS packages to load data into enterprise database using Various SSIS Tasks.
• Extract Transform and Load source data into respective target tables to build the required data marts.
• Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services (SSIS).
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Designed SSAS cube to hold summary data for Target dashboards.
• Developed Cube with Star Schema.
• Created usage-based aggregations in cube to minimize time for query retrieval from client tool Target.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
• Developed optimal stored procedures and queries to create data sets for reports.
• Designed and implemented stylish report layouts.
• Created and scheduled SSIS packages for running feeds from enterprise Database.
• 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 Drill-through and Drill- down reports using SSRS.
• Worked with UAT team after deploying to higher environments.

Environment: SSIS, TSQL, MS SQL Server 2008, Query Analyzer, SQL Profiler, Index Tuning Wizard, SSRS, MS Excel, SQL Server Business Intelligent Development Studio

Confidential, Cherry Hill, NJ

MSBI Developer

Responsibilities:

• Created Sub-reports, Drill-down reports, Drill-through reports, Summary reports and Parameterized reports in SSRS.
• Created report models and deployed on report server and into Excel and PDF.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS) 2005/2008.
• Generate various ad hoc reports using MS Reporting services.
• Created various Weekly and Monthly reports showing detailed information.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Prepared documentation related to database design, objects security and rules.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Generated DDL Queries for creation of new database objects like tables, views, indexes, triggers, stored procedures, roles and granting privileges.
• Worked on T-SQL programming such as, stored procedures, user-defined functions, cursors, views and management of linked servers to Non-SQL-Server databases.
• Created functional and technical documents, report templates and reporting standards for the rest of team.

Environment: Windows XP/2003 Enterprise edition, SOX, MS SQL Server 2005/2008, Excel, Visual Studio, TFS, Database Engine Tuning Advisor, Profiler, SQL Server Management Studio, Reporting Services Configuration, SSIS, SSRS.