SUMMARY:

• 12+ years of full - stack software development life cycle (SDLC) experience in Fortune 500 environments.
• Expert in Microsoft technologies for business layer and back-end implementation (.NET, SQL Server, SharePoint).
• Extensive experience in using Design Patterns with an emphasis on high-quality software development.
• Broad understanding of a variety of technology layers and concepts including Big Data, Analytics, etc.
• Proficient in client facing / consulting roles and interacting with business managers/users as well as technical team including analysts, QA and engineers.

TECHNICAL SKILLS:

Programming: Web Programming (Expert): using ASP.NET, Ajax, MVC, jQuery, JavaScript, CSS, Firefox, firebug, IE + IE Dev tools, and Chrome. Windows Communication Foundation (Expert): including advanced features like Parameter Inspectors, Message Formatters, Custom Serialization of WCF Messages. Windows Presentation Foundation, WPF (Intermediate): Have done XAML - based development for various client platforms, including the use of ORM frameworks with MVVM pattern. WCF Security (Intermediate): Knowledge of SAML-based, Message, and Transport Security. Telerik RAD controls for ASP.NET Ajax as well as MVC. (Expert).

Design: Design Patterns: Factory (Expert), Command (Expert), Mediator (Expert), MVVM (Expert), MVC (Expert), Repository (Expert), Dependency Injection (Intermediate), Inversion of Control (Intermediate).Software Architecture/Design (Expert), Business Layer Design using design patterns (Intermediate).

Databases: SQL Server Database Design and Development (Expert): Stored Procedures, Views, Tables, Triggers, Indexes, Query Optimizations, etc. Oracle 11G, design and development. SQL Server Integration Services, SSIS (Expert): have used almost all advanced techniques, including production - critical SSIS package optimizations. Performance Analysis/Tuning (Intermediate). Query/Execution Plan Analysis & Optimization (Intermediate). Data Modeling (Expert).

PROFESSIONAL EXPERIENCE:

Technical Lead

Confidential

Responsibilities:

• Worked on challenging problems involving claim filing, benefits disbursement and tracking, and revenue collection at DUA as part of their Unemployment Assistance program.
• Designed and developed Military Quarterly Billing Report modules involving a Batch Job (a service run through an enterprise scheduler - Argent) and a set of User Interface screens, developed in ASP.NET.
• Designed and Implemented new database tables (in Toad for Oracle 11g) to accommodate requirements for Military Quarterly Billing Report.
• Modified an existing Batch Job - all batch code was written in C# - responsible for generating interface files (.txt) used to facilitate the exchange of unemployment information between state agencies. Codebase for this batch was modified in the wake of new business rules and changed file format for ICON 710.
• Fixed several defects in UI-Online enterprise application which is in Maintenance and Support mode.

.NET Systems Architect

Confidential

Responsibilities:

• Short-term project to streamline reporting and Electronic Data Interchange (EDI) process at Mizuho’s NJ branch.
• Designed end-to-end architecture for Report Distribution Server (RDS). RDS was designed as a 3-Tier system for retrieving, storing, and distributing reports. It included Database server, App server, and Web server.
• A Windows Service running on App server would collect reports from multiple servers in Mizuho’s corporate datacenter over FTP. The reports would then be stored on the App Server.
• The Windows Service would also populate a database on DB server with relevant statistical and historical information about Reports.
• The Windows Service produced several output files for sequencing and routing of Reports to Mizuho’s geographically dispersed offices / datacenters as well as Mizuho’s clients.
• RDS also had a web-based, front-end application (deployed on Web Server), which provided managers with insights into end-to-end Report Distribution operations. This Web Application communicated with database server only.
• Employed Repository patterns with Entity Framework, both in Windows Service and Web Application.
• Extensive use of other Application Design Patterns (Factory, Mediator, etc.) to achieve effective polymorphism in the business layer of the Windows Service.
• Used ASP.NET MVC for Web Application with Entity Framework, and Data Repositories.
• Initial deliverables in the project plan were Functional Specification document and Technical Design document only, but went above-and-beyond to produce functional, demonstrable prototypes, with working code in Visual Studio. All this was achieved in less than three months to meet aggressive time and budget constraints.

.NET Systems Architect

Confidential

Responsibilities:

• Designed and implemented a complete SharePoint Branding solution for the portal for FHLB Boston Finance partners and clients. This solution when deployed as a WSP, brands the SharePoint site with Custom Master Page, CSS, JavaScript, and images. Also enables custom quick launch navigation bar.
• Designed and developed a complex SharePoint Timer Job. The job referred to a class library solution to do its work. The class library project was implemented using Transaction Script Design Pattern, and performed complex operations involving numerous business rules.
• Streamlined entire development process by implementing best practices on Subversion code versioning, branching, merging, and source control practices.
• Enhanced SharePoint workflows, and led the DEV, QA, UAT, and Production release cycles of MPF SharePoint Application.
• Used MVP pattern for the design of Phase 2 of MPF SharePoint Application.
• Produced technical design document for the Swap Execution Facility Project, MBS project and FinCEN project. Used Visio and Visual Studio for modeling business domains and architectural designs.
• Designed and documented technical specifications for a custom project that involved Summit, a financials’ legacy application, and various disparate systems that allowed integration with external vendors such as Bloomberg and TPG, in a service-oriented fashion.
• Used Factory, Singleton, and Repository patterns for design and implementation of the above-mentioned application.
• Used Messaging patterns and other Enterprise Integration patterns to achieve integration amongst different applications.

