Performed business analysis to support migration of legacy Group Insurance administration system to Salesforce platform.• Lead daily scrum calls with project team reviewing status and scheduling of changes required in Salesforce platform• Wrote and maintained Jira stories documenting enhancements and defects required in target system • Partnered with business teams to elicit information for new voluntary product enhancements and designed user interface based on business needs• Wrote requirements for the implementation of new voluntary insurance products in the Salesforce platform• Facilitated requirement walkthroughs with development and QA team members

Managed data aspects of actuarial pre-processor (annuity/life) conversion from mainframe platform to SAP. Responsibilities included:• Working with architecture designing future state process of data intake, storage and ultimately user consumption• Analyzing and documenting existing data flows and transformations of actuarial pre-processor system for the purpose of defining project scope and identifying impacted resources • Leading analysis team responsible for building extensive mapping requirements incorporating data from external admin platforms supported by multiple third-party vendors• Attending weekly steering committee meetings communicating status, risks and accomplishments to senior leadership

Managed data related aspects of a large-scale transformation project aimed at modernizing and optimizing actuarial processes. At the core of these processes was a data store containing validated annuities information readily available for downstream processing and efficient reporting and analysis. • Designed and implemented enhanced annuities actuarial valuation platform focusing on inforce annuities data. • Partnered with annuities technology teams and actuarial teams in generating data specifications for valuation model and internal / external reporting.• Performed detailed analysis on annuities actuarial legacy systems to produce functional and technical specifications for the development team.• Designed database schema for optimal access to annuities seriatim level data received from source systems.• Tested system to ensure validity of data stored in new platform and facilitated UAT with actuaries.• Participated in regularly scheduled audit (internal and external) reviews of system processes and responded to questions and data/documentation requests• Produced a rigorous data quality strategy to ensure the accuracy and reliability of the annuities data.• Regularly met with the business partners to discuss system impact of new product launches and changes in regulatory requirements.

Transformed vast data delivery process pulling data directly from administrative platform to a self-service model employing advanced data stores and business intelligence tools. Result of effort led to both reduced cost and risk of providing this information to our annuities business community.• Thoroughly analyzed existing data request and delivery process determining both who in the organization was requesting information and what data they required • Managed a team of interns that were responsible for maintaining the project’s documentation and key metrics• Using complex SQL scripts, replicated many common requests made against the administrative platform for proof of concept purposes• Facilitated training sessions with the user community demonstrating how the self-service model can accommodate many of their data analysis needs • Measured progress of transformation the Cognos audit stores automatically created by our reporting tools or manually captured user information and compiled a database containing business functions’ data usage. • Elicited business requirements for sophisticated reports then designed and constructed these reports in the Cognos environment