Summary:

** ***** ** ************ ********** in building and testing of Enterprise applications in US.

Technical manager with 15 plus years of Oracle database design, data architecture and QA experience.

Expertise in project management, planning and implementation.

Expertise in functional analysis and data modeling

Expertise in building J2EE Enterprise applications for financial, medical, automobile, insurance, telemarketing, production planning, MRP II and human resources management industries

Very strong programming skills in SQL, ANSI SQL, PL/SQL, Oracle database packages, database procedures, triggers, Oracle Designer, SQL*Loader, Data Pump and Data Base Administration tools

Expertise in high transaction database modeling, design and development

Expertise in MySQL, Teradata and ETL Tools (Data Stage and INFORMATICA)

Expertise in Data Base Administration, Table Partitions, Pipe line and Parallel Table functions

Experience in complete software development life cycle (SDLC) and software maintenance

Very strong programming skills in Java, Servlets, JDBC, JSP, HTML and JavaScript

Very strong programming skills in EJB, J2EE, Struts framework and Spring MVC

Expertise in building Oracle ERP/Financial applications

Expertise in developing unit test cases, integration testing, performance testing and Quality Assurance

Expertise in destructive testing and gap analysis

Very Strong in tools - MS Word, Visio, Excel, Power point and HP ALM

Strong experience in SCRUM- AGILE

Educational Qualification:

Bachelor of Technology BS (8 semesters full time program )

Masters in Design MS (4 semesters Full Time program)

Technical Skills:

