SUMMARY:

• Dynamic and techno savvy professional with 9+ years of cross - functional experience developing Enterprise class, modern, Software projects with hands-on experience in development, deployment, implementation and maintenance of application software.
• Proficiency in Microsoft® Technology Stack.
• Technical Expertise in Business Intelligence and Web Development.
• Extensive experience in developing web based solutions using Microsoft® Web Platform - .NET Framework, Visual Studio®, ASP.NET, IIS, HTML, CSS, JavaScript,AngularJS, SQL Server®, LINQ, ADO.NET,Entity Framework, AJAX and Web Services.
• Rapid web application development using ASP.NET MVC and HTML5.
• Enterprise integration using SharePoint.
• Expertise in designing rich, responsive, user friendly interfaces for the web using HTML, CSS, JavaScript, AngularJS,AJAX, Bootstrap, jQuery and Telerik.
• Proficient in writing complex queries and optimizing queriesinSQL Server®., Oracle, Sybase databases.
• Excellent database skills in creating SQL objects like Tables, Views, Indexes, Triggers, user defined data types, Stored Procedures, CLR Procedures and functions.
• Experience working with data models, data dictionaries, logical & physical Data modeling, Normalization and De-Normalization techniques for OLTP and OLAP systems.
• Excellent experience in Data warehousing and Data mining with querying and mining large datasets to discover patterns and to examine financial data.
• Experience in Progressive Data modeling to serve dynamic business needs
• Extensive experience in the MSBI stack: Analysis Services (SSAS), Integration Services (SSIS) and Reporting Services (SSRS).
• Experience in Test Management&Test Automation - Quality Center.
• Experience in Programming Quality Center Open Test Architecture (OTA) API.
• Web debugging using Fiddler™.
• Experience in Oil and Gas domain: dealing operations with Upstream and Midstream sector.
• Experience in Banking, Financial Services and Capital Markets domain.
• Source control managementexperience in using Subversion (SVN), VisualSourceSafe (VSS) and Team Foundation Server (TFS).
• Experience in classic Waterfall Methodology andmodern Agile methodology of software development.
• Good Team player and also ability to work as individual contributor.

TECHNICAL SKILL:

Framework: .NET 4.0/3.5/3.0/2.0, ADO.NET, ASP.NET 4.5/4.0/3.5/3.0, ASP.NET MVC, AngularJS, Bottle

ProgrammingLanguage: C, C++,C#4.0 / 3.0 / 2.0, VB 10.0/8.0/6.0 Java, Python

ScriptingLanguage: Shell scripting,Perl,PHP,JavaScript, VB Script

Markup Language: HTML, HTML5, XML, XHTML

Style sheet Language: CSS3, XSL

IDE: Visual Studio 2012/2010/2008/2005, Eclipse 3.5, IntelliJ

DBMS: SQLServer 2005/2008/2008 R2/2012, Oracle 9i/10g,Sybase ASE 15.0, MongoDB 3.0

BusinessIntelligence: SSRS,SSIS, SSAS, MicroStrategy, Power BI

Application/WebServer: IBM WebSphere 7.0, Internet Information Server 6.0/7.0/7.5/8.0, Apache 2.2

Content Management System: SharePoint, MediaWiki

Protocol: HTTP, SMTP, SOAP, FTP, POP, IMAP

Tools: HP Quality Center, MicrosoftWebMatrix, Microsoft Solver Foundation, Telerik, FiddlerARIES™, IHS FieldDIRECT, BOLO, Control-M, NuGet, Bower, Gulp

Testing Tool: Selenium, Test Studio, NUnit

Source/Version Control: SVN 1.6, TFS 2010/2012, VSS 2005

OperatingSystems: MicrosoftWindows 10/8/7, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh, NC

Technical Architect / Senior .NET Developer

Responsibilities:

• Requirements gathering, Design, Implementation and Testing.
• Design and Development of involved Database: Tables, Views, Functions, Stored Procedures, Triggers, Custom User-defined data types and Table Types.
• Implementation of SSIS packages consuming data shared by external agencies over Web Services.
• Enhanced security of sensitive data (SSN, TIN) with SQL Server symmetric cryptography system.
• Implementation of Data Access layer using ADO.NET
• Responsive Web design using Bootstrap.
• Implementation of custom workflows.
• Implementation of SMTP based Custom Mail utility.
• Implementation of Custom logger module.
• Implementation of traditional business reports using SSRS.
• Integration of server side ReportViewer control with MVC Razor views.
• Power BI analytics solutions.
• Code review, Code Walkthrough.
• Release Management.

TechnologyASP.NET, C #, VB.NET, Micro s o f tSQLSer v er2014, ADO.NET, SSI S,SS R S, AJAX, jQuery, Telerik Controls, Web Services, Bootstrap, TFS, Power BI

Technical Lead/ Senior .NET Developer

Responsibilities:

• Involved right from inception to delivery and support.
• Developed ASP.NET MVC components using C#.
• Developed Client-side JavaScript library for standard control validations using regular expressions and DOM methods.
• Implemented Responsive web design using Bootstrap.
• Ensured seamless user experience across different devices using Bootstrap CSS media queries.
• Developed utility libraries for database access using ADO.NET, file storage and logging using data stream, and notifications using SMTP clients.
• Implemented AJAX based web controls in web forms using jQuery libraries for enhanced user interfacing.
• Developed SQL Queries and Procedures for storage & retrieval of data using ADO.NET and LINQ to SQL.
• Custom Financial Analytics - calculating Rates of Return, Planning Loan & Lease schedules.
• Developed feature rich, expressive user interface using AngularJS.
• Developed and maintained SQL Server Databases. Built, maintained, and scheduled DTS and SSIS packages and stored procedures for migrating and updating data.
• Set up and maintain database environments to support production, QA and development activities.
• Developed reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures. Configured and maintained Report Manager and Report Server for SSRS.
• Code review, Walk through and deployment across different environments.
• Change control management.
• Provided production support.
• Ensured Cross browser compatibility.

