PROFESSIONAL SUMMARY:

• 8 years of experience in Database Development, Administration and Data Architecture using SQL server 2000/ 2005/2008/2008 R 2/2012/2014/2016 systems in OLTP and OLAP environment.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SSIS 2008
• Generated daily and weekly monthly reports involving customized and on- demand reports using SSRS and involved in analysing multi-dimensional reports in SSRS
• Integrated and transformed data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 by creating SSIS packages.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Performed migrations from SQL Server and 2008 R2, SQL Server 2005, SQL Server 2008 to SQL Server 2012 and Expertise in installation, migration, applying Service Packs, Hotfixes and Critical Security Updates released by Microsoft.
• Installed and maintained SQL Server failover clustering (active/active and active/passive) for SQL Server 2005 and SQL Server 2008R2, SQL Server 2012 versions and have a good understanding of SQL Server 2014 features always ON, user defined server roles.
• Strong experience in monitoring database performance and tuning using various native tools namely Extended Events, Performance Monitor, Activity Monitor, SQL Profiler and Third Party Tools.
• Experience in Query Optimization techniques using DMV’s and DMF’s, DBCC commands, Index Rebuild / Reorganising and used tools to identify slow running queries using Server-side tracing.
• Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting .
• Experience on Database Mirroring and Log shipping, SQL Server Replication that is Snapshot, Transactional and SQL Server failover cluster installation.
• Expertise in Business Intelligence including SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Extensive experience in generating different type of reports including: parameterized reports, formatted reports, tabular forms, matrix forms, cached reports, drill-down reports, drill through reports, charts and sub reports using SSRS 2008/2008R2/2012.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Index, Views, User Functions, SQL joins, Relational Database Systems following Data Integrity and normalization.
• Filtered bad and inconsistent data using complex T-SQL statements and implemented various constraints and triggers to maintain data consistency and to handle complex business rules, history data and audit analysis.
• Created stored procedures and used Common Table Expressions (CTE) and various kinds of User Defined Functions (UDF) in the stored procedures to make the code easy to understand and reliable.
• Configured Security at Active Directory and SQL Server by mapping users to roles. (Securable and Permissions).
• Experience in Production Support for very large (VLDB) and Complex Databases.
• Provided Disaster Recovery through Replicated SAN and Multi Subnet Clustering.
• Implemented SQL Server Failover Cluster Installation.
• Has experience in using SCOM (System Centre Operations Managers) for monitoring performance.
• Worked with Microsoft Power BI to create reports and Dashboards upon the business requirements
• Has experience in 24*7 Production Support and in mentoring junior SQL developers.
• Experience in analysing blocking issues, concurrency and locking.
• Have experience in all phases of software development life cycle including project management, functional requirements definition, technical design, development, testing, quality assurance, system certification, systems implementation and system validation.
• Develop or modify SQL queries and stored procedures to meet business requirements and achieve desired performance
• Worked in VB.NET, C#.NET environments.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation.
• Performed Hardening of servers after migration of data.
• Expertise in designing solutions using SSIS, SSRS and created Database Management warehouse, management data warehousing.
• Strong working knowledge of IIS7.0 and Windows Server Administration.
• Experience in working with ITIL Methodologies, Agile/SCRUM based product development teams, collect database requirements and provide solutions and recommendations for new schema, infrastructure or architecture.

TECHNICAL SKILLS:

Languages: C, C++, DDL, DML, T-SQL, SQL, PL/SQL

RDBMS: MS SQL Server 2014, 2012, 2008R2, 2008, 2005, 2000, SSAS, SSIS, SSRS, MS Access.

Front End: HTML 3/5, CSS, MS Visual Basics 6.0, SharePoint2010,2013

Middle Tier: Servlets, JSP, JAAS, JTA, JSTL, JTA, EJB 2.0/3.0, MSMQ, Microsoft .Net Technology.

Tool: Technologies: JIIRA, TFS, SSIS, SSAS, BCP, Red Gate, Lite Speed IIS 7.0, MTS, ERWIN 4.0, VISIO 2007

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr MS SQL Server Developer

Responsibilities:

