Zahid Keshodia

ZAHID NAZIR KESHODIA MICROSOFT POWER PLATFORM, DATA SCIENCE PROFESSIONAL, SHAREPOINT, WORKFLOWS, QLIK SENSE Experienced Data Analyst and Visualization Expert with over 8 years of proven expertise Personal Information in uncovering valuable business insights. With a total professional experience of 16 years, Phone: - I bring a deep understanding of data analysis, dashboard creation, and visualization Email:-techniques. I excel in developing comprehensive analyses tailored for C-Level Executives. By LinkedIn:www.linkedin.com/in/zahidkeshodia effectively communicating complex findings, I facilitate informed decision-making and assist in identifying critical areas for improvement. Lives in: Karachi, Pakistan One of my key strengths lies in my ability to simplify data interpretation by creating Areas of Expertise intuitive online dashboards. By consolidating information from various sources, I Microsoft Power BI eliminate the need for manual data retrieval, reducing time delays and mitigating blind spots in decision-making processes. Microsoft Power Apps / Flows PROFESSIONAL EXPERIENCE Feb 2022 Manager IoT / Automation To Date Cnergyico PK Limited (Previously as BYCO Petroleum Pakistan) Manage software that streamlines processes, automates manual workflows, and sets up measurement tools that generate actionable insight. Coordinate, communicate, and negotiate with 3rd party vendors for purchase of goods or services. Also serve as a PMO-coordinator in the implementation of SAP RISE IS-OIL; responsible for maintaining best practices and documenting project status and strategy in one place. Jun 2015 Manager Information System. Jan 2022 Independent Media Corporation Private Limited Plan, execute, monitor and control the different stages of software development life cycle, applying the techniques of project management; while satisfying client requirements within defined timeline, and meeting the standards of quality through relevant tools. Major responsibility includes:  Managing a team of staff including programmers, analysts and supports.  Evaluating the functionality of systems.  Consulting computer users to ascertain needs and to ensure that facilities meet user or project requirements.  Providing user training, support, advice and feedback.  Testing and modifying systems to ensure that that they operate reliably.  Designing maintenance procedures and putting them into operation. Previous Roles @ Independent Media Corporation Private Limited. May 2012 May 2015 Associate Manager Information System Jul 2008 Apr 2012 Senior System Analyst Dec 2005 Jun 2008 Senior Software Engineer Nov 2004 Software Engineer Nov 2005 ApplicationXS Private Limited As a Software Engineer, I am responsible for the development, maintenance and implementation of customized Share Clearing and settlement system integrated with GL system, for brokerage houses of KSE (Karachi Stock Exchange) Dec 2003 Software Developer Oct 2004 Sidat Hyder Morshed Associates. Responsible for the analyzing client’s requirement, development, maintenance and implementation and to provide technical support to their clients of ongoing project. All development was done using Microsoft Visual Studio 6.0, SQL server, and SHMA’s Customized Software for Reports. Advance Intermediate Qlik Sense / Qlik View / Tableau Intermediate Google Data Studio Intermediate R Studio, Python ,ML Fundamental Awareness Oracle Business Intelligence (OBIEE) Beginner Nintex Workflow 2016 K2.Net 2003 Intermediate Expert Microsoft SharePoint 201x Microsoft SQL Server 20xx Intermediate Advance SSRS + SRS Mobile Reports Microsoft .NET 20xx (VB.NET/C#) Advance Advance Technical Qualifications Big Data and Visualization Workshop Institute of Business Administration (Dec-2019) MCTS: Microsoft SharePoint 2010, Application Development (Exam 70-753) Microsoft SharePoint 2013 Administration and Application Development, Park Avenue Office, Karachi Workflow Management System (K2.NET) Imitation Technologies, Karachi. QUALIFICATION- Masters of Computer Science (MCS) - IQRA University (Karachi - Main Campus) Bachelors of Computer Science - IQRA University (Karachi - Main Campus) Inter-Commerce - Commecs Institute of Business Education (CIBE) Matriculation (Science) - Board of Matriculation, Karachi Page 1|4 . ZAHID NAZIR KESHODIA MICROSOFT POWER PLATFORM, DATA SCIENCE PROFESSIONAL, SHAREPOINT, WORKFLOWS, QLIK SENSE PROJECTS’ QUICK REVIEW CNERGYICO PK LIMITED (PREVIOUSLY AS BYCO PETROLEUM PAKISTAN) AUTOMATIC TANK GAUGE REPORTING AND APP Tools The Rosemount is a black box application that’s integrated with the instrument positioned in tanks to major the multiple level/temperature of a liquid/material in it which helps in managing the upcoming operation and decisions.       As it’s a black box solution the only possibility to share the reading with others is by email and as per specific format build in the application, also having limitation while extracting the historical data. Integration with Rosemount ATG System. SQL Server 2019 Microsoft Power Apps Microsoft Power Automate SQL Server Integration Services. SQL Server Integration Services. To cater the limitation, I had reviewed the entire Rosemont application to collect the maximum data as possible to generate the Data ware house and make reports enabled to others over terminals and mobile. So this purposes utilize the SQL DataMart, Integration Services and reporting services to generate and designed the reports. Also utilize the Power Automate to fetch the data using Stored Procedure from onpremises server and use Power App to allow user to review the updates over Mobile/tablets after every hour. HAZIREE REGISTER (ATTENDANCE REGISTER APP) Tools Brief of the projects is provide the functionality to review the attendance sheet over mobile/desktop by every individual all over the corporate office as well as refinery site to enable the user to track their monthly time sheet to avoid any discrepancy in payroll.     SQL Server 2019 Microsoft Power Apps Microsoft Power Automate SQL Server Integration Services. Major functionality includes:  Time sheet on each individual  Time sheet view by HODs of respective members.  Division/ Department Level Summary of Man-Power  Details of each Division / Department to identify late comers and early going staff. CRUDE OIL MARKET TRENDING REPORTING Tools BLOOMBERG AND OIL-PRICE.COM      To review the change in CRUDE OIL prices mostly people utilizing Bloomberg and OilPrice.com websites. A DataMart being created to collect the data from Bloomberg Free APIs and scrapping the Oil.Price.com using python; enable the users to also review the historical data which may help them in making some decisions. Bloomberg Free APIs Python SQL Server 2019 Microsoft Power BI. SQL Server Integration Services. INDEPENDENT MEDIA CORPORATION PRIVATE LIMITED YOUTUBE ANALYTICS AND REPORTING Tools Initially the reporting of YouTube channels been done utilizing the YouTube Data Studio; which includes manual intervention to generate the query with limited features as per management requirement.      To make it hassled free and make data available to multiple users with historic data; I had written the script in Python to connect with YouTube provided APIs, extract the data, import in a SQL DataMart and developed the Analysis in Power BI for the End User having multiple trends and shares. YouTube Analytics and Reporting APIs. SQL Server 2019 Microsoft Power BI. Python. SQL Server Integration Services. Key dimension/metric includes: Dimension: Day, Country, Traffic Source, Video, Tags, Age Group. Metric : Views, Hourly Watched, Like, Dislike, Shares, Comment, Subscriber Gain /Lost, Estimated Revenue Page 2|4 . ZAHID NAZIR KESHODIA MICROSOFT POWER PLATFORM, DATA SCIENCE PROFESSIONAL, SHAREPOINT, WORKFLOWS, QLIK SENSE ELECTION DATA HQ Tools Had developed the multiple Analysis by utilizing the Microsoft Power BI Report server for the TOP management based on the historical and LIVE result data recorded in the application. Includes:  Comparison of previous election results.  WHAT-IF analysis on multiple scenarios to help the management to review the probabilities of changes and finalization of any result.  Candidate Analysis – current vs previous elections  LOTA Analysis  Time Trail analysis – to review the changes in party seats over time.  Election Pulse Analysis - create an analyses; shows: o The party votes over time by multiple channels o The percentage of result announced by multiple channels over time o Highlight any discrepancy o Highlight the impact of rejected votes. o Etc.  SQL Server 2017  Microsoft Power BI on-premises report server  Internal Web App to access the reports. EXECUTIVE’S DASHBOARDS Tools These are specially designed and developed Dashboards for Organizational CEO as well as other Chief Officers (i.e., CMO, CFO, COO, CTO etc). These dashboards help those people to take the right decision at right time, through Business’s deep analysis of the business health.     These dashboards provides information based on multiple dimension, covers:  Network and Industry Channels performance based on revenue, rating viewership, power ratio etc.  Top 10 Agencies with bifurcation in Network and Industry Business.  Top 10 Clients with bifurcation in Network and Industry Business.  Cost per rating point analysis to provide insight of channel performance in correlation with revenue, rating and other facts.  Sales Team performance.  Channels’ booking status along with the dropped business impact.  Programs’ Cost Benefit Analysis.  SharePoint Server 2013 SQL Server 2016 SQL Server Reporting Services (SSRS) Microsoft Power BI – cloud and onpremises. R Language for Forecasting ORACLE BUSINESS INTELLIGENCE – AT GROUP LEVEL Tools Key member of the implementation team for Oracle’s Business Intelligence implementation at Group Level includes Geo and Jang. Responsibilities includes; gathering information from user champions and higher management to set the phase wise milestones of the implementation, identification of the sources, creation of data mart and make it available for ELT process to finalize the subject area and to design the reports and Dashboard for users and management.     ROSHNI Platform : Windows based application Roshni is a powerful MIS that caters vital areas of Sales, Traffic, Transmission /Publishing, Monitoring, Billing and Receivables of different means of Jang GroupParent Group of GEO TV Network. It has three separate, but fully integrated instances for Television, Radio and Print Media. Tools This application furnishes Jang Group, GEO Television Network and Clarity Media business in a smooth fashion by automating and revamping organizational processes. Dynamic design of application triggers the organizational growth by managing credit history and evolution reasoning reducing the organizational risk factor. Right now “ROSHNI” is being integrated with Oracle Financials (EBS), and the Process of Billing would be transferred to EBS.     SQL Server 2016 OBIEE 12.2c OBIDV 12.2.2 Different tools for data import and management Visual Studio .NET 2010 SQL Server 2012 Crystal Report 10 Infragistics NetAdvantage 2012 Page 3|4 . ZAHID NAZIR KESHODIA MICROSOFT POWER PLATFORM, DATA SCIENCE PROFESSIONAL, SHAREPOINT, WORKFLOWS, QLIK SENSE GEO-NEWS MANAGEMENT SYSTEM Platform : Windows based application Geo News Management System is designed to automate news room process from story creation to putting it in rundown along with Integration with MOS devices and rich and easy user interface. Tools System covers workflow of news room system from assignments, pools to rundown. System is capable to communicate with other MOS devices like Prompter, VIZ, Play out servers etc. Easy to use and have rich UI features like Drag n Drop, Splits, Filters, Context Menus, Hot keys, etc. Strong administrative and security area. Analyses links : Reporter Summary , Headline Analysis       SALES PORTAL Tools Sales force automation through Sales Portal was an interesting and challenging project which was accomplished successfully and helped the organization in achieving the bench marks of Sales and recovery targets. Marketing collaterals, e-flyers and Agreements/Deals management was the add-on product which covered the sales cycle from contracts to execution of the sales order.    Visual Studio .NET 2015 SQL Server 2016 R2 Crystal Report 10 Infragistics NetAdvantage 2012 MOS Protocol Integration K2.NET (For News workflow) SharePoint Server 2013 SQL Server 2012 SQL Server Reporting Services (SSRS) Executive’s performance was measured through the daily activity reports. Sales team Incentive management based on sales and recovery targets achievement on bi-annual basis is one of the major areas of this product. PRODUCER’S WEB PORTAL Tools Producers’ Web Portal is an online tool designed to help the producers to manage the production of a program from the concept to the pre and post production stages till on-air. All concept papers will have a tag number which will be easy to track the program status from the concept paper to on-air. It will facilitate the producer to schedule his program’s production, make budgets and get them approved online. They will have access to programming standards and guidelines regarding promos and episodes being produced for on-air.     FORFEIT – PAYROLL MANAGEMENT SYSTEM Platform :Windows based application FORFEIT is a comprehensive payroll system, integrated with attendance system helps user to execute salary process efficiently, it includes various types of adjustments like appraisals, bonuses, incentives, IDP taxes, Flood surcharge and other custom adjustments with auto tax calculation, Bank file and email system to email pay slips to employees, it also creates JVs for posting in GL system. Tools TECHNICAL RESOURCE MANAGEMENT Tools Technical Resource Management is an online application designed to help technical dept. in resource planning, execution and their utilization. TRM covers all important areas of technical dept. operations like Items Inventory, Staff Profile, Staff Duty Roster, Kits Management, ENG, OB and studio management. TRM streamline the process from requisition to job completion through rich and easy user interface. TRM Dashboard provides great insight of resource planning and utilization at a glance.            K2.NET 2013 SQL Server 2008 R2 Crystal Report 10 Visual Studio .NET 2005 Visual Studio .NET 2015 SQL Server 2012 Crystal Report 10 Infragistics NetAdvantage 2012 SQL Server Reporting Services (SSRS) Visual Studio .NET 2015 SQL Server 2012 Crystal Report 10 Infragistics NetAdvantage 2012 SQL Server Reporting Services (SSRS) Single R Page 4|4 .