Worked on OLAP Data warehouse, Model, Design, and Implementation.• Developed new jobs and modifying existing in new VTOM toll which supports SQL procedures to perform end to end requirements.• Deployment of new code into Production and validation for end-to-end performance.• Generated dynamic stored procedures, xml stored procedures, triggers for the database development.• Fine-tuned the complex database stored procedures and increase performance up to 7%.• Experience in Database Tuning.• Experience in Database Mirroring, Database Snapshots.• Experience in creation of logins, users and configuring permissions and assigning roles to users• Taking weekly database backup and schedules job using SQL Agent.• Involved in Backing up and restoring of databases.• Provide production supports.• Creating procedures which produce result and that used by other stream team to develop reports.• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services.• Developed SSIS packages to conduct simple and complex transformations and executed these packages using the execution package.• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.• Environment: Visual TOM, SSIS, SSAS, SSRS2008R2/2012, SQL, MS SQL Server 2016, GitHub, , SQL Server 2012/R2/2008, MS Visual Studio 2012/2008, MS Access Database, Microsoft Office 2005/2008, T-SQL

• Worked on OLAP Data warehouse, Model, Design, and Implementation.• Developed new reports and enhanced existing reports in Tableau environment.• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.• Designed the technical architecture on a J2EE based platform for SB20 part Designed GUI screens for SB20 functionality.• Used SQL Profiler for troubleshooting, monitoring, optimizing SQL Server and T-SQL statement from developers.• Worked with partitioned tables in very large database environment in RAC databases.• Worked on SQL and Vertica servers and migrated data using SSIS and Informatica.• Created various reports and dashboards using Tableau Desktop and published them to the internal team for review and further data analysis.• Documented Source Code, Critical scripts and Stored Procedures• Trained business and end user to create ad-hoc queries that decreased dependency on IT by 90%.• Developed database batch process to move reference data of the Traders to the Trading System. Extensively used Crystal report.• Created alerts for successful or unsuccessful completion of scheduled jobs. Developed ad-hoc queries for end users.• Developed and designed the Registered Rep Systems to advance the ability of local management and compliance professionals in the process of supervision and compliance of registered representatives.• Designed logical and physical database for reporting tool, generating various monthly financial & end user reports and sending them to the traders and end users. Also generated reports in different formats such as csv, pdf, rpt & txt etc.

As a Database Administration my responsibilities included as follows: • Installed and configured MS SQL Server 2016 along with Visual Studio on a network domain system. • Involved in Database design, Data modeling and writing Stored Procedures for GDC. • Used SQL profiler to optimize remote procedures and queries by creating workload files and setting various filters and parameters like cash hit ratios. • Involved in Designing User manuals and Test Cases. • Work with business analyst groups to ascertain their database reporting needs.• Take the database reporting needs and turn them into powerful SQL queries that will extract data and compile it into meaningful reports.• Perform data loads and routine updates on an ongoing basis.• Develop database application forms using MS Access in coordination with SQL tables and stored procedures.• Monitoring system performance and identifying problems that arise.• Responding in a timely manner to user-reported errors.• Protecting the database against threats or unauthorized access.• Ensuring that the database is adequately backed up and able to be recovered in the event of memory loss.• Reporting on metrics regarding usage and performance.• Suggesting changes and improvements for database maintenance or protection.• Provide technical leadership. Mentor junior staff on database technical details. • Provide technical assistance to developers.• Provide technical support to databases, including system management, backup/recovery, account management, configuration management, and trouble calls.• Perform and manage daily database maintenance, monitoring, and performance tuning tasks/jobs. Environment: MS SQL Server 2016, GitHub, AccuRev, SQL Server 2012/R2/2008, MS Visual Studio 2012/2008, SharePoint 2007, MS Access Database, Microsoft Office 2005/2008, MapPoint 2013, SSIS, SSAS, SSRS2008R2/2012, SQL, T-SQL, PL-SQL, Oracle 11g, DB2

• Experience designing and developing, data warehouses (DW), data marts and other business intelligence solutions that increase the performance, productivity and efficiency of business users. • Extensive experience performing comprehensive quality assurance, debugging, testing and corrections.• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Functions, Views, Indexes, Triggers and Constraints, CTE, Temporary Tables, Tables Variables.• Extensive Experience designing and developing SSIS packages to pull data from heterogeneous sources like SQL Server Database, Oracle Data Source, Excel files, Text Files.• Extensive Experience in performance improvement of SSIS packages and SQL Server, Oracle Data sourceDatabase, TSQL and PL/SQL queries.• Proficiency in logical, physical modeling, and data mapping for both normalized and dimensional databases.• Expertise in Extracting, Transforming and Loading (ETL/SSIS) data using various tools including SQL Server Integration Services (SSIS), DTS, BULK_INSERT, BCP and Import/Export wizard to load/migrate data to and from various sources.• Extensive experience in report creation with thorough knowledge of report serving architecture. Developed tabular, chart, list and matrix reports, drill down and drill through reports with Drop down menu using SSRS, Front end dashboards.• Experience in using tools like Database Engine Tuning Advisor, SQL Server Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.• Ability to work independently under pressure in fast-paced environment to achieve the goal.• Strong Organizational skills, Communication skills and excellent attention to detailEnvironment: SQL Server 2005/2008 R2, MS Visual Studio 2005/2008, BIDS 2005/2008, Windows XP Professional, MS Access Database, Erwin 7.3.6, TFS 2008, Microsoft Office 2005/2008,.Net Framework.

• Designed, developed and tested Database for web based application: Protocol Analyzer captures and displays complete information of network packet. Information included type, source address, destination address, data, and sending time of the packet.• Write complex stored procedures to process prospective user information and balanced the processing load between front end and back end. • Successfully Developed GUI modules for Generic Data Converter (GDC) to convert different kind of files or data into different format or files.• Installed and configured MS SQL Server 2005 along with Visual Studio on a network domain system.• Involved in Database design, Data modeling and writing Stored Procedures for GDC.• Used SQL profiler to optimize remote procedures and queries by creating workload files and setting various filters and parameters like cash hit ratios• Involved in Designing User manuals and Test Cases.Environment: Microsoft Visual Studio 2005, MS SQL Server 2000/2005, JDK 1.2, Eclipse, Swing, Servlets, CSS, HTML, Windows XP, JDK 1.2, Eclipse, JAVA, TCPIP.