Sql Server Development

Professional Summary

Professional Roles Major Industries Technology Areas

Played served Served

Software Solutions 3 Banking & 4 SOA and BPM 4

Design Insurance

Technology 1 Trading and 3 Web and Shared 4

Leadership Logistics Services

Applications 5 Basic Materials 2 Client/Server 1

Development Applications

. Over 9 years of professional experience in software Analysis, Design,

Development and Implementation of which over 3 years experience as a

senior PRPC System Architect.

. Number of years of experience by role, industry and technology areas

is listed below.

. Experience involves hands-on Web, SOA, BPM, and BRE applications

architecture, design, development, and implementation using PRPC 5.x,

Java/J2EE (JDBC, Servlets, JSP, Swing, Struts, Hibernate, XML Web

Services) technologies.

. Extensive experience in Design, Development, and Deployment of PRPC

(Pega RULES Process Commander) and Java/J2EE applications for

Financials, Manufacturing, and Insurance industries.

. Experience in implementing, customizing, and extending PRPC Solution

Frameworks such as Smart Investigate, Customer Process Manager (CPM),

Sales and Process Management (SPM), Automated Claims Repair, and

Claims WorkStation.

. Expert with object-oriented design and modeling using UML design

methodologies, design patterns in Java and Frame Works like Jakarta

Struts and Hibernate.

. Expertise in developing rich GUI interfaces, Java Server Side

Programs, and e-Commerce applications using Swing, JSP, Servlets, and

JDBC.

. Expertise in developing web applications using JSP and Custom Tag

Library components.

. Expertise in developing data access components using JDBC for Oracle

and SQL Server.

. Expertise in deployment and configuration of BEA WebLogic Application

Server 6.1/8.X/9.X.

. Working knowledge of GUI/IDE tools like Eclipse, WSAD 5.1.2 and RAD.

. Experience of Use Cases, Sequence Diagram, and Class Diagrams using

UML and Rational Rose.

. Exposure and working knowledge of Web Services using JAXP, WSDL, and

AXIS.

. Very good team player with excellent interpersonal, analytical,

presentation, and leadership skills.

. Highly scalable in managing large scale assignments in heavily

diversified team environments.

Technical Skills

BPM Software Languages

PRPC v5.x/v4.x, CPM, SPM, Java, C, C++, SQL & PL/SQL,

CPMHC, Smart Investigate (SI) UML, XML, HTML, DHTML, XHTML

Internet/Intranet Development Development Tools

J2EE, Servlets, JSP, JDBC, RAD, WSAD, Eclipse, Dream

Swing, AWT, JNDI, HTML, XML, Weaver, XML Spy, Rational Rose

DTD,XSL, DOM,SAX, JAXP, XML4J, 2002, VISIO, TOAD, Apache ANT,

Log4J, JavaScript, XSLT PRPC Rule Set Versioning

Web & Application Servers Databases

WebLogic 9.X/8.X, WebSphere SQL Server 2000/2005, Oracle

5.x, Tomcat 9i/10g, DB2

Operating Systems Development Frameworks

Windows 2000/2003, UNIX Jakarta Struts, Spring,

Hibernate, MVC

Educational Qualifications

. Bachelor of Engineering from Andhra University, Visakhapatnam, India

. Advanced Diploma In Software Applications from VJ Info, Visakhapatnam,

India

Professional Certifications

. PEGA Certified System Architect v5.x

. Certified in Object Oriented Analysis and Design and Advanced Modeling

using UML

. Certified in Oracle 8i Database Programming

Professional Experience

JP Morgan Chase (JPMC) - Wilmington, DE, USA July 2006 - Till date

Joined JPMC as a senior PRPC Consultant to provide Design and development

services to various Middleware Integration and Business Process Management

solutions across the company. Primary responsibilities included but not

limited to gathering functional requirements, messaging specifications,

identify end-point mappings and integration points, business process

analysis and process modeling, documenting architecture patterns, technical

implementation procedures, modeling technical deployments using Object

Oriented Analysis and Design methodologies, installing PRPC software in

different environments and configuring the server farms for optimal

performance, providing third-level technical support as an SME to mission

critical business applications, plan the configuration of different

application environments for high availability, define strategies for the

distribution of application packages to the different environments

following a scaled out implementation approach, work with different

development and support groups to accelerate the overall implementation of

the solutions.

. Designed, developed, and implemented projects like Entitlements, EMEA

Acceleration, USD Clearing, FlexApp, DynApp using PRPC and Java

