SUMMARY

• 8 years of IT experience in Software Development Life Cycle (SDLC) involving Requirement Gathering, Architectural Modeling, Design, Development, Testing, UAT, Deployment and Support.
• Architected, designed and development of .NET based products in C# and SQL.
• Experience with Microsoft technologies including but not limited to Azure, C#, ASP.NET MVC, .NET Core, Web Services, WCF, Web API, ADO.NET, Entity Framework, Power BI, WSDL, XML, JSON, LINQ, T - SQL, SSIS, SSRS and TFS.
• Experience creating Azure functions, deploying web apps in Azure.
• Experience in developing front-end User Interface using JavaScript, jQuery, HTML and CSS.
• Hands on experience on ASP.NET MVC pattern: Controller Actions, View Engine, HTML Helper methods, Entity Framework Model.
• Excellent experience in implementing Web Service, RESTful services which communicate data in a both XML & JSON.
• Strong RDBMS skills in creating Stored Procedures, Views, Triggers and Functions.
• Expertise in building SSIS (SQL Server Integration Services) packages to automate various ETL jobs.
• Experience in building various letter templates using SSRS.
• Experience with using various HTTP clients like Postman, Ready API, Fiddler for testing web APIs.
• Experient building reports in Power BI.
• Experience in Configuration Management using Team Foundation Server (TFS).
• Responsible for providing high-end development solutions and troubleshooting all issues related to development, implementation, and deployment of applications.
• Worked extensively in Agile and Scrum methodology (iteration and stand-up meetings etc.) with strong sense of ownership of development.
• Good Knowledge of Design Tools, UML Diagrams and Design Patterns.
• Experience in SQL tuning and query optimization tools like SQL Trace, Execution Plan, and Profile.
• Proficient in data conversions and data warehousing tasks.
• Worked on various types of web Apps projects (Implementations, Support/Maintenance and Upgrade).
• Excellent communication, analytical, interpersonal, problem solving and presentation skills. Keen to learn & develop using new technologies quickly.
• Self-driven, passionate, and highly motivated. Possess good communication, presentation and interpersonal skills with high motivation and desire to learn in a fast paced ever changing environment.
• Adept and building strong business relationships with both clients and co-workers.
• Excellent interpersonal and organizational skills, ability to handle diverse situations, multiple projects.
• Proficient in handling responsibilities such as code review, compliance to best practices & standards, technology mentoring, knowledge transfer, assisting team members and customer training.
• Excellent customer management/resolution, problem solving, debugging skills and capable of quickly learning, effectively analyse results and implement and delivering solution as an individual and as part of a team.

TECHNICAL SKILLS

Core Competencies: C#, ASP.NET, .Net Core, .Net Framework, ASP.NET MVC, Web API, ADO.NET, Entity Framework 4, Web Forms, WCF, LINQ, Azure, MVC5, REST, Swagger

Database: Microsoft SQL Server, TSQL

UI Technologies: Angular 2+, JavaScript ES6, jQuery, JQueryUI, Java Script

Version Control Tools: Team Foundation Server (TFS), SVN, GIT

Bug Tracking \ Management Tools: Visual Studio Team System, TFS, Jira

Build Management & Deployment: Azure Dev Ops, GIT, Visual Studio Team Foundation Server (VSTS), MS Build

Integration & Reporting Services: SQL Server Integration Services (SSIS), SSRS, Power BI

Design Patterns: Façade, Inversion of Control, Abstract Factory, Singleton, Circuit Breaker, Builder, Command

Azure Services: Virtual Machines, Azure Functions, API Management, Azure CDN, Azure Service Bus, Logic Apps

PROFESSIONAL EXPERIENCE

Confidential, Fate, TX

Senior Transformation Analyst

Responsibilities:

