Background

• Analytical, innovative and highly motivated software professional with 18 years of Information Technology experience in implementing Oracle based application as well as Sql Server and Sybase with PL/SQL, T-sql and integrating Java/J2EE/Web based solutions
• Strong knowledge of server side Java, accessing bean properties, Java Database Connectivity JDBC , Java concepts, Design Patterns and Object Oriented Analysis Design.
• Exceptional analytical problem solving skills in Oracle and Server side Java, coupled with strong knowledge of Data Structures and Algorithms.
• Comprehensive knowledge of Software Development Life Cycle SDLC , having thorough understanding of various phases such as Requirements Gathering, Analysis, Design, Development, Testing and Production Maintenance.
• Adept at creating and transforming business requirements into functional requirements and designing business models using Designer, Erwin Data Model as well as UML diagrams for Object Oriented Design - Context, Use Case, Sequence, Activity diagrams in UML, MS Visio and Rational Rose.
• Comprehensive knowledge of Waterfall and Agile software development methodologies.
• Excellent track record for meeting deadlines and submitting deliverables on time.
• Great team player with excellent communication and interpersonal skills. Could work equally well in an individual environment.
• Have exposure in doing business analysis mentoring field users analysts on business systems and procedures and working with QA team to set priorities and schedules.
• Strong consulting experience in bridging technology and business goals to provide productive solutions.

Technical Skills

• OS: Windows 95/98/2000/XP/NT , UNIX/Sun Solaris 2.8, MS-DOS
• RDBMS: Oracle 7.x/8.x/10g,11g, SQL Server 2000-2005-2008 , Sybase 15.x
• Languages: PL/SQL, SQL, T-SQL Java, JSP, Oracle Java Stored Procedures, HTML, XML and C /Pro C
• Technologies: Weblogic 6.x, 8.x, GA ,OAS 5.1, Servlets, JSP, EJB 2.0, JDBC/ODBC
• Application Servers: Oracle Weblogic 8.2, Apache Tomcat 6.x, Jboss 4.x, 5.x
• OOD: UML, Visual Studio
• ETL Tools: Abinitio 3.x, SQl Loader, knowledge Informatica
• Tools: Eclipse 3.7, Builder 8.0, Rational Rose 2000, TOAD, SQL Developer, Embarcadero 8.5 Database Management, Monitoring Tool , , Mercury Quality Center, Test Track Pro, OEM 10-11g
• Data Modeling Tools : Erwin, ER /Studio , Power Point , TOAD , SQL DataModler
• Management Tools: Rational Rose, MS Project, MS Visio, MS Word, Excel and PowerPoint
• Frameworks: Weblogic 6.x, 8.x, Webshere, J2EE
• Configuration Tool: CVS and SVN, Hp Service Manager, Hp Quality Center, AnthilPro, Test TrackPro, SVN,Mercury
• Networking : UNIX, AIX, TCP/IP, NFS, SQL Net, LDAP, Active Server Authentication

Professional Experience

Confidential

Database Architect / BASEL II Support

• Performed the following tasks for multiple Basel II-III applications support:
• RWA Risk Weighted Asset: Basel II compliant risk weighted assets and Risk Adjusted Return on Capital calculation and reporting Production.
• LMT Limit Management System: Credit limit management system for traded products that will track and store data on trades, calculate risk amounts based on historical data and Basel parameters and feed certain resultant information into UB's data warehouses.
• MRF - Moody's Risk Frontier - Portfolio Management of Default Risk

Other duties includes:

• Analyzed application issues, monitoring performance related activities such as defects fixing, assigning the related group, troubleshooting production issues, and respond to business users for data inquiries for application support and management.
• Worked products release upgrade, export / import, configuration setting and deployment for RWA, LMT and MRF products working with vendors Moody's and IBM .

Tools/Technology: Windows IIS Server, SQL Server 2008 R2, Oracle11g, Jboss 4.x, Tomcat 6.x, PL/SQL 11g, J2EE Java. RedHat Linux 5.4 , HP Quality Center 8.2, Autosys,

Confidential

Database Architect

