Business Systems Data Analyst Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

SUMMARY OF QUALIFICATIONS

• Business Intelligence Enterprise Management — assists clients in moving from incremental reporting to integrated dashboards and scorecard based on results and strategic goals.  Combines corporate data sources (e.g., Finance, Field Operations, etc.) to produce EVA (Economic Value Added), BVA (Business Value added) strategic united, analytical automated feedback - allowing management to quickly act on trends, issues and challenges in real time.   Constructs automated Business Intelligence tools that shorten client reaction time, strengthen customer loyalty, reduces cost and achieves profitable growth.  Dashboard, Scorecards based on KPIs - visual aids continuously refresh to indicate trends and progress in reaching forecast goals  -  details expand when necessary to indicate issues or suggest opportunities.  Drill-through visual aids focus attention on progress (i.e., pods, wheels, charts, graphs, gages, mouse over, videos, pictures, power points, etc.).  Automates and streamlines integrated report processes at all hierarchy levels.  Supports clients in outdistancing competition with planned strategic amalgamated reports that include intricate ties to sales, finance (cost/profit), customer knowledge, field operations and business departments. Supports clients in finding where to make money, make more of it faster and sustain growth longer - fundamentally supporting and changing organization when necessary.  Well thoughtout scaled BI that solve issues, use a shadow copy of business data to reduce business system burden with queries, scrub and normalize data, merge data from different repositories, optimized data for reporting as opposed to transactional operations, pre-aggregate data. Experience in sales, pre-sales of technology services and large deals.   Presents status to senior executives, fields operations, sales teams, loyalty programs and corporate sales.
• Microsoft BI Tools Expert - Constructs integrates BI solutions with SQL Server 2008 R2 & Office 2010, Visual Studio 2010 and Sharepoint 2010 PerformancePoint Services.  Creates multidimensional stores for aggregating business data with SSAS.  Built analysis with Excel and Excel services.   Combines data form difference sources and connects data for analysis with power pivot.  Moves data into the system using SSIS, Infopath, Streaminsight and Sharepoint 2010 External lists.  Builds and publishes reports with SSRS.  Integrated data from disparate applications using Sharepoint 2010 BI features.  Created scorecards and dashboards PerformancePoint Services.   Summarizes large volumes of data in charts and graphs.  Uses SSRS map features for complex visualizations of spatial data.  Uncovers patterns and relationships in data using the SSAS data mining engine.  Handles master data management with master data services.  Publishes the components of BI solutions and performed administrative tasks.
• Sharepoint 2010 Server Administration - Plans deploys, administers and maintains Sharepoint Server 2010 (install, architect, farm, Scale and Migrate legacy).  Secures, protects and optimizes Sharepoint architecture (virtualize, deploy extranets & authentication scenarios, antivirus and edge security, email and exchange integration, safeguard confidential data).  Maintains SQL Server databases for SharePoint, customizes/manages libraries and lists, designed and managed pages and sites for knowledge workers, managed metadata and content types, content integration (Office web apps, excel, access and Visio), create/managed workflows customized solutions with Sharepoint designer and Visual Studio 2010, creates/manages BI solutions with PerformancePoint and business connectivity services and governed Sharepoint ecosystem.
• Project Management and Research Management — manages multiple projects, motivates cross-functional teams towards common goals, directs new system development, gathers business requirements and business processes, develops business cases, designs systems and implements project.  Reduces cost by consolidating operations, eliminates redundancy, eliminates bottlenecks and disconnects, evaluates critical path, inspects process cycle time and workflows.  Institutes performance measurements, documents business processes, requirements, definitions and data models.

EXPERIENCE

NDEX (Brooksource/ TECHNICAL YOUTH LLC), Farmington Hills, MI  October 2010 to June 17 2011

Business Intelligence Enterprise Management

Built corporate BI Reporting processes, Enterprise Architecture, produced data model, created standard reports, created adhoc reports, created business user playground semantic reporting area (e.g. webi SAP), built cube reporting and visual click-through trended dashboard dashboards based on KPIs with color codes, dials and charts.  Combined corporate data sources to produce strategic united, analytical automated feedback - allowing management to quickly act on trends, issues and challenges in real time.   Moved incremental reporting to SQL server and reporting BI tool.