technologies in BPM and SOA platforms.

. Interacted continuously with the different stakeholders, business

analysts to gather, review, and analyze the functional business

requirements

. Worked with different cross functional integration teams to gather

messaging specifications, integration requirements for various

services and connectors

. Prepared functional, technical design, exception handling,

correspondence and attachment, implementation, deployment, and

migration specifications

. Analyzed functional business requirements, data mapping requirements

and designed the solution

. Identified data classes and integration points, end-point mappings and

designed organization structure, rule set hierarchy, and class

structures

. Developed the solution using out-of-the-box features and extended the

functionality by developing reusable components and scripts in

compliance with Pega Framework

. Built initial application including Application Rule, Rule Sets,

Classes, Access and Class Group

. Defined Classes, Properties, Validation rules, Field values, and HTML

Properties

. Configured models for data initialization, Code Activities, Decision

and Declarative rules, correspondence rules and attachments

. Developed flow rules to implement the business process including

Assignments, Routing, Tickets, Flow Actions, Connectors, Notification,

Screen Flows, Data Flows, Fork and Decision

. Analyzed schema definitions, configured SQL, Java, and SOAP

connectors, customized activities to map request/response parameters

and handled exceptions

. Configured and customized Service File rules, setup file listeners,

portal rules, binary file rules, exposed reporting fields, and created

list view / summary view rules

. Developed activities, Decision Rules (When condition Rules, Decision

Tree Rules, Decision Table Rules and Map Value Rules), Declarative

Expressions, and work classes as per the requirements

. Involved in configuring the agents to perform the background

processing

. Built XML parse rules to load and parse inbound/outbound files and

configured eForm File and Map rules, Designed and mapped PDF Forms and

generate PDF files

. Created a project in QualityCenter and developed test cases and

executed them using Tracer, break points, different trace options, and

tested rules like UI Harness, Sections, using Rules Inspector

. Tested service/connector activities by feeding payloads manually, and

by manipulating clipboard pages and creating tester activities

. Installed and configured PRPC in different environments and migrated

Pega solutions, and performed system management application tasks for

various Pega applications

. Administration, configuration and maintenance of agents, listeners,

requestors and logging

. Define Access Roles, Privileges, Access of Role to Object rules

. Maintain Rule Sets and Rule Set Versions and Define Operators,

database table instances

. Use Pega PAL tool to analyze the performance and tune the solution as

per the Pega recommended Performance guidelines

. Worked with the network engineering team to build the different test

and production environments, complying with enterprise standards, to

meet the operational needs of the BPM platform.

. Optimize the network, application databases, and BPM solutions

configuration to improve scalability of the solutions to withstand

demanding transaction volumes.

. As BPM technologist in the IS team, mentored different business,

development, and stakeholders with best practices and applying them in

developing and supporting quality solutions.

. Participate in design discussions and provide architectural

feasibility reports to the management team to make appropriate

decisions in implementing quality and sustainable solutions.

. Develop POCs to present different approaches for scalable

implementation of the BPM solutions.

Environment: PEGA PRPC v4.x/5.x, Smart Investigate (SI), CPM, SPM,

WebSphere, WebSphere MQ, Oracle, JavaScript, Java, SQL and PL/SQL, EJB,

XML, Web Services, JDBC, AJAX, TCP/IP, SOAP.

Trade Exchange (www.tradexchange.gov.sg), Singapore November 2004 -

June 2006

As a Systems Analyst to provide development, design, and testing services

for various integrated solutions to wide network of clients in Singapore.

Primary responsibilities included but not limited to requirements analysis

and modeling, documenting technical and functional procedures, modeling the

technical deployments using Object Oriented Analysis and Design

methodologies, configuring different test and production server farms and

coordinating migrations to these environments, and providing third-level

post production technical support to mission critical business

applications. Technically lead the project development and deployment

efforts to ensure quality implementation.

. Interacted continuously with the different business analysts and

stakeholders to gather, review, and document the functional business

requirements

. Developed and implemented methods for improving processes for the

rapid prototyping and evaluation of new technologies, products and

standards.

. Researched for technologies specific to a problem space, evaluated

technical architecture, and created reports based on that research and

evaluation and recommended direction to both the development group and

the business units.

. As a web technologist, played major roles in full cycle of the

projects from initiation thru implementation and worked with the

project management team to help drive the project costs, deployment

timelines, and change management processes.

. Developed various reusable components and solutions, development and

deployment frameworks, which can be used as base standards by

different applications development groups.

. Developed POCs and demos to present the capabilities of SOA platform