• Extensive experience in developing Stored Procedures, Views, Cursors, Triggers, Scripts and Complex Queries in MS SQL Server.
• Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
• Hands on experience in Creating Star Schema and Snow Flake Schemas.
• Utilized Dynamic T-SQL within functions, stored procedures, views, and tables.
• Optimized the performance of queries in TSQL queries, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Developed dashboards using Tableau for demographic information such as population and allow users to drill into geographical objects such state and county information.
• Created various T-SQL scripts for RDBMS applications.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Configured SQL mail agent for sending the error records to a different team.
• Designed rich dashboards with power BI and prepared user stories to create compelling dashboards.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Extensively used BI tools like Integration service, Reporting Services and Analysis services in MS SQL server 2005 and 2008R2.
• Developed C# scripting for packages.
• Performed most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
• Used ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Worked with SSIS packages involved FTP, send mail, script tasks, Merge, and Merge joining Control Flow Transformations.
• Generated reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Generated Monthly, Yearly, Quarterly and daily reports in Power BI and SSRS.
• Performing the ETL operations to support the incremental , historical data loads and transformations using SSIS.
• Designed SSIS packages for synchronizing the data between two different servers .
• Worked on Linux environment using virtual machines
• Created reports and Dashboards using Microsoft Power BI and integrating it into applications
• Used Power BI for Data warehousing which includes data discovery and Data Preparation.
• Responsible to archive data from local SQL Server database to Azure SQL Database in cloud using Stretch Database.
• Used Azure to create and configure databases in remote servers.
• Created Interactive reports and live Dash Board.
• Designed the application by implementing Spring framework based on MVC.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Created Ad-hoc reports and cascading reports, Pivot Tables for historical data using SSRS 2008.
• Worked with RCM (Revenue Cycle Management) to unify business and clinical sides of health care by managing Administrative Data
• Worked with Registration, Pre-registration and Coding modules
• Provided the required reports in claims according to the goals.

Environment: SQL Server 2008R 2/2012/2014/2016 , Windows Server 2008(x64), SQL Server Management Studio, Visual Studio 2013, T-SQL, VB Script, PowerShell, SQL Profiler, Hadoop, Big Data, No SQL databases, C#.NET, VB.NET.

Confidential, Amherst, MA

Sr MS SQL Server Developer.

Responsibilities:

• Performed migrations from SQL server 2008R2 to SQL server 2012
• Implemented and Maintained Clustering (active/active, active/passive) as a high availability procedure.
• Implemented and Maintained Transactional and Snapshot Replication and Performed troubleshooting and fine-tuning of databases for its performance and concurrency.
• Performing query optimization and performance tuning using native tools like performance monitor, resource monitor, profiler, DMV’S and performance reports.
• Applying required Service Packs, Hotfixes and any Critical Security Updates in clustered and standalone servers and managing SQL server using PowerShell scripts
• Creating logins and database users, roles and providing permissions to users and roles according to the requirement and security policy.
• Has implemented TDE (Transparent Data Encryption) and column level encryption.
• Deploying reports in reporting server and Creating and providing permissions to users on reports in a reporting server.
• Worked with both mac and Linux based systems on Development and on Production Environment.
• Configured report manager for creating report subscriptions, snapshots, and caching.
• Uploaded Reports on to Report manager and Organized them based on Business Rules.
• Integrated and transformed data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 using OLE DB connection providers by creating various SSIS packages.
• Performed several transformations and data cleansing on data including fuzzy lookup, slowly changing dimension, union all, merge join and check points/break points.
• Created SSIS packages to load data into staging table and data mart and Performed logging in SSIS packages to capture error data and for error handling.
• Performed Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Created maintenance plans for Re-indexing/Reorganizing Indexes and for performing DBCC checks on databases and updating statistics for smooth execution of queries and purging old files for preventing space issue.
• Designed scripts using T-SQL for getting information about history of backups and restoration, database space utilization, alert for critical errors or events, resource intensive queries and general monitoring and maintenance tasks.
• Used Cloud Storage tools like Azure cloud and AWS to transfer and maintain data storage in the Data Warehouse.
• Worked with SAP Business objects to gain business intelligence from data.
• Used Tool Crystal Reports for generating reports from different data sources

Environment: SQL Server 2005/2008R2/2012/2014, Windows Server 2008(x64), SQL Server Management Studio, Visual Studio 2013, T-SQL, VB Script, PowerShell, SQL Profiler, Activity Monitor, Data Collector, Performance Monitor, Database Tuning Advisor,C#.NET, VB.NET.

Confidential, Rockville, MD

MS SQL Developer

Responsibilities:

• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Created complex SQL stored procedures using Microsoft SQL Server 2008 and 2008 R2
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Experience in developing reports using SSRS 2008 and SSRS 2008 R2
• Created SSIS-ETL packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, Execute package task
• Created cubes and dimensions and measures and calculated measures according to the business requirements.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS2008.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Deployed SSIS packages and Reports to Production Servers.
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Created SSIS Packages from various data sources.
• Created ETL packages in SSIS with event handling, try/catch.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.

