PROFESSIONAL SUMMARY

• Business/Data Analyst with more than 10 years of experience leading cross - functional projects programs within multiple sectors, with a specific focus on Data and technology.
• Adept at navigating complex issues utilizing advanced statistical competencies to harness data and drive change.
• Talented communicator, able to strengthen relationships with peers and senior leadership, build consensus, and elicit clear decisions from clients and all levels of stakeholders.
• Requirements Gathering & Analysis User Acceptance Testing (UAT) Waterfall and Agile Methodologies Enterprise Implementations KPI Dashboards
• Data Mining & Analytics BI, ERP & Big Data Platforms SAP/SAS Solutions Write SQL Queries Systems Development Life Cycle (SDLC) General Ledger (GL)
• SQA JIRA Functional Requirements Power Query, Power Pivot and Power BI Scripting & Documentation Regression & Negative Testing API/ETL

TECHNICAL SKILLS

• JIRA
• Oracle
• Azure
• Tableau
• Teradata
• Metadat
• MS SQL Server
• MySQL
• Loan IQ
• Siebel
• Salesforce
• SharePoint
• SAP
• ADP
• MS Office
• MS Word
• MS Excel
• Java Core
• Java Enterprise
• JavaScript
• Python

PROFESSIONAL EXPERIENCE

Confidential, Edison, NJ

Sr. Benefits Data Analyst

Responsibilities:

• Interacted with Technology during BRD, FRD, UAT Testing and Production support stages. Maintained and updated SharePoint platform.
• Managed master data, including creation, updates, and deletion, in PeopleSoft, Truven (IBM), Oracle Database and Salesforces.
• Provide quality assurance of imported data, working with quality assurance analyst if necessary.
• Commissioning and decommissioning of data sets.
• Processing confidential data and information according to guidelines.
• Helping develop reports and analysis.
• Managing and designing the reporting environment, including data sources, security, and metadata.
• Supporting the data warehouse in identifying and revising reporting requirements.
• Supporting initiatives for data integrity and normalization.
• Assessing tests and implementing new or upgraded software and assisting with strategic decisions on new systems.
• Generating reports from single or multiple systems.
• Troubleshooting the reporting database environment and reports.
• Evaluating changes and updates to source production systems.
• Training end users on new reports and dashboards.
• Providing technical expertise on data storage structures, data mining, and data cleansing.
• Supporting the Sales team, qualifying Sales leads on Salesforce. Adding and deactivating users on Salesforce; running the sales report to help forecast.

Confidential, Charlotte, NC

IT Business Analyst

Responsibilities:

• Successful launched large complex Agile project, designing application, architectures and improving business processes for Line of Businesses (LOB) Ownership AML KYC refresh, utilizing comprehensive data sets (client, revenue/cost, underlying accounts and non-revenue client info) through a centralized analytics utility to support AML KYC refresh in Legal Entity Onboarding (LEO) and Loan IQ development.
• Gather requirements from Product Owner, Created Product Backlog, Sprint Backlog and managed (JIRA) User stories in Systems Development Life Cycle (SDLC).
• Utilizing Loan IQ worked with global American and European banks providing solutions for Syndicated Lending Market.
• Responsible for creating the business and/or functional requirements necessary for creating software products that meet customer needs, expected delivery dates, and exceptional quality standards.
• Analysis of new business requirements / strategic road map for client specific enhancements and translation into product-specific designs/ detailed Requirement Definitions/and Use Cases.
• Serve as liaison between the development team, strategic partners or/and the business users.
• Develop use cases, mockup screens, Data Flow Diagrams etc. to explain/demonstrate business requirements/specifications to development team.
• Lead offshore QA teams on understanding the business requirement and prioritizing testing paths.
• Assist Customer Support on L3 issues by providing the workaround and suggesting the solutions.

Confidential, Charlotte, NC

Onboarding Facilitator

Responsibilities:

• Gather evidence of customer profile via documentary or non-documentary means utilizing both in-house and external sources. Initiate the Client Onboarding process by entering data into the client onboarding system and share documents with internal teams such as the Documentation, AML and Credit teams via Loan IQ and Salesforce.
• Via Loan IQ worked with global American and European banks providing solutions for Syndicated Lending Market.
• Evaluate the internal control environment to develop and improve the firm’s controls
• Provide regular updates to Investment Operations senior management
• Collaborate with key constituents, internally and externally, to ensure a globally consistent and tightly controlled environment
• Responsible for delivering high standards of client service while at the same time ensuring that all internal (Risk) and external (Compliance) standards and requirements are fully met.
• Pose solid understanding of the regulatory implications of FATCA, Dodd Frank, EMIR, OFAC, Patriot Act and Finra regulations.

Confidential, Charlotte, NC

Business Analyst

Responsibilities:

