Janet Mitchell Email & Phone Number

Venice, Fl, Us

Venice, Fl, Us

Atlanta, In, Us

Atlanta, In, Us

Indianapolis, In, Us

• Developed complex reports and queries using the backend database tables for Microsoft Dynamics AX 2012 and Microsoft Dynamics 365 including critical reporting for the migration from AX 2012 to D365 • Created visualizations and reports for all departments and levels of leadership in SSRS, Power BI and Tableau• Extensive experience creating advanced SQL queries, stored procedures, views, functions, tables, indexes, SSIS Packages, and SQL Agent jobs• Designed various database models and constructed corresponding databases and data marts• Managed database and report server security • Converted Microsoft Access databases to SQL Server

Whitestown, Indiana, Us

• Manage, maintain, and support the church database management systems • Provide specific training to staff and volunteers based on roles • Ensure effective and stable electronic check-in process for various ministries (used by 1000+ people each week)• Implement database upgrades and patches • Create, maintain and enforce comprehensive guidelines and procedures to ensure consistency of use• Create and modify SQL Stored Procedures, complex SQL queries, and SSRS reports to enhance functionality• Created a directional metrics dashboard for leadership • Modify HTML, CSS, ASP.NET, and C# files• Manage security rights and user access to databases• Research and install new Arena .NET modules to enhance functionality • Restore, drop, backup, and create databases and tables in SQL server 2008 R2• Assist users in maximizing functionality and generating custom reports• Configure and customize the user interface to meet ministry needs

Indianapolis, In, Us

• Maintain and support the enterprise Microsoft Dynamics CRM software package• Transformed new user training to better target specific roles• Conduct new user training• Restore, drop, and create databases in SQL Server• Assist users in maximizing the CRM functionality and generating custom reports• Manage security rights and user access to CRM• Configure and customize the CRM user interface, workflows, and plugins to meet business requirements• Technical and functional lead for the upgrade from CRM 4.0 to CRM 2011• Design, create and modify reports using the CRM report wizard and SQL Server Reporting Services• Collaborate with users from all markets and roles to understand issues and enhancement requests, answer technical and functional questions, and train them on improved processes and functionality• Assisted with upgrade of Marketron software for all Emmis markets

Indianapolis, In, Us

I was responsible for all phases of the software development life cycle, including business analysis, requirements gathering, database design, development, testing, and maintenance. In addition to managing and supporting 15 applications simultaneously, I also helped with strategic initiatives, including assisting with the creation of the new IS Governance process, improving IS communication within the national office, and improving camaraderie within the IS staff. Additional responsibilities and achievements:*IS Communications Lead - collaborate with the Communications department to communicate all new IS applications, tools, updates to existing products, etc. to the national office*Assisting in the creation of the IS Strategy and Governance process for the national office*Responsible for all phases of the software development life cycle, including business analysis, requirements gathering, database design, development, testing, and maintenance*Served as a liaison between the developers and the NCAA’s web hosting vendor and initiated the effort to clarify the monitoring and services provided*Saved the NCAA $10,000 annually and provided greater data integrity by bringing an outsourced process in-house*9 years of experience developing Java web applications using a MVC framework*Integrated applications with the Oracle Financials System to aid and streamline Accounting processes*Automated inefficient mailing processes for a department and annually saving three employees 2 weeks of time each *Technical lead of the applications and database tables that gather and store the annual membership data which is used in all of our applications*Extensive experience in creating database tables, triggers, indexes, functions, and stored procedures in Oracle

Bloomington, Illinois, Us

*Supported all of the Life Actuary Department’s PC-based software packages*Designed and developed a COBOL program that automated the daily system date entry into the Life Company processing, saving the company millions of dollars*Installed and maintained necessary upgrades to a 3rd party software package*Designed, developed, tested, and integrated JCL and DOS programs into a 3rd party software package and database*Developed functional documentation for business partners and detailed technical specifications for developers*Developed detailed project requirements and test cases for various projects*Established quality goals and procedures for an enterprise research project*Reviewed and verified project management plans, processes, and deliverables to ensure the project met time and quality objectives