1. Work with engineers to perform performance evaluation and provide recommendations. 2. Provide technical assistance and advice to ensure smooth system performance while development and after deployment phases. 3. Analyze test results and provide appropriate solutions 4. Provide technical assistance to improve system performance, capacity, reliability, and scalability. 5. Evaluate performance monitoring tools based on the company’s needs 6. Perform root cause analysis of performance issues and suggest corrective actions. 7. Ensure non-functional requirements for performance parameter (CPU usage, latency, blocking, volumes etc.). 8. Oversee system performance lifecycle and identify key metrics for performance improvements. 9. Evaluate system performance and provide suggestions for macro level improvements. 10. Generate periodic performance reports for senior management for capacity planning. 11. Document optimization best practices and produce reference configurations and sizing 12. Find out Automate solutions 13. On call support in emergence

Platform: SQL Server 2014 Enterprise Edition With High Availability, T-SQL, Integration Services (SSIS), Reporting Services (SSRS) and Microstrategy, ER/Studio, Query Analyzer, SQL Profiler, Enterprise Manager, Windows OS, Ignite – server monitoring tool. ER/Studio (Embarcadero) and MongoDB for static data.

Platform: Tableau (7.3 & 8.x) Client and Server integration, SharePoint integration with Performance point and SSRS, SQL Server 2012 Enterprise Edition-SQL, Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), Query Analyzer, SQL Profiler, Enterprise Manager, ER/Studio (Embarcadero).

• Collaborated with end-users and stakeholders to bring form and clarity to multitude of data sources, enabling data to be displayed in meaningful, analytic manner.• Estimated work and timelines; split workload into components for individual work which resulted in providing effective and timely business and technical solutions to ensure projects were delivered on time, within budget, adhering to high quality standards and meeting stakeholder expectations.• Enforced database standards, best practices, methodologies, processes and procedures which resulted in consistency across projects, enabled comparative evaluation and priorities, process improvements, consistent metrics to meet expectations, and flexibility to match project complexity.• Application deployment and sync up database objects across all environments.• Write routine to upload X Millions records to database in few minutes with PK, Unique and Mandatory validations. • Help company run SQL Server faster and more reliably.• Tune SQL Server by examining current workloads and hardware, making improvements, and measuring the results.• Worked with developers to tune the SQL queries using SQL Profiler • Managing Database related issue • To provide load balance strategies to improve demographic data retrieving and searching mechanism • Review SQL Server objects/Procedures and improve the performance and reduce log generation each transaction.• Generated tableau dashboards and drilldown reports for different categories/segments and reference lines, User Java Script API to customize the views, selects, filters, date and time combination charts for clear understanding.• Create job schedules to data source sync between SQL server/External and Tableau server for incremental/full data cycle to minimize lag period in dashboard.• End User Support and Communication• Subject matter expert (SME) for Database activity, including Financial reporting; technical SME for reporting user training.

Primarily responsible and owner of All DSS system’s load programs and their performance tuning.Set up the SSIS packages for the exchange of data between different data sources (SQL Server, Oracle, and Tara Data).• Involved in extracting large volumes of data from different data sources, performing transformations and loading that data into another data sources.Provide source data to CA’s OLAP engines to create cubes to provide reports like SSRS, COGNOS, SharePoint and Excel.Integrated XML with DB and write\store procedure to save and retrieve data from DB and send to GUI (.net) application & SAP using XML• Involved in the design and generation of reports for different data sources using SQL Server reporting services.• Designed SQL Server database tables, views, stored procedures, triggers and functions.• Monitored the performance of SQL Server using SQL Server Profiler.• Designed different kinds of transactions for the application. • Performed data transformation services and bulk inserts for large amounts of data.• Set up the SSIS packages for the exchange of data between different data sources.

Role: • Database Architect • Mentor for team members.• Manage communication and development .• Subject matter expert (SME) for Database activity.• Application deployment and sync• Coding in SQL server, Oracle, VB, C#, ASP.NET, SQL, T-SQL,PL/SQLProject Details: 1. Web base ERP Application (Duration April-2005 - May-2006) 2. Legal Community Information Portal - Legal Search Portal (Duration Nov-2005 March-2005) 3. Customer Relation and Sales Management (Duration April-2005 August-2005) 4. Payment Batch Management. (Duration November-2004 March-2005) 5. Business-to-Business portal for dot2Net Inc. (Duration Jan-2004 May-2004 ) 6. Migration Project (Duration - Jan-2001 - Oct-2001 ) 7. Inventory Management (Mar-2000 - Dec-2000 ) 8. Material Requirement and Production Planning (Mar-2000 - Dec-2000 ) 9. Project Monitoring System & Asset Management (Duration Jun-96 - Nov 97 )