Oracle Database Lead Resume
2.00/5 (Submit Your Rating)
PROFESSIONAL SUMMARY
- Seasoned Information Technology (IT) practitioner with 35+ years’ experience and proven track record for development, delivery and operations of multiple complex enterprise technology initiatives and managing large enterprise operations to ensure alignment and support to Enterprise vision, mission, and goals.
- Expert Scaled Agile Framework (SAFe) practitioner for information, systems engineering, data science development; database architecture, data warehouse, data marts, BI, data dashboards and Artificial Intelligence leveraging on premise, Azure and Amazon Web Services (AWS) environments.
- Experience translating requirements into an architectural roadmap, framework and mobile first design and coordinating development of User Stories and Tasks within a release train to attain enterprise goals.
- Well versed with supportive and facilitative components for security, infrastructure, mobile devices, Internet of Things (IoT), operations technical support.
- Proactive identification of technical debt and architectural improvements needed for systems already in place.
- Provided stakeholders and business partners collaboration leadership, technical leadership, agile leadership, configuration management, standards, standard operating procedures, requirements facilitation, scripting, training; systems analysis/, design, development, implementation, quality testing, and documentation.
- Evaluation experience: bake off and selection of COTS and Open Source products, appliances, frameworks, platforms and architectures.
- Highly experienced with Waterfall, Spiral, RUP and Agile e.g. XP, Scrum, KANBAN, SecDevOps, CI/CD
- Experience with Linux / Windows, Oracle (APEX) / SQL Server/ .Net and Java technology stacks.
- Experience with scripting and automation tools for CM, Deployment, DevOps and QA: Jenkins, Maven, Subversion, Git, HP Quality Center, Eclipse, Puppet, Chef, Red Hat, CloudForms, and JBOSS.
- Experience with Agile Lifecycle Management (ALM) Tools: Rally, Jira, Rational Jazz, Team Foundation Server (TFS), Git, Bit Bucket, Confluence, SharePoint. Also, Microsoft Project & Plan view PPM Pro.
PROFESSIONAL EXPERIENCE:
Oracle Database Lead
Confidential
Responsibilities:
- Full scope responsibility for the delivery and maintenance of web - based database applications, decision support systems and business intelligence developed by the Investigative and Intelligence Applications Unit of the FBI dat support a variety of law enforcement and victims’ assistance functions.
- Planned delivery and development of one of the first Mobile Applications to ATO delivery into the AWS GovCloud by the FBI.
- Technical understanding of the virtualization, architecture and operational design of FBI’s GovCloud AWS implementation required to implement robust applications atop the platform.
- Provides wide variety of cradle to grave enterprise IT services including business requirements analysis, application development, data management, and security analysis.
- Provides as-is assessment, recommendations and implementation for systems architecture, enterprise data architecture, data modeling, data warehousing, data marts, & business intelligence.
- Provides Scaled Agile program & systems management support, training, mentoring, and coaching.
- Managing a portfolio of over 50 projects, Systems Operations and Development Operations for the National Institutes of Health National Heart Lung and Blood Institute (NHLBI).
- Management of risks, priorities, schedules and quality of the portfolio.
- Maturing the Agile practice and SecDevOps for NHLBI.
- Supporting System and Data Architecture and Agile transformation for Agile Software program supporting Federal Bureau of Investigation National Backstopping System (NBIMS).
- Developing and implementing new procedures and standards. Migration of the database application to an Oracle 12c Multitenant PDB. Performed the roles of DBA, PL/SQL Developer, Apex programmer and on-site manager.
Principal Data Architect
Confidential
Responsibilities:
- Supporting System and Data Architecture and Agile transformation for Agile Software program supporting Federal Bureau of Investigation (FBI) Combined DNA Index System (CODIS), highly complex forensic analysis tool, built using SQL Server and .NET, used nationally by law enforcement agencies.
- Developing and implementing new procedures and standards to improve efficiency of software delivery platform, including tighter integration of tool suite. Implemented STIG on local and AWS database instances. Maintenance of scripts for deployment into AWS CICM deployment pipeline.
- Defined functional and data requirements for Office of Comptroller of Currency (OCC) Enterprise Data Warehouse (EDW) which houses data for human resources (HR) and financial institutions.
- Provided leadership in transforming program from waterfall to agile methodology.
- Built HR operational data store (ODS) and Large Bank Data Mart on STAR Schema.
- Lead development of standards used to define OCC data Architecture.
- Contributed to special Innovation team directing high level architecture of EDW, Data Marts, Cubes and Formula Engine Architecture; recommended adopting new or improving existing technology such as Data Cubes and Formula Engines OLAP of Large Banks.
- Drove functional, data, and security requirements for EDW and Business Intelligence initiatives.
Principal Data Architect
Confidential
Responsibilities:
- Defined highly complex functional and data requirements for replacement of the SEC’s primary IT system, EDGAR.
- Analyzed redundancy in data submitted on various forms, result of stove-piped securities regulations implementation over time.
- Participated in analyses of specific technical topics to drive functional data requirements, physical storage, memory and topology.
- Analyzed shredding data from XML and XBRL sources to improve system performance.
- Performed deep analysis of security requirements for system modernization including decoupling of commissions organizational structure from application and security models.
- Provided expert written recommendations to stand up, sustain and use best practices for PMO.
Sr. PM, Scrum Master/ Tech Lead
Confidential
Responsibilities:
- Directed 35+ people (4 scrum teams) in Agile Development of the Patent Trial and Appeal Board End to End (“PTAB E2E”) Case Management System based on Angular, Oracle 11g, Java, Spring, and JavaScript
- Provided technical leadership and collaboration with team members and stakeholders in PTO’s CI/CD environment.
- Using the Scaled Agile Framework and Rally Dev as primary ALM tool to roadmap, plan releases and iterations (sprints) with product owner to prioritize stories deployed in each increment.
- Developed original (green field) logical and physical data models for the Oracle 11g Database schema for the application.
- Led FDIC Enterprise Data Architecture team of data developers, data modelers, and data architects in development of enterprise data architecture. Was responsible for peer reviewing and quality scans of the PL/SQL, Java and JavaScript code.
- Led requirements analysis for Enterprise Reference Repository, EDW, and Metadata Repository.
- Served as Project Manager for Business Intelligence and Data Mart projects and applications supporting FDIC.
Sr. PM, Sr. Enterprise Data Architect
Confidential
Responsibilities:
- Supported data stewardship and data governance for British Petroleum (BP).
- Supported FBI Enterprise Architecture (EA) and Technical Reference Model (TRM), enterprise data architecture, enterprise data repository and project management tasks; developed sophisticated hierarchical inheritance model to determine stewards responsible for specific technologies. Later re-developed using Oracle APEX.
- Supported DHS Chief Information Officer (CIO) Enterprise Data Management Office (EDMO) Data Management (DM) programs. Led Data Standards subgroup of DM Working Group. Participated in elaboration of NIEM standards. Developed data model to replace Data Assert Catalog with Data Asset Repository component of EA Information Repository. Contributed to revision of SDLC called System Engineering Life-Cycle (SELC) dat broadened framework beyond software development to include systems and software engineering. Chaired data naming standards working group to standardize on naming conventions and data products to be reviewed at specific SELC gates.
- Prepared briefings for delivery to the Secretary of Air Force. Provided Domain Models and Enterprise Vocabulary for Secretary of Air Force (SAF)-XC ontologies; represented in Ontology Web Language (OWL), Resource Description Framework (RDF) and Extensible Markup Language (XML). Identification and description of information assets and functional domains to support Air Force Smart Operations for 21st Century (AFSO21). Evaluated Search Engines. Analysis and strategies for jet-fuel saving with flight scheduling.
- Maintained Troux Metis repository to store EA metadata; Erwin models to reverse- and forward-engineer physical and logical database models to produce As-Is consolidated enterprise model of EPA’s water programs. Created To-Be model and transformation plans for new architecture.
- Provided policy, procedures, and standards used by data analysts and database administrators aligned with national and international standards for HHS Centers for Medicare and Medicaid Services. Created data models and managed metadata included in data dictionaries and repositories. Developed automated tools for metadata extraction and analysis; provided EA team with nomenclature and navigable taxonomy to control and classify atomic terms used to label data.
- Performed EIM support, data requirements analysis, business analysis, and data modeling. Created and validated logical data models and physical data models using Erwin, data directories and dictionaries, data flow diagrams, & business rules for FDIC.