Candidates About

Lawrence Proman

                  Senior Business Analyst and RDBMS Integration Lead

Summary:

 

Business/Systems Analyst and Oracle Developer experienced in the development of full life cycle system integration and web based initiatives utilizing industry standard project management methodologies. Strong track record of leading and motivating multidisciplinary teams to deliver substantial benefits. Extremely attuned interpersonal and communication abilities demonstrated on many high profile client-facing projects. Knowledgeable Senior Business Analyst and UI Technical Consultant with talent to think strategically, and the ability to achieve project objectives on time and within budget. Have consulted on the application of reference architectures and the direction of enterprise technology via the development of reusable patterns and domain architectural blueprints with UML artifacts and data models.

 

SDLC: Agile (Scrum), RUP, SDLC (Waterfall), JAD & RAD, Sprint.

 

Languages:Java, Javascript, PL/SQL, C, C++, C#, Visual Basic, VB.NET, HTML, XML, Progress 4GL,Fortran, COBOL, Macro-11, Macro-32, Intel Assembler, Basic, Basic Plus 2, Pascal, RPG, SQL, Inform, Conform, ADA, AMD Microcode, Ingres 4GL, Lisp, Dbase, Ade-11, Perl, PeopleCode, Laszlo, PHP, ASP, JSP, VBA.

 

Databases: Oracle 4.0-11g, MicroSoft SQL Server 6.0, 7.0, 2000, MySQL, ACCESS, Ingres, Sybase 8-11, Informix, Dbase, DBMS-32, RDB, Model 204, Inform, DB2, Teradata, Datatrieve, Hyperion, MongoDB, Hadoop.

 

Applications: PeopleSoft HRMS 7.5, 8.0, 9.0 (HR, Payroll, Benefits), PeopleSoft Financials 7.5, 8.0, 9.0 (GL, AP, AR, Budget, Asset Management), SAP, Visual Studio, Symix Manufacturing and Financials, Hyperion Enterprise, Ab Initio, MS Project, Visio, Excel, PowerPoint, Clarity, SharePoint, XML Spy, Web Servers (Apache, WebLogic, IIS), and Web Services (REST & SOAP).

 

Operating Systems: NT, AIX, HP-UX, Ultrix, Linux, RT-11, RSX-11, RSTS/E, VMS, TOPS 20, DOS, XP, Sun Solaris, Compass, Tempo, AS/400, System 38, IBM 3270, CICS.

 

Case Tools: Rational Tools (RUP), CA Erwin, SDW, IEF, Oracle*Case (Designer & Developer), IEW, EasyCase, LBMS, SA, PWB, LoadRunner, Eclipse.

 

Tools – XML Spy, SOAPUI, Adeptia.

 

Documentation: UML, BPMN, System Requirements Specs, JAD Notes, System Design Specs, UAT Play-books, Data Mapping, Data Modeling Designs, Gap Analysis Docs, User Documentation, API Specs, and Project Management Documentation.

 

LMP Software         1/2017 - 8/2017

Consulting Business/Systems Analyst

 

Project Overview: Gathered requirements and performed Gap Analysis on the re-design of an Asset Retirement Obligation System in adherence with government compliance (Fasbe 143). Gathered requirements and provided documentation for the re-design of a customizable Web based workflow system in Java, which was utilized for client extensible Business Process Engineering.  

 

Lonza International, Portsmouth New Hampshire

Senior Systems Analyst     2/2015 - 12/2016

 

Project Overview: Worked with peer Business Systems Analysts to define Business Systems Owners and User Interface Requirements; the mapping Data Flows from originating Business Systems to Requesting Business Systems and/or centralized repositories and Data Marts.

 

Gathered requirements and documented a proposed Business Systems Technical Interface Architecture Model.

 

Gathered requirements and documented leveled BPMN process maps for the targeted Business Systems, defining current and future state; then provided Gap Analysis and Action Plans. Conducted Reporting Workshops for dashboards & reports with key stakeholders based on the documented requirements, Gap Analysis, GMP Compliance, and the I.T. Risks.

 

