SUMMARY

• Over 9 years of IT experience in SQL Server Database Design, Development and Implementation of SQLSERVER 2016/2014/2012/2008 R2/2005 and providing ETL/Business Intelligence applications using Microsoft components.
• Effectively involved in all the phases of Software Development Life Cycle such as Analysis, Design, Development, Testing, Implementation and Maintenance of projects.
• Extensive SQL Development experience in a Banking & Healthcare environment with a strong understanding of data & analytics.
• Experience working in Waterfall and Agile development methodologies.
• Working experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T - SQL Programming using DDL, DML, and DCL commands for various business applications.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.
• Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability and Expert in using SQL Server Agent to Schedule and monitor Job.
• Experience in Error handling and debugging coding issues and troubleshoot production problems
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMF’s and Query Execution Plans
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations.
• Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access, Oracle and DB2) and SQL Server as a part of Data Migration, Data Maintenance
• Expertise in merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill down and web reporting by customizing URL Access.
• Expertise in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports.
• Extensive knowledge of database installation and configuration principles and In-depth knowledge of database procedures, regulations, applications and methods.
• Experience in Database Backup, Recovery and Disaster Recovery Procedures.
• Experience in developing applications using C#. Net, VB.Net and Strong Experience in Unit, Integration and System Testing.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.

TECHNICAL SKILLS

DATABASE: MS SQL Server 2005/2008 R2, 2012, 2014, 2016 Oracle8i/9i/10g, DB2, MS Access, My SQL

SQL Server Tools/Utility: SQL Server Management Studio (SSMS), SQL SERVER BIDS, Database Tuning Advisor, Enterprise Manager, BCP, SQL Profiler, Visual Studio 2005/2010/2013/2015

Programming Languages: T-SQL, PL/SQL, HTML, XML T-SQL, Oracle Pascal, C, C++, Visual Basic 6.0. VB.Net, PowerShell

Tools: DTS, SSIS, SSRS, SSAS, Erwin, Red Gate SQL Compare, Solar Winds

Version control Tools: Subversion SVN, Team Founder Server TFS, GIT Hub

Operating Systems: Windows NT/98/2000/XP/2003/2008,2012 server, Unix, Linux, Mac OS

IT Processes: Software Development Life Cycle (SDLC)

PROFESSIONAL EXPERIENCE

Confidential, Beaverton, OR

MS SQL Server Developer SSIS/SSRS

Responsibilities:

• Created and monitored Database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.
• Creating and managing schema objects such as Tables, Views, Indexes, Stored Procedures and referential integrity depending on user requirements and converting them into technical specifications.
• Involved in T-SQL code review and modification for the development of new requirements.Performed queries tune-up, integrity verification, analysis and interpretation.
• Collaborated with Java Developers and architect to design database and to create new database objects (Tables, Views, Indexes, Stored Procedures).
• Created the logical and physical data modelling using Erwin tool also Involved in designing and building relational databases.
• Responsible for maintaining and updating data model and data Dictionary for each release.
• Designed SSIS Packages to transfer data from Excel source files, to SQL Server 2014.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve data from the Flat files on monthly and weekly basis.
• Responsible for troubleshooting and deploying SSIS packages.
• Designed and developed ETL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2012 for further Data Analysis and Reporting by using multiple transformations.
• Identified and resolved database performance issues, database capacity issues. Also Developed and implemented backup and recovery strategy.
• Monitored Log shipping/ Transactional Replication and troubleshooting errors. Running Index tuning wizard and rebuilding indexes for faster query response.
• Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer
• Resolving any dead locks issues with the Databases/Servers on a real-time basis.
• Installed, configured and supported SSRS and manage subscriptions and deploying reports
• Developed and automated the process for SSRS reports deployment and subscription.
• Responsible for Database Backups & Restoration, Backup Strategies and Scheduling Backups.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Worked on SQL Server 2014 migration from SQL Server 2008R2 also Installed and configured SQL Server 2014 on windows server 2012R2.
• Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Supported day-to-day operational duties for the database platform such as service requests and tickets, backups, monitoring, performance tuning, system troubleshooting.
• Developed PowerShell Scripts to automate repetitive tasks across all servers. Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Provided technical assistance by responding to inquiries regarding errors, problems, or technical questions; train end users and technical support staff as required.
• Documenting new and existing processes as well as updating existing documentation when changes are necessary.

Environment: MS SQL Server 2008R2/2012/2014,2016 SSRS, SSIS, SQL Query Analyzer, SQL profiler, Erwin Data Modeler, Windows Server 2012/2008, Share Point Portal Server, PowerShell Scripting, Visual Studio 2010/2015, MS Access, MS Excel 2010,IBM rational Clear Quest, Solar winds, SVN, GECS, Agile Environment.

