SUMMARY

• 7+ years of experience in business process analysis,businessrequirements modeling and development of Web Based, and Client/Server applications in diverse business domains of Retail and Financial Sectors.
• Experience and strong working knowledge across Financial suite of applications for AX Finance with specialties in modules of GL, AP, P/L
• Experience as a Microsoft Dynamics AX consultant involved in designing new e - commerce solution using Magento e-commerce,DynamicsAX 2012 R3, AX Retail POS and Call Centre functionality to support funeral service customer service and sales teams. Also worked on Dynamics 365 and office 365.
• Worked for projects which involved integration ofDynamicsAX with several technologies like BizTalk and SQL.
• Experience as a MicrosoftDynamicsAX Consultant in implementing, configuring and customizing Microsoft DynamicsAX with 2 full life cycle implementations, analysis & production support.
• Hands on experience in AX 4.0/ AX 2009/ AX 2012 R2 &R3 versions and extensive experience in doing setups and configurations in AX 2012 R2, R3.
• Developmental skill set in Microsoft Dynamics AX Application technology stack (SQL Server, Forms, SSRS Reports, Workflow, and Interfaces).
• Expertise working knowledge on order to cash (O2C) and procure to pay (P2P) manner.
• Experience of working in several project teams responsible for full cycle implementation of MicrosoftDynamicsAX projects.
• ImplementedDynamicsCRM /AX enhanced features as required to streamline thebusinessprocess.
• Worked with end users to designbusinessrequirements of aBusinessCRM System and manage B2B processes of distribution across the region
• Experience in Developing and Extending OLAP Cubes in SQL Server andDynamicsAX environments.
• Expertise in Data flow diagrams, Entity Relation diagrams, Gap Analysis, DevelopingBusinessProcess Re-Engineering and Process Modeling usingMSVisio.
• Good understanding of oracle data dictionary, oracle workflow, Data flow diagrams, ER diagrams, Data warehousing concepts, RDBMS and normalization techniques.
• Impact of on Process Management Improvement and Reengineering using ETL tools for Data cleansing, Mapping Mode long.
• Used a solid understanding of the capabilities of MicrosoftDynamicsCRM to help the team make decisions about what's possible to implement, and what is not. Proficiency in documenting Test Cases, Test Plans, Test Strategies, scope document and mapping document.
• Worked on AX security, adding users, providing access, restricting users and experienced in Installation and configuration of MicrosoftDynamicsAX 2012 and proficient inDynamicsAX troubleshooting, defect resolution and SI implementation.

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. MS Dynamics AX Consultant

Responsibilities:

• As a MicrosoftDynamicsAX consultant involved in designing new e-commerce solution using Magento e-commerce,DynamicsAX 2012 R3, AX Retail POS and Call Center functionality to support funeral service customer service and sales teams.
• Configure and implementDynamics365 (D365) with a primary focus on General Ledger, Accounts Payable, Accounts Receivable, Budgeting and Fixed Assets
• Integrated MS Dynamics 365 with office 365.
• Responsible for design high availability and Implement full life cycle of E-Commerce on Sitecore online store, SharePoint Farm and Brick and Mortar Retail Systems with SQL Server 2014 Enterprise with Always On deployment.
• Created AX Reports and SSRS reports for various financials using Microsoft Dynamics AX Cues and Functional lead for Retail POS implementation of Microsoft Dynamics AX 2012 R3.
• Worked on Accounts Payable Module for Procurement to Pay (P2P), Sales and Marketing Module for Order to cash (O2C), Inventory and Warehouse Management Module and Product Information Management Module.
• Proposed and track IT Application budget for ERP MicrosoftDynamicsAX Customizations and Implementation.
• Worked on AX & SQL Performance tuning activities using SQL tracer, Profiler, data tuning tools. Implemented IDMF to perform data archive on production SQL database.
• Worked onMSDynamicsAX security, adding users, providing access, restricting users and security setup related solutions with Microsoft best practices in Security and performance.
• Functional demonstrations on ERP, closure of the negotiation, project management, participation in activities of the ERPMSDynamicsAX Implementation, support parameterization of the solution.
• Responsible for configuring product management, order processing and advanced warehouse modules inDynamicsAX.
• Analyze large data sets and patterns using TSQL, Power BI, advanced Excel models like Power Pivot and Power Query to identify opportunities and risks in current operations and define solutions in dailybusiness.
• Played a key role in a team of AX functional and technical consultants and documented the as-is processes, technical design specifications through brainstorming meetings with outside consultants, key business users, subject matter experts and architects.
• Deep understanding and configuring Retail Headquarter, Commerce Data Exchange which includes Real time service, Server/Client, Channel DB/Offline DBs, Retail Servers and Modern POS.
• Configurations of Retail Components includes Retail Scheduler Jobs, Retail Channels, Channel data group, Channel DBs and Catalogs, Products
• Dynamics AX Technical issue, performance tuning and troubleshooting, AX Database server maintenance and optimizing slow running AX jobs and DIXF jobs. Dynamics AX Security roles, duties and privileges development and customizations as per security and business needs.
• Installation and administration of Windows 2012 R2 Cluster with SQL Server AlwaysOn features. AX SSRS load balancing, Integration services and Analysis Service.DynamicsManagement Reporters.
• Migrated Microsoft SQL Server 2000 to Microsoft SQL Server 2005.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment. Migrated Microsoft Analysis Services to SQL Server Analysis Services (SSAS)
• Successfully Designed, Implemented and administrating Microsoft Dynamics AX 2012 R3 Retail Environment from Develop, Test, UAT, Stage and Production Environment with full high availability with load balancing configuration including SQL Always Feature. Developed and documented business requirements and rules for reporting dimensions in creation of an enterprise data warehouse.
• Involved in configuration of General Ledger (G/L) module, Chart of Accounts and Financial dimensions based on the requirement with the help of advance rule Structure.
• Configuration of main accounts, legal entities, intercompany transactions, accounting currency, reporting currency, Journal names and numbering system.
• Involved in configuration of Account Receivable (A/R), payment schedule, terms of payment, payment day, cash discount, method of payment, posting profiles, customers and customer groups and collection cases.
• BusinessIntelligence Suite (SSIS, SSRS, SSAS) for SQL Server 2008 R2, SQL Server 2014.
• Design and developed SSIS packages, database objects, stored procedures and packages, views, tables, triggers and ETL code using coding standards and according to technical specifications.

