Project Manager, Business Intelligence, CRM, Systems/Business Analysis

HENA AHMED

** ****** *****, ********, ** *****

847-***-**** ****.*****@*****.***

BUSINESS / SYSTEMS ANALYST

Creating Solutions through IT

PROFILE

Highly experienced Business/Systems Analyst with a record of developing and supporting solutions incorporating a wide range of applications. Consistently recognized by Management in Business and Information Technology for demonstrating expertise in strategy, analysis, research, requirements gathering and operations. A seasoned Technology Professional who enjoys the synergies of idea exchange, collaboration, and shared learning. A creative problem-solver with a strong interest in new technologies and approaches that is both customer and end-user focused. Extremely reliable, possessing strong work ethics, and a dedicated team player.

CORE COMPETENCIES

Systems Analysis • Process Improvement • Solution Design • Compliance • Training • Project Management

UNIX • DB2 • Oracle • FTP • Tivoli • Rx Navigator • SalesLogix • EVA Genie • SQL

AS400 • MS Office • Siebel • SAS • TOAD • Clarity Management

PROFESSIONAL EXPERIENCE

CVS Health 11/2012 to 10/2015

IT Gov Svcs, Adjustments Sr. Analyst/PM Buffalo Grove, IL

• Generated the RxClaim PDE(Prescription Drug Event) Reconciliation Status report on a weekly basis, which was a subset of the Steering Committee presentation. Developed and presented the HP Service Manager/Enterprise Issue Tracking Weekly and Monthly Status reports which showed current ticket volumes and their respective status. Completed 6 daily reports to analyze new batches and report on their current status between the Adjustments Systems: EAS and ERIC. Designed the First Pass Rejects report on a weekly basis to show the volume of reject claims on a weekly basis. Verified 800 issue batches in the ERIC Production A-Box RxClaim system to see if they were open closed or pending, and released batches when needed.

• Maintained the team SharePoint site for Adjustments team, granted access to users, created groups and performed permission setup for users/groups. Uploaded documents and streamlined the team Wiki site so that the team could locate system and process documentation easily.

• Created project plans to create the RCA(Root Cause Analysis) process for our team and designed a form in SharePoint to track each RCA entry. Tracked 15 RCA's from entry to closure for all the Adjustments teams by collaborating with the Project Managers for 11 sub-teams on a weekly basis.

• Recipient of multiple Values in Actions Awards: Sep 2013, Oct 2013, Mar 2014.

CVS/Caremark 11/2010 to 10/2012

PPS/MCO - Project Lead/Systems Analyst Northbrook, IL

• Developed adhoc reports in Crystal Reports 11 such as the Open/Closed Projects Report. Scheduled reports via Business Objects to be delivered to users or Print Production Services (PPS) network drives via e-mail.

• Maintained and updated all PPS Team Reports/Scorecard on the SharePoint site. Created adhoc SQL Queries via TOAD for Oracle and TOAD for DB2 for PPS Team members.

• Project Manager for a 15 member team project to transition the Siebel Database BART application to Salesforce.com. Collected the business requirements and functional requirements from team members in regards to work streams, workflows and data maps. Created the current state and future state diagrams in order to see which parts of the workflows could be streamlined. Presented my diagrams during the Kick-Off meeting to the rest of the Project Owners and stakeholders. Created the project plan within MS project for the different phases and marked the milestones. Allocated resources to each task and maintained deadlines and project status. Created the Work Breakdown structure for my team members for the project.

• Worked with the DBA team to create the data map from Siebel to Salesforce.com. Held Checkpoint meetings with team, IT and business users on a weekly basis in order to make sure that all the requirements are being brought in and that the project is within scope and budget. Uploaded deliverables to the Project Site in SharePoint. Worked with the Technical Lead at Deloitte to build dummy data and created a training database. Set up users and their access for the training database by working with the Technical Lead.

• Trained team members on how the application works for their day to day work, and presented the final prototype to my team, in order to introduce them to the new workflows for Booklets, ID card, Welcome Kits, and the Support Cases. Worked with Technical Lead to make sure that the fields were placed in the proper orders and that the screens had all the appropriate layouts and data elements. Created 10 tabular reports and 2 graphical weekly reports within Salesforce.com as well as other adhoc reports for specific clients which showed Service Level Agreement and Priority data.

