We provide IT Staff Augmentation Services!

Senior Business Analyst Master Resume

4.00/5 (Submit Your Rating)

NC

SUMMARY:

  • SME Focal Point for Business Intelligence Reporting Tools, working cross functionally with Global Organizations (IT, Call Center, Operations, Sales, Finance, Marketing and Promotions, Data Security, Management)
  • Administrative Support, Commissions, Travel and Expense Reporting in support of multiple stakeholders on top of analysis. (SVP, ED, CEO, Channel Chiefs)
  • DataAnalysis (10+ years),Database Management (9 years),Business Processing (6 years), Leadership (9 years),Project Management (6 years),Requirements Gathering (9 years),BigData(5 years) Teradata (7 years), Report Development (10+ years)
  • Microsoft SQL Server administration and maintenance functions of production and QA
  • Responsible for the accuracy of the sales support; data modeling/ warehousing and maintenance and Visualization for presentations of stakeholders
  • Data Governance, Cleanup, Integrity using SQL, Citrix, SAP Business Objects, and CRM SFDC, OBIEE, ODBC, Access etc
  • Building Visuals (Scorecards and Dashboards) in MicroStrategy, Business Objects, Tableau Power BI
  • Ensure Taxonomy Guidelines are communicated to Content Stakeholders
  • Global Enterprise Accounting / Reconciliations/ Statistical/ Regression Reporting
  • Subject matter expert for the development, implementation and maintenance of Master Collection, Retailer, Distributor and Industry Standard Taxonomies
  • Understands the business side, technology and analytics with use of tools for output deliverables and produce BI outputs as needed.
  • Responsible for creating weekly and monthly reports for management based on Cognos Data
  • Developed presentations for personnel on Cognos and other business tools as well.
  • SME Focal Point for Business Intelligence Tools, working cross functionally with Global Organizations (IT, Operations, Sales, Finance, Marketing and Promotions, Data Security, Management)
  • Many of Executive, Administrative, & Accounting experience as well as Finance & Data Analysis, Data Manipulation & IT with the Ability to collaborate and work in teams
  • Six Sigma processes with concentration on describing the in - depth process of capturing customer's expectations, preferences and aversions.
  • Best Practices, Processes, Data Integrity, Quality and Governance Driven as well as reporting at Enterprise Global levels
  • Result Oriented/ Driven Data Analysis
  • Project Management / Administration/ Coordination
  • Performed data manipulation, order tracking, inventory and financial forecasting in SAP
  • Produced weekly and monthly reports and maintained various spreadsheets and databases
  • Use SAP to store and track information for scorecards and commissions and built Excel Spreadsheets to match up with SAP data
  • Experience with physical security implementation to include software/hardware solutions
  • Maintenance and Management of ERP systems/ MDM
  • Responsible for the accuracy of ad-hoc and development of reporting, maintenance and Visualization for presentations of stakeholders
  • Reporting, monitoring sales budgets and future forecasts
  • Exercised the use of Oracle/Hyperion Enterprise for financial reporting and analysis
  • Excellent customer / IT support organization and communication skills
  • Methodical with great attention to detail
  • Good interpersonal skills and ability to communicate with both technical and non-technical stakeholders
  • Strong verbal and written communication skills with the ability to explain complex issues in concise terms to a broad range of stakeholders
  • Experienced communication and collaboration skills

TECHNICAL SKILLS

  • MS Office All Suites
  • IR Studio Interactive
  • MS Project 2013
  • MS Visio 92- 2013
  • QuickBooks 2008
  • PeopleSoft Enterprise 8.8
  • JD Edwards Enterprise One
  • AS400 Sales Force
  • Sage Sales Logix 7
  • Sage Peachtree 2009
  • Sage MAS90
  • Express Scribe 4.15
  • Six Sigma
  • Seagate
  • Crystal Reports 7
  • Agile Enterprise /Scrum Master
  • SAP/All levels
  • Tableau
  • Six Sigma Cert
  • SOQL ETL
  • Logistics
  • Kronos
  • Dataloader
  • Callidus
  • Micro-Strategy
  • ODM
  • MS Visio
  • Crystal Reports
  • Oracle Essbase
  • Hyperion Enterprise Concur
  • Force.com
  • Python
  • CRM
  • SharePoint
  • Azerity
  • Business Objects
  • ERP
  • Hummingbird
  • Deal Mgt.
  • BI
  • OBIE- Oracle Business Enterprise
  • Six Sigma
  • ECM
  • Customer Registry
  • FoxPro
  • Sales Account Mgt. View
  • ODS
  • Oracle Enterprise Publisher
  • Data Modeling
  • SSAS/SSRS/SSIS/SAS
  • Bilingual (Spanish)

