SUMMARY

• Over 10 years of Business Intelligence (Microstrategy, Power BI, Tableau, QlikView/Sense, CRM Salesforce) Components & Tools. Development, analytics, modeling programming in all tools
• Hands - on development of dynamic dashboards, grids, graphs, scorecards, and statistical reporting utilizing Business Intelligence Tools
• Prepare and maintain various detailed records, documentation and reports in order to provide information summaries, presentations, and ad hoc reporting
• Proficient in Business Intelligence architecture, dashboard, and report development including objects, filters, prompts and metrics
• Document designs, specifications, and flow diagrams to assist in efficient development, support, and problem analysis
• Create and enhance report objects, metrics, filters, and prompts
• Develop dashboards and reports per specified requirements and timelines
• Develop, execute, and document test plans for development activities
• Validate reporting results against requirements, and troubleshoot and analyze data issues within reports
• Support and manage special projects, ad-hoc management reporting requests, testing, and issue resolution
• Ensure optimal end-user performance by establishing and consistently executing overall system performance assessment processes and associated action plans
• Development and integration including setting up configuration management, developing components, peer review, creating unit test plans, and performing unit testing
• Experience with intelligent cube development, custom widget, visualization development and implementation
• Understanding of relational databases, strong SQL skills, and experience with data modeling and BI architecture"
• Strong involvement with Finance Teams and global Sales Organization
• 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.
• Ability to work both independently and collaboratively
• Experienced communication and collaboration skills
• Ability to collaborate and work in teams
• Technical knowledge regarding data models, data flow diagrams and database design development
• Escalates issues / risks in a timely manner.
• Proficient troubleshooting and problem-solving skills
• Excellent verbal and written communication skills

TECHNICAL SKILLS

• MS Office All Suites. (365 etc)
• QlikView/Sense
• IR Studio Interactive.
• MS Visio .
• PeopleSoft.
• Alteryx
• Microstrategy
• Power BI
• Sales Force CRM
• SAP Business Objects
• Tableau
• Callidus
• Anaplan
• Xcelcius
• Logistics.
• Workday
• Crystal Reports
• Hyperion Enterprise.
• ERP.
• Microsoft Dynamics
• SSIS/SSAS/SSRS
• IAM
• Copaq
• PL/SQL
• MSSQL
• Redshift
• MS Azure
• EDW
• Qlikview/Sense

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Analyst / BI Engineer

Responsibilities:

• Work closely with the Oracle data warehouse team
• Responsible for supporting existing analytical applications, as well as designing and developing dashboards for internal customers.
• Tableau Server administration, BI dev and engineering
• Managing, monitoring, and analyzing incoming incident, change, and service support requests within Tableau.
• Developing Business Intelligence reports and dashboards, defining and documenting Unit, Quality Assurance, and Integration analytical test cases.
• Travel across the US and Canada
• Sharepoint and MS Visio admin
• Root Cause analysis (at times using Six Sigma process)
• ETL with Oracle, SQL, SSIS, SSRS, SAP, BUSINESS OBJECTS
• Gathering business requirements
• Project Management
• Access AD Management
• Stakeholder meetings for next steps
• Voice of Customer collection
• Work as a liaison between business clients and IT
• Translate high-level business requirements on multiple, complex requests into detailed functional and system specifications.
• Work with data management team and data providers to communicate and define any data and reporting requirements.
• Manage stakeholder relationships and change management requests.
• Provide assistance and guidance during the development and testing phases to ensure that test cases are accurate, and quickly confirm the validity of potential issues.
• Create project plans, track and communicate project status, and escalate to business clients, technology management, and development team leads any key risks.
• Prepare project status reports by collecting, analyzing, and summarizing information and trends; making decisions and recommending actions.
• Prepare justification documentation for management level approval.
• Lead and participate in formal/informal design reviews.
• Train and support business key users and end users.
• Perform other duties as assigned.

Confidential

BI Developer/ Data Engineer

Responsibilities:

• Microstrategy main focus
• Strong Use of Business Intelligence (Microstrategy, Tableau, QlikView, Power BI) Components & Tools.
• Hands-on development of dynamic dashboards, grids, graphs, scorecards, and statistical reporting utilizing Business Intelligence Tools
• Proficient in Business Intelligence architecture, dashboard, and report development including objects, filters, prompts and metrics
• Document designs, specifications, and flow diagrams to assist in efficient development, support, and problem analysis
• Hi Volume Data Quality of Teradata/SQL and external data sources
• Create and enhance report objects, metrics, filters, and prompts
• Develop dashboards and reports per specified requirements and timelines
• Develop, execute, and document test plans for development activities
• Validate reporting results against requirements, and troubleshoot and analyze data issues within reports
• Support and manage special projects, ad-hoc management reporting requests, testing, and issue resolution
• Ensure optimal end-user performance by establishing and consistently executing overall system performance assessment processes and associated action plans
• Development and integration including setting up configuration management, developing components, peer review, creating unit test plans, and performing unit testing
• Experience with intelligent cube development, custom widget, visualization development and implementation
• Understanding of relational databases, strong SQL skills, and experience with data modeling and architecture"
• Strong use BI systems, and/or concepts with analytic tools, i.e MicroStrategy, Birst, Power BI, QlikView/Sense, Tableau etc.
• Data analysis, correlation, and actionable report design/Visual development
• Designing visual interface for data interactions, based on business requirements
• Using appropriate visualization techniques based on the data set for functional analysis of sales, financial, import, export, and inventory data.
• Translating business requirements into technical solutions
• Prepared analysis reports on operations or program effectiveness with results and key performance indicators (KPI) on our Registration and TMP programs for the Program Managers;
• Research / Reconciliations of Accounts reporting monthly, qtrly, yrly closings through SAP Business Objects Interactive, Desktop as well as Webi Designed Queries
• Heavy BPM (Business Process Management) Agile / Six Sigma Methodologies
• Worked closely with technical teams to drive productivity and efficiencies through tool development and enhancements.
• Operations research, economics, finance, sales analysis, BI programming and development
• Master Data Mgt
• Problem Solving >Define, Measure, Analyzing, Improving, Control (SIX SIGMA)
• Make sense of large datasets
• Works closely throughout organization> Cross-functional in technical and “run the business”

