Post Job Free

Resume

Sign in

Data Analyst Manager

Location:
Camby, IN
Posted:
January 09, 2021

Contact this candidate

Resume:

Laura Miller - *

Laura Miller

Indianapolis, IN 317-***-**** adjaps@r.postjobfree.com https://www.linkedin.com/in/laura2015/ PROFESSIONAL SUMMARY:

Over 15 years of experience as a Systems, Business, Data, Project Analyst, Database Report Developer with focus in business software and systems. Strong background with clients, designers, and developers to identify business requirements, assist with creating user interfaces, and develop implementation procedures. Works well in both independent and group settings, along with interacting effectively with subordinates, peers, functional managers and clients. Demonstrated aptitude for technical writing producing clear, accurate, and concise documentation. Tracked various project deliverables, dates, and checked deadlines for accuracy. Experienced in Business Objects Enterprise Products (Desktop Intelligence, Web Intelligence, CMS, CMC & CCM) and its deployment.

TECHNICAL SKILLS:

Operating Systems: Windows 10, Windows 7, Windows XP, Windows 2000, AS400, DOS Software: Vista, SQL Server Management Studio, Infor Visual MFG, StaffSuite, Kova/Sapphire, Toad, PL/SQL Developer, Oracle SQL Developer, VisualCut, Remedy, ServiceNow, Sharepoint, JIRA, Confluence, Microsoft Office Suite, GoTo Meeting, Evernote, MS OneNote, MS Project, MS Visio, Lotus Notes, SmartDraw, Monarch, Compleo, JasperReports, Clarity PPM, Notepad++

Business/Software Methodologies: AGILE, Technical Writing, Standard and Custom Reports Business Objects: Crystal Server CMC (Central Management Console), H.P. Quality Center, Crystal Reports, Repository Manager, Active Directory, Web Intelligence (WEBI) Reporting, SSRS, SSMS, Microsoft Power BI, Tableau, BusinessObjects Design Studio EDUCATION SUMMARY:

Ivy Tech Community College

GPA 3.7/4.0 – Graduated Cum Laude: May 2008

A.A.S in Computer Information Systems – Programmer/Analyst Specialty Certificate in Visual Programming

Relevant Coursework: Information Systems Fundamentals, Logic Design and Programming, C++ and Advanced C++ Programming, Database Design and Management, Website Development, Visual Basic and Advanced Visual Basic Programming, Network Fundamentals, Systems Analysis and Design, SQL PROFESSIONAL EXPERIENCE:

Infrastructure and Energy Alternatives, Inc.

ERP Analyst July 2020 – Present

● Resolve Level 2 and above requests and issues in internal ERP System (Vista)

● Manage and maintain enterprise resource data across all corporate entities

● Review data for inconsistencies or anomalies

● Generate and review documentation for all system updates

● Assist with report and data extraction when required

● Troubleshoot data-related problems and implement modifications

● Update system when released by software vendor

Arbor Homes/Silverthorne Homes, a Berkshire Hathaway Company Data Manager November 2019 – July 2020

● Develop and manage data upload sheets to support internal ERP System (Mitek, Kova, Sapphire)

● Maintain database integrity and conduct routine maintenance as required

● Review data for inconsistencies or anomalies

● Generate and review documentation for all database updates

● Assist with report and data extraction when required

● Troubleshoot data-related problems and implement modifications Laura Miller - 2

MW Industries, Inc.

Business Analyst, Report Developer Crystal Reports July 2019 – October 2019

● Created, modified and distributed new, existing, ad hoc and sub-reports in Crystal Reports

● Data analysis of report results to determine the cause of discrepancies from the ERP system (Infor Visual MFG)

● Worked to improve processes and increase efficiency of existing reports.

● Performed data validation, analyzed data, identifying problems and proposed solutions for potential data fixes.

● Evaluated existing reports for reduction of redundancy

● Tested current and new reports to confirm fulfillment of project requirements The GEL Group (Contractor through OMT Consultants, LLC) Database Report Developer, iNet Clear Reports June 2019 – September 2019

● Report conversion from Oracle Reports to iNet Clear Reports

● Created, modified and distributed new, existing, ad hoc and sub-reports in iNet Clear Reports

● Data analysis of report results to determine the cause of discrepancies

● Worked to improve processes and increase efficiency of existing reports.

● Performed data validation, analyzed data, identifying problems and proposed solutions for potential data fixes.

● Team collaboration for report needs and requirements gathering

