Professional Profile

• Posses very strong analytical, troubleshooting, problem solving, critical and logical-thinking skills
• More than 2 years developing Oracle applications using Oracle forms and reports
• More than 7 years of Oracle consulting experience
• More than 4 years of Data Modeling experience
• More than 9 years of Data Analysis and Data Management experience
• More than 13 years of technical hands on Oracle, PL/SQL programming and development experience.
• Over 16 years of experience in Oracle PL/SQL development, design, requirements analysis, data analysis and management, trouble-shooting, problem-solving, some oracle database administrative skills, oracle discoverer, and system testing in consulting, healthcare, retail, manufacturing, telecommunications, and government industries.
• More than 2 years of Oracle 9i/10g discoverer experience
• Very reliable, trust-worthy, dependable, and can get jobs done.

Industries

• Manufacturing
• Government
• Healthcare
• Consulting
• Education
• Retail
• Telecommunication

Areas of Expertise

• Trouble-shooting/Problem-Solving Oracle related issues
• Complex SQL Development
• Data Analysis
• Requirements Analysis
• PL/SQL programming and development
• Oracle Reports Development
• Oracle 9i/10g Discoverer

Experience and Skills

• Oracle Datawarehouse Builder - OWB
• Data Modeling Tools used MS Words, MS Visio, Toad by Quest
• Project Management Techniques
• Some Oracle DBA Skills
• Windows NT/95/98/2000/XP
• Developer 2000
• TOAD 7.x/8.x/9.x/10.x/12.x
• Oracle Forms and Reports Developer 6, 6i, 9i, 10g, 11g
• Oracle 9i/10g Discoverer
• Oracle SQLLOADER
• Oracle 7.3x, 8i, 9i, 10g, 11g
• Oracle SQL Plus
• Oracle PL/SQL PL SQL
• Oracle Advanced PL/SQL
• Oracle Database 8/8i/9i/10g/11g
• Oracle 8/9i/10g/11g Enterprise Edition
• Oracle 10g/11g SQL Developer
• Golden Development Tool
• Harvest
• Change Management
• Unix Sun Solaris AIX
• Unix Vi Editor
• Oracle 10g Database Express
• MS Office Tools Word, Excel, Outlook, PowerPoint, Visio
• Erwin Exposure

Chronology of Experience

Confidential

Industries: Financial

Position: Oracle PL/SQL Development

Environment: Oracle 11g, Windows 7, UNIX AIX

Tools:

• TOAD Version 12.5.x, SQLPLUS, PL/SQL, TFS, PUTTY, SharePoint, MS Outlook, MS Office Tools, Oracle Forms 11g
• Performed SDLC for client projects developing technical design, test plan and test results documents to design and develop objects
• Used Oracle 11g database and Oracle Forms 11g, PL/SQL, Unix, SQL Developer, SQLPLUS, MS Office Tools, and other proprietary tools as well as SQL report scripting and TFS tool for version control

Confidential

Positions: Technical Leader/Solution Architect - L1 App Analyst/Production Support

Environment: Oracle 10g, 9i, Windows NT, UNIX AIX, Netezza

Tools:

