Mts Iv Consultant-data Management Resume
SUMMARY:
- Senior mainframe programmer for leading global telecommunication company. Senior P/A for large scale, financial organizations with experience on client - facing, inter-agency and back office applications systems. Expert level IT developer, Data and Network Communications specialist, CCNA® certified.
TECHNICAL SKILLS:
Hardware Platforms: - MVS OS, z/Series, UNIX, Windows PC, iMac, Cisco Catalyst 2960Cisco 1841 ISR
SOFTWARE: - COBOL, DB2, IMS DB/DC, CICS, RACF, QMF, SPUFI, Teradata Data Warehouse database, Teradata Online Analytical Processing connector, Open DataBase Connectivity administrator for Teradata, Teradata Client 15.10, Teradata SQL assistant, REXX JCL, G Suite, Gmail, Drive, Chrome, Webex, Cisco Jabber, Windows 10 Enterprise, MQ Series, z/OS, NDM, CyberFusion Integration Suite (CFI) for MFT, CA Clarity PPM, HP s Project & Portfolio Management Center, Macro4 - Dumpmaster, Tracemaster, Freezeframe, INSYNC for DB2, MQ series, & IMS, Candle DB2 Explain, FOCUS, MARK IV, BMC Unload Plus for DB2 Software & BMC Catalog Manager for DB2, IBM OnDemand, Rational Requisite Pro, Clearquest, Compuware Xpediter, File-Aid/IMS, File-Aid/DB2/RDX, File-Aid Data-Ager, File-Aid for MVS, Platinum, Smartest, Strobe, iStrobe, ENDEVOR, OS/MVS JCL, IBM Utilities. TSO/SPF, Omegamon, TMONDB2, VSAM, BTS (Batch Terminal Simulation), Intertest, IBM DFS Sort, SYNCSORT, PMSS (Programming Machine-Standard Solutions), COBOL SF, HourGlass2000, Portal 2000, Windows 7, Windows 10, Apple OS High Sierra, MS Outlook, Cisco Webex, LOTUS NOTES, MS Office Standard 2013, Visio, MS Project, Visual Basic, MS Visual C++, Borland Turbo C++, Java Visual Studio, Novell Netware, Microfocus Workbench (XDB/SQL, Microfocus COBOL, Stingray IMS), Peritus Mass change factory, SEEC COBOL analyst2000, Wireshark, Cisco IOS, Cisco Packet Tracer 5.2JIRA, Informatica 9.6.1 Developer Client, XML
PROFESSIONAL EXPERIENCE:
Confidential
MTS IV Consultant-Data Management
Responsibilities:
- Develop, test, and deploy production changes for data warehouse application using IT best practices, including Agile/JIRA methodologies to facilitate entry of user stories/epics and ensure high quality, timely release upgrades to end-user. Agile fast pace development was facilitated by weekly grooming calls, daily touch point and iterative development periods where IT development, system test & UAT worked together until all stories were ready for production.
- Designed real-time deployment of critical information in Proof of Concept effort to use Informatica Client ETL for the Enterprise Data Warehouse and Big Data initiatives.
- Led several business transformation initiatives contributing to targeted savings of $400M under the data enablement, finance, supply-chain and audit initiatives. Efforts included rollouts in support of Device Payment and Securitization of Tranches for Public & Private deals, enabling significant revenue realized for the enterprise. Accounts payable and asset management business intelligence/analytics projects assisted in governance over financial reporting within the organization as well as to enhance credit payment decision support systems and contributed to reduction in fraud.
Confidential
Mainframe Developer/Senior Software Systems Engineer
Responsibilities:
- Data Warehouse Extract team developer with key role in data mining of customer information from the Vision Billing systems to a Unified Data Model Teradata Data Warehouse for senior management business intelligence reporting. Participates in full project Software Development Life Cycle (SDLC) that includes project planning, business requirement analysis, data analysis, technical design documentation, developing and testing scripts and programs, developing reports and performance tuning.
- Projects include multiple phases of EDGE installment loans and Average Revenue per account dashboard reporting for Revenue Accounting/Finance group, migration of Business to Business customers onto new Logical Partition. Regularly implements data warehouse components during the Enterprise Release eight times annually, as well as off-release and critical fixes. Duties include work in the on-call rotation for support after hours.
Confidential
Cisco Network Associate
Responsibilities:
- Network transformation specialist performing configuration and engineering tasks in support of new voice and data routers, switches, and other Cisco hardware for production integration of merged office branches into a major U.S. bank's networking systems.
Confidential
Technical Specialist III/Senior Programmer/Analyst
Responsibilities:
- Senior Programmer Analyst with the primary responsibility for coordinating complex enhancements using software development life cycle.
- Managed multi-platform project teams in establishing quality assurance goals and best practices for software engineering on an international banking system supporting foreign exchange, securities processing and cash management business for global clients.
- Development efforts managed as a Senior Analyst on the International Money Management Systems, a mainframe system coded in CICS & DB2.
- Designed a solution oriented approach for new screen match information between FX vouchers and FEDWIRE confirm information enabling clients to reconcile their foreign exchange transactions with resultant money movement confirmations.
- Implemented daily NDM process to collect financial accounting information for multiple global branches during the regionalized batch cycle; sole purpose was to improve accounting controls; worked with global financial accounting department in Brussels & Luxembourg to customize multiple financial reports for CCY rates, FX rates, FX vouchers, and Money Market transactions, account balances, end of day balances, back valuations, and money movements for various classes of accounts.
- Developed daily xml file feed for account maintenance download to UNIX based application in effort to synchronize application information between mainframe applications and web-based platform.
- Collaborated with performance optimization application to fine tune over 1700 batch jobs and reduce the duration of the batch cycle. Task included an analysis of the 26 distinct branch requirements, customizing their needs, and measuring results in order to enhance batch performance. Some of the tools used to analyze streamline the daily batch cycle included STROBE and Candle’s DB2 explain.
- Created new DB2 tables to handle the processing of general ledger entries of combined FX accounts and specified subsequent statement facility necessary to manage client on-line inquiries.
- Worked on effort in support of the Confidential merger with the Confidential ’s custodial and cash management systems.
- Performed 24/7 Production support for 31 international branches on a rotational basis.
- Responsible for Process Quality Assurance & Software Process Improvement adherence throughout the department functioning in the role of Lead PQA support for all team members; providing expertise and guidance as mentor and coach, while imparting in-depth knowledge of CMM, SDLC & software quality assurance goals across the eight application, multi-platform team.
- Developed al program/s designed to enhance group’s best practices in software process.
- Subject matter expert for many of the CMM initiatives within the group, readying organization for positive SW-CMM assessment.
- Represented division as a PQA auditor in conducting objective process evaluations for applications external to the division in order to satisfy bank-wide Quality Assurance charter mission while meeting internal and external technical audit requirements. Well versed in all aspects of Systems Development Life Cycle. Performed IT audits, provided instruction to the audited application team, and gave project insight to management and software process engineering group.
- Coached the teams and assessed how well they embraced the mandated controls.
- Trained groups in all aspects of SDLC processes in order to meet QA expectations across the IT sector by developing staff in their ability to meet audit requirements both internally & externally to the organization.
- Managed performance level above the division norm using designated metrics reporting to senior management.
- Guided staff in drafting & finalizing required SDLC documentation, tailoring of same, and functioned in QA lead capacity for the institutionalization of SDLC process and activities for project development using the Bank’s best practices for software engineering.
- Co-authored several Software Configuration Management Plans for usage by the division, group & application areas. Developed divisional Process Quality Assurance Plan in conformance with SDLC requirements. Involved in preparatory of the group for incremental releases of the Process Quality Assurance evaluation procedures.
- Served on division’s software process improvement team to develop quality assurance initiatives, most important of which was a quality assurance monthly checklist, which assessed roughly 720 distinct project properties across large, medium efforts contrasted to 420 for small projects, to measure each team’s ability to meet the project’s quality challenges and to report select measures to senior management for insight into the project team’s effort, status and goals achieved.
- Developed and maintained the Business Continuity Plan. Managed disaster recovery testing for group participation, including business recovery exercises initiated via business lines, annual bank-wide technology center recovery, internal group emergency preparedness testing and pandemic event contingency planning. Adapted procedures for capacity planning, team response, off-site coverage, and communication. Broadened group’s abilities to perform as needed by periodic testing, and through presentations and embedded advance knowledge of who to call, what to do, where to go & what one might need in the event of any emergency.
Confidential
Assistant Vice President-Technical Specialist
Responsibilities:
- Responsible for the Bank's $250 Billion/day money movement systems, a system that interfaced with more than 100 internal and external applications to communicate wire transfer information such as SWIFT, FRB, NYCH, TELEX, & bank’s in-house customized PC based wire instruction systems. Fluent in all message formatting rules & message types for each of the wire transfer instruction systems as well as the agency money movement systems. Systems run on IBM MVS platform using IMS DB/DC & DB2.
- Supervised year-long effort in support of the New York Clearing House Inter Bank System Interface (CHIPS) mandated changes for payment Finality, the agency’s proprietary software set to reduce participant daily risk and EDI, an electronic data interchange between manufacturers as well as the payment parties in a financial transaction. The changes included quadrupling of messages sizes across VAX and IBM IMS DC environments while communicating with CHIPS; storing it in a new DB2 table designed for integrated access in the IMS online, passing the related 9,000 bytes of EDI information to historical applications and exceptional reporting of the newest time sensitive information for funds transfers. The assignment affected existing payment messages, addition of new payment resolver notification, requests for priority, deletion of all messages related to bilateral controls, new administrative reporting, final payment settlement, and procedural changes for contingency failures like Rule 13 and Rollback of transfers.
- Collaborated on division-wide task force to implement organization's Year 2000 compliance efforts for selected critical applications.
- Successfully piloted the Funds Transfer Systems' Year 2000 conversion efforts. Investigated and beta tested a half dozen Y2K tools for use at the Bank while accomplishing the Funds Transfer compliance and set the standard for effective Y2K strategies for deployment by various applications throughout the bank.
- Involved in the coordination of the bank’s Y2K testing with internal applications, outside agencies directly communicating with Funds Transfer (FRB, NYCH, SWIFT), and customer interfaces.
- Provided ongoing support for bank’s coordinated testing and re- of all critical applications for Year 2000 readiness throughout 1999 and into the millennium.
- Managed Y2K team to expand date fields for Human Resource and Payroll systems.
- Improved Bank’s emergency re-routing of money movement messages when it was deemed impossible to communicate with New York Clearing House in the case of a Year 2000 type or other emergency outage. Project involved detection of CHIPS agency close and automatic re-routing of payment messages en masse to the open FEDWIRE agency.
- Redesigned processing area queues for major partner, Credit Suisse, in handling their Funds Transfer business after they ended participation in the CHIPS money movement system. Effort required addition of the new broad based geographic area into the funds transfer distributed processing environment, so that the 9,000 daily items could be handled by specially trained former Credit Suisse employees to address their specific client base when items needed manual intervention.
- Led yearlong effort to recognize custodial accounts directly. Task included coordination of many interfacing systems to deal with a new form of account in order to do money movement.
- Implemented a product allowing an automatic intermediary to be used in Fully Automated Straight Thru payments. Credits to identifiers would be looked up on DB2 table for substitution in the payment message. Redesigned table and on-line screen for update handling. Enhancement removed need for operator intervention.
Confidential
Mainframe Developer / Project Leader
Responsibilities:
- Maintained large mainframe centralized systems for domestic and international customers with interfaces to electronic depositories, (DTC, PTC, FRB), as well as outside vendors,(IDSI, S&P, BOND BUYER, JJ Kenny). Implemented a 12 position serial note CUSIP on above systems.
Confidential
Lead Analyst/Project Leader
Responsibilities:
- Led project team on a year - long effort to implement New York Clearinghouse Inter Bank Payment System new message format. Effort included all aspects of the project life cycle, communication testing with VAX front-end systems, rewrite of existing interface between Funds Transfer and CHIPS, and user acceptance testing.
- FTS Enhancements for FEDWIRE included conversion of systems to FEDWIRE FLASH protocol, structured formatting changes for money messages requiring an IMS database expansion, and development of new screen for submission of drawdown requests to other participant banks under Federal Reserve structured message guidelines.
- Worked on the Cash Management Delivery System, a money movement system designed to allow retail and internal bank branches to enact funds transfers.
- Collaborated on effort to integrate Anti Money Laundering and enact Know Your Customer principles for every Funds Transfer transaction based upon text scanning of strings matching the Office of Foreign Assets Control list of suspicious entities. Parties in financial transactions were automatically compared to the OFAC listing of prohibited names. Clients were then subject to blockage of their money movement and operator scrutiny to prevent loss to the bank if prohibited transactions were allowed to finalize. Proprietary system developed & maintained by application team enabled automatic blocking of straight through payments and was used organization wide to satisfy compliance directives.
- Implemented a system for entry and validation of custody account information from Cash Management to Funds Transfer. In order to effect the payment and advise the payment transaction was input as an IMS message to the Cash Management System, and then sent to the Funds Transfer System by an IMS message switch. After the funds transfer was completed, the bank branch initiating the custodial instruction was advised using an IMS to CICS Inter-System Communication link.
