Erin Ramirez Email & Phone Number

Seattle, Wa, Us

Seattle, Wa, Us

Austin, Tx, Us

- Lead & participated in project design meetings with architects, designers, ETL developers, & reporting staff to identify requirements & work through issues- Mapped data elements from multiple legacy systems to EDW tables, including querying, reviewing, & correcting legacy data- Collaborated with end users to identify, understand, & document business processes, KPIs, & reporting requirements, including acting as liaison between report designers & users- Researched & tested data both before & after loading into new EDW- Wrote SQL queries, scripts, views, & stored procedures, including nested queries, CTEs, & pivots- Assisted & provided input in structure & schema development for fact & dimension tables in new EDW based on Kimball Methodology- Technical team lead on ETL project for Workers’ Compensation (WC) claims data from TPA- Developed & tested ETL code to load WC claims to new EDW based on requirements using SSIS- Assisted business users with migration to NavRisk system, including requirements and testing- Assisted with extracting & testing data to be migrated from Risk360 to NavRisk system- Solely responsible for extraction of WC policy data from legacy Risk360 to be migrated to NavRisk system, including identifying data requirements, mapping data fields from legacy data, developing SQL scripts to extract data, testing data, & resolving issues in legacy data- Developed, tested, & modified reports in Cognos, BO Edge, & SSRS- Wrote custom C# code for reporting requirements not handled by BO Edge- Cognos Administration duties, including migrating reports to environments & security- Worked directly with end users on multiple applications, including Risk360, iMIS, Access databases, & custom C# web applications, to provide support, training, & resolve issues as reported- Database administration responsibilities including security, user access, backup, & restore of various databases- Version control & documentation for changes to Risk360 OLTP system

Austin, Tx, Us

Primary business analyst for developing and creating brand new systems, and for enhancements/modifications to existing systems. Systems developed were for both web-based use and stand-alone systems. Business analysis duties included meeting with potential users; identifying, clarifying and maintaining requirements, including documentation; testing of system, including developing test cases, running test cases, assigning test cases to other testers, gathering and documenting test case results and reporting back to programmers; assistance in implementation of final systems, including user support after implementation; maintaining enhancement lists; creating project plans using Microsoft Project software. Database administration, including designing, developing, creating, populating, documenting, and maintaining databases used for majority of systems. Including making modifications to data and responsibilities for databases as systems were moved to production. Also including creating and maintaining database dictionaries and entity relationship diagrams for systems. Responsible for running custom queries upon request for end users and other customers, and formatting results appropriately. Programming experience in PHP, VB.NET, C#, and Java, including experience with MySQL queries. Experience with Eclipse and Microsoft Visual Studio. Additional organizational duties including maintaining requested project lists, staff meeting scheduling and notes, and acting as desktop support backup to IR staff.