Reviewed BI Reporting tool(s) to solve data and reporting challenges.  The BI tools review identified BI reporting options (and cost) for small, medium and large partners.  Narrowed down tool review to only include tools with a robust BI platform with a proven ability to deliver enterprise wide implementations and an operational capability to deliver on a global basis and support a broad range of BI strategies.  Reviewed various BI tools for use:  SAP (Edge, Crystal and XCelsius, Enterprise), IBM COGNOS, SQL Server 2008 R2, SSRS, MICROSOFT SharePoint BI Reporting, ORACLE, SAS, MICROSTRATEGY, Dundas, TIBCO (SPOTFIRE), QLIK, QLIKTECH, Powerbuilder, INFORMATION BUILDERS, WebFOCUS BI reporting and Teradata.  Setup and managed BI tool auditing, security, change management, ETL integration and setup DW.  Downloaded tools to a server, setup data on the server, setup corporate data in the BI tools.  Created queries in BI tools to support reports, created data universe(s), Setup secure user environments in BI tools with corporate data, created ad hoc and standard reports, dashboards, scorecards and cubing.  Trialed BI tools with partners to assess the tool(s)' ability to solve data and reporting challenges with ad hoc web-based user reporting areas, click and drill dashboards, etc.  Documented the SKUs and training necessary to complete a BI tool platform for small, medium and large firms.

ENTERTAINMENT PUBLICATIONS (The Judge Group), Troy, MI. Mar 2010 to Aug  2010

BI Enterprise Solution Architect

Lead business requirements for Business Intelligence project, documented business models, data models, story boards, conducted workshops and brainstorming sessions, documented business processes, stakeholder analysis matrix, BRD (Business Requirement Document), requirements traceability matrix, use cases, requirements glossary, data dictionary, communication plan template, requirements management plan template, documented details for data new data models, documented BI Models for Business Object tools from a functional and technical capability.  Supported BI Project manager in defining, developing and maintaining more complex technical specifications, complex reports, test plans, and system / functional requirements.  Worked with large complex projects and complex organizations, directed and supported PM Methodology.

PULTE HOMES (TekSystems), Bloomfield Hills, MI  August 2009 to March 2010

Business Intelligence Data Analyst Consultant

Corporate Report Liaison between Field Operations, Finance, IT and business departments.   Formulated reporting strategies to improve cost, standardize cycle time and increase profits.  Evaluated plans that measured progress in reaching goals, forecast growth, charted and examine trends and suggested opportunities.  Managed data from multiple sources, streamlined corporate and field report processes and directed automation of corporate system development and reporting.  Provided comprehensive Economic Value Analysis (EVA) and Business Value Analysis (BVA).

·         Created an Integrated Field Enterprise Scorecard and Analytic Brand Reporting for Pulte, Del Webb and Centex based on Key Performance Indicators (i.e., Return Based Growth, Cost, Gross Margin, Productivity, Quality, Customers and People). 

·         Created Unexpected Cost Reporting - creating unexpected cost categories, trends and differences nationally, regionally and at different times of the year.  

·         Created pod reporting, process wheels and scorecard reporting in accordance with corporate plans and goals. 

FORD MOTOR COMPANY (AQUENT), Dearborn, Michigan June 2006 to Jan 27, 2009

Field Sales Business Intelligence ROI Liaison Consultant

Liaison between IT systems and Marketing and Sales Senior Executives, field operations and loyalty/customer-initiative programs.   Manage data from multiple sources, develop and streamline field report processes and direct system development.  Evaluate sales and marketing initiatives, measure progress in reaching metric goals, forecast growth, chart and examine trends and suggest opportunities.  Instrumental in increasing Field Operations effectiveness by designing cost effective, versatile, purposeful report processes.  Visual results tracked & rewarded field  teams that surpassed scorecard goals, displayed visually pleasing, user friendly, business objects, supported any business need and displayed any number of business metrics. 

