EXPERIENCE SUMMARY:

• 7+ years of experience in MS SQL Server experience in Designing, Coding, Analysis, Development, Maintenance, Implementation and support of MS SQL Server (V ) and oracle SQL 2012/2018.
• Experience in configuring and maintaining the performance of large and critical MS SQL Server database applications.
• Experience in large - scale Databases systems using execution of SQL jobs, SSIS packages, stored procedures, triggers, quires.
• Experience in writing, Reporting Service (SSRS) 2005/2008 R2.
• Experience in SQL Data Processing, Transformation and Loading (ETL) tools (SSIS, informatica) database integration with Oracle, SQL Server and other databases.
• Experience in developing and designing reports using SQL Server Reporting Services (SSRS), Crystal reports, XML and Excel spreadsheet.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Designed reports with complex sub reports, drill down, cross Tabs, formulas, functions, parameters, multiple grouping, running totals, charts, multiple sections and mailing label.
• Experience in developing report specifications based on business requirements.
• Interacted with users in resolving the Help Desk Tickets (Jira Tickets) and tracking the issues and provided on call support after reports are deployed to production.
• Experience in daily meetings for Bug scrub to update the whole team on bus status.
• Experience in creating summary data reports and Detail Reports.
• Prepare and review the activity, progress and performances reports.
• Efficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent SQL Profiler, restoring database using full, differential, and transactional log backups.
• Modified existing reports and developed new reports by analyzing the databases, data sources and structures.
• Experience in performing Backup & Restore using different backup medias, involved in creating & documenting Backup strategy & Disaster Recovery plan for development servers within specified maintenance Window.
• Experience in working with Reports where data must share across Sub reports, Pie and Bar Charts. Tested Reports for accuracy using SQL quires in TOAD and SQL Developer.
• Good experience in Automation Configuration by Creating Jobs, Alerts and Maintenance plans. Crated parameters, running totals, filters, and conditions for suppressing data, grouping on crystal reports.
• Developed new filter options to sort data in excel format reports.
• Hands on experience with SQL Server Management Studio and T-SQL in constructing triggers, tables, user functions, views, indexes, covering indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Excellent Knowledge in SQL Server Administration, SQL Server Integration Service (SSIS) and SQL Server Reporting Service (SSRS) and SQL Server Analysis Services (SSAS).
• Knowledge on SQL Server and Database Monitoring & Tuning for better performance using different tools like Database Tuning Advisor, Systems Performance Monitor, and Event viewer, SQL Profiler.
• Applied security setting in Dev, QA, UAT and Production domains by testing the reports.
• Performed unit testing, system testing and user acceptance testing UAT for reports.

TECHNICAL SKILLS:

Operating Systems: Windows NT 4.0, Windows 2010 Enterprise/Advanced Server, Windows 2010, 2003 Enterprise/Datacenter Server, XP Professional and Windows 2000, UNIX.

Databases: MS SQL Server 2012, 2008 R2/2005/2000, Oracle SQL.

Programming Languages: T-SQL, C, C++, Basic Java Script, CSS, Shell Scripting, UNIX shell scripting, SQL, XMLVB.NET, MDX

Business Tools: Word, Excel, PowerPoint, Access, Visio, and Outlook.

Database Tools: SQL Server Enterprise Manager, Oracle SQL, SQL Query Analyzer, SQL Profiler, SQL Alerts, Index Tuning Wizard, BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS, SSRS, SSAS, Index Analyzer, SQL Client Utility.

Reporting Tools: Reporting Service (SSRS) 2012/2013/2016, Crystal Enterprise 8.8/XI R2, crystal reports 2008/8.5/9.0, info viewETL Tools DTS, SSIS.

Data Modeling: Erwin v 4.0, Visio 5.0

PROFESSIONAL EXPERIENCE:

SQL Developer

Confidential

Responsibilities:

