Sr. System Analyst Resume Birmingham, Alabama - Hire IT People

PROFESSIONAL SUMMARY:

Around 20 years of experience in Analysis, Design, Develop and Production Support of IT systems. Using COBOL, Db2, JCL, SQL and other programming tools.
Domain expertise in building comprehensive analytical solutions in Loans, Deposits, Cards, Accounting across Technology and Banking industries.
Translated client and consultant requirements & constraints into Business models.
Hands on experience in optimizing the DB2 Queries and database performance tuning.
Expert in using SQL queries, JOIN statements and developed Stored Procedures, Triggers, Functions, Packages.
Strong experience using MS Applications.
Good understanding of delivery processes such as Agile & Waterfall.

SKILL MATRIX:

LANGUAGES: COBOL, CICS, ASSEMBLER, EASYTRIEVE, JLC. SAP ABAP (basic knowledge)

Databases: MS Excel, ORACLE, DB2

PROGRAMMING: Python (basic knowledge), SQL, PL/SQL, Java (basic knowledge)

ETL TOOLS: n/a

DATABASE TOOLS: QMF (Query management facility) used for DB2 databases, Toad used for Oracle Databases.

REPORTING TOOLS: COBOL, COGNOS.

METHODOLOGIES: System Development Life Cycle (SDLC), Agile, Waterfall Model.

PROFESSIONAL EXPERIENCE:

Confidential, Birmingham, Alabama

Sr. System Analyst

Responsibilities:

At this moment as Sr Systems Analyst, I serve as liaison between Confidential Compass application systems and CCR systems support. I also serve as Project coordinator for the projects delivered to CCR infrastructure using Waterfall and Agile practices and methodologies.
Other duties developed for Confidential Group include: Analysis of external LEGACY COBOL interfaces to develop new process in ALNOVA System.
Maintenance in case of any incidence on Mainframe production area, that include Deposits, Loans, OPS, Credit Lines, Audit, Financial Statements, Credit Scores, Risks, Credit/Debit Cards, Corporate Tables, ACH. Testing processes in Mainframe production area and optimization of batch processes.
Performed manual test duties for the Clients, Deposits, Net - Cash and Cards applications systems, creating test scenarios, running tests, reporting errors and retesting as required.
Managed the Data Management team and QA during the different migration/testing phases.
Generate SOX documentation for Audit Department.
Giving support 24-7 for batch processes in production environment.
Supervised a 4-member team that resolved Mainframe production problems.
Maintenance Y2K - Analysis and developing/update new/existing COBOL programs for the adaptation for New Millennium era.

Environment: Mainframe.

Confidential, San Juan, Puerto Rico

Sr System Analyst

Responsibilities:

Carried out modifications to the Billing LEGACY in Mainframe System to manage transactions that make inquiry/update DB2 databases.
Support 24-7 to Mainframe batch process.
Generation of reports using BI COGNOS utility tool and TOAD utility using ORACLE PL\SQL for Purchase, Invoice, Revenue Assurance, Accounting and Finance departments.
Generation of interfaces with TOAD utility using ORCALE PL\SQL for Purchase, Invoice, Revenue Assurance, Accounting and Finance departments.
Support to production reports.
SQL development with ORACLE and DB2.
Programming with ORACLE PL\SQL (store procedures, functions, etc).
Development process to extract data (ETL processes) to create reports.

Environment: Mainframe, Open System.

Confidential

IT Consultant

Responsibilities:

Total support of installation of Altair System for Confidential using COBOL language and DB2 databases, also using JCL language as batch processing.
Design and development of batch/online COBOL/DB2 programs for LOANS application. Writing Technical Processing Description Documentation, as well as program specifications documents.
Involved in creation of New JCL’s, including members, programs, parms, Unload cards, Sort cards, etc.
Perform manual test duties for Altair system, creating test scenarios, running tests, reporting errors and retesting if it is necessary.
Generate all SOX documentation for Audit Department.
Giving 24-7 support for batch processes in Mainframe production environment.

Environment: Mainframe.