Karen L.

Information Systems Operator/Analyst; Assistant IG

239 followers

Sun Prairie Town, Wisconsin, United States

Connect with Karen L. to Send Message

Connect

Connect with Karen L. to Send Message

Connect

Timeline
About me
ETL / SQL / Mainframe Developer | Recent UWM Graduate
Education
- University of Wisconsin-Milwaukee
  2016 - 2017
  BS in Information Science and Technology (IST) 3.967
  ► The Web Server Model & FTP | HTML & CSS Editing► Intro to JavaScript & the DOM► Database Design | Database Management Approaches | Database Languages, SQL, MySQL► Advanced Concepts of DB Management | User Requirements in DB Design► Fundamentals of Information Science | Information Systems | Knowledge Systems► Social Issues in Information Science & Technology► Web Space and PHP | PHP Scripts, Form Handling, Arrays and Functions | Dynamic Web Pages using PHP and… Show more ► The Web Server Model & FTP | HTML & CSS Editing► Intro to JavaScript & the DOM► Database Design | Database Management Approaches | Database Languages, SQL, MySQL► Advanced Concepts of DB Management | User Requirements in DB Design► Fundamentals of Information Science | Information Systems | Knowledge Systems► Social Issues in Information Science & Technology► Web Space and PHP | PHP Scripts, Form Handling, Arrays and Functions | Dynamic Web Pages using PHP and MySQL► Definition of Data Information and Knowledge► Formal Information Classification Systems | How Information is Organized | Digital Information Organization Systems | Trends in Information Organization► Human Factors in Info Systems | Interface Usability Concepts | Interface Usability Testing | Heuristic Evaluation in UI► Systems Analysis & Design► Calculate descriptive stats, apply formulae in Excel | Calculate simple statistical analyses | Infographics and visualizations Show less
- University of Wisconsin-Madison
  -
  Engineering
- Madison Area Technical College
  -
  Associate in Applied Science Computer Information Systems - Programmer/Analyst 3.96
  ► Graduated with Academic Honors.► Earned an Advanced Technical Certificate in Client/Server Computing in 2000.
Experience
- Wisconsin Army National Guard & Army Reserve
  May 1983 - Jun 2003
  Information Systems Operator/Analyst; Assistant IG
  # MASTER SERGEANT - RETIRED► Served for more than 2 decades in the U.S. Army Reserve and Wisconsin Army National Guard. Mobilized to serve with U.S. Central Command (USCENTCOM) in Tampa, FL, during Operation Enduring Freedom in 2003 for 9 months.► Received a Top Secret security clearance with Sensitive Compartmented Information (TS/SCI) in 1999.► See the “Honors & Awards” section of my LinkedIn profile for the military awards I received during my time in the Wisconsin Army National Guard. Show less
- American Family Insurance
  Apr 1992 - Jun 1997
  Development Analyst
  ► RESPONSIBILITIES: Team member and project leader in support of insurance claims and statistical reporting systems for Casualty, Property, and Health Insurance.► ACCOMPLISHMENTS: Designed a system to track and report key factors affecting exposure and reinsurance of property at risk. Project leader for cross-functional team to design a batch system that supplies semiannual data for five years according to a court decreed settlement of a lawsuit. Maintenance of a quarterly batch system used to assess and monitor factors effecting productivity of field agents.► ENVIRONMENT: COBOL | JCL | VSAM | FOCUS | CICS | Syncsort | File-Aid | Comparex. Show less
- Keane, Inc.
  Jun 1997 - Aug 2000
  Senior Consultant
  Worked as a contract programmer for CUNA Mutual Group and Johnson Controls, Inc.Keane, Inc. is now a wholly owned subsidiary of NTT Data Corporation of Japan.# SENIOR IT CONSULTANT | CUNA MUTUAL GROUP► RESPONSIBILITIES: Complete three Y2K projects, design an archival process for DB2 data; resolve billing system discrepancies and fix SQL inefficiencies. ► ACCOMPLISHMENTS: : Designed, coded, tested, and implemented a monthly archival process for the billing system DB2 tables. Acted as a co-project leader during Year 2000 system testing of a large batch COBOL/DB2 system containing over 80 programs and 30 tables. Earned my second K-Pin, which is awarded for exceptional customer service.► ENVIRONMENT: COBOL | DB2 | JCL | SPUFI | VSAM | File-Aid | ICEMAN | Princeton Tools | SAS.# SENIOR IT CONSULTANT | JOHNSON CONTROLS INC.► RESPONSIBILITIES: Converted an invoice entry system from the IBM mainframe to the DEC Alpha.► ACCOMPLISHMENTS: Drove the migration of an invoice entry system from the IBM mainframe to the DEC Alpha. Worked independently with subject matter expert and end users to define requirements. Was responsible for the design, coding, testing, training, documentation, and implementation of the new process. Earned my first K-Pin for customer service excellence.► ENVIRONMENT: COBOL | JCL | File-Aid | DCL | Praxa. Show less
