We provide IT Staff Augmentation Services!

Lead Pl/sql Developer, .net Developer Resume

SUMMARY

  • Experience in Designing, Development and Deployment of High - Performance, Scalable, Distributed, ASP.NET Applications with Oracle as backend.
  • Understanding & mapping client’s requirements / enhancements to the product and providing technical solutions. Strong Knowledge in all phases of Software Development Life Cycle including analysis, design, coding, testing, implementation and maintenance.
  • Experience in Product Development in Agile Scrum and Waterfall software development methodologies
  • Domain experience - Insurance - Mobile Device Protection, Insurance - Fire/Earthquake/Hurricane/Flood Catastrophe risk management & Banking and Financial Service
  • Experience in Microsoft.NET Framework 4.0(or earlier) and Microsoft Visual Studio 2019(or earlier).
  • Excellent and working knowledge in ASP.Net using VB.Net, WCF service using C#, Micro Services on Azure Service Fabric platform
  • Excellent working knowledge of Oracle PL/SQL development which includes creating Database Tables, indexes and triggers, writing oracle package and procedures, Functions, Cursors, Views and performance tuning.
  • Experience in creating Unit testing for the developed modules using Mocking Framework Moq in C#
  • Experience on Change & Configuration Management, Release Management of applications in database, client/server and Web/Internet environments under windows platforms.
  • Excellent working knowledge of Team Foundation Server (TFS 2012 or earlier) and Git for source repository/release management activities. Worked with ALM tool TFS 2012 and Azure DevOps for version control, reporting, requirements management, automated builds and release management capabilities.
  • Experience in creating automatic Build and deployment scripts, Branching, Merging, Security, maintaining the version control, creating and maintaining build definitions and continuous integration.
  • Proficient Automated build and deployment into Dev, Test environments by customized process template.
  • Experience in Releasing schedules, communicating the Release status, created Roll out Plans, tracked the Project Milestones, prepared the reports and chaired the Release calls and worked for a successful Release.

TECHNICAL SKILLS

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

Web Technologies: ASP.NET 4.0 and earlier, Web services and WCF service

Scripting Languages: JavaScript

Database: Oracle 12c or earlier

Unit Testing: Moq Mocking Framework

Development Tools: Visual Studio 2019, PL/SQL Developer, SQL Developer

Code Analysis Tool: ReSharper

Build Tools: Azure DevOps, TFS 2015 MS build

SCM Tools: Git, TFS 2015

Deployment Tool: Octopus, PowerShell scripting, NuGet packages

Requirement/Bug Tracking Tool: Jira, Azure DevOps, TFS

Change Management Tool: Service Now, Cherwell Service Management

Operating Systems: MS Windows 10 Enterprise

Web Server: IIS 10.0 or earlier

PROFESSIONAL EXPERIENCE

Confidential

Lead PL/SQL Developer, .Net Developer

Responsibilities:

  • Involved in the Agile development/enhancement of the application as lead developer.
  • Looked into the project development, requirement refinement, development, bug fixes and code review. Had been accountable in communicating with Product Owner and Stakeholders on the sprint/project milestones. Assist business & clients as an SME to map the requirement with the system features.
  • Create technical design documentation for the user stories and share it with team/product owner, architecture team and production support team.
  • In addition to user story development, assist other developers in their development and troubleshooting.
  • Oracle PL/SQL development which includes creating Database Tables, indexes and triggers, writing oracle package and procedures, Functions, Cursors, Views and performance tuning. Load flat file data for policy enrollment and claim into ELITA oracle database using SQL loader/ TransAll / File mapping.
  • ELITA UI Web Form development in ASP.Net using VB.Net
  • Develop/enhance WCF Service using C# and unit test using Moq mocking framework for Assurant client portal/ dealer portal.
  • Develop/enhance Micro Services on Azure Service Fabric platform
  • Provide on-call support and providing end to end Application Support.
  • Track all teams release deliverables and dependencies to ensure we can create release candidate builds and ship on time.
  • Visible role with daily contact with internal customers and a lot of good team collaboration.
  • Created and Implemented branching and merging strategy with multiple branches.
  • Developing and maintaining the build environment, the source code control system and managing build packages using TFS.
  • Performed build and deployment activities across multiple environments - Testing and UAT environments.
  • Worked on Setting up UAT, Staging and Production environments and created deployment scripts according to the requirement.
  • Developed and maintained the release schedule for all development teams and ensured alignment across key partners.
  • Tracked and communicated release issues, risks, schedule, activities and status.
  • Produced production deployment plan and coordinated with support resources.
  • Managed release deployment communications (plan, status, issues).

Environment: Windows 10 Enterprise, IIS 10.0, Oracle 12c

Confidential

Team lead, Onsite coordinator

Responsibilities:

  • Interact with multiple teams to schedule and execute migration of around 60000 bank users in 3 phases.
  • Provide on-call support and assist business & clients as an SME.
  • Create Migration game plans, project journals and maintain issues list for each phase of user migration.
  • Lead and execute the production changes during weekends by following proper change management process - Change Control Ticket.
  • Guide team in automating existing user data verification prior to user migration in new system using T-SQL.
  • Interact with offshore team to distribute work and mentor them.
  • Handle any production issues via incident management and inform all stakeholders about it
  • Design, Test Case Review and share the feedback with the team.
  • Lead the team in the testing phases, build review, UAT support and production support

Development Environment: SQL Server 2005 management Studio, Visual Studio 2005

Hire Now