Worked as part of a small team to interface GMP Compliant data to a Pharmaceutical client. Collaborated with I.T., Database Analysts, Network Engineers, and Management when required. Was client facing with directors and technologists.

 

Performed Database Administration, Systems Integration and ETL design and programming (via Adeptia, SOAPUI, XML Spy). Gathered Requirements, Designed, Deployed, and Validated Interface Standards; performed Production Problem Identification and Resolution; Created and Maintained Interface Harmonization; and supported the Data Compliance Program.

 

J.B. Hunt Corporate, Rogers, Arkansas

Senior Business Analyst/Data Architect    11/2013 – 6/2014

 

Project Overview: Worked on the redesign of the current DB2 physical data models to reengineered MS SQL logical and physical data models on a DB2/Cobol conversion effort to Java/C# and MS SQL. Conducted data modeling, Gap Analysis, and review session. Facilitated   SOA architect analysis and design meetings, conferred with SMEs and developers, and built Erwin based data models. Gathered requirements and documented consensus agreed dashboards and reporting. Facilitated data modeling peer review sessions. Instructed and reviewed SME and Business Analyst Use Cases for D.O.T. compliance and inherent I.T. risks.

 

Samsung Network Services, Overland Park, Kansas

Contract Business Analyst/Data Architect    4/2013 - 9/2013

 

Project Overview: Gathered requirements, documented requirements, designed, normalized, and constructed an Oracle Operational Data Store from legacy Access Databases based upon U.S. Telephony Compliance. Performed a Best Practice Gap Analysis of 3^rdParty Business Intelligence tools and dashboards. Defined and wrote an Oracle PL/SQL Naming Standards and Programming Guide for Samsung Network Services development. Gathered requirements, designed, and constructed Help Desk Trackers in Excel and Access for the Network Services War Room and Primavera P6 Help Desk. The Help Desk Tracking System provided solutions to I.T. issues and I.T. risks, based on topics and keywords. Help Desk issues were automatically escalated based on Access database driven severity, region, and alert and alarm thresholds. Gathered and documented requirements based on workshops to make recommendations for dashboard and report development within Samsung Network Services.

 

Hampton Roads Transit, Norfolk Virginia        2/2012 - 8/2012

Business Analyst/Data Architect

 

Project Overview: Requirement gathering, documentation, and the design of an Oracle PL/SQL data driven dashboard, which facilitated the build-out of a data warehouse of company KPIs (utilizing the Agile Methodology and serving as Scrum Master). Subsequently generated system requirement documentation, system design documentation, and storyboards for additional reporting requirements. Led the risk assessment and implementation of an Oracle 11g database implementation. Managed the PL/SQL ETL efforts, and managed the DBA and Oracle Security production team. Was responsible for Gap Analysis for a PeopleSoft upgrade and the associated I.T. risks. Provided production application and database support for Peoplesoft HR and Finance, and other HRT production systems. Performed Gap Analysis and Risk Analysis for new hardware and software architectures, as well as vendor products and services. Worked with the IT security and Active Directory teams.

 

Capital One, Richmond, Virginia        2/2011 - 8/2011

Contract Project Manager

 

Project Overview: Managed a Teradata Infrastructure hardware and software upgrade. Managed a Teradata Dual Instance Proof of Concept project and provided Gap Analysis and an I.T Risk Assessment. Generated Project Management Plans, Work Breakdown Structures, Schedules, Risk Impact Reports, Budgets and Resource Plans. Utilized MicroSoft Project, PowerPoint, and Clarity Project Management software for management reporting. Facilitated project meetings and requirements JADs. Documented requirements for system and business requirements, as well as a design specification for the Teradata Dual Instance prototype project.

 

Core Concepts/Synapse Analytics, Atlanta, Georgia    1/2006 – 10/2010

Business Analyst/Enterprise Architect/Development Project Manager

 

