MARY JILL MELIES
Omaha,NE
Summary
Experienced and knowledgeable Senior Systems Analyst with 30 years of IT experience. Design, develop, create, update database and mainframe systems. Demonstrated strengths include gathering requirements, analysis, programming, testing, project management, and quality assurance.
Overview
26
26
years of professional experience
Work History
Senior Systems Analyst
Data Axle
06.2022 - Current
- Analyzing client’s business processes and requirements to build automated processing using both mainframe and database systems to increase productivity.
- Creating and executing test plans for seamless transitions from client system
- Working closely with client to achieve highest quality software development
- Solving system issues for clients and internal employees
- Building automation processes internally for sales and other divisions
- Updating non-profit database with refreshed client files on weekly or monthly basis.
Client Operations Data Developer
Data Axle
11.2016 - 06.2022
- Matching client files to in-house consumer/business databases to append various information
- Documenting process flow using Visio, uploading/downloading files to EFT mailboxes and mainframe
- Non-profit account manager in charge of gathering and loading client files (fixed, delimited, compressed)
- Creating work orders on established procedures for team to follow to process files.
Quality Assurance Support Analyst
Alorica
01.2014 - 10.2016
- Supporting multiple web-based applications that house stored data within various databases
- Use Structured Query Language (SQL) to build queries for retrieval of data
- Testing technical projects throughout development and implementation phase to ensure systems meet business needs.
Service Manager
Alorica
08.2011 - 10.2016
- Service Manager for AT&T customers on provisioning, billing, and maintenance issues. Engage, escalate, and resolved all questions for 75 customers.
Systems Analyst
Data Axle
10.2007 - 07.2011
- Built in-house client specific databases for marketing through email, phone, and mail
- Requirements gathering calls, analysis, cost/time estimates, and documentation of project
- Analyzed customer data, created program specifications, final testing on all phases of process
- Created test files and JCL steps to unit/stage test new process and updated daily files
- Files loaded to database and final quality assurance done by writing SQL statements to ensure access/linkage to all tables and fields involved
- Wrote/updated documentation, layouts, and flowcharts in Visio
- Change requests written for languages in COBOL, XML, SQL, PL1, and Assembler.
Programmer Analyst
Data Axle
05.2005 - 10.2007
- Managed transition of client processing from three out of state divisions to Omaha headquarters writing programs in COBOL and setting up JCL
- Extracted/uploaded to mainframe client files in various formats to match in-house consumer and/or business databases to append information and check for address changes
- Incoming/outgoing file formats in access excel, and comma delimited using FTP or EFT to send and retrieve files
- Created SAS models for scoring data
- Cross-trained on AS400, SQL, and Eztrieve.
Operations Manager
QA3 Financial
09.2004 - 05.2005
- Managed brokerage account transactions for over 2,000 clients from cash disbursements, stock transfers, and IRA requests
- Handled all questions and calls from clients and representatives on client accounts.
System Programmer
National Network of Estate Planning Attorneys
03.2002 - 09.2004
- Programmed in Visual Basic on new document creation program to create estate-planning documents for attorneys to use for their clients
- Programmed state specific documents into existing system for NNEPA members to use in producing legal documents for their clients
- Developed Help Screens in RoboHelp using Visio flowcharts.
Consultant
Business Security Software Inc, Alegent Health Care
01.1999 - 03.2002
- Managed restructure of five hospitals COBOL programs, PROCS, JCL into one shared set that will run for each hospital’s nightly cycle
- Increased productivity by only needing to update one set of programs instead of five. Huge cost savings for company
- Libraries, datasets, JCL, and scheduler updated, renamed to new standards, and moved to new system
- Built queries to produce test files from database for unit testing.
Senior Software Development Analyst
First Data Resources
08.1997 - 01.1999
- Started as consultant on newly developed client specific team prior to becoming permanent
- Lead programmer and Project Manager for new/updated programs in COBOL, JCL, and DB2
- Endeavor for order tracking of any changes to production system
- Analyzed and designed detailed project plans which included time and cost estimates for each project
- Trained new programmers and developed training manual for new team members to follow on project plans, implementation procedures, and timelines.
Education
Associate of Science - Information Technology
Institute of Computer Science
Omaha, Nebraska07.1986
Skills
- Windows NT
- JCL
- COBOL
- SQL
- XML
- CA7 Scheduler
- CA11 Scheduler
- Control-M Scheduler
- FTP/EFT
- Visio Flowchart
Timeline
Senior Systems Analyst
Data Axle
06.2022 - Current
Client Operations Data Developer
Data Axle
11.2016 - 06.2022
Quality Assurance Support Analyst
Alorica
01.2014 - 10.2016
Service Manager
Alorica
08.2011 - 10.2016
Systems Analyst
Data Axle
10.2007 - 07.2011
Programmer Analyst
Data Axle
05.2005 - 10.2007
Operations Manager
QA3 Financial
09.2004 - 05.2005
System Programmer
National Network of Estate Planning Attorneys
03.2002 - 09.2004
Consultant
Business Security Software Inc, Alegent Health Care
01.1999 - 03.2002
Senior Software Development Analyst
First Data Resources
08.1997 - 01.1999
Associate of Science - Information Technology
Institute of Computer Science
Similar Profiles
Raj PaddaRaj Padda
Senior Director, Business Development at Data AxleSenior Director, Business Development at Data Axle
Matthew WilsonMatthew Wilson
Director, Marketing Operations at Data AxleDirector, Marketing Operations at Data Axle
TUSHAR RAUTTUSHAR RAUT
Senior Storage Admin at Data AxleSenior Storage Admin at Data Axle