Quality Assurance Sales

SONU LAUL ARORA

*** ******* **, *******, **-***** 630-***-****

****.****@*****.***

APPLICATION DEVELOPMENT LEAD

Software Architecture, Design, Development & Implementation

Senior Application Developer experienced in implementing strategic IT

business applications for Fortune 500 companies across diverse industries.

Proven success delivering large scale multi-million-dollar technological

projects on time and under budget.

Systems Implementation Technical Support & Training Oracle-Siebel Vertical

Configuration Management Applications

System Development Life High Level Consultative

Strategic Planning & Cycle (SDLC) Skills

Execution System Support Research & Problem Solving

Coach, Mentor & Change Control Management

Motivator Analytical & Technical

Acumen

TECHNICAL SKILLS

Productivity Tools Perforce, Mercury Quality Center, Rational Suite (Clear case,

Clear quest), Siebel, Kana, Toad, UC4, Control-M, Siebel OBIEE

(Analytics)

Languages ColdFusion, Visual Basic, PL/SQL, SQL*Plus, Oracle report

writer, Oracle 2000, Java2.0, Perl Shell Scripts, HTML, VB

Script, RPG/400, SQL/400

GUI Oracle Reports, Oracle 2000

Application Servers WebLogic 5.1, WebLogic 6.0, Apache Tomcat

Operating Systems AIX, UNIX, Solaris, MSDOS, Windows 95, NT, 2000, XP, IBM

AS/400

Databases Oracle 8.0/8i/9i/10g, Informix 7.X, MS SQL 6.5/7.0/2000,

Sybase 10/11, MS Access 97/2000, DB2

Oracle-Siebel Sales Force Automation, Call Center, and Finance

Applications

PROFESSIONAL EXPERIENCE

JP Morgan Chase, Chicago IL

2001 - 2009

Development and Migration Lead (2005-2009)

. Successfully designed, developed and implemented configuration control

guidelines for Siebel/Siebel OBIEE system deployment.

. Designed and developed SharePoint for Siebel 7 Migration processes to

enforce configuration guidelines. Efficiently set up and created new

environments for Siebel 7.

. Designed and built several automated backend jobs to extract data from

one system and load it into another.

. In recognition of outstanding productivity, accuracy and performance,

selected by management to serve on the core transition team (among top 5%

of staff), converting Washington Mutual applications to JPMorgan.

. Provided responsive 24x7 Tier 2 Support on Application (during

implementation warranty period, provided Tier 1 Support). Troubleshot

and rapidly resolved issues encountered in application, minimizing down

time. Also troubleshot latency between Siebel, WebLogic and database by

fine tuning the application.

. Served as team lead in the management and coordination with offshore

development staff. Communicated effectively with both onshore and

offshore teams and fully leveraged offshore development model.

. Developed reusable templates and interfaced with application to

facilitate business user data gathering efforts.

. Functioned as point person for technical implementation of code releases

to production and pre-production environments and managed stability of

application after code change. Also ported entire application from

Solaris to AIX in collaboration with team.

Change Control, Configuration Management and Quality Assurance Lead (2003

-2005)

. Configuration Management - Successfully managed Siebel and WebLogic

deltas to Pre-Production and Production environments. Collaborated with

cross-functional teams to obtain requirements for setup of Pre-Production

environment.

. Led technical implementation meetings to ensure appropriate team

involvement as well as successful implementation of project releases.

. Provided Application/Software Support to Quality Assurance Labs.

Designed several innovative solutions to streamline software support

resulting in increased productivity.

SONU LAUL ARORA - Page 2

Change Control, Configuration Management and Quality Assurance Lead

Continued

. Served as single point of contact for all CRM Application migrations to

Production as well as Lead Administrator for Clear Case and Clear Quest

applications.

. Led change control meetings to analyze changes affecting Home Loan CRM

application. Ensured compliance with corporate change control policies

. As Test Director Administrator, implemented workflow and rules to

effectively support business processes.

. Managed Quality Assurance for Data Integrity projects involving

Informatica, PL/SQL, WebLogic.

. Facilitated work with external teams to obtain functional test data setup

in external systems; set up bulk test data in Siebel using Siebel EIM.

. Coached and mentored team members and new hires regarding test procedures

and processes resulting in a cohesive team approach as well as improved

productivity and performance.

Development Lead-Siebel CRM (2001-2003)

. Developed technical architecture, vision and approach for the CRM

Application to ensure high quality performance.

. Designed Interface Mappings to load CRM Data into Siebel for Home Loans

using Informatica and Siebel EIM. Provided responsive 24x7 Production

Support of Siebel CRM Application for Home Loans.

. Delivered WAMU's Home Loan, Customer Account data prior to the Go Live

Date. This effort entailed loading five million records into the

application, using Siebel EIM process, within 36 hours. Received

positive feedback from management for overcoming issues related to

conversion from Hogan to Siebel under stringent time frames.

. Facilitated business requirements, design and development in conjunction

