PROFESSIONAL SUMMARY

• I am a professional application developer with 20+ years of commercial application development experience in analysis, design, development involving databases, SOA architecture, internet technologies, intranet technologies and client/server applications.
• Working on Government contract for 7 years.
• Oracle EXADATA (X2 - 8) 12c, 11g, 10g, 9i PL/SQL, SQL, Stored Procedures, Triggers, etc.
• Building Mappings and Workflows for ETL using Informatica PowerCenter 9.5, 9 and 5.0 for over 5 years.
• Design and development of Logical, Physical Entity Relational models.
• Design and development of Logical, Physical Dimensional models.
• Working with Oracle 12c, 11g, 10g, 9i PL/SQL, External tables, PL/SQL, Stored Procedures.
• Oracle 12c, 11g, 10g, 9i Query Performance tuning.
• Implementing Oracle’s features like “Transparent data encryption”, Oracle’s XML based queries and XML based Utilities.
• Implementing Oracle 10g Streams Advanced Queues.
• Crystal Reports 9.0, 8.0.
• XML, HTML, ASP.
• Working with Teradata V2R5 database.
• Client-Server application development tool Powerbuilder 7.0 to 4.0.
• Procurement process for domains like Purchasing, Receiving, Inventory management.

TECHNICAL SKILLS

DBA/Developer Tools: Oracle Enterprise Manager, SQL Navigator 4.0, Toad, PL/SQL Developer, BTEQ, Developer 2000

ETL Tool: Informatica PowerCenter

Data Modeling tool: Erwin.

Software: SQL, PL/SQL, Crystal Reports 9.0, 8.0, PowerBuilder 7.0 to 4.0

Web Technologies: XML, ASP, JavaScript, VBScript

Operating Systems: UNIX, Windows NT, Windows XP

EXPERIENCE

Confidential, Alexandria, VA

ETL Architect / Developer

Responsibilities:

• Design and develop ETL Mapping and Workflows using Informatica Powercenter 9.5 for implementation of data migration from IBM mainframe to DB2 UDB Transactional database and Data warehouse.
• Created mappings to load data from COBOL copybooks, flat files using NORMALIER transformation. These mappings also use Expressions, Connected and Unconnected loopkup, Sorter, Router, Aggregator, Stored Procedure and other transformations.
• Perform data quality analysis, data profiling and data cleansing.
• Build DB2 Stored procedures and entity relational data structures for staging area and destination databases.
• Build Queries using analytic functions like SUM, RANK, ROW NUMBER, LEAD, etc. for extraction of data from staging area to target OLTP/ operational database.

Confidential, Chantilly, VA

Sr. Database Engineer / Data Analyst

Responsibilities

• Design and Develop Oracle Objects, data structures and data mart for building regression models.
• Develop Oracle Package and Stored procedures to implement the regression models.
• Design and develop ETL’s to build and maintain Data Warehouse for regression models.
• Design, develop, deploy and maintain Oracle packages, data mart in OLTP environment to implement the regression model for risk assessment.
• Build Queries using analytic functions like SUM, RANK, ROW NUMBER, LEAD, etc. for ETL.

Confidential, Herndon, VA

Database Developer

Responsibilities

• Developed Oracle PL/SQL Package and Stored procedures that were used for validating the Home Affordable Modification Program (HAMP) loan modification result for a given loan or scenario.
• Developed Input XML document that was to be used for input to the Home Affordable Foreclosure Alternative (HAFA) loan modification program.

Confidential, Lakeland, FL

Database Architect / Developer

Responsibilities

• Redesigned existing IVS backend system that is on Oracle 10g. This process is build using Oracle 10g PL/SQL Packages and Procedures.
• SQL query tuning, build Stored procs for the core-processing engine, including Oracle Advanced queuing.
• Created, monitored (Query to check AQ$ tables for load, error queues, etc on queues) and Maintain (Stop, Start, requeue, flush, etc, the Queues as needed) Oracle queue’s. “IVS” uses Oracle Advance Queues for recording all messages coming in from different monitors, so that each communication is recorded and no data is lost.
• Implemented new functionality via Stored proc’s that Enqueue and dequeue messages for improved communication between Modem servers and Oracle database.
• Lead the redesign of Reports that are built using SQL and PL/SQL.

Confidential, Tampa, FL

Database Architect / ETL Developer

Responsibilities

