Career Overview

I have over fifteen years of diverse experience in government and private sector contracting. I have been utilized throughout the software development life cycle on my various projects. My focus is developing enterprise architectures that align strategy, processes, and IT assets with business goals. My technical strengths include information and access management, business intelligence reporting, database administration, ETL design, system upgrades and capacity planning, especially with Oracle tools and products. I've lead development teams and advised management staff on architectural issues for enterprise systems. Along with my technical abilities, I have strong presentation skills, particularly simplifying complex concepts to business stakeholders in persuasive, informative deliverables.

Skill Summary

Enterprise Architecture, Capacity Planning, Performance Tuning, Identity and Access Management design and implementation, Oracle Database Administration, Database Design, Data Warehouse Design, Database Implementation, Data Acquisition and Transformation, PL/SQL, Oracle EBS Applications, Oracle Business Intelligence Enterprise Edition 11g, Oracle Weblogic Application Server 11g Administration, Web Services, UNIX and Linux Shell Scripting.

TOOLS

Oracle 10g / 11g RDBMS, Oracle Weblogic 11g, BI Publisher, Oracle Portal, Oracle Warehouse Builder, APEX, Oracle Forms 6i, Oracle Reports 6i, PL/SQL, TOAD, Apache, Erwin, Oracle Data Modeler, PSFTP, Putty, Exceed, Rational Clear Case Clear Quest, JDeveloper, XML, XSL, XSLT, WSDL, SQL, Oracle Directory Manager, OIDDAS, SQL Loader, Informatica, OIBEE, OIM, OIA, OVD.

WORK EXPERIENCE

Confidential

Business Intelligence

• Develop high-level design HLD documents to depict business processes
• Develop migration plans for J2EE applications from OAS 10g to Oracle WebLogic 11g
• Design enterprise drawings depicting current and target postures
• Analyze business and technology challenges, assess costs, and propose solutions
• Apply formulas for proper sizing of server resources to scale for expected concurrent user thresholds
• Design customized user process documentation for OIM provisioning requests
• Design SOA architecture for communications between identity systems
• Worked directly with senior management on requirements development
• Document best practices and guidelines for selecting, developing, and implementing IT systems within enterprise.
• Design system objects and approvals using Oracle Design Console
• Use Adapter Factory to build connectors
• Create OIM accounts and requests through Java APIs
• Add modify LDAP attributes with Java APIs
• Build web services to expose resource objects such that specific entitlements can be added or removed through api call
• Use JDeveloper to design, edit, and deploy SOA composites

Business Intelligence

• Install, administer and configure Oracle Business Intelligence Enterprise Edition 11g
• Create metadata repository
• Design, develop, and distribute historical and audit reports using BI Publisher
• Design BI solution with Adobe Flex

Database Administration

• Install, administer, and configure Oracle 10g 11g RDBMS
• Design database and application architecture to meet security requirements
• Conduct performance tuning analysis and improvement
• Perform database patches and upgrades

Systems Administration

• Install, administer, and configure Oracle 10g 11g RDBMS
• Install, administer, and configure Oracle Weblogic 11g 10.3.2 10.3.5
• Install, administer and configure Oracle Identity Manager 11g R1, R2 9.1.0.1 then patched to BP17

Data Migration

• Design and Developed Informatica Power Center mappings to transform the source data to the new data mart schema
• Document the existing ETL process to gather data from source tables to the new data mart schema
• racle Forms 10g development for financial collection system
• Analyzed data matching results and advise client on data cleansing topics.
• Maintained Erwin model
• Managed software build release schedule and versioning
• Developed a web application using JSP and Apache Struts on an Oracle 10g Application Server platform
• Migrated workflows between development, test and production environments
• Designed and implement ETL process using Java SAX, Sql Loader, Shell Scripts, Scheduler Jobs, PL/SQL code and Informatica
• Integrated Oracle Identity Manager Oracle Role Manager with 3rd party systems as well as Oracle database iteration.
• Developed PL/SQL packages for OID maintenance, workflow, user administration, code generation, etc.
• Administered OAS10g, OID, Solaris 10, Discoverer, etc.
• Managed tasks for tech team and guided them as necessary
• Managed developers schedules, tasks, and code reviews
• Used OBIEE BI Publisher to deploy and share reports as web service
• Used OBIEE BI Admin tool to define meta data layer for end user access
• Worked closely with government client to define executive reporting needs and architecture.
• Led technical decisions related to system architecture and integration.
• Develop an ETL solution utilizing DataMigrator and PL/SQL code
• Designe and Developed Power Center mappings to migrate legacy data to Oracle data warehouse
• Perform risk analysis and planning for ETL processes
• Created infrastructure documents with recommended OIM, ORM, and OID system design for development, testing, and production systems
• Technical lead for the Oracle Identity Manager and Oracle Role Manager components
• Create testing framework for all application code
• Developed PL/SQL stored program units to satisfy application requirements
• Developed Oracle Portal interface for main menu page
• Generated XML data for reporting
• Designed and implemented database objects to support functional units
• Made application architectural recommendations to mitigate engineering problems
• Produced ad hoc database reports to help enforce standards and meet project timeline
• Stayed abreast of software tools and frameworks related to our development needs
• Made presentations on software solutions to team members