Confidential, NC

Sr. Business Data Analyst- MDM

Responsibilities:

• Assisted the program managers in analyzing, developing and implementing program enhancements or new programs. Set up of promotion codes for program and promotions as required.
• Prepared analysis reports on operations or program effectiveness with results and key.
• Strong use of data query creation, administration and reporting high level in CRM/CRM Salesforce/SAP/Business Objects, Power BI / Business Intelligence, E-Genie, Iprocurement, Customer Registry Admin, SAVM, MBR, IB, EDW, EDS, DISE, Contracts tool, etc many more Cisco intra tools, IAM, Citrix, Tableau, Business Objects Superuser Deski, Xcelcius Dashboards, SmartSheet, CSSO, SQL query writing, Rebok, Smartsheet, EPromo, PSPP, MBR etc
• Global Channel Partner and Global Sales Organization in all markets
• Administration / development, visualization in Power BI (different organizations call for different BI tools)
• Stayed abreast of new Salesforce features and functionalities using my knowledge to provide recommendations for process improvements
• Worked on Salesforce accounts, leads, and contacts enrichment initiatives, data cleanup for accouints, contacts and leads
• Deduping and adding new accounts with cleansing with updated addresses
• Build and ran reports for Sr. Management and built presentations based on the SFDC data and worked with reps as well.
• Developed, modified, distributed standard and adhoc management reports/dashboards to better understand the overall business/unit
• Determined Sales territories, giving access and keeping up with access and securities for Sales organizations
• Salesforce Analysis of all data, modeling, creating complex metrics, reporting, and dashboards on a worldwide level
• Managed multiple medium complexity HR and/or Finance projects, including interviewing partner areas, business users, business SME’s and IT to further refine system effectiveness
• Understanding Business needs and investigate data required
• Aided in the design, Development, Migration, Customizations, Enhancement and Implementation of Compensation plans
• Oracle PL/SQL & Crystal Reporting
• Created Reports from Multiple sources & functionals i.e slice & dice, drill down in Crystal reports
• Used my knowledge of Data warehouse Concepts including schemas and data Modeling
• Heavy Incentive Compensation Management using Callidus/Cloud/ On-Premise/ On Demand Model
• Analyzing results and helping to create strategies that drive optimization;
• Meeting with the Managers, stakeholders and regions to insure ongoing support and modifications necessary for the business;
• Payment / compensation reconciliation for over 70K employees
• Understands the functional, technical and analytics with use of tools for output deliverables and produce BI Querying and outputs as needed.

Confidential

Channel Strategy and Operations Sales Analyst

Responsibilities:

• Understood business needs and investigate data required.
• Scorecarding in Tableau and Salesforce
• Defined architecture required to organize, present data and created proposals built high performance analytical models (multidimensional and tabular) that can be used for interactive data analysis, reporting and visualization.
• Setup New Employee Hires, interviewed prospective hires, Benefits, Commissions, Personal Details, Salary Changes as well as expense reporting and analytics in Workday HR system
• Ensured data consistency, quality and security ODBC database and strong Microsoft BI, MS SharePoint, All MS Office Suites in high volume
• Performed complex research and analysis from a variety of sources which included operational data, metrics in CRM Salesforce as well as feedback from partners and leadership.
• Analyzed information to identify trends, patterns, gaps and insights using descriptive analysis
• Microsoft SQL Server administration and maintenance functions of production and QA.
• High Volume use of Workday, Oracle Essbase/SPM. Callidus Administrator for sales commissions as well as loading target caps for teams/commissions tracking and reporting.
• Gathered business requirements and documented application design. Accounts payable/accounts receivables/reconciliations.
• Conducted assessment, opportunity, assessment, lead assessment, cost/benefit analysis, feasibility etc
• Strong use and administration of Workday as an HR Strategist SAP/CRM Salesforce/business objects.
• Lead project discovery activities. Prepared regular daily, weekly, monthly and quarterly business reports.
• Participated in analysis, testing and implementation of patches and upgrades.

Confidential, Raleigh, NC

Sales Support Analyst

Responsibilities:

• Lead audit team and generated audit reports.
• Presented audit information effectively and responded to questions from groups of internal customers.
• Created sales reports for products and services and performed other related duties as assigned.
• Extracted financial and other data from diverse systems and applications such as PRMS, Vista, Metrix, QAD and Synergy and ERP systems.
• Obtained detailed understanding of business functionality and took the responsibility of preparing the functionality test plan which was used by testing team while doing their testing process.
• Prepared integration test plan which was used by functional team as well as development team for doing a detailed testing on the business application.
• Consolidated and summarized data into management reports and created flow charts for the company.
• Exercised the use of Oracle/Hyperion Enterprise for financial reporting and analysis.
• Ran reports and kept up on numbers in Excel correcting ranges and values at closings using VLookup.
• Scheduled manpower allocations and workloads, scheduled service delivery.
• Responsible for all activities in accounts payable and receivable. Ensured timely payments of vendor invoices.
• Assisted on completion and maintenance of general ledgers. Negotiated past due accounts.
• Delivered results to appropriate finance and product management employees for review and payment.
• Served as Point of Contact for commission inquiries from sales partners, investigates issues and implement corrective actions to resolve/prevent issues from reoccurring.