Project Overview: Enterprise Architect for a software startup company designing and developing analytical tools for the Pharmaceutical Industry, specifically contracting and pricing utilizing an SOA and PL/SQL based Clinical Trial Management Systems. Was directly involved in the design and development of the Analyst Workbench in VB.Net utilizing WebLogic based on GMP data compliance. Scrum Master, Project Manager, and code and report development team manager (Georgia and offshore - India).   Architected an Oracle Enterprise Data Warehouse for clinical trial data and metadata. Utilized Agile and RUP in the project management of documenting Structured Requirements and Design, coding, testing, security, and ETL. Coordinated the launch efforts (risk management, software drops, client expectation management, training, and UAT interaction) and test management.

 

Technical Project Manager of the design and construction of a Web Based Clinical Trials Management System (analytics and visualization). Designed and constructed the J2EE Country Allocation Planner for heuristically selecting the best countries for Clinical Trials, and managed the testing effort. Gathered requirements, documented, architected and developed web applications utilizing various technologies including Visual Studio, Web Services, XML Spy, SOAPUI, GUI tools including C#, PL/SQL, Lazlo, ASP.Net, and Flash/Flex.

 

Sr. BSA, and technical manager of a Vendor Management System (SRS) – JAD facilitation, Data Modeling, System Requirement Specs, and Design.

 

Technical Project Manager and DBA on the Web Based CTInsight Clinical Trial Simulation engine. The aforementioned system was constructed in Java, PL/SQL, Apache, and the Oracle Database platform utilizing the Agile (Served as Scrum Master) and JPACE methodologies.

 

Falconbridge/Noranda International   1/2003 – 4/2005

Contract PeopleSoft Business Analyst/Technical Lead

 

Project Overview: Technical Project Manager utilizing the Waterfall SDLC for the conversion of PeopleSoft world wide multi-currencies to USD, as well as the implementation of PeopleSoft Multibooks for international business units based on Sarbans Oxley compliance. The Project Team designed and coded Journal Line Translation tools with PL/SQL and SQR to augment existing PeopleSoft tools based on Gap Analysis. Managed the analysis, design, ETL, and testing of a PeopleSoft to Hyperion interface for financial and statistical reporting, as well as the gathering of requirements, design, and report development of Nvision, Perl, PL/SQL, and SQR based reports for the Management Team.

 

LMP Software         7/2002 – 1/2007

Consulting Systems Architect

 

Project Overview: Designed and developed an Asset Retirement Obligation System in Java with Swing components, in adherence with government compliance (Fasbe 143). Designed and developed a customizable Web based workflow system in Java to be utilized within the realm of Business Process Reengineering.   Interfaced product output to PeopleSoft 9.0 Financials (GL).

 

Agris Corporation, John Deere Technology Center, Roswell, GA. 8/2001- 6/2002

Contract Business Analyst & Enterprise Architect

 

Project overview: Develop a Web based browser oriented grain trading system for various exchange service firms. Gathered and documented requirements, generated Use Cases and created browser interfaces in a RUP/J2EE environment to John Deere legacy systems.

 

Duties: Managed a 20 person product development team composed of JAVA, PL/SQL, VB, WebLogic, and XML developers; as well as managed the testing team, IT security, data analysts and performance management. This position was responsible for project timelines, product deliverables, product performance, and grain trading compliance. This position reported to the Agris CTO.

 

Dantis Corporation, Chicago, Illinois     8/2000 - 6/2001

Contract Senior Business Analyst and Enterprise Architect

 

Project Overview: Gathered and documented requirements, generated Use Cases, and managed the construction of Web based supporting systems for a Startup Web Hosting business.

 

Duties: Facilitated JAD & RAD Sessions which gathered and generated System Requirement Specifications. Documented requirements, Use Case Designs, Data and Object Models utilizing RUP. Was responsible to lead a team of twelve business and data analysts, database modelers, web designers, and DBAs.

 

Hr-Ease Inc., Tampa, Florida       1/2000 - 7/2000

Contract Business Analyst & Senior System Architect

 

Project Overview: Develop a Web based employee self-service product that integrated with the PeopleSoft HR and Benefits modules.   The product provided the ability to perform Employee Self-Service Benefit Registration.   Was responsible for the Gap Analysis, resolutions, and integration of PeopleSoft 8.0 into the realm of Web based feasibility and functionality.

 