TechnologyASP.NET, C #, VB.NET, Micro s o f tSQLSer v er2012, Oracle 12g, ADO.NET, SSAS, SSI S,SS R S, AJAX, jQuery, Telerik Controls, Web Services, AngularJS, Bootstrap, TFS

Senior .NET Developer

Responsibilities:

• Created ASP.NETMVCcomponents containing code for business and data access logic using C#.NET.
• Implemented the data access layer using ADO.NET Entity Framework.
• Developed error handling, validation and e-mail components.
• Used Master pages to create a consistent layout for all the pages in the application.
• Applied styles to web page using CSS to ensure compliance standards.
• Responsible for the designing the advance SQL queries, procedure, cursor, triggers, scripts.
• Created, scheduled and managed SQL Server jobs to automate various data load.
• SQL Server Service Broker Implementation
• Implemented SMTP based Database Alerts and job status notifications.
• Evaluated several Third party scheduler controls.
• Design and Implementation of view-dependent controllers in client-side using AngularJS.
• Designed rich and responsive UI using AngularJS and CSS3 transformation effects.
• Built a custom scheduler control by extending the calendar control.
• Created several user controls to enable code reusability.
• Implementation of Microsoft solver Foundation to calculate decline curve factors.
• Graphical representation of rig schedule and assignment using Telerik controls.
• Telerik implementation for seamless UX across Devices and Browsers.

TechnologyASP.NET, C #, VB.NET, Micro s o f tSQLSer v er2008 R2, ADO.NET, Entity Framework, SSR S,SS I S, Microsoft Solver Foundation, AJAX, jQuery, Telerik Controls, Web Services, AngularJS, SVN

Senior .NET Developer

Responsibilities:

• Developed multiple excel forms using VBA to collect budget & actual data.
• Designed rich, intuitive input forms in excel to upload data into the server over Web services.
• Developed executive dashboard using ASP.NET
• Implemented ASP.NET MVC pattern mechanism to display consolidated AFE details.
• Implementation of custom web services to render expense data across other business units.
• Used LINQ to retrieve information from the XML data files.
• Transformed XML files into specified business format using XSLT.
• Implementation of enabling workbook in an Excel Web Access Web Part.
• Used Serialization in C#.NET to manipulate binary data rendered over web service.
• Developed error handling, validation and e-mail components.
• Implemented SMTP based mail module to notify involved stake holders during the course of workflow.
• SQL Server Service Broker Implementation.
• Helped to migrate legacy spreadsheets into custom eAFE system.

TechnologyASP.NET, C #, VB.NET, Micro s o f tSQLSer v er2008 R2, ADO.NET, VBA, EXCEL, SSR S,SS I S, AJAX, Web Services, VSS

.NET Developer

Responsibilities:

• Design of fact tables and dimension tables to match the Star Schema of the data mart.
• Performed manual & automated schema comparison & schema synchronization.
• Validating the migration against the existing physical data model.
• Migration of schema, data & Adhoc sql statements.
• Design and implementation of transactional & snapshot fact tables.
• Handled Sybase System function references.
• Manual handling of known migration issues; Data Types, Expressions & SQL commands etc.,.
• Test Management using Quality Center.
• Performed pre-migration and post-migration testing.
• Part of formal design review prior to production migration.
• Automated the direct & incremental loading.
• Design and development of web interface to manage the migration process flow.

TechnologyASP.NET, C#, ADO.NET, Sybase ASE, Microsoft SQL Server 2005, SQL Server Migration Assistant, HP Quality Center, VSS

.NET Developer

Responsibilities:

• Implementation ofweb services to render MQ message status& Control-M job status.
• Design and Development of centralized Dashboard using ASP.NET, C#.
• Workload Automation using Control-M job scheduler.
• Cross platform messaging using IBM WebSphere MQ.
• Developed utility libraries for database access using ADO.NET.
• Developed SQL Queries and Procedures for retrieval of data using ADO.NET.
• Implemented wrappers to consume external web services.
• Design and implementation of custom user controls to display message and job statuses.
• Custom web services to render and consume enterprise mailing service.
• Design and implementation of Integrated logging module to register event logs in SQL server database.
• Automated subscription mechanism for event notifications.
• Implementation of Web interface to manage users, user roles and subscriptions.
• Implementation of Web Application Security module.

TechnologyASP.NET, C#, VB, Microsoft SQL Server, ADO.NET, IBM WebSphere MQ, Control-M (job scheduler), VSS

ULT Test Automation

Responsibilities:

• Detailed study of Mercury Quality Center architecture (3-tier) and the Open Test Architecture (OTA) object model.
• Extending Mercury Quality Center feature with Open Test Architecture (OTA) API using C#.
• Windows API programming to perform GUI automation using VC++.
• Implementation of wrapper classes to access, identify and manipulate UI elements of other windows applications.
• Design and implementation of customizable simulator control.
• Implementation of Test Plan and Test Case management module.
• Custom Test Reporting.
• Implemented wrappers to consume external web services.
• Implementation of configurable notification services module in C#.

Technology.NET, C#, VC++, Jscript, Mercury Quality Center, Open Test Architecture API