● Tested current and new reports to confirm fulfillment of project requirements Schneider National (Contractor through Kelly Services) Database Report Developer, Clarity PPM/JasperReports November 2018 – May 2019

● Wrote Clarity database reports

● Evaluated existing reports for reduction of redundancy

● Team collaboration for report needs in Clarity

● Tested current and new reports to confirm fulfillment of project requirements

● Data analysis for existing and new reports

RenPSG (Renaissance Philanthropic Solutions Group) November 2016 – November 2018 Senior Report Developer, Crystal Reports

● Created, modified and distributed new, existing, ad hoc and sub-reports in Crystal Reports.

● Data analysis of report results to determine the cause of discrepancies in the internal ERP system.

● Scheduled Crystal Report distribution using SAP Crystal Server Central Management Console (CMC).

● Scheduled report distribution using VisualCut, .bat file and Windows Task Scheduler.

● Generated monthly, quarterly and annual reports.

● Created templates to help streamline the process for new report requests.

● Communicated with the business team in evaluating existing reports for conversion to templates.

● Worked to improve processes and increase efficiency of existing reports.

● Performed data validation, analyzed data, identifying problems and proposed solutions for potential data fixes.

● Gathered business requirements from other internal teams within company and customers to create custom reports based on data needs.

● Business/Process analysis – providing training on current processes and needed improvements.

● Updated documentation for reporting process.

● Documented project progress on helpdesk and project tickets in JIRA.

● Created and modified SQL queries to enhance report creation.

● Modified existing stored procedures.

Eli Lilly and Company (Contractor through BCforward) June 2014 – November 2016 Systems Security Administrator/Data Analyst

● Managed security administration and account management for 14 internal, industry-specific ERP systems (LIMS)

● Managed system access in Active Directory

● SharePoint Administrator

● Audited systems on monthly, quarterly and annual basis to maintain SOX compliance

● Technical writer updating documentation for auditing procedures

● Data Analyst for system databases in IndyDry division

● Provided support for Business Intelligence reporting Laura Miller - 3

TCC Software Solutions March 2014 – June 2014

Software Developer/Data Analyst

● Modified existing stored procedures for Crystal Reports

● Modified existing Web Intelligence (WEBI) reports

● Ran existing Crystal Reports and WEBI reports

● Data Analysis

● Updated documentation for report procedures

Smithville Communications, Inc.

Project/Process Analyst March 2011 – March 2014

● Business and process analysis of all operational processes.

● Subject matter expert in ERP software (NiSC Telecom Solutions).

● Technical Writer developing documentation and process workflow charts, increasing overall efficiency.

● Gathered business requirements from internal staff.

● Documented standard operating procedures, providing end user training.

● Created/maintained end user documentation.

● Oversaw project responsibilities of project team members.

● Assisted project manager in all phases of implementation.

● Established, maintained and coordinated the project timeline and updated Executive Team.

● Developed, created and distributed process flowcharts to all staff affected by processes.

● Designed custom Crystal Reports and Showcase Queries on-demand for team leaders, managers and corporate executives.

● Implemented process to automatically distribute recurring reports.

● Extracted data from AS400, and MS Excel to incorporate in reports.

● Performed data validation and corrections that involved analyzing data, identifying problems and proposed solutions for potential data fixes.

● Served as primary point of contact for technicians’ schedules.

● Administered SQL database of fiber optic customers.

● Acted as a liaison between the business and development teams communicating project status and issues regarding development and implementation.

● Performed portal administration to include: managed content for all lines of business, administered role based security, created end user training documentation and provided end user training. Information Support Specialist/Data Analyst March 2009 – March 2011

● Data analysis for SQL database of fiber optic customers in internal ERP System used to schedule technicians, inventory parts needed for installation and billing.

● Wrote Crystal Reports and Showcase queries for SQL Servers and AS400.

● Distributed daily and weekly reports for multiple staff members.

● Technical Writer documenting processes in the IT department.

● Subject matter expert in industry-specific software.

● Assisted other users with issues they were experiencing.

● Remotely connected to users for technical assistance. Employment Plus, Inc. November 2004 – February 2009 Credit Manager, A/R Manager

● Oversaw invoice generation and cash application in internal ERP System (Staff Suite)

● Scheduled Crystal Reports using CMC (Central Management Console)

● Liaison between EPI and funding company for receivables totaling $1 million weekly

● Reduced number of past due accounts

● Ran weekly reports as needed for both in-house and client requests

● Trained staff at multiple branches on payroll entry



Contact this candidate