Sid Katz Email & Phone Number

New Hyde Park, Ny, Us

New Hyde Park, New York

Greater New York City Area

Greater New York City Area

Key member of Corporate Data Warehouse team involved in all phases of SDLC supporting cross-functional business areas.• Activities included stakeholder interviews for requirements gathering, developing business requirements documents (BRD), creating functional specifications (FRD) with source to target data mappings, build & execute test plans (UT and UAT), generated implementation plans including triggers and dependencies and provided customer support after going ‘live’. • Led the design, testing and implementation of the Retail Sales Data Mart that allowed for high volume data reporting and analysis used by the Financial Management Department (FMD), Individual Policy Services (IPS) and Corporate Compliance.• Developed complex SQL queries using joins, groupings, aggregations and sub queries for data analysis and extraction of data from an Oracle Data Warehouse.• Detailed knowledge of all aspects in the life cycle of Life Insurance policies and Annuities.• Served as the SME to Financial Management Information Systems (FMIS).• Partnered with IT and business stakeholders to resolve escalated Production issues.• Defined SLA parameters when sourcing data from outside vendors (Experian, FISERV, DST).• Worked with the internal auditors to obtain data that was sent to NYS to fulfill their requirements.

Hicksville, New York

Integral participant in cross-organizational teams for analysis, mapping, extraction, transferring of data and documentation in support of the merger of JPMorgan Chase and Bank One.• Developed COBOL programs that merged high volume customer files ensuring seamless and timely service.• Member of Quality Assurance team that finalized merged DB2 Data Warehouse data.• Teamed with ETL, DB Admin and Operations in support of all new projects related to the newly combined organization.

Hicksville, New York

Performed analysis, data mapping, design, QA testing and documentation of applications in support of end-user access to the DB2 Data Warehouse.• Built a Web process that reduced Data Warehouse table maintenance from multiple days of application programming to logging two table entries resulting in savings in excess of $1MM.• Identified and implemented process improvement that optimized execution of marketing campaign month summary reporting from a DB2 DBMS.• Monitored and reported on client problems and issues.• Updated stakeholders on problem status and ensured speedy resolutions.

Brooklyn, New York

Analyzed, designed, coded and documented Extract/Transformation/Load processes on a DB2/UDB DBMS.• Lead Cobol programmer on both new and existing applications in the Credit Card division and Securities Services division where data was stored on a DB2 DBMS. • Led development of a Customer Information File that allowed users quicker access to data while significantly reducing labor cost.• Analyzed and compiled data viewed by Customer Service for call center reporting and analytics.• Led meetings between IT team and internal business analysts.

Diploma, Information Technology, 4.0

Bachelor'S Degree, Accounting, 3.5