PROFESSIONAL EXPERIENCE

Confidential, NC

Senior Business Analyst Master

Responsibilities:

  • Understanding Business needs and investigate Sales data Worldwide
  • Governing company, partner and customer Subscriptions
  • Sales Compensation tool and ETL Systems administration along with various other systems
  • Data Governance, Cleanup, Integrity using SQL, Business Objects, MS CRM SFDC, Power BI, etc
  • Maximum analytics of Sales Data of Bookings, Cloud, Services
  • Building Visuals (Scorecards and Dashboards) in Microstrategy and Tableau as well as use of other major Business Intelligence tools
  • Assisting the Program Managers in analyzing, developing, and implementing program enhancements or new programs.
  • Set up of promotion codes for program and promotions as required;
  • Data Quality architecture and processes
  • Onboarding new hires in IAM system determining access levels per requirements of new employees’ organization
  • Major Role in On Demand Learning / SAP Learning Solutions for Certifications (Six Sigma)
  • Data Governance, Quality and Integrity
  • Strong use of data query creation, administration and reporting high level in SFDC / CRM/Oracle/ODM/ETL/ Business Objects/Tableau
  • Smartsheet Project Management
  • Experience with physical security implementation to include software/hardware solutions
  • Analyzing results and helping to create strategies that drive optimization;
  • Meeting with the Program Managers, stakeholders and regions to insure ongoing support and modifications necessary for the business;
  • Understands the business side, technology and analytics with use of tools for output deliverables and produce BI outputs as needed.
  • Built Google Analytics Dashboards in Excel to show the team how to extract their Google Analytics data via their web API and Python helper library so it can be used in other tools such as Excel.
  • Coding with an analytical programming using Python, Django.
  • As Data Strategist ; speak the language of IT and analytics
  • Making data actionable for business leaders.
  • Produce Executive ready slide ware with capability to have the data tell the story
  • Understand data attributes and value.
  • Produces and/or participates in the design and implementation of BI work outputs
  • Responsible for BI story slide-ware
  • Preparing analysis reports on operations or program effectiveness with results and key performance indicators (KPI) on our Registration and TMP programs for the Program Managers;
  • Working with Legal, Tax and other corporate governance organizations to ensure program compliance;
  • Working with marketing and communications to ensure proper content on collateral and websites;
  • Statistical analysis of financial, marketing and health care data and in the production of reports, tables, graphs and listing using SAS
  • Utilized SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting. Involved in the data analysis, DB creation, applying database constraints and make ready to load onto database
  • Assisting in creating and updating an internal webpage for our Incentive programs as well as updating our Cisco documents pages with critical program documents and collateral;
  • Working closely with technical teams to drive productivity and efficiencies through tool development and enhancements;
  • Partnering with regional partner teams and field sales organizations to provide support to partners, gather and take actions on feedback, and assisting in representing partner incentive programs
  • Modified existing SAS programs to load data from the source and create study specific datasets
  • Research / Reconciliations of Accounts reporting monthly, qtrly, yrly closings through SAP Business Objects Interactive, Desktop as well as Webi Designed Queries
  • Tracking renewals of promotions to be updated in our administrative tools
  • Reporting on Teams progression and regressions for determination of further actions

Confidential, Morrisville, NC

Channel Strategy & Operations Analyst

Responsibilities:

  • Strong Microsoft BI, MS Sharepoint, All MS Office Suites in high volume
  • Understanding Business needs and investigate data required
  • Defines architecture required to organize, present data and create proposals built high performance analytical models (multidimensional and tabular) that can be used for interactive data analysis, reporting, and visualization
  • Ensure data consistency, quality and security
  • ODBC database and systems administration
  • Experience with physical security implementation to include software/hardware solutions
  • Microsoft SQL Server administration and maintenance functions of production and QA
  • High Volume use of Oracle Essbase / SPM
  • Callidus Administrator for sales Commissions as well as loading target caps for teams / commissions tracking and reporting
  • BI analytics for SI/ SO/ ROI/SOW
  • Gather Business requirements and document Application design
  • Accounts Payable / Accounts Receivables/ Reconciliations
  • Strong use and administration of SAP/CRM/Business Objects
  • Lead project discovery activities
  • Administrative support provided for Channel Executives i.e travel planning, meetings, calendar management, and travel when needed with Execs as an assistant/coordinator
  • Prepare regular Daily, Weekly, Monthly and quarterly business reports
  • Participate in analysis, testing and implementation of patches and upgrades.
  • Ensure assignments are completed with highest quality and within Service Level Agreements.
  • Support vendor product integrations.
  • SOW- Share of Wallet creation and reporting executive level
  • Data consolidation and analysis for reporting month/yr/qtrly closings
  • MDF, Sales Metrics Reporting Data Governance
  • Trained people in SalesForce
  • Created best business practices

