We provide IT Staff Augmentation Services!

Business Analyst Resume

Smyrna, GA

PROFESSIONAL SUMMARY:

Seasoned technology professional with over 20 years blended experience in the areas of reporting, analytics, data analysis, data governance, business analysis, quality assurance, development, consulting, and contracting across many platforms using many tools, programming and applications.

TECHNICAL SKILLS:

  • WorkDay Reporting
  • BrassRing Reporting
  • Success Factor Analytics and Reporting
  • SalesForce.com Reporting
  • Crystal Reports
  • ReportSmith
  • Cognos Report Studio
  • SQL Management Studio / T - SQL
  • Toad / Oracle
  • Tableau (Training)
  • Lawson Enterprise Reporting (Query Builder)
  • Crystal Xcelsius / Dashboard Builder
  • Advanced MS Excel Skills
  • Microsoft Office Business Intelligence Stack

WORK HISTORY SUMMARY:

Confidential, Smyrna, GA

Business Analyst

Responsibilities:

  • Utilize Workday Report Writer to develop Advance and Matrix reports for Core HCM, Recruiting, Payroll, Benefits
  • Create Data Field Mapping Document
  • Create calculated fields as needed for use in reports where field is not currently being utilized
  • Collaborate with stakeholders to refine requirements when converting reports from PeopleSoft to Workday

Tools: Utilized Workday Reportwriter

Applications: Workday, PeopleSoft

Confidential, Appleton, WI

Workday Report Developer

Responsibilities:

  • Utilize Workday Report Writer to develop Advance and Matrix reports for Core HCM, Recruiting, Payroll, Benefits
  • Create Data Field Mapping Document
  • Create calculated fields as needed for use in reports where field is not currently being utilized
  • Collaborate with stakeholders to refine requirements when converting reports from PeopleSoft to Workday

Tools: Utilized: Workday Reportwriter

Applications: Workday, PeopleSoft

Confidential, Portland, OR

Workday Report Developer

Responsibilities:

  • Analyze over 300 reports and determine which if any standard reports can be utilized as is or needed to be developed customized.
  • Create Data Field Mapping Document
  • Utilize Workday Report Writer to develop Advance, Matrix and Composite reports for Core HCM, Recruiting, Onboarding, Talent, Payroll, Benefits, Compensation - Basic, Advanced Compensation, Absence Management & Time Management
  • Create calculated fields as needed for use in reports where field is not currently being utilized
  • Collaborate with stakeholders to refine requirements when converting reports from PeopleSoft to Workday

Tools: Utilized: Workday Reportwriter

Applications: Workday, PeopleSoft

Confidential, Jackson, MS

Workday Report Developer

Responsibilities:

  • Utilize WorkDay Report Writer to develop Advance, Matrix and Composite reports for Benefits, Payroll, Absence Management, Recruiting, and other general HCM reports
  • Create calculated fields as needed for use in reports where field is not currently being utilized
  • Use Jira application track individual tickets for each report from requirement gathering through testing
  • Collaborate with stakeholders to refine requirements when converting reports from Lawson to Workday

Tools: Utilized: Workday Reportwriter

Applications: Workday, Lawson

Confidential, Atlanta, GA

Data Management Analyst

Responsibilities:

  • Provide analytical support by utilizing knowledge of SQL/data management and overall business value.
  • Identify key data, understand data quality, and recognize the origin of data consumption.
  • Keep management apprised of system status by analyzing data quality located within housed data systems, building out data quality rules/thresholds/breaches.
  • Create, design, and reverse engineer reports providing traceable documentation and system/app mapping.

Tools: Utilized: Metadata Hub, Notepad++, Work Front, SQL Management Studio

Applications: Workday, Cognos, Crystal Reports, SAS

Confidential, Atlanta, GA

Data Governance Analyst

Responsibilities:

  • Coordinated the resolution of data integrity gaps by working with the business owners and IT
  • Worked with business partners to gather and understand functional requirements, develop complex queries and provide reports
  • Supported the development of Data Management practices, process and role guides
  • Developed enabling systems, controls and services to support the DMF e.g. Data Dictionary, Metadata Management, Impact Analysis, Data Lineage, Business Use, Rules and Standard of Use
  • Performed special tasks as assigned by Data Governance Stream
  • Developed tool for capturing and generating impact analysis utilizing process, process steps, metadata and definitions for all SAP fields by Tcode and Tables
  • Extracted data from various systems and create normalized flat files for consumption into data warehouse

Tools: Utilized: Excel

Applications: SAP Vendor Master

Confidential, Atlanta, GA

Business Analyst, Quality Analyst

Responsibilities:

  • Extracted, Anticipated, Constrained, Organized, Translated, Safeguarded, Simplified, Verified, and Managed Requirements between business and developers
  • Developed test plans, test cases, test scripts and test reports on multiple projects of varying size
  • Validated that user expectations are achieved during the testing process

Tools: Utilized: SQL Developer, Pentaho CTools, Excel, Google Sheets, Word, Google Docs

Applications: Pentaho Dashboard Data

Confidential, Atlanta, GA

Business Analyst, Quality Analyst, Technical Writer