Environment: SQL Server 2005/2008/2008 R2/2012, Windows 2008 server, Windows Server 2008(x64), SQL Server Management Studio, Visual Studio 2010, T-SQL,VB Script, PowerShell, SSRS, Crystal Reports, SSIS,SQL Profiler, Activity Monitor, Data Collector, Performance Monitor, Database Tuning Advisor, Tivoli storage manager, lite speed tool, C#.NET, VB.NET.

Confidential, New York, NY

SQL Server Developer

Responsibilities:

• Performed migrations from SQL server 2005 to SQL Server 2008
• Implemented and Maintained Clustering (active/active, active/passive) as a high availability procedure.
• Worked on Always on and Disaster Recovery Options
• Implemented and Maintained Transactional and Snapshot Replication and Performed troubleshooting and fine-tuning of databases for its performance and concurrency.
• Performing query optimization and performance tuning using native tools like performance monitor, resource monitor, profiler, DMV’S and performance reports.
• Applying required Service Packs, Hotfixes and any Critical Security Updates in clustered and standalone servers and managing SQL server using PowerShell scripts
• Creating logins and database users, roles and providing permissions to users and roles according to the requirement and security policy.
• Has implemented TDE (Transparent Data Encryption) and column level encryption.
• Deploying reports in reporting server and Creating and providing permissions to users on reports in a reporting server.
• Configured report manager for creating report subscriptions, snapshots, and caching.
• Worked with Tools Such as Crystal Reports to create reports based on the requirements.
• Used Central Configuration manager to trouble shoot and configure the Server nodes
• Uploaded Reports on to Report manager and Organized them based on Business Rules.
• Integrated and transformed data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 using OLE DB connection providers by creating various SSIS packages.
• Used IBM Web Sphere Data power to accelerate web services and Deployments
• Performed several transformations and data cleansing on data including fuzzy lookup, slowly changing dimension, union all, merge join and check points/break points.
• Created SSIS packages to load data into staging table and data mart and Performed logging in SSIS packages to capture error data and for error handling.
• Performed Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Used BI Integrated SharePoint to manage and Archive Various Records
• Created maintenance plans for Re-indexing/Reorganizing Indexes and for performing DBCC checks on databases and updating statistics for smooth execution of queries
• Designed scripts using T-SQL for getting information about history of backups and restoration, database space utilization, alert for critical errors or events, resource intensive queries and general monitoring and maintenance tasks.
• Worked with Different Debt management tools Like FICO Debt management to manage and control different economic and regulatory Challenges.
• Used automated tools to generate the financial reports.
• Worked with IBM Cloud for the backup and restore of the databases

Environment: SQL Server 2005/2008R2/2012, Windows Server 2008(x64), SQL Server Management Studio, Visual Studio 2013, T-SQL,VB Script, PowerShell, SQL Profiler, Activity Monitor, Data Collector, Performance Monitor, Database Tuning Advisor

Confidential, Pittsburgh, PA

Database Developer

Responsibilities:

• SQL Server 2000/2000(X64)/2005 Installation and Configuration.
• Migrated DTS packages from SQL Server 2000 to SSIS SQL server 2005.
• SQL 2005 - Performed installation of SQL Enterprise bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers, Patch applications.
• Wrote SQL and batch scripts for automation and maintenance tasks.
• Wrote Stored Procedures, function, views and triggers as per the business requirement.
• Design SQL Server Inventory application.
• Experience with TFS and source safe.
• Worked on Transaction replication.
• Experience in checking Actual and estimated execution plans to find out performance issues for long running quires and find out how SQL Server optimizer is behaving while the query is running in terms of (Nested loop, Hash and Merge Join).
• Experience in checking each operator property compare that with SQL Server query to find what columns are needed to be indexed to get the better performance.
• Experience in running and stopping server side trace to get more information about performance issues on production servers.
• Worked with SAP Business objects to gain business intelligence from data.
• Used Tool Crystal Reports for generating reports from different data sources
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005.
• Worked on daily routine tasks like backup, refresh lower environments, security requests and issues.
• Worked on DB2 LUW and z/OS mainframe and different versions of DB2 like DB2 9 on both distributed platforms and z/OS
• Integrated DB2 to eclipse and visual studio environment
• Involved in Error Processing and dealing with deadlocks and trigger roll back issues
• Used Facets Integration tool for rapid implementation and smooth integration Reduce the time required to handle accumulators
• Worked with the Different database tools such as SQL Server 2005 and oracle database 9

Environment: SQL, PL/SQL, SQL Server Management Studio, Visual Studio 2005, SSAS 2005, SQL Server 2000/2005.