• TOAD Version 9.x, SQLPLUS, PL/SQL, HPSM, HEAT, VMWare, CITRIX, PUTTY, SharePoint, MS Outlook, Remedy, Informatica, VSS, IPM, QC, MS Office Tools, TWS, SQL Developer, PL/SQL Developer, NetezzaAguity Tool, Netezza database
• Confidential developing functional and technical specifications from user requirement document to design, development, test cases and results, testing, project tracking and status reporting, and deployment of codes to production as well as the transition part of the developed objects to support team
• Used Oracle 10g, PL/SQL, Unix, SQL Developer, SQLPLUS, MS Office Tools, Netezza Database, NetezzaAguity, and other proprietary tools
• Responsible for receiving Knowledge Transfer KT from Keane resource for GSK project for the CDF and CAT applications Responsible for the day to day development and operations part of CDF and CAT applications using Responsible for running and monitoring CDF and CAT application processes on a daily basis Responsible for Logging incident related issues, making sure the issues are resolved in timely manner Responsible for creating the analysis documents, estimates, project specifications, test cases for unit testing, and release sheets for development related tasks and projects for CDF and CAT processes Responsible for communicating issues, progresses, etc to application owners where and when necessary Responsible for assigning tasks/projects to offshore team members and reviewing the same before implementations Have daily, sometimes, three times weekly status/live meetings with offshore team members Utilized Toad version 9.x for Oracle processes, etc Informatica version 9.x for ETL tool Unix Sun Solaris for batch scripting Korn Shell and other Unix server related processes In-Process Manager IPM for jobs/applications scheduling and processes MS Office tools: Outlook for email communications, live meetings, appointments, etc , Word for document related tasks , Excel for spreadsheet related tasks , PowerPoint for presentation related tasks , and Live meeting for team meetings and presentation related tasks/sessions Laptop with Windows XP operating system, winftp for ftp related tasks Visual Source Safe VSS - for check-in/check-out of objects PL/SQL Developer for oracle related developments, trouble-shooting tasks TWS for job scheduling tasks
• Responsible for researching, analyzing, trouble-shooting and resolving both application and database related issues as it pertains to GSK healthcare and Mail Order Pharmacy Dispensing Applications
• Work on incident resolution as assigned via Remedy, HEAT and HPSM incident management applications for the CVS Caremark PBM project
• Work on root cause analysis and problem elimination
• Work on some Business Service Requests for efforts less than 100 hours as it pertains to Mail Order Pharmacy Dispensing Oracle related tasks as assigned
• Work on documentation of application processes as they pertain to Mail Order Pharmacy Dispensing Work on application monitoring as it pertains to Mail Order Pharmacy Dispensing

Confidential

Position: Sr. Oracle PL/SQL Developer/Production Support

Environment: Oracle 10g, 9i, Windows NT/XP, UNIX Sun Solaris, Data Warehouse - Retail

Tools:

• TOAD, ORACLE, SQLPLUS, PL/SQL, Quality Center, Harvest, Oracle 10g, Change Management Tool, VI Editor, FTP
• Responsible for Oracle10g Development, PL/SQL Development, Unix Scripting, trouble-shooting and resolving code related issues both in UNIX and Oracle Database environments.
• Handled several projects relating to Data Loading and production support issues.
• Handled PL/SQL code Analysis, coding, tuning, modifications, and new developments based on requirement.
• Handled Oracle New Object Creations Tables, Indexes, Sequences, Procedures, Functions, and Triggers.
• Handled data analysis, validation, and trouble-shooting issues based on customer requirements.
• Handled retrieval and loading of data based on customer requirements via import/export mechanism.
• Utilized TOAD 9.x, Oracle SQLPLUS, and Windows Command Prompt for creating objects, modifications, import/export, trouble-shooting and resolving issues.
• Utilized Microsoft Outlook for Emails.
• Utilized Microsoft Excel and Word for spreadsheet related tasks.
• Utilized Quality Center for creating defects and logging tasks.
• Utilized Change Management for New and Old Projects Deployment purposes.
• Utilized Oracle10g/11g, SQLPLUS, Windows NT/XP, Unix Vi Editor, Sun Solaris for creating and modifying both Oracle Unixrelated objects.
• Utilized TOAD for data loading importing/exporting tables' data in Oracle environment.
• Utilized SQLLOADER for data loading importing tables' data in Oracle environment.
• Utilized Harvest for checking-in/checking-out objects for both new developments and existing ones.

Confidential

Position: System Analyst

Environment: Oracle 10g, Unix, Windows NT/XP

Tools:

• Golden, TOAD, ORACLE10g, SQLPLUS10g, PL/SQL10g, Test Director, JTRAC, SQL Developer11g, SharePoint
• Responsible to design, code, and test PL/SQL scripts for test data generation for performance testing
• Responsible to assist in support of applicationprojects
• Created high level design document for test data generation for performance test projects.
• Created PL/SQL scripts based on high level design document to generate data for 14 table objects
• Loaded several million records to test PL/SQL scripts
• Resolved issues encountered during testing
• Worked on data cleansing/scrubbing and data loading projects
• Worked on Oracle PL/SQL code modifications/enhancements to resolve issues
• Served as primary/secondary on-call person on rotational basis
• Participated in team/project meetings
• Documented all work performed
• Used JTRAC, Test Director, SharePoint to log requests, defects, check-in/check-out respectively
• Used Oracle 10g, SQL Developer 11g, Golden TOAD 9.x, SQLPLUS10g
• Volunteered to some community services