• Collected business requirements from users and translated them to technical specifications and design documents for development.
• Ensure data quality by writing and executing procedures for cross checking totals and identifying data anomalies. Triage data related issues.
• Assist in troubleshooting and impact analysis of any changes made to the database Objects.
• Optimize SQL performance, integrity and security of databases/schemas. Contribute to the optimization of data management and performance tuning.
• Working with Stake holders and Business Analysts to gather requirements and Mapping these requirements to mapping document from source to destination.
• Perform tuning and trouble-shooting of applications, modules and reports to improve performance and minimize system resource constraints.
• Utilize various tools to evaluate performance and implement remedies to improve performance, including tuning database parameters and SQL statements
• Writing SQL Scripts to extract data from various applications and validating the data internally to match with existing requirements.
• Investigated and debugged queries and SSIS packages to solve specific issues.
• Analyzing and Establishing security features in SQL Server Reporting Environment.
• Normalizing the Data to load it to optimize Application Server with respect to destination entity.
• Perform SQL tuning to improve the performance of the queries.
• Collaborated with the business owners to ensure systems performances and integrity.
• Developed Expressions on the web application by using basic java script for stake holders.
• Developing stored procedures and user defined functions for batch scripting and scheduling these stored procedures to run in regular intervals.
• Worked with report subscriptions in SSRS to send the weekly run automated reports to end users and worked with Report snapshots.
• Designed and developed procedures for new processes and online system process.
• Configured the reports in Report server and tested the reports.
• Responsible for report development, report testing and report implementation.
• Involved in Production support team to support the production issues and resolved the issues as soon as possible and have done the Report Validation for reports for the generated reports to test and update into Production.
• Integrated the data from different data sources like MS Access, Flat File, Csv, and Excel to SQL Server.
• Worked with offshore team to develop reports/ resolve issues.
• Created Complex SQL quires using PIVOT, UNPIVOT conditions to get the data and display in reports.
• Reported issues on the database to the manager and suggested the fixes to improve the performance of the overall application which will help the Users.
• Create and update documentation for all reports and processes and Performed unit testing, system testing and user acceptance testing UAT for reports.

Environment: MSSQL Server 2012/2014, Tableau, Visual Studio 2012/2015, SSMS, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), HTML, CSS, Basic java script, UNIX, Team Foundation Server, Power BI, SharePoint, tortoise SVN, JIRA, Visio.

SQL Developer

Confidential, Boston, MA

Responsibilities:

• Develop new custom reports using Crystal Reports for Business and Workflow of DCAMM (Division of Capital Asset Management and Maintenance) and Department of Labor Standards (DLS).
• Creating reports using crystal reports and ACCELA Ad-Hoc reporting and publishing reports to reports manager.
• Collected business requirements from users and translated them to technical specifications and design documents for development.
• Responsible for creating, supporting and maintaining reports, as well as, troubleshooting and solving customer report issues via phone and email.
• Managed servers to ensure the configuration and deployed the reports in Production servers.
• Configured the reports in Accela report manager and tested the reports.
• Supported Accela end users with production reporting issues and interacted with users in resolving Help Desk Tickets (Jira Tickets).
• Created and exported reports from crystal to excel for the Accela workflow process.
• Involved with the Users and gathered requirements for accounting reports and schedule the reports using Info View to run at specific times as desired by the business users.
• Involved in getting requirements from the user, writing stored procedure from transaction and developing reports using crystal reports 2008. Maintaining proper documentation of the reports for future reference.
• Developed reports with creating complex crystal reports on demand, ad Hoc Reports, Summary reports, Sub reports, Drill-down, Dynamic grouping, Cross-Tab and graphical.
• Responsible for report development, report testing and report implementation.
• Developing Template based and Letter Based report for daily business process.
• Developed Accela expressions for the Accela application specific information table to get the data into reports as required and global variables.
• Developed Accela manual configuration and Designed Application specific by using page layout editor and Application specific information table.
• Involved in Production support team to support the production issues and resolved the issues as soon as possible and have done the Report Validation for reports for the generated reports to test and update into Production
• Created Quick Quires for the application users for quick processing the data.
• Modified pre-created reports according to new requirements and maintained existing Accela Reports.
• Wrote Formulas to calculate the percentages and summaries based on the group levels.
• Created the SQL Update complex quires to update the data in Database as requested from manager.
• Developed and supported Accela Statistical reports for the user and analysis solutions.
• Worked intensively on crystal reporting console and produced monthly reports.
• Integrated the data from different data sources like MS Access, Flat File, Csv, and Excel to SQL Server.
• Worked with offshore team to develop reports/ resolve issues.
• Created Complex SQL quires using PIVOT, UNPIVOT conditions to get the data and display in reports.
• Exported Reports into PDF, Excel, word and RTF from Enterprise and resolved formatting issues.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly reports using Crystal Reports and Ad-Hoc reports.
• Reported issues on the database to the manager and suggested the fixes to improve the performance of the overall application which will help the Users.
• Use Sprint methodology to develop the product and daily meetings.
• Create and update documentation for all reports and processes and Performed unit testing, system testing and user acceptance testing UAT for reports.

