Anita Jerome
Sacramento
Summary
Dynamic Information Technology Analyst with a proven track record at EDD, State of California, excelling in ETL development and data migration strategies. Adept at leading cross-functional teams and enhancing data governance practices, I drive impactful solutions that streamline workflows and ensure data integrity, fostering collaboration and innovation in every project.
Overview
25
25
years of professional experience
Work History
Information Technology Analyst
EDD, State of California
Sacramento
01.2024 - Current
- Developed and deployed ETL pipelines (SSIS, SAS, AWS Glue, Snowpipe) for migrating mainframe and SQL Server data into Snowflake.
- Automated workflows to ingest structured mainframe tables and SQL Server schemas into centralized Snowflake data warehouse.
- Validated data transfers through automated row-count reconciliations and business-rule checks, and a match between datasets.
- Executed SQL- and Python-based cleansing scripts in staging and production environments, correcting anomalies pre-go-live.
- Scheduled and automated conversion jobs via IBM Flow Manager and AWS Batch, ensuring minimal downtime for downstream systems.
- Mentored 3–4 junior data engineers on full lifecycle of BI data-warehouse projects, enhancing team capabilities.
- Partnered with Finance, Operations, and IT stakeholders to refine acceptance criteria and secure final sign-off with zero critical defects.
- Maintained metadata registries to empower analysts with governed access to data mart tables, reducing ad-hoc requests.
Information Technology Lead
Atheropoint LLC
Roseville
01.2015 - 01.2024
- Pricing analysis and model preparation.
- Monthly reporting of Client billing and Finance department coordination.
- Develop client requirement and product requirement documentation for engineering design and enhancements.
- Perform DBA role for MS SQL Server and BI tools.
- Report development using complex SQL and reporting tool.
- Design, setup and maintenance of internal websites.
- Test medical applications released by the development team.
- Run a validation test of our internal software against industry standards.
- Involved in preparing FDA approval documentation of our internal software.
- Prepare product installation and user guide for clients.
Lead Build/Release Engineer
iPass Inc.
Redwood Shores
01.2001 - 01.2009
- Clearing and Settlement product release management
- Release bulletin preparation in collaboration with Business and Product teams
- Automated build process to run on daily and weekly basis with validation against expected build output.
- Reorganized source code into modular structure to aid agile development process for front end applications.
- Created detailed instructions for deployment of software packages on different target platforms.
- Plan and conduct BRP and BCP exercise.
- Support internal and external audit.
Education
Master of Computer Applications -
India01.2000
B.Sc. - Physics
India01.1997
Skills
- Programming languages: Java, PHP, UNIX
- Database management: SQL, MySQL, SQL Server
- Agile methodology: Scrum framework
- Test automation and deployment
- Business process automation
- Data migration strategies
- ETL development techniques
- Snowflake administration
- Tableau reporting skills
- Data governance practices
- Data analysis expertise
- Project management proficiency
- Cross-functional collaboration
- Effective communication skills
- Team leadership
References
References available upon request.
Timeline
Information Technology Analyst
EDD, State of California
01.2024 - Current
Information Technology Lead
Atheropoint LLC
01.2015 - 01.2024
Lead Build/Release Engineer
iPass Inc.
01.2001 - 01.2009
Master of Computer Applications -
B.Sc. - Physics
Similar Profiles
Siva DandamudiSiva Dandamudi
Salesforce Technical Architect at State of California, EDD, State of OhioSalesforce Technical Architect at State of California, EDD, State of Ohio
Roberto HintonRoberto Hinton
Associate Information Systems Analyst at State Of California-EDDAssociate Information Systems Analyst at State Of California-EDD
Diamond BaileyDiamond Bailey
Claims Processing Specialist at Maximus with California State EDDClaims Processing Specialist at Maximus with California State EDD
John TrujilloJohn Trujillo
Executive Chef at Mulvaney'sExecutive Chef at Mulvaney's
Raymond AliRaymond Ali
Assistant Manager at Handel's Homemade Ice CreamAssistant Manager at Handel's Homemade Ice Cream