SUMMARY

• Microsoft certified professional with 12+ years of rich experience in IT Application Design, Development& Maintenance in functional domains like Service Management, CRM ERP development using various Microsoft Technologies.
• Experience in developing/managing N - tier applications using Visual Studio, C#. Net, ASP.NET, MVC, VB.NET, JavaScript, VBScript, WPF, Entity Framework etc.
• Proficient in developing distributed applications in Web Services (SOAP, REST), WCF, LINQ, Windows Services and WSDL.
• Well versed in Object Oriented Programming (OOPs) and SOLID concept of software Architecture.
• Proficient in implementing various design patterns including, Façade, Factory Pattern, Singleton, Observer, Dependency Injection and Strategy pattern etc.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions. Relational Database models and Data integrity and SQL Joins.
• Expert in Performance Tuning and Optimization of SQL Scripts, Views and Stored Procedures
• PMP & ITIL Certified. Expertise in Project Management activities from project initiation to closure phase with project management capacity. Sound Knowledge ITIL Processes (Incident, Problem, and Change Management systems).
• Experience in Extracting and Transforming (ETL) data using SSIS, SQL Server Import Export, Bulk Insert and BCP.
• Experience in creating database maintenance tasks like Indexing & Statistics update, backup & restore jobs.
• Proficient in various Software Development Life Cycle (SDLC) Models. Suggested and implemented process improvements, best coding techniques and standards.
• Experience in Functional, Integration, System, Regression, Usability and User Acceptance Testing.
• Proficient in preparing Project documentation like Functional Specification, Test Plan and Use Cases etc.
• Highly professional and solution oriented attitude. Responsible individual with exceptional research and analytical skills. Proven problem solving capabilities and ability to meet Challenging goals. Excellent communications and interpersonal skills.

TECHNICAL SKILLS

Languages: C#.NET, VB.NET, VB 6.0

Databases: SQL Server 2000/05/08/12/14/16

Framework: .NET 1.1, 2.0, 3.5, 4.0

Web Technologies: ASP.NET MVC, XML, WCF, WPF, REST, LINQ, AJAX, Web API, JQuery

Design Methodology: UML, MS Visio, Entity framework

Scripting Languages: Java Script, VB Script

Web Servers: IIS 6.0 / IIS 7.0

Platforms: Windows2000, Windows NT, Windows9X. Win7

Paradigms: Object Oriented, Agile SCRUM, Functional and Logical.

Reporting Tools: OBIEE, MS Power BI, Crystal Report 10

DW tools: MS-SSIS, SSRS, SSAS

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Architect and Project Lead

Responsibilities:

• Involved in full Software Development Life Cycle (SDLC) and identifying the requirements and defining the business rules to user requirements.
• Created the Technical design document/ Database design document including creating database structure, UML documents including State chart, Activity Diagram, Sequential diagram.
• Designed the application flow and identified Interfaces, classes and calling mechanism.
• Developed WCF based application using C# for Initial data setup related to products cost.
• Used WCF to perform Duplex Communication, One way Messaging and DB connectivity.
• Worked on LINQ to SQL based queries to filter data.
• Developed WebAPI based APIs using HttpGet and HttpPost attributes.
• Designed the DW dimensional model (Dimensions, Facts) using Star Schema.
• Performed various project management related tasks in the development life cycle including communication to stakeholders, weekly progress report to management.
• Used Entity Framework 6.0 to insert, fetch and update the data in database.
• Verifying performance and impact of code written by peers.
• Created users Role base security (permissions) for reports and migrated database to SQL Server 2016 to implemented Row Level Security.
• Configure the ETL packages, Cubes in Jobs and Scheduling the Jobs Using SQL Server 2012.
• Used Team Foundation Server (TFS) extensively for version control of the source code along with the maintenance of the builds and the relevant documents of the same.
• Used JIRAas bug tracking and project management tools.

Confidential

Project Lead/Sr. Developer

Responsibilities:

• Prepared Architectural Document, UML documents including State chart, Activity Diagram, Sequential diagram.
• Created a Technical design document based on Business and Functional requirement document and reviewed the document with internal and external clients.
• Migratedlegacy system written in VB 6 and upgradedSQL Server .
• Implemented the Observer design pattern for patients’ appointment module.
• Involved in the design, development, coding and implementation of the solution. Each view was developed using MVC 4 (RAZOR engine), also worked on Partial Views, controller actions, Business and Data Layer.
• Used the UpdateModel function in MVC.
• Hosted the web site on IIS and published for distribution on web and mobile devices.
• Applied WPF templates for the application UI (logical separation of a control from its appearance).
• Responsible for talking to clients and understanding the technical/functional requirements.
• Designed the technical database architecture, developed complex Stored Procedure for invoice process.
• Involved in Identifying the Business Entities and converted those Business entities toData Contract.
• Developed web site in ASP.NET with Bootstrap, JQuery, AJAX, JSON and HTML.
• Deploying/Releasing the application and fixing bugs found by peers and clients.
• Used SSRS to design key reports for invoice printing