- Bank of Ireland
  Jan 2001 - Nov 2001
  Software Engineer
  ► RESPONSIBILITIES: Relocated to Ireland and supported mainframe applications for electronic statements sent via SWIFT, ftp, and the internet to corporate customers of the Business Online group.► ACCOMPLISHMENTS: Wrote program specifications, reviewed code and JCL of contract programmers. Spearheaded conversion of data to new platform and system.► ENVIRONMENT: COBOL | DB2 | SQL | VSAM | JCL | SPUFI | File-Aid | Xpediter | Comparex | MS Access.
- Compuware
  Oct 2002 - Feb 2004
  Software Engineer
  ► RESPONSIBILITIES: Served as external consultant to Unity Health Insurance to analyze and perform code changes to merge their packaged software during a version upgrade that was precipitated by HIPAA requirements. While working for Compuware, I was mobilized to serve with the US Army during Operation Enduring Freedom.► ACCOMPLISHMENTS: Drove code changes to +150 objects; pinpointed and rectified production issues while deploying changes.► ENVIRONMENT: COBOL | OpenVMS | DCL | MS Access. Show less
- US Army
  Feb 2003 - Oct 2003
  Information Systems Operator/Analyst
  ► RESPONSIBILITIES: Mobilized to serve with the US Army at Central Command during Operation Enduring Freedom.► ACCOMPLISHMENTS: Supported the implementation of the Joint Staff and Combatant Command Records Management Policy within the J6 C Division. Redesigned, maintained, and created end user training and documentation for the division’s MS Access personnel database.► ENVIRONMENT: MS Access | Information Retrieval Support System (IRSS)
- Stratagem, Inc
  Oct 2004 - Jan 2005
  Software Engineer
  ► RESPONSIBILITIES: Served as external consultant to analyze source to target transformations within mainframe systems for Assurant Health onsite in Milwaukee. ► ACCOMPLISHMENTS: Rewrote source system data extraction programs and documented business rules within legacy COBOL programs to assist designers in the architecture and development of a client’s new Data Warehouse.► ENVIRONMENT: COBOL | DB2 | VSAM | FileAid | SyncSort | JCL | Visio | MS Office.
- WPS Health Insurance
  Jan 2005 - Apr 2015
  ETL Developer/Sr. Programmer Analyst
  Progressed through a series of increasingly responsible positions – starting as a Mainframe Developer and ending as an ETL Developer for a large Health Insurance Data Warehouse (DW). # SENIOR PROGRAMMER ANALYST | ETL DEVELOPER► RESPONSIBILITIES: ETL Developer for the Commercial Health Insurance DW.► ACCOMPLISHMENTS: Oversaw System Integration Testing for new DW, built in congruence with a new Facets operational policy and claims processing system. Built, tested, deployed and documented ETL instructions and standards for an additional 20 custom tables. Supported the production environment, proposed performance enhancements and communicated open items/issues to stakeholders.► ENVIRONMENT: SSIS | SSMS | SQL Server 2008 R2 | Analytics Mapping Mgr | MS Office | ServiceNow | ChangeMan DS.# SENIOR PROGRAMMER ANALYST | ETL DEVELOPER► RESPONSIBILITIES: ETL Developer for the TRICARE (Military Health Insurance) DW.► ACCOMPLISHMENTS: Supported 3 distinct DB2 DWs built for our prime government contractors. Part of a team to convert all 3 from DB2 to Netezza target tables. Identified areas within ETL code and mainframe jobs that were causing us to miss our Service Level Agreement (SLA). Coordinated the changes, testing and implementation which reduced our nightly cycle time by approximately 3 hours.► ENVIRONMENT: Cognos Data Manager | Netezza | DB2 | VSAM | JCL | Control-M | MS Office | SPUFI.# PROGRAMMER ANALYST III► RESPONSIBILITIES: Mainframe Developer for the TRICARE (Military Health Insurance) Enrollment system while also supporting multiple production systems.► ACCOMPLISHMENTS: Lead analyst to design the automation of the return of TRICARE Encounter Data (TED) from the government. Wrote program specifications and test plans, performed walk throughs of code and JCL, monitored system testing, and managed the development team’s workload.► ENVIRONMENT: COBOL | DB2 | CICS | VSAM | FileAid | SyncSort | JCL | Xpediter | Easytrieve | ChangeMan | SPUFI | MS Office. Show less
