Oracle Apex Application Development

Summary of Qualifications

Over **+ years of planning, designing and developing solutions with outstanding diplomacy that consistently produces win-win results for customers. Ability to work effectively in a team environment and with executive management. Many years of experience with .NET framework, ASP.NET, JavaScript, Plateau LMS, PRD, VBScript, IBM Cognos, Business Objects, Maximo 7.5, Maximo 7.6, ServiceNow, Oracle APEX, BDNA, Technopedia, BIRT, Tableau, PowerBI and MicroStrategy reporting platforms.

Experience

iVision Inc. (Boyds, MD) Nov 2021 – Present

EA Technical SME – SSA & NOAA (Oracle APEX, Planview, ServiceNow)

Designed and developed interactive web applications using Oracle APEX for NOAA Fishery loan application.

Created custom reports and dashboards using Interactive Reports and BI Publisher in Oracle APEX system.

Built backend logic in PL/SQL packages, procedures, functions, and triggers to support APEX application functionalities, such as automatically send out emails to loan borrowers and generate notifications to loan officers shown on application dashboard.

Automated data integration and reporting tasks to improve operational efficiency and system stabilities.

Created and modified SSA customized BIRT reports for applications used in the organization, and drilldown reports to provide detail information, so users have easy access to the information needed.

Gather and analysis requirements for migrating Planview to ServiceNow, propose solutions to customers for easy transition to new system.

Utilized PowerBI to create graphic reports, charts and dashboards to demonstrate how PowerBI can help customers understand their data and provide visual views of their business.

Technologies: Oracle APEX, ServiceNow, PowerBI, Planview, BIRT, SQL Server

VSolvit LLC. (Washington DC) May 2019 – Nov 2021

Senior Software Engineer – Bureau of Engraving and Printing (Maximo / Oracle / BIRT / Tableau)

Utilized Tableau reporting tool to create reports which connect to MSS system and Maximo system to generate reconciliation report for reconcile inventory items balance, and reports which compare inventory item records and work order records to verify syncing accuracy between two systems.

Gather requirements from BEP water treatment department, facility maintenance department, security department and printing department, understand their needs and determine how they can use the Maximo system to improve their work processes.

Create/modify Maximo BIRT reports to generate and automatically email work orders to responsible parties; and generate reports for supervisors to oversee forthcoming work orders for 15 days or 30 days.

Technologies: Maximo 7.6, Maximo BIRT, Tableau, Oracle.

Perficient Inc. (Washington DC.) Nov 2018 – Mar 2019

Senior Maximo Report Developer – America Red Cross (Maximo / MS SQL / BIRT Reports)

Designed and Implemented Maximo BIRT reports library to automatically populates report headers with Red Cross logo, report title from report description defined in Maximo, populates the report design file name and its last modified date on the footer.

Created sophisticate reports based on report requirements, like reports that will update work order status based on how the report was generated and also populates work order history entries.

Created audit log report that will generate the report’s core dataset query dynamically based on the selected audit table, and allow the report to generate the audit report for any audit table(s) defined in the Maximo system.

Created many others reports to fulfill the most complicated America Red Cross report requirements.

Utilized Atlassian Jira software to configuration Service Desk for tracking issues.

Technologies: Maximo 7.6, Maximo BIRT, Atlassian Jira, JavaScript, HTML, DB2.

Free Alliance LLC. (Leesburg, VA) Jun 2017 – Jun 2018

Senior Report Developer/Application Administrator - HHS Site (Troux / MicroStrategy / MS SQL)

Setup and configured MicroStrategy 10 on Dev and Production environments to migrate BIRT reports in Troux system.

Imported Troux datamart database into MicroStrategy Architecture, created facts, metrics and attributes so they can be used to create report in MicroStrategy, also allow users to create their own ad-hoc reports.

Created data cube to pre-process the data which used by some of complicated report to improve performance.

Responsible for user and MicroStrategy system administration.

Gathered new report requirement, create new MicroStrategy reports, test and deploy reports to Dev and Production environments.

