Software Development Sql Server

Veera Reddy Nandikanti

415-***-**** ️ ***************@*****.***

A results-driven IT professional and technocrat with 15+ years of experience in solution development across Banking, Healthcare, Logistics, and HR domains. Proven expertise in the Software Development Life Cycle (SDLC), including design, implementation, and support of enterprise applications. Strong background in business process and workflow design, leveraging industry best practices.

Proficient in BPM technologies such as Appian, Pega, and Kofax Total Agility (KTA), along with modern Java Spring Boot and Microsoft technologies including C#.NET and ASP.NET. Well-versed in relational databases, with hands-on experience in SQL Server and Oracle.

Education

EDUCATION

·Master of Computer Applications from Osmania University, Hyderabad with Distinction

·PGD-M I S & Computer Applications from Osmania University, Hyderabad with First Division

CERTIFICATION:

·Appian - Appian Certified Lead Developer

·CSA - Certified System Architect (PEGA)

·MCP - Developing and Implementing Web Applications with Microsoft Visual C#.NET and

Microsoft Visual Studio.NET.

Competence

Proficiencies

·Core Proficiency in all phases of Software Development Life Cycle, BPM Technology (Appian 22.2, Pega, Kofax Total Agility), MS.NET Technologies and Database Design on MS SQL Server, Strong Exposure to OOPS, Business Process Modeling, Work Flow Automation Design and Optimization, Agile Development Methodology

·Skilled in Appian SAIL interfaces, Process Models, Expression Rules, Integrations, Web APIs, Record Types, Reports, and application deployments. Experienced with Query Entity, Query Record Type, Timers, Group and Document Management, and User Management. Familiar with modern features like Sync Records, Record Relationships, Data Fabric, DevOps deployments, and Appian RPA.

·Special proficiency includes technical knowledge of Business Process Management (Appian, Pega, Kofax Total Agility), MS.NET Technology, MS SQL Server, SQL Server Integration Services (SSIS), Oracle

·Extensive experience of all phases of Software Development Life Cycle, including Analysis & Study of Business Requirements, Technical & Functional Specifications, Data/Interface/Process Design, Module/Interface Development, Testing, Integration, Implementation along with Service Support

·Adept at Application Support through Study and Analysis of Production environment of Application; Root cause Analysis & Identification of Cause of failure; Revised Work Flow Design; Change Management (Revised Work Flow); Testing and Release Management; Monitoring of Application

·Cohesive Team Player with Fast Learning Curve along with strong analytical, problem solving, innovation, planning, organizational, communication & interpersonal skills

Technical Skills

·Technology: BPM

·Tools: BPM (Appian, Pega, Kofax Total Agility, Cordys), Instabase, SpringCM (DocuSign CLM), Java Spring Boot, JIRA, Confluence, Postman, Apigee, Bitbucket, SOAP UI, HTML, JavaScript, Microsoft .NET Technologies

·Database: MS SQL Server and Oracle

·Operating System: Windows, Linux

·Business Domains: Banking, Insurance, Healthcare, Logistics, HR

·Methodologies: Agile, Waterfall

Project Summary

Participated/Led several projects involving Banking, HR, Insurance, Healthcare and Logistics domain applications, in terms of Design, Development, Application Support and enhancement and the following project is a snap shot of most recent experience:

Project

Lending - PLP

Client

JP Morgan Chase / First Republic Bank (FRB), California-USA

Duration

Mar-2015 to till date

Environment

BPM Appian, SQL Server, Instabase and SpringCM

Description

Lending project is part of Flightpath program of the bank. As part of this program bank has defined goals to make enhancements to the existing processes using Appian BPM product to add more functionalities to the existing flows. To name few projects which fall under this are Professional Lending Program (PLP), Loan Client Onboarding, Eagle All-In-One (SLR), Advance posting process and Red Flags automations etc. Few functionalities covered as part of this is origination, underwriting, decisioning and Funding & Booking of the loan to AFS system. It also follows the Reg B compliance which tracks different clocks and updates the overall Reg B status.

This project objective is to put in place an enterprise workflow application program. The goal of this project is to ensure all the identified legacy processes are automated although the scope includes a longer-term strategic direction to build the platform.

