
Susan K.
IT/Business Analyst/Healthcare Expertise
Profile
Business Analyst skilled in translating complex business needs into functional requirements and user stories across Agile, Scrum, and Waterfall methodologies. Comprehensive background in healthcare, including coding, reporting, and data warehousing. Adept at backlog refinement and UAT/SIT support, with hands-on experience in SQL, ServiceNow, Jira, and Salesforce. Recognized for exceptional attention to detail, organization, and high-quality documentation.
Key Skills & Competencies
Data Warehousing, SDLC, Agile, Programming & Design
SQL (DB2, Teradata) for reporting and data investigation
Healthcare data: Claims, Benefits, Contracts, Pharmacy (RX), and Membership
Strong oral and written communication skills
Data Analytics certification with Power BI-like tools (2020)
Software: Jira, Confluence, SQL, Microsoft 365 (O365), SharePoint, ServiceNow, Salesforce, Adobe
Languages: SQL/QMF, HTML, JavaScript, Visual Basic, XML
Databases: DB2, Teradata
Tools: Planview, Smartsheet, Trello, Miro, Visio, Lucidchart, Power BI
Core Competencies: Business Systems Analysis, Agile/Scrum, SAFe, Project Life Cycle, Stakeholder Engagement, PMO, Programming & Design, Change Management, Healthcare
Professional Experience
IT Operations Coordinator, MOTORLEASE CORPORATION, Farmington, CT 1 year
Supported IT operations for 40+ employees, managing onboarding/offboarding, device and account provisioning, and troubleshooting hardware, software, and network issues.
Supported and validated data migration into SharePoint, ensuring accuracy and completeness.
Developed training materials, user documentation, and job aids to support adoption of new workflows and system enhancements
Business Analyst, Untapped Potential Flexreturn™ for VIZIONARA, LLC. Canton, CT (remote) 1 year
Contributed to a boutique IT consultancy specializing in digital transformation, IT portfolio management, and organizational planning.
Translated business needs into user stories, workflow diagrams, and process maps using Agile methodologies.
Created 30+ ServiceNow knowledge articles, dashboards, and reports to strengthen documentation, training, and knowledge management.
Designed and implemented a PMO, establishing governance frameworks, standardized processes, and executive reporting.
Senior Application Developer, ANTHEM, INC., Wallingford, CT 4 years
Team lead of a Benefit project which was tasked with reducing prescription drug costs.
Developed complex SQL queries (Teradata, DB2) to investigate and report pharmacy data integrity issues.
Reduced customer impact by identifying and resolving data timing issues between external drug vendors and internal data stores.
Reduced overall time for validation/QA testing by coordinating data and testing across multiple DB2 / IMS regions.
Data Warehouse Developer/System Conversion Lead, ANTHEM, INC., North Haven, CT 7 years
Implemented the first data warehouse for Anthem East and led the conversion of a mainframe/IMS system to a Visual Basic/DB2 platform.
Reviewed and enhanced ERDs, designing adjunct DB2 tables that integrated with vendor-defined claim databases.
Served as Data Warehouse SME and primary contact for internal clients and external vendors across Claims, Provider, Benefits, and Membership.
Led client mapping and design sessions to define new DB2 tables, GUI windows, and redesigned web pages.
Prioritized and managed work for an 8-member Data Warehouse team.
Trained new programmers and analysts, developing training materials, demonstrating systems, assigning tasks, and reviewing completed work.
Self-taught coder for the Benefits system, utilizing Visual Basic, HTML 4, Java, and JavaScript.
Community Experience
Yearbook Editor, Griswold Elementary School, Berlin, CT
Girl Scout Leader, Girl Scouts of CT, Berlin, CT
Education
Organizational Change Leadership Certification, Apogy, LLC (2021)
Data Analytics Certification with Capstone Project, Our Second Innings (2020)
Bachelor of Science (BS), Computer Information Systems - Bentley University, Waltham, MA
Other Experience/Awards/Publications
