Information Security / Etl Engineer Resume
SUMMARY:
Almost 30 years of experience, mostly in the financial services sector, as a software developer / engineer. Experience of/exposure to Z/OS, Unix and Windows software processes and their interaction across platforms.
TECHNICAL SKILLS:
Knowledge of the following: MVS & z - Series, JCL, Cobol, PL/I, Easytrieve, IMS (including OTMA), CICS, DB2, SQL, Datacom, MFS, XML, Websphere MQ, Connect Direct (Secure+) aka NDM), UNIX System Services, BMC Utilities, CA Utilities, Omegamon, TSO/ISPF, RACF, DFHSM, MicroFocus MFE and Revolve, CLIST, FileAid, IMS-Xpert/FileAid for IMS, Librarian, LCS, SCLM, Changeman, Infoman, ClearQuest, Vantive, Pac2000(Remedy), Method One, (Rational) Unified Process, UNIX, Sperry 1100 series, Cromemco, DOS, WSAD, (base) SAS.
PROFESSIONAL EXPERIENCE:
Confidential
Information Security / ETL Engineer
Tools: Remedy, Microsoft Active Directory Toolkit. SQL Server (for queries of HR), Endeavor and numerous other tools common to the TSO development environment.
Responsibilities:
- Expert support for application security teams, during their during their initial adoption of Confidential (Account Certification Tool) for access credential re - certification.
- Assist in set up, review & testing of data feeds, according to the Confidential (Interface Control Document) specification and in accordance with company policies.
- Provided an initial response to all data formatting issues. Give guidance on content, to best provide meaningful, understandable descriptions.
- Participated in Data Quality Validation processing of data. Remediated issues out of hours, especially supporting the feed from the Wholesale line of business.
- Set up & coordinated NDM Secure+ transmission tests.
- Supported semi-annual releases.
Confidential
ETL Technical Lead (Software engineer)
Tools: ClearQuest, Remedy & Changeman (controlled development environment) and numerous other tools common to the TSO development environment.
Responsibilities:
- Maintenance & support for the batch processing of 70+ files, transmitted between Confidential and external vendors.
- These are sent by a variety of transmission methods (NDM, FTP, etc), and with a range of different interactions with internal applications.
- This includes a set of Informatica workstreams delivering mortgage data to a data warehouse.
- End to end process improvement development.
- This ranges from eliminating dummy UNIX batch jobs, designed to detect file arrival on Network Attached Storage, to simple code changes to reduce the Confidential frequency of various mainframe jobs.
- Secondary support and problem solving functions for other team support staff.
- Conducting cost/benefit and critical path analysis in support of business administration functions.
- Member of the architectural committee.
Confidential
Senior Programmer/Analyst
Tools: Changeman, SPUFI, Strobe and many tools common in the TSO development environment.
Responsibilities:
- Ran simultaneous small projects, as sole technician or as Tech. Lead with associated onshore and offshore out-taskers.
- Identify re-engineering opportunities, improvements to database design and usability, and decommissioning opportunities.
- Provide thought leadership, in long-term migration to an SOA architecture.
- Creating technical documentation.
- Providing secondary support and problem solving functions for other team support staff.
- Conducting cost/benefit and critical path analyses in support of business administration functions.
Confidential
Application Developer
Responsibilities:
- Identified, coded & tested changes, to deliver the product for California Confidential .
- Confidential had an unstructured project development environment, with no recognizable development or project management methodologies. So, much of the work included creating informal intermediate refinement of the draft functional requirements.
- Maintained database neutrality - creating code to run on both DB2 & Oracle. Date handling and a few other “wrinkles” meant the code wasn’t 100% neutral. But it came close.
- Created change requirements for the J2EE developers, including changes to the interface/(Entity) EJB’s and front-end (web browser) processing (validation and layout changes).
Senior Systems Analyst
Confidential, Phoenix, AZ
Responsibilities:
- Lead legacy architect. Lead and guided architectural process for project’s legacy architects.
- SOA back end service designer/architect.
- Messaging expert - managed delivery of messaging middleware. Client (MQ) team liaison.
- Collaborated with Web Services developers, to develop a new Proof of Concept for a point-to-point message delivery pattern, BizTalk-WMB-OTMA/OTMA-MQ-BizTalk.
- Provided "translation" and coordination between Web Services staff & Mainframe staff.
- Supported the Technical Architecture team. Activities included advice on change control and testing environments and also providing VBScript MQ code fragments, for the test harness.
- Cell Lead, with dotted line an offshore development group.
Confidential
Senior Staff
Responsibilities:
- Graduate of the Confidential Technical Mentor program.
- Worked on a “Proof of Concept” real-time CRM application, to synchronize DB2, Datacom & Oracle service domains.
- Replaced numerous file transfer processes with adoption of Unix System Services, to write data directly into UNIX files from a COBOL program; alleviated communication & Scheduling issues associated with file transfer and dramatically reduced execution time.
- Provided cross-platform production support on 24x7 on-call basis.