Hany Elgayar

  • Analyst
  • Greater Los Angeles Area
  • Jun 24, 2018
Full time Healthcare Informatics Project Management | Project Manager | Project Coordinator Security | Security Analyst Systems Analyst

Personal Summary

An innately charismatic and ambitious personality combined with a diverse professional background in Management Information Systems, SAP Business Objects Reporting, and Finance, creating a truly driven, passionate and inspired Programmer Analyst. • Posses unique combination of technical knowledge and business savvy to identify key data needs in the business and utilize reporting resources to address these needs. • Proven record of meeting customer needs while working on multiple responsibilities with tight deadlines. • Specialties: SAP Business Objects Reporting, reporting automation, data modeling, statistics, BI reporting, competitive analysis, social marketing, web response metrics (email/ direct marketing), sales reporting & analysis, ad hoc analysis,market data analyst, tech savvy, data mining, data driven results, business data analysis, reporting and data analysis. • Skilled in preparing reports and presenting complex technical information in non-technical language with the ability to analyze problems and make recommendations. • Demonstrate initiative and discretion in handling complex, sensitive, and confidential information. • Expert at gathering requirements and developing functional and technical specifications. • Experience working with and supporting Financial Organizations a part of larger corporate environments. • Posses fundamental knowledge of budgeting, financial analysis and techniques. • Experience with IBM PC utilizing: MS Office for Windows versions though 2013 (Word, PowerPoint, Access, Project, and Excel) • Experience with Data Mapping and SAP CRM Reporting Tools (Web Intelligence Business Objects, and Desk Intelligence Business Objects).

Work Experience

Senior Data Analyst
Nov 2016 - May 2018 Care1st Health Plan
  • Work with business program development team to manage and monitor performance of the Enrollment Service and Cal MediConnect Program.
  • Utilize objective data analysis to perform program performance assessments and identify opportunities for operational improvement.
  • Support daily business and enrollment operations for Medicare Advantage Prescription Drug plan

(MAPD) and Medicare-Medicaid plan (MMP) product lines.

  • Assist with the development of Care1st's new programs and produce lines.
  • Ensure that Care1st programs efficiently and effectively comply with regulatory requirements and

meet Care1st's goals.

Marketing Database Management Consultant
Mar 2015 - May 2016 UnitedHealth Group
  • Responsible for effective configuration, operation, and maintenance of system(s).
  • Served as Subject Matter Expert on Business Objects reporting, Data Warehouse, Data Marts; guided the development design activities with assumptions and data dependencies. 
  • Reviewed upgrade documentation related to Business Objects reporting and content, determined the best implementation approach. Evaluated, anticipated and communicated risks to existing reports and processes, and recommend ways to mitigate those risks.
  • Performed in-depth data analysis by writing complex PL/SQL queries on various source systems, data marts and data warehouse to find trends and anomalies in the data in support of the requirements for various strategic projects. 
  • Assisted in system resolution. Participate in technical research & development to enable continuing innovation of system(s) needs, benefits, and technical strategy, technical analysis & design, and support in executing, enhancements.
  • Interacted with internal marketing, information technology maintenance and development as well as external vendor partners.
  • Responsible for system monitoring, Electronic Data Interchange (EDI) maintenance, issue resolution and operational & training documentation, system release coordination, and User Acceptance Testing participation
Project Analyst
Apr 2013 - Jun 2014 Edison International
  • Applied research methodologies and techniques to design and conduct analysis with the purpose of improving and streamlining processes regarding data flow and quality to improve data accuracy, viability, and value.
  • Monitored performance of Business Objects reports and took corrective action to optimize or improve the performance of the reports when necessary.
  • Managed the inventory of SAP Business Objects-based reports used for published reporting. Assured that the metadata used for the Report Catalog is meaningful, standardized, complete, accurate, and up to date.
  • Maintained CRM Tracking and Performance Reports utilizing Business Objects. For example, I validated CC COE Analysts Activities, and bounced the data against live CRM data. This resulted in helping BCD Data Analysis & Reporting group to resolve data discrepancies and discovering root - cause of systems issues.
  • Consulted with IT Project Management, product development, and operations concerning efforts and testing plan around creating /enhancing product value propositions based on data quality improvements.
  • Preformed SAP CRM User Acceptance Testing.
  • Solved issues with SCE My Account login, data migration, password reset, and account linkage. Coordinated with other internal SCE organizations to ensure customer care issues were appropriately resolved or addressed responded to customer historical usage data requests.
  • Utilized the CRM ‘E - mail Inbox’ functionality which allowed viewing and processing e - mails present in Lotus Notes Inbox in CRM. I was able to efficiently and promptly communicate to internal clients by associating Lotus Notes e - mails to their correct account/activity in CRM.
  • Operated CRM as part of my daily routine practice to process customer care requests through CRM Customer Care Center of Expertise (COE). And also directed and instructed some users for creating a Customer Interaction Log and E - Mail Interaction in order to link them to the customer care sales task.
