Business Analyst - Project Manager
OSN
Total years of experience :23 years, 4 Months
Define and document information sets, system procedures and internal BI processes.
Analyze and assess feasibility, costs and risks of upcoming projects.
Coordinate with stakeholders and department heads and ensure information alignment with business strategies.
Gather and document requirements from business users and channel requirements to the development team.
Track and document changes to the BI platform.
Consolidate and maintain internal BI documents in a single repository.
Translate technical literature into understandable business definitions.
Act as a liaison to business users and send regular updates on ongoing and future developments.
Identify and assess opportunities for improvement within the BI department’s internal processes.
Build and manage all large scale BI team projects and initiatives.
Perform risk assessments and ROI analysis on new business intelligence projects and implementations.
Liaise with internal and external auditors during audit engagements.
Accomplishments
Streamlined internal BI request process to improve business user and BI developer experience thereby increasing efficiency and setting deliverable expectations.
Created a master project plan for the business intelligence team thereby simplifying the tracking of priorities and expectations.
Documentation of all internal BI processes and suggested areas for improvement.
Met with all stakeholders to prioritize reporting needs and gather requirements for upcoming data migration.
Data Analyst/ QC Control/ Project Manager
• Perform ad hoc and trend analyses to produce actionable information to support decision making. Leverage enterprise business intelligence tools, queries and other data discovery and manipulation tools to develop complex models and reports.
• Partner with the business teams to develop SAS Enterprise Miner Churn Prediction Model, dashboards and operational reports to optimize retention initiatives.
• Track and measure retention campaign performance, working closely with operational teams and managers conducting outreach activities.
• Work with supervisors, managers, and executives to translate business problems into actionable reports and analysis.
• Leverage understanding of underlying data structures and connections to bring new insights to the organization.
• Evaluate business requirements and formulate a technical design in conjunction with the data warehouse team.
• Create functional / technical specifications to document design approach.
• Build visually engaging presentations and reports, to satisfy reporting requirements.
• Complete data validation and facilitate end user testing on designed reports and dashboards.
Accomplishments
• Reduced early churn by a total of 3%-5% by implementing actionable rewards/ penalty procedures
• Reduced Billing and Collection attempts without hindering successful collections thereby reducing costs to the organization.
• Managed implementation of Predictive modeling analysis by working closely with external consultants and cross departmentally to implement Churn Prediction Model Scores and Segmentation analysis to be integrated, updated, and utilized by all departments with the main objective of lowering overall churn by 1.5% annually.
• Created targeted retention campaigns designed to proactively target high risk subscribers.
• Created KPIs at the campaign and agent levels.
• Created and managed proactive retention team and training manuals.
Data Analyst/ Production Coordinator
• Collecting and extracting raw data from government and private sectors.
• Manage, build and maintain databases using Microsoft Access, Esri FGDB, and SQL. Efficient knowledge of Python and Model Builder.
• Create and provide data content for Esri software within release deadlines.
• Process and integrate international demographic and market potential datasets for overseas clients for use in Business Analyst.
• Plan and execute data collection, entry, analysis, and editing.
• Compute data, summarize results, and prepare reports or charts to support software and data development.
• Verify data products comply with requirements prior to delivery, identify inadequacies, and take corrective action.
• Deliver data in Comma Separated, dBase, Excel, Shapefile, and Fixed Field based on contract requirements.
• Expertise in producing customized maps based on clients requirement.
• Experience with creating high quality thematic and topographic maps.
• Experience with site prospecting analysis using Esri Business Analyst.
• Testing Esri Maps for Office in Arabic.
Accomplishments
• Increased data delivery turnaround time from a standard 10 business days to 5 business days.
• Worked extensively with programmers to streamline internal data extraction tools that resulted in increased accuracy and customer satisfaction by 35% according to team management.
• Worked with warehouse to create standard deliverable DVDs and metadata documentation. This resulted in expedient data delivery time and increased customer knowledge of data methodology.
• Trained internal staff on data extraction and formatting to meet stand alone data orders.
• Created manuals and documentation that simplified employee training and workflow.
• Created new quality assurance processes that assisted software developers integrate data content seamlessly and decreasing bug reports.
• Increased sales team efficiency by revamping the organization of historical data and past data deliverables resulting in effortless research of past orders for sales team to access for returning clients.
Auto Damage Adjuster
• Used Mitchell software extensively to write and submit auto damage estimates.
• Interacted with customers and auto body shops to assess damages and determine the validity of the claim.
• Inspected vehicle damage ranging from minor fender-benders to extensive damage caused by major accidents, hurricanes, floods and other disasters.
• Estimated the cost of vehicle repairs, negotiated equitable settlements and issued payments.
• Managed mapping/dispatching project the entire Auto Damage department.
• Conducted department meetings with associates in self-appraisal procedures.
• Standardized department letters, memos and monthly reports.
Claims Representative
• Analyze case facts and related claim information to determine accurate and appropriate compensation while identifying potential fraud for each property and auto claim.
• Investigated claims by conducting interviews and inspecting property damage to determine liability based on existing insurance and traffic laws.
• Facilitated all paperwork for policy holders while calculating and delivering accurate property damage and medical payments.
• Negotiated with claimants in order to settle various claims outside the courts.
• Reviewed and explained insurance contracts to clients and claimants.
• Settled claims while adhering to contractual guidelines and insurance laws.
• Consult with professionals to assess the calculations of residential and commercial properties.
Accomplishments
• Created mapping and routes that resulted in more effective use of field auto damage adjusters.
• Created new claim file organization that improved claim handling.