• Involved in meetings with clients and internal team members to find best solutions for the client requirements.
• Meet with clients on a regular basis to gather requirements and update the project status.
• Responsible for configuring the system as per the requirements gathered.
• Participated in Designing databases to ensure that the relationship between data is guided by tightly bound Key constraints.
• Extensively used ASP .NET concepts such as Master Pages, Sessions, post-backs etc., and written logic in code-behind files with C# in .NET 4.7 Framework.
• Involved in implementation of ASP .NET Core MVC Controllers, passing the data from controller to view using View-bag, Model bindings, temp data and created Views/Partial Views, Layout Pages etc.
• Developed view models and controller actions to transfer data between controller and views for the admin portal.
• Converted ADO .NET code to Entity Framework by using Code First Approach in Data Access Layer.
• Designed and developed WCF Services using SOAP messages with different bindings, and generated WSDL files for service description.
• Extensively used LINQ to SQL Queries and LINQ to Entities for manipulating data retrieved from database.
• Extensively used OOPS Concepts and SOLID principles in C# to implement business logic by creating abstract classes, interfaces, and classes.
• Developed and enhanced User Interface Components using HTML5, CSS3, JavaScript, AJAX Toolkit.
• Extensively worked with JQuery for HTML Controls traversal/manipulations and for Client-Side Validations.
• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Responsible for developing interfaces/Conversion logic to import legacy data (Member, Provider, Authorizations, claims etc.,) from client systems into SQL Server conversion tables and transform to batch loader files for loading into new system.
• Extensively worked on C#, T-SQL and SSIS to transform the legacy data received to desired format as per system specifications.
• Write complex queries, stored procedures, views, triggers, functions, Indexes etc, to transform data.
• Developed various pipelines in Azure Data Factory to load data from CSV files to Azure SQL Database.
• Build serverless API that return data from SQL database using Azure SQL bindings in Azure functions using HTTP trigger to return product details and display on web portal.
• Responsible for building automated batch jobs to transform and load data on daily basis.
• Create new and update existing Web API endpoints as per client requirements.
• Create new and customize existing web pages in web portal as per client needs.
• Create and customize stylesheets on web and windows application using XSLT.
• Build various graphical reports that summarizes the type of provider and Member registrations using Microsoft Power BI.
• Modified existing data warehouse jobs and packages to enhance the performance and any production issues.
• Build process flow diagrams for each task assigned.
• Responsible for creating Mapping documents for clients and internal team members for better understanding of the logic implemented while transforming/converting client’s data.
• Responsible for assisting other team members in configuring the system and coding complex business logics, when needed.
• Help clients with providing information on using Web API endpoints.
• Assisting QA team with explaining the implemented logic, when needed.
• Resolving bugs/defects in a timely manner to meet deadlines.
• Involved in daily status meetings with other team members, managers, and director to update status of the assigned tasks.

Environment: Visual Studio, SSDT, SSIS, C#, SQL Server, T-SQL, Azure Data Factory, Azure functions, Visio, HTML, CSS, JavaScript, ASP.Net, .Net Core, Web API, JSON, XSLT, XML, IIS.

Confidential, Lewisville, TX

Sr .Net Developer

Responsibilities:

• Involved in meetings with client and internal leads and managers to find best solutions for the client requirements.
• Responsible for scheduling meetings with client to gather requirements.
• Analyze various batch load specs in detail to create batch load files to be loaded into the system.
• Build SSIS packages to batch load CSV encounter files received from Delta.
• Responsible for mapping fields in CSV files to batch load specs by understanding the business behind them.
• Build SSIS package to load 837 encounter files received from VSP and HPMG.
• Created Interchanges required by the process to load 837 files into the system.
• Used custom stored procedure within Interchange to update some of the date loaded from 837 files.
• Created multiple PowerShell script files to execute different Task Agent tasks.
• Worked on generating multiple outbound files by executing necessary extracts as per the specs provided by the client.
• Build various letter templates (EOB, EOP, registration letters etc.,) using SSRS.
• Build process flow diagrams for each interface assigned.
• Integrated InsataMed payment portal with HSP iTransact member portal for member premium payments as Single Sign On using SAML.
• Worked on decrypting SAML response using certificate provided by Instamed.
• Developed components for new screens, services to call REST APIs, custom directives etc.
• Customized XSLT stylesheets to show or hide data on iTransact portal as per client needs.
• Extensively used MediTrac, HSP Admin, HIPAA Gateway and iTransact applications.
• Involved in daily status meetings with other developers, Managers and director to update status of the assigned interfaces.

Environment: Visual Studio 2015, SSDT, SSIS, C#, SQL Server, Visio, LINQ, ADO.Net, HTML, T-SQL, JavaScript, ASP.Net, XSLT, XML, SAML, IIS.

Confidential, Love Land, CO

Senior Software Developer

Responsibilities:

• Involved in discussions with project manager and service delivery manager regarding enhancement deadlines as per delivery milestones.
• Following Scrum methodology during project delivery which includes Sprint Planning & Daily Scrum meetings.
• Contact users to gather information from users about reported bugs.
• Fixing existing bugs reported by users.
• Help other developers by analyzing existing applications and assist with best available solutions.
• Written TSQL queries for database operations.
• Written and optimized complex SQL Queries, Stored Procedures, Functions, Triggers and Views using Microsoft SQL Server.
• Coordinate onsite and offshore team and involved in assigning tasks.
• Customize existing windows forms applications as per client needs.
• Customize C# based web services applications as per client needs.

Environment: Visual Studio 2017, .NET framework 4.5, ASP.NET, LINQ, jQuery, JavaScript, ADO.Net, SQL Server 2014, T-SQL, TFS, VB.Net.

Confidential, Rancho Cucamonga, CA

Full stack Developer

Responsibilities:

