Greg Frank Email & Phone Number

El Dorado Hills, Ca, Us

Reading, Pa, Us

o Interact with all levels of client community (including representing company to client CIO) to provide time/effort estimates for critical issueso Define the architecture and approach to new data warehousing projects, incl. resource estimates for both hardware/software, people, timelines, and roadmapping dependencieso Perform hands-on evaluation of Snowflake (a columnar data store) as a cloud database for data warehousingo Evaluate NoSQL technologies as relational DBMS alternatives (Couchbase as JSON document store, Neo4J/Cypher as graph database)o Perform architectural analysis of existing projects to evaluate project effectiveness, incl. architectural modeling and visualization with Archimate, UML, BPMN, and OPM.o Project management (incl. staff management) of critical short-term projects through all phases, from analysis through to completion, including presentation of results to cliento Write Data Warehouse analysis methodologies and lead analyses using them, introduced Data Vault to the organizationo Evaluate methods to improve project effectiveness, incl. Scrum, Kanban, Scaled Agile (SAFe), TOGAFo Perform data modeling - third normal form (3NF), dimensional (star schema), and data vault with erwino Introduced Power BI as a dimensional modeling prototyping toolo Serve as data management subject matter expert (SME)o SQL tuning of large datasets (300TB+)

o Monitored database performance and performed troubleshootingo Performed SQL tuning and database software patchingo Submitted tickets to Oracle technical support and monitored them to ensure timely resolutiono Interacted with client community to design solutions

o Served as thought leader and data modeler on projects for major government cliento Designed operational databases with ER/Studio o Reviewed data models with client and performed business process analysis as input to detailed architectural analysis of contract proposals to understand gaps and omissionso Facilitated discussion on SOA/data integration issues and performed data integration planning, analysis, and design, including ETLo Supported internal software development, database design, and customer deployment planning, including hardware sizingo Analyzed and troubleshot database performance issues on customer siteo Wrote internal development process documentation

Dublin 2, Ie

o Managed day-to-day tasks of team of Oracle DBAso Analyzed and documented architecture to assess database enhancement needso Planned and designed database hardware for disaster recoveryo Evaluated options to secure highly confidential personal information in production databaseo Set direction for ETL and data warehousing, including initiating ETL and business intelligence (BI), and reported product evaluations for data martso Sought after to lead and develop data models for difficult issues o Recruited staff, performed annual evaluations, and planned and delivered trainingo Managed projects and activities with development groups for significant database tasks o Served as primary driver of SDLC database process improvement; wrote initial process documents and acted as primary point-of-contact on databases for upper managemento Planned database software strategy, including presentations to client

Us

o Installed, upgraded, patched, and maintained database software for multiple productso Troubleshot performance issues on customer site o Documented processes and wrote reference materials on database aspects of productso Advised management on hardware/software issues

o Interviewed users at various levels of management to understand business strategies and gapso Synthesized requirements into software architecture plan o Collaborated with various groups within IT to communicate architecture o Analyzed business processes and workflows, wrote use cases, and provided recommendations before beginning software development projects to ensure solution fit overall business contexto Acted as technical lead on critical architecture projects, including integrating ERP/MES into existing manufacturing processo Introduced UML and CASE tools to company for object-oriented development, ER data models, and data flow diagramso Introduced SOA and enterprise service bus (ESB) ideas into architecture solutionso Performed data modeling on architecture-related projects, including customer master hub, and produced ER models with documented entities and attributeso Provided recommendations on software development process, to include architecture oversight o Evaluated software development processes, including RUP and Agile approaches such as Scrumo Defined DW architecture, including data mart approach and ER data models for Master Data Management (MDM)

Information Technology

Chemistry