Sql Server Manager
Resume:
Jiyaulhuk R
Email:***********@*****.***
Mobile:+91~979*******
mailto:**********@*****.*** %0D%0D%0C
mailto:**********@*****.*** %0D%0D%0C
Summary
* ***** ** ** ******** experience in multi technology environments such as Microsoft Dynamics GP, Microsoft Dynamics RMS, MS-SQL Server Reporting Services 2005 & 2008, Microsoft .Net, Microsoft SQL Server 2000,2005,2008.
Strong technical knowledge in Microsoft Dexterity, VBA, e Connect, MS-SQL Reporting Services 2005 & 2008,MS SQL Server 2000,2005,2008 & 2012,Microsoft Dynamics CRM Connector For GP.
Hands-On experience in reporting tools – Dynamics GP Report Writer, SQL Server Reporting Services (SSRS).
Hands-On experience in Customizations, Design, Development, Maintenance & Enhancements and GP Web service Installation and configuration
Strong knowledge QuickBooks to GP Migration and strong knowledge in GP upgrade.
Design using Visual Studio.Net 2005,2008,2010 as front-end
Experienced in interacting with Clients
Has good experience in analyzing business applications
Learned many new technologies within short span of time
A good team member driven with effective communication and presentation skills
Technical Skills
ERP : Microsoft Dynamics GP 10.0/2010/2013/2013R2
Languages : Sanscript,
Database : MSSQL Server 2005, 2000, 2008 R2, 2008 & 2012
Front-end Tools : Microsoft Dexterity, c#,ASP.Net
Integration Tools : eConnect, Microsoft Dynamics CRM Connector for GP, Integration Manager
Reporting Tools : GP Report Writer, SQL Server Reporting Services 2005 & 2008, Management Reporter
Operating Systems : Windows Vista/XP/2000, 7, 8, Windows Server 2003, 2008 & 2012, Linux
Other tools : MS CRM-GP integrator
Education
Bachelor of Engineering – EIE, 2014, 69%, Easwari Engineering College - chennai.
Professional Experience
Jeganee Technologies, Chennai, India.
Project Experience
Auto Posting Inventory Transfer
Project Description
Automate the posting process in Inventory transfer Entry window using SQL Server SP.
Responsibilities:
Understanding the Requirements
Writing stored procedure in sql server 2008R2.
Testing the posting process
Technology Environment:
Dynamics GP 2013SP2, MS SQL Server 2008R2.
Customizing Reports in Report Writer
Project Description
Customizing the RM Transaction Report, Bank Reconciliation Reports, Cash Receipt reports as per user needs.
Responsibilities:
Understanding the Requirements
Customizing the Reports in Report Writer
Testing the Reports
Deploying the Reports
Technology Environment:
Dynamics GP 2013SP2, Report Writer.
Dynamics GP Support
Project Description
Giving the support for ISGN Novasoft .Provide complete Functional support for the finance team.
Responsibilities:
Understanding the Functional Requirements
Solving the hurdles faced by Finance team in dynamics GP
Providing solution for new requirements.
Technology Environment:
Dynamics GP 10.0, 8.0 MS SQL Server 2005,Frx Reporting, Report Writer.
Al Muntazah GP and RMS support
Project Description
Giving the support for Al muntazah super market’s GP, RMS and other application. Implementing the reporting tools and management tools of GP.
Responsibilities:
Understanding the Functional specification documents
Providing technical support for MS RMS and Dynamics GP
Unit testing and functionality testing
Preparing application documents
Technology Environment:
SQL Server 2005 & 2000, MS Dynamics GP 10.0 & 2010, MS RMS,VBA Modifier, Integration manager, MSBI tools
Al Khawarizmi GP2013 Upgrade and Support
Project Description
Upgraded GP8.0 to 2013 and giving the support for Client GP application
Role: Technical Consultant
Responsibilities:
Upgraded the GP version 8 to 2013
Understanding the Functional specification documents
Implemented new GP tools for business process
Transfer the requirement to subordinates.
Developing the Products as per the requirements
Fixing the issues
Unit testing and functionality testing
Preparing application documents
Technology Environment:
SQL Server 2008 R2, MS Dynamics GP 8.0/GP2013, Integration manager
NPM – GP2013 Implementation & Support
Project Description
Implemented Dynamics GP2013 and migrated data from existing Quickbooks ERP system.
Role: Techno Functional Consultant
Responsibilities:
Requirement gathering
Prepared implementation plan
Implemented GP2013
Migrated data from existing ERP
Preparing Functional specification documents
Understanding the Functional specification documents
Implemented new GP tools for business process
Transfer the requirement to subordinates.
AIPE – GP2013 Implementation & Support
Project Description
Implemented Dynamics GP2013 and migrated data from existing ERP system.
Role: Techno Functional Consultant
Responsibilities:
Requirement gathering
Prepared implementation plan
Implemented GP2013
Preparing Functional specification documents
Understanding the Functional specification documents
Implemented new GP tools for business process
Worked in customizing Sales Order and Purchase order window.
Transfer the requirement to subordinates.
Client support
TrinDocs Purchase Order Automation
Project Description
To automate the purchase order creation after purchase requisition process and to generate the custom Trindocs Purchase order Report.
Role: Technical Consultant
Responsibilities:
Create dll in .Net to automate the PO creation in GP.
Create custom tables in database to store the data from customized fields.
Integrate the Dynamics GP with third party PDF Creator software to print documents.
Manual Testing.
Implementation in client system.
Provide support for the client.
Prepared User training Documents.
TrinDocs Document Management
Project Description
Customized Purchase Order Entry Window and integrated 3rd party PDF creator Add-ins to the GP.
Role: Technical Consultant
Responsibilities:
Customize the Purchase order entry window.
Create custom tables in database to store the data from customized fields.
Integrate the Dynamics with third party PDF Creator software to print documents.
Manual Testing.
Implementation in client system.
Provide support for the client.
Prepared User training Documents.
Estimated Monthly Consumption Forecasting-EMC
Project Description
To develop a forecasting modules as a solution for the purchase department in dynamics gp.
Role: Technical Consultant
Responsibilities:
Requirement gathering
Designed and developed the GP windows with dexterity using sanscript
Designed SQL tables, Procedures, views
Manual Testing
Developed Crystal Reports.
Personal Profile
Name : Jiyaulhuk R
Date of Birth : 07th Sep 1989
Marital Status : Single
Languages Known : Tamil,Telugu,English
Permanent Address : 120 Compost yeard street,
Theni-625531,
TamilNadu,
India
Mobile : +91-979*******
Nationality : Indian
Passport : Yes (Details on Request)
Declaration
I hereby declare that the details furnished above are true to the best of my knowledge and belief.
[Jiyaulhuk]
Contact this candidate