Manager Management

Allan I. Ortiz

Teaneck, NJ ***** Cell: 973-***-****

www.linkedin.com/in/allaniortiz *****************@*****.***

Business Analyst / Product Manager

Initiate, analyze, QC, and oversee enhancements, delivering cost-effective

innovations

Broad Health Care Industry knowledge ranging in supportive and operational

responsibilities encompassing data analysis for products and reporting

enhancements driving Health Decision Science for healthier clinical and

financial outcomes. Solid understanding in developing and maintaining

relational database and access of data through Structured Query Language.

Strong analytical and detailed oriented skills. Build strong relationships

with excellent oral and written communication.

Technical qualifications:

. Reporting and query tools for data analysis with Technical documentation

skills

. Programming languages: VBA, HTML, VBScript, ASP, SQL

. Microsoft application software: Excel, Word, Access, PowerPoint and Visio

Experience

Express Scripts (formerly MEDCO) Franklin Lakes, NJ 2003 to 2015

Business Analyst / Product Manager 2008 to 2015

. Upheld relevance, completeness and reliability of clinical

products and their reporting with the development of

strategic enhancements. Supported product owners by

converting detailed business rules and objectives into

business requirements and thorough change control

management crafted from negotiation, and consensus-

building.

. Delivered client driven customized reports by developing

and implementing reports using SQL, Excel programming, and

Access also thorough maintaining data updates in mapping

systems.

. Developed and organized test plans, then coordinated and

reviewed results in progressions up through scheduled

releases by collaborating with business users and IT.

Oversaw lifecycle of enhancements/issues identified from

reporting inconsistencies or defects.

. Performed product operational tasks including client

installations, enrollment, and ongoing support while

collaboratively working with Sales and Account Management

teams.

. Exclusively administered version controlled installations,

oversaw enhancements, and provided support of BiQuery

models. Trained in functionality and basic usage.

. Developed and maintained centralized documentation on

SharePoint (previously Wiki).

. Coded spreadsheet processes with strong working experience

in VBA improving efficiencies >98% resulting in immediate

issue identification triggered by exceeded thresholds.

. Programmatically coded, debugged, and manipulate worksheets

and cell properties to parse data and automatically

generate PowerPoint presentations for client meetings.

. Positively impacted product billing initiatives by

participating in weekly meetings to address open issues

with comprehensive collaboration.

. Efficiently procured Ad Hoc and periodic reports for client

service teams. Strengthened data integrity with quality

control of outputs against base tables.

Allan I. Ortiz *****************@*****.*** Page Two

Express Scripts (Continued)

. Handled inquires, concerns, and complaints utilizing

thorough analysis, tracking, and prioritizations with adept

documentation ticketing records via BMC Remedy System.

. Achieved aligning market forces to corporate goals by

delivering cost-effective, reliable, and secure HIPPA

compliant reporting solutions.

. Coordinated effective meetings with organization, clear

objectives and meeting minutes facilitating information and

requirements with Account Management teams, MIS, and other

functional areas.

. Created unique value-added reports, utilizing Teradata and

writing SQL.

Information Analyst 2003 to 2008

. Defined client and user requirements, telephonically and /

or centralized mailbox media, working as liaison between

Account Management, Operations, and clients for effective

utilization of online information product tools.

. Supported clinical product goals by interfacing with

technical staff, developing automated standard analyses,

reports, and data models, and using business intelligence

and data discovery tools.

. Managed multiple projects simultaneously and oversaw issue

resolution while documenting life cycle of reporting

inconsistencies.

. Produced data discoveries which were presented and utilized

by decision-making team while leveraging Teradata

warehouse, operational systems, and modeling.

. Improved productivity by providing user training for data

discovery tools on the B2C Client Website (standard /

periodic).

. Scaled solutions for decision support by working cross-

functionally across all levels of organization and

supporting on ongoing projects and initiatives.

. Ensured accuracy and quality by:

o Providing 1st level analytical troubleshooting of value-added support

software utilized for claim detail analysis and monitoring of

prescription benefit plan performance for PBM clients and internal

associates.

o Performed administrative duties for new client installations / setups.

o Engaged meetings and conference calls for process discussion and

ticket resolution.

Contact this candidate