SUMMARY:

• Fifteen years of report development experience, including but not limited to inventory control, general ledger, inventory reconciling, accounts receivable, product sales history, product pricing, purchase history, purchase forecasting, customer intelligence, delivery schedules, order dispatching, trend analysis and bar coding.
• Nine years of creating Reporting Services (SSRS) reports.
• One year of Jet Reporting experience.
• Nine years of SQL Server experience, including analysis, data quality and performance monitoring, T - SQL, Stored Procedures, Reporting Services (SSRS)
• Seven years of Microsoft Dynamics AX experience including but not limited to the following modules: production, trade and logistics, financials, GL, AR, AP, human resources, inventory and warehouse management, project management and accounting
• Extensive experience communicating and collaborating with end users on technical requirements, outcomes, and data integrity.
• Extensive involvement designing, developing, managing and delivery reports.
• Solid Electronic Data Integration (EDI) experience with several enterprise databases, including Oracle, SQL Server and Microsoft Access

PROFESSIONAL EXPERIENCE:

Confidential

DATABASE DEVELOPER

Responsibilities:

• Responsible for designing and developing SSRS reports based on AX 2012/AX 2009.
• Designing, developing and delivering reports using Power BI.
• Developing Jet Reports using Dynamics AX 2012 as datasource.
• Interaction with business users, analysts and developers to translate business needs into requirements
• Data Warehouse development using Jet Enterprise and Microsoft Stack.
• Develop SSIS ETL packages for Data Warehouse.
• Assist in integration of relevant data source for Data Warehouse.
• Developed integration scripts to import forecasting information from Demand Solutions to Microsoft Dynamics.
• Requirement Gathering.
• Developed complex stored procedures as data sources for Reporting Services.
• Modified Microsoft Dynamics SSRS reports including but not limited to Sales Invoice, Sales Confirmation, Packing Slip, Free Text Invoice and Statement of Account.
• Data Migration.
• Collaborate with users to prepare SSRS reports.

Confidential

Microsoft Dynamics Jet Reports Analyst

Responsibilities:

• Responsible for designing, developing and delivering reports using Jet Reports.
• Modifications and Enhancements to Jet Enterprise Data Warehouse.
• Interaction with business users, analysts and developers to translate business needs into requirements
• Created Snippets to update Jet Enterprise Data Warehouse.

Confidential

Microsoft Dynamics Analyst

Responsibilities:

• Responsible for designing, developing and delivering reports based on AX 2012.
• Support for Dynamics AX 2012
• Form Development
• Form Enhancements

Confidential

Microsoft Dynamics Business Intelligence Developer

Responsibilities:

• Responsible for designing, developing and delivering reports based on AX 2012.
• Create reports using Power BI.
• Develop SSIS ETL packages for Data Warehouse.
• Assist in integration of relevant data source for Data Warehouse.
• Responsible for designing, developing and delivering SSRS reports based on Microsoft CRM (Off Premise)
• Requirement Gathering.

Confidential

Microsoft Dynamics Report Writer

Responsibilities:

• Responsible for designing, developing and delivering SSRS reports based on AX.
• Developed integration scripts to import forecasting information from Demand Solutions to Microsoft Dynamics.
• Developed SSRS report from a Data Warehouse.
• Requirement Gathering.
• Developed complex stored procedures as data sources for Reporting Services.

Confidential

Microsoft Dynamics Report Writer

Responsibilities:

• Responsible for designing, developing, managing and delivering SSRS reports based on Microsoft Dynamics AX 2012
• Modified Microsoft Dynamics SSRS reports including but not limited to Sales Invoice, Sales Confirmation, Canadian Invoice, Free Text Invoice and Statement of Account.
• Data Migration.
• Develop complex queries and stored procedures to be used as a data source for SSRS reports
• Develop SSRS reports for AX 2012 using X++.
• Collaborate with users to prepare SSRS reports.
• Use TFS and changesets to track code modifications.

Confidential

Data Analyst

Responsibilities:

• Responsible for designing, developing, managing and delivering SSRS reports based on Microsoft Dynamics AX 2012
• Develop complex queries and stored procedures to be used as a data source for SSRS reports
• Develop SSRS reports for AX 2012 using X++.
• Collaborate with users to prepare SSRS reports
• Requirement gathering

Confidential

Senior Consultant

Responsibilities:

• Responsible for designing, developing, managing and delivering SSRS reports based on Microsoft Dynamics AX
• Collaborate with users to prepare SSRS reports
• Develop complex queries and stored procedures.
• Requirement gathering
• Gap analysis
• Created SSRS reports in multiple languages.
• Developed SSRS reports for AX 2012 using X++.
• Created SSRS report for AX 2009 based on stored procedures.
• Data Warehouse development using Jet Reports.

Confidential

Data Systems Analyst

Responsibilities:

• Created custom reports using SSRS from Microsoft Dynamics AX SQL Database.
• Migrated data from Legacy System to Dynamics AX.
• Enhanced Dynamics AX interface using MorphX.
• Modified existing AX reports using X++.
• Requirements gathering, migration planning and business analysis.
• Automated vendor payments using SQL and MS Access.
• Administered users for Sharepoint and SQL Reporting Services.
• Developed custom complex SQL views, stored procedures, functions related to the custom solutions or reports.
• Trained Users on Sharepoint site.

Confidential

Database Developer - Report Writer

Responsibilities:

• Created reports using SSRS from the data warehouse.
• Worked with different departments to define requirements and produce adhoc reports.
• Responsible for requirements gathering and design of functional specifications.
• Developed complex stored procedures as data sources for Reporting Services.
• Extract information and results from the data warehouse.
• Created SSRS data driven Subscriptions.