Business Analyst
Mar 2007 - Apr 2013 Edison International
  • Administered tracking and reporting on various State - mandated initiatives impacting department functions such as energy efficiency projects, and energy usage.
  • Performed in-depth data analysis; develop database models, database processes and functional analysis across various lines database methodologies specific to Business Objects
  • Managed Climate Action Plan reporting initiatives for the entire company with a strong focus and sole responsibility for all sales and account management optimization efforts.
  • Initiated and laid groundwork for a database to centralize reporting and make it accessible online with secured access. Go - To person for all reporting questions and requests. Influenced the scope, objective and regulatory work around Community - Wide data requests. I enhanced the existing automated tool (leveraging advanced queries in Microsoft Access) to fit not standard reports.
  • Supported Partnership Sustainability Initiative Data Team in developing and Electronic Data Interchange (EDI) for integration into utility manager system for all Local Governments Municipal accounts. This identified kWh savings opportunity and provided additional information for enterprise energy management.
  • Delivered high quality holistic dashboards/reports for business insights on a daily, weekly and monthly basis by working creatively through various systems including internal data storage.
  • Developed detailed Evaluation, Measurement and Verification (EM&V) analysis. Developed a Cost Benefit Analysis utilizing Microsoft Excel tool to assist small commercial customers in identifying areas of savings by participating in Energy Efficiency programs.
Systems Analyst
Jan 2006 - Jun 2006 California State University, Long Beach
  • Provided project management in all areas of Student Administration and Bursar business system implementations by directly managing technical projects from inception through completion.
  • Translated business requirements into technical specifications. Directly coordinated the efforts of project teams. Produced tangible deliverables in the form of project plans, issue lists, status reports, white - paper analyses, recommendations, prototypes and completed development projects.
  • Facilitated cross - functional communication and system implementation involving multiple business and technical areas.
  • Ensured that systems are customer - focused, integrated, efficient, documented, and in compliance with best practices and legal requirements.
  • Ensured that processes and systems conform to all CSU and campus requirements regarding security and personal privacy.
  • Analyzed and evaluated various business processes pertains to implementing 8.9 PeopleSoft’s version upgrade, resulted in streamlining the current process work flow.
  • Evaluated and analyzed various Module reports and documents, in coordination with management. The documents were presented and utilized in Tech Object Database Upgrade Statuses, and Remedy Tickets Module Meetings, to stimulate and organize discussions and decision making.
  • Analyzed data to develop Status Report, graphically, on Tech Objects Upgrade 8.9, resulted in running productive Status Meeting presentations, and appropriate decision making.
Business Analyst
Jun 2003 - Sep 2005 Edison International
  • Developed and maintained Board Bank Database system using MS Access. The system was designed to track and report on SCE employees serving on the Board of Directors of Nonprofit organizations for the eventual matching process. The database provides a basis for tracking and reporting on the employee activity during their time of service. It also includes historical (contact, financial, etc.) information on nonprofit organizations which has Edison employees on their board.
  • Worked with Program Manager and other professionals to organize and present database process, procedures and workflow in a unified structured format. Developed Ticketing database system for the Corporate Contribution department, resulting in a more effective method of tracking events and tickets allocation to senior managers.
  • Participated and attended training session on operating procedures of Grant Management System, MicroEdge GIFTS.
  • Assisted in reconciliation process of Grant Management System in order to migrate data from the old Corporate Contribution database system to the new Edison GIFTS.

Education

Management Information Systems
Jan 2008 - Dec 2010 Keller Graduate School of Management at DeVry University
Project Management Certification
Jan 2008 - Aug 2010 University of California (UCI)
Bachelor's Degree, Management Information Systems
Jan 2000 - Dec 2003 California State University - Long Beach
Bachelor's Degree, Finance and Real Estate, Grade: Dean's List
Jan 2000 - Dec 2003 California State University - Long Beach