to the different teams.

. Prepared functional, technical implementation, deployment, and

migration specifications

. Developed web service interfaces to call the Business Server RPC to

read the solicitation information from the ACAPS mainframe and used

Hibernate mappings for data mapping and parsing

. Redesigned the Application Abandonment process and developed robust

exit intercept processes to reduce the application abandonment rate -

thereby increasing the apply rate

. Designed and developed middleware integration services to enhance the

solution to interface with a new backend system using Swing, SOAP, and

Apache Axis on Spring framework

. Developed custom pricing solutions using XML, Schemas and J2EE to

offer Risk Based Pricing through CIG for Instant Applications to

facilitate acquisition of incremental accounts

. Redesigned the validation framework using open source JavaScript

engine "Rhino" to extend client side as well as server side validation

of rules and policies

. Developed user interfaces and parsing solutions for creating

applications automatically based on the requirements specified in

excel batch feeds

. Designed the different application modules using UML and Rational Rose

and designed artifacts including use cases, class diagrams, and

sequence diagrams

. Designed the presentation layer components with HTML, JSP and Style

Sheets and developed the server side components and business logic

using J2EE

. Configured WebLogic Application Server 6.3 and 8.1 and coordinated the

application deployments to different test and production server farms

. Developed Data Access Layer services using Java and Hibernate mappings

to implement the Oracle 9i database access functions in the solution

. Developed test plans and test cases and executed the different cycles

of tests and documented the test results, and test metrics

. Provided third-level post production technical support services and

handled the cases using monitoring and tracking solutions on an on-

call basis

. Managed the development, implementation, and administration of various

research standards, and monitored the conformance of those standards

throughout SDLC.

. Coordinated the technical implementations of the entire solution to

ensure quality deployments and deliverables to the operations/support

team.

Environment: WebLogic, WebSphere, Oracle, JavaScript, Java, J2EE, JAXP,

JSP, SQL and PL/SQL, EJB, XML, Web Services, JDBC, AJAX, SOAP.

iVector Technologies - Bangalore, KT, India February 2001 - October 2004

Joined iVector Technologies, an Independent Software Testing, Validation &

Verification (V&V), and Quality Assurance (QA) Services Company, as a

Software Engineer to provide development, design and testing services to

various integrated solutions to clients in USA and Middle East. Primary

responsibilities included but not limited to gathering requirements,

documenting technical and functional procedures, preparing test cases and

executing different cycles of tests, documenting deployment procedures,

migrating code to different test and production environments and providing

post production support to critical applications.

. Worked with business leads and process owners to gather and document

mapping requirements and developed data mappings to transform legacy

data into standards compliant transactions.

. Architected and implemented the debatching architecture to improve the

performance of the high volume transaction processing in a clustered

environment.

. Developed a deployment framework to migrate solutions to different

test and production systems.

. Designed the services to improve the productivity of status

notifications to partners and interchange processing notifications to

business customers.

. Successfully migrated application from WebLogic Server 6.1 SP3 to

WebLogic Server 8.2 SP3

. Designed and developed web based applications using JSP, Java,CVS,

Eclipse, Oracle 8i, and server side components using Java Servlets

. Developed middleware components for automatic transaction support,

data integrity, and protection

. Designed flowchart and data flow diagrams, and specifications,

processing functions of the system

. Designed rich user-centric user interface screens using JSP, Java,

HTML and JavaScript

. Developed JSP pages and Servlets for server side interaction and

developed JavaScript routines for validating the different form fields

on the client side

. Utilized CVS for code management, source code control, and version

control

. Developed Web Forms using HTML, JSP, and JavaScript and business layer

components using Java

. Developed RPC components using CORBA and Java patterns and utilized

JDBC classes to access the Oracle and SQL Server databases

. Developed stored procedures, SQL queries, properties, methods,

functions using T-SQL

. Performed Unit and Integration Tests to deploy defect free code to

production environment

. Developed reusable service contracts and web service interfaces and

introduced SOA to extend the services to disconnected partner network.

. Designed the entire development and production deployment platforms

and developed reusable deployment scripts to automate the solution

deployments to cluster environment.

. Developed database maintenance plans to maintain and administer the

databases in a clustered SQL Server environment.

Environment: WebLogic, WebSphere, Oracle, SQL Server, JavaScript, Java,

J2EE, JSP, JAXP, SQL and PL/SQL, EJB, XML, Web Services, JDBC, AJAX, SOAP.

references

Available upon request

Contact this candidate