Security Officer Data Architect

Paul A. Flores

Professional Summary

**+ years of Application design and development experience utilizing a wide variety of both languages and application areas.

15+ years of experience as a proven Information Systems Architect with expertise in the identification, integration, management, design, development, implementation, support, and maintenance of technology to meet business requirements.

Extensive experience utilizing a diverse set of skills for both the communication and identification of architectures for complex, high data volume, high risk analytical and data integration projects

Possesses a broad set of experiences demonstrating the agility needed to rapidly adapt and effectively apply technology in a wide variety of business-use cases.

Effectively applies a diverse set of modeling approaches to problem solving reflecting a keen insight and unique perspective utilizing functional to natural language to object role modeling skills

Actively mentors others assisting in their professional development.

LinkedIn profile link: https://www.linkedin.com/in/paulaflores Technical Skills

Development Environments: Microsoft Visual Studio (C# & Visual Basic),Eclipse (Java, C++), COM / COM+, Alteryx Designer 2018,IBM RSA (Java, J2EE), Java (J2EE)

Databases:

Oracle 19/12, DB2, Microsoft SQL Server (2019, 2017), Snowflake, Amazon RDS & Redshift Modeling Techniques & Tools: UML, IDEF, ERWIN, dbt, Rational, VISIO Programming Languages: C++ (gcc, g++, Visual Studio), C, C#,Python, dbt, Java (J2EE, JBoss, junit), Perl, ANT, OCCI, SQL (T-SQL, PL-Sql), R, XML, XSL, Visual Basic;CORBA, GSOAP, DFDL and others Systems: Talend 6.3, Matllion 1.66.21, XML Spy, Soap UI, IBM DataStage (11.3, 9.1, 8.7), IBM InfoSphere, IBM WebSphere, IBM QualityStage (9.1, 8.8), IBM Information Server (IIS 11.3, 9.1, 8.7) (Metadata Workbench, Business Glossary FastTrack and MDM Workbench(10) ) and others Past Application Areas:

Concurrent and Parallel Application Design / Development, Manufacturing Shop Floor Scheduling, Information System Security, Business Process Development and Re-Engineering, Data Modeling

(Information, Functional, Dimensional and Natural Language), Messaging Systems Integration Current Application Areas

Metadata Driven ETL Framework, C++ development of simulation framework plugins, Text Analytic Design/Development (Alteryx,Python), AMQP integration (C++), “Transparent” Configuration Management System Development/Integration (C#, PA File Sight) Professional History

RevGen Partners November 2021 - Present

Architect

Solution Architect

Data Governance utilizing Erwin DI Suite

Design of and management of implementation of a metadata driven ETL framework in Talend utilizing Oracle DB, Java, python, Jira, bitbucket, and Visual Studio

Design and implementation of REST based solution for management of GL transactions utilizing Sage Intacct, AWS, Snowflake DB, JavaScript, Jira, and git.

Design of and management of implementation of dbt / jinga based components to support improvements to a web portal dashboard functionality utilizing Visual Studio, Jira, and git. General Dynamics Information Technology May 2021 – November 2021 Senior Software Engineer

Software Designer / Developer

Design of and development of a Windows Service (C#) to run different simulation executions simultaneously in independent threads.

Development of C# data parsers utilizing regular expressions. Aegis Technology Group October 2019 – May 2021

Senior Software Engineer

Software Designer / Developer

Novel design of and development of dynamic loading libraries in C++ for the extension of simulation capabilities.

Extension of an existing design of a C++ component plugin to a simulation framework addressing fundamental issues with design issues affecting data structural effectiveness and overall functionality. SAIC January 2016 – October 2019

Software Systems Engineer Senior Principle

Object Oriented Software Designer / Developer

Design/Development of components of a “transparent” configuration management system in C#

Integration with PA File Sight.

Development of text analytic functionality in Alteryx and Python to synchronize between a model of contractual requirements and contractual documentation

Application architectural review/analysis of messaging functionality between testers and production systems

Integration of Apache QPID AMQP framework to replace an existing CORBA application

Development of C++, Java and Perl assets in the transition to the use of AMQP Data Analytics/Science

Assisting engineering and business/administrative staff in the adoption of standard data analytic tools

Assisting/ guiding both technical and administrative staff in the development of analytical and business processes Data Architect/ Designer / Developer

Development of a data model to document data “linkages” between disconnected data bases

Identification and development of data structures and SQL to facilitate data “linkage” across disparate data stores Clarity Solution Group Feb 2014 – January 2016

Senior Consultant - ETL Architect, DataStage Designer/Developer, System Integrator

Developed and maintain a DataStage wrapped stage for the integration of a data appliance to increase sort and lookup throughput.

Developed functional performance tests using SOAP UI Pro within an MDM environment to validate MDM transactions

Responsible for development of SQL scripts in a Microsoft SQL environment for application validation / certification

Responsible for the successful representation of client technical ETL requirements in design documentation and in subsequent development activities.

Identified technical resources to assist client in building technical knowledge and understanding, and created approaches to address specific technical requirements.

Created technical assets to address client requirements (DataStage sequences and scripts) and produced tools (scripts) to assist technical team members in the accomplishment of their tasks.

Mentored junior staff members in the utilization of the IBM DataStage environment. Assisted junior staff in script development tasks. Encouraged their engagement in the representation of client technical requirements in novel approaches. Supported their efforts to take on technical and project responsibilities. Integration Point Consulting L.L.C Jul 2013 – Feb 2014 Senior ETL Consultant,

Info Server Specialist

Financial Institution

Evaluated and assessed an online financial institutions’ implementation and customization of MDM QualityStage rules, the underlying Information Applications and DataStage jobs.

Provided full scope of assessment, including current and future version upgrade considerations and criteria to evaluate impacts of future upgrades.

Reviewed DataStage applications as they apply to client development practices.

Participated in both the compilation and presentation of assessment results to the client. Financial Institution II

Assisted financial institution in development of data lineage and business glossary maintenance processes and practices.

Developed requirements, design and deployment of DataStage jobs to assist in creation of FastTrack mapping specifications and business glossary import files.

Compiled process documentation for Client Enterprise Information Management groups, data lineage and business glossary maintenance business practices with guidance on use of logical data model to business glossary command, ldm2bg.

IBM Corporation Jan 2008 – Jul 2013

Senior Software Developer

Developed and presented hands-on-lab, guiding users on functional extension of the BIL DataStage assets and subsequent developerWorks article, providing extension guidance.

Re-engineered existing RDP DataStage assets into BIL DataStage assets, resulting in a greatly improved product that is easier to install, deploy, maintain, support, and extend.

Integrated Data Formation Definition Language (DFDL) parser from an IBM Open Source sponsored project into MDM Workbench, using development version handling semi-structured and unstructured data.

Constructed Bourne, Korn and Perl scripts to improve and increase installation, development and administrative task execution.

Improved overall development time, improved delivery schedule, and increased client satisfaction with schedule performance across all supported operating systems; AIX, UNIX. LINUX, Solaris and Windows.

Successfully designed, developed and implemented an extensive XSLT/ Java application to alter contents of an XML formatted Data Stage Exchange (DSX) file so project could support multi-byte characters without rewriting any of DataStage jobs.

Contributed to the successful design, development, testing, and release of the Rapid Deployment Package (RDP) DataStage assets, increasing the throughput of data loading and delta processing. Axciom Corporation Nov 2005 – Jan 2008

IS Architect, Software Developer, ETL Developer

Designed and developed rule-based event handler, hash key routines, and web service to expose encryption functionality, extensive message handling system, and numerous subsystems components for a major health care concern in the Phoenix area utilizing UNIX, C++, C, DataStage, GSOAP, ORACLE PL / SQL, JAVA and UML.

Successfully transitioned customer needs into system design through identification of resources addressing requirements traceability acceptance criteria, development sign off, migration strategy approval, and successful client acceptance.

Oversaw the transitioning of pilot Java applications to production by ensuring applications were production-worthy, meeting tight deadlines, and achieving desired levels of quality and maintainability.

Led in the design and development of custom C++ components for the DataStage environment providing access to a wide range of functionality to satisfy business requirements.

Mentored DataStage Developers through review of job designs, development of user guides for both technical and business users, and effective administration / management of development environments, increasing effectiveness and knowledge.

Intel Corporation Apr 2000 – Nov 2005

Data and Systems Analyst, Sr. Software Engineer

Designed, developed, reviewed and assessed database designs prior to application development in a data governance role.

Created and implemented manufacturing production scheduling applications, software testing frameworks, and enhancements to business processes.

Leveraged data-modeling experience to effectively address business requirements, increasing understanding and visibility of critical data elements and enhancing production worthy systems.

Led data analysis of market analysis database/data warehouse modeling project, providing necessary approvals of underlying data structures prior to actual system development.

Designed, developed, and supported a successful, automated software testing framework, in C# simulating system load, for application volume testing.

Successfully participated in the development, management, deployment and maintenance of an automated interface to the shop floor scheduling system utilizing a mixture of VB, C, C++, TIBCO and MSMQ. Sandia National Laboratories Nov 1989 – Mar 2000

Information and Business Systems Analyst, Sr. Member Technical Staff, Information Security Officer

Technical leadership in using functional modeling to introduce manufacturing into SNL R&D organizational environment

Participant in the utilization of a variety of modeling techniques (IDEF, ORM/NIAM) to develop organizational and project specific data architectures for analysis and development

Developed manufacturing specific measurement and analysis applications utilizing a variety of programming languages.

Information system security officer for the manufacturing division enforcing information systems guidelines and guidance Additional Related Experience

B.D.M. International

Senior Systems Analyst

M.D.C. Corporation

System Supervisor

Nierbanc/Money Marts

Systems Programming Coordinator

Education

Master of Science in Computer Information Systems, University of Phoenix

Bachelor of Science in Mathematics, Western New Mexico University

Contact this candidate