VIZIONARA, LLC. Canton, CT (remote) | 3 yrs

Untapped Potential Flexreturn™ converted to IT System Analyst & Consultant
Boutique IT consultancy that delivers digital transformation, IT portfolio management, and organizational planning.
• Established and deployed a Project Management Office for a private equity firm
• Documented PMO requirements, conducted a software tool comparison, and implemented the solution
• Led project portfolio proposal intake meetings with project managers and IT
• Participated in all Agile ceremonies as part of the Business Process and Workflow Digitization squad.
• Acted as the liaison with business stakeholders to facilitate discovery sessions and translate customer requirements into Jira stories, including acceptance criteria and test cases.
• Created, refined, and maintained ServiceNow Knowledge articles. Developed ServiceNow dashboards and reports.
• Documented workflow configurations, test cases, user criteria, and notification requirements in Confluence and JIRA.
• Supported Product Owner, Scrum Master, Engineering, and QA team members to deliver initiatives with measurable business outcomes and key results.
• Extracted and compiled information to create and develop metrics, reports, and answer queries on ServiceNow workflow usage and overall portal traffic patterns.

ANTHEM, INC., Wallingford, CT | 11 years

Senior Application Developer/Data Reporting Analyst
Team leader of Benefit project which was tasked with reducing prescription drug costs.
• Coded complex SQL queries against Teradata and DB2 databases to investigate and report data integrity issues.
• Reduced customer abrasion by identifying and resolving data timing issues between external drug vendor and interfacing data store.
• Decreased number and length of project requirement meetings by creating and adhering to predetermined agendas, assigning follow up task assignments, and preparing meeting minutes.
• Reduced overall time for validation/QA testing by coordinating data and testing across multiple DB2 / IMS regions.

Data Warehouse Developer
Implemented first data warehouse for Anthem East by utilizing commercial ETL process to aggregate and store institutional, professional, and drug claims.
• Reviewed and modified ERD’s, designing adjunct DB2 tables that integrated with vendor-defined claim databases.
• Improved end-user reporting, enabling business to extract data and create more meaningful reports. Data could now be retrieved at patient level or across claims to identify treatment patterns and cost of care.
• Prioritized, assigned, and monitored projects and issues for an 8-member Data Warehouse team.
• Data Warehouse subject matter expert and main contact for internal clients and external vendors.
• Supported Claims, Provider, Benefits, and Membership.
• Trained new programmers / analysts. Set up training material, demonstrated systems, assigned tasks, and reviewed completed work.

Data Warehouse Manager
Project team lead to convert mainframe / IMS system to a Visual Basic / DB2 system.
• Led client mapping / design sessions to design new DB2 tables, GUI windows, and redesigned web pages. • Made new system more user-friendly and increased sales by allowing the company to market custom-tailored benefit packages.
• Developed and monitored project timelines.
• Self-taught coder for Benefit system, utilized Visual Basic, HTML 4, JAVA, and JavaScript.

KONICA MINOLTA, INC, Windsor, CT

Senior Business Applications Analyst
Core analyst in 3-year project to create flexible invoicing and reporting application. Led to reduced user
errors during input and allowed company to offer more complex billing packages to customers.
• Utilized IBM’s structured analysis and design methodology.
• Participated in data modeling, created Entity Relationship Diagrams, defined entities, and developed Process Flows.
• Led client Requirement and Design Sessions, utilizing business knowledge and experience to translate business requirements into system specifications.
• Scheduled entire batch system, including dependencies and interfaces, involving over 220 jobs.
• Maintained 32 mainframe systems, including Contracts, Rental Invoicing, Order Entry, Parts Processing, and Inventory. Supported on call and coded and modified COBOL, CICS, FOCUS, and M204 database programs.