Frederick Kirwin's Email Addresses & Phone Numbers

MS OFFICE SUITE: Excel, Word, PowerPoint CRM APPLICATIONS: Microsoft Dynamics (2011), TechExcel, eRecruit BUSINESS INTELLIGENCE REPORTING TOOLS: Cognos, Tableau, MS PowerPivot, SSRS, OLAP Cubes, Crystal Reports, Microstrategy, DOMO DATA MINING TOOLS: SPSS Modeler, Microstrategy PROJECT AND PROCESS MANAGEMENT APPLICATIONS: Microsoft Project, LeanKit, MS Visio DBMS: Oracle (10g, 11g), MS SQL Server (2005, 2008, 2014), Access, MySQL, Vertica...

MS OFFICE SUITE: Excel, Word, PowerPoint CRM APPLICATIONS: Microsoft Dynamics (2011), TechExcel, eRecruit BUSINESS INTELLIGENCE REPORTING TOOLS: Cognos, Tableau, MS PowerPivot, SSRS, OLAP Cubes, Crystal Reports, Microstrategy, DOMO DATA MINING TOOLS: SPSS Modeler, Microstrategy PROJECT AND PROCESS MANAGEMENT APPLICATIONS: Microsoft Project, LeanKit, MS Visio DBMS: Oracle (10g, 11g), MS SQL Server (2005, 2008, 2014), Access, MySQL, Vertica DATA WAREHOUSING/DATABASES/DATABASE ADMINISTRATION: Dimensional/Star Schema, Data Vault, Relational/3NF, Stored Procedures, Triggers, Entity Relationship Diagrams, Red Gate, Linked Servers ETL/DATA MIGRATION: SSIS, Scribe, Talend TESTING: Telerik,Test Rail IDE: Visual Studio (2008, 2012) PROGRAMMING LANGUAGES:Python QUERY LANGUAGES: SQL, T-SQL, PL/SQL BUSINESS INTELLIGENCE: Dashboard, scorecard and report creation and maintenance. Data analysis and data mining. BI planning and program design. BUSINESS ANALYSIS: Gathering requirements, creating processes and documentation for information systems. User training. Creating use cases. MARKETING: Sales analytics and competitive intelligence.Data Management @ From September 2015 to Present (3 months) Data Warehouse Analyst/Business Data Analyst @ Applications-Dynamics CRM, Manage2000 (ERP) • Assist in managing projects related to the enhancement of the Dynamics CRM system. • Administer Dynamics CRM on premise application. • Create new entities, forms, views and fields in Dynamics CRM to help business maximize Dynamic's ROI. • Assist users and management in creating workflows and business processes utilizing available applications and technology. Data Warehousing/Databases-Microsoft Environment (SQL Server 2012) • Maintain company databases, staging areas and data warehouse. • Enhance data warehouse using dimensional data modeling techniques. • Create ETL packages using SSIS. • Use SSAS to create reports, maintain and enhance Centrix's OLAP reporting. • Create new reports from data warehouse using SSRS and PowerPivot. • Manage systems integration using a variety of tools and vendors including Scribe and NovoRoi. • Created cube in SSAS to monitor sales activity. From April 2015 to August 2015 (5 months) Shelton, CTBusiness System Analyst/BI Developer @ Applications (eRecruit): • Support the evaluation, testing, and roll-out of new features. • Respond to, triage, and resolve end-users issues and inquiries. • Work with vendor to ensure business needs are being met. • Identify and implement workflow and/or business process improvements to enhance the productivity of our employees, optimize decision making, and reduce time frame from identifying an opportunity to winning the business. • Work with training department and other business units to ensure that users are aware and properly trained on new application features or enhancements. • Perform and document automated and manual release testing. Reporting: • Provide consultation and when necessary write queries and reports. • Work with SSRS, SQL queries and other reporting tools to gather data, develop and validate reports to support business needs. • Assist in maintaining and developing enterprise data warehouse. Currently testing a project to architect a data warehouse using dimensional modeling consistent with Kimball methodology. • Perform necessary database administrative activities to support production databases and enterprise data warehouse. Duties include: writing stored procedures, creating triggers using Knowledge Sync, creating SSIS packages for maintenance and ETL, writing insert and update scripts to update the databases and revising current scripts to align them with business needs. From August 2013 to April 2015 (1 year 9 months) Wakefield, MASignal Support System Specialist @ • Maintain radio and data distribution systems. • Perform signal support functions and technical assistance for computer systems. Tasks include installation, troubleshooting and maintenance of various information and signal technologies. • Provide technical assistance for local area networks. • Equipment used includes: Harris HF Radios, Harris Tactical Satellite Radios, SINCGARS, MBITR, Blue Force Tracker (FBCB2), TOCNET, CASI and other tactical switches, routers and networking equipment. From August 2011 to August 2014 (3 years 1 month) Melrose, MABusiness Analyst @ • Collected, analyzed, and evaluated sales and financial information to increase operating efficiency. Responsibilities included gathering requirements, process creation and documenting processes. • Assisted in maintaining and auditing company information systems including financial and sales databases. • Guided sales and administrative staff in proper usage of company information systems. • Executed strategic marketing campaigns through the use of company’s CRM sales database. • Supervised cross functional teams in the execution of national projects related to the MS Dynamics. • Served at the subject matter expert (SME) for MS Dynamics CRM and the sales database. • Created and maintained reports in Excel using a variety of source data. From June 2009 to August 2011 (2 years 3 months) Woburn, MAMasters, Business Administration @ University of Massachusetts Boston From 2011 to 2014 B.S., Business Administration @ Saint Michael's College From 2004 to 2008 Frederick Kirwin is skilled in: Marketing, Insurance, Employee Benefits, Risk Management, Recruiting, Process Improvement, Microsoft Office, Account Management, Underwriting, Analysis, Customer Service, Health Insurance, Business Intelligence, Microsoft Word, Applicant Tracking..., Microsoft Excel, Strategic Planning, Property & Casualty..., Data Analysis, Outlook, Leadership, Training, Social Media, Operations Management, MS Project, SQL, Team Building, Sales, Access, CRM, Management, Cross-functional Team..., Data Warehousing, Requirements Analysis, Databases, Software Documentation, Business Analysis, PowerPoint, Data Mining, Team Leadership, Visio, Testing, Program Management, Microsoft SQL Server, PL/SQL, Cognos, Visual Studio, Microsoft Project