Maintained and monitored Troux EA Application to ensure system performance, functionality and reliability, which include database server and web servers.

Conducted Troux application administration and helpdesk support.

Technologies: Troux 9.5.3, MicroStrategy, BIRT, SQL Server 2015, BDNA, Technopedia

Rivermatrix. (Columbia, MD) May 2016 – May 2017

Senior Maximo Report Developer - DOD Site (Maximo / MS SQL / BIRT Reports)

Designed and Implemented Maximo BIRT reports for Budget, Procurement, Operational & Maintenance and warehouse departments.

Setup and configured Report development Environment for Maximo 7.6 which includes SQL server setup, configuration, Database sync with Production environment.

Assist with upgrade of Maximo 7.5 to Maximo 7.6.

Technologies: Maximo 7.5, Maximo 7.6, Maximo BIRT, JavaScript, HTML, SQL Server 2008, SQL Server 2010

iVision, Inc. (Boyds, MD) Oct 2014 – May 2016

Senior MicroStrategy Report Developer - DOE Site (MicroStrategy / MS SQL / BIRT Reports / Troux)

Installed and configured MicroStrategy on development server and testing server.

Installed MS SQL 2008 R2 on all Environments for MicroStrategy data storage.

Setup data model within the system which imports metadata into MicroStrategy data warehouse, to provide data access for users to create ad-hoc reports.

Setup user groups and privileges to control access to projects, setup security filters to limit data access.

Implemented MicroStrategy Transaction Service input forms to collect data for Cyber Security data call, design database schema for data collection and implement MicroStrategy project to produce reports for the data call.

Configured MicroStrategy mobile to allow users to access the MicroStrategy system via mobile devices.

Outsourced to Planview Inc. and worked closely with the Troux support team to implement customizations and reports development for their clients PNC Bank and Raytheon.

Worked on an in-house application BDNA Data Collector using C#.NET, to connect to the BDNA data warehouse web service components to pull technology information, process the data into different formats, such as json file, xml file, SQL database or XML files which can be imported into Troux system.

Technologies: MicroStrategy 9.4.1, BIRT, Troux 9.1, SQL Server 2008.

Knowledge Advantage, Inc. (Gaithersburg, MD) Sept 2013 – Jan 2015

Senior Maximo Report Developer - DOD Site (Maximo / MS SQL / BIRT Reports)

Designed and Implemented complicate BIRT reports for a in-house Maximo asset management system, including bar charts, pie charts, drill down sub-reports and also provide navigation capability within the report.

Gathered report requirements from Maximo users and department managers, analysis requirements and draft mock ups.

MS SQL Server administration for the Maximo 7.5 database.

Technologies: Maximo 7.5, Maximo BIRT, JavaScript, HTML, SQL Server 2008, SQL Server 2010

iVision, Inc. (Boyds, MD) Sept 2008 – Sept 2013

Senior Software Developer (.NET / JAVA / Reports)

Lead for the development of Dashboards, Data Collection, ETL, Reporting (BIRT & Cognos) efforts for the Troux EA repository system using Agile Methodology.

Develop Cognos data cubes to provide instead data result for users to create ad-hoc reports.

Configure Cognos framework to build Business Intelligence reports via Report Studio and Query Studio.

Gathered requirements working with stakeholders at various levels and documented their business requirements and IT challenges

Developed interface with Sharepoint portal and department tools using SOAP web services API in C#

Developed and conducted training for developers on writing SQL queries and creating visually appealing reports on SQL Server backend and datamarts in Troux system.

MS SQL Server administration for the Troux system, which includes SQL server data backup, restore, create store procedures and functions.

Developed sophisticated reports using PRD (Plateau Report Designer) in Plateau LMS system.

Developed in JAVA servlet, XML, CSS, XSL, HTML, JSON, JavaScript, ASP, VBScript, HTML, Tomcat and MS IIS to provide secure thin-client web portals access.

Technologies: .NET C#, ASP.NET, SOAP web services, JAVA, JSON, XML, CSS, HTML, JavaScript, ASP, VBScript, HTML, Tomcat, MS IIS 7, SQL Server 2005, SQL Server 2008, BIRT, COGNOS