Role

Appian Lead Developer / Project Lead

Responsibilities

·Design, develop, modify, integrate, test, deploy and support enterprise-level Appian based BPM applications.

·Translate business process software requirement specifications into Appian process model prototypes and solutions.

·Engage with enterprise architects on design collaboration and review to ensure Appian solutions align with enterprise initiatives. Also ensure the implementation is consistent with design decisions, standards and best practices

·Ensure solution is unit tested for every new functionality and also provide guidance to the QA team on testing approach and scenarios for Appian applications

·Assist with gathering functional requirements and provide technical input for technical system requirements

·Responsible for review and guidance of project teams in the areas of Appian BPM Solution design, Process modeling, Solution development, System and Application integration approaches, Deployment and Optimization.

·Responsible for Handling production support tickets, monitoring alerts and experience in inflight modification of Process instances.

·Serve as a technical lead and mentor other Appian developers on best practices. Provide technical support or leadership in the development and continual improvement of service

·Conduct and participate in detailed design reviews and validate that the design follows the approved architecture

Please refer to the Annexure for other Project Details

Career Profile

Mphasis Corporation, California

Senior Appian Lead Developer

Joined the organization as Associate Software Engineer and progressed to the designation of Project Manager and leading the several team members along with hands-on Appian design and development.

Responsibilities:

·Primarily leading the team in design and module development activities across projects.

·Managing requirement analysis, technical design, and development execution.

·Serving as the primary point of communication with support groups during project lifecycle.

·Leading the design and implementation of Appian workflows, and system integrations.

·Handling routine team administration tasks including task assignment, tracking, and progress monitoring.

·Conducting regular sprint demos to business users to gather feedback and ensure alignment with requirements.

ANNEXURE

PROJECT DETAILS

Project: Appian PWM Client: First Republic Bank

Role: Sr. Developer/Team Lead Duration: May 2014 – Feb 2015 Environment: Appian, SQL Server

Designed and developed Appian workflows for onboarding high-net-worth clients.

·Integrated with CRM, DocuSign, and Content Management Systems for seamless client data handling and e-signatures.

·Led unit testing, reusable component development, and defect resolution.

Project: ACE (Advanced Case Engine) – SWISS Client: Charles Schwab

Role: Sr. Developer Duration: Oct 2013 – Apr 2014 Environment: Pega BPM

Built case management workflows for Cashiering and Account Maintenance departments.

Developed reusable components and participated in requirement analysis and design discussions.

Project: Business Process Suite (BPS) Client: Internal Project at Mphasis

Role: Sr. Developer Duration: Jun 2009 – Sep 2013 Environment: Kofax KTA, ASP.NET, SQL Server, Oracle

Developed BPM-based HR automation modules (Employee Onboarding, Transfer, BV, Position Creation).

Actively engaged in Agile development, requirement analysis, design mockups, and production support.

Project: FXRS and GSM Client: FedEx

Role: Sr. Developer Duration: May 2008 – Apr 2009 Environment: C#, Sybase, Windows

Developed remote server applications for shipment order processing and synchronization with FedEx central servers.

Designed and implemented service-oriented solutions supporting global shipping management.

Project: FSMX Development Client: FedEx

Role: Developer Duration: May 2007 – Apr 2008 Environment: ASP.NET, C#, JavaScript, SQL Server

Contributed to development and integration of FedEx Enterprise Solutions suite for web and smart client applications.

Participated in analysis, design, and bug fixing.

Project: AT&T Enrollment Process Client: AT&T

Role: Developer Duration: Feb 2007 – Apr 2007 Environment: ASP.NET, VB.NET, JavaScript

Developed enrollment modules for recurring payments in compliance with PCI standards.

Designed and implemented secure account and payment information storage processes.

Project: CAHIMS (Hospital Management System) Client: Columbia Asia Hospitals

Role: Developer Duration: Aug 2006 – Jan 2007 Environment: ASP.NET, VB.NET, Crystal Reports, SQL Server

Developed modules for hospital information management and patient data access.

Built reusable user controls and created reports using Crystal Reports.

Contact this candidate