Summary:
Eleven years experience as Technical –Functional in Peoplesoft Financials and HRMS. Five years experience as a Technical and Functional Consultant in Microsoft Dynamics GP 8.0, 10.0, 2010, QuoteWerks 4.0, Scribe, and Microsoft Dynamics CRM 3.0, 4. and CRM2011. Certifications in GP and CRM.

Experience:

Confidential,CRM TechnicalConsultant

• Performed integrations to other systems.
• Performed upgrade from CRM4.0 to CRM2011
• Setup SSIS integration packages.
• Create plugins and workflows.
• Created Reports according to customer’s specs
• Develop technical specs for clients.
• Perform data migrations.
• Integrate Microsoft Outlook and setup Email Router.
• Create knowledge transfer documentation.

Confidential,CRM Consultant

• Perform CRM4 upgrade to CRM2011 in the Cloud.
• Setup SSRS Reporting.
• Created Reports according to customer’s specs
• Develop technical specs for clients.
• Perform data migrations.
• Create plugins and workflows.
• Integrate Microsoft Outlook and setup Email Router.
• Create knowledge transfer documentation.
• Create custom views and SITEs.

Confidential,GP2010 Technical Consultant

• Perform GP2010 upgrade from GP10 for Finances and Inventory.
• Install SQL Server 2008
• Created Reports according to customer’s specs
• Train users on how to use reports, as well as, create queries.
• Develop technical specs for clients.
• Perform data migrations using Integration Manager.
• Integrate FRx and SSRS reporting with GP. Customize reports according to customer specs.
• Create stored procedures.
• Implement Inventory and Project Accounting modules.
• Setup environments (instances)
• Prepare functional specs for Inventory and Project Accounting for client’s approval.
• Setup Inventory and Project Accounting configuration.
• Perform data mappings for Inventory and Project Accounting modules.
• Used connections used for reading and writing data from one application to another.
• Wrote complex code in GP and based it upon unique business roles using SmartConnect.

Confidential,PM / MS Dynamics CRM and GP Techno-Functional Consultant

• Provide installation of GP and CRM for GP upgrade from v8 to v10 and for CRM upgrade from v3 to v4.
• Install SQL Server 2008
• Created Reports according to customer’s specs, via Crystal Reports v1.
• Train users on how to use reports, as well as, create queries.
• Develop technical specs for clients.
• Wrote functional and technical specs, per client’s interview sessions.
• Conduct Reporting Training, as per client’s requests.
• Create stored procedures.
• Create queries according to customer’s specs.
• Migrate reports and queries to various levels of environments after they’ve been tested and approved for ‘move’.
• Worked with the business users/developers to perform QA testing based on document business requirements.
• Configure and write code to interface from either between modules or from one env to another..
• Perform code changes and enhancements.
• Wrote component interfaces.
• Create customized queries as per client’s request.
• Create reporting customization documentation for knowledge transfer.
• Build and customized queries and interfaces with other applications.
• Create forms, dept trees, new menus, and fields.
• Build functions in access with mappings of fields.
• Extract data from excel to access db for reporting.
• Create customized queries and SQL queries.
• Created scope and reporting definitions.
• Created, customized, and modified crystal reports version 11.
• Install SQL Server 2005
• Gather requirements, analysis, definition, and coding.
• Design the approach of Data Warehouse implementations, implement best practices, and perform BI assessment of client projects
• Hands-on knowledge of Data warehousing ETL and OLAP reporting tools, methodologies, Dimensional modeling, solution architechture, data profiling, data cleansing, and testing.
• Front End Reporting design of cubes using MS OLAP Services, and OBIEE.
• Database Design Development
• Experience working with Oracle 10g, DB2, and SQL Server
• Configure GP modules: AP, AR, GL, and AM. Configure CRM modules: Sales and Marketing.
• Setup and configure Scribe and Scribe Console.
• Lead Offshore and Onshore team.
• Prepare SOW and Project Plan.
• Setup meetings to ensure all issues are resolved.
• Perform two way customizations to and from GP and CRM.
• Coordinate installation of 3rd party tools such as tax software
• Setup and configure picklists and workflows.
• Setup security configurations for GP and CRM.
• Install hotfixes for CRM environment.
• Setup GP and CRM Test environments for UAT.
• Create test plans for GP and CRM testing.
• Setup and validate integrations.
• Create test servers for clients, as well as, upgrade databases.
• Perform unit and system testing for both GP and CRM
• Develop enhancement reports and modify existing GP and CRM reports via code.
• Migrate opportunity, customer, contact history, calendar records, accounts, order, invoice, and purchase order data from MS Dynamics CRM 3.0 to Microsoft Dynamics CRM 4.0
• Integrated FRx 6.7 with GL module, provided FRx training to users, and created reports according to client’s specs.
• Hands on Implementation experience with FRx Forecaster, Report Designer, Report Launcher, Drill Down Viewer, Report Server, and Report Manager v6.7.
• Setup MS SQL Server DB, web services, system services (workflow, metadata, integrations), query model, setup ad hoc queries, plug in services, and reporting services
• Customize and extend MS CRM, setup infrastructure, setup SQL Server 2008, setup MS Exchange Server, IIS, Biztalk, setup CRM integrations, Sharepoint, use C#.net.

Confidential,Functional Consultant

• Implement and install CRM 4.0.
• Install SQL Server 2008.
• Configure CRM: Marketing, Accounts, Opportunity, Products, and Campaign.
• Prepare Functional and Technical Documents for client.
• Customize CRM environment per client’s specs.
• Customize reports and integrate MS Outlook with CRM.
• Create test plans for CRM testing.
• Create test servers for clients, as well as, upgrade databases.
• Perform unit and system testing for both GP and CRM
• Document specs and perform knowledge transfer to the client.
• Setup opportunity, customer, contact history, calendar records, accounts, order, invoice, and purchase order data for Microsoft Dynamics CRM 4.0