Environment: SharePoint Server 2010, SQL Server 2012, Entity Framework, LINQ-to-SharePoint, LINQ-To-Entities, WCF, Windows Services, Console Applications, MS Tests, dotNet multi-threading.

Team Lead/Architect

Confidential

Responsibilities:

• Designed and implemented a SQL database as well as an SSIS package for Patient Emergency Visits.
• Designed and implemented database and an SSIS package for gathering and consolidating data from various health organizations across New York State.
• Designed and implemented a thread-safe solution for parsing, executing and storing results from SQL query files submitted by Department of Health. The solution, implemented as a Windows Service, was relatively bug-free, highly efficient and responsive and was delivered to meet an aggressive deadline. Scalable, componentized design and verbose logging using log4net were the highlights of the system. Extensively used .NET Regular Expressions for parsing SQL query files.
• Designed and implemented various WCF services, including hand-written XML, XSD, WSDL documents using XmlSpy and another XML engine (Oxygen).
• Interfaced with third-party java-based services using custom serialization techniques and advanced customizations of WCF 4.0 stack.

Environment: SQL Server Integration Services (SSIS) and SQL Server 2012, Entity Framework, LINQ-To-Entities, WCFdotNET Regular Expressions library, Windows Services, Console Applications, MS Tests, dotNet multi-threading.

Team Lead/Architect

Confidential

Responsibilities:

• Designed the entire .NET technology stack (ranging from SQL Server 2012 database on one end, and ASP.NET Web Forms on the other) for the portal.
• Revamped the existing portal by eliminating Page Load events and full page post-backs, and instead introduced partial page posts from client to server, in accordance with the modern best practices for AJAX and screen responsiveness. Most of my work involved re-design and optimization of the existing application, as well as streamlining the entire development process for the new releases of the FA Portal.
• Used Telerik controls with ASP.NET Web Forms, for asynchronous calls between browser-based clients and the server. Mainly utilized Telerik’s client-side JavaScript library to implement AJAXified web pages and extremely responsive screens.
• Optimized the HTTP payloads of the web pages using Fiddler and other advanced UI optimization techniques.
• Modified the screen design using CSS, HTML in Firefox + Firebug, and IE + IE Dev tools, with ASP.NET Ajax Library.
• Designed, implemented and optimized stored procedures in SQL Server 2008 R2 database. Improved the performance of some stored procedures by more than 66%.
• Designed and implemented the business services layer (on App Servers). The Service layer exposed business logic through WCF services. Behind the WCF layer, the business logic was implemented through a Repository pattern that integrated with Data Model.
• Utilized LINQ to Entities in the Business Service Layer - used all of the advanced techniques around LINQ, including Dynamic LINQ with projections. Also used .NET Regular Expression Library.
• Implemented the Entity Framework Data Model using T4 code templates, with self-tracking POCO entities.
• Performed unit testing of the application and basic QA.

Environment: SQL Server Integration Services (SSIS), SQL Server 2008 R2, Entity Framework, Telerik Rad Controls for ASP.NET, Dynamic LINQ-To-Entities, WCF, JavaScript, jQuery, ASP.NET Ajax Library, CSS, HTML.

Application Design & Development

Confidential

Responsibilities:

• Designed SSIS packages which read data from multiple MS Access database files, and transported data into a SQL Server 2008 R2 database.
• Single-handedly designed entire the database to support more than one application.
• Designed and implemented the WPF application using Blend and SketchFlow along with Visual Studio 2012.
• Used the best practice ORM techniques and tools (used a third party ORM tool), and implemented a scalable MVVM pattern, thus abiding by the modern best practices of a scalable XAML-based design.
• Communicated with the client and the project manager to resolve issues, and gather requirements.
• Performed unit testing of the application and basic QA

Environment: SQL Server Integration Services (SSIS), SQL Server 2008 R2, MS Access 2010, MS Excel, Blend + SketchFlow for VS 2012, Visual Studio 2012.

Lead Database Engineer/Architect

Confidential

Responsibilities:

• Designed and developed around 10 SSIS packages that achieved seamless integration among three databases.
• Served as a sole point of contact for all database-related queries from client, as well as internal development team.
• Helped the lead architect in designing the database solution for ESAP.
• Developed the ESAP database solution using T-SQL - Stored Procedures, Tables, etc.
• Participated in design of a WCF service (host and client) that interacted with New York Police Department service to achieve integration with ESAP.
• Helped in design of an Entity Framework 4.1 Data Access Layer to communicate with the database back end.
• Served as the sole escalation point for all database related queries during Dev, UAT, and Production phases.
• Received commendation and recognition from the client on robust and flexible design of SSIS packages as well as timely implementation to meet very aggressive timelines.

