Senior Technical Business Analyst & Data Engineer
Resume:
WENDY CHANG
BROOKLYN
NEW YORK, NY 11210
email: **********@*****.***
*.*******@******.***
PROFESSIONAL SUMMARY:
Senior Technical Business Analyst with extensive hands-on experience in data analysis, data extraction, data lineage, and ETL design and integration utilizing tools such as Ab Initio, Oracle, PostgreSQL, Unix, SQL Server, PL/SQL, DB2, and COBOL.
• Databases Supported: SQL Server, Oracle, PL/SQL
• Operating Systems: Unix, Linux, Windows
• Scheduling Tool: Autosys
• Tracking / Deployment: Jira, uDeploy
HARDWARE: UNIX, TOAD SQL Server, IBM Mainframes (OS/390, ES9000, S3083, S/370) SOFTWARE: SQL Server, TOAD SQL Server, Oracle, PL/SQL, COBOL LE, MQ SERIES, CICS/VS, SQL/DB2, DYATRON – Global Custody, Swift Messaging, Fileaid, MSA Packages: Payroll, Human Resources, General Ledger DBEDIT, QMF, PLATINUM, SPUFI, MS ISQL, TSO/ISPF, INTERTEST, FTP, XPEDITOR, CA- ENDEAVOR, NDM, OS JCL and Utilities, DOS/VSE, ROSCOE, CHANGEMAN, SDF, VSAM, BMS. EXPERIENCE:
For NYC (Dept of Health and Mental Hygiene) 06/26 – 8/26 IT Staff Consultant
Manage and resolve Service Center tickets pertaining to Health and Permits licensing in Accela and Accela Automation. Additionally, support quality assurance efforts by testing updated software releases. For a Major Bank (CITIGROUP) 03/02 – 10/25
Data Engineer and Onsite Coordinator
Planning, design, development, testing, and implementation of new conversion process converting US and Latam Clients, Entitlement Groups, and account linkages from Hogan over to OneSource. This project included the mapping and functional specifications documentation for CBNA interface feeds from CBNA CAS, TIPS, Systematics Checking and Savings, Custom ESA, DLS Mortgage, and GPS Ready Credit product systems to Project1 ODS.
Developed code to generate business, underwriting, compliance, and control reports for the SaaS platform, transforming complex nested API responses into structured Oracle Database data, streamlining business queries and analysis.
• Skilled in ETL mapping and experienced with various source and target systems such as flat files, relational databases, and COBOL copybooks for investment data integration from firms like BNY Pershing and Fitek.
• Delivered on key regulatory requirements including FATCA 871m, ensuring timely tax and audit reporting.
• Used SQL to answer queries from clients, bankers, and auditors, and to produce periodic global reports.
• Analyzed data quality issues using graphs and identified rejected data due to inaccuracies or missing values.
• Possess solid business knowledge across banking, investment, securities, asset allocation, and credit card domains.
• Participated in large-scale data migration to Exergy, enabling rapid transfer of millions of records.
• Built a scalable data masking tool that anonymized sensitive production data for over 100 tables, supporting test data generation and benefiting multiple teams. For a Major Bank (BANKER’S TRUST/DEUTSCHE BANK) 04/90 – 01/02 Senior Programmer/Analyst
I contributed to the development of several integrated systems within Global Custody utilizing SWIFT message formats. The sub-systems included:
• Securities Lending, leveraging CICS, DB2, and COBOL 2;
• Entitlement Tracking, employing DB2 (DRDA), CICS, and COBOL LE;
• Global Plus, an accounting platform for SUNGUARD, implemented with MQ Series, DB2, CICS, and COBOL LE;
• Global 1, utilizing SWIFT messaging format, COBOL LE, DB2, and CICS. My responsibilities encompassed requirements analysis, system design, application development using CICS, COBOL LE, DB2, and MQ Series, as well as testing, production support, and select DBA functions. During my tenure as Senior Programmer/Analyst for BTWORLD 4.2/5.0, a quasi-client-server asset and securities inventory management system developed with CICS, DB2 (dynamic SQL), and COBOL 2, I was tasked with analysis, design, programming, unit and integration/system testing, and ongoing production support. Additionally, I participated in the enhancement and maintenance of the Interdepartmental Transfer Processing System, an accounting solution interfacing with two MSA systems—Financial and Budgetary Control Systems. My role focused on analysis, program enhancements, and coding of CICS modules and related tables. I was also responsible for the analysis and implementation of the Decentralized Proof Sheet Processing System, enabling each Journal Area to independently create and submit proof sheets to the General Ledger. For a Major Manufacturer (Seagrams) 2/89 – 3/90
Senior Programmer/Analyst
I was accountable for installing and securing the MSA Human Resource and Payroll System. These systems enabled prompt access to and updates of personnel information as needed. Comprehensive and selective security protocols were implemented to safeguard all confidential data. For a Major Insurance Firm (Guardian Life Insurance) 2/86 – 1/89 Oversaw the maintenance of the Sensitive Transaction System, ensuring purchase orders and invoices were effectively monitored, with rigorous security access controls administered by the Controller for evaluation of sensitive transactions.
Served as a key team member in the analysis, design, implementation, and ongoing support of the Automatic Transfer Option within the Human Resource System.
Managed the Personnel Reporting System and restructured it to deliver comprehensive employee profile documentation to company officers.
EDUCATION: University of Waterloo (CANADA) – (BSC in Computer Science) REFERENCES: Available upon request
Contact this candidate