• Involved in discussing the feasibility of requirements with team.
• Involved in Design, Architecture planning and development throughout the project.
• Worked in designing, documentation of application flows and developed functional diagrams using Visio.
• The integrated environment Visual Studio 2017 was used for developing the complete application based on the Web API pattern. Developed the application as a three-tier application with Controllers to communicate with client, Business logic in the middle layer using C# and Data Access Layer to communicate with data base.
• Involved in designing Layouts to provide uniformity among the web pages.
• Created various web API endpoints(controllers) which serves data to client application and post data to database via BLL and DAL.
• Extensively used LINQ to query and merge data in different forms.
• Used C# generics to achieve code reusability.
• Consumed Web APIs to get member Information from different applications.
• Implemented jQuery for UI validations.
• Implemented Data Access Layer using ADO.Net.
• Used SQL server 2017 for writing Stored Procedures, Tables, UDD, Views and Functions
• Created automated process using SSIS package that runs daily to generate registration confirmation/reminder CSV files for mail room.
• Implemented feature flag to retrieve data from specific environment and update data in respective environment (ex: Development, QA, UAT, Prod).
• Generated reports using Power BI
• Used Postman HTTP client for testing Web APIs while developing.
• Adhering to implement the project in agile methodology.
• Utilized Team Foundation Server (TFS) as version control tool and check in code on daily basis.
• Involved in meetings with project manager, technical lead, QA and end users in defining and optimizing requirements and expected results.

Environment: Visual Studio 2017, .NET framework 4.6.1, ASP.NET Web API 2, LINQ, HTML 5, jQuery, ADO.Net, SQL Server 2017, T-SQL, SSIS, Team Foundation Server 2017.

Confidential, Rancho Cucamonga, CA

.Net Developer

Responsibilities:

• Attended various meetings with the business users to discuss estimation and planning of enhancement requirements.
• Involved in gathering System Requirement, Data Requirement, and prepared design document.
• Adhering to implement the project in agile methodology.
• Analysing and documenting the existing applications.
• Communicating with other developers to get proper understanding of data returned by channels.
• Created Web API end points by consuming data from other channels (ex: provider, member) and data base.
• Used LINQ to merge different C# objects and query data quickly and efficiently.
• Used Entity Framework in data access layer to get data from database.
• Worked with SQL Server 2016 for developing stored procedures with complex business rules and created tables and functions in the database.
• Wrote various integration stored procedures to gather data from different databases and fill flat tables.
• Implemented indexing for various tables in the database for improving performance of the application.
• Responsible to debug and fix the existing code, based on the test cases provided as per business requirements.
• Assisting the team members, with their daily tasks and responsibilities, when necessary.

Environment: .NET Framework 4.6, C# 6.0, ASP.NET MVC 5, LINQ, Web API 2, Web Service, T-SQL, Entity Framework 6.0, SQL Server 2016, IIS 7.5, Visual Studio 2015, TFS 2015.

Confidential, Rancho Cucamonga, CA

.Net Developer

Responsibilities:

• Involved in redesign the existing application to fulfil the Phase-2 requirements.
• Created new Web API end points.
• Consumed web services to get data from other vendors.
• Worked on html part and validations.
• Worked on existing code to download cases and activities from Oracle CRM via web services.
• UsedjQueryevent handling in UI pages to display list boxes and to handle validations.
• Participated in peer-to-peer code reviews.
• In addition, capture and implement designs created by the UI team, add new functionality, enhancements, and improvements on the overall website aesthetic.
• Followed Agile development and consistently delivered new features on time during sprints.
• Communicated updates in daily scrum meetings.

Environment: Visual Studio 2015, .Net Framework 4.6, HTML, C# 6.0, Web API 2, IIS, SQL Server 2014, Team Foundation Server (TFS) 2015.

Confidential, Rancho Cucamonga, CA

.Net Developer

Responsibilities:

• Involved in entire SDLC Life cycle of the development of the application.
• Involved in coding, development, Unit testing and bug fixing for the entire application.
• Wrote code to consume SOAP APIs and get data in xml format.
• Extensively worked serializing and deserializing large XML.
• Developed class files for business layer and data access layer.
• Participated in database design in SQL Server 2014 to create tables.
• Created stored procedures in SQL Server to update multiple tables.

Environment: Visual Studio 2015, C# 6.0, T-SQL, SOAP, XML, SQL Server 2014.

Confidential

Jr/intern .Net Developer

Responsibilities:

• Study the requirements of the clients and the specific needs of the business projects.
• Developed core functionality usingASP.Net, C# and MVCFramework.
• Require the user to specifydurationof no more than set number of months, for which the Lab will exist.
• Notify users via email of Labs nearing expiration.
• Worked on mechanism that automaticallyexpireLabs once they have reached the expiration date.
• Provide an n-month un-expire capability for Labs that have expired.
• Developed middle tier webservices for implementing the core functional areas in application and consuming other services.
• Upgraded some existing application functionalities from .Net 2.0 to .Net 4.5.
• Experience in Agile software development methodology.

Environment: C#,ASP.Net4.5, MVC, jQuery, HTML5, Entity Framework, LINQ.