• Responsible for redesign of existing Bill of Material process. This process is build using Oracle 10g PL/SQL Packages and Procedures. I did SQL query tuning, wrote and redesigned many Stored procs in the core processing engine called "BOM PROCS".
• Lead the designing Data warehouse for Material Forecast effort. This Data warehouse is designed on Star schema with source data from core "CXP" OLTP application. Warehouse is updated daily and various Reports show the Material consumption (Daily) and other details for each Unit.
• Lead the redesign and rewrite of the ETL’s that update the master data in Oracle 10g from SAP application.

Confidential, Tampa, FL

Database Architect / Designer

Responsibilities

• Responsible for Design and Development of 2 Operational data store (ODS) and 6 OLTP databases using CA’s ERWIN.
• Responsible for design, development of ETL’s in Oracle 10g PL/SQL from various data vendors, SSN administration and Banks who contribute their Fraud data. Data comes in different formats ranging from flat files to XML files. Built ETL’s using Oracle 10g External tables for staging and PL/SQL Stored procedures.
• Lead a team of 3 to 4 offshore developers team for development effort.
• Responsible for Implementation of Oracle 10g “TRANSPARENT DATA ENCRYPTION” for securing customer sensitive data like SSN, DL, State and all other forms of ID’s in database for PCI compliance of securing data at rest.
• Responsible for Design and development of pseudo code of all Oracle 10g PL/SQL Stored procedures for all databases used in “Origin”. These stored procedures were called from different SONIC services.
• Responsible for Design, Development and implementation of Origin’s “RULES ENGINE” which is used in Strategy decision for outcome of a transaction. For this “RULES ENGINE” I designed the database, designed and developed the PL/SQL Stored Procedure and helped design the rules.
• Responsible for Design of all Use Case Realization (UCR) for all Oracle 10g PL/SQL Stored procedures used in “Origin”.
• Responsible for co-ordination with the offshore team for development of PL/SQL Stored procedures according to the UCR’s.
• Responsible for Code review, modification, enhancements and implementation of all PL/SQL Stored procedures for “Origin”.

Confidential, Tampa, FL

Database - ETL Designer / Developer

Responsibilities

• Responsible for Logical and Physical design of CES data warehouse.
• Design and develop ETL Mapping and Workflows using Informatica Powercenter 5.0 for implementation of data migration from IBM mainframe to DB2 UDB Transactional database and Data warehouse.
• Created mappings to load data from COBOL copybooks, flat files using NORMALIER transformation. These mappings also use Expressions, Connected and Unconnected loopkup, Sorter, Router, Aggregator, Stored Procedure and other transformations
• Responsible for Impact Analysis, detail design and development of ETL for 3 data sources using Oracle 10g PL/SQL Stored procedures. The 3 data sources are DUNS & BRADSTREET (Flat file), KINGLAND, GEMS ( Confidential ''s internal data mart on Oracle).
• Responsible for health check and validation of the data after it is being loaded into the data warehouse.
• Tuning SQL queries, PL/SQL Stored procs and reduced the load time by 30%.

Confidential

Responsibilities

• Maintained core GEMS Entities, Relationships, Engagements and Restriction data and processes that keep data in sync.
• Maintained, Tuned and enhanced GEMS core "Restriction Engine" (also added robust error handling, new restriction regulators and other features).
• As part of Production support, I built utilities in Oracle 9i PL/SQL that correct online restriction issues with GEMS data. No Database downtime for this maintenance.
• Tuned and Enhanced Oracle 9i PL/SQL bulk data load process in GEMS for GEMS Entities, Relationships, Engagements, etc data.
• Responsible for design, development of GEMS data warehouse.
• Built Daily, Weekly Alert reports for monitoring GEMS system using Crystal reports 9.0 as front-end.
• Frontline Consulting Services is a consulting company and I did various projects for them from

Confidential Charlotte, NC

Database Developer

Responsibilities

• Design and developed web based application that enables customers to make online payments. Integrated information to and from 5 different Internet based web service providers, such as, Trust Mark, IDShield, eValuChek, SafeTrade and Southern Data Com using ASP, HTML, VBScript, XML, Visual Interdev IDE.
• Responsible for and involved in full life cycle development of this project of integrating system to all Internet Service providers.
• Developed merchant Reconciliation Process that handles all transaction settlements through various vendors and provided Online Reports using Crystal Reports 8.0.
• Designed and developed Oracle 9i based stored procedures and triggers using SQL and PL/SQL.
• Responsible for database application tuning and query optimization.
• Setup and administer database, including monitoring of disk space, managing users, troubleshooting database issues and other DBA tasks.
• After registering a user, the system validates the information provided, then binds the User to a specific machine, enables user to make payments via Check or Debit Card that are processed online and issues a warranty against the trade done online.
• System handles Checks and Debit Cards as online payment methods.

