SUMMARY:

• Have over six years of focused experiences in IT industry in various fields like financial and telecom domain. Extensive experiences in Microsoft SQL Server Business Intelligence (BI) and data warehouse design, analysis, modeling, development, administration, implementation, trouble shooting and quality management. Comprehensive experience as senior MS BI and SSIS ETL developer; proficient in designing the logical and physical model of the enterprise level databases. Have impeccable communication and interpersonal skills and an exceptional team player.

TECHNICAL SKILLS:

Database Language MS BI Stack Development Tools/Utilities: Microsoft SQL Server 2008R2/2012/2014, MySQL 5.x, Oracle 11g/12c T - SQL, HTML / CSS /JavaScript, XML, C/C++/C#, PowerShell SSRS/SSAS/SSIS, Visual Studio 2010/2012/2013 , SharePoint Agile/Scrum, JIRA, Rally, SVN, Git/Github SSMS, Visual Studio 2012/2013/2015

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Senior Microsoft SQL Server/SSIS Developer

• Partner with data and business analysts to refine the business requirements that must be met for building and maintaining data warehouses/marts built on Microsoft SQL Server 2012.
• Designed, created and regular tuned of physical database objects (tables, views, indexes) in MS SQL Server 2012 to support normalized and dimensional models.
• Configured SQL Server maintenance plans to automatically back up SQL Server Databases, optimize index and update statistics
• Worked as a primary T-SQL developer in creating complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Designed and implemented Modular and Reusable ETL processes and associated data structures for Data Staging, Change Data Capture (CDC), Data Balancing & Reconciliation, Exception Handling & Reject Recycling, Surrogate Key Generation & Assignment, Data Lineage Tracking, ETL Auditing, etc.
• Used SQL Server Profiler to trace long running queries for optimizing databases.
• Designed, created and regular tuned of physical database objects (tables, views, indexes) in MS SQL Server 2012 to support normalized and dimensional models.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, Oracle etc. to SQL Server using SSIS various features such as multitasking, conditional split, union, union all, merge, lookup, fuzzy lookup, data conversion.
• Collaborated with system teams and development teams for codes release including MSSQL database changes and patches.
• Involved in all phases of Software Development Life-Cycle (SDLC) by using Agile / Scrum methodologies in the current development activities.
• Took the lead to enhance team development practices on SQL Server Data Tools, Visual Studio and Team Foundation Services.
• Identify and analyze expensive T-SQL stored procedure by using the SQL Profiler, SQL analyzer, create the necessary indexes and SQL hints to improve query performance.
• Documented All Microsoft SQL Database structures and functionalities. Worked with Auditors and Provided Database related documents.
• Provided day to day support of data warehouse and troubleshooting of existing process and procedures.
• Worked on 7X24 on-call rotation to support the production environment.

Confidential

Data Analyst

• Involved in gathering requirements, performing source system analysis and development of ETL jobs to migrate data from the source to the target Data Warehouse.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Transformed data from MS SQL Server 2008R2 to MS SQL Server 2012 using OLE DB connection by creating various SSIS packages.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Built reports in SSRS for errors generated by SSIS Packages; generated Reports using Data Source Views in Report Builder; created Drill Down, Drill through, linked and sub reports using SSRS.
• Generated various type SSRS reports that could be used to send information to different vendors, clients and managers.
• Scripted several database maintenance tasks reducing manual processes and related overheads.
• Managed production deployments of schema changes and data conversions.
• Recreated indexes, optimized queries, memory management to improve performance.
• Created and managed full-text server, linked servers to support production needs.
• Tested and installed latest SQL server / Windows server service packs on all SQL servers
• Created strong passwords for SA account, sometimes disabled it, remove sample databases.
• Ran Microsoft Baseline security analyzer periodically to check for SQL server security issues.
• Worked on database maintenance (including DB changes, DB patch, DB index tuning)
• Extensively involved in all the phases of Report Life Cycle (Authorizing, Managing, and Delivery).
• Created ad-hoc Reports using SQL Server Reporting Services to validate the information inserted to the warehouse after refreshing it.

Confidential, Southlake, TX

Microsoft SQL Server T-SQL Developer

• Responsible for requirements gathering, status reporting, creating various metrics, project deliverables.
• Developed Complex SQL queries using various joins and developed various dynamic SQL's thorough out the projects.
• Built efficient ETL packages with SSIS to fetch, cleanse and transform data from various types of sources. Develop package configurations dynamically as well as populating variables dynamically.
• Written complex SQL statements using joins, sub queries, correlated sub queries and CTE.
• Generated variety of business reports using SQL Server 2008 SSRS including matrix report, parameter report, and dashboard with charts and drill down function.
• Built reports from Analysis Services cube using MDX query designer; configured report server and deployed reports on web server and SharePoint, built Performance Points Dashboards in SharePoint.
• Developed Complex SQL queries using various joins and developed various dynamic SQL's thorough out the projects. Tuning long-running SQL Queries, Procedures and Functions using SQL Profiler, SQL analyzer, Index tuning wizard.
• Work with development teams to make best schema design that balances feature requests with performance concerns.
• Coordinate with the team that responds to all system problems in order to reduce or eliminate production problems by analyzing production usage information and using that information to design a better architecture.
• Built efficient ETL packages with SSIS to fetch, cleanse and transform data from various types of sources. Develop package configurations dynamically as well as populating variables dynamically.
• Increase availability and performance of applications by gathering and analyzing server and database metrics with various monitoring tools.