ZULFIQUAR SHAIKH

Profile Highlights as Senior Business Analyst:

 Analyzed requirements received from Advisors to Supreme Committee, and other leadership teams to prepare tournament time Projections and reports.
 Understanding the data points and designing multiple Reports & Dashboards for MOC (Main Command Center) to monitor critical processes related to FIFA World Cup Readiness & Delivery, and monitoring KPI.
 Worked on TTDM (Tournament Time Demand Module) for detailed analysis of Arrival, Departure, and In-country visitors.
 Provide detailed analysis for Daily Executive Summary, on Transport facility for Fans & Match Spectators, Entry-Exit by Air and Land border, and activities at Fan-Zones during the match day & rest days.
 Post-tournament analysis on Projection vs. Actual.

Profile Highlights as Senior Manager - Business Intelligence Analytics & MIS Reporting

 Head the MIS-Reporting and Analytics department for the entire Garment Division.
 Formulate Annual Operating Plan and monthly Projection for all three existing & proposed manufacturing plants.
 Design and implement KPI and SLA for effective monitoring of critical processes.
 Circulate monthly Business Performance reports & presentations to higher management and Board members.
 Streamline and automate existing reports in Excel using templates, Macros, and Dashboards.
 Publish the P&L (projection/estimation), and other Financial, Operational, and Analytical reports.
 Working on a project to implement a Business Intelligence application
 Gather and Validate Requirements raised by different stakeholders for new developments (Application module / Reports).
 Consulting management for effective monitoring, reduction of Working Capital, Conversion Cost, and Material Balance.

Profile Highlights as Business Data Analyst - Consultant:


 Streamlined the Business Data Analytics / MIS-Reporting process for the Asset Affairs division.
 Gathering Business Requirements from different stakeholders for monitoring the processes.
 Assist in transforming the Reporting process from manual to automated mechanism using Excel Macro, and SQL query.
 Managed cross-functional Dashboards for different business units, for nationwide monitoring. Such as,
o Network Customer Complaint & Resolution Monitoring (SLA) Dashboard: based on CRMS (MS-Dynamics 365) data.
o Repeat Customers and Repeat Complaints dashboard.
o Analytical Dashboard to visualize the Effectiveness of Major Projects and Investments
o Asset Condition Dashboard based on IBM-Maximo (EAMS) and ArcGIS, for assessing Operational Risk.
o Dashboard for country-wide Treatment Plant Operations Monitoring.
 Manage Periodical and Adhoc Management Reports for the Directors and other stakeholders.
 Catchment analysis to identify the impact of projects on Network Customers during different stages of the project.
 Publish Monthly Business letters on Assets and Asset Performance for the higher Management team and Directors.

Profile Highlights in MIS - Reporting & Business Intelligence Analytics role:

 Manage the MIS-Reports & Business Intelligence Analytics unit.
 Prepare monthly Reporting Schedule for the entire Babyshop Concept.
 Publish various financial reports on Budget Achievement, Margin and Markdown; on the Scheduled and Adhoc basis.
 Write OBIEE queries, Excel Macro, and Templates to ensure Quality, Accuracy and Consistency of MIS-Reports.
 Prepare a number of Analytical reports to analyze Sales Promotion Impact, Customer Purchasing Patterns.
 Publish end-to-end analysis on stores performance, on a quarterly basis.
 Responsible to provide and validate MIS-Reports & Other Inputs for Top-Management presentations and Board meetings.
 Circulate MIS-Reports on Stock, Purchase Orders, Sales Performance, Royalty Payouts, Customer Footfall, KPI Reports for Stores & Productivity Reports
 Initiated Customer Loyalty Reports (based on Shukran Customer Transactions)
 Streamlining Reporting process in other GCC countries.
 Resolving Adhoc requirement of Reports & other MIS related clarifications.
 SPOC for the concept (Babyshop) for all MIS-Reports and Data Analysis related requirements from within the Concept or from Landmark Group.


Profile Highlights as Business Analyst in implementing Business Intelligence Tools:

 Gather Requirements for implementing Business Intelligence Tools from various Process owners and Management Team.
 Validation of Requirements raised by various business users.
 Coordinate with Software Developers to implement new Requirement and Change Requests.
 Managed Business Requirement Documents (BRD) & Functional Specification Documents (FSD) to incorporate changes.
 Facilitate the BI Consultants on clarifying Business Rules.
 Update the Management Team on the ongoing development status.
 Conduct UAT to finalize the development.
 Responsible for Data Upload and Accuracy in OBIEE ER application and QlikView.
 Devised Dashboards, Reports, and Alerts in QlikView.
 Maintenance of OBIEE (Enterprise Reporting) & QlikView (Business Intelligence) application for the Concept.
 Conducted Training sessions on QlikView usage to various Process owners and Management Team.
 Maintain the Master Database in BI applications.
 Responsible for Preparation & Maintenance of Sales Budget in BI Applications.

