PROFILE:

• Data Analyst with solid background in Accounting, Finance and Payroll with IT experience.
• Detail - oriented, problem solver with excellent analytical and trouble shooting skills, quick learnerteam player, motivated to learn new skills, working knowledge in various legacy systems.

SYSTEMS PROFICIENT:

Skilled in: MS SQL server, SQL, Cognos11 BI Reporting, Oracle EBS, MS ACCESS

Systems and tools that are proficient include: MS SQL Server 2005 and SQL Server 2008 R2,MSBI,MS Access2000 database, Oracle EBS, Oracle Discoverer query, MS SQL queries, MS SQL DTS packages, ETL, Hyperion Financial Management, Infinium AS/400 G/L legacy system, Confidential Payroll System, Microstrategy 9.0 Reporting, MS Office, Oracle SQL Server queries, COGNOS Analytics

WORK EXPERIENCE:

Data Analyst

Confidential, Alpharetta, GA

Responsibilities:

• Provide varied production data support of mortgage loan data to internal and external clients.
• Load mortgage loan data to production database and send logs to clients.
• Execute loan transfers between mortgage banks. Provide data extracts by running sql queries for internal and external clients.
• Test board mortgage loan data for transferring loans between mortgage banks.
• Assist in QC tasks.
• Provide Cognos production support and assist in monitoring daily Cognos jobs.
• Provide maintenance support for Cognos reports, update report distribution list for clients in Cognos.
• Assist in monitoring Help Desk tickets and provide production support.

Data Analyst

Confidential, Norcross, GA

Responsibilities:

• As an Oracle EBS Analyst provided database support and managed employee payroll data.
• Receive weekly payroll files via FTP from Work Day and load to EBS sub ledger. Validate and balance data before and after data load meeting Sox compliances.
• Validate weekly files to Work Day check registers.
• Trouble shoot kick outs by checking for new pay codes and adding them to table, heavy mapping of new GL accounts in line with complex business rules.
• Post all payroll transactions into EBS and into legacy GL system and communicate to payroll team, meeting deadlines.
• Update new vendors and employees in EBS table, load exchange rates and run monthly jobs in EBS, provide month end data feed files for Data warehouse team.
• Actively participated as a team member in a project migrating Confidential Payroll to Work Day, working closely with consultants and end users.
• Assisted with GL account mapping, deduction and pay code mappings.
• Provide financial data support for corporate reporting, FP&A, Payroll, Accounting, Sales support team, Auditors, Senior Management and various other stake holders.
• Assist in month-end general ledger closing. Perform (ETL) data loads from GL system and refresh data in MS SQL Server and provide data files for Data warehouse, Microstrategy and Hyperion.
• Assisted in producing monthly financial reporting packages for VP of Finance and Accounting, Senior Executive Committee and for Board of Directors using BI tools like Microstrategy and Hyperion. Assisted with data uploads for annual budget preparation and forecasting. Extract data from multiple legacy systems, data upload, refresh various financial data cubes for end users.
• Maintenance of various data tables, publish reports and data files on company intranet.
• Maintain employee headcount table, employee master table, company’s global facility table, GL account mapping tables.
• Extract data to produce daily and weekly sales reports, validate and balance and email them to corporate executives, Sales, Marketing and Finance groups.
• Approve and monitor employee cost center coding change requests in Confidential HR system.
• Extract payroll data files, travel expenses and other financial data for various departments on a weekly and monthly basis.
• Map new general ledger accounts by applying complex business rules to multiple management reporting systems, perform UAT to ensure accurate flow of data for reporting purposes. Other responsibilities include grant user access to financial database, document various data processes.
• Also held position as Senior Accountant and managed payroll database on MS SQL Server.
• Extracted various payroll data files from Confidential Payroll Service database, loaded them into SQL Server tables, balanced weekly payroll, employee payroll deductions, check registers and produced various weekly payroll reports for distribution.
• Team member in Hyperion Financial Management (HFM) implementation project.
• Worked as a team member by providing data extract files from various databases for S1 reporting for SEC Filing during company merger.
• Actively perform process improvements in data processing, analysis and data validation, end user support.

MS Access Database Administrator

Confidential, Roswell, GA

Responsibilities:

• Managed a new database in MS Access for Confidential Fuel Supply Strategic Planning Team. Several reports, queries were created for the users.
• The queries and reports enabled the users to view all the information that is needed in making business decisions.
• Several reports that were done in Excel spreadsheets were automated into MS Access.
• Tables and queries were created by importing csv files into MS Access.
• Managed shipper address database by approving and adding new customers to the database.
• Maintained and updated various address patterns of shipping labels.
• This application allows the shippers to have visibility of all shipments coming to their businesses on a daily basis.
• The application is utilized by businesses to manage their warehouse and inventory more efficiently.

Staff Accountant

Confidential, Norcross, GA

Responsibilities:

• Verified weekly ticket sales report, correct the edit list and made electronic transfer
• Other duties included, monthly G/L closing, produce P&L reports, invoicing, payment posting, vendor payments, bank reconciliations and wire transfers.

Business Analyst

Confidential, Atlanta, GA

Responsibilities:

• Worked as a team member in JD Edwards G/L Accounting System Implementation project.
• Project consisted of automating General Accounting system for two companies.
• Areas covered Included, automating accounts receivables, accounts payable and general ledger.
• Met with department managers and several end-users and closely worked with them to meet their goals and requirements.
• This included training end-users in cash application, payment posting, journal entry posting, trial balances, income statements, balance sheets, allocation and budgeting, month-end closing.
• Developed departmental P&L reports and balance sheets.

Programmer Analyst

Confidential, Atlanta, GA

Responsibilities:

• Responsible for maintaining corporate financial database in MS Access and produced monthly corporate financial reports.
• Automated sales and profit reports for eight subsidiary companies including Mexico and Canada.
• Several reports produced in Excel spreadsheets were migrated into MS Access.
• Eliminated duplication of data entry by directly importing data files from subsidiary companies into corporate MS Access database.
• Several queries, reports and forms were developed for end-users.
• Set up macros to export data files from Access database to Excel and e-mail Access reports to upper management.
• Tools like import and export of data, macro, SQL, Visual Basic functions were utilized.
• Documented all steps and procedures for end-users.

Senior Programmer

Confidential, Atlanta, GA

Responsibilities:

• Developed a system to determine sales contest prize winners for each month for various contests.
• The program was used as a sales tracking system to determine the top salespersons of the month.
• Modified production programs to reflect new sales promotion rules for the sales force.
• Effectively accomplished these responsibilities in a timely fashion.
• Systems used were MVS/COBOL II/COBOL 370/JCL/TSO.
• Actively participated in a project to convert sales contest system from mainframe to Visual Basic application.
• Project included analysis, design and testing of database and programs.
• Participated in developing a new compensation program for branch managers.
• Other duties included creating reports and data files for users, testing new sales contest and compensation programs.