• Successfully facilitated Confidential and Merrill Lynch’s Global Ledger Separation-Migration Project.
• Reviewed and provided process improvements via Automation of manual processes.
• Metadata experience: Processed financial master data and comparisons for Finance Data Maintenance Onshore and Offshore.
• Researched and investigation of issues concerning Global Ledger and Reporting Operations.
• Communication and collaboration via answer questions and solving problems for finance community.
• Created and approved new company codes and cost centers for financial community in the Global Ledger.
• Developed and executed tests, test tools, procedures, benchmarks and documentation for new and enhanced products.
• Classified and reported bugs, problems, and enhancements to Development Teams and proposed resolution for some items.

Confidential, Charlotte, NC

Senior Operation Specialist

Responsibilities:

• One of a select group of individuals contributed to Fortigent Acquisition and Migration project.
• Gather business requirements and functional specifications for projects
• Conducted UAT testing for projects and process improvements as needed. Work effectively and efficiently with other business units (internal and external) to resolve transaction and data related issues. Perform quality control reviews.
• Reviewed and validated performance numbers and resolve discrepancies. Troubleshoot performance and data issues. Updated and maintained department procedures. Coordinated and conducted implementation of new tools and processes.
• Answer user inquiries regarding application operation to resolve problems. Provide technical support for software maintenance or use.
• Maintain records of daily data communication transactions, problems and remedial actions taken, or installation activities. Document operational activities.

Confidential, Davidson, NC

HR Support Services Coordinator

Responsibilities:

• Collaborate with HR to create and maintain Workday Roadmap with the intent to extend the value of Workday (functionality, new capabilities)
• Supports HR technology projects or initiatives involving Workday HCMS. Configuration responsibilities may include modifications to business processes, compensation set-up, security configuration, condition rules and notifications, payroll earnings/ deduction codes and reports
• Provide shared service support for various News Corp Companies
• Demonstrate extensive knowledge to troubleshoot and fix Workday related issues
• Provides technical support and responds to all assigned JIRA tickets
• Handle administration and support of existing environment and future upgrades of iCIMS

Confidential, Fort Mill, SC

Payroll Analyst

Responsibilities:

• Worked with various Finance groups, analyzing financial transactions and general ledger.
• Assists Payroll Manager with KPI analysis, testing and special projects as requested.
• Provided support to HRIT by trouble shooting issues, implementing process changes and coordinating user acceptance testing. Administered support to the payroll processing functions. Provided back up support to the payroll tax analyst. Created and maintained custom reports and system queries.
• Administered periodic internal audits of the payroll system to ensure compliance with company policies and pay practices.
• Coordinated and supported external audits. Assists with expatriate tax processing and reconciliation of all expatriate employee taxability records. Assists with SAP payroll/ ADP Enterprise & Total Pay payroll funding and tax submissions.

Confidential, Fort Mill, SC

Specialist Tax Compliance

Responsibilities:

• Identified required data to register clients for tax accounts, collect the necessary power of attorney forms, rate documentation, and register said accounts in compliance with state regulatory requirements in a multi-state environment.
• Administer report, remit tax timely, at the correct tax rate, and upload and balance general ledger, FUTA FICA/SUTA via Master Tax and Black line accounting software systems.

Confidential, Charlotte, NC

Payroll/ Data Analyst

Responsibilities:

• Obtained Secret level security clearance in order to work with classified and protected client information.
• Executed extensive testing and migration of data during period of merger and acquisition.
• Utilized a wide array of software applications to create and design reports and spreadsheets; planned and monitored work production timelines to meet strict deadlines in reporting regulations, prepared department correspondence as needed.
• Managed end to end payroll for 12,000 plus employees, utilizing PeopleSoft 9.1.
• Duties included: balancing and controlling earnings, deduction, 401K and Union totals, calculating and preparing general ledger entries, inspecting automated system output such as registers and standard reports, determining and correcting out-of-balance conditions, preparing and filing tax reports, gathering payroll data for inclusion in financial statements, and researching and preparing special reports for management, calculating military and jury duty pay, and processing garnishments and levies.
• Performed unit, system, migration and integration tests.

Confidential, Charlotte, NC

Human Resource/Data Analyst

Responsibilities:

• Streamlined payroll harmonization, migration project, research, and testing. Point person on Employee Leaves discrepancies in HRIS systems, verified and updated Employee Banking and Tax information. Provided high quality, timely customer support to Managers and Employees in the Americas region.
• Administered and maintained leaves plan in coordination with HR Shared Services, including monitoring volume and workflow of new and ongoing requests for leave. Process employee leave, FMLA, STD/LTD, Military Leave transactions through on-line data entry of leave information in SAP, PeopleSoft and internal leave database; act as a liaison to vendor(s) CIGNA, ADP.

Confidential, Charlotte, NC

WFA Analyst

Responsibilities:

• Oversaw payroll utilizing PeopleSoft, Workday and SAP. Maintain data integrity, employee records, process new hires, rehires, transfers, pay rate changes, 401K, union dues, process of unemployment
• Workers Compensation, Leave of Absence, wage statements, W2 and W2C reprints, W2 and W2C reconciliations, earning statements, I9 processing, social security reporting, subpoenas, child support, garnishments, verification of employment, adoption assistance, also monitored compliance with Federal, State, and Local authorities/agencies.