PROFESSIONAL SUMMARY:

• Over 7+ years of extensive experience in Database Design, Data Modeling, Programming, Development and Administration of Client Server Applications using SQL Server versions (2000 - 2016)
• Extensive work knowledge in handling huge databases & worked on performance tuning and query optimizations, d ata integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor
• Experience in using Microsoft BI studio products like SSIS, SSAS, and SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• 5+ years of experience in Analysis, Design, Development and Testing of Client-server and Web-based n-tier architecture for windows and web applications using Microsoft .net technologies
• Good experience to entire Software Development Life Cycle (SDLC), documentation of software products with Agile, Scrum and waterfall methodology.
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles
• Highly experienced in whole life cycle of DTS/SQL server integration services (SSIS 2005/2008), Packages (Developing, Deploying, Scheduling, Troubleshooting & monitoring) Data Transfers and ETL purposes across different servers.
• Extensive experience in Configuration, Implementation and Maintenance for Disaster Recovery solutions using Log Shipping, Mirroring and Clustering
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues
• Experience in Migrating Oracle & MYSQL databases to MSSQL using SSMA tool
• Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing
• Automated day to day maintenance tasks using PowerShell scripts, converting existing TSQL batch scripts to PowerShell scripts and improving SQL Server maintenance jobs performance

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL 11g, Dynamic SQL, MDX, C, C++, C#, ASP (.Net), XML, HTML, HTTP, Shell Scripting

Databases: MS-SQL Server Denali, 2000, 2005, 2008, 2008R2, 2012, 2014 & 2016

DWH/BI Tools: SSIS, SSRS, SSAS, BIDS, Informatica, Visual Studio, Cognos, Crystal reports, VBA Add ins, Excel data sorting

Database Design Tools & Data Modeling: Ms Visio, ERWIN 4.5/4.0, star schema/Snowflake schema modeling, FACT & Dimension tables, Physical and Logical data modeling & de normalization techniques

Packages: MS Office, MS SharePoint server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import and Export Wizard, Visual Studio, .Net Microsoft Management Console, Business Intelligence Development Studio (BIDS), Crystal Reports, Power Pivot, Pro Clarity, Microsoft Office, Lotus Notes, Excel Power Pivot, Excel Data Explorer, Tableau, Power BI & Cubes (Tabular)

Operating Systems: Windows 2000/ XP/7, Windows Server 2003, 2008, 2010 UNIX

WORK EXPERIENCE:

MSBI Developer

Confidential, TN

Responsibilities:

• Installation, Configuration and Maintenance of Multiple Instances of SQL Server 2016/2012/2008 R2 in Development, Staging and Production Environments
• Installed Service Packs, Hot fixes, Service Packs on Various SQL Servers
• Implemented and Maintained Always On in Production Environments
• Managed Policy Based Environment on User, Database and Object Level Security in SQL Server
• Involved in Capacity Planning and Setting Up of New Environments
• Installed SQL Server Integration Services, SQL Server Reporting Services and SQL Server Analysis Services on Various Environments
• Implemented Transactional Replication in Various Environments
• Created and Maintained Various Database Maintenance Plans
• Created Maintenance Plans for scheduling the full, diff and T-Log Backup's
• Migrated SQL Server 2008R2 Databases to SQL Server 2012 and SQL Server 2012 Databases to SQL Server 2016
• Migrated databases to cloud environment on Microsoft Azure
• Worked on setting up the log shipping between the databases
• Deployed Various T-SQL Scripts, SSIS Packages and SSRS Reports
• Use the third part tools such as Apex SQL Diff for comparing the Schema and to overwrite any changes on the new servers
• Monitored Performance in the Production Environments and involved in troubleshooting and Fine Tuning of the Databases for optimizing performance
• Monitored Various Query Plans for Query Cost and Provided Valuable Suggestions in Performance Tuning to the Development Teams
• Created Various Clustered and Non-Clustered Indexes to optimize performance and Re-Created, Re-Organized Various Indexes per their Fragmentation Levels
• Performed Health Checks on Various SQL Server Environments using DBCC Commands
• Created Various Extended Events to Monitor Locks and Deadlocks
• Managed Disk space, memory, and User connections
• Created Various SQL Server Alerts and Reports for Monitoring
• Solved the regular tickets that we received from different application team and pointing them towards the successful completion
• Technical Analysis, Code Review, Release reviews and Implementation & on call 24 x 7 production support

Environment: Sql Server 2014/2012/2008 /2008 R2/2005, T-SQL, TFS, Excel, MS Visio

SQL Server/ BI Developer

Confidential, Pekin, TN

Responsibilities:

