Business Intelligence Data Analyst
Resume:
CARLA M. CAMERON
Streetsboro, OH 44241
www.linkedin.com/in/ccameron75/
630-***-**** ********@*****.***
SUMMARY OF QUALIFICATIONS
Over 16 years of Business Analysis experience with various large companies. Experience with presenting to both internal and external customers in Manufacturing, Energy, Trucking / Transportation and Food Services industries, as well as building productive and respective relationships within all levels of an organization.
WORK EXPERIENCE
PARKER HANNIFIN, Cleveland, OH 2014 – Current
Sr. Business Intelligence Data Analyst
Responsible for improving Data quality and the design and analysis of quality metrics for Corporate Master data, including, but not limited to Parker’s Customer, Distributor, Division, and Product data. Analyze requests for data and develop solutions to meet requirements of team and other colleagues.
●Create, compile and interpret key operational and statistical data. Analyze performance metrics and generate a variety of value-added reports for all customers, including KPIs and critical success factors.
●Develop and maintain standardized metrics for data and reporting on a routine basis and ensure timely and accurate generation of various types of reports.
●Help review and recommend improvements to BI data processes as well as reports and dashboards, including the creation of new reporting templates and analytical reports.
●Assist in the design, development and implementation of systemic improvements to processes and data standards to improve the quality of division and distributor reported sales data, customer and product master data, and other master data used throughout the company.
NAVISTAR INTL TRANSPORTATION CORP, Lisle, IL 2012 – 2013
Sr. Business Intelligence Analyst
Analyzed complex business problems and issues using data from internal and external sources. Automated daily agent reports for Senior Management to highlight breakdowns and reason for breakdown, as well as order updates for new engines.
●Identified and interpreted trends and patterns in datasets, locating influences. Created weekly report for main customer and held conference call with key players, tracking orders and alerting issues or possible delivery delays.
●Created specifications for reports and analysis based on business needs and required or available data elements. During UAT sessions with OBIEE developer, communicated business needs and issues with current platform, addressing changes needed, and working together to resolve open issues.
●Provided consultation to users and led cross-functional teams to address business issues with OBIEE 11g platform. Set up training sessions with the OBIEE Developer that was opened to all business users, instead of one-on-one training. Also set up and led open forum sessions where teams could share experiences and best practices.
●Worked with BCG (Boston Consulting Group), assisting in development of company turnaround plans for sales and marketing through compiling and analyzing market research on top customers, fleets, and competitors. Assisted with development of new Sales training program.
BP 2007 – 2012
Joint Venture Financial Analyst, Warrenville, IL 2009 – 2012
Compiled full sets of Joint Venture Financial Statements on a monthly basis, and compiled, reviewed and submitted Government FERC (Federal Energy Regulatory Commission) reporting quarterly. Analyzed monthly spend for pipelines in and on the Gulf Coast, and recorded variances and submitted journal entries.
●Monitored divestment activity on assets, ensuring closure of divested cost centers and monthly review of accounts over $500K were accurate.
●Reviewed and documented all procedures and processes, analyzing and implementing process improvements.
●Project manager for cross-training initiative across the team. Implemented round-robin approach, ensuring proper back up coverage in case of emergency.
Retail Operations Business Analyst, BP, Naperville, IL 2007 – 2009
Developed and implemented tools that displayed internal and external performance for the 6 teams supported and distributed these dashboards to our customers and Senior Management.
●Analyzed financial budgets for each team and department monthly, trained and made team leads accountable, and decreased our overall departmental variance plan over actual by 12%, to just a 3% variance.
●Compiled and edited information from each team in department, creating PowerPoint slides and graphs to represent team performance, achievements, and issues on a monthly basis, and presented to director and senior management.
US FOODSERVICE, Rosemont, IL 2004 – 2006
National Accounts Business Analyst
Prepared detail of work plan and schedule, completed detailed analysis and research, identified options, prepared reports for management and recommended action or change. Conducted detailed customer analysis and research in areas such as financial performance, cost control, and operating metrics.
●Solved problems which required originality in approach, creativity in design, and ingenuity in solution, with use of Oracle database (Data Warehouse) which holds sales data and MS Access.
●Conducted special non-financial and business-related studies as requested, followed established procedures and created new procedures, analyzing customer business performance.
TRANSUNION CREDIT BUREAU, Chicago, IL 2001 – 2004
Computer Security Analyst
Led implementation of company’s latest Remote Access software. Produced and presented monthly statistics and accomplishments performed by team for upper management. Supported and operated security software and related tools.
●Completed everyday tasks such as running and analyzing reports, creating and terminating user IDs and access, rule writing, and ensure systems overall are operational and effective.
CHICAGO AREA SPORTS TEAMS, Chicago, IL 1999 – 2005
Sports Statistician (Part-time role)
Documented the Play by Play stats for Football teams such as Northwestern University, Chicago Rush Arena Football League and the Chicago Bears. Audited plays entered for Chicago Bears. Play caller for University Illinois Chicago and Northwestern University Basketball teams (Men and Women).
EDUCATION
MBA, Business Management, Robert Morris University, Chicago, IL 2011
BA, Math Major, Business Minor, Ohio University, Athens, OH
TECHNICAL SKILLS
Microsoft Office (Word, Excel, Access, Outlook, Power Point), Microsoft SharePoint, Siebel, UNIX, C, Crystal reports, Oracle Data Warehouse, Oracle Business Intelligence Enterprise Edition (OBIEE),
Mainframe, VPN (Virtual Private Networks), SAP, Oracle EDQ, Power BI, Zoom, Project Management, Change Management, Budget Planning, Forecasting, Software testing, Computer Security, Process Documentation, Analytics, Cross Training, Time Management, Teamwork, Troubleshooting
Yellow Belt certified (BP)
Contact this candidate