Developed Business Intelligence Tools – established Integrated Field Reporting tools - combined several data sources and definitions and reconciled to financials.  Present executive power information at different points in time (daily, weekly, yearly or in project periods) to micro-market positive changes to brands and vehicles, compared to competition sales, buyer changes (new sale versus prior purchase), product line sales, brand sales, incentive sales, BUDGET, lease sales, cash sales, term, tier, model year and other metrics combined into reusable business objects for reporting and query purposes, including area (region, marketing area, dealer, etc.).

GM ONSTAR (JDM), Detroit, Michigan May 2003 to June 2006

Field Sales Business Intelligence Data and Report Liaison Consultant

·         Received Report Wizard Award for a report the Field Operations deemed “their most powerful tool”.  This report enabled the field to pinpoint opportunities and reward performance at the foundation dealer salesperson level.  Enabled the business to reach zone>region>nation and finally global business goals and objectives.

·         Streamlined and standardized reports to minimize the amount of time spent on administrative processes.  Drove the development of ad hoc and standard global reporting processes and supported teams involved in the change.  Used Business Objects, Power Point, MS Access, Excel formulas, macros, pivot tables and charts to report and analyze progress in reaching business goals.

·         Pursued research that indicated xxxx has a higher time-to-turn than non-xxxx vehicles, an integral measure in driving xxxxx as a standard option on all xxx vehicles.

·         Initiated research that indicated  xxxx is a prevailing force that positively changes behavior, consistently improves scorecard performance and distinctly increases dealer CSI scores.

KMART CORPORATION, Troy, Michigan Mar 1998 to Sep 2002

Project Manager / Business Systems Data Analyst  

Defined and implemented Business Process Modeling standards.  Directed project teams to document business processes, institute performance measurements, eliminate redundancy and create common processes and common platforms.  Developed business cases.  Initiated and managed new project documentation, cost, benefits, etc.. 

·         Instrumental in implementing a major BPR project, involving 112 systems, six months ahead of schedule by instituting effective gap analysis practices and by creating competition among sub-teams. Saved $900,000 in system memory by eliminating unnecessary data from 65 systems.

·         Recommended purchase order/shipper/invoice matching changes that potentially saved $3 million annually in inventory costs.

·         Guarded the corporation against liability risks and ensured superior merchandise was delivered to stores.  Developed and implemented a Distribution Center Quality Assurance system.

·         Invented a business case for a new attribute system that would use store and item attributes to create location-specific assortments for 1200+ stores that matched customer and corporation needs.

·         Interfaced with senior management to report project progress, coordinate budget, track project hours, risk management, or any other department wide summaries and analysis.

·         Coordinated IT Projects – supported development teams, used MS Excel, MS project and Workbench to track project progress.

·         Streamlined and supported internal department reporting requirements to minimize the amount of time project managers and cross-functional teams spent on administrative processes.

·         Promoted when created/presented corporate "Best in Class" business process standards to senior executives.

THE EXPRESS GROUP, Walled Lake, Michigan  Mar 1997 to Jan 1998

Administrative Professional    Trained administrative staff to track and respond to clients effectively with advanced Microsoft Word, Excel and Access features.  Improved packaging, distribution and rebate fulfillment processes.

NSB (NORTH SLOPE BOROUGH), Dept. of Health & Social Services, Barrow, Alaska Feb 1993 to Oct 1996

Project Manager / Health Educator 

Directed a benchmark health education project via a federal government grant.  Substantially increased health education and surpassed Alaska state health education standards. 

·         Developed a network that identified, addressed and solved health concerns at local, state and national levels through the establishment of a consortium of 75+ members (i.e., elected officials, community leaders, health board members, health organization officials, search and rescue and school officials).  Facilitated quarterly consortium meetings to continually address and adapt the health fair project to meet the needs of each village, developed annual progress report for the federal government (i.e., described budget, logistics, health screening station charted results, demographics and consortium responsibility).

