Manawar Hossain

Md. MANAWAR HOSSAIN MOB- #- Email-- SUMMARY Accomplished, analytical, innovative and result-oriented with more than 10 years of experience in Business/Data Analytics with tools like VBA, R programming, Power BI, Excel, Access, google spreadsheet with JavaScript, SQL. Experience: - 10+ years TECHNICAL SKILL SET Analytics using R, Power BI, KNIME, SAS, SPSS, Tableau, Advanced Excel, Alteryx. VBA expertise with Microsoft Office tools, Microsoft Excel Advanced Dashboard Reporting. SQL Server with MSBI (SSIS, SSAS, SSRS), PervasiveSQL SQL, HTML, Google App script (JavaScript). Exposure to Predictive analytics, Machine learning & Big data technologies like Hadoop & SparkR. EDUCATION Post Graduate program in Business Analytics & Business Intelligence (PGPBA-BI) from Great Lakes Institute of Management -). ENGLISH (Hons) from Delhi University (2007). Work EXPERIENCE Accenture (Strategy/Capability Network) - Gurgaon, India 3rd Apr 2017 – Present Program and operation Senior Analyst PowerBI, VBA, Access, Excel, Tableau development. Leading the implementation, development & design of dashboard/reporting data module for different data sources (Sales/financials/chargeability etc) into PowerBI ecosystem. Developed at least 2-3 visualization options for each report for discussion with stakeholders, created POC for dashboards in PowerBI and sold to stakeholder. Gathering and documenting business requirements for analytical reports. Integrated Custom visuals based on the requirement using PowerBI. Developed complex calculated columns and measures using DAX and for pivot/un-pivoting datasets created a standard custom re-usable M query module. Managing access of dashboard/reports and data for individual users using role level security. Providing continued maintenance and development of bug fixes for the existing and new PowerBI, VBA based tools. Amaris Consulting – Shanghai, China 5th May 2014 – 19th April 2016 Consultant – Business/Data analysis, VBA development, ETL, data migration etc Automating and streamlining the process of data migration/reports using VBA, SQL, MS office tools etc and helping to generate accurate data for migration to load into Target system (JD Edwards Oracle ERP). Requirement gathering and coordinating among different functional teams from different business entities and giving expert suggestion on ETL & data migration process from Legacy system (SAGE ERP) to Target system. Development work on the ETL programs, automated the data migration process. Developed online timesheet for different entities in google spreadsheet, automated the data entry step, consolidation part, dashboard/reports etc using Google App Script (javascript). Evalueserve ltd – Shanghai, CHINA 24th Sep’2012 – 4th May 2014 Technical/Senior Data Analyst – Corporate and Professional services Worked in the Knowledge center (Shanghai office) of a Magic circle law firm as a Technical data analyst/Lead. Liaising with key stakeholders to define client requirements and understand business priorities, responsible for coordination and administration work among London data team, India and Shanghai data team. Leading and assisting 5 members Shanghai data team on all the data management issues, report developments, streamlining the reporting process, small technical projects on SQL & VBA and ad hoc requests, responsible for work allocation amongst the team members and defining the turnaround time for projects. Tools – SQL server 2008, MS office including Access, Web based reporting tools and VBA and SQL to automate the reports. Migration of data from a legacy to upgraded CRM system from sources such as outlook contact folders and other locally held repositories such as Excel or Word documents. Responsible for data management, reporting, knowledge management systems, CRM system implementation & maintenance and data analysis. ENF Business consulting co Ltd – Wuhu, CHINA 7th Dec’2011 – 21st Sept’2012 Seniore data analyst & VBA/Excel/Access Developer– Automation Department Data Analysis of Market research data using MY SQL,MS Access and Excel. Designing automated templates using Access, Excel, Word to improve the data processes and automated Analysis. Assisting in the production of commercial reports. Developing VBA macros for Access, Excel, Word, Outlook and PowerPoint. Assisting other departments in streamlining the process and giving training on Excel, Macro. Freelancer/Consultant Aug’2010 – Sep’2012 Business/Data analysis, Report development, streamlining the process Worked with a Principal consultant from US based firm on different projects related to VBA/Excel/Access and Business Intelligence projects as a freelancer for more than two years. Worked with a German manufacturing client (Shenzhen/Hong Kong based – 4-5 months project). Created Access based database/ERP system and reporting tools from scratch where they had different departments for report/analysis consolidation such as – Final Inspection, Production Inspection, Supply Chain Inspection, contact data/employee data etc. GENPACT, Gurgaon August 2007 – September 2010 Senior Associate/Business Analyst – Analytics (Business Intelligence) Technical Skills used in Genpact – MS SQL Server (2000,2005& 2008), VBA, MS ACCESS, Excel, SQL, BO. Was working for GE FLEET TELEMATICS as a Telematics Analyst, Analyzing the data that was sent via Telematics unit on the vehicles. The work involved creating Trend Analysis, Productivity Analysis and other projects for various customers and streamlining the process using Lean methodology by automating manual Reports using MS Access & VBA, below are some analysis we do on quarterly, monthly and weekly basis- Trend analysis is done to determine the cost associated with idling, speeding and exception drives for fleet on weekly or monthly basis so that customers can act on reducing the same. Productivity Baseline Analysis: to get the average work time at customer location, average windshield time as well as average commutes time per day by a vehicle. Report out the performance of all the drivers specially on Speeding and Idling for the whole Fleet Level Wise Point of Interest analysis is build around each point of interest (location) to determine the operating & labor cost for each point of interest. Return on Investment is used to analyze the return on monthly cost of a Telematics unit. This gives the value associated with each telematics unit. Automated various monthly and quarterly reports for GE Fleet using VBA. GE European Equipment Finance (EEF) Collections Reporting including Risk Analytics, collections weekly & monthly & Telephony performance analysis using tools like, Data Warehouse (BO), Access Database, Excel and PowerPoint and communicating with client on a daily basis. Got expertise in Excel and VBA. Worked with Corporate Quality Team for Service Delivery Fundamental project and was doing reporting for about 3 months. MIS agent for CAS-ANZ, was producing daily, weekly & monthly various productivity reports for agents using tools like SQL SERVER (2000 & 2005), Excel. HOBBIES Reading Novels and listening to music. PERSONAL DETAILS Father’s Name M G Rasool Nationality Indian Date of birth 30th September 1984 Language known English, Hindi, Arabic and Urdu Date (Md Manawwar Hossain) Place