Environment: SQL Server Integration Services (SSIS), WCF, T-SQL, SQL Server 2008 R2, XSD Serialization/Deserialization.

Senior Software Engineer

Confidential

Responsibilities:

• Designing and developing a software application for Acura Motors.
• Designed and Developed two three pages for production. The pages involved jQuery AJAX, with heavy emphasis on client-side JavaScript.

Environment: MVC 3, ASP.NET 4.0, HTML, CSS, JavaScript, jQuery, MS Tests

Senior Software Engineer

Confidential

Responsibilities:

• Designing and developing a cloud-based software application for identity access management.
• Wrote test cases and an MVC 3 application to be used as connector configuration module by B2B end users.

Environment: MVC 3, ASP.NET 4.0, MS Test, n-Unit, jQuery, Javascript, Factory Design Pattern for the middle tier.

Solutions Architect

Confidential

Responsibilities:

• Successfully managed client expectations in the design and implementation of the various software components.
• Used ASP.NET 4.0 and Visual Studio 2010 for the web application front-office software
• Wrote Stored Procedures in SQL Server 2008 R2.
• Developed an internal ASP.NET 4.0 Web Form based application used by managers for Employee Status Updates.
• Prepared and got customer sign-off on all technical documents: Functional Specification (MS WORD and VISIO), Data Dictionary (Excel Spreadsheet), Interface Control (MS Word) documents.
• Handled customer interactions and resolved production issues.

Environment: C#, Entity Framework 4.0, jQuery, and XML.

Application Consultant (Part-time)

Confidential

Responsibilities:

• Used ASP.NET 3.5 and Visual Studio 2008 for the application
• Worked on Entity Framework 1.0 in ‘Model’ part of the ASP.NET MVC 1.0 application
• Used AJAX enabled Telerik RAD controls for the front end.
• Merged the (SQL Server) databases of AccessPoint and En Pointe - the two B2B vendors that had separate businesses prior to the project.

Environment: C#, MVC.NET, Entity Framework 1.0, jQuery, XML, Telerik RAD Controls and web services

Lead Software Engineer

Confidential

Responsibilities:

• Worked on the Electronic Data Interchange modules of the CureMD application.
• Led a team of 6 software engineers to convert parts of the CureMD application from ASP 3.0 and VB 6 to .NET 2.0.
• Had the responsibility of Architecture, Design and Implementation Management of the parsers (written in .NET 2.0) that parsed data from the electronic files (EDI and REC format) received from MedAvant Claims Clearinghouse (now known as Capario). The parsers were deployed as part of a Windows Service that was installed at the download server which received the electronic files from MedAvant.
• The modular and scalable parsers used Factory and Singleton design patterns and employed .NET Regular Expression class libraries to undertake pattern matching. The regular expression patterns were stored in a separate library in XML format. The parsed data was then stored in an MS SQL Server for use by the main CureMD application.
• CureMD application supports 837 Healthcare ANSI 4010 A1 standard.
• Also worked on VideoAdGames, an Advertising-cum-Gaming, multimedia application.
• Was responsible for Requirement Analysis, Design, and Implementation of the project.
• Development Platform: ASP.NET 2.0 and Microsoft SQL Server 2005.
• Was the sole point of contact for the US based client during this project, and was primarily responsible for Application Design and Implementation Management; Used VBA and VB Scripting in Classis ASP.

Environment: .NET 2.0, MS SQL Server 2005, ASP 3.0, ASP.NET 2.0.

Software Engineer

Confidential

Responsibilities:

• Participated in the Requirement Analysis, Design and Implementation phases of the project.
• Docwerx - document management system, is a software suite that allows organizations to manage, track and move documents of any kind across the wire and thus streamline inter-departmental communication.
• Was part of a team of experts from Trisoft, led by the CTO, who worked a host of IT consultants and shared expertise and best practices in the realm of Information and Communication Technology (ICT)
• Worked as an Application Analyst and Developer in implementing yieldWerx.
• Performed Requirement Analysis and Design of the application.
• Undertook SQL Design, development and tuning.
• Performed Coding and Unit testing - Individual modules

Software Engineer

Confidential

Responsibilities:

• Design and Development of web applications.
• Acted as hands-on Lead Software Engineer for the web applications developed.
• Led a team of three developers in building a scalable and robust web application for ICI Polyester Fibres
• The applications allowed the top management at the Factory to monitor their plants for efficiency and productivity.
• The applications logged real time data from Programmable Control Circuits (PLCs) installed at production units into a central database and allowed users to view reports and perform analyses over data.
• Reports could be accessed remotely over the Internet using portable devices such as palm tops and hand held PCs.

Environment: ASP.NET and Microsoft SQL Server