Annessa Riechmann

• Participated in hiring and interviewing developer and analyst candidates. • Managed Special Needs data warehouse production process, bug fixes, retriggers, and communications. • Drove rebranding initiatives project, including all analyses, ETL, SQL, and reporting updates. • Lead migration of SSRS to Tableau, creating standardized procedures and reporting efficiencies. • Owned Tableau Production, UAT and DEV server environments, including global group management and security protocols. • Spearheaded project to optimize Data Warehouse production environment saving 1.5 hours of daily processing time. • Created process flow for SSIS jobs utilizing Active Batch to manage alerts, dependencies and allow for parallel job processing. • Participated in forecasting project management timelines in Jira and scrum.

• Hired and managed new team of analysts and developers. • Oversaw development, QA, and delivery of monthly board of directors report. • Collaborated with senior leadership to drive efficiency in processes based on operational KPIs. • Managed budget, contracts, and negotiations with technology vendors. • Sponsored company’s digital transformation, including migration to Snowflake. • Increased Tableau company adoption, adding over one hundred viewer licenses and driving the migration from Looker to Tableau. • Realized company savings of $50K+ in annual software costs. • Created a centralized data repository for reporting, developing ETL to merge multiple data sources. • Completed over eighty internal requests per quarter, including Dashboard Enhancements, Analyses, Custom Lists, and Bug Fixes.

• Developed comprehensive modeling for data warehouse capacity, initiatives, and department forecasting. • Created complex ETL in SSIS utilizing and merging multiple data sources. • Served as administrator and head developer of Cigna Confluence for the OE department. • Consulted with a wide range of departments on BI tools and best practices. • Managed all Tableau Server permissions and production site rules as needed. • Oversaw project management tool roll-out for top-level executives and teams.

• Managed MAPS project management reporting for top-level executives and teams, ensuring clarity and efficiency. • Generated ETL processes for merging data from Teradata, SQL Server, and Oracle sources to enhance data accessibility. • Converted team OneNote documentation into a structured site on Cigna Confluence, improving knowledge sharing. • Received multiple achievement awards for contributions and excellence in delivery, showcasing commitment to quality.

• Delivered comprehensive analysis that led to the reallocation of leads, enhancing revenue and operational efficiency. • Developed custom analytics templates and procedures for the Analytics team, streamlining reporting processes. • Created quarterly financial forecast models for sales teams, leveraging leads and regression analysis. • Merged Adwords and Salesforce data for tailored tracking within dashboards, improving data visibility.

• Developed complex T-SQL scripts for seamless CRM data transfer to reporting tables. • Created custom Tableau workbooks tailored to large non-profit clients' program requirements. • Trained clients on effective use of Tableau workbooks, enhancing their data visualization skills. • Mentored fellow analysts in Tableau and SQL development, fostering a collaborative learning environment.

• Compiled complex SSIS jobs to efficiently transfer and transform large data sets for reporting. • Managed Jira tickets and acted as the administrator for the Business Intelligence team at Mutual of Omaha. • Migrated Access projects to SSIS and SSRS, enhancing reporting capabilities. • Developed custom reports for dynamic email blasts using Crystal Reports and Business Objects.

• Managed the ongoing creation of a data warehouse environment to enhance reporting efficiency. • Developed a universal reporting request form in Salesforce to streamline data requests. • Created secure reporting depositories for the SMB Unit, ensuring data integrity and accessibility. • Generated complex queries from 6+ multisource servers, facilitating comprehensive data analysis.

• Managed a Data Warehouse project in SQL Server 2012, enhancing data accessibility for Small Business clients. • Developed ERD diagrams using SQL Developer Data Modeler to streamline data architecture. • Created comprehensive Business and Consumer profiles with SAS, improving marketing strategies. • Designed insightful dashboards and ad hoc reports using Tableau and Hyperion, facilitating better decision-making.

• Developed customized reports for multi-million dollar revenue accounts, enhancing data visibility. • Utilized Visual Basic and C# within Visual Studio for advanced report programming. • Extracted and manipulated data from Microsoft SQL Server using SQL language and SPSS programming. • Managed project deadlines effectively using Oracle, ensuring timely delivery of reporting solutions.