Mairead Kasmere Email & Phone Number

Alexandria, Virginia, Us

Alexandria, Virginia, Us

Atlanta, Ga, Us

Atlanta, Ga, Us

Provides clients in various industries worldwide with high quality end-to-end ETL, data modeling, and reporting solutions. Developed strong data cleansing, modeling and reporting development skills with Power BI, Tableau, SSAS and SSRS. Multiple projects involving heavy use of the Microsoft stack including SQL Server, Azure, SQL Database and Data Warehouse, Data Factory, Logic Apps, Data Lake, Functions, Event Hub, KeyVault and more.Project Examples:- Provided ETL solution leveraging Azure Logic Apps and Data Factory to successfully pull data from a range of on-premises and cloud sources, perform transformations, and store in Azure Data Lake (gen 1). - Used T-SQL to create and modify external tables off of the data lake files to make the data accessible via Azure Data Warehouse and stored procedures to create tables and views from the external tables. - Assisted in creating a security data model with row-level security based on employee position, data type, and employee team. - Designed 6 Power BI reports (collaborating with UI/UX) heavy with technical challenges and passed reports to the client’s development team to take control during test runs with their financial team while continuing on as support as needed - Developed data acquisition and transformation processes from a range of data sources, built a new data model, created validation and report-ready Power BI reports, and collaborated with over 15 teams world-wide to prepare dashboards and reports with up-to-date, automatically updated data that was then presented to a major government agency

Atlanta, Georgia, Us

Business Intelligence team (June-January)- Assist in design, development, and testing of new company BI solution including leading meetings with various teams within Acuity to receive feedback, collaborating with external consultants, and executing to a project methodology plan and deliverables by phase.- Worked closely with external consultants to create PowerBI report wireframes to replace the current company SSRS reporting system that aligned with requirements determined by multiple meetings with usersEnterprise Architecture team (Jan-May)- Assisted in the initial steps of moving Acuity Brands to Microsoft Azure including spinning up, replicating, and failing over servers to Azure, installing agents, configuring web applications and creating documentation for all processes for future consistency- Created Charters, AS-IS and SHOULD-BE workflows for the team's 4 major projects that were signed off by the company Vice President of IST

Gb

• Performed evidence gathering activities and comprehensive testing for various clients through both the selection and the examination of samples in order to assess the design and operating efficiency of the current controls• Worked with a team to provide services regarding IT General Controls, specifically Access to Programs and Data, Program Development, and Computer Operations• Met with clients to gain in depth understanding of the scope of the IT business processes within each company.

Gainesville, Fl, Us

- Analyzed current company purchasing methods, organized records of previously ordered items into a user-friendly spreadsheet, and generated a system to automatically inform the Director of Operations to order specific products depending on inventory level.- Conducted industry research and surveyed current employees to generate options for promoting company morale which included ideas for team building events as well as designing and implementing a new office layout.- Assessed new employees’ adjustment process and created a “New Employee Handbook” in order to orient new interns or employees to the company and local area.

California, Maryland, Us

- Independently researched, developed and implemented a new purchasing and property control process and corresponding automated tool which received approval for use from the Defense Contract Management Agency. - Assisted senior Project Managers as part of a team of engineers who successfully pursued a new contract. Participated in preparation for solicitation release, building a team of companies, and preparing the proposal, learning what it takes to build a winning bid while competing against larger, long-established companies in the sector.

California, Maryland, Us

- Directly reported to the Company President and Vice President. Gained significant exposure to the challenges facing a small, innovative software company as it works to identify and pursue business opportunities in the face of limited resources and a lean organizational structure.- Created custom spreadsheets to increase efficiency of the monthly internal financial reporting process along with new electronic forms which streamlined administrative processes for employees working at remote locations.

Master'S Degree, Information Systems And Operations Management - Business Intelligence And Analytics

Bachelor'S Degree, Bachelor Of Science In Business Administration, Information Systems