Profile Highlights as MIS - Reports & Business Intelligence Analytics Deputy Manager:

 Manage the MIS, KPI Reports, Financial Reporting, and Predictive Analysis process.
 Designed new Reports for Management Team and Board of Directors, to analyze Business scenario.
 Automated existing Financial, Sales and Operational reports using OBIEE (DSS), Hyperion, MS-Excel Macro, Formulas & MS-Access queries.
 Design various Dashboards, Reports and Alerts in DSS (Decision Support System), the BI application of Reliance Retail.
 Prepare Financial Reports and Monthly Profit-and-Loss report for all the 172 stores and HO Overheads.
 Prepare COGS, Gross Margin Report to analyze the major city-wide performance of each item shipped and sold within a specified time period.
 Analyze the Inventory status on a monthly basis and suggest the Marketing/SCM department take the necessary steps to mobilize the Non-Moving stocks.
 Inventory and Stock Analysis to identify Intercompany Margin, Inventory-Aging, Damage/Shrinkage status.
 Budget - Business Strategy Planning for the coming financial year, for both Stores and HO Overhead expenses.
 Prepare Presentation for Board of Directors, in every quarter for the board meeting.
 Monthly and Quarterly Reporting to Reliance, INDIA and Grand Vision, Netherlands.
 Maintain Database and Portal for Financial and Sales data.
 Budget and Achievement reporting in Hyperion.
 Maintenance of Sales Target & Expenses Budget in Hyperion.
Hungama Digital Media, Mumbai (INDIA)

Profile Highlights as MIS - Reports & Business Intelligence Manager:

 Generate various Analytical Reports for all the major verticals of the organization on a Periodical & Adhoc basis.
 Prepared Report Templates to maintain the accuracy of MIS and maintain TAT.
 Managed a team of 4 Sr. Executives, 3 Executives, and a Management Trainee to execute below activities:
• Maintaining a Tracker for Raw/Transaction Data that we receive from Internal & External clients.
• Analyze data to identify possible anomalies and other discrepancies before processing the same in BI tool.
 Prepare Presentations for Internal and External clients.


Profile Highlights as Business Analyst (Business Intelligence Tool implementation Project):

 Requirement gathering from Top-Management to implement business rules in the Business Intelligence tool.
 Managed the complete Project Life-Cycle of BI (Business Intelligence) application implementation project.
 Shouldered the responsibility of Information Gathering from various Departments to design Automated Dashboards and various MIS - Reports.
 Structured the Database to maintain uniform Metadata for the entire business.
 Maintenance of User-Login access and privacy of data.
 Analyze all the available Archived and Current Data to design the ETL Process.
 Lead a team of Consultants, Programmers and Business Analysts to implement the customized BI tool.
 UAT and validation of reports and finalization of customized Dashboards.
 Synchronize the processes of MIS, Legal, Finance and Content Distribution vertical to remove the process-gaps.
 Managed the MIS-BI Operations and ensured processing of data in BI application within defined TAT.
 Constantly engaged in identifying further Enhancement of the application and possibility of Incorporating with other Internal & External Applications.
 Monitoring performance of Servers for Ensuring smooth Functioning of BI tool at various locations.
 Designed Automated Tracking System to track various Functions of MIS, Legal and Finance department and for Data Flow.

Significant Highlights of BPR profile

1) Analyzed existing process using SIPOC methodology to remove Process Gaps.
2) Designed new application according to SIPOC to meet Customer’s Voice and to achieve Process Excellence.
3) Restructured the Policy Issuance Process based on ‘Time-N-Motion’ analysis to expedite the NB process and to remove the bottlenecks from the process.
4) Designed the Application to efficiently manage the OPUS-Indigo Helpdesk and resolve customer issues within TAT.
5) Significantly contributed in implementing Centralized Policy Issuance Process at West Hub at Pune head-office.
6) Monitoring Centralized New Business Process through various reports and exception MIS to identify process gaps.


Significant Highlights of Managing Projects & Operations

1) Managed a team of more than 23 people (comprising Scrutiny-Verification unit, Data Invocation unit and Policy Under-Writers) to organize the ‘Time-N-Motion’ analysis for NB Process.
2) Instrumental in designing ‘Renewal Premium Chasing’ process to increase the retention ratio for existing customer and to increasing the Renewal Premium Collection volume.
3) Managed OPUS-Indigo (the core application at Bajaj Allianz Life Insurance Co.) Help-Desk team to resolve all IT & Application Related queries raised by different process owners.

Software Skill Used : MS-Access, MS-Excel. and Visual Basic

Profile Highlights as Process Leader, MIS

1) Significantly contributed in setting up MIS factory for entire Service Central, which was instrumental for Dashboard for new business and financial operations.

2) Prepared weekly MIS and Exception report for top management to review New Business and Business Loss.

3) Generated monthly payment dishonored report for Financial Operations.

4) Prepared weekly ECS (‘Electronic Clearing System’) to track the mandate lodgment status for various vendors.