Confidential, Raleigh, NC

Executive Assistant / P.A - Infrastructure Development

Responsibilities:

  • Serve as the technical lead in SharePoint/ Visio and interface with software vendors to get end-user issues resolved where applicable.
  • SharePoint Graphics and Web design administrator keeping sites in order and updated
  • Provide basic development changes to systems using appropriate tools.
  • Present financial information to managers by preparing spreadsheets, graphs, and charts to help illustrate financial trends.
  • Be hands on as necessary in development and modification of reporting (e.g. PSQuery, vVision, Crystal, BI Publisher).
  • Experience with physical security implementation to include software/hardware solutions
  • Data Governance
  • Perform revenue and expense forecasts in order to make financial decisions.
  • Create and review financial records, prepare budgets, expense reporting, payment of invoices, and shipping reports.
  • Strong use and administration of SAP/CRM
  • Guided the team on self-organizing to fill in the intentional gaps left in the Agile/Scrum frameworks
  • Assessing the Scrum Maturity of the team and organization and coaching the team to higher levels of maturity, at a pace that is sustainable and comfortable for the team and organization
  • Removing impediments or guiding the team to remove impediments by finding the right personnel to remove the impediment.
  • Facilitated discussion, decision making, and conflict resolution
  • Assisting with internal and external communication, improving transparency, and radiating information
  • Support in educating the Product Owner, especially with respect to grooming and maintaining the product backlog.
  • Providing all support to the team using a servant leadership style whenever possible, and leading by example
  • Update through testing and rollout of product corrections and enhancements
  • Review technical changes/enhancement specifications used to develop and implement changes alongside of software engineers.

Confidential, NC

Sales Analyst

Responsibilities:

  • Responsible for the accuracy of the sales support; reporting, monitoring sales budgets and forecasts, analyzing quarterly and monthly sales, reviewing and analyzing sales compensation and coordinate and compile sales journals.
  • Work with Business Process Functional Teams, Application Development Teams, and Technology Services Teams as well as the end users, to analyze, design, develop, modify, test, and implement, software solutions and applications to satisfy MSA's business requirements.
  • Responsible for the business and functional requirements development of medium and large scale system development projects.
  • Interact with internal business and operational clients, and outside vendors and internal IT groups.
  • Conduct meetings with identified stakeholders discuss business needs and manage stakeholder expectations as project progresses.
  • Design, Prototyping and other methodologies.
  • Develop test scenarios, scripts and conducting testing effort, including the recording of testing issues.
  • Develop training documents & delivering end user training sessions.
  • Provide post-production support for system issues, including research and follow-up.
  • Assist RFI, RFQ, RFP and contracts development and negotiations alongside of legal attorneys.
  • Convert MS Visio to MS PowerPoint Presentations for conference meetings to show business height updates and activity as well as annual trending.
  • Meet with key end users to determine application development requirements, acting as the liaison between the IT Organization and the end users to insure requirements and progress are communicated accurately.
  • Provide administrative support for the Director of Business Development and key staff members.
  • Responsible for supporting the work of business development, expense reports, account management, and undertaking special assignments as directed.
  • Performed data manipulation, order tracking, and financial forecasting in SAP and Azerity
  • Removing impediments or guiding the team to remove impediments by finding the right personnel to remove the impediment
  • Responsible for supporting the diverse administrative activities of the Wavecom Sales Team, Directors, and VP.
  • Assist financial department with collections of delinquent accounts from clients and distribution companies.
  • Report metrics on a detail or summary level and manipulate the data into meaningful performance measurements.
  • Analyze data with various programs, including Microsoft Excel and Microsoft Access.
  • Produce weekly and monthly reports and maintained various spreadsheets and databases
  • Provide marketing support of tradeshows, client trips, hotel conferences, international company meetings, and magazine publications.
  • Manage all petty cash and office supply expense accounts.
  • Reconcile bank balances and record general ledger entries.
  • Establish customer credit lines and set up credit accounts with clients and distributors.

We'd love your feedback!