C# Azure SQL Server Resume

DEEPAK DORAISWAMY

CELL: 440-***-****

EMAIL: *************@*****.***

Irving, Texas

Summary of Career:

Having (18+) experience in IT development projects in Finance and Banking, Health Care, Transportation and Automobiles using multiple technologies like Microsoft.NET, Microsoft Azure and RDBMS.

Well rounded experience in Software Development process models like SCRUM Agile, Hybrid Model, Waterfall Model and Evolutionary Prototyping Model

Vast experience in Financial Projects areas like Global Market Currency Management Trading, Capital Markets, Front Office Trading, Fixed Income, Loan Leverage Market and Retail Banking

Experience in project management, Technical Leadership, Team Building, managing client expectations, project planning, effort estimation, monitoring and controlling, risk analysis and mitigation, resource allocation and managing customer relationship

Summary of Technical Experience:

Cloud Technologies: DevOps, Message Queue, Service Bus, Azure SQL, Storage, Azure File Share, Function App, Key Vault, Monitoring, Application Insights, Containers, Data Factory, Data Flow, Data Ingestion patterns, Data Lake,

Terraform, PowerShell, CosmosDB, MongoDB, Web apps, API gateway

Database/RDBMS: Oracle 11G, SQL Server 2022/2019, ORM, Sybase 12.5.0.1, SQL Developer, TOAD, ER Studio

Data Architect

Middleware: Restful Web API, MSMQ

Operating Systems/Development Tools/Configuration Management: Windows 11/10, UNIX, Linux, POSTMAN,

RestSharp, JIRA, Rational Team Concert, Visual Studio 2022/2019, UML, SSIS, SSRS, Git, Bitbucket, IBM ClearCase®,

Team Foundation Server, SVN, SQL Profiler and Query Analyzer

Programming Languages and Web Technologies: ASP.NET MVC, C#, HTML, Angular, Typescript, PowerShell, Razor,

CSS, Web API, Core, LINQ, Entity Framework, WCF, Bootstrap, C++, Java Script, Shell Programming, VB.Net and XML

Windows Application Development and Third Party Controls: WinForms, Dev Express controls, Telerik controls and

Infragistics Net-Advantage Suite

Third Party Application and Business Intelligence: Calypso 17, JAMS, Tidal Enterprise Scheduler and Power BI

Other Microsoft Tools: Visual C++, Visual Basic, Office 2016, Microsoft Teams, WebEx

As a Technical Lead/Project Lead/Senior Software Engineer:

Performed project management activities like planning, scheduling, reviews, escalation, and update project status to higher-ups and led a team of 15 members

Requirement management, scope management and change management

Participated in reviews, weekly meeting, status update to customer and senior management

Project Initiation comprising of planning, requirement analysis and onsite coordination

Participation during project audit, interacting with process team, SQA during development life cycle

Involved in defining product architecture, High-level and low-level design

Education:

2002 - Master’s in computer applications (MCA) from Madurai Kamaraj University

1996 - Bachelor in commerce (B’Com) from Bangalore University

1998 - Higher Diploma in Software Engineering (HDSE) from Aptech Computer Education

Training/Certification/Professional Achievements:

Completed Microsoft Azure Fundamentals and Azure Architect Technologies course

Successfully attended PMP preparation training program of 35 hours PDU’s

MCSD Microsoft transcript ID 1215330

During crucial time, took a leadership role to build support team for a financial client and showed drastic improvement in delivery. Received Star Employee Award for this achievement

Professional Experience:

Senior Software Engineer 01/2008 – Till Date

Symbol Software Services Inc. (Full Time)

Senior Consultant, Federal Home Loan Bank 05/2021 – 10/2024

Project: Calypso Migration

Responsibilities:

Worked extensively on Azure, DevOps and scrum methodology

Worked on Azure SQL, Azure Storage, Azure File Share, Function App, Key Vault, Application Insights, PowerShell

Used on .Net Core 3.1, .net framework 6.0/8.0

Calypso customization like Message, creating Scheduled Tasks, Chains, uploading CDUF data

Technologies: Microsoft Azure, DevOps, Azure functions, Service Bus, Azure Storage, Azure File Share, .NET Core 3.1, NET 8.0, C#, Web API, SQL Server 2022, Visual Studio 2022, SSIS, SSRS, Calypso, Power BI, Git, POSTMAN, BMC, Windows 10

Technical Lead, Revenue Solutions Inc., Wilmington, DE 07/2019 – 04/2021

Project: Integrated Revenue Administration System

Technologies: Microsoft Azure, NET 4.8, C#, Web API, RestSharp, .NET Core 3.1, SQL Server 2017, Visual Studio 2019, TFS, Git, JAMS, POSTMAN, Windows 10

Responsibilities:

Attended requirement meetings with DOR staff and JPMC for ACH implementation

Implemented Web API Microservices to provide and update tax payment details to GOVOLUTION

Implemented Web API Microservices to retrieve license details and to update payment details

Coordinated with Infrastructure team for Microservices deployment by configuring CI/CD pipelines

