SUMMARY

• 9+ experience in full SDLC including requirements gathering, business analysis, system/software architecture, database design, coding, testing, and creation of functional documentation.
• Extensive experience in developing web - based applications using Microsoft.NET technologies including ASP.NET 3.5/4.0/4.5, ASP.NET MVC, ASP.NET CORE, C#, ADO.NET, Localization, Server Controls, WCF, AJAX and Web Services using N-tier architecture.
• Experience in ADO.NET components such as Data Grids, Datasets and Data reader.
• Written complex SQL Queries, Stored Procedures, Triggers and Views. Good exposure in query optimization.
• Proficient in JavaScript, jQuery, knockout JS, Angular JS / 2.0, Typescript along with HTML, DHTML, HTML 5.
• Have implemented core level API, libraries, Custom Web Authentication/SSO/ User Tacking Module in C#/ASP.NET using OOP concept.
• Hands on experience in LINQ, Extension Methods, Delegate, Lambda Expressions, Generics, Reflection, XML, XPATH, XML to LINQ and SQL to LINQ using C#.
• Have worked with SSRS, SSIS including SQL Server replication.
• Worked on SharePoint 2007, 2010 and SharePoint Client Object Model in 2010.
• Familiar with third party web controls like Telerik RAD controls.
• Used OOAD, OOP and Design Patterns concepts in an Agile environment, using SCRUM methodology.
• Good noledge of Data warehouse and MPP database concepts with hands-on experience in Amazon Redshift, Actian Matrix and Vector databases.
• Knowledge of AWS S3 and AWS Lambda Functions.
• Used AWS S3 API in .NET as well in Python using Boto module.

TECHNICAL SKILL SET

OS: MS Windows Server 2008/2012 RC, MS Windows 7/8/10, MAC OS 10.

Languages: C#, VB.NET, Python PL/SQL.

IDEs: Visual Studio 2008/2010/2013/2015, Visual Studio Code.

Web Development: ASP.NET, AJAX, JavaScript, jQuery, HTML, DHTML, HTML 5, jQuery, Knockout JS, Angular JS, Typescript, CSS, DNN 4.7.

Technology: .Net Framework 4.0/4.5, ASP.NET / MVC, ASP.NET Core, Web Service, WCF, Windows Service, SharePoint 2007/2010.

Databases: MS SQL Server 2005/2008/2012, Amazon Redshift, Actian Matrix/Vector, Teradata.

Web Server: IIS 6.0/7.0/7.5

Version Control: Visual SourceSafe, TFS, VSTS, Git.

Software Tools: Install Shield 2010, Empower, Attunity Replication

AWS Development: S3, Lambda functions, Redshift

PROFESSIONAL EXPERIENCE

Confidential, PLAYA VISTA, CA

Sr. Developer

Responsibility:

• Involved in gathering requirements and designed web application and tasked based window service from scratch.
• Responsible for developed data access layer, views and controllers in web application. Built UI on bootstrap CSS.
• Developed core libraries using factory and abstract factory pattern in C#.
• Involved in end to end pipeline implementation from different data sources to SFTP/S3.
• Implemented REST API/Service call for selected extract, custom transformation and uploaded to SFTP or S3 using C#/Python.
• Implemented python code for YouTube REST API and upload data to S3. Boto python package is used to upload data to S3.
• Implemented AWS S3 functionality code using C# as well in Python.
• Involved in writing custom SQL queries, Store Proc and optimizing existing SQL.
• Designed various reports in SSRS which were sent as attachment in email to selected users.
• Worked on SSIS package to interact with OData.
• Responsible for writing ODBC layer for Redshift, TFS branches, deployments, Release notes and design documents.

Confidential

Sr. Developer

Responsibility:

• Involved in gathering different queries from different existing system including notable long running queries.
• Run all 36 queries in Matrix, Vector, TeraData, AWS Redshift, Snowflake, MemSQL and Microsoft Azure.
• Documented all execution and response time in excel to compare along with multiple SQL compliance from all Data Warehouse.
• Involved in query optimization in Redshift and MemSQL to achieve desired results.

Confidential, AGOURA HILLS, CA

Lead Developer

Responsibility:

• Responsible for end to end ASP.NET page development and design how web page and WCF service interact with. ASP.NET pages compliance with Empower framework.
• Responsible for creating and designing WCF service which used request and response payload to transfer data from WCF.
• Involved in R&D and understanding of empower existing API, empower grid, controls like Loan Data Object, Query Object by creating sample POC.
• Display data using Empower grid control using generic custom pagination.
• Design and Code XML based Empower Mapping tree to export data.
• Write complex C# code and routines, ensure end to end code quality.
• Used jQuery, knockout JS and EMPOWER client API to achieve client-side scripting. Also, responsible to implement UI to client to server architect.
• Implemented AJAX call to create UI more responsive using page methods and jQuery and knockout js to display data as per demand.
• Worked with offshore team to speed up the development. Help them with design and implement complex flow.
• Coded complex Store Procs, queries, Views and functions as per business specification.
• Worked extensively on Microsoft reporting (SSRS) to create many complex reports.
• Developed common utility, API and extension methods to speed up the development for other developers.
• Review the code from other developer’s compliance with coding standards.
• Responsible for writing Release notes and managing deployments.

Confidential

Lead / Sr. Developer

Responsibility:

• Involved in R&D on Telerik RAD grid/controls, requirements analysis, technical design document, sequence diagram, program logic and detail flow chart.
• Involved in R&D on Net Tier which is used as ORM. Do the initial implementation using Net Tiers code and set standards for other developer for code to be implemented.
• Implemented end to end WCF service calls including review of other service calls implemented by the team members.
• Developed generic custom pagination in Telerik grid control using WCF used by all.
• Accountable for reviewing team member’s code as per Confidential standard.
• Involved in conversion of complex SQL store procedure using Net Tiers code which contains complex LINQ, Lambda expression and complex business logic using C#.
• Trained and conducted noledge sessions with team members to convert complex SQL logic using Net Tiers and LINQ ensuring good quality code.
• Mentored other resources regarding functional and technical issues. Responsible to assign tasks to team members, meet stringent timelines and provide a report to Manager.
• Developed core level API and implement architect level helper class.

Confidential

Sr. Developer

Responsibility:

• Created High Level Document for this application.
• Created List, Roles, Permissions and navigation as per compliance with old application in SharePoint 2010.
• Developed Info Path Form for few reports to display filtered data to achieve old application view.
• Client-side coding in jQuery using Client Object Model for customization that involved populating data using CAML query, attaching custom event on control and populate data on demand, handle validation in pre-save event, hide/show column in EDIT/VIEW form.
• Involved in creating List Workflow from SPD 2010 for updating as well as maintaining history for list compliance with legacy application.
• Responsible for end to migration from legacy application to SharePoint.

Confidential

Project Lead

Responsibility:

• Responsible for task assignment, weekly team reports and maintain the tickets queue.
• Monitored task status among the team members.
• Worked with team members for complex task and resolve their technical queries.

Confidential

Sr. Developer

Responsibility:

• Involved in analysis of all versions of SharePoint content database structure and how data stored in Content Database from SharePoint web UI.
• Developed SQL triggers for all versions of SharePoint Content DBs after analysis of content DB.
• Developed windows service for migrate Remote Data collected from Content Database to Central Database using WCF service through reading SharePoint object Model.
• Developed complex Store Procedure, SQL queries, triggers along.
• Have developed custom installation setup using Install shield.
• Involved in R&D of Click Once and Signing Click Once with trusted Certificate like VeriSign.