PROFESSIONAL SUMMARY:

• Over 8+ years of professional experience in working with projects driven on SQL Microsoft Business Intelligence tools, Data Warehousing and ETL processes.
• Experience in all phases of the Software Development Life Cycle (SDLC).
• Proficient in relational database modeling(Conceptual, Logical and Physical Modeling) and normalization
• Strong RDBMS concepts and experience in creating and maintaining Stored Procedures, Views, Functions, Triggers, Indexes, and Constraints.
• Designed, developed and implemented various SSIS Packages and deployed using Deployment Wizard.
• Experienced in ETL from various heterogeneous data sources like Access, Excel, and CSV, flat files using connectors, tasks and transformations provided by SSIS.
• Proficient in creating dynamic SSIS packages for Incremental Loads and used change data capture (CDC) control task that makes efficient data loading.
• Experienced in Configuring Batch Logging, Error Logging, event handlers and Connection Managers in SSIS.
• Good hands on experience on performance tuning of SQL server for handling transactions at high volume.
• Experienced in migrating data from one SQL Server version to another.
• Highly experienced in database server performance tuning and optimization of Complex SQL queries.
• Experienced in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Experience with data security and privacy by datasets.
• An excellent team player & technically strong person who has capability to work with business users, project managers, team leads and architects, thus maintaining healthy environment in the project.
• Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS:

RDBMS: SQL Server 2005/ 2008/2008 R2/ 2012/2014, DB2

Database/ETL Tools: SSIS, SSAS, SSRS, Informatica Cloud, Snowflake Computing, Microsoft Azure

Reporting: SQL Server Reporting Services (SSRS), Report Builder, cognos, tableau

Languages: VB.NET, C#, C++, T - SQL, E-SQL

MS-Office: Microsoft Office Tools

Operating Systems: Windows Server 2000, 2003, 2008, 2008R2, 2012

Tools: Backup Utility, Litespeed for SQL Server, Visio

Data Warehousing:

BI Tools: SQL Server Business Intelligence Development - SSIS, SSAS, SSRS, DTS, BI Stack (Power pivot, Power query, Power map)

Database Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, T-SQL, PL/SQL, OLAP, MOLAP, ROLAP, OLTP, Cubes

Reporting Tools: SQL Server Reporting Services, MS Excel, Power BI, Tableau Application Packages MS-Frontpage, Microsoft Office Suite, SSIS, SSAS, SSRS Operating Systems Windows 8 - 2003, XP, 2000, NT, ME, 98, Macintosh Programming Languages C, C++,C#, Java, Javascript, ASP.Net, VB.Net Other Software Work Shelf, Adobe Software

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

SQL/Application developer

Responsibilities:

• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.(used CTE, temporary tables, user defined table types in codes developed) worked on fixing Bugs and Enhancement on the application those related to the databases
• Used SVN subversion for version control
• Good experience in handling Errors/Exceptions and debugging the issues in large scale applications
• Flexible, adaptive, quick learner, team oriented, collaborative with peers, team leads, business heads
• Experienced in large-scale custom development and/or systems integration projects across multiple Phases of the software development lifecycle (SDLC)
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Implemented application security logging to splunk.
• Prepared test plans and test strategies, executed and reviewed the test cases. worked with JSON and XML data formats created different SSIS packages using multiple data sources and destination used script task and script components transformation to create solutions that are not implemented with regular SSIS worked as production support(on call support)

Environment: SQL Server Integration Services (SSIS), T-SQL Server, Windows 10, Visual Studio 2017,SQL server 2014, JAVA/J2EE, Eclipse, SVN subversion, Splunk, Tomcat,Github,SSRS,JIRA,TFS,AGILE

Confidential, Dayton, OH

SQL/SSIS/ ETL Developer

Responsibilities:

• Worked as a SQL developer to write complex queries like Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Created and developed SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a particular time depending on requirements.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008/2012.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load using Visual Studio.
• Design daily/weekly/monthly SSRS reports utilizing multiple types of reports including sub reports, Drill Through/Drill Down, and Cascading Parameterized Reports
• Scheduled SSIS packages for running monthly/weekly/daily feeds from and to various vendors using SQL server Agent.
• 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 and various transformations
• Integrated SSIS packages with the windows batch to trigger the SSIS package.
• Used TFS for source code management of developed codes/version control,
• Created expressions in SSRS to provide flexibility to users by providing them with variety of Options for seeing the business information in tables/charts etc.
• Debug through C#.NET code to troubleshoot production issues and created unit test methods for validation of codes developed.
• Created Alerts/log entries for successfully completed and failed jobs
• Rebuilding/Reorganize indexes and running Database Consistency Check Commands (DBCC).
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Coordinated and attended every day standup/scrum/agile meetings and weekly sprint meetings to evaluate completed work.
• Ensured HIPPA and regulatory compliance rules are addressed for all data movement
• Worked on Agile Methodology and Microsoft Team Foundation Server (TFS)

Environment: MS SQL Server 2016, Excel, SQL,T-SQL, SSIS,SSRS, Microsoft Visual Studio 2014, Microsoft Visio, Teradata, Informatica, TeamCity, Octopus, Agile/Scrum, TFS.

Confidential

Data analyst/application developer

Responsibilities:

• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Successfully installed and configured MS SQL Server 2005 on the production server.
• Automated the migration of data from Oracle DB to MS SQL Server 2005 DB using Microsoft SQL Server Migration Assistant (SSMA).
• Migrated the entire schema, as well as, data into MS SQL Server 2005 and also validated the migration process to ensure that it has been successfully migrated.
• Designed Drill down, Drill through, and Parameterized reports using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Designed, reviewed, and created primary objects such as views, indexes, views and stored procedures.
• Worked with User Defined Functions and Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that had the least update to improve the query performance.
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
• Experience in creating multi-dimensional cubes using SSAS and designing DW Schemas.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2012.
• Created Calculated Member in MOLAP cube using MDX in SSAS 2012.
• Implemented user based subject selection (Role based security) in Power Views, Power Pivots and SSRS using DAX, MDX and SQL queries.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Performed error and event handling: precedence Constraints, Break Points, Check points and Logging, re-running the failed SSIS packages using checkpoints.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Modified the SSIS packages for adding the new columns in the SSAS cubes and used Pivot transformation to pivot the data.
• Developed SSIS packages, which extract the data from Oracle source, which involves developing the code in oracle from the scratch.
• Developed SSIS packages to extract the data from SQL server tables and import the data to excel files.
• Worked with Business Analysts and Users to understand the requirement.
• Improved the performance of the SSRS reports by tuning the SQL server code and modifying the SSIS packages associated with the reports.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
• Work with the end users to ensure that the reports are working as per the Business requirements specified

Environment: MS SQL Server 2005/2008, Visual Studio-2006, T-SQL, DTS Designer, MS-Office, MS-Excel, VSS, SSRS,SSIS