SUMMARY:

• Provide Optimal solutions for data warehouse and online transactional systems using Oracle SQL and PL/SQL.
• Over 15 years of experience as a developer and technical lead in Relational Database Systems and Web based systems.
• Actively engaged in various phases of Development starting from System requirements, Design, Coding, Testing and Deployment.
• Contributed to project planning and have been responsible for Deployment planning of several projects.
• Developed Packages, Database Triggers, Stored Procedures and Functions using PL/SQL.
• Migrated data using batch processes, Interface programs.
• Hands - on Experience in Performance Tuning, Export/Import Utilities, TOAD & SQL Loader. Hands on experience in Data export/migration from Redbrick to Oracle. Hands on experience in using different tools in Sybase like ISQL, bcp, T-SQL.

TECHNICAL SKILLS:

Hardware: HP 9000, RM 600, RS 6000, IBM-PCOperating Systems: UNIX, MS-DOS, HP-UX, Windows NT

Languages: C, COBOL, HTML, Java

RDBMS: ORACLE 8i/9i/10g/11g, DB2, Sybase System 10Front Ends: Cold Fusion 4.0,Visual Basic 3.0PowerBuilder 3.0a/4.0/5.0,Designer 2000 SQL*Forms 4.0/4.5, Swing

Utilities: make, awk, shell, Perl, LoadRunnerSQL*Loader, TOAD, JCreator 1.5Sourcesafe, PVCS, SCCS, TruechangeClearquest, GIT

EXPERIENCE:

Confidential - Chantilly, VA

Environment: - Oracle 12c, PL/SQL,Unix

Technical Lead (Database)

• Designed/implemenetd data structures to centralize USPS rates that could be accessed by different USPS applications
• Lead efforts towards implementing ETL solutions with optimal performance for persisting various USPS rates
• Designed and implemented monitoring techniques and alerts for jobs run on a daily basis
• Developed understanding of client business processes, objectives, and solution requirements
• Participated in project work groups with subject matter experts and stakeholders to understand data specific needs
• Communicate status to upper management/project oversight

Confidential - Chantilly, VA

Environment: - Oracle 11g, PL/SQL,Unix

Technical Lead (Database)

• Designed and implemented back-end solutions for USPS business needs
• Lead efforts towards implementing procedures for optimal performanceand minimizing maintenance
• Planned and implemented efficient deployment procedures to reduce downtimeand coordinated smooth execution of production tasks
• Worked on sprint team in agile, rapid development and deployment environment.
• Developed understanding of application processes, coding standards, and performance standards. Learned existing and new processes and technologies

Confidential, VA

Environment: - Oracle 11g, PL/SQL,Unix

Senior Developer

• Designed Oracle PL/SQL solutions for a web-based application for the US Veteran Affairs Benefits administration
• Analyzed business problems/functional requirements and translated them into well documented database solutions that meet business needs, as well as provided ongoing development support for the same
• Supported production and non-production Oracle databases including correcting issues reported in production systems, supporting routine/ad-hoc change requests and creating technical documentation
• Provided expertise on performance tuning standards and techniques
• Adhered to company standards while scripting all changes and procedures

Confidential, Herndon, VA

Environment: - Oracle 10g, PL/SQL, Unix

Technical Lead

• Lead efforts towards design, development and performance tuning of an OLTP application using Oracle PL/SQL.
• Designed/developed code from maintainability, reusability, performance andextensibility perspectives
• Responsible for driving execution across all phases, including requirements anddevelopment
• Adhered to standards and processes and collaborated with other departments forsmooth execution of projects
• Provided guidance to customer service on support issues and followed through onsolutions to customer problems
• Identified several areas of the database tier for performance tuning
• Suggested improvements to legacy systems and prototyped solutions

Confidential - Herndon, VA

Environment: - Oracle 9i, PL/SQL, Unix

Lead Developer

