Responsible for administration and customization of databases and business intelligence software ensuring smooth access to information by users across the organization.
My responsibilities includes, Daily backups, Daily, weekly maintenance plans, performance tuning, Security and access right assignments.
* Developed an enviroment for automated report emailing to Business heads, Daily schedule at start of the day, for analysis and planning.
* Development of customized reports for analysis on different pattrens, like financials, gross profit, performance code wise etc.
*Development and implementation of business process and their execution with high level integrity and efficiency, as per requirement analysis.
* Proper guidance and training to MIS team for implementation and support for provided objective without any mishandling.
* Management of overall MIS related tasks, ability to cascade management vision to team so that they are able to timely meet and deliver results as well as right involvement in application related decisions in favour of comapny's business.
* When performance issues arise, determine the most effective way to increase performance including hardware upgrade, server configuration changes, or index/query changes.
* SQL server Installation and Configuration as per Microsoft Dynamics AX requirement.
* Identifying list of top 10 most resource-intensive queries on the server and troubleshoot and emphasize query performance by changing design without effecting results.
* Design indexes for ERP and applications, choosing when to add or remove indexes.
* Creating and designing database for several tasks like enumeration purpose or reporting requirement.
* Designing Views and Stored Procedures, Designing tables and picking datatypes.
* Using Profiler traces and other tools to find the most frequently run queries.
* On-call troubleshooting for SQL Server service outages
* Planning and Configuration of DB mirroring, replication, clustering, log shipping.
* Designing and creating Cubes for BI tools enhancement.
* Designing DW and updating via ETL process by using Integration services.
* Direct Excel Import to DB using several methods.
* Designing reports Using SSRS, MS SQL Report Builder.
* Designing Excel Based Reports using intelligent queries in Views or SP.
* Conducting and in-line with Developers for customization in App's or developing utilities for ERP.
* Administrating MS Dynamics AX\ MS SQL DB and BI Security and user right assignments with Application administration tasks like troubleshooting in daily business ERP operations, posting issues, stucking workflows, slow app response, services issues etc. with that maintaining test servers with updated DB's.
* Deploying and managing Automated excel based reports for Business heads, managed using windows task scheduler and programming behind excel to get update and email automatically as per schedule.