XTS, Inc. (Columbia, MD) Sept 2006 – Sept 2008

Senior Integration/Solution Architect

Worked on projects managed using SDLC and full life cycle support

Developed Business Intelligence Reporting framework to allow thick client, visually modeled data to be shared using a reporting framework designed and managed to allow maximum flexibility for users and ensuring that uptime of the production application was close to 100%.

Developed remote installation scripts using VBScript along with TMA deployment modules with the Troux product set. Installation scripts supported Windows XP, Windows Vista and Windows 7 environments.

Instrumental in developing Cognos reports and setting up the Cognos environment to allow remote development of web-based reports in Troux application. Designed, develop and manage the datamart structure along with regular backups for the production database instance. Incorporated custom queries, views and stored procedures.

Maintained and enhanced the front-end ASP application comprising of Java Applets for navigation, XML for customized report menu, and JavaScript for dynamic content display

Developed a flexible navigation framework within the Troux Architect for allowing users to efficiently navigate through the models and submodels. Using VBScript, XML, COM/DCOM and Business Objects Crystal Reports, users had the ability to browse, search and analyze their data to ensure decisions were made based on the available data within the EA Repository.

Technologies: .NET C#, ASP.NET, ASP, COM/DCOM, SOAP web services, VBScript, JAVA, XML, CSS, HTML, JavaScript, ASP, VBScript, HTML, Tomcat, MS IIS 7, SQL Server 2005, SQL Server 2008, Business Objects

STG, Inc. (Rockville, MD) March 2006 – Sept 2006

Senior Systems Engineer

Developed the backend stored procedures for extracting the EAMS from the SQL Server database and designed artifact-based reports that have been presented to the HHS user community

Designed and developed Visual Basic (VB) Dynamic Link Libraries (DLL) used in COTS product that generates reports in MS Excel or XML format to populate model instances, relationships, properties and counts from the Metis model view

Migrated the backend environment for client from Oracle to SQL Server 2005. Administrated, installed and configured the full SQL Server 2005 environment to meet the performance and scalability needs of the client

Enhanced features and performances of the HHS EA PI Metamodel library to boost usability and performance in the COTS product dashboard PI. Improved performance of the unsupported Metis user-interface components (UICs) by 6,000%. Out-of-the-box performance of the UI components from Troux allowed generation of components in about 30 minutes. After performance enhancements and code optimization, the same generation of components, within the tool, was consistently tested at 30 seconds.

Technologies: Visual Basic, EAMS, ASP, COM/DCOM, SOAP web services, VBScript, JAVA, XML, CSS, HTML, JavaScript, ASP, VBScript, HTML, MS IIS 6, SQL Server 2000, Oracle, Business Objects

Createch, Inc. (Hong Kong, China) July 2005 – October 2005

Senior Software Engineer

Performed market research and analysis for P2P photo and file sharing through the internet.

Design a P2P application that can be easily enhance in the future, and also be user friendly and competitive.

Develop a multi-tier system using VB.Net and Python to provide rich functionalities for ordinary users wish to share with their friends and families.

Technologies: VB.NET, ASP, P2P, COM/DCOM, VBScript, XML, CSS, HTML, JavaScript, ASP, VBScript, HTML, Python

Mantas, Inc. (Reston, VA) July 2000 – June 2004

Senior Software Engineer

Designed and developed thin client GUI applications for telecommunication fraudulent detection system using JAVA, XML, CSS, XSL, Javascript and Tomcat. Implement JAVA servlets to centralize webpage requests and responses handling, such as database connectivity, data retrieval, signal sign on, session control; construct XML stream data for XSL/CSS transformation.

Utilized Visual Basic 6.0 & .Net, Seagate’s Crystal Report 9.0, VideoSoft 7.0 and Infragistics to build a GUI templates and DLLs for common functionalities that can be easily incorporate into other applications.

Developed high security web applications for generating reports for monitoring performance measurements throughout the network, using Visual InterDev 6.0, VBScript, HTML, JAVA and ChartFX 2000.