Senior Consultant

• Oracle Portal lead developer and administrator
• Created Executive Dashboards using Oracle10g, Apache, Flash, and XML
• Ad hoc ETL procedures for transforming disparate legacy data into Oracle 10g
• Used AJAX framework on many web applications
• Presented technology briefs and recommendations to management on emerging technologies

Senior Consultant

• Gathered requirements for C A application
• Conducted field study on COTS products e.g., Documentum, Xacta, and others
• Used Erwin for modeling
• Migrated applications to 10g
• Created workgroup applications with HTML DB or PL/SQL Toolkit

Senior Consultant

• Used Toad, Oracle 10g RDMS, Oracle Portal, JDeveloper, CVS, Qdesigner and others to accomplish daily tasks
• Used PDK to create Web applications and integrate them with OracleAS Portal
• Created database logical and physical design using Qdesigner
• Managed single sign-on, directory integration, caching, and security with Oracle Portal
• Performed Tuning, Maintenance, and Backups of Database server
• Created and manage triggers, indexes and database performance
• Created user-defined objects and object types
• Generated BC4j Views and Object
• Provided guidance to Java developer on development issues

Senior Consultant

• Used Toad, Oracle 9i RDMS, Websphere, Rational Tools, Erwin, Xemacs and others to accomplish daily tasks
• Created and maintain VPD policies
• Used OEM to create and manage user accounts, profiles, and groups within Oracle Portal
• Created custom templates for interfaces within Oracle Portal
• Created user-defined objects and object types
• Generated Java classes using Jpub
• Interacted with team members and customer to meet application requirements
• Coded and maintain JSPs and JavaScript
• Investigated code deficiencies in a very complex environment
• Used UTPLSQL framework for unit testing pl/sql code
• Used Struts Framework for Java development

Senior Consultant

• Used Toad, Oracle 9i RDMS, Cold Fusion 5 and MX, Flash 5 and MX, Visio and other to accomplish daily tasks
• Created customized applications CFML, PL/SQL, Action Script, JavaScript for diverse workgroups within the Park Service
• Provided technical guidance to in-house DBA's

Senior Consultant

• Generated forms and reports using Oracle Web Portal.
• Assisted Sr. DBA in all DBA tasks such as tuning, security, DDL scripts, recovery, backup, etc. of Oracle 8i Database with over 300 tables and several hundred users.
• Created web forms and reports using PL/SQL Toolkit, HTML and JavaScript for validation.
• Created Procedures using PSP technology.
• Wrote database triggers for backend enforcement of business rules.
• Wrote complex packages, procedures and functions using PL/SQL.
• Reverse engineered forms into Designer 2000. Used Designer 2000 for data modeling and ERDs.

Web Developer

• Administered several department dynamic web applications with Oracle 8i as RDMS.
• Set Up Oracle8i Database Server in heterogeneous web architecture.
• Administered Domino server for department applications.
• Implemented and managed user rights and access controls to Oracle server
• Performed all DBA functions as needed daily for support of web team and customers
• Wrote database queries using SQL and PL/SQL that update and deliver dynamically driven web pages via Cold Fusion Server
• Administered Cold Fusion Server
• Wrote stored procedures, database triggers, functions and packages using Oracle's PL/SQL
• Managed several projects from Analysis phase of SDLC through Maintenance phase
• Built web-enabled reports using Crystal Reports integrated into Cold Fusion environment, that allow for user control through the browser

Systems Analyst/Programmer

• Conducted detailed analysis of large university's core database applications
• Produced ERDs, DFDs, FHDs system models during the analysis process of legacy systems and during the design of new applications written in Oracle
• Managed university's website as head Webmaster
• Managed and created users using Netscape Enterprise Server
• Wrote and managed Perl scripts used for text parsing, bulletin boards, form emails, etc.