SUMMARY

• 12+ years of experience in Business Intelligence as SQL developer, Database Administrator and Software developer.
• Extensive experience on BI Technology using SSIS, SSRS & SSAS .
• Having knowledge about ticketing and SLA related customer escalation and follow up process.
• Extensive operational experience and Customer facing issues.
• Extensive experience of Software development involved design, development, implementation, and Testing in the areas of .Net (C#) and SQL .
• Having knowledge in COSMOS and SQL Azure .
• Extensive Experience in MVC and Entity framework model.
• Extensive experience as a SQL Server Database administration including Installation configuration, troubleshooting, Database Backup, Performance Tuning, High availability, Windows, and failover clustering (Both Production and Development environment)
• Extensive experience of supporting multiple Production SQL Servers (2012, 2008) in 24x7 environment hosted on Windows 2012 server and windows 2003 server platforms
• Demonstrated record of high performance standards, including attention to accuracy, schedules, details, deadlines and quality work even under high pressure and rigid deadlines
• Profound Knowledge of SDLC and Software Testing Life Cycle.
• Having experience to manage 10 members team including Onsite and Offsite.
• Excellent team member with problem solving and trouble shooting skills
• Profound Knowledge of SDLC and Software Testing Life Cycle.

TECHNICAL SKILLS

Programming Languages: T - SQL, C#, VB.NET, C, C++ (Academic only)

Databases: MS SQL Server 2012, SQL Azure, MS Access, Oracle (In Academic)

OS/Platforms: Windows Client OS Win 98 and after, Windows Servers SQL Server Integration Services (SSIS)

ETL: ASP.NET, Ajax, Windows Azure Visual Studio

E-Com/Web Technologies: Visual Studio Team Foundation Server, Visual Source Safe, Source Depot

Development Environments: MS-Office Stack Microsoft Visio for Architects COSMOS & SQL Azure

Source Control Tools: Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), PowerBI Windows PowerShell, Batch scripting SDLC, Agile

PROFESSIONAL EXPERIENCE

SDE

Confidential, Redmond, WA

Responsibilities:

• Developed Scope scripts as part of ETL process.
• Database design and development for automation feature using C# and SQL.
• SQL programming for ETL and reporting in PowerBI.
• Automate VSO work Item creation using REST API in C#.
• End to End Program execution from gathering requirement till deployment.
• Support SQL related issues and setup monitoring process to track the issues.
• Created service which runs on schedule and pull data from VSO tracking database to SQL azure database.
• Improved the performance of Mail2Bug tool and fixed the bugs as well.
• Managed Scrum process with multiple teams and planning for new bi-weekly process.

SQL Developer/DBA

Confidential, Redmond, WA

Responsibilities:

• Database design and development for billing features/databases using SQL .
• SQL programming for ETL and reporting from SSRS
• Implemented SSIS packages to integrate data between different data sources (CSV File,SQL Database) and load to SQL Server 2012/2008 or files with proper mapping.
• Developed or modified SSRS Reports (SQL Server 2008 Reporting Service).
• Developed cube using SSAS to ensure better application performance and flexible reporting.
• Designed and Developed Data Model using Star Schema.
• Designed and created data marts, indexes, views, aggregations, stored procedures, partitions, calculated measures, and data integrity.
• Worked on SQL Profiler and Estimated Query plan to optimize the performance of SQL queries and stored procedures.
• Agile/Scrum methodology was used throughout the project, performed pivotal role in planning and developing as well as aligning with the assigned sprints.
• Worked in Configuring & troubleshooting Clustering, AlwaysOn in SQL Server 2012
• Process big data using Cosmos and Scope.
• In-place upgrade of existing SQL Server Failover Cluster in 2008, 2008R2,2012
• Good Experience in to automate routine processes with PowerShell
• Estimation of the storage and computational hardware requirements
• Designing and development of workflows using Windows Workflow foundation for Billing data flow from distributed file system to SQL databases.
• Windows PowerShell scripting for automating the build and test process
• Managed code programming to develop a robust database shrinking solution to shrink production database into smaller versions to use in testing environments
• Working on customer related issues and fix them within SLA.

SQL DBA/.Net Developer

Confidential

Responsibilities:

• Data Warehouse design for analyzing security trend in organization
• ETL Designing using SSIS for Data Warehouse
• Worked in Configuring & troubleshooting Clustering, AlwaysOn in SQL Server 2012
• Experience in SSIS package /DTS creation, deployment and performing ETL Task
• Defined many Cubes using SSAS services to generate reports in SSRS
• Understanding knowledge in SSAS.
• Including OLAP and Data Mining algorithm
• In-place upgrade of existing SQL Server Failover Cluster in 2008, 2008R2,2012
• Good Experience in Troubleshooting of Fail Over Clustering and in SQL Servers (2012, 2008)
• Worked on Mirroring and Log shipping for SQL Server High Availability in SQL Servers (2012, 2008)
• Good Experience in Troubleshooting Replication in SQL Servers (2012, 2008, 2005)
• Worked on various SQL Server databases of size till 500GB, 3TB
• Good Experience in to automate routine processes with PowerShell
• Created tool to download data from COSMSO using Scope language .
• As an OPS worked on MS Ticketing and follow up till resolution.
• Proficient in Microsoft SQL Server installation, configuration, performance tuning, client/server connectivity, Clustering, query optimization, back-up/recovery, disaster recovery and trouble shooting
• Backup restore and recovery activities using SQL Script
• Good experience in Server Tuning and optimization, identifying query performance bottlenecks by using SQL profiler and trouble shooting performance issues
• Monitoring the growth of database to ensure smooth running of daily activities
• Sound Understanding of SQL Database Engine Architecture, Physical and Logical Structure
• Good knowledge in SQL, T-SQL, PL/SQL, and query optimization
• Ability to proactively identify, troubleshoot and resolve live database systems issues
• Deployment of bits from pre-production environments through Octopus.
• Optimizing Index and SQL Queries
• Apply windows patching, deployments and hotfix

SQL Dev\Tester

Confidential

Responsibilities:

• Successfully implemented Test Architecture and Tests in SQL Test Shell.
• Designed the Testing Architecture for SWA tool.
• T-SQL Programming using SQL Server 2008
• ETL Designing & Development using SSIS, Business Intelligence Studio
• .Net Development for SSIS using VB.Net
• Performance Tuning of Stored Procedures, SSIS Packages
• SQL reporting using SSRS
• T-SQL Code Reviews
• Improvising performance of queries.