Duties: Facilitated JAD Sessions; gathered and documented System Requirement Specifications, Use Case Designs, Data and Object Models, and coded the application. Technically managed a team of VB (Visual Studio), JavaScript, IIS and SQL Server developers utilizing a Waterfall SDLC, and managed the testing team.   

 

Advantech Inc., Tampa, Florida       6/1999 - 5/2000

Consulting Senior Business Analyst & Enterprise Architect

 

Project Overview: Developed a Web based payroll and HR product which integrated with the PeopleSoft HR and Payroll modules.

 

Duties: Facilitated JAD Sessions, generated and documented System Requirement Specifications, Use Case Designs, Data and Object Models, coded SQRs and Crystal Reports. Technically managed a team of VB (Visual Studio), JavaScript, IIS, SQR, and PL/SQL Oracle developers utilizing a Waterfall SDLC; and managed the testing team.

 

Conduit Software, Atlanta, Georgia     4/1998 - 5/1999

Consulting Business Analyst/Project Manager/Enterprise Architect

 

Project Overview: Develop Web enabled HR, Benefit, and Payroll employee self-service products in Java with IIS which integrated to PeopleSoft, SAP, J.D. Edwards, and other proprietary systems.

 

Duties: Facilitated JAD & RAD Sessions, generated and documented System Requirement Specifications, Use Case Designs, Data, Meta-Data, and Object Models. Technically managed a team of seven Java, HTML and Oracle developers; and managed the testing effort. Designed and constructed PeopleSoft Message Agents utilizing C. Designed and built interfaces to 3^rd generation systems utilizing PL/SQL, Perl, DCOM, and Corba.

 

Falconbridge International, Toronto Canada     2/1997 - 3/1998

Contract Business Analyst and PeopleSoft Technical Lead

 

Project Overview: Technical Project Manager responsible for the I.T. risks, Burroughs data conversion, and integration of PeopleSoft Financials for an international mining company.

 

Duties: Led the technical and testing team in designing automated monetary conversion routines, created a set of transaction validation tools with PL/SQL, and generated an ETL suite.

 

Conducted JAD Sessions, Gap Analysis sessions, designed, and constructed PeopleSoft extensions for various mining exploration offices utilizing PeopleCode, PeopleTools, PL/SQL, SQR, NVision, Crystal Reports, Oracle utilities, and PeopleSoft security.

 

Chesapeake Corporation, Richmond Virginia     4/1992 - 1/1997

Consulting Senior System Architect and Lead Developer

 

Project Overview: Conducted Rules Gap Analysis sessions, documented the I.T. risks, and developed a rules based estimating system for Corrugated, Litho, and Packaging companies which integrate to Symix Manufacturing and Financials. Developed EIS systems for Chesapeake top management to assess the corporation's financial health based on Business Requirement Gap Analysis.

 

Duties: Facilitated JAD Sessions, gathered and documented System Requirement Specifications, Use Case Designs, and Data Models. Technically managed a team of five Progress developers and the testing team.

 

Cap Gemini America/Sogeti, Richmond Virginia    12/1987 – 3/1992

Staff Consultant/Certified Project Manager

 

Certified as a Project Manager and Systems Architect. Gathered requirements, design, and implementation services for clients in a wide array of vertical markets. Utilized Oracle RDBMS, Oracle*Case, Ingres, Informix, DB2 and 3GLs to manage and construct systems for clients in the Federal Government, State Government, manufacturing and distribution sectors based on vertical market compliance. Developed a Programmers Workbench for standardized SDLC (Waterfall) client software development. Designed and developed Rules Based Systems for Corrugator, Litho, and Packaging configurators and estimating systems. Taught JAD, RAD, Case Tools, relational database theory, PL/SQL, DB2, and Structured Methodology classes.

 

 

 

Education

 

Brandeis University - Computer Science

 

Boston State College - Computer Science, English Literature

 

Digital Equipment Corporation- Certified RSX Software Engineer, Certified VAX Software Engineer, Certified RSTS Software Engineer

 

Oracle Corporation - Certified DBA, Certified Oracle Developer   

 

Cap Gemini America (Sogeti) – Certified Project Manager, Certified Systems Architect