SUMMARY:

­­

• 11+ years of assorted expertise in Software Development Life Cycle (SDLC) involving Design, Development, Integration, Implementation and Testing of applications in Client/Server, N - tier Architecture based on Microsoft .NET technologies, SQL Server and Oracle.
• Expert in Object Oriented Design & Development using Microsoft .NET technologies including ASP.NET, VB.NET, C#, ADO.NET, Entity Framework, Web services, XML, IIS Windows.NET Application, .NET Framework, MVC 4.0, WCF, Web API, Visual Studio 2008/10/17 etc.,
• Extensive experience in development of Web and Windows applications using the latest Visual Studio 2012, .NET 4.0/3.5/3.0/2.0 Technologies; writing Functional & Technical Specification; OOAD using UML (MS Visio) & Web services Integration.
• Created SOAP based services with WCF, and CRUD operations are handled with ASP.NET Web API.
• Good experience in using ADO.NET objects such as SQL Connection Object, SQL Command Object, Data
• Reader Object, Dataset Object and Data Adapter Object.
• Experience in Windows Desktop application and WPF based desktop applications.
• Functional Knowledge in Banking domain and Health care domain.
• Expertise in N-tier development architecture and proficient in all phases of SDLC coupled with ample experience in applying them in all kinds of projects.
• Having Experience in VB, ASP, XML, HTML, VBScript, JavaScript, AJAX.
• Managed application hosted IIS in windows server 2012, And SQL server 2016.
• Extensive experience in architecture, design and development of Client-Server and distributed Web applications.
• Experience in programming with Visual Basic, C++, ASP, HTML, VB Script, ADO and XML.
• Solid understanding of Service Oriented Architectures
• Expertise in XML, XAML, HTML, DHTML, CSS, Themes, skins and JavaScript.
• Developed Data Access Layer (DAL), Business Logic layer (BLL) also in implementing Business Processes.
• RDBMS experience includes SQL-Server, Access database connectivity using ADO.NET/ADO, ODBC and programming using SQL, Stored Procedures etc.,
• Experience in developing complex queries, Stored Procedures, triggers and cursors using SQL Server 2010/2008/2005, Oracle 10g, Teradata
• Performed many ETL processing with Microsoft SSIS tool. .
• Ability to work independently with minimal supervision to meet deadlines.
• DevOps work are coordinated with system Admins. Part of automating DevOps, Repliweb jobs are created in shell scripts which will copy the build from UAT to Production/Contingency servers.
• Hardworking, Willing to learn new technologies and good inter-personal skills.
• Excellent communication, Analytical, interpersonal and leadership skills.

TECHNICAL SKILLS:

Programming Languages: C#, SQL, PL/SQL, C++, C, Java 6.0

Microsoft.NET: .Net Framework 4.0/3.5,Web Forms, Win Forms, ASP.NET4.0/3.5 ADO.Net, 3.5/3.0, Web Services, WCF, WPF, Web API, Win Services, LINQ, MVC 3.0, 4.0, 5.0, SSIS

Development Tools: Visual studio 2010/2008/2005

Databases: SQL Server 2012/2008/2005 MS Access, Oracle 10g, Teradata

Web Development: HTML, CSS, XML, DHTML, XHTML, XPATH, SOAP, Adobe Flash MX, Java Script, JQuery, Ajax Programming

Operating Systems: Windows Server 9x/ 2000/2003/2013, Windows XP, Vista, 7, 8, 10

Versioning Tools: Visual Source Safe, SVN Tortoise, Team Foundation Server.

Reporting Tools: SSRS, MS Access Reporting, SQL Server 2005 Reporting Services, Microstatergy

Standards: MS Word, MS Excel, MS PowerPoint, MS Project, MS Visio

Design & Management Tools: Visio, Visual Studio.NET, Expression Blend

PROFESSIONAL EXPERIENCE:

Confidential, NC

Technical Lead

Responsibilities:

• New data model created for new SQL server 2016 repository along with LOB and Teradata architects. Created ER diagram for new SQL server data model. Conducted data model review with Teradata architect team and LOB.
• Performed capacity analysis to migrate current metadata from Teradata to SQL server. Created new SQL server 2016 DB/tables/views with the ER diagram.
• Current ASP.NET web forms migrated to MVC5.0, performed End to end development in modules assigned to me. ASP.Net and C# code was rewritten to modify Model layer and impacted stored procedures based on new data model.
• Used entity framework Database first approach and implemented CRUD operations with ASP.NET Web API.
• Attribute based routing was implemented in application in Web API.
• Performed Stored procedure tuning in SQL server 2016, and better indexing in tables for better performance with new data model.
• Existing SSIS packages has to re-mapped/rewritten based on new data model.
• Part of Level 3 support team, will conduct triage call in case of Severity 1 or 2 issues. Analyzing and fixing the production issues, and responsible for deploying the ASP.net web pages in production.
• Managed Code deployment activities in non-production environments, and production code move with the help of Repliweb job(tool provided by Bank)
• Responsible for CAB/CRQ activities, Coordinating release management activities and for production deployment. And responsible to create packaged code by publishing code.

Product owner/Business analyst (PRM)

Responsibilities:

• Conducting business requirement meeting with LOB/USERS and gather requirements.
• Convert the business requirements to multiple Users stories in JIRA tool (AGILE process is managed in this tool).
• Conduct grooming session to walkthrough the User stories with agile team and LOB.
• Conduct Iteration planning where stories will be pointed and picked based on team capacity.
• Creating Wireframes for the web page UI and writing Pseudo code for the backend business logic, this will help developers to code better.
• Performance issues in pages are identified and created user stories to fix the performance issues.
• Also, part of Level 3 maintenance for this tool. Fixed many SEV1/SEV 2 production issues.

Environment: ASP.NET MVC 5, C#, Web API, SSIS, SQL SERVER 2008, Teradata, Team Foundation Server, One Note.

Technical Lead

Responsibilities:

• Both TPM & CREP and the application developed from Scratch. Including Database design and view design. I was handling from design to implementation in production.
• Actively coordinated with SQL server teams to create environments like DEV, QA, PROD and DR for the project from scratch.
• Implemented Authentication and Authorization for the websites, and configured SSO (Site Minder) in Production environment.
• Implemented Globalization and Localization to support 7 different language features in Web sites.
• Created page layout and implemented MVVM Patten for WPF application development.
• Worked in various SSIS jobs for ETL process.
• HR job will perform SFTP authentication to get HR data for Confidential .
• ARIBA is a daily job which will perform deltas with multiple files and data will be integrated into single ARIBA master table. And website will use data for creating contract.
• ADAT will import perform table sync up between ADAT and TPM systems.
• Consumed Sanction screening web service of Confidential and website will perform screening for vendors with SOAP protocol. And response will be captured and stored in TPM.
• Currently working on development of CREP, this website will be dynamically changed based on configuration tables. And control can be changed from Textbox, Dropdown, and Multi select based on table configuration.
• Whole risk exposure matrix will be driven from table; Based on country and category selecting various risk questions will be driven from tables.
• Configured TFS environment for the project and performed configuration admin for the code maintenance.

Environment: ASP.NET 4.0, C#, WCF, SOAP, SSIS, SQL SERVER 2008, Team Foundation Server, One Note.

Technical Lead

Responsibilities:

• Designed and developed FFM/CMS integration with Benefit align product.
• From portal (benefit align), if users need to check their Government subsidy. Application will do a SAML redirection to healthcare.gov website. IN SAML redirection Request portal will send the return URL and Heart beat URL, so users can come back to portal website to submit payment.
• Once users submitted their application in healthcare/FFM/CMS marketplace will do SAML redirection to Portal website and users will use the subsidy amount from marketplace.
• I have consumed two Healthcare.gov SOAP web services.
• Eligibility: Used to get the current status of eligibility of the applicant in FFM/CMS.
• Enrollment: Once Eligibility web service is success and have all the values required for eligibility application. Enrollment web service will be called to get the subsidy amount and all others marketplace details about the customer.
• Took care of END to END flow of FFM integration with Portals.
• Will attend all CMS webinars and designed this integration.
• Backend is SQL server and we are using REST web service to interact with SQL Server.

Environment: C#, MVC 4.0, WCF, SOAP, REST, Alfresco(Document storage), SQL SERVER 2014, Team Foundation Server, One Note.

