OBJECTIVE:

To obtain a challenging position that will effectively utilize my strong skills and experience in Oracle Applications, Business Intelligence, ETL, Database Design and Development.

SUMMARY:

• Accomplished business and technology professional with over fifteen years of experience in full software development life cycle: requirement gathering, design, development, implementation, testing, production support, maintenance and administration.
• Extensive experience in providing technical and functional leadership to resources and customers to meet project deadlines and objectives.
• Excellent experience in Oracle EBS (GL, AP, AR, OE, INV)
• Extensive experience in providing guidance and create standard report.
• Thorough knowledge of Data Modeling: concepts, logical, physical data modeling, dimensional modeling, star and snowflake schema, fact aggregation.
• Expertise in SQL, PL/SQL, stored procedures, triggers, functions and packages.
• Solid OBIEE experience with: BI Publisher, BI Administration, Answers and Dashboard.
• Energetic self - starter who can adapt and learn fast, good team player.
• Excellent analytical, organization and problem solving skills.
• Excellent communication and interpersonal skills, strong customer service experience.

TECHNICAL SKILLS:

Oracle Expertise: Oracle Applications/Oracle EBS R11i/R12 - GL, AP, AR, OE, INV, Oracle Clinical (OC) 4.x, Oracle 8i/9i/10g/11gRAC, Oracle Enterprise Manager, Oracle Developer Suite 10g, Oracle Developer 2000, Oracle Warehouse Builder (OWB), OBI EE 10gOracle BI Discoverer 10g

Other Databases: MS SQL Server 2000/2008, MS Access, FoxPro

ETL: Informatica PowerCenter 8.1, SQL Server Integration Services

Data Modeling: ERwin, Toad Data Modeler, MS Visio

Languages: SQL, PL/SQL, T-SQL, XML, UNIX/Linux Shell Script, Java (Swing, AWT, JDBC, Servlet, Java Bean, RMI, etc), JSP, Java Script, ASP, Cold Fusion, Visual Basic, C/C++, C#

Operating System: UNIX, Linux, Windows 9x/NT/2000/XP/Vista/7, MS-DOS

Development Tools: SQL*Plus, SQL Loader, TOAD, Crystal Report, SAS, Integrated Review (IReview), Java Version of Review(JReivew), Medidata Rave, Clintrial, TKPROFJBuilder, Install Shield, MS Visual Studio, Serena PVCS, CVS, TortoiseSVN, dsNavigatordsNavigatorIAT, IIS, Tomcat, Converge

PROFESSIONAL EXPERIENCE:

Confidential, VA

Senior Oracle Applications Developer

Responsibilities:

• Use Oracle Applications/Oracle EBS R11i/ R12, modules include GL, AP, AR, OE, INV, Alerts, custom and extension modules.
• Lead projects development with both internal and external clients: including requirement collection, design, development, implementation, documentation, testing and user training.
• Prioritize and provide timely support to customers via Help Desk Support
• Monitor and analyze users requests, created SOP, document solution/guidance for Oracle team and end users
• Validate and test applications upgrades and patch installation on multiple tiers
• Identify system issue and work with Oracle Support on Service Request
• Detailed responsibilities include but not limited to: manager users; develop PL/SQL packages/procedures/functions/triggers; work on interfaces, customizations; create new forms; create new reports; create Linux shell scripts; monitor process
• Work extensively with department of Regulatory Affairs to create XML reports compliant with International Maritime Organization (IMO) and International Labour Office (ILO) policies and guidelines, including ISO compliant certifications.
• Create IRI Paycheck XML template when Oracle Applications is updated from R11i to R12
• Set up Payment Manager and XML Administration
• Document process and instruction, train users
• Work with multiple teams from IRI and Wells Fargo for electronic payment outsource
• Review Wells Fargo Payment Service specifications and proposal technical solutions to IRI Accounting team
• Lead technical design and development following SOW
• Customize Oracle EBS extraction for payment instruction; created template for eText format; set up Payment Process Profile; configure payment transmission; create shell script and set up cron job for file transfer
• Set up bank account and payment document
• Lead the testing: create testing cases; submit payments; monitor file transmissions
• Create process documentation for accounting team and Oracle team; train users
• Maintain and monitor process; troubleshoot
• Lead the project to provide sets of various combinations of documentations dynamically (document contents and copy numbers) and print in various papers
• Work with corp teams in multiple business centers to gather/consolidate requirements
• Create new forms/reports/request sets; build database tables/packages/triggers; set up CUPS printers; conduct test in multiple tiers
• Provide documentation and train user