Responsibilities:

  • Troubleshoot technical issues related to data transformation and flow
  • Analyzed customer data specifications and provide gap analysis
  • Created documentation for future reference, training and support purposes
  • Provided customers or internal teams with support on technical integration issues. Assist others in development
  • Communicated with customers to clarify data format requirements
  • Examined and evaluated purpose and content of business reports to develop new, or improve existing format, use, and control: Review reports to determine basic characteristics, such as origin and report flow, format, frequency, distribution and purpose or function of report
  • Conferred with persons originating, handling, processing, or receiving reports to identify problems and to gather suggestions for improvements
  • Documented technical definitions of critical reports in legacy systems (Pivotal & Salesforce.com) to prepare for redevelopment in Workday and Salesforce.com (upgrade)
  • Validated addresses from legacy systems and standardize for importing into Workday

Tools: Utilized: Advanced Excel

Applications: Workday, Salesforce.com, Pivotal, Great Plains

Confidential

Business Analyst

Responsibilities:

  • Supported the business of HR by providing access to data intelligence for proper decision making using WorkDay Reporting.
  • Developed WorkDay Dashboard solutions for data visualization and statistical analysis
  • Leveraged the enterprise DW and HRIS/HCM/ERP as primary tools for HR dashboard, reporting and analytics
  • Mentored and provided training to end-users on developing WorkDay Reports and Success Factors Analytics
  • Contributed with analysis to advance processes improvement projects and initiatives
  • Utilized advanced Success Factors analytical tool and WorkDay Dashboards to provide data driven analysis and recommendations for managing client's human capital
  • Performed analysis to identify data ownership, along with data production and consumption
  • Performed analysis to profile the data, identifying and documenting patterns of errors, and provide recommendations for corrections within the WorkDay system
  • Provided support to create data quality checkpoints and internal audit processes
  • Helped establish metrics to steer Workday data quality initiatives
  • Analyzed, design, develop, and integrate and/or manipulate standard and ad hoc WorkDay reports
  • Collaborated on the preparation of WorkDay reports and data extraction to support the department
  • Maintained and ensured the integrity and accuracy of the WorkDay HCM database information. Generate advanced queries and reports needed by all levels of management providing metrics, trends and benchmarking data
  • Utilized advanced Excel skills to merge data from various systems into one system and present as a single report and/or scorecard
  • Produced and interpreted monthly HR Operations Metric Scorecard using extracted data from WorkDay, Success Factors, combined using heavy manipulations in excel and presented in PowerPoint
  • Communicated effectively, both verbally and in writing; to establish and maintain effective business relationships
  • Created standards for Service Level Agreements (SLAs) and updated in Salesforce.com for reporting and dashboards.
  • Partner with stakeholders (internal/external to HR) to understand new report/data requirements and ensures results meet the business needs within Workday
  • Create and maintain report catalog to enable end users to get needed reports from Workday
  • Educate and promote self-service reporting functionality with end users by utilizing various communication and training methodologies
  • Actively participate in Workday Community by contributing to content, voting on Brainstorms, etc.

Tools: Utilized: Workday Reporting, Success Factors Online Reporting and Analytic Tool, BrassRing Reporting Tool, Salesforce.com Reporting, Excel, Excel Macros, PowerPoint, Word

Applications: Workday, Success Factors, BrassRing, Salesforce.com

Confidential, Atlanta, GA

Business Analyst, Reporting Engineer, Quality Analyst, Trainer, Owner

Responsibilities:

  • Develop and implement plans for improving business intelligence
  • Extract, anticipate, constrain, organize, translate, safeguard, simplify, verify, and manage requirements between business and developers (often myself)
  • Work with stakeholders to define business KPI’s and develop semantic layers in the BI tool to support these KPIs
  • Manage the reporting and analytics platform(s) to ensure that scheduled jobs are successfully run and analytics data aligns to timeliness / completeness requirements
  • Work with DBAs to ensure that databases feeding the reporting platforms are tuned for optimal performance
  • Examine and evaluate purpose and content of business reports to develop new, or improve existing format, use, and control: Review reports to determine basic characteristics, such as origin and report flow, format, frequency, distribution and purpose or function of report.
  • Confer with persons originating, handling, processing, or receiving reports to identify problems and to gather suggestions for improvements
  • Recommend establishment of new or modified reporting methods and procedures to improve report content and completeness of information
  • Prepare and issue instructions concerning generation, completion, and distribution of reports according to new or revised practices, procedures, or policies of reports management
  • Organize teams of developers to meet required milestones and project deadline
  • Develop Data Dictionary for databases to enable users to quickly determine tables needed to create reports
  • Model data using the Star Schema to design databases holding data from various data sources to include SQL, Excel, Access and others into a single source of the truth.
  • Convert and/or develop reports which return data as seen in legacy systems using different technology or systems
  • Troubleshoot existing Stored Procedures and Views for issues related to data quality (missing or duplicated data as well as inaccurate calculations)
  • Travel to client sites to give on-site training to clients using their live data thus giving the client the opportunity to explore, view and analyze real reports
  • Training sessions/workshops were geared towards ensuring the clients thorough understanding of product.
  • Training on Basic, Intermediate or Advanced Levels
  • Custom Technical Training Manuals were created for each class
  • Analyze report data against data source to ensure accuracy
  • Create Financial Reports (P&L Statements, Sales & Transactions) for Quarterly and Annual Reporting

Tools: Utilized: ReportSmith, Crystal Reports, Lawson Query Builder, SQL Server, Oracle, MS Office Suite, SQL Management Studio, Custom & Proprietary

Applications: ADP, Lawson (HCM & Financial), PeopleSoft, Ultipro

Hire Now