Sr. .Net Developer & Onsite Lead

Responsibilities:

• Designed and developed front end pages using ASP.NET, JavaScript and HTML.
• Interacted with business partners in gathering the requirements and helping them prioritize their requirements.
• Part of the innovators team in RACF password generator, designed workflow and implemented code logic in ASP.Net, C# and windows executable.
• Participate in joint application development sessions with business and analyze the requirements.
• Worked with cross-functional team members to recommend technical solutions to business issues and system issues.
• Worked as onsite team lead, for 14 offshore team members responsible for both productions support and development activities for application. Also developed screens to support development activities.
• Adding User Controls to the framework that can be used across the application.
• Analysis, design and development of the web site.
• Used ADO.Net for Interacting with Databases.
• Designed and Developed Master Pages for the application.
• Immediate onsite bug fix for severity 1 and severity 2 issues happened in application, Additional to development activities acted as Level 3 support responding to user queries and support for clients.
• Perform Unit testing and integration testing, and provide bug fixes.
• Deploy code and other database changes in different Teradata environments.
• Data retrieval using ADO.NET datasets, data table and data adapter.
• Performed data validations using validation controls such as Required Field Validator, Compare Validator, Range Validator, Regular Expression Validator, Custom Validator and Validation Summary and used Java Script for Client Side validation.
• Developed functions, triggers, views and stored procedures using SQL SERVER 2005 and Teradata.
• Testing, Bug Tracking and Maintenance.
• Developed Test Plan for testing the application.
• Responsible for all release activities to different environments (Dev, UAT, Prod)

Environment: C#, ASP.NET, VB.NET,COM, ASP, XML, JavaScript, DCOM, . Net Framework 4.0, Web Services, VBScript, DHTML, HTML, SQL SERVER 2005, MS Visio, Team Foundation Server.

Sr. Web Developer & Onsite Lead

Responsibilities:

• Users for this web site are Project managers and resource managers of Confidential . Excel reports developed in this project will provide data’s for forecast and actual cost of this project in EIM portfolio. Worked as Onsite counterpart for all EIM managers and responsible for all report level enquiries and data population. Actively developed Manage Project screen from onshore. And will generate various weekly and monthly reports till Bank Level 3 managers, these reports will have complex queries and responded to many business queries with fast turnaround time.
• Performed analysis with end users and business process owners in order to determine and document requirements for the design, development, and implementation of new system.
• Served as liaison between offshore/Onshore developers and end users in translating business requirements to technical designs and applications.
• Involved in creating complex SQL queries, for excel reports. And Excel VB macro will generate report directly in Excel
• Designed and developed complex Web Forms & User Interface Screens using C#, HTML & Java Script.
• Effectively created easy to use, reusable controls and Master Pages and integrated them into ASP.NET web pages with MVC 4.0.
• Extensive use of ADO.NET for achieving disconnected database connectivity.
• Used Subversion (SVN) for version control.
• Used various error handling techniques to handle the runtime errors that are occurring.
• Extensively used View State & Caching for the dynamic controls to speed up the application.
• Involved in developing web code, SSIS packages, and Excel reports. And developed Manage project screen from onsite in development period.
• Reviewed design documents, code, unit test scripts and all the deliverables.
• Deployed code, packages and reports in different environments. Provided production support during warranty period.
• Designed and developed the complex SSIS package that loads data from different data sources at different frequencies.
• Currently working on changing all excel reports to Micro strategy.
• Coordinating with Micro strategy architect to create a better data model which will act as reporting database layer, and Micro strategy server will use the new Reporting layer.
• Learning Micro strategy, and developed few sample reports to senior management for demo, and currently in progress of development to convert all excel reports to Micro strategy.

Environment: .NET Framework 3.5, VB.Net(excel macro), C#.Net, ASP.Net, VBA, ADO.Net, JavaScript, JQuery, HTML, DHTML, AJAX, SQL SERVER 2008,T-SQL, DB2, Subversion, Microstatergy and XML Web Services.

Sr. Developer & Onsite Lead

Responsibilities:

• Design and development of Desktop application using WPF and JavaScript.
• Designing WPF Forms, Custom Controls and User Controls using XAML language for interactive UI. Implemented business logic using C#.
• Used Dependency Properties to bind data on these control
• Worked on BL and DAL layer classes and integrated in UI using MVVM pattern.
• Extnsively used Action, Func and Predicate in ViewModel and Middleware classes.
• Learned quickly about master data Management database and its hierarchy level structure tables.
• Involved in the design and maintenance of databases for various module in Oracle 10g and MDM.
• Worked on various WCF services / Web Services web services which will be used to syndicate data from oracle to MDM database. And learned quickly to use Hyperion tool to Navigate MDM database.
• Data retrieval using ADO.NET datasets, data table and data adapter.
• Developed various stored procedures using Oracle 10g.
• Different validations controls provided in WPF are used for input validations.
• Requirement analysis, Preparing Use Cases, Functional Specification & TechnicalSpecification using MS Visio
• Testing, Bug Tracking and Maintenance.

Environment: . Net Framework 4.0, C#.Net, WPF, COM, ASP, Java Script, HTML, Web Service, WCF, DCOM, UML, Oracle 10g, SSIS, MDM Hyperion and XML Web Services.

Offshore team lead, .NET Developer

Responsibilities:

• Worked as offshore Lead managing, responsible for coordinating with onshore and understanding requirements.
• Assisted in creating the project plan, estimates and resource plan for many enhancements.
• Responsible for requirement gathering and involved in analysis and design of the system based on n-tire architecture.
• Translated the business requirements into technical requirements and designed the architecture based on the business needs.
• Created database design and other database objects needed for the application.
• Took care of all development activities in team, and involved in development of Emerging Risk module.
• Used separate Presentation, Business Logic and Data Access Layer in project development.
• Implemented business logic using C#.
• Involved in the design and maintenance of databases for various module in SQL2K.
• Database access achieved through ADO.NET datasets.
• Developed user interface for the modules using ASP.net, Server Controls, Validation controls and HTML.
• Extensively worked on creating CSS, Master Pages, Theme and Site Definition to enrich the portal.
• Used JavaScript to perform front end validations as per the business rules proposed.
• Used Visual source safe for version control for version control.
• Wrote Stored Procedures and SQL queries

Environment: .NET Framework 2.0, Visual studio .NET 2008, MS SQL Server 2005, SSIS, SSRS, C#.net, ASP.net, ADO.net, Java Script, AJAX, CSS, VSS

.NET Developer

Responsibilities:

• Involved in requirement analysis, functional specification & effort estimates.
• Responsible for requirement gathering and involved in analysis and design of the system based on n-tire architecture.
• Coded and developed Timeline modules using ASP.NET technologies.
• Translated the business requirements into technical requirements and designed the architecture based on the business needs.
• Involved in the design and maintenance of databases for various module in SQL2005.
• Database access achieved through ADO.NET datasets.
• Code behind done with C#.
• Developed user interface for the modules using ASP.net, Server Controls, Validation controls and HTML.
• Used Visual source safe for version control for version control.
• Worked on developing Stored Procedures, functions, data scripts, views, indexes in SQL 2005/2008.

Environment: .NET Framework 2.0, Visual studio .NET 2008, MS SQL Server 2005, SSIS, SSRS, C#.net, ASP.net, ADO.net, Java Script, AJAX, CSS, VSS

VB Programmer

Responsibilities:

• Involved in analysis, design and development of the project.
• Involved in developing a custom URL encryption logic which will prevent Cross site scripting.
• Validated for special characters like with java script.
• Coded and developed many modules using VB technologies.
• Created unit test scripts and did peer review of the code and test scripts created by other developers in the team.
• Unit and Integration testing of the application.
• Build Manager of a small team, taking care of day to day build and deployment activities in DEV and SIT environments
• Testing, Bug Tracking and Maintenance.

Environment: VB, VBA, MS Excel, SQL Server 2005

Programmer

Responsibilities:

• Worked as Level 3 support person responsible for production issues in BOA VRU.
• Learned Peripro and performed Level 3 support activities with zero production issues.
• Unit and Integration testing of the application.
• Taking care of day to day build and deployment activities in DEV and SIT environments
• Involved in creating various project System appreciation document.

Environment: Peripro, UNIX