with the cross-departmental business team, resulting in alignment between

business needs and functional requirements.

. Designed and Developed PL/SQL interface for data cleansing and messaging

efforts.

. Managed and mentored consulting resources from Accenture, ensuring

application was developed to meet requirements.

. Analyzed and recommended backend database tuning to improve application

performance. Presented recommendation to senior management.

Technical Consulting Assignments - Iormyx Inc., Chicago, IL

1997 - 2001

CRM Consultant - Staples, MA - (Environment: Siebel Call Center, Enterprise

Integration Manager, Oracle 8.1.6)

. Implemented a Sales Management System using Siebel Sales Enterprise.

. Uploaded data into the Sales system from comma separated files using

Enterprise Integration Manager.

. Implemented marketing campaigns and events. Created and maintained Sales

Teams, Sales Reps, Territories and Territory Assignments. Incorporated

lead tracking, opportunities, fulfillment and rollups in sales

forecasting.

. Set up server tasks for Assignment Manager, Siebel Remote (DB Extract,

Transaction Processor/Router/Merger) and Email Manager.

CRM Consultant - Cbeyond Communications, GA

(Environment: Siebel 2000 eCommunications, Oracle 8.1.6, Windows NT,

Vitria 3.0 Daleen)

. Performed the installation, configuration management, user acceptance

tests, troubleshooting internal workflow and external integration from/to

Siebel. This involved 24x7 support, refining the migration plan, planning

for newer repository deployment and managing change control process.

CRM Consultant - United Stationers, IL - (Environment: Siebel 2000 Call

Center, Oracle 8.0, Windows NT)

. Developed a data mapping documentation, presenting the interface between

the Siebel 2000 Call Center interface tables and the client's existing

legacy database system.

. Migrated legacy data such as Accounts, Contacts, Orders, Products, and

Tracking into Siebel using EIM to pre-production and production

environments. Prepared EIM script to import data, export data, and

delete data to/from Siebel.

. Automated and documented data load process for client. Mentored client

team members to support application.

. Wrote fix programs in Siebel VB as a work around for some of the defects

found in Siebel 2000 application.

CRM Consultant - Applied Signal Technologies, CA - (Environment: Siebel

Workgroup '99, Oracle 8.0, Windows NT)

. Performed installation, configuration management and user acceptance

tests for Siebel Workgroup for Sales.

. Uploaded data into Siebel Workgroup from comma separated files using

PL/SQL and Enterprise Integration Manager.

. Created and maintained data for Sales Teams. Analyzed the organizational

structure and assigned positions to employees. Migrated legacy data such

as Accounts, Contacts, Campaigns, Literature and Activities into Siebel

using EIM.

SONU LAUL ARORA - Page 3

CRM Consultant - EBA Systems, CA

(Environment: Siebel Sales Enterprise 99.5, Cold Fusion 4.0, Visual Basic

6.0, SQL Server 7.0, Windows NT 4.0, Palm OS, Palm VII PQA)

. Implemented the technology necessary to access Siebel through wireless

connection. Developed VB/COM Wrapper Classes for communication between

web application servers and Siebel COM components using VB.

. Developed web application server code using Cold Fusion as well as web

front end code for Palm VII wireless functionality using HTML3.2

Software Consultant - College of American Pathologists, IL

(Environment: Windows NT4, HP9000 K200 (HP UNIX), Informix 7, Informix 7.3,

PowerBuilder 5.0, PowerBuilder 6.5)

. Involved in the complete lifecycle of the application including

Requirements Analysis, Design, Development, Testing and Integration

phases.

. Created external and functional design documents based on requirements

and specifications.

. Developed final product from screen prototypes to final cut as well as

Batch Reports Ancestor and related documentation for training.

. Prepared test plans, test data for testing (system, user acceptance and

volume/parallel).

. Designed and set up production implementation and deployment procedures.

Performed Bug-Fixing, Enhancement Request implementations, Performance

Tuning and Code Optimization.

. Developed Custom Data Load Tool to load data into Informix TEXT/BLOB

fields. Provided Production Support and Application Maintenance.

. Performed Y2K Testing and Certification Procedures.

EDUCATION AND TRAINING

Manipal Institute of Technology

Manipal, India

Bachelor of Engineering -Computer Science

Training

. Web Development by Infomatrix Inc (Html, Java, JavaScript, Applets,

Servlets, JDBC, RMI, Corba, XML)

. Java Designing by SUN Systems (UML, Modeling)

. Java Programming by SUN Systems (Java API, Swing)

. Siebel 7.7 Essentials by Oracle (Siebel)

. Siebel 7.7 Administration by Oracle (Siebel)

. BEA Weblogic: 5.1: Advanced System Administration

. BEA Weblogic: J2EE Programming with Servlets and JSPs

. Clearcase Administrator

. Oracle 8, Developer & Designer 2000

ADDITIONAL INFORMATION

. US Citizen

Contact this candidate