Ecommerce Business/data Analyst Resume
SUMMARY
- Business analysis for information systems planning/design/development
- Business process analysis - mapping as it and to be states
- Data management, data analysis, and dashboard/report development
- Project administration, project coordination and project management
- Technical training experience in instructional development/course development, course delivery/facilitation
- Technical writing and IT systems documentation (user manuals, job aids, quick reference guides)
- Proficient in gathering, classifying and manipulating data from multiple sources (databases, flat files) and extracting useful insight
- Proficient with design, development and distribution of management and operational reports as well as analyze data to identify trends and opportunities for improvement
- Proficient with business intelligence tools for use in data analysis and reporting
- Proficient with database queries to extract data for analysis and reporting
- Proficient in report design (tabular, graphic)
- Proficient in administration of information systems and manipulation of data
- Proficient in eliciting business requirements for information systems, developing AS IS and TO BE process flows, and using Scrum user stories and use case technique to document them
- Proficient in project administration/management, using MS Project and Clarity
- Proficient at communicating with stakeholders to provide accurate reporting and information regarding the ongoing projects, risks and initiatives.
- Proficient in training delivery via classroom and virtual environment
- Proficient in meeting facilitation
- Proficient in developing operational and system documentation and training materials
- Proficient in planning designing, and writing system materials, including articles, case studies, quick reference guides, specification documents, handouts, job aids, manuals and presentations.
- Knowledgeable in change management principles based on ADKAR
- Proficient in using Microsoft Word, Microsoft Excel, (advanced level, including PivotTables, VLookup and macros) Microsoft PowerPoint (advanced), Microsoft Access (advanced level), Microsoft Office, Microsoft Project, Microsoft Visio, Microsoft Publisher, Microsoft FrontPage and Lotus Notes.
- Knowledgeable in traditional SDLC and agile software development methodologies
- Knowledgeable in Web technologies/architectures
- Knowledgeable in data modeling (logical designs)
- Knowledgeable in use of Clarity for project management
- Experience using Brio and Cognos business intelligence tools.
- Utilize graphical tools such as Visio, PowerPoint, SnagIt, Visio and ERwin for documenting information systems with data flow diagrams, ER diagrams (data models) and system flow charts.
- Aptitude to learn software products.
PROFESSIONAL EXPERIENCE
Confidential
Ecommerce Business/Data Analyst
Responsibilities:
- UAT test lead for Integrate Third party project
- Create process documentation for third party data mapping into Confidential taxonomy.
- Update data flow diagram of item setup process/system interfaces.
- Perform data mapping of third party items/develop mapping rules.
- Perform name standardization on third party items to conform to Confidential standards.
- Responsible for overall coordination, status reporting and stability of project work efforts.
- Responsible for assembling project plans, directing and monitoring work efforts on a daily basis and escalating issues appropriately.
- Responsible for tracking key project milestones and adjusting project plans to meet project objectives.
- Responsible for managing cross-functional interdependencies.
- Responsible for monitoring project spend rate to stay within project budget.
Confidential
Business Analyst
Responsibilities:
- Gather requirements, develop and enhance Excel-based project management reports to improve data analysis and decision-making regarding staffing and forecasting.
- Update operational process documentation for a project management/resource management application.
- Develop and enhance Excel-based project management reports to improve data analysis and decision-making.
Confidential
Project Manager/Lead Business Analyst
Responsibilities:
- Initially brought onboard as lead business analyst to support the implementation of a new front office application (recruiting, account management, and sales).
- Gather requirements for all users and key personnel to understand the current functionality of the existing system.
- Perform current state process flow analysis and documentation through interviews with business users.
- Create Visio flow charts of as-is process flows.
- Analyze user needs and maintain business requirements.
- Develop and implement project plan to implement the new information system.
- Develop and maintain RACI matrix
- Interface with leading business partners in their areas such as training, reporting, configuration, data conversion, and deployment to the field.
- Manage a diverse project team that included business analyst, database analyst, infrastructure engineers, and developers.
- Plan and coordinate training for end users, system administration and report development.
- Collaborate with software vendor on development of role-based end user training (self-paced and Web Ex).
- Collaborate with software vendor in data integration of front-office application with back end accounting system for billing and payroll
- Coordinate work between different teams at different locations.
- Communicate and collaborate with the software vendor and internal customers.
- Facilitate and lead weekly team meetings.
- Maintain project status and create weekly status reports for management.
- Key lead with the software vendor to coordinate activities and project planning.
Confidential
Data Analyst
Responsibilities:
- Support the PMO Data Management team with initiatives:
- Collaborate with business users to develop/update report inventory to determine report ownership and service level agreement for delivery (Excel list, PowerPoint report tree).
- As part of process to improve service operations, develop data management team metrics around assigned support tickets (Cognos ReportStudio to select service tickets and create Excel reports/charts with findings).
- Create/update functional service level agreement for each business unit.
- Responsible for managing small project to in corporate updated Equifax credit scoring file for business unit.
- Gather, interpret and represent business requirements in process flow diagram.
- Work with IT Tech Services to implement changes to meet business requirements.
- Responsible for gathering/documenting requirements a data management support dashboard.
- Responsible for providing day to day support, troubleshooting and incident management.
Confidential, Boca Raton, FL
Business/Data Analyst
Responsibilities:
- Support the Windows Fileshares Split Project - an Confidential /TycoIS split initiative to separate shared network folders (fileshares) based on company ownership.
- Collaborated with business data owners on disposition of server data (migrate/delete).
- Created Visio process flow diagrams of fileshare separation/migration tasks.
- Created end user training guide for fileshare separation/migration.
- Created internal run book and project checklist for managing branch split activities.
- Created project announcement communication and project documentation.
- Maintain Excel-based list of departmental servers and business data owners.
- Collaborated on development of Excel-based project tracking and reporting spreadsheet.
- Coordinated/monitored departmental fileshare separation/migration status.
- Support the roll-out of ConnectMe self service portal for submitting application access requests.
- Support the roll-out of Chatter internal social media tool.
- Support the Windows Fileshares Split Project - an Confidential /TycoIS split initiative to separate shared network folders (fileshares) based on company ownership.
- Collaborated with business data owners on disposition of server data (migrate/delete).
- Created Visio process flow diagrams of fileshare separation/migration tasks.
- Created end user training guide for fileshare separation/migration.
- Created internal run book and project checklist for managing branch split activities.
- Created project announcement communication and project documentation.
- Maintain Excel-based list of departmental servers and business data owners.
- Collaborated on development of Excel-based project tracking and reporting spreadsheet.
- Coordinated/monitored departmental fileshare separation/migration status.
- Support the roll-out of ConnectMe self service portal for submitting application access requests.
- Support the roll-out of Chatter internal social media tool.
Confidential, Boca Raton, FL
Data Analyst
Responsibilities:
- Support the In Store Customer Experience project team with sale data analysis and performance reporting.
- Work closely with project team to understand reporting requirements and develop solutions to fulfill requirements.
- Facilitate progress reporting to all levels of store management by updating weekly dashboard of store performance.
- Develop and enhance Excel files using advanced formulas and macros.
- Monitor and report on daily quality issues.
- Utilize SQL Server as data repository.
- Support executive reporting for strategic project portfolio analysis with the development of key indicator dashboards
- Support the Enterprise Project Management Office (EPMO) team with design and development of roll-out new project management methodology and framework.
- Designed and developed PM training course and related materials.
- Develop portfolio tracking executive dashboard (Excel-based).
- Author/QA various PMO documents including demand management and integrated reporting.
- Participated in UAT for PM Framework.
Confidential, Miami, FL
Responsibilities:
- Supported the IT PMO in Clarity Project Management system administration which included weekly project and staff reporting, user adds/changes/deletes and staff support.
- Assisted in the collection and organization of past project data to be used as a baseline for analyzing project completion going forward. The initiative was part of a Six Sigma effort to improve project management.
Confidential, Ft. Lauderdale, FL
Project Manager/Business Analyst
Responsibilities:
- Led the initiative to centralize administration of a key marketing/CRM Internet-based information system for international countries.
- Managed project and resources from idea stage and project charter, implementation of the centralization model.
- Developed project charter, overall and by-country project plans.
- Developed and managed schedule to meet project timelines and delivery dates.
- Tracked and monitored project inter-dependencies and drove resolution to issues, risks, and changes.
- Designed process for request submission from end-users.
- Created guides and templates for requirements gathering and documentation.
- Developed go-to-market roll-out communications.
- Business analysis and documentation of as-is system information which included development of Visio process flows for key administration processes.
- Gathered requirements from SMEs for request submission templates.
- Wrote quick reference guides and training materials for the new centralized processes.
- Managed SharePoint site.
- Conducted/facilitated meetings via Live Meeting.
- Prepared project progress reports and status reports for management review.
- Developed 20+ intelligent Excel-based templates with embedded business rules and business logic for request submission.
- Developed and documented policies and procedures along with workflow.
- Utilized Microsoft Project and SharePoint for project management and communication.
- Global call center application project involving design and development of a new solution using a rules engine using agile development.
- This multi-year, multi-team project was planned to deliver new functionality in iterations.
- Represent project and project team in high-level management review and status meetings.
- Strong interaction with the end-users and product owners, stakeholders throughout the Project Life-cycle.
- Responsible for coordinating team’s involvement in the analysis, design and development of the business rule-portion of this solution, for management status reporting, and meeting facilitation on all-levels.
- Led analysis effort to design a business rule matrix for analyzing rules within business use cases and software use cases. Analyzed business process flows to identify and classify business rules.
- Utilized Microsoft Project for project management.
- Supported the implementation of a Project Management Office (PMO) including compiling application process flows, SLAs, responsibilities matrix and service catalog descriptions.
Confidential, Boca Raton, FL
CRM Project/System Administrator
Responsibilities:
- Worked with VPs and senior management on performance reports including loan officer sales and member service rep activity.
- Develop/run bi-weekly, monthly and ad hoc reports for sales/marketing and operations by extracting CRM data from SQL Server database and other sources, and formatting into Excel reports.
- Convert Access data into flat files for additional analysis.
- Provide ad hoc analytical support to operations and marketing.
- Collect and analyze usage data and prepare reports for management.
- Assist accounting with budget and other financial projects.
- Led training project for major system upgrade with responsibility for design and development of user and manager training classes and class materials as well as delivery of classroom training.
- Functional project lead for migrating to new version of CRM (client/server architecture).
- Interfaced with software vendor for planning and implementing upgrades.
- Provide functional support of the CRM environment - support customization and enhancement of CRM system.
- Evaluate opportunities to improve operational effectiveness and efficiency by implementing new features.
- Maintain CRM job aid library and end user documentation.
Confidential, Boca Raton, FL
Project Coordinator/Trainer
Responsibilities:
- Led training project with responsibility for design and development of user training classes and class materials as well as delivery of classroom training for new system roll-out (SCT Banner Student System for academic history, admissions, and student registration - client/server architecture).
- Participated in functional system testing.
- Interviewed functional users to assess needs and document training requirements.
- Involved with the change management effort.
- Create training materials (PowerPoints, handouts, quick reference guides, exercises, how-to tips, job aids) to meet the identified performance requirements.
- Developed training schedule for various classes.
- Taught 800+ staff over the course of implementation process.
- Wrote 250+ procedure manual for the Office of the Registrar staff on how to perform various processes using the new system along with many topic-specific quick reference guides.
- Developed self-paced study materials (video) using Camtasia.
- Participated in data standards committee; responsible for development of data standards manual and quick reference guide.
Confidential, Miami, FL
PMO IT Senior Trainer/Instructor
Responsibilities:
- Responsible for IT professional development training, including developing training documentation and curricula for the project management initiative (roll-out of enterprise project management PMO within Carnival Information Systems).
- Assigned to PMO project management team in managing roll-out of new PMO methodology within CCL, with responsibilities of coordinating overall training project for IT staff.
- Developed a new hire orientation program for IT professionals.
- Developed a performance goal template for setting and reviewing performance goals.
- Coordinated a performance management workshop on coaching/counseling.
- Developed content and training materials for “Conducting Project Meetings” and “Train-the-trainer” workshops.
- Developed course evaluations to provide feedback on course content and instructors.
- Conduct needs assessment for new training initiatives.
- Provided classroom instruction on MS Project, Enterprise Project Management, Brio (business intelligence application), MS Outlook, and HEAT (help desk) applications.
- Wrote new 260+ page Brio end-user training manual.
- Co-authored MS Project training manual.
- Assisted in administering and maintaining Intranet-hosted, Internet-hosted, and standalone learning systems to all shore-side, shipboard and remote employees.
- Taught custom classes when necessary.
- Provided one-on-one training on existing learning systems.
- Assisted with the production of the LRC newsletter which involves researching and creating new ideas for publication on current trends and special projects.
Confidential, Boca Raton, FL
Adjunct Professor
Responsibilities:
- Instructing junior level Management Information Systems (MIS) course and senior level Systems Analysis and Design course.
- MIS course includes instruction on concepts of using information systems within a business environment, such as the types of information systems, the logical components of information systems, computer hardware and software technology, how to plan and development information systems and coverage of databases and networking.
- The course included hand-on instruction on intermediate-to-advanced Microsoft Excel and beginning to intermediate Microsoft Access. Advanced Excel topics include pivot tables, macros, data tables, scenario manager and solver.
- The Systems Analysis and Design course includes teaching the full systems development life cycle (SDLC), including planning, analysis, design and implementation.
- The course includes feasibility assessment techniques and making a business case.
- The course covered functional and non-functional requirements gathering and documenting using methods such as use case reports, business process modeling with data flow diagrams and data modeling using entity-relationship diagrams.
- Students were taught Microsoft Project as a tool for planning and controlling their project.
- Students learned about developing documentation for information systems, training users, and developing an implementation strategy.
Confidential, Boca Raton, FL
IT Consulting Specialist
Responsibilities:
- Responsible for application/data analysis consulting, training delivery, and marketing of IT consulting services and products used in data modeling, business process modeling, business intelligence, report development, and database design/validation.
- Developed software installation and standard operating procedure documentation.
- Developed and delivered training services on Microsoft Windows XP, Microsoft Word, Microsoft Excel, Microsoft PowerPoint and Microsoft Access to organizations, using a hands-on approach to teaching how to use Windows, create spreadsheets and database applications.
- Provided IT consulting services on application, database design and report design.