- U.S. Department of State
  Sept 2016 - May 2017
  EInternship - Virtual Student Foreign Service (VSFS)
  # eINTERN► Member of a team of 3 eInterns to research, discover and compile scientific research being done in a region of the world using ‘Web of Science’ and the Internet. My countries in the Pacific Area of Responsibility (AOR) included: Australia Brunei India Indonesia Japan Malaysia New Zealand Philippines Republic of Korea (South Korea) Singapore Taiwan Thailand Vietnam► Applied language and research skills to solve a real world information need. Show less
- TCWGlobal
  Jan 2019 - Apr 2019
  Data Privacy Support
  Assist the Data Privacy Group at Accuray Incorporated, Madison WI, with the evaluation and verification of Records of Processing activities and vendors to prepare for the European Union’s (EU’s) General Data Protection Regulation (GDPR) validation, utilizing OneTrust to operationalize the compliance program. ► Interviewed 35 employees across the globe and researched over 2,000 vendors. ► Extracted data from OneTrust to Excel and created an Access database for data discovery and vendor status reporting. Show less
- U.S. Census Bureau
  Dec 2019 - Sept 2020
  IT Clerk | Enumerator
  IT Clerk: December 2019 - February 2020Enumerator: August - September 2020
Licenses & Certifications
- Advanced Technical Certificate in Client/Server Computing
  Madison Area Technical College
  Sept 1999
Honors & Awards
- Awarded to Karen L.
  Meritorious Service Medal (MSM) Wisconsin Army National Guard Feb 1998 “For meritorious service while serving as an Information’s Systems Analyst. Sergeant First Class Ledding’s professional abilities contributed immensely to the accomplishment of duties at HQ (-) STARC Detachment, the Recruiting & Retention Force and the Inspector General Office…”
- Awarded to Karen L.
  Army Achievement Medal (AAM) Wisconsin Army National Guard Apr 1996 “For her performance at Advanced Noncommissioned Officer Course. Sergeant First Class Ledding’s demonstrated leadership skills, high level of personal motivation and initiative and “unique ability to motivate solders” were instrumental in the achievement of being on the Commandant’s List…”
- Awarded to Karen L.
  Army Achievement Medal (AAM) Wisconsin Army National Guard Jun 1990 “For meritorious service while assigned as the Detachment Administrative Supervisor, Headquarters (-) State Area Command… demonstrated initiative, technical adeptness, and comprehensive knowledge in the development of an ADP generated Annual Training Status Report to track the performance of unit personnel. In addition, her meticulous efforts and attention to detail ensured orders were properly requested and issued for personnel of this command. Staff Sergeant Ledding’s foresight… Show more “For meritorious service while assigned as the Detachment Administrative Supervisor, Headquarters (-) State Area Command… demonstrated initiative, technical adeptness, and comprehensive knowledge in the development of an ADP generated Annual Training Status Report to track the performance of unit personnel. In addition, her meticulous efforts and attention to detail ensured orders were properly requested and issued for personnel of this command. Staff Sergeant Ledding’s foresight, resourcefulness and professional competence ensured the successful accomplishment of this training mission…” Show less
- Awarded to Karen L.
  Army Commendation Medal (ACM) Wisconsin Army National Guard Feb 1988 “For meritorious service while serving as Computer Machine Operator during the period of 1 May 1985 to 31 January 1988. Staff Sergeant Ledding’s abilities and extensive knowledge in the area of computers contributed immensely to the Full Time Recruiting and Retention Force successfully accomplishing its mission. During this period she developed programs and data bases that ensured timely and accurate information and was constantly searching for new, effective procedures. Her untiring efforts… Show more “For meritorious service while serving as Computer Machine Operator during the period of 1 May 1985 to 31 January 1988. Staff Sergeant Ledding’s abilities and extensive knowledge in the area of computers contributed immensely to the Full Time Recruiting and Retention Force successfully accomplishing its mission. During this period she developed programs and data bases that ensured timely and accurate information and was constantly searching for new, effective procedures. Her untiring efforts and willingness to always do her best is in keeping with the finest tradition of the military service…” Show less