D365 Lead Functional Consultant Resume
Houston, TX
SUMMARY:
- 14+years of overall professional IT experience in various industry domains involving manufacturing, construction, pharmaceuticals, oil, gas - thermal-energy sector and IT in Microsoft technologies, ERP applications, design, implement and testing.
- Over 3 years of functional, business, implementation, configuration, support,, quality control and support experience with Microsoft Dynamics AX and Business Intelligent applications.
- Knowledgeable in highly utilizing proficiencies of Dynamics AX and MS SQL Server in executing full life-cycle projects.
- Experience of planning and implementation of Dynamics AX system quality tests to ensure that business requirements, functionality, configuration and data meet the expectation.
- Ability to architect solutions by assessing client needs and increasing technical efficiency of the business operations.
- Experience in implementation and configuration of OG, GL, AR, AP, FA, Banking and cash management.
- Well versed with Product Costing, Product Cost Planning and Cost Object Controlling.
- Well versed with the key Integration of Finance modules with Trade/Logistics/Sales/Tax including Enterprise Asset Management module experience.
- Ability to engage with executive and senior level decision makers with reports and dashboards.
- Experience in working on Management Reporter application for preparing various financial reports for Key Executives.
- Expert and actively involved in different phases of implementation from gathering client requirements, conducting GAP Analysis, preparing Business Blueprint document, Configuration, Unit Testing, User, End user manuals and Production Support.
- Design and document functional requirements, workflow, and system specifications
- Very good understanding of business processes across different industry verticals.
- Strong knowledge in Financial Accounting, Managerial Accounting and Cost Accounting concepts.
- Very good organizational, interpersonal and communication skills with proven ability to interact across multiple levels of organization.
SKILL:
- MS Dynamics AX/D365 Finance and Operations (Premise to Cloud Version 10)
- All Accounting modules
- Trade and logistics (Procurement)
- Project management and accounting (Fixed Asset)
- Management Reporter 2012 (Financial Reporter)
- Power BI for Dashboard
- MS SQL Server, Data Migration and Cleansing in SSRS
- Desktop, clientserver, web and cloud: based environments
- Design, implement, testing applications, QA, UAT
- Support and maintenance
- Worked with QuickBooks, SharePoint, SAP ECC 6 and MS Office
PROFESSIONAL EXPERIENCE:
Confidential, Houston, TX
D365 Lead Functional Consultant
Responsibilities:
- Worked on requirements gathering, gap analysis, feasibility analysis.
- Analyzed and mapped business requirements to ERP modules and processes.
- Prepared Functional Specifications Document.
- Configured financial accounting settings like company, segment, Legal entity, department, Cost centers, Organization Hierarchy, currency, Periods, fiscal calendar, posting Profiles, Number Sequences, field status criteria, field status groups, credit limits for Banks and Vendors.
- Configured chart of accounts, account structure and advance rules structure.
- Configured financial dimensions with Chart of Accounts, automatic account assignments, validations and Posting Profiles.
- Created end user procedures to document the business transactions like Procurement, Payment terms, sale and transfer of assets, depreciation run, period closing and Consolidation.
- Configuring Asset Accounting - specified asset categories, value models defined depreciation areas, and created custom defined Depreciation Keys for calculations.
- Tested Transactions Capitalization of Assets under Procurement, Asset Maintenance,
- Actively involved in data importing from legacy system.
- Precise setup Experience for Consolidation, Prepayment, Centralized Payment setup.
- Knowledge in Product receipt over delivery and Policy management setup, Inventory setup, item model group and item group as well.
- Knowledge of Financial Reporter (Web Browser-Financial reporting) to divisions and Organization Hierarchy as per reporting requirement.
- Developed UAT test scenarios, test scripts and test cases for financials implementation and worked with finance users in executing test scripts in conference room pilot sessions.
- Worked closely with Finance team to prepare various financial reports (Balance sheet, profit and loss, trial balance etc.)
- Ensure that internal controls and standard procedures are strictly followed under enhanced ERP environment ultimately ensuring efficient business processes, effective financial/management reporting.
Confidential, Tomball, TX
Principal Functional Consultant
Environnent: Dynamics 365 For Finance & Operations (7.1 & 7.3) intégration with Dynamics CRM, Power BI, Blackline, Avalara, Coupa & Prokarma
Responsibilities:
- Providing continuous support for day to day operation and ongoing configuration change
- Active involvement for requirements gathering, gap analysis, feasibility analysis
- Analyzed and mapped business requirements to ERP modules and processes
- Preparing Functional Specifications Document, sign off & User acceptance tasks
- Actively involved in ongoing enhancements as well
- Knowledge in Procurement cycle, Inventory Management, Product Information and Fixed asset helps to work with cross functional team for better execution
- Capitalizing asset experience, Customer billing with interface & Work order management for Projects through Enterprise asset management module.
- Developed UAT test scenarios, test scripts and test cases for financials implementation and worked with finance users in executing test scripts in conference room pilot sessions
- Worked closely with End users, Product owners and Project Manager
- Ensure that internal controls and standard procedures are strictly followed under enhanced ERP environment ultimately ensuring efficient business processes, effective financial/management reporting
- Worked with Corporate accounting team for their Audit support and month end closing process
- Performing as a Point of contact for bringing efficiency and effectiveness across the users
- Engaged with solution manager as well for Monthly reporting and presentation
- Experienced with Upgrade of the versions as well of platform update
- Knowledge of LCS for environment monitoring interaction as well handling Microsoft for ticket
- Effective VSTS Management for internal requirement control
- Effective Service now experience for Client ticket management
Confidential, Cherry Hill, NJ
Functional Consultant
Environnent: Microsoft Dynamics AX 2012 R3, Dynamics CRM, SQL Server
Responsibilities:
- Worked on requirements gathering, gap analysis, feasibility analysis.
- Analyzed and mapped business requirements to ERP modules and processes.
- Prepared Functional Specifications Document.
- Configured Products, financial dimension for various project related enrolments comes from CRM.
- Tested Transactions for sales agreements, revenue recognition, sales order, payment and settlements.
- Actively involved in data importing from integrated system.
- Knowledge in Product receipt over delivery and Policy management setup, Inventory setup, item model group and item group as well.
- Developed UAT test scenarios, test scripts and test cases for financials implementation and worked with finance users in executing test scripts in conference room pilot sessions.
- Worked closely with End users, Product owners and Project Manager.
- Ensure that internal controls and standard procedures are strictly followed under enhanced ERP environment ultimately ensuring efficient business processes, effective financial/management reporting.
Confidential, East Windsor, NJ
Functional Consultant
Environnent: Microsoft Dynamics AX 365, SQL Server, Quickbooks
Responsibilities:
- Worked on requirements gathering, gap analysis, feasibility analysis.
- Analyzed and mapped business requirements to ERP modules and processes.
- Prepared Functional Specifications Document.
- Configured financial accounting settings like company, segment, Legal entity, department, Cost centers, Organization Hierarchy, currency, Periods, fiscal calendar, posting Profiles, Number Sequences, field status criteria, field status groups, credit limits for Banks and Vendors.
- Configured chart of accounts, account structure and advance rules structure.
- Configured financial dimensions with Chart of Accounts, automatic account assignments, validations and Posting Profiles.
- Created end user procedures to document the business transactions like Procurement, Payment terms, sale and transfer of assets, depreciation run, period closing and Consolidation.
- Configuring Asset Accounting - specified asset categories, value models defined depreciation areas, and created custom defined Depreciation Keys for calculations.
- Tested Transactions Capitalization of Assets under Procurement, Asset Maintenance,
- Actively involved in data importing from legacy system.
- Precise setup Experience for Consolidation, Prepayment, Centralized Payment setup.
- Knowledge in Product receipt over delivery and Policy management setup, Inventory setup, item model group and item group as well.
- Knowledge of Financial Reporter (Web Browser-Financial reporting) to divisions and Organization Hierarchy as per reporting requirement.
- Developed UAT test scenarios, test scripts and test cases for financials implementation and worked with finance users in executing test scripts in conference room pilot sessions.
- Worked closely with Finance team to prepare various financial reports (Balance sheet, profit and loss, trial balance etc.)
- Ensure that internal controls and standard procedures are strictly followed under enhanced ERP environment ultimately ensuring efficient business processes, effective financial/management reporting.
Confidential
Functional Consultant
Environment: AX 2012 R3, SSRS, SQL Server, Management Reporter 2012
Responsibilities:
- Evaluated current business processes and existing configured ERP setup.
- Supported client in their decision making by carrying out research, analysis, and recommendations based on Enhancement required in Dynamics AX.
- Map the business scenarios on Microsoft Dynamics AX accounting modules.
- Supporting Setup and configuration of Dynamics AX accounting, costing, and procurement and trade modules.
- Management reporter- Worked on Report designer to prepare various reports.
- Designed Report definitions and worked on Building blocks; Raw Definition and column definition along with respective reporting Tree definitions.
- Created reporting tree definitions for various departments, Balance period and YTD and trial balance, Balance sheet, Inventory net change, Profile loss detail and variances.
- Created report definitions for Accounting expense, Balance sheet, Branch materials report, Profile loss detail and sales net profit report
- Understood key user requirement and configured Main Account/Financial Dimensions accordingly to have detailed level Drilled down reports.
- Successfully worked on Scheduling, automation, and maintaining version of reports with copying comments.
- Prepared analytical charts, bar and different combination of visualization for dashboard.
- Worked on saving dimension combinations and reuse the dimensions for multiple reports.
- Understood client senior business users’ requirement and converted into Raw/column definitions.
- Prepared, verified, analyzed, presented Reports with demo to the user and provided continuous as and when required.
- Worked on trial balance to analysis. Provided inputs to Developers for advance customization based on complexity report. Tested and verified reports before publishing to
- Worked on Change Request Management as per Project requirement. Worked on daily production support and troubleshooting issues assigned.
- Liaison between IT/technical staff and system users for financial/management reports development to enable the client's senior management and end users to make timely, effective and qualitative decisions.
Confidential
Functional Consultant
Environment: AX 2012 R3, MS Visio, SQL, MS Excel, MS PowerPoint
Responsibilities:
- Study the current (AS-IS) business process, organization structure and Business process
- Conducted Q&A Workshop/session for GL, AP, AR, Bank, Budget and Project Accounting modules
- Conducted Fit-Gap Analysis and presented detailed report to Architect for analysis.
- Configured GL: Main Account, Chart of Accounts, Configure the Structure, financial Dimensions, GL Allocation Rule
- Configured AP: Vendor, Purchase agreement, Pre-Payment Program, Posting Profiles
- Configured AR: Customer Groups, Pool, aging definition, Posting Profile, Aging definition
- Configured Project related Profit center, Cost center, WBS and customized reports for Monthly monitoring.
- Configured FA: Chart of Depreciation, Depreciation Areas, Depreciation methods and depreciation keys for execution of Book depreciation and calculation of Tax depreciation
- Configured Item costing: costing group, costing codes, material and indirect costing formula, worked with SCM Consultant to finalizing Production costing at BOM Level.
- Configured Profit Center Hierarchy and Profit Centers, Dummy Profit Center, Maintain Automatic Assignment, Foreign Exchange valuation.
- Knowledge in Product receipt over delivery and Policy management setup, Inventory setup, item model group and item group as well.
- Management reporter- Worked on Report designer to prepare various reports.
- Designed Report definitions and worked on Building blocks; Raw Definition and column definition along with respective reporting Tree definitions.
- Created reporting tree definitions for various departments, Cost to complete, Bidding and trial balance, Balance sheet, Project Profitability, Marginal variances.
- Created report definitions for Accounting expense, Balance sheet, Division wise report, Profile loss detail and sales net profit report
- Understood key user requirement and configured Main Account/Financial Dimensions accordingly to have detailed level Drilled down reports.
- Successfully worked on Scheduling, automation, and maintaining version of reports with copying comments.
- Prepared analytical charts, bar and different combination of visualization for dashboard.
- Involved in the key Integration of Finance with Procurement and Inventory modules
- Involved in Preliminary Testing, UAT and Production Testing
- Performed Post Implementation Support and issue resolution
- Participated in the users, and prepared the User Procedure Manuals