Confidential, Rockville, MD

Oracle Clinical Programmer

Responsibilities:

• Reviewed cancer centers’ requirement, proposed solution to the functional requirements.
• Led the projects development and ensure the timely delivery of high quality work.
• Designed, developed and implemented Oracle databases in Cancer Center Clinical Data System.
• Developed procedures, functions and packages based on business needs.
• Extracted, transformed and loaded data from various sources to Oracle database.
• Created views, snapshots, extract data following standards for submission and monitoring.
• Administrated Oracle Business Intelligence (BI) Discoverer: create and maintain business areas, folders, items; Control user access; Create calculations, drills to support end user analysis.
• Managed Oracle Clinical (OC): control user interface configuration, grant user data access.
• Validated and tested software upgrades and patch installation on multiple tiers for OC, Oracle BI Discoverer, IReview, JReview.
• Supported, maintained and enhanced applications: troubleshoot, tune, and work with vendors.
• Provided customer support to broad range of users: conduct metadata replications, create complex reports, (BI Discoverer, IReview, JReview); instruct users to install application; track data processing between different applications, etc.
• Reviewed peers and clients’ database design and provide recommendations.
• Mentored junior team members and trained caBIG (cancer Biomedical Informatics Grid) users.

Confidential, Vienna, VA

Senior System Engineer

Responsibilities:

• Gathered/Reviewed requirements and provided design documents.
• Defined system requirements and set up working environment.
• Developed Oracle PL/SQL packages to facilitate data loading, coding data synchronization between databases.
• Developed the auto-loading of files from sFTP server into Oracle Database.
• Created documentation, provided database scripts and instructed clients to conduct application validation and testing.
• Generated complex reports for data analysis using PL/ SQL.
• Successfully developed SMQs (Standardised MedDRA Queries) auto-loading process for dsExplorer, a solution of safety data analysis.
• Supported clients for various issues, including MedDRA and WhoDrug/WhoDRL dictionary management, coding, data analysis and migration.
• Mentored and supported junior team members.

Confidential, Bethesda, MD

Programmer/Analyst

Responsibilities:

• Designed, developed and implemented template database in Cancer Center Clinical Data System (C3D), which was used as the standard for other databases, it greatly accelerated the database development.
• Developed and documented procedures, functions, packages, created testing cases.
• Created and maintained electronic Case Report Form (eCRF) instructions, which is widely used during user training, business rule reference.
• Created standard IReview reports supporting users from various groups, developed the manual of operation, it successfully reduced user’s effort to get data on time.
• Designed, developed, and implemented various databases.
• Monitored data inconsistency and helped user to clean data.
• Created reports using Oracle Discoverer and analyzed data from various resources.
• Reviewed protocols and recommended resolutions to clinical team.
• Generated snapshots, extracted data for internal and external review using SQL Plus, TOAD, IReview, and SAS.
• Extracted, transformed and loaded data from legacy system to Oracle database.
• Developed automatic email notification to monitor cron jobs.
• Identified user’s problems and proposed and implemented improvement process.
• Reviewed database design to ensure design meets standards and project requirements.
• Mentored junior team members.

Confidential, Gaithersburg, MD

Programmer/Analyst

Responsibilities:

• Administrated Oracle database.
• Designed and developed database using Clintrial as user interface tool.
• Developed, tested and documented PL/SQL packages for data validation.
• Generated reports for internal/external data review.
• Extracted data from Oracle database and prepared SAS datasets for data transfer.
• Installed and administrated Crystal Web Server, created Crystal reports.
• Validated and tested software upgrade.

Confidential, Rosslyn, VA

Software Engineer

Responsibilities:

• Installed and configured IIS web server, implemented security configuration.
• Administrated and maintained database on SQL Server and Access.
• Designed and developed web application Global Positioning Systems (GPS) using ASP, Congressional Correspondence System (CCS) using JSP.
• Designed, developed and documented Automated Risk Management System (ARMS), using Visual Basic and Access.
• Designed and implemented modules for the Budget database management System, used for GPS appropriation, spending, travel, etc.
• Created Crystal reports based on business needs.
• Created, defined and maintained the installation package of the desktop applications, using InstallShield under the Windows' operating system.