• POINT Risk Management Project: Worked with Technical Architecture and Business Users to implement and maintained databases for risk asset processing.
• Designed new database, logical and physical data model for creating staging Oracle database, Applied full development cycle from start to end including configuration database storages, development, deployment for database and web environment for the application anthill Pro, SVN
• Conducted successful proof-of-concept tests for Point team's architectural ideas.
• Designed and implemented ETL jobs to build a mission critical enterprise risk platform, which supports various portfolio and security risk management and fixed income asset processes and maintained using SDLC best practices - entire dev, qa, test, demo, and production instances for POINT.
• Worked with other teams for integrating data from the sources to collaborate overall dashboard reporting and other analytics result, which have dependency result setting.
• Implemented Java code Hibernate for XML parsing the incoming files including testing and debugging for various data loading and manipulating processing using Eclipse/Junit and pl/sql packages and Oracle tools .
• Performed routine on-call production support for several projects running in production which is available 24X7 by monitoring and processing batch processes autosys timely manner and directly interfacing Barclay Point Job scheduler processes London .
• Applied performance tuning for existing stored procedures, scripts used for ETL and analytics reports for multiple databases and data warehouse application Sybase 15.1, Sql Server 2008 R2, Oracle 11g .
• Implemented new ETL processing using Abinitio tool from different databases such as Oracle, Sybase, MS SQL Server and transformation as well as modifying the exiting ones for decreasing CPU time and cost .

Knight Risk Dimension Project SAS :

• Developed PL/SQL stored procedures, functions, several SQL scripts from various databases Sybase, MS SQL Server , Oracle to integrate Proc SQL in SAS Risk Dimension Project.
• Applied data mapping and conversion from multiple databases for the project definition and integration from multiple databases.
• Designed and modeled the stage and target star / snowflake schemas using Erwin. For SAS - Risk Dimension Project.

Tools/Technology: Oracle 11g, PL/SQL, Shell Corn/Perl/SQL Scripting, Embarcadero/ER Studio /PowerPoint, Power Designer 16.1 for Sybase, UNIX, Java Hibernate, Abinitio 3.3, SVN, Anthill, SAS 9.x, Autosys

Confidential

Snr.Software Engineer

• Bill Pay Conversion Project: Bill Pay conversion project is a corporate initiative to migrate the entire bill pay Wachovia customers to Wells Fargo Online Bill Pay System. The project required dividing the entire customer base into regions and executing one region per release.
• Provided critical 3rd level support for the Money Movement Solutions MMS platforms including Bill Pay, Scheduled Transfers, Desktop Deposit, Direct Pay, Online Billing and other highly prized applications moving funds for existing Hogan customers to West Wells Fargo application system based on PL/SQL, SQL, Unix shell, Perl scripting .
• Worked on predictive analysis using complex queries for forecasting the exception rate during conversion event and production deployment.
• Designed technical specifications and business reporting for the project.
• Developed complex highly efficient SQL scripts and for staging, validating and then migrating the Wachovia custom data to Wells Fargo Bill Pay System.
• Performance tuning involved running the batches, looking at trace files, increasing the initrans, cache value, sequence cache, number of threads and buckets based on SLA. It also involved optimizing the bulk operations and using more efficient bulk operation approach.
• Developed various error handling techniques to capture and display the errors and trouble shooting the nightly job failure for production support.

Tools/Technology: Oracle 10g, PL/SQL, Perl Scripting, SQL Scripting, TOAD, SQL Loader, TOAD, UNIX, Java Stored Procedures, VISIO, Clear Case Documentation/ Reporting , Clear Quest Defect Ticketing , Autosys batch processing

Confidential

Database Architect / Sr. Database Developer

• SITA Inc. delivers and manages business solutions for airline, airport, GDS, government and other customers over the world's most extensive network, which forms the communications backbone of the global air transport industry. The system was built using EJBs on Weblogic and JSPs in J2EE framework and Oracle 10g and update Oracle11g database.
• Contributed to the architecture, design, implementation and configure multiple streams of work with an appreciation for SITA's vision for Airfare Data Builder and Automated Fares Management and Pricing Projects.
• The system is distributed through JMS queue which is available 24X7 and monitoring and processing batch processes timely manner and directly interfacing SITA E-Commerce to its inventory, hosted by
• SITA Reservations system Borland Java , which is web booking, site now displays multiple fare options, enabling customers to select the appropriate service level for the desired itinerary.
• Designed and developed solutions for the system distribute the fare tariffs and rule sets to all GDSs and other subscribers. Every airline employs staff who code air fare rules in accordance with yield management that reflect strategic, long-term direction and planning using Oracle PL/SQL stored procedures, integrated with business objects enterprise Java API, Oracle advanced batch scheduler and Oracle Subloader for ETL solutions.
• Produced architecture and technical design documents for the core business models, change request and built part of the business service layer according to agile principles.
• Lead offshore team working on new modules, change request and system development
• Worked on existing bugs and enhancements in the product as per business requirements using Eclipse, JUnit for java based application and Sql Tuning Tools for database server side processing.
• Worked closely with cross-functional teams such as, QA Engineering for Regression testing as well as Prod Ops and Product Management and Data Center located in Atlanta for porudction support, deployment and other issues..
• Coordinated with build/release team for production release and system configuration Java and Weblogic Clustering, Database Management and Monitoring , and deployment processes also helped with postproduction support.