• Assisted in complete Life Cycle including Design, Development and Testing of an Application
• As a part of SQL DB team, was primarily responsible for planning DR, ensuring databases are online and providing infrastructure and application DB support
• Developed application using C#.Net, ASP.NET
• Troubleshooting and Performance tuning of SQL Server using DMV's, Performance Counters and Extended Events
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements
• As a developer created complex Stored Procedures, triggers, cursors, and other SQL joins and statements for applications
• Created database Maintenance Plans, SQL Server Jobs and deployed custom maintenance scripts to schedule regular DBA tasks for enhancing the performance of SQL Server. Some of these tasks included Database Integrity checks and Re-Indexing, Updating Statistics, Full and Transactional Log Backups and DBCC Cleanup
• Created web pages using HTML5, JQuery, CSS, JavaScript developed layout pages
• Solely maintained a database for the reporting purposes like creating database and other SQL table objects
• Worked on SSIS packages to load the date from application database to reporting database
• Installed, configured and maintained MS SQL fail over clustering for critical production servers
• Daily routine Developer/DBA tasks like handling user's permissions and space issues on Production and UAT Servers and handling maintenance Jobs
• Excellent experience configuring and maintaining all three types of replication like transactional snapshot and merge replication

Environment: SQL Server 2008R2/2012, Microsoft Business Intelligence Development Studio, T-SQL, SSIS, SSRS, SQL Profiler, C#.Net, ASP.NET

Sr. MS SQL SERVER/ SSIS/SSRS/SSAS Developer

Confidential, NC

Responsibilities:

• Analyzed the client requirements and translate them into technical requirements
• Extensively worked on T-SQL for creating stored procedures, indexes and functions
• Performance Tuning of SQL queries and stored procedures using SQL Profiler
• Assisted in designing and management of PostgreSQL database schemas and tables
• Managed index statistics, Tables, Views, cursors and optimized queries by using execution plan for tuning the database, Implemented different types of constraints on tables
• Extensively worked on designing reports using SQL Server Reporting Services (SSRS)
• Worked on SSRS 2008 to generate about 30+ reports for various user groups and developer groups
• Developing Tabular Reports, ad-hoc Reports using SSRS Report Designer & generating several types of drill down and drill through reports using SSRS
• Developing complex SSRS reports using multiple data providers, global variables, expressions, user defined objects, charts, and synchronized queries
• Designing and implementing parameterized and cascading-parameterized reports using SSRS.
• Deploying reports, creating report schedules and subscriptions. Managing and securing reports using SSRS
• Using Data Analysis Expressions DAX to creating custom calculations in Power Pivot for Microsoft Excel workbooks
• Produce scripts to synchronize SQL Server databases across environments using vendor tool Redgate SQL Compare
• Work as a PostgreSQL database consultant and Application Developer for virtupal machine management
• 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)
• Extensively worked on Data Flow tasks like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task
• Used various control flow tasks like FTP, Bulk insert task, Conditional Split, Multicast, Merge task and different data flow tasks
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
• Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split and many more
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc
• Successfully migrated SSIS packages from development to test and Production environments using SSIS Configuration files and deployment wizard
• Created and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly and monthly loads

Environment: MS SQL Server 2014/2012/2008 R2, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS),SSAS,DB2, MS SQL Profiler, Crystal Reports, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2005, Cognos, Windows XP,MDX C#, ASP.NET,, XML, Erwin v4.1, MS Office 2013

SQL Server Developer

Confidential

Responsibilities:

• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Upgrading of SQL Servers.
• Performed Physical and Logical Data Modeling for databases of varied sizes including VLDBs.
• Configured DR solution with Transaction Replication from Distribution Server with multiple Updatable subscriptions.
• Involved in Installation, Configuration and Deployment of SSRS Reports using different topologies.
• Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2008.
• Used Process Explorer for maintenance of stuck process, and to release the handles on files
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Provided On-Call support to Mission critical Environments and expertise with Disaster Recovery mechanisms.
• Maintained two different databases: Read-only reporting database and Disaster recovery database
• Performed security tasks like Grant, Revoke permissions for security tasks
• Resolved issues for mission critical high usage of system CPU, Disk, Deadlocks and Transaction per/sec, Memory.
• Developed Stored Procedures, Triggers, and SQL scripts for performing automation tasks
• Performed and fine-tuned Stored Procedures and SQL Queries and User Defined Functions.
• Implemented Table Partitioning, Advanced Error handling, Common Table Expression (CTE) and LINQ.
• Involved in training Update features for Business solution of SQL Server

Environment: SQL Server 2000/2005/2008/2008 R2,2012, T-SQL, Windows Server, Microsoft Visio, Performance Monitor, SQL Server Profiler, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)