Denis Abando Email & Phone Number

● Developed reports and dashboards in Cognos Report Studio● Collaborated in the creation/refinement of SQL and Framework Manager models● Worked directly with business to define, document, and refine requirements● Prepared technical and high level report documentation● Led knowledge transfer sessions with Business/End Users● Performed all or a combination of the above in the following subject areas: ► Information Security - Built a multi-report Cognos dashboard/report application to provide monthly and daily snapshot reports highlighting the main subject areas of focus for the Information Security Team ► Gaming/Casino - Built reports and dashboards to support a custom Cognos application that analyzes casino player value statistics and marketing campaign ROI/trends ► Energy - Utility Transportation and Distribution - Built reports to support customer service and account reconciliation analysis ► Government Services - Built reports to track and project monthly and quarterly departmental budget allocations

● Led Qlikview trial and implementation initiatives including the following: - Meet with business users, primarily upper management and C-Level executives, to define analytics requirements. - Design the data models as well as conceptualize dashboards. - Develop various dashboards key in setting up a new centralized distribution center. - Oversee and conduct QA/UAT testing. - Conduct training sessions with various levels of users. - Invited and participated in Qlikview conference to present successful and rapid deployment of key dashboards.● Develop new and maintain existing BOBJ reports. - Support various departments including accounting, manufacturing, and shipping/distribution. - Meet with various level of users during requirements elicitation.● Develop SQL scripts to support data profiling/validation needs of business users.● Maintained stored procedures for various reporting needs.● Responsible for executive daily, weekly, and monthly operational reports.● Implemented critical dashboards using Highjump warehouse management software.

● Assisted in scope definition and requirements gathering process including stakeholder workshops and discussions.● Provided insightful subject matter specific analytics and dashboards to drive business innovation.● Utilized SAP Business Objects (Designer and Webi) to create universe foundations and provide analytics, reports, and dashboards to reflect stakeholder requirements.● Increased awareness of untapped business goals by providing insightful reporting narratives.● Established genuine client relationships to influence positive collaboration efforts.● Worked in a team environment to produce and motivate the creation of forward-thinking business models.● Created PowerPoint presentations and report mockups to present to stakeholders in order to communicate.project efforts and align agreements of defined requirements.● Assisted in facilitation of communication between business/user needs and IT implementations from requirements to production roll outs.● Proficient in the use of SQL in profiling data, conducting QA, and development of queries for data universes- frameworks and reports.● Used various RDBMS and business intelligence tools during analysis, design, and development activities.

Delivered first-rate customer service and prescription sales to Kaiser Members in the largest Kaiser pharmacy in Orange County.● Resolved member complaints and problems with medical billing and prescription discrepancies.● Responsible for training new employees in pharmacy practices.

Assisted in achieving sales goals by providing technical pre-sales support in various capacities.● Effectively articulate and demonstrate the functionality of products with a “solution” approach.● Assisted in the creation of proof-of-concepts for specific needs of prospects.● Supported the scoping of project objectives and the development of implementation plans.● Conducted technical and industry solution research.● Conducted QA of BI solutions.

Coached for sixth to eighth grade co-ed teams for three seasons.● Organized multiple weekly practices to conduct drills and develop team game strategy.● Led team to finals during first two seasons.