• Strong technical, data analysis, problem solving, and troubleshooting skills.
• Consistently ensure software developed and maintain fits the business needs of clients.
• Dependable, flexible and adaptable to rapidly changing conditions.
• Continuously cited by managers for outstanding performance.
• Dedicated individual achieving reputation for consistently going beyond what is expected.
• Demonstrated ability to function effectively as a team player as well as working independently to achieve objectives.
• Quick learner taking every opportunity to enhance skills through classes, CBT's, experimentation, and on the job training.
• Involved in all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Loaded Data into Oracle Tables using SQL Loader.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Experience in Dynamic SQL and Exception handling.

EXPERIENCE

Confidential

Oracle Database Developer

• A member of a project team responsible for database, report and application development for the Defense Contract Management Agency DCMA , a Division of the Department of Defense. This project employs a vendor Web based Application with an Oracle database.
• Plan, design and implement application database objects, such as packages, procedures, views to support Cognos reporting and business applications.
• Provide production support by performing data analysis, identifying data issues and implement the necessary modifications.
• Technical mentor to database and Cognos developers.
• Work with business stakeholders, report developers and application developers across various functional areas to review and clarify new project requests then develop estimates for database design, development time, data migration, implementation and testing.
• Develop ER Diagrams using ERWIN and backward engineer via Toad Schema scripts.
• Manage workload of 5 or more simultaneous projects.
• Create database objects like tables, views, queries, materialized views for new enhancement in application using oracle tools like Toad, PL/SQL Developer and SQL plus.
• Develop PL/SQL triggers for automatic creation of primary keys.
• Create indexes on the tables for faster retrieval of the data to enhance database performance.
• Use hints to direct the optimizer to choose an optimum query execution plan.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Load Data into Oracle Tables using SQL Loader, Toad, and PL/SQL Developer.
• Partition large Tables using range partition technique.

Confidential

Oracle PL/SQL Developer

• A member of the Army Equipping Enterprise System AE2S team responsible for database and Oracle Business Intelligence Enterprise Edition OBIEE development for the Army Headquarters Department G8 Force Development. This project employs a Web base Application with an Oracle database running on Unix.
• Planned, designed and implemented application database objects, such as functions, packages, procedures, object types, pipeline table functions, and views to support business applications.
• Provided production support by performing data analysis, identifying data issues and implement the necessary modifications.
• Developed ER Diagrams using ERWIN and backward engineer via TOAD Schema scripts.
• Installed and Performed OBIEE upgrade from 10g to 11g.
• Created and modified repository using Oracle BI Admin tool.
• Created connection pools, physical tables and defined joins in the physical layer of the repository.
• Created dimension hierarchies and level based measures, in BMM layer based on requirements.
• Created presentation catalogs and organize tables and columns in presentation layer as per the requirements.
• Developed Reports with different Views like Pivot Table, Filter View, Chart, Column and View Selector.
• Created Interactive Dashboards using filters to avoid excessive data.
• Created Dashboard Prompts at dashboard and page level.

Oracle Database Developer

Confidential

• A member of a project team responsible for database and application development for the National Guard Advanced Information Technology Services AITS . This project employs a vendor Web based Application with an Oracle database.
• Planned, designed and implemented application database objects, such as packages, procedures, views, objects types, functions to support business applications.
• Provided production support by performing data analysis, identifying data issues and implement the necessary modifications.
• Technical mentor to less experienced engineering personnel.
• Worked with business stakeholders and application developers across various functional areas to review and clarify new project then develop estimates for database design, development time, data migration, implementation and testing.
• Used Agile methodology and SCRUM adoption to facilitate iterative development and better manage tasks assigned through sprints.
• Created use cases and prototype application using Microsoft SilverLight.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Used Pragma Autonomous Transaction to commit or rollback subprogram without affecting main program.

Confidential

Oracle Database Developer/Cognos SME/Sustainment Manager

• A member of a project team responsible for database, report and application development for the Defense Contract Management Agency DCMA , a Division of the Department of Defense. This project employs a vendor Web based Application with an Oracle database.
• Planned, designed and implemented application database objects, such as packages, procedures, views to support Cognos reporting and business applications.
• Provided production support by performing data analysis, identifying data issues and implement the necessary modifications.
• Technical mentor to database and Cognos developers.
• Worked with business stakeholders, report developers and application developers across various functional areas to review and clarify new project requests then develop estimates for database design, development time, data migration, implementation and testing.
• Developed ER Diagrams using ERWIN and backward engineer via Toad Schema scripts.
• Managed workload of 5 or more simultaneous projects.
• Created database objects like tables, views, queries, materialized views for new enhancement in application using oracle tools like Toad, PL/SQL Developer and SQL plus.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Used hints to direct the optimizer to choose an optimum query execution plan.
• Partition large Tables using range partition technique.