Environment: Oracle SQL Developer 2012, PL SQL, TOAD, Crystal Reports Enterprise 8.8, Crystal Reports 2008/9.0, MS SQL Server 2008, SSRS, report builder, ACCELA Automation AA, ACA, tortoise SVN.

Confidential, CA

SQL Developer

Responsibilities:

• Collected business requirements from users and translated them to technical specifications and design documents for development.
• Actively involved in setting up database policies and procedures for internal and production environments.
• Wrote complex SQL queries for report developers.
• Integrated the data from different data sources like MS Access, Flat File, Csv, and Excel to SQL Server.
• Created complex Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.
• Responsible for performance tuning. Improved the performance by tuning the store procedures/views/adding appropriate indexes.
• Created Complex SSIS packages using PIVOT, UNPIVOT.
• Transformed the data to desired data types using Data Conversion task and Derived Column.
• Scheduled SSIS packages to run every night and send email alerts on Success or Failure using Event Handlers.
• Responsible for Development environment used by the Developers.
• Generated reports for the senior management team to make some business decisions.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Worked with the developers on a daily basis to review the stored procedures/views to ensure the performance. Suggested changes as needed.
• Reported issues on the database to the manager and suggested the fixes to improve the performance of the overall application which will help the Users.

Environment: SQL Server 2008/2012, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, MS SQL Server DTS, SSISNET, SSRS 2008, and UNIX.

SQL Developer

Confidential, San Jose, CA

Responsibilities:

• Created tables, temporary tables, table variables, indexes, procedures, views and triggers for automating various tasks in TSQL.
• Documenting the process of validation performed by comparing the CSV files with the stored procedures resulted tables.
• Developed database connections, SQL joins, loops, views and aggregates.
• Developed the complex SQL quires by using PIVOR, UNPIVOT conditions to get the data as required.
• Documenting every step of the stored procedures, which explains the flow, and meaning of the T-SQL statements.
• Worked a lot with the MS Excel, CSV files.
• Ability to understand new and complex data structures.
• Performance tuning of SQL Server queries and the stored procedures. Good hands on experience on using the SQL Profiler and execution plan.
• Worked with Application Teams on creating a productive Development, Test and Production environment for Application

Environment: SQL Server 2000/2005, T- SQL, Analysis Services, Windows 2000, MS Office, SQL Query Analyzer, MS Excel.

SQL Developer

Confidential

Responsibilities:

• Created tables, temporary tables, table variables, indexes, procedures, views and triggers for automating various tasks in TSQL.
• I nvolved in Requirement Analysis, Design, Development and Testing phase.
• Installed and configured SQL Server 2000, Software, Tools Utilities in Development and Production servers.
• Migrated the databases from various systems SQL Server 2000, Oracle, and MySQL.
• Performed the deployment activities in different client place remotely and solved the issues during deployment phase.
• Performed daily DB activities on various servers which include Database consistency, Integrity health checks, Index tuning, backup and restore strategies etc.
• Handled various requests/issues of users related to applications, production servers and databases.
• Written T-SQL scripts, Designed and created Databases, tables, views, indexes, stored procedures, functions, triggers, batch jobs, created complex reports using crystal report, error handling mechanism as per the business requirements.
• Created DDL and DML commands through command line tools OSQL as well as GUI tools Query Analyzer, Enterprise Manager, Management Studio, etc.
• Managed SQL databases, security, created user accounts / logins for development purpose and implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Used Performance monitor, SQL Profiler and Execution plan to optimize queries and enhance the performance of database servers and to solve long/slow running Queries.
• Involved in optimization fine-tuning, debugging the database objects.

Environment: Windows Server 2000, MS SQL Server 2000, T-SQL, DTS, Oracle, MySQL, Crystal Report, IIS 6.x, .Net framework, Asp.net, C, XML, VSS etc.