PROFESSIONAL SUMMARY:

• Having 9 plus years of experience in Development and SQL Database Administration Maintenance & Support of MS SQL Servers 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017 and Azure SQL in Production, QA, Development and Test environments.
• Experience in Database Design and Development, Microsoft BI Solutions, ETL Development, Data warehouse Implementation, Report Development using PowerBI, Spotfire, SSRS and TSQL.
• Used Azure Dev OPS to create automated deployments to deploy the code into the environments.
• Complete understanding of ITIL processes and used for incident management and change management.
• Experience in migrating stand - alone databases to cluster.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and Visual Studio.
• Handled incident tickets including problem isolation, analysis, root cause, and solution implementation.
• Given recommendations on database products, services, protocols, and standards.
• Experience in troubleshooting TSQL queries.
• Experience on Windows Azure cloud.
• Excellent understanding of SQL with experience performance tuning relational databases.
• Experience in troubleshooting SQL Server related CPU, memory, I/O, disk space and other resource contention.
• By using PowerBI, PowerApps, PBI Gateway, Stand-alone servers created solutions according to the business requirements.
• Hands on experience in applying patches and Hotfixes as per the business requirement on both cluster and stand-alone systems.
• Experience in high availability SQL Server solutions, which include Log shipping, Replication, Mirroring and Always on.
• Migrated SQL server 2008/2008 R2 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Experience in implementing the High Availability Always On with Availability Groups on 4 servers.
• Migrated SSIS packages from SQL Server 2008 to SSIS 2012.
• Experience in using 3rd party tools like Networker, BMC Remedy, Tivoli and CA tools.
• Hands on experience in active/active and active/passive cluster installation and maintenance on WSFC.
• Having hands on experience on DR solutions to servers.
• Experience on Capacity Management.
• Experience in troubleshooting Performance issues.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries.
• Excellent skills in database Backup, Restoration, Recovery, Database Maintenance Planning.
• Experience in creating Jobs, and Alerts.
• Expertise in planning and implementing Database and Instance Level Security by creating logins, users, roles, and granting permissions to them.
• MS Certified IT Professional (MCITP-Database Administrator 070-450) - SQL Server 2008 design, optimize and maintain DB administration.
• MS Certified Technology Specialist (MCTS-DBA 070-432) - SQL Server 2008 Implementation and maintenance.

TECHNICAL SKILLS:

Operating Systems: Windows SERVER 2003, 2008, 2008 R2 and 2012

Databases: MS SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016 and Azure SQL databases

SQL Server Tools: SSMS, SSCM, SQL Profiler, Visual Studio MSBI (SSIS, SSRS and SSAS) and DTA

Tools: PowerBI, PowerApps, SpotFire, SQL Safe, SQL Diagnostic Manager, HP Service Manager (HPSM) and BMC Remedy.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

Lead MSBI Developer

Responsibilities:

• Working as a Lead MSBI Developer.
• Developed the ETL strategies to load the data from different sources into warehouse.
• Designed a solution to integrate D365 SQL Azure data into standalone servers.
• Developed incremental load solutions into warehouse.
• By using PowerBI, PowerApps, PBI Gateway, Stand-alone servers created solutions according the business requirements.
• Used Azure Dev OPS to create automated deployments to deploy the code into the environments.
• Working on migrating the stand-alone data warehouse to Azure SQL.
• Involved in supporting and developing new reports from data warehouse.
• Responsible for designing the facts and dimensions for the data warehouse.
• Involved in creating the POCs for PowerBI, Spotfire, Data warehouse concepts and new applications.
• Involved in Agile methodology by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems, completed work through Sprints.
• Used PowerBI, Spotfire for development of reports for Business users from different sources like tables, stored procedures and development of various types of reports.
• Used Team Foundation Server as Source Control to store Packages, Reports and SQL Scripts and share it among team members.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Improving Performance by index creation, index removal, index modification, file group modifications, and adding scheduled jobs to rebuild/reorganize and update statistics in databases.
• Given recommendations on database products, services, protocols, and standards.
• Deploying and troubleshooting the SSIS Packages.
• Performed DBA activities in the dev and stage environments.
• Involved in requirements gathering meetings and designing the solutions based on the requirements.

Environment: MS SQL Server 2012, 2014, 2016, 2017 and Azure SQL.

Confidential, Chicago

Lead MSBI Developer & DBA

Responsibilities:

• Worked as a Lead Developer and DBA.
• Involved in demerger of the Confidential.
• Lead the team to develop the code to bring the data from multiple data sources and formats.
• Responsible to design the solutions for ETL and load the data into multiple systems.
• Responsible to load from ACBS to LoanIQ.
• Developed RCF (Reconciliation Framework) to check the consistency of data.
• Involved in creating the POCs for PowerBI, Spotfire, Data warehouse concepts and new applications.
• Involved in designing, developing and implementing a solution for cash matching for LoanIQ.
• Created a near real time solution to bring data from different sources into a database.
• Involved in Agile methodology by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems, completed work through Sprints.
• Using PowerBI, Spotfire,SSRS for development of reports for Business users from different sources like tables, stored procedures and development of various types of reports.
• Used Team Foundation Server as Source Control to store Packages, Reports and SQL Scripts and share it among team members.
• Worked on performance of reports using SQL Profiler.
• Developed Package configurations for Integration, Test and Production environments and execution of SSIS packages automatically.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Improving Performance by index creation, index removal, index modification, file group modifications, and adding scheduled jobs to rebuild/reorganize and update statistics in databases.
• Given recommendations on database products, services, protocols, and standards.
• Created alerts and notifications for system errors, insufficient resources, and fatal database errors.
• Performed capacity planning to create and maintain the databases.
• Deploying and troubleshooting the SSIS Packages.
• Designed database Backup, Recovery Strategy, and Monitor their activities.

Environment: MS SQL Server 2012, 2014, 2016, 2017 and Azure SQL.

Confidential, Des Moines, IA

Senior MSBI Developer

Responsibilities:

• Worked as a Senior SSIS, SSRS Developer.
• Involved in merging Confidential.
• Developed SSIS packages to load the data from two cities.
• Developed ETL packages to convert the data into the formats required for the destination
• Developed RCF (Reconciliation Framework) to check the consistency of data.
• Involved in implementing data warehouse solution.
• Worked in designing data model.
• Created packages to view in a graphical representation through SSRS.
• Created ETL reusable processes for Error handling & Audit tracking.
• Created test cases for Unit testing and System testing.
• Developed Processes to cleanse the source data as per Business Supplied Cleansing rules.
• Implemented Column store index in some databases.
• Deploying and troubleshooting the SSIS Packages.
• Worked in Agile environment, with daily scrum and ticket updates.
• Developed C# scripts for email notifications and data validations.

Environment: MS SQL Server 2008, 2008 R2, 2012 and 2014.

Confidential

Senior SQL Server DBA/ Developer

Responsibilities:

• Worked as 24X7 on-call production DBA support including off hours and weekend support.
• Provided production, development and Test Database Administration for SQL Server.
• Installation of SQL Server 2008, 2008 R2, 2012 and 2014 based upon the requirements.
• Installing SQL Servers in Clustered environment.
• Configured High Availability Always on and Always on Groups.
• Applying required Service Packs, Hotfixes and any Critical Security Updates in clustered and standalone servers.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Improving Performance by index creation, index removal, index modification, file group modifications, and adding scheduled jobs to rebuild/reorganize and update statistics in databases.
• Configuring Transactional Replication and troubleshooting if any.
• Migrated SQL server 2008/2008 R2 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Migrated SSIS packages from SQL Server 2008 to SSIS 2012.
• Automated and enhanced daily administrative tasks, including space management, backup& Recovery and performance monitoring.
• Implemented Contained Databases to isolate from other databases in an Instance.
• Implemented Column store index in some databases.
• Handled incident tickets including problem isolation, analysis, root cause, and solution implementation.
• Given recommendations on database products, services, protocols, and standards.
• Created alerts and notifications for system errors, insufficient resources, and fatal database errors.
• Used 3rd party tools like EMC Networker and TSM in taking the backups to optimize performance.
• Configured mirroring and troubleshooting the issues.
• Used 3rd party monitoring tools like Tivoli and CA in all the servers.
• Involved in implementing and testing the Disaster Recovery.
• Implemented Auditing in sensitive databases.
• Used Data collector to maintain the management data warehouse.
• Performed capacity planning to create and maintain the databases.
• Deploying and troubleshooting the SSIS Packages.
• Designed database Backup, Recovery Strategy, and Monitor their activities.
• Created Database Maintenance plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Streamlined the server/database level security by creating the Windows and SQL logins with the appropriate server/db roles and object level permissions. Used custom server roles.
• Running the reports through SSRS.

Environment: MS SQL Server 2000, 2005, 2008, 2008 R2 and 2012.

Confidential

SQL Server DBA/ Developer

Responsibilities:

• Worked as 24X7 production support with a rotation basis.
• Installing and configuring SQL Server 2005 and 2008 both.
• Scheduled the Backups for Databases and Transaction log. Performed restoration operations.
• Creating databases and logins with permissions in SQL Server 2005/2008 as per the developer’s request.
• Monitoring a clustered database server environment.
• Used CDC (Change Data Capture) Feature to audit the changes to data.
• Used Data collector to maintain the management data warehouse.
• Used 3rd party tools like SQL Safe in taking the backups to optimize performance.
• Monitoring backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Used CDC (Change Data Capture) Feature to audit the changes to a secured table.
• Provide security on creating the database roles and server roles to the users.
• Configured Mirroring and Ensuring data synchronization between Principal and Mirror are maintained through Mirroring on some databases in the environment.
• Setup Log shipping and troubleshooting log shipping errors when arises.
• Configured Transactional Replication between the production servers.
• Hands on experience on Transactional, Merge, Snapshot, Peer to Peer Replication.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Used 3rd party tool SQL Diagnostic Manager in monitoring all the servers.

Environment: MS SQL Server 2000, 2005 and 2008.