Amy Shatzen
Lead Business Systems Analyst @Centene Corporation
Signup · Get unlimited contacts
WORK HISTORY
Lead Business Systems Analyst @Centene Corporation
Woodland Hills, CA, US
Performed a detailed data gap analysis between legacy Health Net systems and the Snowflake platform, developing complex SQL queries, to ensure a seamless retirement transition.• Developed automated SQL Server Integration Services (SSIS) packages that perform ETL tasks, integrating API, improving data load efficiency by 90%. • Pioneered the research and development of new API technology for automating data loads to SalesForce, reducing manual data load time by 80%.• Converted a lengthy hour daily process to scheduled SSIS jobs, saving 3 to 4 hours per day of manual processing. Wrote detailed documentation for the process which included Visio charts.• Engineered database applications for efficient source-to-target data load mapping to SalesForce by assessing business needs, collaborating with SME’s, and performing comprehensive testing.• Provided daily troubleshooting and root-cause analysis of data issues to quickly isolate the solution and implement it.• Continuously coached, advised and mentored co-workers to encourage professional development within the team.• Authored thorough user guides and technical documentation for all data loading processes, ensuring clarity and consistency. • Followed the Agile/Scrum methodologies (creating user stories) using Jira.
EDUCATION
UC Irvine
Bachelor's degree
Santa Monica College
Associate's Degree
California State University-Los Angeles
Master's degree
ABOUT AMY SHATZEN
I was destined to be a data analyst when my dad and I took the family cat to the vet and…
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.