Sr Onsite Technical Lead Resume
AtlantA
SUMMARY
- Technology Professional offering around 12+ years of experience in designing and developing web and window based applications and processes using Microsoft Technologies.
- Over 6+ years of experience in developing stand - alone & Internet Application utilizing Visual Basic 6.0/ CLASSIC ASP/VBScript/HTML.
- Around 5+ years of experience with C#/ASP.NET/VB.NET/MVC/WebForms/ADO.NET/ WinForms/WPF/WCF/Web API/ JavaScript, jQuery, and Entity Framework in developing Web Applications.
- Experience with JavaScript, jQuery, JSON and JS based framework AngularJS & TypeScript
- Experience with HTML5 and CSS3
- Over 10+ years of experience in database programming using Oracle (PL-SQL).
- 5+ Years of experience in writing T-SQL queries in SQL Server 2000/2008.
- 1+ years of extensive experience in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) using SQL Server 2008/2005.
- Experience with SQL performance tuning.
- Worked on Agile Scrum methodology environment.
- Onsite lead for Support team to provide 24x7 technical supports to related issues and to maintain/monitor the proper functioning of all production applications and different job running on the production environment.
- Experience in handling roles involving client interaction, providing estimates, track project work & report work status for team. Requirement Analysis, writing WBS, Technical Design, LLD, Coding, Testing, Configuration and Build Management.
- Have worked for Crop, Media Entertainment, Rights Management System, Legal, Learning Management System.
- Possesses experience in all stages of SDLC including planning, estimation, knowledge transition, requirements gathering, designing & documenting application flow, application development & maintenance, testing, implementation and post production support.
- Team Handling and Leading the team at onsite & offshore
- Knowledge of SQL, Design Patterns and Best Practices, OO programming and best practices
- Database Programming with the help of Stored Procedures, Triggers, Cursor and Indexes.
- Extensive Experience in Designing and Creation of Crystal Report 11.5
PROFESSIONAL EXPERIENCE
Confidential, Atlanta
Sr Onsite Technical Lead
Responsibilities:
- Designed, developed and implemented Active Report in the existing application to provide user the facility to different report based on different criteria using ASP.NET/C# /MVC/Entity Framework/jQuery
- Upgraded the existing FTP Process written in MVC/C# to use new version of WinSCP Client.
- Designed, developed and implemented new workflow in Concert to replace existing Remedy Integration with SNOW.
- Change was implemented in the Interface to Communicate with Web Services using ASP.NET/C#/Entity Framework/MVC/Java Script/JQuery.
- Providing production support and developing enhancements for we based application like Concert / AAA & Legal Applications using VB.NET/ASP.NET/C#/Entity Framework/SQL Server 2014 & Oracle 11g.
- Designed, developed and implemented automation process using C# & Entity Framework to check DB Connection & Tibco Services and notify the users if they are down.
- Created ad-hoc PL/SQL and T-SQL queries to generate custom reports requested by business users from Order Management team.
- Development of the new BO Reports and deployment it on downstream and prod environment.
- Worked closely with L2 & L3 Support team to provide technical assistance to maintain/monitor the proper functioning of all production applications.
- Lead Production outages due to patching in SQL Server updates and service pack updates.
- Coordinating with Onsite and Offshore team members for end to end delivery of any enhancement or modification required by business.
- Participate in gathering business requirements and organizing meetings with business stake holders, development teams and QA analysts on a scheduled basis.
- Responsible for change management and discussion of all changes in change control board meetings.
- Responsible for Technical Analysis, Code Review, Implementation and post installation production support.
- Provide production support through ticketing system using SNOW.
- Use SNOW to create RFC (Request for Change) to push data fix, small enhancements into production.
Environment: ASP.NET, C#, MVC, ADO.NET, LINQ, VB.NET, Entity Framework, SQL Server 2014, Oracle 11 (PL-SQL), SQL Developer, JavaScript, JSON, jQuery, XML, Postman, ServiceNow, TFS
Confidential, NY
Sr. Technical Consultant
Responsibilities:
- Application migration planning and strategizing how and when application will be moved
- Onsite Lead& Offshore coordination.
- Working with Business Users to understand the requirement and document them to get the final sign off
- Working on creating Technical Design Document and review them with Technical Team of TW
- Mentoring team members
- Production Support. For the .NET applications and making changes to the existing system for new business requirement using C# and VB.NET
- Created ad-hoc PL/SQL and T-SQL queries to generate custom reports requested by business users from Order Management team.
- Used Toad/PL-SQL Developer to write various Stored Procedures, Functions, Views and Triggers to implement business logic in Oracle database.
- Worked on developing application written in C#/ VB.NET and MVC 5.0.
- Making Changes in the existing Stored Procedure and writing new stored procedures for the new requirements using T-SQL and PL-SQL
- Stored Procedure Performance Tuning to improve application performance.
- Requirement gathering and analysis by interaction with domain group and users.
- Development and Unit Testing for the enhancements assigned.
- Doing RCA for the defects.
- Defect fixing and Code merging, Source control management.
- .NET application configuration on IIS 7.0 and SQL Server 2014
- Release Management
- Work with different team to fix the issue related to integration testing
- Continuous Integration using TFS
- Working with other stakeholders to communicate the progress of the work and attending daily status call to communicate the status.
Environment: VB.NET, C#, ASP.NET, SQL Server, IIS, TFS 2010, Crystal Report 11.5, WCF, Web Services, AngularJS
Confidential, New York
Sr. Technical Consultant
Responsibilities:
- Gathering Business requirements and organizing meetings with business users on a scheduled basis.
- Creating Technical Design Document
- Development and Unit Testing for the enhancements assigned.
- Implemented REST service using ASP.Net Web API
- Writing Stored Procedure and making changes to the existing stored procedures
- Coordination with Different team members to resolve the issue in the connected system
- Worked on developing application written in C#/ VB.NET and MVC 3.0.
- Designed & development of the new enhancements in Application written in Angular & Web API.
- Write Stored Procedure/Trigger and SQL Queries on Oracle 11 and SQL Server 2014
- Used Toad/PL-SQL Developer to write various Stored Procedures, Functions, Views and Triggers to implement business logic in Oracle database.
- Shoulder the responsibility of smooth rollover to production environment and provided post production support.
- Involved in issue logging/tracking, risk identifying/maintaining exercise with the team as required.
- Worked more than a year as build/release manager to manage various .NET Applications production releases.
- Doing RCA for the defects.
Environment: ASP.NET 4.5, ADO.NET, C#, VB.NET, MS-SQL, HTML, JavaScript, SSRS, MVC, Web API, Entity Framework, AngularJS & KnockoutJS, SQL Server 2012, Oracle 11g, Crystal Report, TFS, JQuery, WCF, Visual Studio 2010/2013/2015 , Windows 2012, IIS 7.0
Confidential, New York
Sr. Technical Consultant
Responsibilities:
- Requirements gathering & Analysis / Bug Triaging and Preparing Requirement Document
- Analysis and Estimation
- Code Review
- Developing and Enhancing Existing Web Services using C#
- Creating new Reports using Crystal Report 11.5 and modifying existing one
- Maintaining and Enhancing ASP.NET Application
- Used ADO.NET extensively for retrieving, querying and manipulating data in the database.
- Created Stored Procedures, Indexes, Views and Triggers using SQL Server 2014 & Oracle 11.
- Involved in unit and manual testing of the application.
- Unit Testing /Integration Testing and Preparation of Test Cases
- Vendor Coordination
- Involvement in Initial knowledge transfer and creating documentation to capture the knowledge
- Using GitHub for version control for managing source code and scripts.
- Onsite / Offshore Coordination
- Code Review
Environment: ASP.NET, C#, Web Services, WCF, SQL Server 2012, Oracle 11g.
Confidential, Atlanta
Lead Developer
Responsibilities:
- Requirements gathering & Analysis & Preparing Requirement Document
- Designed, developed and enhancing.NET application built on Framework 4.0
- Developing and Enhancing existing Web Services using C#
- Creating and modifying reports using Crystal Report 11.5
- Used ASP.NET Validation Controls and developed JavaScript to perform various Client side validations.
- Created Stored Procedures, Indexes, Views and Triggers using SQL Server 2008.
- Used Tortoise SVN for the source control, data collection, Reporting and Project tracking.
- Involved in unit and manual testing of the application.
- Analysis and Estimation
- Code Review
- Unit Testing /Integration Testing and Preparation of Test Cases
- Migrated Reports to SSRS Migration Work from Crystal Report
- Created new reports using SSRS
- Web Services development for Android Application
- Creating Adhoc Reports as requested by the customer
Environment: VB.NET, C#, ASP.NET, SQL Server 2008, IIS, TFS 2010, Unfuddle, Crystal Report 11.5, Flex, WCF,, Web Services, REST based on Service Stack, AngularJS, WebAPIs, Coldfusion 9.0, VS 2010, Kentico, Lotus Notes 6.0 SSRS, & SSIS
Confidential, New Jersey
Lead Developer
Responsibilities:
- Creating and Reviewing Test design docs for new enhancements and QFE and Hotfixes for the existing system
- Providing Production Support to the Applications
- Writing Stored Procedures, Triggers, Cursors and SQL Queries using SQL Server 2005
- Working on performance tuning of Stored Procedure being used in Reports
- Publish production release document and defects status report to Confidential stakeholders and HCL America Management.
- Bug fixing & development of new feature in Web based Application
- Regular Interaction with onsite and offshore team in resolving their problems
- Preparing and sending out the weekly status report to HCL manager.
- Review development work of the offshore team and ensure compliance with Confidential standards.
- Daily Feed Monitoring and addressing them with different stakeholders from different system
- Worked in Agile Methodologies
- Creating Technical Documentation and reviewing them with the client
- Used ADO.NET technology extensively for data retrieving, querying, storage and manipulation of interface screens developed using ASP.NET.
- Designed and developed WCF Web Service so that third party can consume data for reporting purpose
- Designed, Developed Web Forms using .Net Framework (C#, ASP.Net, ADO.Net), for the user interface (UI) with SQL as the Database.
- Worked on SSIS Package to import Data from Oracle to SQL Server 2005
Environment: ASP.NET, C#, VB.NET, VB 6.0, SQL Server, Oracle, IIS, TFS 2010, VSS 2005, Bugzilla, JIRA, Crystal Report 11.5,, Infragistics, Sheridan & Ultra Grid Controls, Text Box 14.0
Confidential, Seattle
Lead Developer
Responsibilities:
- Requirements gathering & analysis and Bug Triaging
- Analysis and Estimation
- Change Request/ Scope change analysis and impact
- Designed & development of C# & ASP.NET Application
- Providing Production Support for Web Based Application
- Modifying existing Stored Procedure and creating new Stored Procedure / Triggers & Cursors
- Creating Ad-hoc Report as requested by the client and present the data in Spreadsheet
- Mentoring the team
- Involved in internal audit of the project
- Weekly Status meeting with the client
- Build Management and Deployment on Windows and Solaris OS
- Code Review
- Unit Testing /Integration Testing and Preparation of Test Cases
Environment: C++, C#, ASP.NET, ASP, Solaris, Oracle 11g, SQL Server 2000, Perl, CVS, Windows XP / 2000, IIS, Bugzilla, Crystal Report 8.0, Visual Studio, TFS
Confidential
Lead Developer
Responsibilities:
- Team Lead.
- Mentoring team members.
- Development and Unit Testing of modules assigned.
- Doing RCA for the defects
Environment: C#, ASP.NET 2.0, Web Services, ADO.NET, SSRS, SSIS, Visual Studio 2008, SSRS, SSIS, SSMS, VSS