·         Exceeded health education goals by 67% by implementing effective processes, by creating competition among villages and by rewarding volunteerism and contribution. Villages set new records for state health fair attendance records.

·         Directed 4-day-long Health Symposiums throughout NSB villages.  Annually recruited 200+ volunteers.  Secured financial sponsors, directed publicity, special events, health exhibits, basic screening station volunteers, health and addiction presentations, volunteer training, basic screening stations (e.g., registration, height, weight, blood pressure, blood testing, vision screening, evaluation and checkout).   Trained two persons from each village to plan, organize, fund a health fair.

NSB SCHOOL DISTRICT Substitute Teacher / Library Technician, Barrow, Alaska  1991/92

KBRW Radio Station Assistant, Barrow, AK  1993

ILISAGVIK COLLEGE, Tutor and English as a Second Language, Barrow, Alaska 1996

WEST BLOOMFIELD SCHOOL DISTRICT Preschool Teacher, West Bloomfield, Michigan 1990/91

ST. JOSEPH MERCY HOSPITAL, Pathology Technician, Unit Secretary, Pontiac, MI  1986-91, 1981-84

GENERAL INDUSTRIAL EQUIPMENT  Office Manager  Pontiac, MI   1985-87

EDUCATION

·         Bachelor of General Studies Oakland University, Rochester, MI  Jun 22, 1989 Major General Studies, Minor  Management.  Masters Degree in Business Management and Statics (Wayne State and Oakland University) Dec2015.

·         BI Tools:  SQL Server 2008 R2, SAP (Edge, Crystal and Xcelsius), IBM COGNOS, MICROSOFT, ORACLE, SAS, MICROSTRATEGY, TIBCO SOFTWARE (SPOTFIRE), QLIK, QLIKTECH, INFORMATION BUILDERS. 

·         Object Oriented analysis and design, UML modeling, Classic design patterns and J2EE patterns.

·         Build process and integration tools (e.g. JUNIT, Ant, Maven, etc.).

·         Waterfall or Lean/Agile delivery environment, SCRUM/XP development expertise.

·         Service Oriented Architecture (SOA)

Multi-dimensional modeling

·         ETL products required (e.g., Informatica).

·         Development languages:  Java, JavaScript, 

L, CSS and XML.  Write to achieve value added business outcomes

·         Certification – Dale Carnegie - Leadership/Public Speaking Oct01 Livonia MI, Cognos/Reportnet Jan06, PMP Sep12, Proforma-Provision  Business Process Modeling and Data Modeling Southfield, MI Jan01, Project Management Kmart University Aug01, IT Consulting Skills Kmart University Sep00, BABES Beginning Alcohol and Addiction Basic Education Studies Southfield, MI Dec93, Project Workbench Kmart University Dec98, System Life Cycle Reporting Jun01. Extraordinary Expert PC skills – Cognos, ReportNet, Crystal Reports, Outlook, Access, Excel, MS Word, MS Project, PowerPoint, Graphics, Photo Editing, Video Editing, Web page, Brochures, Macros, Advanced Queries, Formulas, Hyperlinks, Pivot Tables, Corporate and ISO processes, Visio, SQL, Microsoft SQL Server T-SQL, Visual Basic, Business Object Design/Rptng, Provision Business Process Tool, Data Modeling tools, Workbench, Oracle, SAP, Informatica ETL, CRIMSON, ERP, Baan, ERP LNPeople Soft Procurement, MCTS Sep14, MCITP Sep14, MCA Sep14, or MCM Sep14, Service Oriented Architecture (SOA), Java, JavaScript, HTML, CSS and XML , VMware View, Citrix XenDesktop, Perl, SQL Server Reporting Services (SSRS), Cloud Computing, SAS, Infor, Epicor, and QAD, POP, WOP and SOP business processes expert.  PeopleSoft HCM and Benefits Administration 9.0 & 9.1. translate benefit plan requirements into PeopleSoft.  ERP application and PeopleSoft support. Principal focus is providing ERP, database and infrastructure support for Oracle, Sql Server, Linux & Unix, PeopleSoft, Lawson and other ERP applications.

Download Resume Format