Oracle Data Base Server (12c/11g/10g/9i/8i/7/6), SQL, ANSI SQL, PL/SQL (All versions), Oracle designer 2000/6i/11g, Oracle Forms, Oracle Reports, Oracle Discoverer, Oracle SQL developer 3.x, TOAD, SQL Navigator, HP ERWIN, HP ALM, Oracle JDeveloper, MySQL, Teradata, ETL Tools, Data Stage 8.x,9.x, INFORMATICA 6.x, Java2, Java 5 and 6, HTML, XML, UML, Java Script, JSP, Servlets, EJB 2.x, DTD, XSD, XSLT, AJAX Struts Frame Work, Apache Tiles, Spring Frame Work, Apache Commons, Java Server Faces, Hibernate, Design Patterns, Maven, JMS, Hudson, SOAP, WSDL, JAXB, JUnit, Eclipse 3.x,RAD6.x/7.x/8.x WSAD5.x, Change Man, PVCS, Visual Source Safe, Clear Case, IBM Web Sphere (6.x/ 7.x) BEA Web Logic (8.x/9.x,10.x), Tomcat, J Run, File net, SSL Encryption,RSA, Visio, Power Point, MS Project, MS Office products Oracle Designer, Developer, Forms, Reports, SQL*Loader, Data Pump,, Oracle Financials 10.7, 11i, Business Objects, Crystal Enterprise XI, Rational Rose, MS Windows (95/98, NT/XP/Vista/7/10.x), Unix (HP-UX, Sun Solaris & AIX and Shell scripts

Status: US Citizen

Professional Experience:

JP Morgan Chase – Dallas

June 2015 – To Date

Project Manager/ QA Lead, Team Size 24

Responsibilities

Leads the planning, implementation and testing of multiple advanced level IT projects.

Participates in facilitating the definition of project scope, goals and deliverables of routine projects.

Participates in developing project tasks and resource requirements.

Demonstrates competence around the areas of product knowledge, relationship building, professionalism and personal excellence, leadership, people focus, and business development.

Develops more junior project management staff by mentoring and training.

Advanced level project management, meeting agreed to completion dates, and delivery of the desired results for multiple, parallel projects.

Good written and verbal communication skills.

Develop testing strategies, unit test case, integration testing and perform gap analysis

Knowledge of both theoretical and practical aspects of project management.

Use HP ALM to perform requirement analysis, test planning, functional testing, defect management and production support

Knowledge of project management techniques and tools. Proven experience in leading project teams.

Perform the responsibilities of SCRUM master. Fill in for product manager.

Northern Trust – Chicago IL

August 2014 – May 2015

Data Architect/ QA Lead, Team Size 15

Responsibilities

Perform data modeling and analysis for NT Compliance Analyst and Liquidity applications.

Work with business stake holders and business analysts to create conceptual and logical design.

Participates in facilitating the definition of project scope, goals and project deliverables.

Created detailed design for new projects. Generate DDL, DML, DCL scripts.

Created design artifacts and documentation (ERD, DFDs, Sequence diagrams, Class Diagrams…)

Design and create database tables with partitions to store billions of rows.

Code and Test several database packages with several stored procedures and functions.

Develop and test Data Stage (ETL) Jobs to extract data into data repository and Oracle database from upstream systems.

Written a number of shell scripts to automate data extraction from several upstream systems Bloomberg, AIP, NDR and OTC DataMart

Worked on project automation using Control M scheduler.

Write and optimize several SQL queries and database views for batch processing.

WebLogic 10.x administration tasks. Guide QA team to test the software components developed.

Active involvement in unit testing, integration testing, feature testing and regression testing.

Use HP ALM to perform requirement analysis, test planning, functional testing, defect management and production support

Citi Bank (Credit Card Division), Elk Grove Village (Chicago IL)

June 2012 – July 2014

Technical Lead/ Data Architect, Team Size 21

Responsibilities

Perform data modeling and analysis for a 4 Terabytes data model.

Created database design with integrity constraints and triggers.

Created design artifacts and documentation.

Work with business stake holders and business analysts to create credit models

Design and create database tables with partitions to store billions of rows.

Database administration on DEV and QA instances.

Developed several database packages with dozens of stored procedures and functions in them.

Written several SQL*Loader script to migrate data from legacy databases.

Written a number of shell scripts to automate data loads from CSV files.

Write and optimize hundreds of SQL queries and database views for Java/J2EE UI interface.

Imported data from SAS (Statistical Analysis System) to oracle tables.

Develop technical detail design for all the major tasks.

Assign tasks to team members onsite/offshore and monitor status till completion.

Conduct project status and follow-up meetings and discussions.

IBM application server WebSphere 7.x administration tasks

Perform root cause failure analysis and recommend resolutions.

Mentor and guide junior team members onsite/offshore.

Guide QA team to test the software components developed.

Involved in unit testing, integration testing, feature testing and regression testing.

Participate in software gap analysis with business analysts and product managers.

Manage open tickets and find resolutions.

JP Morgan Chase, Chicago IL

March 2011 – May 2012

Technical Lead/Application Architect, Team Size 30

Responsibilities

Work with business users and business analysts to develop requirements and translate requirements into technical designs.

Functional analysis, data modeling and database design for Oracle 11g RDMS Databases.

Data migration from legacy systems and other DBMS Systems.

Research advanced concepts to develop reusable solutions to recurring problems.

Work with product managers on capacity planning.

Participate in software gap analysis with business analysts and product managers.

Created several DB packages, stored procedures, functions, and triggers

Wrote large number of Oracle queries. Heavy coding effort in PL/SQL. Data base administration

Analyze functional requirements, Use Cases and technical specifications for J2EE Architecture and design

IBM application server WebSphere 6.x administration tasks

Preparation of design documents in UML

Project Management and sizing

Lead and mentor developers in the team

Implementation of Struts MVC pattern frame work using Struts2

Unit testing using JUnit

Involved in unit testing, integration testing, feature testing and Regression testing

UNIX and Shell scripts, Source control management in Subversion

Navistar, Melrose Park (Chicago IL)

Dec 2009 – Feb 2011

Team Lead and Solution Architect

Responsibilities

Conduct sessions/interviews with the business side to secure detailed information pertaining to application and data usage.

Worked both directly with business users and with business analysts to develop requirements

and translate requirements into technical design

Functional analysis, data modeling and database design for Oracle 11g RDMS Databases

Application architecture and design

Preparation of design documents in UML

Weekly communication and reporting of project status risks and issues

Construct and optimize complex SQL queries

Heavy coding effort in PL/SQL

Assign tasks to team members onsite/offshore and monitor status till completion.

Mentor and guide junior team members onsite/offshore.

Guide QA team to test the software components developed.

UI coding efforts in JSP, JavaScript and HTML

Develop applications using Spring MVC pattern frame work.

Integration with IBM MQ series

Used SOA and Web services for importing BOM structure from TEAMCENTER application

Develop WSDLs, SOAP.

Heavy hands on programming efforts in control and UI layer.

US Bank, Chicago IL

March 2008 – Nov 2009

Solution Architect

Responsibilities

Analyze functional requirements, Use cases and technical specifications.

Application architecture and design.

Preparation of design documents in UML.

Research advanced concepts to develop reusable solutions to recurring problems.

Construct and optimize complex SQL queries.

Go to guy in the team for Oracle queries, stored procedures, functions, packages and triggers.

Implementation of Spring MVC pattern frame work.

Data management and persistent layer development in open source ORM tool IBATIS.

Implementation of Dependency Injection using Light weight Spring frame work

Heavy hands on server side programming efforts in Java.

UI coding efforts in JSP, AJAX, JavaScript and HTML.

Extensive coding efforts to develop oracle data base packages and IBATIS mapping files.

Design and develop SSL encryption and single sign on features of the application.

Rational tools Clear case and Clear quest for source control and defect tracking.

Mentor junior programmers in the team.

JP Morgan Chase, Chicago IL

Feb 2007 – Feb 2008

Application Architect Treasury Services

Responsibilities

Data migration and data loading programs in Oracle environment

Conversion of Oracle PL/SQL systems into J2EE Application.

Written a number a Database packages and triggers in PL/SQL

Data modeling and database design focused on Oracle environment

Installation, administration and maintenance of Oracle 10G Database for the development and QA environment

Construct and optimize complex SQL queries

Analyze functional requirements, Use Cases and technical specifications

Preparation of design documents in UML

Implementation of Struts MVC pattern frame work using Action Servlets and JavaBeans

Data management and Persistent layer development in open source ORM tool Hibernate

Implementation of Dependency Injection and AOP using Light weight Spring Frame Work

UI coding efforts in JSP, JavaScript and HTML

Extensive programming efforts in server side Java business layer

Rational tools Clear case and Clear Quest for version control and defect tracking

Mentor junior programmers in the team, both onshore and offshore.

Involved in unit testing, integration testing, feature testing and Regression testing

Chicago Mercantile Exchange, Chicago IL

March 2006 – Jan 2007

Senior Oracle/ Java/J2EE Consultant

Responsibilities

Analyze functional requirements, Use Cases and technical specifications.

Implementation of MVC pattern in Struts frame work and Tiles using Action Servlets and Java beans

Data management and Persistent layer development in open source ORM tool Hibernate

Implementation of Inversion of Control and AOP using Light weight Spring frame work

UI coding efforts in JSP, JavaScript XML, CSS and HTML

Rational tools for defect tracking and version control

Construct complex SQL queries in Oracle and DB2

Conversion of legacy reports into Crystal4Eclipse in J2EE environment

Developed Business Object report designs.

Perform administration on WebLogic app server for QA and DEV environment

Caremark, North Brook (Chicago, IL)

Oct 2004 – March 2006

Application Architect

Responsibilities

Worked directly with business users to develop requirements and translate requirements into technical design

Analyze functional requirements, Use Cases and technical specifications.

Develop design documents in UML

Weekly communication and reporting of project status risks and issues

Detailed design review and introduce best practices for the new application development.

Mentor junior programmers in the team

Used RUP software development methodologies

Construction and programming of business layer in EJB 2.x Session beans

Implementation of MVC pattern in Struts frame work and Tiles using Action Servlets and Java beans

Heavy UI coding efforts in JSP, JavaScript XML and HTML

Data modeling and database design focused on Oracle environment

Oracle 10g Administration, write and optimize complex SQL queries

Intensive coding efforts in PL/SQL for OLAP, batch process, data migration and data integrity

Crystal XI Administration

International Trucks and Engine Corporation Chicago, IL

Feb 2003– Sep 2004

Senior Java/ Oracle Architect

Federal Government Military Service (US Air Force), Texas,

March 2001 - Jan 2003

Senior IT Consultant

Health Care System for Military personnel

American Express, HSN, Ticket Master and Direct TV, Miami FL

January 2000 - Feb 2001

Oracle Lead,

Oracle Custom built CRM applications for telemarketing and order fulfillment

AT&T, Miami FL

May 1997 – January 2000

Senior Oracle Consultant,

Oracle Client Server Application

Oracle Corporation, Herndon Virginia

May 1996 – April 1997

Principal IT Consultant

Gulf Air, Manama (BAHARAIN)

November 1994 – April 1996

Project Leader

Hindustan Aeronautics Limited, Bangalore (INDIA)

January 1990 - November 1994

Deputy Manager (Computer Department)

This company is a business partner of Boeing USA

Another Solid Oracle, PL/SQL Client / Server Project

Responsibilities:

MRPII System Oracle 7.x Client Server Application for a big defense sector organization

Designed and Developed 4 modules of an in-house MRPII System for Aircraft manufacturing organization.

Contact this candidate