Jody Rozenblit Email & Phone Number

Virtual, New Jersey

Within the Data Conversion Services team, I served multiple functions. - As a Lead Systems Analyst, I provided support, training and maintenance of the core ETL code and processes we used to convert legacy data into the Alight Benefits Administration system. - I coordinated with our ETL Vendor and internal IS groups to identify root cause and resolve issues that impact multiple client projects. - I performed regression testing for system upgrades (both Informatica, server and file system changes) and evaluated impact to the code, process, and documentation. I evaluated new functionality in new product releases and implemented improvements to our process. - I consulted with conversion teams on solving complicated business needs or data issues, and provided direction on how to use the base code. - Advanced Data Analyst on 3 clients: analyzing, cleansing and reconciling and reporting data- Coded and executed test plans, analysis reports, reconciliation routines as well as data cleansing.- Established and updated process improvement procedures across several teams to improve the efficiency of the conversion process as well as the quality of data.

Lincolnshire, Il And Virtually Starting In 2010

Aon Hewitt after merger:-- Designed, coded and tested using Informatica (ETL) tools, creating a data conversion process to load historical HR and benefits data onto system utilizing the Informatica Suite (ETL) of tools, SQL, Excel.-- Lead parts of complete redesign of data conversion/migration process from a mainframe SAS based conversion model to an Informatica ETL conversion model. -- Participated in vendor selection when reviewing various ETL tools for development project.-- Reviewed requirements with key stakeholders, wrote specifications, developed code and unit test plans and created documentation and training materials. Coordinated Integration and Regression testing with business analysts. -- Developed expertise in Informatica (ETL) suite of tools. Lead proof of concept efforts and developed business cases to evaluate additional tools like IDQ/DVO. -- Coached new Data Conversion team members in various roles. -- Provided system improvements and efficiencies based on issues and enhancements submitted by implementation team and as skills/knowledge of Informatica increased. -- Served as co-chair for Informatica User group and attended conferences regularly to improve our process and efficiency.

Lincolnshire, Il

-- Provided design, coding and testing, documentation and training for data conversion. -- Developed expertise in SAS, SQL and JCL coding. -- Service domains included Health Management and Defined Benefits. -- Worked within SDLC structure.

Lincolnshire Il

Ann Arbor, Mi

AmeriCorps VISTA (Volunteer in Service to America)

Bachelor Of Arts - Ba

Education record