● Designed and create New Databases from scratch in PostgreSQL and SQL Server.● Securing the Database and providing user rights and logins.● Created Excel and Access reports tailored to business requirements and developed interactive Power BI dashboards for presentations.● Developed dynamic charts/graphs and BI analysis in Excel using VLOOKUP, Pivot tables, and complex formulas.● Manual review and correction of numerous errors and gaps for client’s dataset using Data Analysis Expressions. ● Maintained database for the purpose of extracting reports.● Developed interactive Microsoft Power BI dashboards for presentations purpose.● Wrote complex SQL queries using various joins, unions, and functions for report purpose.● Worked with the Business users to understand what reports were critical, non-critical and not needed.

● Created Dynamic Charts/Graphs in MS Excel ● Created Queries, Reports in MS SQL Server ● Created Excel BI Analysis and reports using VLOOKUP, and Pivot tables. ● Developed interactive Microsoft Power BI dashboards for presentations purpose.● Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas.● Manually modified the SQL in Report Studio to tune and/or to write complicated reports.● Developed Power BI reports to tell compelling stories around datasets.● Wrote SQLs to implement report specific queries in reporting. Environment: MS Excel, SQL Server, PostgreSQL, Power BI, PowerPoint

• Database Administrator, Database Programming.• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.• Rebuilding the indexes at regular intervals for better performance• Designed and implemented comprehensive Backup plan and disaster recovery strategies.• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.• Monitored and modified Performance using execution plans and Index tuning.• Deploying new code base release to UAT and Production Environments.• Perform SQL Server service pack and Windows Service pack upgrades.• Working with customers on Application rollouts and server migrations.• Extensively worked on Enterprise Manager for managing the database.• Troubleshoot performance problems and fine-tuning of databases.• Involved in Index Analysis and Performance Tuning.• Worked with different upstream team for downloading ETL MART data.• Migrating SQL Server 2008 R2 data bases into SQL Server 2012.• Recovering the databases from backup in disasters.• Analyze long running/slow queries and tuning to optimize application and system performance.

• Installation, configuration and maintenance of MS SQL server 2008R2 and 2012• Monitoring the server for High availability of the servers.• Solving the request raised by user support.• Participate in implementation of new releases into production.• Worked on SQL Server 2012, migration from SQL Server 2008 / 2008R2• Troubleshoot performance problems, fine-tuning of databases and index Analysis.• Monitoring SQL server performance using SQL Profiler to find performance and dead locks• Identifying and tracing user activities like who has/is deleting, updating, inserting and accessing what.• A 27/7 audition at a certain period of time with the aid of both internal and external auditors.• Ensure data protection with constant and or periodic Data base backup with a well-tested recovery plan for a quick and save recovery of data when there is a problem• Ensure high availability with the use of database clustering, log shipping and database mirroring • Worked on configuring SQL Server with minimum privileged access.• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN • Monitoring of database size and disk space in Production, Staging & Development environments• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases• Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.