• Lead efforts towards design, development and performance tuning of data warehouse applications using Oracle 9i/10g specific analytic functions
• Designed a central source for datamart reporting for business analysis
• Designed a data model to ensure accurate ETL processes in order to comply with oncoming daily data feeds of 20 million volume
• Designed/developed/integrated/deployed data warehouse components using PL/SQL
• Enhanced and supported the application as per customer needs
• Tuned PL/SQL procedures and queries issued against 300 million rows for optimal performance
• Lead team efforts towards successful implementation of releases
• Involved in life cycle development of real-time (OLTP) transaction processing systems

Confidential, McLean, VA

Environment: - Oracle 8i, PL/SQL, SQR, Designer 2000, Unix

Developer/DBA

• Designed reports for financial applications
• Involved in trending of database statistics, proactively making database changes to optimize performance and prevent issues
• Tuned SQL for optimal performance
• Extensive user interaction in obtaining the user requirements and transforming the data warehouse model to in corporate the requests
• Designed reports using SQR report writer against Oracle based data warehouse applications
• Reverse engineered the FINSTAR physical model into a logical model for impact analysis using Designer 2000
• Provided production support for weekly load into the data warehouse
• Integrated external and internal data into the data warehouse using PL/SQL

Confidential, Herndon, VA

Environment: - Oracle 8i, PL/SQL, SQL*LOADER, Windows NT

DBA/developer

• Developed utilities for monthly data clean-up routines
• Analyzed user requirements, designed functional and technical specifications, identified data sources and designed tables
• Administered database access to users and assigned privileges/roles
• Administered/Monitored jobs by querying against the Oracle 8i database server
• Defined database standards, transaction management, error handling and security
• Automated generation of commission statements for Confidential Sales personnel
• Involved in production support and resolved issues with minimal business impact
• Developed test suites for verifying integrity of data during migration from one source to another
• Developed PL/SQL stored procedure and triggers

Confidential, Fairfax, VA

Environment: - Oracle 8.0, PL/SQL, SQL*Loader, Java, HTML,Cold Fusion

Senior Associate

• Responsible for DBA activities and coding PL/SQL scripts to extract information based on dynamic query criteria
• Developed Web based search facility using Cold Fusion, Java and HTML with Oracle as the back end
• Analyzed user requirements, identified data sources and designed tables

Confidential, Washington DC

Environment: - Oracle 7.1, SQL, Mercury LoadRunner, Unix

Analyst/Developer

• Testing database load for multiple Data Warehouse applications against an Oracle dataserver using LoadRunner test tool
• Simulating concurrent access of 500 users of the application in a production like environment for testing database queries response time, performance comparison
• Well versed with Load Runner testing tool
• Database activity in Oracle involved interpreting the log files for correct parsing of the SQL statements and making the necessary changes to the scripts to in corporate the same

Confidential, McLean, VA

Environment - PowerBuilder, Sybase 10, Windows NT

Analyst/Programmer

• Involved in studying an existing procurement request information system in a DOS environment and developing the same with enhanced options in Windows using PowerBuilder 4.0/5.0 and Sybase as the developing environment on a Windows NT platform for the US department of transportation. (DOT)
• Designed and developed a user interface in PowerBuilder 4.0 and Sybase to send solicitations, awards and bids via EDI (Electronic Data Interchange)
• Automated the generation of DOT standard forms and reports

Confidential

Environment - Oracle 7.0, SQL*Loader, PL/SQL, Developer 2000 (Forms/Reports), C, Unix

Developer/Analyst

• Designed screens for a navigation/browsing module using Developer 2000 Forms
• Used built-in procedures of Forms as well as coded procedures and functions
• Used packages to enhance performance
• Tested the alpha version of ENTIRE BROKER, a product that acts as a connecting mechanism when developing or enabling distributed applications in heterogeneous computing environments
• Coordinated with SourcePoint team at Software AG headquarters in Darmstadt (Germany) in developing the Data Warehouse Handler, a C based component that realizes access to UNIX based SQL databases
• Involved in mapping and developing database specific modules of the ODBC interface to ENTIRE ACCESS for DB2
• Testing of the ORACLE ODBC interface to ENTIRE ACCESS
• Automation of Library Management System using Sybase/PowerBuilder for maintaining and generating reports for pending and current status of transactions