SUMMARY

• Experienced database developer having experience in enterprise application development projects for various domains - banking, manufacturing, public finance, and healthcare. Mostly worked with .NET technologies and Microsoft SQL Server, and T-SQL.
• Over 10 years of experience in Information Technology, with software and database development experience in web based multi-tier enterprise application development projects
• Exposure to .NET framework especially in ASP.NET MVC, WCF and Web API
• Exposure to various RDBMS - SQL Server, Oracle, MySQL, DB2, and MS ACCESS
• Strong knowledge of database modeling, OLAP, OLTP systems.
• Experience in Normalizing and De-normalizing tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys
• Database development experience with SQL Server 2005/2008/2012/2014/2016 databases
• 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
• Experience in Tuning T-SQL queries using query tuning methodologies and tools.
• Experience in improving system performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor and ability to identify I/O bottlenecks and costly data processing design
• Experience with Microsoft Business Intelligence tools - SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS)
• Wrote parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2008 R2/2012/2014 using data from ETL Loads, and various heterogeneous data sources
• Experience of working with Microsoft Power BI dashboards and Analysis Services Tabular models
• Transformed data from one server to other servers using tools - Bulk Copy Program (BCP), and ETL workflows using SSIS packages
• Experience working in Agile SDLC environment and Team Foundation Server
• Excellent communication skills, and ability to communicate ideas, problems, and issues to different stakeholders - business users, subject matter experts, and application developers

TECHNICAL SKILLS

Operating System: Windows2000 Server, Windows Server 2003/2003R2/2008/2008R2/2012/2012, R2/2016Linux, OS-400

RDBMS: MS SQL Server 2005/2008//2008 R 2/2012/2014/2016 , MS Access, MySQL, Oracle 9i/l0g

Languages: SQL, T-SQL, C#, Java

Web Technologies: HTML, CSS, JavaScript, ASP.NET MVC, WCF, Web API

Tools: and Packages: SQL Server Management studio(SSMS), Microsoft Business Intelligence tools - SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), ETL, SSDT, SQL Server Analytical Services (SSAS), Power BI, Visual Studio, Team Foundation Server, Git version control

Languages: C#.NET, VB.NET, VB6.0 and Core Java

Productivity App: MS Excel, MS Visio, MS Office

PROFESSIONAL EXPERIENCE

Confidential, Parsippany, NJ

Senior SQL Server Consultant

Responsibilities:

• Studied the Business Logic and its requirements for the solution of application, and assisted with the data modelling.
• Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers and Functions.
• Worked on existing data and data sources and designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and load data
• Extracted data from various sources like SQL server 2008 R2, Oracle 9i, CSV, Excel and text file from various systems and through FTP
• Developed User Defined Functions and Stored procedures to implement Physician-On-Call processes for matching physician and registered hospitals requiring expert physician advice
• Developed matching algorithms and data update for work in progress and completion of remote physician services
• Developed business logic for implementing dashboard reporting module. Extract and load appropriate data from other modules into dashboard system as report data
• Developed stored procedures for processing and presenting various reports
• Developed complex and long stored procedures for both Online and Batch requests handling business logic and Functionality of Various modules
• Worked on performance tuning of stored procedures and large T-SQL Queries using Clustered Indexes and Efficient Coding standards
• Monitored, tuned, and troubleshooted database performance and database concurrency
• Also used using SQL Server Reporting Services (SSRS 2014) to Design various enterprise reports.

Environment: C#, ASP.NET, SQL Server 2014, SSRS, SSIS, Oracle 9i, Visual Studio 2015, HTML, CSS, JavaScript, jQuery, Team Foundation Server (TFS).

Confidential, Silver Spring, MD

Senior SQL Database Developer

Responsibilities:

• Work directly with functional analysts and business users in understanding requirements, Security requirements, Enterprise Data Sources and External Data Feeds
• Developed data architecture, design and creation of MS SQL tables, views, triggers and other objects required for loan exchange analysis, web statistics & analysis.
• Installed SQL 2012 and all necessary tools in the Development, Staging, and Production environments
• Installed and utilized the Oracle 10g .Net Data Provider for use with SQL Server 2012
• Wrote SQL and stored procedure to analyze loan information and business logic for bidding and loan reward processes based on ROI data of the loan bidders
• Implemented business logic with SQL for regulatory processes while offering the bid.
• Implemented data conversion and analysis logic for web crawler data with SQL and stored procedure
• Troubleshot stored procedures and query performances using SQL Server Profiler, Performance Monitor and DBCC Commands
• Used Execution Plan, SQL Profiler, database engine tuning advisor, and performance monitor to optimize queries and enhance the Performance of databases
• Created SSIS Packages to Extract, Transform and Load (ETL) the data into main modules for loan analysis
• Loaded data for web crawler extracted data into the reporting modules
• Converted DTS packages to SSIS packages, validating the packages, and migrating to SQL Server 2012 Integration services
• Developed ad hoc and customized reports using SQL Server Reporting Services (SSRS)

