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:
- Software Maintenance & Software Development
- Software Testing: Test Planning, Creation & Execution
- Requirements Gathering
- Data Mapping
- System Conversion
- System debugging
- Issue Escalation & Resolution
- Process Improvement
- Functional Specifications Development
- COBOL
- JCL
- Full Life - Cycle Project Development & Implementation
- DB2
- SQL
FOCUS ON:
Business Analysis… Client Relationship Building… Problem Solving
TECHNICAL SNAPSHOT:
Databases: DB2 | IMS/DB | Oracle | SQL 2005 | SQL 2008
Languages: SQL |COBOL II | CICS COBOL | HTML | XML | JCL | JAVA
Applications: Microsoft Office Word | Excel | Visio | PowerPoint | Access Xpediter | FileAid | Method 1 Project Management | SPUFI Syncsort | Crystal Reports | Endevor | Jobscan | Changeman
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).