Technical Systems Analyst Resume

SUMMARY:

Innovative, accomplished information technology developer / analyst, with more than 30 years in data and programming analysis, software design, development, and project management.
I have more than 30 years in mainframe COBOL experience and 25+ years in DB2.
I have very strong analytical skills and am very knowledgeable in SQL.
Brainstorm and conduct extensive analysis to bring complex claims processing into compliance with new federal health insurance regulations, requiring massive cross - business group changes to applications. Interface with and lead offshore programmers and consultants in the completion of the application redesign and testing process.
Analyze systems and programs for interoperability and monitor within scope of entire project.
Troubleshoot errors in coding and JCL and rectify the errors to keep project on schedule and within budget.
Design, code, and implement COBOL II programs. Define specific data requirements in collaboration with product area programmers, and then coordinate data analysis, design, testing, and implementation of project with each product area.

EXPERTISE IN:

FOCUS ON:

Business Analysis… Client Relationship Building… Problem Solving

TECHNICAL SNAPSHOT:

Databases: DB2 | IMS/DB | Oracle | SQL 2005 | SQL 2008

PROFESSIONAL EXPERIENCE:

Confidential

Technical Systems Analyst

Responsibilities:

Provided consulting services on new and strategic initiatives (medium to large of varying complexity). Provided consulting services on new and strategic initiatives (medium to large of varying complexity).
Provided cobol specifications for large projects; extensive work in JCL and DB2
Managed detailed design phases for large projects/ programs identifying, tracking and resolving technical issues and ensuring solution meets sponsor needs and PLC deliverables.
Contributed to successful project completion by identifying risks and developing/recommending mitigation strategies.
Provided input and co-ordinates with DBA in creating new and modifying existing database structures using different types of databases.
Delivered prospectus delivery enhancement project. The code was installed bug-free. This project ensures that we do not get fined by FINRA.
Created technical specs for large project. This was for the ADV2B process for our financial advisors.

Confidential

Applications Programmer

Responsibilities:

Providing support and issue resolution for the 911 system
Performing analysis to troubleshoot issues for call takers and police dispatchers
Creating reports using SQL for confidential investigation on call takers and police matters
Contributing to team discussions by presenting ideas and sharing knowledge.
Collaborating on problem resolution, team decisions and project planning.
Participating in application of system software patches
Installing updates for CAD 911 application
Unit testing Office 2013 and debugging when necessary

Confidential, Wausau, WI

Associate Report Analyst

Responsibilities:

Analyzed SQL databases and created queries for analysis
Providing support and issue resolution for critical production reports and applications
Performing business analysis to develop and maintain reporting applications in support of the data and information needs
Creating business requirements and updating business system documentation.
Contributing to team discussions by presenting ideas and sharing knowledge.
Collaborating on problem resolution, team decisions and project planning.
Performing initial problem investigation to determine scope and depth of problem and recommending additional steps and solutions by following established guidelines.
Developing, refining and maintaining static, dynamic, and ad - hoc reports using Crystal
Partnering with the client to delivering timely reports, troubleshoot issues in a timely manner, and focus on keeping the client happy .
Unit and integration testing, and debugging application software

Confidential, Wausau, WI

Senior Applications Developer - Subject Matter Expert

Responsibilities:

Managed and oversaw work of offshore team.
Led testing efforts, interfaced with testing group members to facilitate issues and resolve problems while also coordinating testing resources across technical and business areas.
Provided support and resolution of critical production reports and applications
Performed initial problem investigation to determine scope and depth of problem and recommended additional steps and solutions by following established guidelines.

Confidential, Minneapolis, MN

Consultant | Business Analyst

Responsibilities:

Led testing process, created test plans, test cases, and test scenarios covering all aspects of project functionalities and clearly documented testing results.
Created well-defined requirements and functional design specs easily translated into technical solutions in COBOL and DB2 .
Analyzed design testing strategy’s business and system specifications used to verify functionality of system enhancements.

Confidential, Minneapolis, MN

Data Analyst

Responsibilities:

Coded in Java for Confidential Select, a tool for advisors used to create client financial plans.
Designed, coded, and implemented COBOL II programs in DB2 for the reporting system for planners in the financial planning area.
Implemented software changes across environments (i.e. development, QA and Production).