Confidential

Architect and Sr. Developer

Responsibilities:

• Involved in System study, analysis and designing application architecture with Lead Architect and Project Lead.
• Leading the team of developers, communicating with various stakeholders and updating project progress.
• Designed Controller Actions, Partial view, Business and Data Access Layer. Each view was developed using MVC 4 (RAZOR engine).
• Analysis and design for WCF components by identifyingthe Service Contracts, Operation Contracts, Message Contract and Fault Exception.
• Define controller and model being used in application and implemented Entity Framework for database operations.
• Wrote views, stored procedures, triggers and functions for the manipulation of the underlying data in the database.
• Designed Snow Flake Schema, the dimensional model (Dimensions, Facts) database architecture.
• Involved in deployment of the entire system on Development, Staging and Production environment.
• Configure the ETL packages and scheduling the Jobs Using SQL Server 2012.

Confidential

Senior Developer

Responsibilities:

• Created the Architectural Document, UML documents including State chart, Activity Diagram, Sequential diagram.
• Created a Technical design document based on Business and Functional requirement document and reviewed the document with internal and external clients.
• Created the Project layout, Application Architecture, Proof of concept etc.
• Created a development environment and testing environment for development which includes setting up virtual servers and databases.
• Developed the ASP.NET web based application which fetches data based on search criteria, perform calculations and generate reports exportable to excel and PDF.
• Server side caching is implemented to store all change in memory for fast processing.
• Telerik third party controls(Windows Controls, Web Forms ControlsandReporting) to support the integration with the Database and the UI for the presentation module.
• Programming a new web application using .NET Framework 3.5 with C# for implementation of India Tax system.
• Responsible for Programming / Developing the Web Applications using the MVC Framework 4.0 (Model View Controller)
• Wrote complex tax computation queries in LINQ on the data fetched from database.
• Database access layer (Server side) is created using Entity Framework 4.0 and the communication to the middle tier is done through the WCF Services. WCF Services are hosted in IIS. The communication end points are configured with “BasichttpBinding”.
• Wrote database objects like Tables, Functions, Stored Procedure and Triggers.
• Developed WCF service which fetched data from country databases, filters, transforms and save in central database for reporting. The service supports various bindings for communication on intranet and internet.
• Involved in creating and designing the conceptual and logical database model to integrate as part of the system.
• Cross trained team members for using new technology and implementation.
• Implemented the external web services defined by other components.
• Created client tools both Web and Windows based to test the Framework and POC for implementation of framework.
• Responsible for Data build and Release for various system interacting with end client.

Confidential

Sr. Developer

Responsibilities:

• Involved in client interaction and requirement analysis
• Prepared Functional/Technical document and presented the scope to key stakeholders.
• Responsible for Programming / Developing the Web Applications using the MVC Framework 3.5 (Model View Controller)
• Involved in project estimation and used Function Point Analysis method for the same.
• Created the Multi Layered and loosely coupled architecture.
• Developed web service to fetch prospect customer related information from external system.
• Worked on LINQ based queries to filter data and sorting.
• Define database architecture and wrote Stored Procedure, Views for reading, saving, update and delete.
• Participated in desk check, code reviews, internal and external reviews of technical design documents.
• Involved in deployment of the entire system on Development, Staging and Production environment.
• Responsible for Data build and Release for various system interacting with end client.
• VSSfor version control and source control of the software, JIRAis used as bug tracking and project management tools.

Confidential

Sr. Developer

Responsibilities:

• Communicated with Tax authorities about for requirement gathering, analysis and WBS preparation.
• Wrote complex module for tax calculation for Gas and Rental/Services invoices.
• Created the Multi Layered and loosely coupled architecture and design the UI.
• Define database architecture and wrote Stored Procedure for reading, saving, update and delete.
• Participated in desk check, code reviews, internal and external reviews of technical design documents.
• Involved in deployment of the entire system on Development, Staging and Production environment.
• Responsible for Data build and Release for various system interacting with end client.

Confidential

Sr. Developer

Responsibilities:

• Communicating with key stakeholders to requirement gathering and preparing Functional Spec.
• Design rich UI using WinForms and application architecture using Façade pattern.
• Design database architecture - tables, stored procedures, views and functions.
• Written code to integrate application with existing ERP application used by affiliates.
• Support for UAT and production issues.

Confidential

Software Developer

Responsibilities:

• Communicating with key stakeholders to understanding requirements and convert them to business flows.
• Design application architect and created technical documents.
• Design database structure - tables, stored procedures, views and functions.
• Wrote .Net code for assigned module.
• Performer user training and Support for UAT and production issues.

Confidential, North Carolina

Software Developer

Responsibilities:

• Software module developer as per Use Case using ASP.Net 1.1 and C#.Net 1.1.
• Understanding user requirements and convert them to business flows.
• Client interaction and prototypes development.
• Support for UAT and production issues.
• Handled client calls for new requirement discussions, change requests and maintenance activities.