[var] => cut_url
<pre>Array ( [var] => cut_url ) </pre> Resume for CARMEN F. for Consultant / Computer & IT Services in wharton, New Hampshire. Search More Resumes for Consultant on #YUXJLT9AZ

Search Resumes

Post Jobs

Job Seekers:
Post Your Resume


Resume for CARMEN F. for Consultant / Computer & IT Services in wharton, New Hampshire

Occupation: Consultant Industry: Computer & IT Services
Country: United States City: wharton
State: New Hampshire ZIP: 07885

View Complete Resume   Download Resume [
    [name] => cut_url
Share Share

< Back to search results Preview: For the complete resume and contact info please download it.

    [var] => content
    [type] => preview
    [var] => cut_url

            CARMEN  F., MBA, OCP

Wharton, NJ    Summary:

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. 

technical skills

  • Microsoft Technologies: 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
  • Software: Visual Studio .NET , SQL Server Business Intelligence Development Studio BIDS
  • Programming:  TSQL, Application Engine Programming, SQRSQL Programming
  • Reporting: Crystal 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, Tax cut
  • 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
  • PeopleSoft Security:  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 Exams

    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 Reporting Services. 
  • 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.


    Financial Services 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 using SQL/Query.
  • 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

    JGI Consulting, 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 PeopleSoft System.

    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 issues.
  • 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.

       Lockheed Martin Corp. Cherry Hill NJ Sr. Technical Consultant

    Deloitte Consulting, NJ  /  to  /

  • Provided remote technical production support for PeopleSoft Financials GL / CA / PC / BI / AR modules
  • 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 Costing.

    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

    Visiting Nurse 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
  • Significant "handson" experience in project management, systems analysis and design, implementation, conversions, training, post implementation support, management reporting, and business process reengineering for b

  • Cancel
    Not Enough Credits
    Sorry, but you don't have enough credits to download this resume.

    Purchase more credits
    Not Available
    Sorry but this resume is not available for download. Please choose another!

    Confirm Download

    Would you like to download  for 1 credit?

    You have  credits left.

    Yes No 

    Don't ask me again
    Confirm View Complete Resume

    Would you like to view  for 1 credit?

    You have  credits left.

    Yes No 

    Don't ask me again