Mehul Solanki

Experience

• 

  ICICI Lombard

  Jul 2005 - Jan 2006

  WFM /MIS ASSOCIATE

   Streamlining the entire project data which is now maintained in a schematic database in MSAccess which makes generation of reports and analysis much easier. Analysis of Quality, Productivity and Performance parameters and preparing reports for the same Generating graphs based on requisite parameters. Generating dynamic reports for Operation Managers, Service Delivery Leaders, Assistant Managers, Quality Assistants and Team Leaders. Keeping track of Incident Reports (system down time, voice & data down, system clocking, link down…etc) and zeroing in on the problem. Keeping track of incentives of employees with respect to their sales. Burning and Maintaining CDs of Sales and Voice Recording System (VRS). Prepare Roster of employees Shift wise. Keeping track of system used and vacant. Show less

• 

  Hutchsion 3 Global Services (H3GS)

  Feb 2006 - Jul 2008

  MIS Analyst

   Preparation of Internal Reports for 15 processes of 3 Global Services Australia. Reporting includes performance day on day for all the processes. Designing new tables in SQL for easier extraction of reports as per the requirements. Analyzed and Optimized MS SQL Server production databases. Maintenance of regular Backups and Restore. Creating and implementing database design solutions in collaboration with programming team. Extraction of data from SQL with Queries & executive in VBA for generating reports. Implemented Database Snapshot for reporting tools. Preparing the Stored Procedure for various Transfers Dashboards to use them in VBA code. Preparing the Weekly as well as Monthly reports. Preparing Absenteeism and Exceeded break reports. Worked on Aspect Agent Admin, Aspect Director and Seagate Info Desktop System. Maintaining and Creating User and Login.  Workforce management on the floor including break management. Preparing Database Transfer Services (DTS) designing Templates for import/export data. Manage all Appraisal and Incentive Data for every Employee in Australian Operations. Manage the Database of Employees in SQL and Excel. Providing complete movements of an employee during the Tenure of Organization. New dimensions added to Attrition reporting. Providing all Payroll Relation Information to Finance for Payout of Salaries for all Employees. Report to the management about the service level and other activities on a daily basis.Core Strengths: -o Interactive report with Excel and SQL using Macros.o eWFM Admin and Implementation.o Preparation of various MIS Reports.o Presentation of report using various Business Object, SQL and Excel Formulas and Properties. Show less

• 

  Wipro Technologies

  Jul 2008 - Nov 2016

   Writing Automated scripts to test the CITI Web application. Develop clear and easily used interactive code or function. Clearly formulate analytical hypothesis MIS Reports - Design Automated Dynamic reports using VBA Macros as requested by Clients. MIS Reports : Designed various analytical report to identify the progress of Defects and Testcases. Develop business presentations to communicate the solution to a potentially broad array of functional teams and senior managers. Develop and deliver on-going standard reporting/decision support tools as requested by the base of clients. Created Dashboard, Audit trails, TAT (Turn-around Time) report, Test Execution, Defect Linked to Testcases Status, Scripts Impacted, Failed-Blocked Testcases Reports. Perform ad-hoc analysis to support it, communicate results clearly, and understand cause & effect relationships Help develop a state of the art MIS infrastructure using process automation tools. Interface with clients to design data driven analytic and reporting solutions primarily using HP Quality Center, VBA Macros and SQL. Weekly WSR report presented to Clients. Framework Development: Developed an automation framework to interact with Quality Center and generate the reports using SQL queries. Designing Deployment Testing reports for various Project Releases and Cutover. QC SQL Server Schema: Experience on writing advance SQL queries to retrieve defects, Testcases data. Developed good knowledge on QC 10.0 database schema. Extensive experience in MSBI, SSIS, SSRS, Tabular Data Modeling and Semantic layer implementation. Experience in Understanding of data warehouse concepts and ETL processes.Core Strengths:o Designing various dynamic MIS Reports. Reports designed to auto trigger emails.o Presentation of report using SQL and Excel Formulas and Properties.o Analyze the report and send the overview to seniors. Show less  Manage team to provide support for Global Wealth Management (GWM) Group Client in North America. Preparing Service Delivery Plan, Statement of Work and Project Level Agreement and Presentations. Manage Process control and process documentation function. Document business unit’s scope and service level description using ISO standards based approach. Study, analyze and prepare ISO documents as per project requirement. Preparation of Reports for three Zones and Eight regions in US using Stored Procedure. Coordinating with Project Managers to chase reports timelines & summarize the project details. Represented WIPRO from India for testing of Planview 9.1 and PTS-W, it’s a project management tool. Designing Query using SQL on Business Object XI for generating report from Web Intelligent. Business Object XI R2/R3 is reporting tool used for Planview 9.1 and PTS-W. Designing interactive tools for Microsoft Products using VBA and Macros. Designed interactive tool using SQL, Excel and Visio 2003. Designing Automated reports for Daily, Weekly and Monthly dashboards. Creating Town hall slides for client’s Quarterly presentations. Creating Initiatives, Programs, Projects, Milestones and Work-Orders in PTS-W. Resources Management in projects. Keeping close track on Timesheet update, notification and alert. Keeping close track on Program\​Project End-date update, notification and alert. Follow-up with respective Program\​Project Managers. Comparing Actual\​Forecast cost of project on MTD, Weekly and Month-wise.Core Strengths:o Interactive report with Excel and SQL using Macros.o Tools - Planview, SalesForce, PTS, Admin, Business Object.o Handling Team for Preparation of various MIS Reports.o Presentation of report using various Business Object, SQL and Excel Formulas and Properties. Show less

  • Assistant Manager

    Jun 2015 - Nov 2016

  • Senior Executive

    Jul 2008 - Jun 2015
• 

  NTT Global Data Centers & Cloud Infrastructure India Private Limited

  Nov 2016 - now

  Business IT Manager

  Carry out business analysis for applications used in business of Data Centre hosting,Cloud Computing, Data and Infra-management.Prepare documents for BRS (Business Requirements Specifications), Requirement Traceability Matrix, Test Cases.End to End to project management for the project own by Business IT team.Prepare Project Plan, Project Chart, Weekly and Monthly Project Report.Responsible for gathering business requirements and technical specifications from the users.Delivered all the projects and assignments within the specified time lines with accuracy.Strong ability to work within a demanding and aggressive project schedules and environments.Strong knowledge in designing and developing QlikSense dashboards by extracting data from different sources like Sales Force, SQL Server, Oracle, SAP, Flat Files, Excel files, XML Files.Worked installation, configuration and upgradation, environment, system analysis, design, deployment, testing of projects.Experience in optimizing BI Tools and QlikSense applications to improve the performance.Developed QlikSense objects like Multi Boxes, Straight tables, Pivot tables, Containers, Line charts, Bar charts, Combo charts, Scatter charts, Line objects, Pie charts, Buttons.Proficient in troubleshooting and fixing the QlikSense dashboard issues.Extensive experience in creating Pixel Perfect reports, Excel reports, Word reports,Hands on experience in customizing the QlikSense and NPrinting reports as per thebusiness requirements.Created incremental load process to load the data into QlikSense applications from different source systems.Involved in Performance Tuning and Deployment of QlikSense applications.Involved in Inter-departments and management coordination in delivering Business Intelligence Solutions.Understanding of data modeling, dimensional & relational concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.MSBI experience in SSIS, SSRS, Tabular Modelling, Power BI. Show less