Environment: C#, MVC 5, ASP.NET Web API, SQL Server 2012, SSRS, SSIS, Oracle 10g, HTML, CSS, Bootstrap, JavaScript, jQuery, Visual Studio 2015, Team Foundation Server (TFS).

Confidential

Senior SQL Database Developer

Responsibilities:

• Studied existing and legacy financial software systems being used for different functions
• Maintained and extended databased for the existing Integrated Budget and Accounting System (iBAS) database for smooth operation of the application
• Extended iBAS system to interface with other systems - revenue management, and debt management systems.
• Studied different external database systems interfacing with the existing Accounting and Budgeting system - Central Bank, Other Banks involved with the payment and receipt activities and reconciliation.
• Studied existing systems in different organizations which were interfacing with the core accounting and budgeting systems and how data is imported into the core system.
• Remodeled database architecture for IFMIS accounting, budget preparation, and budget implementation modules
• Participated in development of new version of accounting and budget modules of IFMIS for the different offices under Confidential functioning for government accounting and budgeting activities.
• Worked in the core development team to develop modules of the accounting and budgeting system by developing the database.
• Developed SQL Server stored procedures, Triggers, Cursors, and Functions for budget preparation modules, and reporting modules
• Worked with various upstream and downstream systems and customers in interfacing various systems for Data extractions, ETL, Analytics and reporting needs.
• Involved in writing stored procedures for both Online and Batch requests handling business logic and Functionality of Various modules.
• Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers and Functions.
• Involved in source Data Analysis, Design and Creation of Data Mappings for Extraction of bulk data from heterogeneous sources
• Extracted data from various sources like SQL server 2005/2008/2008 R2/2012, Oracle, CSV, Excel and text file from various systems.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and load the
• Data from various Databases using SSIS.
• Designed Complex SSIS packages interfacing SQL with Oracle 10g.
• Scheduling and Maintaining SSIS Packages and batch jobs through SQL Server Agent.
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Designing Enterprise reports using SQL Server Reporting Services (SSRS 2008 R2/2012) and Excel pivot tables
• Built Drill Down, Drill through, linked and sub reports using SSRS 2008 R2/2012.

Environment: C#, ASP.NET, ASP.NET MVC 5, VISUAL STUDIO 2013, .NET FRAMEWORK 4.5, Entity Framework, SQL SERVER 2012, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), TSQL, Microsoft Visio, HTML, CSS, XML, Java Script, AJAX, jQuery, LINQ, and TFS

Confidential

SQL Database Developer

Responsibilities:

• Developed new features and maintained database systems (Shop Floor System, Accounting System, Kormee HRM System) being used in different business units for different functions
• Participated in Interacting with Team and Analysis, Design and Development of database using ER Diagram, normalization and relational database principles.
• Developed SQL Server Stored Procedures, Tuned SQL Queries using Indexes and Execution Plan)
• Developed User Defined Functions and created Views
• Created Triggers to maintain the Referential Integrity.
• Prepare detailed statistical reports in MS Excel to track progress of weekly, monthly and quarterly customers and sales growth.
• Reviewed existing business procedures and recommended and implemented changes.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilt Indexes and Tables as part of Performance Tuning of database
• Conducted business process study of the different department and plants and prepared the flowcharts for the SAP ERP System configuration.
• Conducted testing of the configured SAP system to confirm it complies with the business practices.
• Participated in configuration to successfully run the new SAP ERP after going live, by updating, troubleshooting, and enhancing through functional configuration.
• Configured and operated IBM System-i server for SAP ERP system
• Adapted business functions into the modules of SAP ERP system with functional configuration
• Developed customized reports using data from SAP ERP System

Environment: C#, ASP.NET 3.5, HTML, CSS, JavaScript, Microsoft Visio, Visual Studio 2008/2010, SAP ERP, IBM OS/400, DB2, SQL Server 2005, Windows Server 2008.

Confidential

.Net Developer

Responsibilities:

• Maintained and improved banking software with changing business requirements
• Developed provident fund system and loan management system with ASP .NET and SQL Server
• In collaboration with the International experts on Equation Banking System implementation, developed the implementation architecture of the system.
• Studied the Branch location and workloads and participated in the design for future structure for LAN/WAN installation and cable and wireless installation for data communication.
• Defined IT Security Policy and General IT Policy for the Bank.
• Converted distributed banking system into centralized banking system in collaboration with banking system consultants
• Configured branch systems, central consolidation database, and central server for the new banking system

Environment: ASP.NET, C#, VISUAL STUDIO.NET, Web Forms/Win Forms, AJAX, SQL SERVER 2005, T-SQL, Oracle 9i, Microsoft Visio, HTML, CSS, JavaScript, Crystal Report 11, IIS, Windows 2003