Mark Plummer Email & Phone Number

San Francisco, California, Us

Specialized Enterprise Data Provider facilitating quarterly Regulatory Reporting submissions to the Federal Reserve Board (FRB). - Review and comprehend the Federal Reserve Board's instructions. Implementing robust compliance measures, regular audits. - Ensure traceability of how data is moved and transformed across different sources by Documenting data lineage to multiple data sources. - Identify and remediate data defects which includes thorough data quality assessments, validation checks, and the application of cleansing or correction techniques to ensure the accuracy and integrity of the data. - Develop and implement detective and preventative controls involves establishing measures to identify and mitigate risks within a system or process.- Create ad hoc reporting and analyses- Perform User Acceptance Testing for new or revised tables, views or queries- Create SQL queries and Views using SQL Management Studio- Create SQL queries for data extracts using Teradata Studio- Perform validations on changes made to the team’s primary data source - Develop and implement automated tools and processes for recurring team tasks- Develop data management and governance tools to manage metrics/measures- Author and manage documentation supporting all processes and procedures- Manage projects to include onboarding data ETL process and well as transitioning existing reporting processes to new business units

Charlotte, North Carolina, Us

Provide Reporting and Analytics to senior leadership focusing on the current state of the Life and Annuities Inforce blockCreate, manage and distribute analysis and reporting using intuitive BI Tools such as Qlikview and SharePointCreate and manage metrics focusing on inforce and sales projections and decrements Sales Reports • Provide executive leadership with Monthly Sales reporting to include: Monthly/YTD Sales report breakdown by Products, Distribution Channels, Age, Risk Class, Face Amount as well as Adhoc Reporting • All reports are created by transforming data extracted from multiple sources LIMRA(Life Insurance and Market Research Association) Reporting Using Microstrategy-Sales Data Mart tool and various formats submitted from multiple channels: • Submit Quarterly LIMRA(Life Insurance and Market Research Association), reports • Create Top 20 Industry Summary Report data from LIMRA results • Compile Product type analysis provided by team members into a Summary Report distributed to Sales, Product and executive leaders

New York, Ny, Us

Access Database Developer (Competitive Studies) Develop and manage Access Databases that capture competitor rates and create Benchmark studies. • Monitor top 20 competitors Rates and/or Product Changes • Extract data from multiple sources to create Benchmark databases • Export Benchmark Studies • Distribute Studies using Qlikview SharePoint Sites • Create automated tools to assist with newsletter write-ups and competitive analysis. Reporting Sales Reports • Provide executive leadership with Monthly Sales reporting to include: Monthly/YTD Sales report breakdown by Products. Distribution Channels, Age, Risk Class, Face Amount as well as Adhoc Reporting o All reports are created by transforming data extracted from multiple sources LIMRA(Life Insurance and Market Research Association) Reporting Using Microstrategy-Sales Data Mart tool and various formats submitted from multiple channels: • Submit Quarterly LIMRA(Life Insurance and Market Research Association), reports • Create Top 20 Industry Summary Report data from LIMRA results • Compile Product type analysis provided by team members into a Summary Report distributed to Sales, Product and executive leaders.

North Mankato, Mn, Us

Create, implement, and manage multiple Access databases which include inventory management, project tracking, invoicing, forecasting and billing. All databases are relational, containing menu driven graphic interfaces which allow input and report exports by multiple users in multiple locations. • Provide detailed time-sensitive reports enabling analysts, account executives and clients to manage critical inventory by tracking and forecasting usage trends.• Provide innovative solutions to clients’ ad-hoc reporting requests using Excel documents, SharePoint web parts and KPI tools.• Analyze report requests frequency and similarities that can be automated for ease of formatting • Manage data and document files for an enterprise-wide Online Document Library• Manage projects to migrate large volumes of documents and data to an Online Library by engaging and assembling the appropriate team members, working directly with clients, and monitoring progress through implementation.• Provide unique document automation solutions to clients’ business needs by assisting them in determining which format and electronic delivery method most effectively improves their business process.• Develop Fillable Electronic Forms, enabling users to complete documents online thereby reducing the need to print and store paper documents.• Maintain a working level knowledge of team members’ duties and provide support when necessary.

Arlington, Virginia, Us

Developed and implemented training to ensure the combat readiness of an eleven man infantry squad.Arms Room SergeantAccounted for the maintenance, security and deployment of over 400 weapons and weapon systems valued at over 2 million dollars.