• Updated the Project Scorecard on a daily basis, to mark red yellow or green status. Created a list of users need to participate in smoke testing and User Acceptance testing as well as all the training documentation and test plans. Gathered status reports daily from all team members during training and defect testing and reported back any issues to the Project Owner and Technical Lead. Maintained the Issues and Risk log. Facilitated meeting sessions via Live Meeting /WebEx with other departments to implement project management practices.

• Reviewed and approved SDLC required deliverables. Designed and implemented test plans and strategies to perform defect tracking. Applied the Lean Six Sigma DMAIC principles to each project to ensure successful completion. Created support cases and held the role as System Administrator to provide production support, troubleshoot workflows and resolve issues. Brought in the project from a red to green status and deployed the project 5 weeks early.

• Received Employee of the Quarter award in Q2 2012.

CVS/Caremark 01/ 2006 to 10/2010

Analytics and Outcomes, Analyst Northbrook, IL

• Executed and updated SAS programs in Enterprise Guide 4.0 and PC SAS Version 9.1

• Used TOAD and BI Query to analyze and query against the Oracle/DB2 views/tables.

• Utilized a 3-Tier environment through DB2, Oracle, and Sasnode to perform queries for file archiving /retrievals performed via UNIX commands and the FTP/Tivoli software applications. Returned 200 terabytes of data back to the Sasnode server eliminating the need to purchase a new server.

• Evaluated SAS report processes/custom models for clients including: Formulary Disruption/Repricing Analysis, Stayers and Leavers, Trend Component and Generic Copay Incentive analyses. Create complex Quarterly DUE files for major clients including Pacific Source Health Plan, Drummond Co., Destiny Health Plan, Amerigroup, New York State, and Capital Health Plan Employee of the Quarter, Q1 2009, Q2 2011, Recognized with three ICARE Awards.

CVS/Caremark

Senior Programmer/Analyst Lincolnshire, IL 02/2000 to 12/2006

• Designed reports using SQL code in order to perform data analysis. Used the SDLC methodology and designed professional deliverables including requirements documents, for analysis and design and updated project plans for Medicare Cost Reports.

• Provided production support for MicroStrategy/SalesLogix applications. Resolved all issues in the HEAT ticket system within 7 days as listed in the Service Level Agreement for internal/external users. Resolved SalesLogix system hardware and software issues. Served as main point of contact for all system and technical issues in regards to SalesLogix and EVA Genie. Created adhoc reports for client requests in Rx Navigator. Created complex documentation for SalesLogix user training purposes in regards as to how to enter accounts, contacts, and opportunities. Developed 20 PowerPoint slides to introduce EVA Genie as a reporting tool during the IT Quarterly Meeting (100 attendees). Designed process documents to train users on how to use the reporting tool to create intricate reports.

• Coordinated with business users to gather data requirements for various projects. Created 110 new report objects: attributes, filters, and metrics via Architect for adhoc reports and setup MicroStrategy Web Users using 4 Visual Basic scripts to properly assign individual security profiles for 200 users. Liaison between our business users and Data Warehouse DBA to resolve issues.

• Earned the IS Excellence Award for SalesLogix and EVA Genie.

Siebel Systems, Inc. Rosemont, IL 1999 to 2000

Consultant

Designed demo applications for different clients: US Bank, Humana, Install Shield and Allstate/SITEL.

Innovative Client Solutions Chicago, IL 1997 to 1999

Consultant

Scanned, analyzed, and documented SQL code to update date fields in 200 forms via Oracle 7.2.3 Developer 2000 for CNA Insurance for the Y2K project.

EDUCATION

Bachelor of Science, Biology Roosevelt University Chicago, IL

Certificate, Computer Career Program Aquarius Computer Institute Chicago, IL

Associate of Liberal Arts Oakton Community College Des Plaines, IL

PROFESSIONAL CERTIFICATION

Siebel Certification for Siebel 99.5, Lean Six Sigma Yellow Belt, Lean Six Sigma Green Belt course completed

Contact this candidate