Confidential, Atlanta, GA

MS Dynamics Consultant

Responsibilities:

• Engaged stakeholders and drove end to endMSCRM implementations including design, development, configuration, deployment and operations.
• Collaborated with several disciplines such as architects, developers, PM, vendors, stakeholders,businesspartners, data center ops, DBAs, Active directory domain administrators, network, exchange and security.
• As Dynamics AX Consultant/ Analyst documented, designed, built, tested and implemented new pricing, taxes, and fees engine integrated with MS Dynamics AX 2012.
• Provided MicrosoftDynamicsCRM Application, industry, domain thought leadership, knowledge transfer, guidance including but not limited to Best practices, dos and don'ts.
• Reviewed SOWs, deliverables, provided valuable feedback and ensured they met company quality and standards
• Migrated Dynamics GP to Dynamics AX 2009 while adding manufacturing, supply chain, regulatory modules and customized reporting.
• Responsible for overall health of MicrosoftDynamicsCRM projects and several elements including ongoing support, maintenance, performance, scalability, problem root cause discovery, timely resolution, responsiveness and delivery that met world class standards
• Advised in Project schedule creation helping estimate time and resource with appropriate skill set, critical task dependencies.
• Worked along customer IT team to design and test integrations of Dynamics AX with external RetailX and Amphire order entry systems used by sales representatives.
• Configured, customized MicrosoftDynamicsCRM 4.0, 2011, 2013 application software multiple times to meetbusinessneeds
• Engaged Project team and vendors in critical thinking for several issues resolution.
• Ability to multi-task and prioritize depending on the situation and ongoing needs of stakeholders.
• Participated in Software unit testing, integration testing, system testing, test scripts creation
• Production Deployment and go-live preparation
• Facilitated onboarding of Business partners to Enterprise CRM service

Confidential, NY

MS Dynamics Functional Analyst

Responsibilities:

• Successfully Designed, Implemented and administrating MicrosoftDynamicsAX 2012 R2 Retail Environment from Develop, Test, UAT, Stage and Production Environment with full high availability with load balancing configuration including SQL Always Feature.
• Documented, designed, built, tested and implemented new pricing, taxes, and feesengine integrated withMSDynamicsAX 2012.
• Involved in customization of forms, SSRS Reports, mapping of reports, imported data from Excel toDynamicsAX.
• Configurations of Retail Components includes Retail Scheduler Jobs, Retail Channels, Channel data group, Channel DBs and Catalogs, Products
• Installation and administration of Windows 2012 R2 Cluster with SQL ServerAlwaysOn features. AX SSRS load balancing, Integration services and Analysis Service andDynamicsManagement Reporters.
• Implemented and conducted training for client work place staff on utilizing the CRM applications software. Attended weekly meetings to analyse MS dynamics AX CRM, Sales, Marketing, Services, Inventory Management and MRP business needs. Customized forms, SSRS Reports, mapping of reports, imported data from Excel to Dynamics AX.
• Microsoft Dynamics AX Application configuration and setup serves as primary support liaison.
• Producing business flows, functional understanding documents, training guides (User manual) and solutions design document related to Microsoft Dynamics AX. Provide Functional level training to End users, map the business scenarios on Microsoft Dynamics AX.
• Acted as a liaison between users and Dynamics AX ERP system developers gathering and documenting requirements in SharePoint.
• Forecasted workflow changes and maintained BRD, FRS, Requirement Traceability Matrix, and testing tools for MS dynamics AX CRM. Involved in Dynamics AX Application Setup activities and customized the apps to match the functional needs of the organization.
• Migrated Microsoft SQL Server 2000 to Microsoft SQL Server 2005.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment. Migrated Microsoft Analysis Services to SQL Server Analysis Services (SSAS).
• Development and delivery of testing strategies, E-learning of Microsoft Dynamics Products including AX through Partner Source. Installation and administration of Windows 2012 R2 Cluster with SQL Server AlwaysOn features. AX SSRS load balancing, Integration services and Analysis Service. Dynamics Management Reporters.
• Involved in configuration of General Ledger (G/L) module, Chart of Accounts and Financial dimensions based on the requirement with the help of advance rule Structure.
• Configuration of main accounts, legal entities, intercompany transactions, accounting currency, reporting currency, Journal names and numbering system.
• Involved in configuration of Account Receivable (A/R), payment schedule, terms of payment, payment day, cash discount, method of payment, posting profiles, customers and customer groups and collection cases.
• Involved in customization of forms, SSRS Reports, mapping of reports, imported data from Excel toDynamicsAX.
• Involved in writing SSIS packages for migrating data toMSCRM from SQL and generating reports using SSRS and experience in configuringMSCRM withMSoutlook and SharePoint Integration.
• Designed and architected on customizing AX Retail POS Customer creation and Warranty acceptance page to work with companybusinessprocess.
• Worked directly with the client in requirements gathering, identifying the Gap fits, suggesting the solutions for requirements, addressing the requirement as perDynamicsAX and walk through in AX for client approval.
• Troubleshoot software failure to determine causes for system failure as well as be responsible for ad hoc reporting.
• Assisted testers in developing a variety of possible Test Scenarios and Test Cases to ensure that the system built according the requirements.
• Worked closely with thebusinessusers for each area to elucidate the User Acceptance Testing (UAT) strategy.
• Conducted data mapping and manipulation to create meaningful reports usingMSExcel (Pivot table, V Lookup, Queries etc.)
• Implemented and executed data mining projects to create reports to provide insight into sales, purchasing opportunities and trends and marketing.
• Monitored database performance and resolved process failures to ensure data was available on a timely basis to meet user reporting requirements.
• Partnered with developers to convert the Human Resource reporting system from aBusinessObjects platform to MicroStrategy in support of IT cost reduction efforts.
• Produced complex reporting for Sprint'sbusinessunits utilizing SSAS databases, SSRS, and MicroStrategy which empowered users to analyse customer behaviour and makebusinessdecisions.
• Developed and documentedbusinessrequirements and rules for reporting dimensions in creation of an enterprise data warehouse.

Confidential, Framingham, MA

Business Analyst (MS Dynamics)

Responsibilities:

• Provided knowledge transfer ofDynamicsAX functionally andbusinessprocess and assisted the team in defining their local IT methodologies and standards.
• Role spans fromBusinessRequirements Analysis, Functional Design Documentation, Technical Designed Documentation, Development, Testing and Deployment and oversee day to day operation • Helped analyse new waysDynamicsAX and custom development could help streamline operations in the firm, documented functional requirements, and worked with development teams to communicate functional requirements and deliver the necessary solutions.
• Proposed and designed a custom module that can integrate with AR, AP and Inventory Management
• Designed integration project plan to develop integration betweenDynamicsAX and third-party CRM and e-commerce site using AIF.
• Designed and architected on customizing AX Retail POS Customer creation and Warranty acceptance page to work with companybusinessprocess.
• As a team member participate in full life cycle ofDynamicsAX implementations and support forDynamicsResources clients.
• Configured all database backup plans and make sure all running smoothly, and managed database logs.
• Responsible forDynamicsAX and AX Retail POS training of clientbusinesssubject matter experts and end users.
• Analysesbusinessprocesses by working with users to translate requirements into functional specifications forDynamicsAX modifications.
• Designedbusinesssolutions, process flows and procedures, sometimes of a complex interrelated nature.
• Created detailed Functional Requirement Document (FRD) perBusinessRequirement document (BRD) and user requirements using Power Designer.
• Created detailed design of the system using UML diagrams (Sequence Diagrams, Activity Diagrams, Use Case), Data Flow Diagrams usingMSVisio.
• Analyze the requirements and map them with ERP systems (MicrosoftDynamicsAX) without much code customization.
• Managed Requirement Traceability Matrix (RTM) to ensure test cases are traceable to requirement specifications.
• Used SQL during the testing phase to verify and validate that the correct information is being provided.
• Enhanced and deployed the SSIS packages from development server to production server and scheduled jobs
• Acted as liaison betweenbusinessowners, developers and QA team to ensure enterprise data needs were met and worked closely with-it Project Managers to report project progress.