SUMMARY:

• Senior software engineer with 10 years of IT consultant and development experience. Expertise in Oracle stack, including Data Management (Governance, Architecture, Transformation, Warehousing, Quality, Master Data Management (MDM)
• Integration), ETL, Enterprise Service Bus (ESB), Microservices, Oracle Enterprise Data Quality (EDQ), Oracle Data Integrator (ODI), Oracle E - Business Suite, Business Intelligence, Siebel, BPEL, APEX, and Oracle BI Publisher.
• Skilled in Java, JavaScript, Groovy, PostgreSQL, MySQL, SQL, and PL/SQL. B.S in Computer Science and Oracle PL/SQL Developer Oracle Certified Associate (OCA).

PROFESSIONAL EXPERIENCE:

Confidential, Fairfax, VA

Data Architect/Senior Data Engineer/ETL

Responsibilities:

• Used Oracle Data Integrator (ODI) platform to extract, transform, and load (ETL) data from 4 different upstream systems (Spectrum, Benefit Calculation and Valuation System (BCV), Genesis, and IPVFB) to an Oracle target database. I was able to analyze and evaluate the performance when it runs, and identify steps that might be inefficient against a baseline trend.
• Profiled legacy data using Oracle EDQ platform to discover the technical characteristics of the data to help the client find issues and identify data that is not fit for its business purposes such as candidate key columns, duplication, uniqueness, completeness and missing data.
• Developed a service bus (ESB) data flow using Oracle EDQ to standardize and ensure financial data is accurate on entry to be used by IPVFB. Executed procedures to identify data anomalies as they can significantly impact calculations.
• Converted the existing IPVFB (Integrated Present Value of Future Benefits) business rules program from Microsoft Visual Basic .NET to Oracle EDQ workflows using JavaScript or Groovy. As an OEDQ lead, developed high level business rules and adapters that calculates the averaging program for specific data items and then imputes a practical data value for invalid or missing data items.
• Accomplished a stable and firm data conversion processes from a variety of data sources including extraction, cleansing, validation and data mapping using Oracle EDQ.
• Implemented script processors using JavaScript or Groovy to define processing logic to transform and transfer data between specific systems that cannot be achieved easily using Oracle EDQ.
• Developed scalable solutions to support big data by designing and configuring Oracle EDQ to extract multiple batches in parallel.
• Optimized Oracle EDQ job performance as the data grew significantly with each quarterly import.
• Developed an agent using KornShell (ksh) to execute a sequential multi-step Oracle EDQ jobs based on the application requirements and to monitor progress for each step.
• Performed ETL failure recovery such as daily notifications on ETL workflow statuses to ensure no interruption in services.
• Monitored Oracle ETL workflows to provide detailed job reports and statuses.
• Designed, implemented, and maintained database objects such as tables, clusters, indexes, views, functions, stored procedures, packages, and queries using SQL, PL/SQL.
• Controlled migrations of programs, database changes, data changes and menu changes through the development life cycle.
• Experienced in database design, normalization, selective de-normalization, forward/reverse engineering of applications, and logical and physical data modeling using Oracle SQL data modeler.
• Assisted with impact analysis of any changes made to the database objects. In addition to troubleshooting problems regarding databases, applications and development tools.
• Created custom reports using Oracle BI Publisher 11g. In addition, optimized report performance through database tuning such as adding indexes, unique keys or adjusting SQL queries.
• Established an effective and compelling documentation on how to check for project errors, job failures, and migration steps to technical staff and product owners for debugging purposes in production environment.
• Preformed Agile software development methods to collaborate between technical and functional teams. These methods promoted adaptive planning, early delivery, and continuous improvement.

Confidential, Reston, VA

Senior Software Engineer/IT Consultant

Responsibilities:

• Profiled and analyzed customer and supplier data using Oracle EDQ profilers to check for duplicate records, patterns, record completeness, uniqueness, and examine value frequency to highlight possible issues.
• Merged multiple data models of disparate systems (Carter, OTS, and EIP) into one data stream to mark any duplicate records within each other.
• Implemented business rules in the “Deduplicate” processor to identify potential duplicates for Customer and Supplier data.
• Deployed different EDQ jobs to ingest 2 TB of data.
• Created a high-level documentation to technical staff on how to implement fuzzy logic match rules based on the business workflow and their data set requirements.
• Performed a proof of concept/demo to technical staff and product owners on how Oracle EDQ works and what are best practices to use the product for their environments. PC Connection, Merrimack, New Hampshire
• Customized, tweaked, and updated EDQ’s “Match Entity” process within the Customer Data Services (CDS) package to work with customer’s data in Siebel UCM (Universal Customer Master).
• Modified EDQ’s “Clean Address” process within the CDS package to cleanse, filter, and validate customers addresses in the United States with the help of Loqate.
• Created custom jobs to run in batch and real-time mode using Oracle EDQ.
• Implemented SQL, PL/SQL procedures, function to update tables pre/post Oracle EDQ jobs.
• Provided a complete and comprehensive documentation covering Oracle’s EDQ customized CDS package and how it is configured to their environment.
• Engaged with the customer to gather detailed information on how the business process works and what problems are we trying to solve to help me propose or recommend solutions and strategies to meet the customer’s needs and requirements.
• Restructured the logical data model or schema using 1st, 2nd and 3rd normal form concepts using Oracle SQL Data Modeler to eliminate redundancy, organize data efficiently and reduce the potential for data anomalies.
• Created real-time web service processes using Oracle EDQ to identify, standardize data problems and check data validity by applying business rules.
• Executed a web service to extract key data elements from free text fields using Oracle's EDQ parser processor and regular expressions in JavaScript.
• Implemented ETL scripts to perform data migration from one schema to another using SQL.
• Developed PL/SQL procedures, functions and scripts to be called from APEX webpage platform.
• Built a program in PL/SQL to generate XML files to feed the payload in the BPEL process.

Staff Software Engineer/IT Consultant

Confidential

Responsibilities:

• Worked as technical writer on a project with very high visibility where I was responsible for documenting critical business processes that involved handling invoices using Oracle E-Business iSupplier module.
• Trained a large group (300+) of end users using the documentation I created to apply and utilize the iSupplier model to process the invoices quicker.
• Planned, developed, and provided and staff development programs using knowledge of the effectiveness of methods such as classroom, demonstrations, meetings, and workshops.
• Migrated L.A County application from Oracle Forms / Reports 6i to Oracle Forms / Reports 10g.
• Modified and improved existing forms and reports to accommodate the new structure changes using Oracle forms and Oracle reports.
• Created a security role system in the application that enables/disables actions based on the user’s role.
• Implemented BPEL web services that are able to load nearly 1 million records from specific location into Oracle database tables. In addition to web services that report data load failures while procedures are active.
• Completed tutorials that are designed for software developers who are keen on developing best in class applications using open and advanced platform of Windows Azure.
• Educated myself on the architecture of cloud computing, types of cloud, and benefits of cloud.
• Created and deployed a website (proof of concept) into Azure as an app service using the model, view, controller pattern from visual studio.
• Learned the components of Azure and how it works such as execution models, data management, and networking.
• Generated and tweaked PowerShell scripts to perform tasks such as creating virtual machines to reduce time and effort.
• Monitored the VM statistics such as CPU percentage, disk read/write bytes, and network in/out to keep track of its performance and health.