Confidential, Brentwood, TN

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Developed backup and recovery strategies for SQL Server databases. Experience involved in using tools like SQL profiler for Monitoring and Tuning MS SQL Server.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Filtered, purged and cleansed bad data from legacy system using complex T-SQL, PL/SQL statements in staging area, and implemented various constraints and triggers for data consistency
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing complex transformations using SSIS/DTS packages.
• Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages and Updating and maintaining Visual Source Safe. Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Created ETL SSIS packages both design and code to process data to target databases.
• Identify and resolve problems encountered during both development and release of the SSIS code.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging and Production environments.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Responsible for the design of the SSIS package for updating the data mart from OLTP database and validation of the aggregate data from the ODS and the OLTP Database
• Designed SSRS Reports from scratch depending upon the requirements of the markets, vendors, providers and scanners. Debugging and troubleshooting the technical issues while implementing the applications.
• Improved the performance of SSRS reports by tuning the Stored Procedures and TSQL queries using various join conditions.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Worked with storage and network administrators to plan and estimate drive space and storage needs throughout the environment
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• Documented all the work and all the process of integration and reporting services for further references
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC).

Environment: MS SQL Server 2012/2008R2, SSRS, SSIS, SQL Query Analyzer, SQL profiler, Oracle 10g, PL/SQL, IIS 6.0,Enterprise Manager, Windows Server 2008R2, DTS, Share Point Portal Server 2010, HTML, XML, C#, .Net, ASP.NET, Visual Studio 2005/2010, TFS, MS Access, Crystal Reports, MDX, MS Excel 2007, Agile Environment.

Confidential, Charlotte, NC

MS SQL Server Developer SSRS/SSAS

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification.
• Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks
• Developed database objects like tables, views, stored procedures in SQL Server 2008
• Created Partition Tables based upon Partition Functions and Partition Schemas
• Involved in Performance Tuning of the Stored Procedures, User Defined Functions and long running queries.
• Proper use of Indexes to enhance the performance of individual queries for very fast and efficient reporting process
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc.
• Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Involved in development and modification of existing Financial Reports and Marketing Reports, which include Corporate Consolidation Reports, Financial Reports and Planning Reports for management.
• Created number of standard reports and complex reports to analyze data using Slice & Dice and Drill Down, Drill through using SSRS
• Created reports using SQL Server reporting services SSRS, which is then exported as PDF. Reports variables are passed from ASP.NET web pages.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using SSRS
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).
• Created MDX queries with Calculations, KPIs, Actions and Partitions, Aggregations in SSAS.
• Involved in creating Dataset in the MS reporting services (SSRS) for calling the stored procedures and passed the parameters to the dataset.
• Created reports based on the format specified in the design document designed and created Report templates, bar graphs and pie charts based on the financial data.
• Involved in Unit Testing, Integration and deployment in Production and Staging Servers.
• Used .Net Framework for creating Reports and also for customization of reports.
• Involved in gathering Report Development Specifications (RDS) and SOWs for creating reports and documented all the processes involved in maintaining the database for future reference

Confidential, Nashville, TN

MS SQL Server Developer SSIS/SSRS

Responsibilities:

• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency, Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Involved in designing the physical database models on SQL Server 2005 RDBMS using DML/DDL implementing constraints and triggers for data integrity.
• Worked on Transactional Replication and replicated thousands of tables from various Databases to different production Server.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Developed SSIS Templates that can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev., Test and Production Environments.
• Worked on development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Created SSIS process design architecting the flow of data from various sources to target and Involved in extracting the data using SSIS from OLTP to OLAP.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages. Created incremental data load task using SQL Server Integration services
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages
• Using Dtsx Change tool converted DTS packages to SQL Server 2005 SSIS packages.
• Responsible for maintaining cubes using SSAS and populate the cubes with the data
• Created Tabular Matrix reports, Charts and graphs as per customer requirements Using SSRS.
• Good understanding of SSRS with Report authoring, Report management, Report delivery and Report security and Created reports with Analysis Services Cube as the data source using SSRS 2005/2008.
• Worked on QNXT claims and Conversion of Interface Programs from Legacy to QNXT.
• Involved in conversion interfaces on QNXT Member, Provider, Claims Processing, Utilization Management, Accumulators, Contracts and Benefits.
• Used techniques like backups, restore, replication, and standby databases to ensure higher availability Production Environment.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Worked with development teams in the design of physical databases and in modification.

Environment: MS SQL Server 2008/2005, SSRS, SSAS, SSIS, SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle10g, 11g, Enterprise Manager, ERWIN Data Modeler, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML, C#, .Net, ASP.NET, PowerShell Scripting, Visual Studio 2005, MS Access, Crystal Reports, MS Excel 2007.

Confidential

MS SQL Server Developer

Responsibilities:

• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User defined Data type, Clustered & Non-clustered Indexes
• Installed and configure servers and clients using SQL Server 2008,Upgraded SQL databases.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing
• Managed indexes, statistics and tuned queries by using execution plan for fetching the performance of the databases and Managed database portioning across multiple disks
• Query optimizations (T SQL or Query Analyzer) using query analyzer and Index tuning wizards
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
• Created SSIS ETL packages both design and code to process data to target databases
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler
• Created Snapshots, Subscriptions and Transactions using Replication services. Implement automated Index Maintenance strategy run as SQL Job on a daily basis
• Worked on Transactional Replication and replicated thousands of tables from various Databases to different production Server
• Resolving any dead locks issues with the Databases/Servers on a real-time basis.
• Migrated SQL server 2000 DTS packages to SQL Server 2008 SSIS packages using SQL Server 2008 Upgrade Advisor

Environment: SQL Server 2005/2008, T-SQL Windows Enterprise Server 2003/2008, Enterprise Manager, SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Server Profiler, XML, Microsoft Visio 2003, SFTP