Deployed Web API on Azure App Service (PaaS) deployment slots and IIS Server using VM.

Followed AGILE practice (sprint 2 Weeks) and used Kanban

Involved in migration of on-premises AD users to Azure Active Directory

Mentoring team members on ACH payments/Reversal/DEBIT, Refund Direct Deposit/Check Write (NACHA format)

Assign interface task and explain technical aspect of implementing SSIS packages using standards

Define SSIS standards, created a template package for INBOUND and OUTBOUND interface

Perform team code review and mentoring team members on technical aspects of the application

Senior Consultant, Accenture, Austin, TX 11/2018 – 06/2019

Project: Accenture Public Health Platform

Technologies: NET 4.7.2, C#, ASP.NET, WCF, NUnit, SQL Server 2017, JIRA, POSTMAN, Visual Studio 2017, Git, Windows 10

Responsibilities:

Analyzed and fixed performance related issues on DB side

Involved in code review, technical document review, database tuning and mentor team members on technical aspects

Providing POC for session state management, TCP binding for improving performance of application

Guiding team members on technical aspects of the application

Technical Lead, Wipro Info-crossing, Jefferson City, MO 08/2017 – 10/2018

Project: Railroad Management System (RMS) Missouri Department of Transportation (MODOT)

Technologies: ASP.NET MVC, NET 4.6, C#, WEB API 2, ER Studio Data Architect, Visio 2013, Dev Express 15.2, Oracle 11G, SQL Developer, HTTP Master, Axure 8.1, Visual Studio 2015, TFS, JIRA, Win 7

Responsibilities:

Responsible for the planning, design and predesign information to business users and client managers

Attended requirement meetings with operations manager, Inspectors, Federal Railroad Administration and Rail Safety Specialist

Prepared design document for Crossing Inventory data transfer to Grade Crossing Inventory System of US DOT

Created POC using Asp.Net MVC, Dev Express control and Web API to show miniature functionalities in application

Train team member on Axure to create functional rich prototypes, animations, custom libraries and conditional flow

Published prototypes on Axure Share and generated User specification document

Scheduled internal meetings with team members to prepare the agenda for the client meetings and action items

Followed Agile-Waterfall hybrid method (sprint 2 Weeks) and attended daily standup team meeting

Providing technical solutions to the client managers and to team members

Provided technical and design help for creating database relational model

Created conceptual entity relational data model and composed of entity types and relationships using ER studio

Created Class diagrams, Use Case diagrams and Sequence diagrams in technical specification document

Prepared Analysis and Design document, Technical Specification Documents, and Application Standards document

Attended meetings with Travel way Management System (TMS) team to understand the map and LRS functionality

Senior Software Engineer, BB&T Corporation (Branch Banking and Trust), Wilson, NC 12/2016 – 07/2017

Project: Merge and integration database (MAID)

Technologies: WPF, NET 4.6, C#, Entity Framework 6.1.3, SQL Server 2014, SSRS, Visual Studio 2013, TFS, Win 7

Senior Software Engineer, Anthem, INC. Virginia Beach, VA 01/2016 – 12/2016

Project: External Claims

Technologies: NET 4.0, C#, ASP.NET, Oracle 11G Enterprise Edition, SQL Server 2014, SSIS, Visual Studio 2012, SVN, JIRA, TOAD, Tidal Enterprise Scheduler, Win 7

Senior Software Engineer, State Street Corporation, Boston, MA 10/2014 – 12/2015

Project: Currency Management System

Technologies: NET 4.0, C#, WCF, WinForms, Oracle 11G Enterprise Edition, Visual Studio 2013, IBM ClearCase®, TFS, Rational Team Concert (RTC), JIRA, Use Cases, SQL Developer 4.1, Win 7

Responsibilities:

Responsible for the implementing portfolio management, trading applications, researching, and developing new product innovations, and offering customized research analyses to clients using multithreading and design patterns

Migrated C# .Net 2.0 Currency Management Platform application that uses Accessdb into a C# .NET 4.0 application using Oracle 11G Enterprise edition

Created tools to allow Portfolio Managers to track down issues quickly and reliably with their trading applications

Created controls for better tracking and auditing of every transaction

Implemented functionalities like Buyback, Multi-Currency trades, Profit and Loss on Roll Close trades

Designed and implemented functionality for Automation team and search screen for business users

Used IBM ClearCase® version control and IBM Rational Team Concert for AGILE practice application development.

Prepared functional requirement document by interacting with product manager and business user

Schedule formal meetings involving product manager and QA for module reviews

Configured and implemented Click Once deployment

Application Architect, American Express, NYC, NY 06/2013 – 9/2014

Project: Credit Bureau

Technologies: C# NET 4.0, WPF, WCF, ASP.NET MVC 3, HTML5, Visual Studio 2012, SVN, UML, SQLServer2012, SSIS, Win 7

Responsibilities:

Designed database for BlueLight application using normalization rules

Designed application architecture using MVC, Decorator, Factory and Singleton design patterns

