[var] => content
[type] => preview
[var] => cut_url
CARMEN F., MBA, OCP
Highly experience ERP professional OCP,
Oracle Certified Professional and Business Intelligence /Datawarehouse
professional adept at using SQL Server and Microsoft Technologies.
Highly accomplished consultant with a broad experience in software development,
training and consulting. Has extensive experience in business
with + years of realworld experience that includes business
development, financial analysis and reporting, human resources, project
planning / implementation, employee training, and customer service.
Demonstrated leadership abilities and team work skills as well as the
ability to accomplish tasks under minimal direction and supervision.
SQL Server Integration ServicesSSIS, SSAS, SSRS Performance Point
ServicesPPS, Microsoft Office Share point Services MOSS Microsoft
office Visio, Word, Excel, Power point, Project
Databases: MS SQL
Server , Microsoft Access, Oracle G, Sybase
Studio .NET , SQL Server Business Intelligence Development Studio
TSQL, Application Engine Programming, SQRSQL Programming
Report, n Vision, SQR, Oracle Hyperion Brio, Oracle/PS XML Publisher
Other Tools and Software:
SQL Plus, Query Analyzer, SQL Loader, TOAD, Quest Stat, Test Director,
HP Mercury Quality Center, Load Runner, Quicken, Quick books, TurboTax,
PeopleSoft Tools including
v.: People Tools, Object Oriented Programming in People code,
SQR / SQL, AE, Query, n Vision, Application Engine, EIP App Message,
Excel to CI Utility, Component Interface, Tree Manager, File Layout,
Data Mover, Business Process Workflow
User Profile, Permission List Security, Row Level Security, Query Security,
Field Level Security
PeopleSoft Enterprise : Financial
Management Certified Expert Functional Consultant
Passed Certified Public Accounting
MBA in Management Information System
MIS, St. Peter's College , NJ
Bachelor of Science in Accounting, Polytechnic
University, graduated cum laude
Set Focus, LLC. Parsipanny,
NJ / – /
Business Intelligence Master’s Program
Implemented a Labor Analysis
Business Intelligence solution for a model national construction company.
Existing data from diverse
data sources were consolidated into a uniform SQL Server database.
SQL Server Integration Services was used to define imports of the data,
build scheduling packages, to define integration flow, log data error
exceptions and orphaned data and to define Database Maintenance Plans
and send emails.
Created a number of cubes,
dimensions and business critical KPIs using SQL Server Analysis Services
representing aggregations in several different ways hierarchically
and using custom groupings that the company will use to analyze performance.
Created several MDX queries according to business requirements.
Developed several detail and
summary reports including line and pie charts, trend analysis reports
and subreports according to business requirements using SQL Server
Implemented business intelligence
dashboards using MOSS Report Center and Excel Services producing
different summary results based on user view and role membership.
Created score cards with executive
summary dashboards using MS Office Performance Point Server Dashboard
Designer that display performance monitoring measures for sales, sales
trends, and book return rates for a fictitious book publisher deriving
data from a SQL Server OLAP data source and deployed them to SharePoint
sites . The dashboards also contain drilldown capabilities to view
book sales by book category and customer, through summary reports and
sales trend charts.
Created score cards with
advanced set of dashboards using MS Office Performance Point Server
Dashboard Designer that feature executive summary measures for
revenue, overhead costs, material purchases, labor and profitability
trends for a fictitious construction company extracting data from a
SQL Server OLAP data source and deployed them to SharePoint sites. The
dashboards also contain pages to view performance by employee, by region,
and by quarter enabling endusers to make filter selections.
Assurance FSA and Assured Guarantee, NY,NY
Sr. Technical Consultant / to /
Led merger of two Financial
PeopleSoft Project version . and version . integration to new system
PS V with complete chart of accounts redesign.
Developed conversion programs
for Journals and Ledger information of both companies to the new Version
. system with the new redesign chart field information.
Tested and reconciled journals
and ledger balances for all financial information converted.
Created custom Tree structure
id and custom Tree and various custom query as the foundation
for the various custom Matrix nVision reportdue to custom tables foundation
for the nVision Reports.
Developed custom nVision DrillDown.
Developed various reports
Developed PeopleSoft HRMS/Benefit
interface for United Health Group and rd party software
ConcurExpenses interface integration to PeopleSoft GL and AP and
to rd party software payroll Ceridian.
Developed various custom objects
using PeopleTools, PeopleCode, AE, SQR. Conversion of other modules
and testing of other modules
Rochelle Park, NJ Sr Functional Lead and Technical Consultant
/ to /
Project Mizuho Capital financial
company, functional upgrade lead for AM and PO. PeopleSoft V to PeopleSoft
V. Upgrade all AM and PO Setup configuration. Develop conversion
mapping of transaction and setup tables from V to V. Lead PO
and AM Conference Room Pilotprototype session for NYC , UK and HK
business unit. Developed job aides or training documentation for PO
and AM. Converted some AM and PO setup tables from V to V using Microsoft
BIDS SSIS ETL Tool. Backend Platform Oracle G
Project Intrepid Healthcare
company based in Dallas , functional implementation lead Solomon
Legacy System to PeopleSoft V GL and AP. Setup all configuration tables
for GL and AP using setup manager. Setup inter unit of all business
unit total of BU and intra unit for chart field operating unit.
Conducted various testing for both GL and AP. Converted Vendor Data
from Solomon legacy system into various PeopleSoft vendor tables using
Microsoft BIDS SSIS ETL Tool. Backend Platform Microsoft SQL Server
New York University
, NY, NY / to /
Project Costing Administrator
Led production support of
PeopleSoft V Financial GL/AP/PO/Project Costing, Commitment Control
interfacing with key stakeholders, Controller and Directors to review
postlaunch issues and implement resolution process including pregrant
and postgrant production issues, project costing, accounting entries
and commitment control issues.
Completed the General Ledger
reconciliation for Business Units comprising of Ledgers spanning
a year period. It was needed for a presentation to an outside
auditor as part of a year end audit and was a proof of transaction audit
conversion of a legacy system to the new financial accounting system.
Contributed to the successful
tracking of issues using the client’s change management system TRAC
and successfully closed out issues/tickets by providing a functional
solution. Developed and executed test scripts before any objects
were moved to the production environment.
Reviewed delivered Grant Functionality
delivered by PS as requested by Grant Director in injunction with Project
Costing integration to Grant module.
Education Testing Services ETS Trenton NJ Sr. Functional Upgrade
Consultant / to /
Led comprehensive upgrade
of the financial accounting system PeopleSoft v. Responsible
for requirements gathering, fit/gap analysis, prototyping sessions,
review of current business processes and developed expected future state
with the new version of the accounting system for General Ledger, Projects,
and Contracts Government Contracting. Solved issues concerning
Project Cost Accounting and Revenue Recognition.
Developed framework, designed
various customizations and informed executive management about process
improvement strategies. Additionally, made recommendations for
future enhancements and direction.
Determined alternative solution
in guiding the client to decommission from the old system with bulk
customizations while achieving few customizations in the new version
of the accounting system and still achieving the client’s system requirement.
Analyzed, tested and documented
all integration points of Accounts Payable, Purchasing, AR, Billing
to General Ledger, and Projects and Contracts. Conducted comprehensive
financial application testing.
Mapped PeopleSoft related
objects/tables needed for initial build of client’s data warehouse.
Development of test plans,
integration of internally developed software and vendor developed software,
integration test support, installations, deployments, and endtoend
system and performance testing of the PeopleSoft financial system application.
Participated in the required
knowledge transfer for purposes of training employees in the new V
Euro RSCG– New
York/New York Sr. Functional Production Support Consultant
Led support of Enterprise
Service Automation Financial Application for General Ledger, Projects,
Contracts, AR, BI, AP, and PO. Partnered with stakeholders to
perform fit / gap analyses and requirements gathering to address revenue
recognition and billing process issues. Conducted testing, business
process redesign and system customization to solve billing and accounting
Resolved $M Balance Sheet
production reconciliation issue after extensive review and analysis
of transactions and provided value added recommendations for various
business process changes to streamline support processes and reported
results to executive management. Responsible for unit testing
of all production issues tracked via HP Quality Center prior to any
object migration to production
Resolved and redesigned PeopleSoft
WorkinProcess and Revenue Recognition integration as transactions
pass to Billing/AR and ultimately revenue recognition booking to GL
and also reversal of revenue when billing/invoices are reverse.
Martin Corp. Cherry Hill NJ Sr. Technical Consultant
NJ / to /
Provided remote technical
production support for PeopleSoft Financials GL / CA / PC / BI / AR
Subcontracted through Deloitte
and Touch for Full Life Cycle implementation of PeopleSoft Financial
modules GL/PC/CA/BI/AR/AM. Prepared detailed business process model
for existing government contracting system. Responsible for planning,
designing and getting buyin for business support of the new government
contracting system. Instrumental in identifying the resources
required for design and development of various customizations to the
contracting system and various rd party interfaces to the
new PeopleSoft system implementation.
Developed technical design
document and prototype design. Participated in requirements gathering,
gap analysis, solutions development and identified resource needs. Tested
process functionality and module interfaces. Collaborated with team
to create n Vision reports, Crystal Reports, and SQR reports. Led development
of custom solutions, developing various application engine programs/sqr
programs and other online custom code to meet specific business requirements.
Developed test scripts and led testing effort/execution of all custom
and delivered functionality for GL, Project and Contract Modules.
Designed integration of SAP
Account Payable transactions to PeopleSoft General Ledger and Project
El Paso Energy
Houston Texas Sr. Technical Consultant /–/
Supported PeopleSoft Financials,
including GL, AP, PO, E Pro, Expenses, Security, Asset Management, and
Project modules in a Microsoft SQL Server / Quest STAT environment.
Implemented Delegation of
Authority Project for expense approval routing utilizing Workflow, PeopleCode,
and Travel and Expense module objects. Developed custom account to related
PS account to Hyperion account and vise versa.
Developed, tested and documented
requirements for compliance to SOX audits.
Developed and tested various
financial reports. Debugged and resolved various production issues
Services of New York Sr. Implementation Lead / Production Support Consultant
Led ERP vendor evaluation,
selection and full life cycle implementation of PeopleSoft
Financial Applications GL/AP/PO. Authored project charter and project
plan, determined resource needs, conducted business and technical analysis
to determine necessary customizations, drafted design documents, and
coordinated design and development efforts for PeopleSoft Financials.
Developed custom interface program for ADP Payroll and GL. Ensured adherence
with HIPAA regulations. Implemented Commitment Control, to include rules
and all KK ledgers; activated expense tracking.
Developed and implemented
budget application and supported Corporate Budget Controller in annual
budget preparation and reporting
experience in project management, systems analysis and design, implementation,
conversions, training, post implementation support, management reporting,
and business process reengineering for b