System Analyst ERP/DBA
FAHSS/TUV
Total years of experience :19 years, 10 Months
Responsible in conducting business requirement gathering, analysis and data model design; assist in the business process re-engineering; documenting requirement specification and test plan; and involved in change management activities, e.g. implementation/training. Also facilitate user group discussion for requirement gathering and business process review. Managing all databases.
Manage Projects including System Analysis and Design and Implementation, strategic planing.
Works on Microsoft Dynamics AX 2012, Customization and DASH Board Designing.
• Monitor performance of application and database servers to provide best performance.
• Having strong SQL Server troubleshooting skills.
• Database Mail functionality: write special stored procedures for administrative purpose i.e. to work as Database Mail Notification.
• IIS configuration to setup applications with relevant security parameters and DOS based scripting.
• Database backup and restoration i.e. management by console and scripts for file groups etc.
• SQL Server Reporting Services (SSRS) configuration, designing and scheduling setup for email etc.
• Design various complex queries /T-SQL scripts/cursors/ stored procedures etc to provide performance effective solutions for faster access to database objects and to minimize locking.
• Research and design various T-SQL scripts which provide information form system databases which support in database management tasks.
• Design scripts to perform various database maintenance tasks i.e. database re-indexing, shrink, truncating log files i.e. manually and with SQL Server Agent on schedule time.
Experienced in all aspects of SQL Server administration including clustering, disaster recovery and security best practices, upgrading SQL 2000 to 2005 to 2008.
•Implemented successfully CRM/AX Server, by sitting with key personals of the management specially business managers who deals in all kinds of stuff like payroll/HR Management/Sales (Banking Products)/Retail/Advances for planning, development, testing, debugging.
•Successful designed flow of GL Accounts which are they main role player of the entire Dynamics AX application for finance/accounts.
•Design scripts i.e. stored procedures for New Reports of CRM/AX as per management requirement.
• Deadlock monitoring on live databases on MSSQL 2005/2008 i.e. to provide high availability (24X7)
• Monitor performance of application and database servers to provide best performance.
• Having strong SQL Server troubleshooting skills.
• Database Mail functionality: write special stored procedures for administrative purpose i.e. to work as Database Mail Notification.
• IIS configuration to setup applications with relevant security parameters and DOS based scripting.
• Database backup and restoration i.e. management by console and scripts for file groups etc.
• User creation and permission management on database objects by T-SQL or by console studio and maintain the required documentation.
• SQL Server Reporting Services (SSRS) configuration, designing and scheduling setup for email etc.
• Design various complex queries /T-SQL scripts/cursors/ stored procedures etc to provide performance effective solutions for faster access to database objects and to minimize locking.
• Research and design various T-SQL scripts which provide information form system databases which support in database management tasks.
• Design scripts to perform various database maintenance tasks i.e. database re-indexing, shrink, truncating log files i.e. manually and with SQL Server Agent on schedule time.
Experienced in all aspects of SQL Server administration including clustering, disaster recovery and security best practices, upgrading SQL 2000 to 2005 to 2008.
•Implemented successfully CRM/AX Server, by sitting with key personals of the management specially business managers who deals in all kinds of stuff like payroll/HR Management/Sales (Banking Products)/Retail/Advances for planning, development, testing, debugging.
•Successful designed flow of GL Accounts which are they main role player of the entire Dynamics AX application for finance/accounts.
•Design scripts i.e. stored procedures for New Reports of CRM/AX as per management requirement.
System analysis and design of Information System, as per Company’s requirement for the execution of their operational and administrative departments i.e. lead to design an in-house ERP System.
Major rule is System Analysis, Designing and Restructuring of old systems and Integrating old and new system, migration from old system to new where as possible, team management of IT (Software Development), coordinating with all departmental heads of operational units/departments and also provide support in deployment and maintenance of database/information systems.
During the tenure I have managed the following projects with my team
•General Ledger System
o Analysis and Designed General Ledger System (GL) for Accounts Department. GL System Includes all management reporting (i.e. Cash Book, Expenses, General Entry e-t-c)
o Designed Accounts Receivable/ Payable System along with integration with operational systems of Insurance departments and along with the management of previous system.
o Integration of Accounts Receivable/ Payable with GL Accounting System.
•Payroll Accounting System
o Analysis and designed Database Management System for Payroll Accounting System.
o Provide training to the users and designed management reports as per company’s requirements.
o Also provide training of Database management and performance improvement.
•Inventory Control System.
o Analysis and design information system to management the entire item’s purchasing and used in/out for the company along with reporting.
Successfully Passed Exam Microsoft Technology Associates DBF