Image-empty-state.png

Susan K

IT | Developer | Business Analyst

Profile

Highly-analytical and process-oriented Business Analyst and Programmer, recognized as an expert liaison between IT and business units. Comprehensive background in Healthcare, working with coding, reporting, data warehouse, and mainframe. Known as being extremely detail-oriented and organized. Independent learner who creates quality documentation.

Key Skills & Competencies

Data warehouse reporting, SDLC, Programming, and Design
SQL with DB2 and Teradata for reporting and investigative purposes
Healthcare data including Claims, Benefits, Contracts, RX, and Membership
Strong oral and written communication skills

Languages: SQL/QMF, SAS, COBOLII, MVS/JCL, HTML, JavaScript, Visual Basic, XML
Databases: DB2, IMS, Teradata
Software: Microsoft Office - Excel, Word, PPT, Outlook, Visio, Teradata SQL Assistant, TSO/ISPF, Panvalet, Endevor, FTP, Expeditor, File-AID

Professional Experience

Senior Application Developer/Data Reporting Analyst, ANTHEM, INC., Wallingford, CT 4 years
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, ANTHEM, INC., Wallingford, CT 7 years
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 Developer
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. 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.

Related Experience
Senior Business Applications Analyst, KONICA MINOLTA, INC, Windsor, CT
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.

Community Experience

Yearbook Editor, Griswold Elementary School, Berlin, CT
Girl Scout Leader, Girl Scouts of CT, Berlin, CT

Education

Bachelor of Science (BA) – Computer Information Systems, Bentley University, Waltham, MA

Other Experience/Awards/Publications