Confidential

Principal Software Developer

• A member of the Enterprise Data Warehouse team responsible for application development. This project employs a vendor Web based Application with an Oracle database.
• Developed, modified and tested reports using Cognos 8 suite Framework Manager, Query, Report and Analysis Studio and TOAD.
• Write unit test cases to catch development bugs before delivering to test team for system integration testing.
• Gathered client requirements based on the clients mission and vision.
• Migrated Cognos 7 Impromptu Reports to Cognos 8.

Confidential

Software Engineer/Cognos Application Developer

• A member of the SRA Enterprise Support Services ESS team responsible for application development and reporting on all military shipment data. This project employs a vendor Web based Application with an Oracle database.
• Developed, modified and tested reports using Cognos Impromptu Web Reports, Cognos Powerprompts, HTML, JavaScript and PLSQL Developer.
• Wrote unit test cases to catch development bugs before going into system integration testing.
• Developed triggers and materialized views to extract 1,000,000 records from oracle database creating fact and dimensions tables used for reporting.
• Migrated Reports to Cognos 8.

Confidential

Oracle Database Developer/Cognos Application Developer

• Member of development/production team responsible for reporting on corporate information. This project employs a vendor Web based Application with an Oracle database in a Unix environment.
• Designed and developed database structures and reporting structures using PL/SQL.
• Designed and developed reports using Cognos Impromptu Web Reports, Cognos Powerprompts, HTML and JavaScript.
• Worked with clients to define requirements for sales and marketing reporting cube using Cognos Powerplay. Learned tool and implemented cube on a very tight deadline. Maintained cube usability.
• Played key role in providing analysis of report data to assist in production support and report data validation.
• Modified and Maintained usability and correctness of Cognos Catalog and Reports.
• Provided on call production support to nightly build process.
• Developed Report Specification.
• Built on knowledge of Central Financial System to develop system interface.

Programmer Analyst

• Member of production support team responsible for on-going maintenance, modifications, and troubleshooting for Central Financial System.
• Created files and reports to satisfy user requests using JCL, Easytrieve and Reporter In house reporting software .
• Assisted with Budget Y2K project consisting of Reporter modifications and testing support.
• Developed new COBOL program for the Tax Department and implemented numerous ad hoc requests for data extracts and reports using Easytrieve and Easy Plus.
• Provided production support, problem investigation and resolution.
• Primary support for Accounts Receivable Subsystem.
• Performed ES 20 testing by working with clients to write scripts, run test and analyze results.
• Performed Y2K testing by writing Accounts Receivable Unit Test Scripts, assisted remediation team in setting up and executing tests, wrote test cases, captured and analyzed data, set up and ran test, resolved job abends and assisted Finance Accounting group in resolving issues from their on-line entry or review of reports.
• Instrumental in assisting new Programmer Analysts with technical questions, debugging and CFS training.
• Performed troubleshooting and production support on Financial Application built using Hyperion Essbase.

Confidential

Risk Analyst

• Member of risk management team responsible for analyzing mortgage loan portfolio and providing management with recommendations.
• Analyzed early default loans using Mainframe SAS.
• Designed, developed and produced reports based on observations.
• Maintained analytical systems and tools with modifications as necessary.

Computer Operations Specialist

• Member of computer operation team responsible for monitoring, tape management and printer output of nightly production schedule.
• Monitored operations of all data center resources using system consoles, CICS and Omegamon Monitors.
• Coordinated problem resolution with production control, corporate business partners, vendors and support staff.

TECHNICAL SKILLS

• Languages/Tools: Cognos Business Suite, Cognos Powerplay, Cognos 8, Hyperion Essbase, JavaScript, HTML, and Microsoft Visual Basic 5, PVCS Version Manager, Problem Tracker, PLSQL Developer, TOAD, ERWIN, SQL, PL/SQL, SQL Loader, SQL Developer, ER Assistant, SQL Developer Data Modeler, Oracle Business Intelligence Enterprise Edition OBIEE 10g Familiar UNIX Shell Programming and Informatica
• Databases: Oracle 8i, 9i, 10g and 11g
• Mainframe: Computer Associates Panvalet, IBM FileAid, SyncSort, AMS Core Foundation Software Reporter , Easytrieve, Easy Plus, JCL Job Control Language , COBOL, and some SAS experience.
• Operating Systems: Microsoft Windows 95/98/NT, UNIX Solaris , and IBM MVS/OS390.
• Other Software: UltraEdit programmers' file editor, Microsoft Office Suite 97, 2000, 2010 , Microsoft SilverLight.