Confidential

• Effective Use of Feedback for Business: Effective Feedback for Employees and Companies
• Application Analysis
• Application Delivery Team Lead
• Oracle Forms Developer 10g: Creating and Working with Form Elements
• Oracle Forms Developer 10g: Working with Canvases and Triggers
• Oracle Forms Developer 10g: Building Internet Applications
• Oracle Forms Developer 10g: Architectural Environment and Services
• Obtaining Results without Authority. Communicating to Get Results
• Leading Teams: Dealing with Conflict
• Conflict in the Workplace. Handling Conflict
• Professionalism and Business Etiquette
• Oracle Forms Developer 10g: Query Builder Features
• Cultivating a High-performance Project Team: Building a High-performance Team
• Oracle Forms Developer 10g: Working with Validation and Navigation

Confidential

Position: Sr. Oracle PL/SQL Developer/Data Analyst

Environment: Oracle 10g, 9i, Windows NT/XP

Tools:

• Golden, TOAD, ORACLE, SQLPLUS, PL/SQL, Quality Center, Centrix, Oracle 10g Discoverer
• Responsible for Oracle9i/10g Development, PL/SQL Development, Complex Oracle SQL Development, trouble-shooting and resolving code related issues.
• Handled several projects relating to RJ-11, FlexPay, SIVR, WEB, and Retail.
• Handled PL/SQL code Analysis, coding, tuning, and modifications.
• Handled development and tuning of complex Oracle SQL queries based on customer requirements.
• Handled creation of Oracle Temp Tables, Indexes, Sequences, and Database Links.
• Handled data analysis, validation, and trouble-shooting issues based on customer requirements.
• Handled retrieval and loading of data based on customer requirements via import/export mechanism.
• Utilized TOAD 8.x, Oracle SQL Developer, and Golden Applications for creating objects, modifications, import/export, trouble-shooting and resolving issues.
• Utilized Microsoft Outlook for Emails.
• Utilized Microsoft Excel and Word for spreadsheet related tasks.
• Utilized Quality Center for creating defects and logging tasks.
• Utilized Oracle10g,SQLPlus in Developing Views, Procedures, Triggers, Sequences, Tables, etc. for Quality Center Reporting Project.
• Utilized Centrix for logging timesheets for the client.
• Utilized Oracle9i/10g, SQLPLUS, Windows NT/XP for creating and modifying Oracle related objects.
• Exposure to Oracle 11g.

Confidential

Position: Sr. Oracle PL/SQL Developer

Environment: Oracle 10g, 9i, 8i Windows NT/XP

Tools:

• StarTeam, TOAD, ORACLE, SQLPLUS, PL/SQL, Oracle 10g Discoverer Responsible for Oracle9i/10g Development, PL/SQL Development, trouble-shooting and resolving code related issues.
• Handled Conversion project.
• Handled PL/SQL code Analysis and modifications.
• Handled creation, modifications, and documentation of Oracle Packages, Procedures, Functions, and Indexes.
• Handled creation of Oracle Tables, Triggers, and Materialized View.
• Handled creation of test plans, and technical specifications for developed and/or modified objects. Handled loading data required for system testing, setting up necessary test environment, and system-testing developed Oracle objects.
• Utilized TOAD 8.x for creating objects, modifications, trouble-shooting and resolving issues. Utilized Oracle 10g Discoverer to administer and create reports.
• Utilized StarTeam for check in/check out objects, and logging tasks.
• Utilized Oracle9i, SQLPLUS, Windows NT/XP for creating and modifying Oracle objects.
• Oracle 11i /Oracle Financials Training CBT
• Confidential
• resolving issues as they surfaced.
• Handled PL/SQL code modifications, enhancements and tuning.
• Handled Oracle Reports development, modifications, enhancement, and tuning and Oracle 10g Discoverer Reports design, development, enhancement, and tuning.
• Created Tables, views, materialized views, wrote SQL scripts, Indexes, etc,
• Analyzed Oracle objects,
• Resolved performance issues - like fixing Chaining issues, and documenting projects.
• Responsible for Database objects performance tuning
• Tools/Skills set include the following:
• Create several Procedures, Functions, Views, Packages, Tables, Sequences, Synonyms, Indexes, Materialized
• Views, and Analyzing Oracle Objects and resolving Chaining issues in Oracle Databases.
• Analyze data and resolve Oracle related issues on a regular basis
• Use Oracle versions 9i 10g PL/SQL SQL PLUS for Back-End development of modules for the projects
• Use Oracle Discoverer versions 4.x 10g
• Use TOAD versions 8.0 8.x - up to the latest version - 8.5 , and PL/SQL Developer
• Use Windows NT/XP, Oracle 9i, Oracle 10g
• Use SQLLOADER for Data Loading
• Use Unix AIX
• Confidential
• Project - HR Benefits application
• Responsible for developing over 100 new Custom Reports, Import/Export Utility, Several Data Loading Projects, etc
• Responsible for Oracle development, PL/SQL Development, Oracle Forms Reports 6i/9i/10g.
• Loaded Data utilizing SQLLOADER, Oracle packages, functions, procedures Extensive PL/SQL Coding .
• Responsible for Data migration, Data cleansing, testing, trouble-shooting, problem-solving, and resolving issues as they surfaced. Imported and exported Oracle Objects.
• Handled PL/SQL code modifications, enhancements, and tuning.
• Designed, developed, modified, enhanced and tuned Oracle reports and Oracle Discoverer Reports.
• Created Tables, Triggers, views, materialized views, and SQL scripts
• Tools/Skills set include the following:
• Create several Procedures, Functions, Views, Packages, Tables, Sequences, Synonyms, and Materialized Views
• Create several new custom Reports
• Perform several Data Loads
• Create new Forms and modify existing ones
• Analyze data and resolve Oracle related issues on a regular basis
• Deploy some Forms and Reports to the web
• Use Oracle versions 9i 10g PL/SQL SQL PLUS for Back-End development of modules for the projects
• Use Oracle Developer 6i Forms 6i and Reports 6i
• Use Oracle Developer 10g Forms 10g, Reports 10g, and Graphics 10g
• Use Oracle Discoverer version 10g
• Use TOAD versions 8.0 8.x - up to the latest version - 8.5
• Use Windows NT/XP, Oracle 9i, Oracle 10g
• Use SQLLOADER for Data Loading

Oracle Database/PL/SQL Development, Oracle Developer- Independent Work/Project