Involved in planning, resource utilization, scheduling, and train team members on BlueLight tool

Train team members on ERMG support application to process and move data to production database

Coordinated with team members for preparing test plan, test cases and technical information with peers

Team Lead, 1199 SEIU Benefit and Pension Funds, NYC, NY 10/2012 – 05/2013

Project: JOBS

Technologies: .NET 4.0, ASP.NET MVC 3, HTML, C#, Razor, JavaScript, AngularJS, Bootstrap, WCF, Visual Studio 2012, ClientTrack 2011, SSRS, TFS, SQL Server 2012, MS Visio 2007, Win 7.

Responsibilities:

Designed user interface for ClientTrack application and used JavaScript

Responsible to analyze application for performance tuning improvements

Prepared functional requirements documents by interacting with business users and business analyst

Prepare data mapping documents for data migration and design tables by using existing core ClientTrack tables

Technical Lead, Snap-On Business Solution (SBS), Richfield, OH 05/2011 – 09/2012

Project: Case New Holland (CNH)

Technologies: .NET 3.5, C#, WinForms, Visual Studio 2010, TFS, JIRA, MS Visio, Use Cases, Entity Framework, SQL Server 2008 R2, Win 7

Responsibilities:

Prepared functional requirement document through interacting with SME’s, and managers

Prepared Data Analysis, Data mapping, Functional summary, and Specification documents

Applied enhancements with Strategy, Factory, Decorator design patterns and WATERFALL practice development

Schedule formal meetings involving SME’s and other dependant team leads for design reviews

Responsible for offshore code delivery, combined acceptance testing and analyze application performance

Providing technical guidance for migrating data from legacy system

Senior Software Engineer, International Gaming Technology (IGT), Las Vegas, NV 09/2010 – 04/2011

Project: Softward

Technologies: .NET 3.5, ASP.NET MVC 2, WCF, HTML, JavaScript, SSRS, TFS, IIS, AJAX, Visual Studio 2010, SQL Server 2008

Responsibilities:

Designed application 3-layer architecture and used Singleton, Decorator design pattern, C# and OOPS concepts

Designed web user interface HTML and created Style Sheets

Reconciliation of promotion items was implemented using services

Designed Database for Softward application, SSRS reports and created WCF services to provide promotion details

Team Lead, NYC Department of Health and Mental Hygiene, City of New York, NY 03/2010 – 08/2010

Project: Bureau of Environmental Emergency Preparedness and Response (BEEPER)

Technologies: .NET 3.5, ASP.NET, C#, JQuery, WinForms, MVP, Visual Studio 2008, TFS, SQLCe, SQL Server 2008.

Responsibilities:

Designed in-office database, handheld device database and application architecture

Designed architecture for transferring data from handheld database to in-office database and EDEN database

Designed web user interface and hand-held device applications using ASP.NET, Winforms and C#

Followed WATERFALL method

Senior Consultant, Human Resources Administration, City of New York, Brooklyn, NY 09/2008 – 02/2010

Project: Long Term Assignment (LTA)

Technologies: .NET 3.5, ASP.NET, C#, MVP, JavaScript, Visual Studio 2005, XML, TFS, Telerik, SQL Server 2005, Win XP

Senior Software Engineer, Citibank, Hauppauge, NY 03/2008 – 08/2008

Project: Break Fix

Technologies: .NET 3.0, ASP.NET, C#, HTML, WinForms, MVP, Visual Studio 2008, SQL Server 2005, SSRS, TFS, Win XP

Team Lead, Calyon Financials, NYC, NY 09/2007 - 02/2008

Project: Loan Leverage Market

Technologies: .NET 3.0, C#, WinForms, ASP.NET, Visual Studio 2005, XML, MS Visio, TFS, SQL Server 2005, MSMQ, Win XP

Team Lead, ROO Media Corporation, NYC, NY 02/2007 - 08/2007

Project: DRM, VX Commerce, UGC

Technologies: .NET 2.0, C#, ASP.NET, HTML, Visual Studio 2005, Web Service, TFS, SQL Server 2005, Infragistics, Win XP

Project Lead, Quinnox Consultancy Services, Mumbai, INDIA 05/2004 - 12/2006

Technologies: .NET 1.1, Classic ASP 3.0, ASP.NET, C#, VC++ 6.0, COM, WinForms, Use Cases, Visual Studio 2003, SQL Server 7.0/2000, Sybase, Crystal Reports 8.0, Visual SourceSafe, CVS, UNIX, Shell Script and Win XP.

Software Design Architect, Non-Verba Information Solutions, Chennai, India 01/2004 – 05/2004

Technologies: Classic ASP 3.0, Visual Basic 6.0, Crystal Reports 8.5, MS Viso, Use Cases, VBA, SQL Server and Win 2000

Application Engineer consultant at EIS, Bangalore, India - 08/2003 - 12/2003 Software Engineering Self-Assessment Method (SESAM) for client Robert Bosch India Private Limited

Technologies: Visual Basic 6.0, Crystal Reports 8.5, MS Access 2000 and Win 2000

Contact this candidate