Tools/Technology: PL//SQL, SQL, Java Servlets, JSPs, Weblogic, Web Server Apache, Oracle 10g, JMS MQ v6, JDK , Enterprise Manager, Embarcadero 8.5, ER/Studio, Eclipse, LDAP, Borland Java, XML, Subloader, CVN, Mercury and Test Track Pro Defect Tracking Tools. Integration Server: Distribution Server Win2000x replaced by Webshere MQ series 5.1, Subloader and Server Console C and Java application , Active Directory /LDAP authentication .

Confidential

Snr.Programmer Analyst

• Joined a new team to integrate existing Mainframe products into SunGard Digital Campus products provided by the SunGard Higher Education solutions.
• Contributed to design development of application components for Unified Digital Campus Project IdM team to authenticate resources based on their identity in the directory as well as authorize access to systems based on the resources' directory attributes such as role assignments or group membership - Java Authentication and Authorization Service or JAAS .
• Worked with Luminis Portal team, designed and implemented channels for Campus Portal System using Java, XML and XSLT to create java classes and final user layout. Integrated a campus directory search channel with current Enterprise Directory using JAXP protocol.
• Worked with Banner Customization group to implement Oracle-based, Internet-native solution for medium to large student enrollments. Customize Banner forms, PL/SQL stored procedures, packages for Finance, Student, General and Advancement.
• Worked closely with SunGard and other teams and Product Managers to help them test functionality within different modules of the product.

Tools/Technology: Banner Workflow using Developer, LDAP, Oracle Banner Products, Luminis Portal, Java, XML

Confidential

System Analyst III

• RDS Regulated Default Supply Project , which is EPCOR's energy maintenance project.
• Designed and developed the Oracle standards for logical and physical data model using Oracle Designer,OracleForms,Oracle9iDS Tools.
• Led the team for Quality Assurance of the design and applying the standards.
• Developed Unit Task design and Technical specification for C , XML, PL/SQL, Oracle Forms Reports based on Microscope Design Methodology.
• Designed and implemented C components of the Project.

Tools/Technology: Oracle Designer, C , XML, PL/SQL, Oracle Forms, Microscope methodology , Erwin

Confidential

Oracle Developer

• EMS Environment Management Project
• Installed and Configured Oracle9iAS and Report Server with OCJ4 Enterprise Manager.
• Provided generic code solution for decreasing time and effort for migration Oracle Forms/ Reports on Website.
• Applied EJB and PJC for extending the client with Java UI components,

Tools/Technology: TOAD, Oracle 8.x, IE 5.0 OCJ4 Enterprise Manager, Applied EJB and PJC

Confidential

System Analyst II

• Blue Express Project: Design and Developed the application for upgrading Oracle9i version.
• Directed meetings with appropriate staff and user from other departments to determine specific requirements and acceptance testing for the new application and change requests.

Designed and developed Dental Microfiche Application using PL/SQL, Oracle 9i Forms and Reports

Tools/Technology: TOAD,EJB2.0,JSP, Java2.0, STRUTS, Weblogic7.0, Oracle8.x, MS Visio/Word/Excel/PowerPoint

Confidential

System Analyst III/ C Developer

Penfax Project Pension System Solution : Developed and modified pension calculation engine using Developer 2000 in Oracle RDBMS and Pro C. IPAS Project Pension Corporation Project : Performed maintenance support, built new application using Visual C and Visual Source Safe Tools.

Tools/Technology: C and Visual Source Safe Tools, Pro C, Oracle RDBS and Tools

Confidential

Snr.System Analyst / Data Modeler

• FDOT Florida Photo Radar Transaction Project : Designed and developed logical and physical data models, process flow, functional hierarchy using Designer 200 and Ervin.
• ICBC-SMP Speed Violation Management Project : Worked in major part of coding, configuration and integration modules of SMP Project using daemon Unix processes, C , SQL scripts, Pl/SQL, Oracle Forms, Reports in windows NT/ Unix Platform. Built a new solution for Batch Interface Images Project to improve quality and performance of the applications.
• Tools/Technology: Erwin Data Modeler 4.0 , Oracle RDBMS, Oracle Designer, C , SQL scripts, Pl/SQL, Oracle Forms, Reports in windows NT/ UNIX Platform.

Confidential

System Analyst / Data Modeler

Future Shop Warehouse Project: Created and designed logical and physical data models ERD diagram and functional hierarchy modules. Designed and prototyped Human Resource, employee Bonus and Support Store System applications, Participated workshops for strategic business planning architectural design, re-engineering business processes and detailed system design and project management.

Tools/Technology: Erwin Data Modeller 3.5 , Oracle Designer Warehouse