• Project - Transportation Application
• Worked on PL/SQL modifications/enhancement.
• Analyzed data, trouble-shoot/researched issues dealing with Oracle 8i/9i databases.
• Performed Oracle database tuning for database objects and data warehouse objects.
• Resolved row migration and chaining issues exposure to Informatica.
• Documented some PL/SQL and SQL codes as well as other database objects.
• Project - Vehicle Permit Application for Department Of Aviation
• Handled vehicle permits, entering companies' demographics, vehicle information, and billing companies for the permits.
• Project - Application for Recreational Departments
• Tracking of students' sports enrollments, team assignments based on age grades, payment history, activities enrolled in,
• coach assignments, and students' demographics.
• Tools/Skills set for above projects include the following:
• Data Modeling, Database development using Advanced PL/SQL 8i, SQL, SQLLoader, and SQL PLUS Scripting
• Responsible for creating and assigning roles and profiles to Database users
• Responsible for creating Procedures, Functions, Views, Packages, Tables, Clusters, Sequences, Synonyms
• Databases, Table spaces, and Snapshots
• Analyzed data and resolved Oracle related issues on a regular basis
• Trained/worked with Oracle 9i
• Developed some web enabled Forms and Reports for the Security Vehicle Permits project
• Responsible for deploying client/server Forms and Reports to the web
• Used Oracle versions 8i 9i PL/SQL SQL PLUS for Back-End development of modules for the projects
• Trained/exposure to Oracle Portal and Oracle Workflow, and Oracle 9iAS
• Used Oracle Developer 6 Forms 6 and Reports 6
• Used Oracle Developer 6i Forms 6i and Reports 6i
• Used SQL Server 2000
• Used Oracle Discoverer versions 3.1 4.1.x
• Used TOAD versions 6.0.4 7.3
• Used Windows NT/98/2000/XP, Oracle8 8i Enterprise Edition, Oracle 9i, Oracle 8i, Oracle 8x
• Created, tested, debugged, and implemented Oracle database application project modules utilizing Oracle8.x, Oracle8i, and Oracle8 Enterprise Edition, SQL PLUS, PL/SQL 8.0.5, PL/SQL8i, SQLLDR, TOAD - versions 6.0.3 and 6.0.4 , MS Access 2000 and Excel on Win NT/98/2000 - including Oracle Procedures, Views, Functions, Packages, Triggers, Data Manipulation, Data Conversion, Data Load, Data Extraction, Tables, Indexes, Synonyms, Snapshots, Sequences, Table spaces, and Clusters.
• Worked closely with DBAs and other team members to plan, test and implement several Oracle database related projects for customers.
• Analyzed data on a regular basis.
• Created, updated, tuned and modified Oracle Procedures, Functions, Packages, Tables, and View for better performance.
• Developed Project scopes, test plans, executed the test plans, and assisted in projects implementation.
• Participated in deploying client/server Forms and Reports to the web.
• Participated in team/customer conference calls/meetings to discuss new and existing database projects and other related issues. Maintained daily operation of proprietary applications.
• Developed and ran Oracle reports queries on daily basis for data extraction utilizing SQL and SQL PLUS.
• Performed Functional and data requirement analysis, and some light DBA work. Involved in researching, analyzing, troubleshooting, and resolving Oracle related issues as they materialized.
• Recognized by senior management for outstanding performance resulting in receiving some days off bonuses.
• Met projects deadline.
• Always on call for after hours projects in-progress as the project manager.
• Performed customer database cleanup projects consisting of millions of records/transactions to enhance and tune the database for better performance

Confidential

• Performed Functional and data requirement analysis, and some light DBA work.
• Participated in the Development of Y2K Application using Oracle8 Enterprise Ed., PL/SQL 8.0.5, PL/SQL8i, SQL PLUS, SQLLDR7.3, Oracle 8.x,
• Oracle8i, VB, MS Access97, Crystal Report version 7, Developer2000 Forms 4.5 and Reports 2.5 , Oracle Developer 6 Forms 6 and Reports 6 , and other related tools.
• Developed several Oracle related new modules projects utilizing PL/SQL, SQL, Procedures, Views, Triggers, Synonyms, Indexes, Functions, Packages, and Snapshots on Windows NT, Novel, Windows 95/98/2000 Operating Systems.
• Researched, analyzed, troubleshoot and modified existing modules to fix defects.
• Used TOAD versions 6.0.2 6.0.3 .
• Analyzed data on a regular basis.
• Researched/exposure to HIPAA standards and requirements.
• Involved in constantly testing Back End and Front End of Oracle Application Modules for performance and correctness.
• Utilized/Worked on VB 6 troubleshooting and Seagate Crystal Reports version 7 reports generation .
• Updated, enhanced, and modified Oracle Procedures, Functions, Triggers, Packages, and Views
• Developed test plans and executed the test plans.
• Created test scripts for Back end testing of modules developed.
• Formal training, exposure, good knowledge, and some experience in ASP.
• Participated in the development of user documentations and Online Help for the Y2K applications project.
• Utilized Clear Quest software for defect tracking, recording and updates.
• Sometimes on call for oracle related issues as the only Oracle Developer on my team.
• Utilized Source Safe software to add, check-in and checkout new and existing code modules.
• Worked hand-in-hand and one-on-one with VB as well as Crystal Report Programmers on Defect fixes as well as on new Module Development to check for data integrity and data correctness as the only Oracle Database Developer on the team

Confidential