Managed and controlled source code integrity across multiple development and production projects with Microsoft Visual Source Safe.

Analyzed customer functional requirements for the revenue assurance system for the Cavalier® telecommunication, for usage and facility billing verification.

Developed a highly reliable and flexible centralize application in Oracle 8i using PL/SQL to monitor Williams® Telecommunication’s production servers health status. The application sends out email to the support team member to report servers’ status, data processing status, monitor Oracle jobs and procedure status and collect data for performance report of each server.

Technologies: JAVA, XML, CSS, XSL, Tomcat, JavaScript, VB 6, VB.NET, Crystal Reports, VideoSoft 7.0, Infragistics, ChartFX 2000, Visual InterDev 6.0, VBScript, MS Visual SourceSafe, Visual Basic, Wise Installer, Oracle, Design Alert Manager, Case Tracker, Cavalier, PL/SQL, Oracle 8i, Unix, Bill Manager, Bill Viewer

MeesPierson (Hong Kong, China) Sept 1999 – Mar 2000

Senior Systems Engineer

Designed and Implemented applications using Visual Basic 6.0 and VideoSoft data reporter to generate Trade Commodity Finance (TCF) banking performance reports.

Setup system tests, debugs, quality assurance, application deployment and user training.

Technologies: Visual Basic 6, VideoSoft, MS SQL Server 6.5

Alltel Information Services Ltd. (Hong Kong, China) June 1998 – Sept 1999

Software Engineer

Developed user-friendly applications for Trade Commodity Finance billing system using Delphi 3.0 and MS SQL Server 6.5. Applications include Letters of Credit (LC) application for banks to issue LC letters for their trading clients, the importer; and LC Advice maintenance application to generate advice letters to advice the exporter that the trade is guaranteed by the bank. Letters of credit and LC advice are the most critical documents on each international trade.

Designed SQL Server database architecture using PowerDesigner to improve the performance and stability of the existing product.

Developed common GUI templates; create library components, to be used in all GUI applications to improve productivity and standardize functionalities through all units.

Technologies: Delphi 3.0, MS SQL Server 6.5, PowerDesigner, SWIFT

Summit Research Corp. (Gaithersburg, MD) January 1998 – April 1998

Software Engineer

Created Visual Basic 5.0, Access 97 and Crystal Report base application for National Institute of Standard Technology (NIST) to generate monthly and yearly reports to keep track of multi-million dollar contract billings.

Developed a centralize web portal and intranet applications by using HTML, FrontPage 98 and IIS4.0, MS InterDev 1.0 and VB Script.

Maintained LAN and WAN, including client administration, email server. Troubleshoot enterprise software and hardware system to ensure proper user application accessibility.

Technologies: Visual Basic 5.0, Access 97, Crystal Reports, MS InterDev 1.0, VBScript, HTML, FrontPage 98, IIS 4, LAN, WAN

Education

University of Maryland at College Park, Sept 1991 – May 1996, BS in Electrical Engineering

Technology SKILLS

JAVA servlet, XML, CSS, XSL, HTML, JavaScript, ASP, VBScript, HTML, Tomcat, MS IIS, Troux Metaverse, Troux Architect, Troux Team Server, BIRT, Eclipse, Cognos, Plateau LMS, PRD, Oracle 9i/10g, SQL Server 7.0/2000/2005/2008, Visual Studio 97, 2000 & .NET, Visual Basic 5.0 & 6.0, VideoSoft 7.0 and Infragistics, Seagate’s Crystal Report, Windows 95, 98, NT 4.0 Server, Win 2000 and Win XP, Microsoft Visual SourceSafe, Sharepoint, Web Services, SOAP, Maximo 7.5, Maximo 7.6, MicroStrategy 9.4.1, Atlassian Jira.

Qualification Highlights

Active DOD Secret Clearance

10+ years of reporting.

Excellent Technical Aptitude and Understanding of IT principles

Team player providing leadership and mentorship to other team members

U.S. CITIZEN

Contact this candidate