SUMMARY:

• Data Analyst with over 10 years in finance domain, offering professional expertise in providing analytical, organizational and managerial support for diverse business projects.
• SQL Server Platform, Dreamweaver, VBA, Visual Studio 2010, Lawson and MS Office (Excel, Access, PowerPoint, Project, Word)
• Accounts Payable, Accounts Receivable and Data Analyst professional.
• Gathering business data requirements, documentation for reporting requirements and presentation, educating, supporting end - user reporting needs using Business Objects
• Interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable
• Experienced with staff training and mentoring team members with product knowledge and business processes.
• Data Conversion, User End Testing and Analysis Skills to support business needs
• Great communication, problem solving, result oriented, outstanding interpersonal, teamwork and organization skills
• Self-motivated, fast learner, detail oriented with attention to accuracy

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Business Data Analyst II

Responsibilities:

• Analyze user and system data failures including automation and manual business processes; created efficiency and process improvements with existing VBA scripts and macros to format data; cut processing time by 90%
• Collaborate with various teams including compliance, implementation and IT; ensure critical data is captured, analytic needs are well-defined upfront, and development timelines are coordinated with analytic needs
• Assist in database development and warehousing designs across single, multiple platforms & computing environments
• Examine validating documents for the CIP Compliance process to support the Anti Money Laundering programs; reduced fraud related accounts & ensured government regulation compliance
• Extract data, prepare reports, analyze data, develop recommendations and validate clients’ data; enable META and BANA Banks, to analyze compliant accounts for remediation purposes.
• Develop recommendations according to guidelines on accounts that have compliance issues to include: exemption for remediation, client providing validating documents for exclusion and reformatting billing addresses; reduced processing time by 80% and improve client satisfaction
• Design training documentation and cross trained employees on critical skills to include multitasking; improved efficiency and standard operating procedures
• Develop and maintain VB Scripts, Macros, create MS Access and MS Excel reports; propelled the improvement and creation of new scripts replacing the manual processes; reduced man hours and increased efficiency by 95%
• Collaborated on the design, test and review process of existing data and program quality; validated data integrity and improved the data validation processes
• Evaluate and develop special project solutions within specified timelines; ensures projects are completed by due date
• Facilitate weekly meetings with managers and staff; inspires collaborative problem resolution on Issues related to the remediation processes

Confidential, Kennesaw, GA

Data Analyst/Senior Accounts Payable/Inventory Control Specialist

• Extracted, loaded and validated clients invoice data to ensure there are no errors in payment made.
• Matched invoices to purchase orders and reconciled statements monthly.
• Responded to P&L questions and resolved unreconciled or unpaid invoice issues.
• Managed over 60 assigned vendor’s accounts.
• Manipulated, cleansed and processed 100% of Accounts Payable data using MS Excel and MS Access to provide team members with unreconciled invoice data that needs resolution.
• Prepared reports used for daily payment authorizations, receipts and identify potential errors to avoid paying the vendors for items not received.
• Analyzed data and developed recommendations on how to resolve issues which saves management 60% of decision making time.
• Created test data and performed user end to ensure quality performance of Lawson system before live production is released.
• Created and updated user guide for LAWSON processes to give technical assistance to users
• Provided 100% quality check and audit function on items defined by operating procedures to ensure team members are performing their functions correctly.
• Processed over 500 invoices daily through EDI (Electronic Data Interchange) and ensured invoices are paid in a timely manner in other take advantage of discount offered by vendors
• Monitored data for 100% accuracy, ensured appropriate standard coding and routing rules are applied to each invoice; to avoid misclassification of expenses.
• Participated in weekly meetings with managers, staff and interacted with end-users and vendors to discuss and resolve ongoing problems department problems relating to accounts payable.
• Trained staff members on assigned job functions to increase productivity and job satisfaction.

Confidential, Kennesaw GA

Credit Analyst

• Assisted all credit card customers with 100% loyalty, and respect, through inbound and outbound calls, responding to emails and letter correspondents to resolve any credit application issues.
• Processed over 200 credit card applications daily using all three major credit bureaus to validate applicant’s information.
• Processed over 100 payments over the phone daily and updated customer account information.
• Transferred misapplied payments to correct accounts and re-aged accounts accordingly
• Audited and reconciled all errors with credit card accounts.