Used TOAD version 6.0.2. Analyzed data on a regular basis. Performed Functional and data requirement analysis, and some light DBA work. Utilized Oracle8 Enterprise Edition, Oracle 8.x, SQL, SQL PLUS, PL/SQL8.0.5, Stored Procedures, Views, Tables, Functions, data Manipulations, and Packages to maintain and update existing Applications code on Win NT/95 and Unix

Confidential

• Utilized ORACLE7.3.x, SQL PLUS, PL/SQL2.3, SQL PLUS Reports, SQL, Stored Procedures, functions, Triggers, Indexes, Sequences, Tables, and Views on Sun Solaris Unix operating system.
• Used TOAD version 6.0.2.
• Analyzed data on a regular basis.
• Performed Functional and data requirement analysis, and some light DBA work.
• Involved in CBT Training on Sun Solaris, Unix Shell scripting, Vi editor, and web forms creation HTML

Confidential

• Performed functional and data requirement analysis.
• Designed logical data modeling using entity-relationship technique.
• Created and ran reports on patient accounts, medical records, patient admissions, etc.
• Modified, updated and maintained existing program report codes at the requests of customers

Confidential

• Responsible for consulting using - Oracle 8 Enterprise Edition, Oracle 7.3.x, Developer 2000, PRO C.
• Performed functional and data requirement analysis, and some light DBA work.
• Designed logical data modeling using entity-relationship technique.
• Developed students' classroom scheduling software using Oracle and its tools PL/SQL2.3, SQLLDR7.3, SQL PLUS, SQL, Procedures, Functions, Views, Packages, Indexes, Tables, Sequences, SQL PLUS Reports, etc. , PRO C, and Developer2000 Forms 4.5, Reports 2.5, and Graphics 2.5 on Windows NT and Windows 95.
• Developed Test Plan for testing the software and helped execute the test plan to test the software

Confidential

• Tools used included- Oracle7.x, Developer 2000 for 6months - Forms 4.5, Reports 2.5, and Graphics 2.5 , C/C , UNIX, win 95. Trained students in mathematics, computer science, personal finance and G.E.D.
• Supervised and managed youth in classroom settings.
• Consultant for part-time projects utilizing Oracle7.3.x, Solaris UNIX, IBM Mainframe and Windows OS Procedures, functions, Views, Packages, PL/SQL 2.3, SQL, SQL PLUS, PRO C, HTML, NETSCAPE, WEB PAGES, SQL PLUS Reports, Indexes, Tables, and Sequences to develop projects during summer vacations - 24 months total time

Confidential

• Performed functional and data requirement analysis.
• Designed logical data modeling using entity-relationship technique.
• Created the physical database and populated the database.
• Designed a relational database management system using Oracle8 Enterprise Edition, Oracle 7.3.x and Oracle8x.
• Developed a status tracking software application for a building maintenance and repair client using Oracle and its tools PL/SQL 2.3, PL/SQL 8x, SQL PLUS, SQL, Procedures, Functions, Views, Packages, Tables, Indexes, Sequences, SQL, SQL PLUS Reports, etc. , and Developer 2000 Forms 4.5 and Reports 2.5 on Windows NT/95

Confidential

• Involved in C/C and Java Programming languages designed, developed, documented, and executed programs .
• Conducted Microsoft Office package Word, Access, PowerPoint, Excel Lab trainings, HTML, Netscape, Web Page Designed, and developed web applications .
• Conducted Web Page design development trainings for students in lab settings.
• Utilized Elm, Vi and Pico Editors, and WordPerfect.
• Designed, coded, and implemented Compiler project utilizing C/C on Sun Solaris UNIX, Windows 95 and Mainframe platforms. Served as Consultant for Part-time projects utilizing Oracle7x PL/SQL8x, SQL, SQL PLUS, SQL, Procedures, Functions, Views, Packages, Tables, Indexes, Sequences, SQL PLUS Reports, Shell Scripting, etc. and Developer 2000 Forms 4.5 and Reports 2.5 .
• Designed and developed Personal Web Home Pages utilizing different Netscape browsers.
• Managed and supervised both graduate and undergraduate students and