Confidential, Charlotte, NC

Analyst / Developer

Responsibilities

• Developed Master and Transaction Reports for Purchasing, Inventory, Vendors Material management, Work orders, Production reports etc, etc. In 5 months, I developed about 68 reports using Crystal Reports 8.0 and Oracle 9i Stored Procedures.
• Developed Triggers and Stored Procedures in Oracle 9i using SQL, PL/SQL that were used throughout application for Reports and achieving other business objectives.
• The system has various modules namely, Administration and System Setup, Inventory, Production, Purchases, Sales, Suppliers, Work Orders, Asset Tracking, Accounting and Reports.

Confidential Charlotte, NC

Developer

Responsibilities

• Was solely responsible for developing secure shopping carts checkout system and generating online shipment rates via API''s of shipping co.'s like UPS and FedEx, Craters and Freighters using ASP, HTML, VBScript, XML and Visual Interdev IDE.
• Developed over 25 user interface screens for various modules such as Administration and System Setup, Catalogs, Auction Listings, Suppliers, Inventory and Shopping cart using Visual Interdev IDE.
• Developed Triggers and Stored Procedures and did query optimization and tuning.
• Logical and Physical design of database on Oracle 9i on Windows 2000 for this Web based application that lists auctions on various auction sites like "eBay", "Yahoo" and "uBid".
• This System handles Credit Cards, PayPal online payment methods.
• The system has various modules such as, Administration and System Setup, Catalogs, Auction Listings, Suppliers, Inventory, Shopping cart and Payments, Tracking.

Confidential, Charlotte, NC

Analyst / Developer

Responsibilities

• Was responsible for enhancements and maintenance of the core Purchasing, warehousing, receiving, RFQ''s, Reports & analysis modules using Cold Fusion 4.0, 5.0, HTML.
• Designed and developed online Reporting module in Cold Fusion, HTML.
• Was solely responsible for making the entire application Oracle 8i, 9i compliant in SQL and PL/SQL.
• Was solely responsible for query optimization for the entire application.
• Application has the following features: Purchasing, Receiving, Inventory management, Task scheduling, Internal messaging, Invoice reconciliation, Requisitioning, Reports & analysis, Electronic catalog, Built-in budgeting & approvals, decision support, RFQ, fax and EDI.
• Application layer platform was ColdFusion Server and development tool was ColdFusion Studio 4.0.
• Application can be used with any of the following databases Oracle 9i, 8i, Sql Server, MS Access.

Confidential

Project Lead/Analyst

Responsibilities

• Was team lead and assisted other developers in the development of the application using Powerbuilder 6.0.
• Designed, developed and maintained Database and Stored Procs and Triggers on Oracle 7.0 and Sql server on NT.
• Designed user interface, input screen formats, Reports using PowerBuilder 6.0
• Designed and developed business logic that embeds business process guidelines per client needs.
• This project was developed for Co-operative Departmental Stores under the Government of Thailand, and implemented on more than 200 sites in the country.
• Application has the following features, Administration and Setup, Point of Sale, Inventory, Security, Membership Services, Reports.
• Backend connectivity was established using ODBC. Development tool was PowerBuilder 6.0.
• Application supports Oracle 7.0, Sql Server 7.0, MS Access Databases.

Confidential

Programmer/Developer

Responsibilities

• Participated in Design and requirement gathering from the client for automating government accounting in Sr. Accounts Officer's Office Western Railway India.
• Worked on all four phases of development of this system, that is requirement gathering, analysis, development and testing of the Accounting System.
• Designed, developed and maintained Oracle Database 7.0 on HP-Unix.
• Developed stored procedures and triggers on Oracle 7.0.
• Developed application and screen interfaces using Oracle Developer 2000.
• Developed Periodic Financial Reports in Oracle Report Writer 2.5.
• Developed and implemented Bill entry, Payment and Reporting modules.
• This project was developed for Accounts department of Western Railway, Govt. of India and implemented on more than 200 offices in the country.
• Application has features namely, Administration and Setup, Bill entry and queuing, Bill tracking and monitoring, Payments, Reconciliation, maintaining of account head of expenditure, Financial reports, etc.
• Designed user interface, input screen formats, Reports using Oracle Forms 4.5 and Report Writer 2.5..