Gregory Parsons Email & Phone Number

Mashpee, Ma, Us

Virginia, United States

Defining and scheduling conversion efforts

Virginia, United States

• Contracted to migrate data from Costpoint-to-Costpoint for sub-divisions of parent company for General Ledger and from SAP-to Costpoint for General Ledger, Labor History and ITD Billing. All work using desktop tools, SQL-Server Management Studio.• Created and Maintained all Account and Organization crosswalks in this effort.• Created and Maintained Employee crosswalks in this effort.• Created and Maintained a stored procedure to validate Project schemes, segment lengths and uses for all converted projects. This was the pre-validation to allow construction/maintenance of the Project crosswalk. Conduit for creation of default project id’s (primarily used for validation of source-to-target ETL processes) for three corporate entities; coordination with team members and discussions/decision points with corporate concerning efforts, issues, work-arounds, etc..• Created process to construct an Archive of the source data used in the above effort. Created several functions to validate provided column data-types.

Mclean, Virginia, United States

• Integrations using extensions created range from adding tables, creating web services, updating screens and processes to reset inventory allocations, update timesheet hour allocations, offer Packing Slips, Ship Id’s, or data extraction/interfaces for tools (Adaptive).• Performed and Directed Data Migration from Oracle to Costpoint for over 20 government contractors.• Learned, built and applied Workday Adaptive/Pentaho ETL processes for functional users. Constructed domain-engineered solution to build Workday Adaptive artifact/scripts to extract Costpoint (using web services) to Adaptive tables.• Created (put/get) interface including Deltek’s Costpoint web service to interface with Workday Employee data.

Sandwich, Ma

• Create, execute and test a PL/SQL process to migrate data from Deltek’s Costpoint to Oracle ERP for a major multi-national aerospace firm.• Create and maintain deployment tools using SQL and PL/SQL.• Create, execute and test a SQL-Server process to re-organize project data within Deltek’s Costpoint and Time & Expense systems for a major multi-national aerospace firm.• Create, execute and test a PL/SQL process to migrate data within Deltek’s Costpoint for a major multi-national defense firm.• Create, execute and test a PL/SQL process to migrate data from Deltek’s Costpoint to Oracle ERP for a major multi-national aerospace firm.• Create and maintain deployment tools using SQL and PL/SQL.• Create, execute and test a SQL-Server process to re-organize project data within Deltek’s Costpoint and Time & Expense systems for a major multi-national aerospace firm.• Create, execute and test a PL/SQL process to migrate data within Deltek’s Costpoint for a major multi-national defense firm.

Ma

• Managed both technical resources and client expectations for onboarding clients. Constructed ETL processes from/to Unanet, Deltek Costpoint and Time Collection and other HR interfaces.• Provide technical support for Deltek’s Costpoint ERP and TBS’s Integrated Cloud Exchange (ICE). ICE is a secure client data-interaction platform encompassing tools such as Pervasive, SFTP, Java, SQL and PL/SQL and is used primarily for building client interfaces to/from Costpoint, Time&Expense and any other systems a client determines is necessary to update.• Improved SQL performance characteristics for clients pre-defined extraction processes. Identified requirements and consulted on changes to SQL, PL/SQL and Pervasive processes for client interfaces.

Mt Laurel, Nj

ETL process testing and QC responsibility for an Anti-Money Laundering appliction. Created SQL-based test-bed for verification of content row counts and row-for-row validation.

Etl Process Design Responsibility To Remotely Load Legacy Data Into Deltek Produ

• Installed legacy data for over 60 clients, modify existing data either as a restructure, merge (merging or subsidiary purchase) or database split (for companies divesting).• Identified needs, documented, created, tested, installed and supported customizations for Deltek’s Costpoint and Time & Expense clients. Customizations included constructing triggers to audit table content for event-timing identification, modifying the base-product processes for increased functionality, creating full interfaces from/to non-Deltek products into/from Costpoint and/or T&E for product-extensibility. • Constructed training programs and best-practices for more junior level consultants resulting in quicker learning time and less time on the bench.• Constructed training programs and best-practices for more junior level consultants resulting in quicker learning time and less time on the bench (PL/SQL and T-SQL courses).

Principal Supporting Fund Movement And Trend Identification Data Warehouse.

• Learned Informatica and Hyperion Brio used as ETL and Reporting tools in support a commission sharing and reporting data-warehouse application. • Assuring timely data refreshes and reporting while making system performance improvements.

Principal Architectural Responsibility To Replace An Existing Etl Tool.

• New ETL tool validated, transformed and loaded data 10% quicker validate and transform data. • Created a file transfer utility using Oracle PL/SQL, SQL*Loader and Java.• Designed and constructed a system to rewrite SQL*Loader control files to allow parameter replacement.

Engaged To Create A Straight-Through Processing Financial Solution For Chase Man

• Collaborated and developed a data-driven-code-generator for constructing Oracle SQL, PL/SQL and Java integrated packages. • Architected object manipulations necessary to construct multiple artifacts, perform the build and deploy the process to client.

Responsibility To Design And Create A Supply-Chain Website For Life-Science Indu

• Created several stored packages (PL/SQL) including standard exception-log package, email addressing validation package and method for tuning SQL statements dynamically.• Migrated source code from VSS to Merants’ Dimensions.• Configured machines and supported an Oracle 11i rollout for Financial package, trained and coached DBA and Unix SysAdmin in creating and maintaining backup planning and recovery of database instances.

Client Transformation And Load Responsibility.

• Created flexible ETL for transforming and loading XML data into relevance engine from clients resulting in 86% faster load times.

Bachelors Of Science, Accountancy

Certificate, Networking