Post Job Free

Resume

Sign in

Sql Server Data Analyst

Location:
Johns Creek, GA
Posted:
September 02, 2023

Contact this candidate

Resume:

adzffs@r.postjobfree.com / 404-***-****

Adept Manager. Impeccable work ethic. Self-motivated. Great attitude. Agilist.

EDUCATION

TECHNICAL SKILLS

MBA, University of Hartford Business School, Connecticut

Master of Science, Petroleum Engineering, University of Southern California (USC)

Tableau, Alteryx, SQL Server Data Architect, SQL Server, AWS Redshift Data warehouse, Adobe Analytics Reporting, Analytics, Access, Excel, SQL Data Warehouse, Data manipulation, Python

Data Governance, Quantitative & Qualitative, KPIs.

SQL Data Analysis: SQL using SQL Analyzer Or Coginiti Editor

Agile Scrum Methodology: Jira

AWS Technologies: ec2, Redshift, RDS

ETL Data Prep with Alteryx

Edureka Certified Tableau DeskTop Associate

PROFESSIONAL EXPERIENCE

06/2022 to 06/2023 Digital Marketing Data Lead - Fleetcor Technologies (North American Fuels Div)

oEngaging Stakeholders including Directors of Digital Marketing, on Process of Customer Data Journey from Lead Source to Client Conversion to Refining Target Audience For Client Acquisition.

oPreparing Monthly Campaign Starts Revenue and Quarterly Revenue Vs Goal on Tableau / Excel Pivot Tables

oSalesforce Lightning Report Generation on Converted Leads /Opportunities and Accounts By Dispositions

oDeveloping Data Queries for Extraction and Computing Metrics on Digital Campaign Performance Prior to and after Marketing Campaigns .

oData Architect for Sales Prospect Data Warehouse. Perform Entity Relationship Diagram Models for Dimensions and Facts for the Prospects /Leads.

oExtract, Transform, Load Process Models for different Data Sources using Alteryx into the Staging Database and then Production Data warehouse

oData Driven Strategies to Improve Conversion Rates on Digital Channel Funnels

oManaging KPI from Earned Media on PR based on Organic Social Media using Tableau /Excel Charts

oMonthly Revenue Forecast Reporting from Various Sales Channels

oAnalytic Revenue Reports on Leads Conversion to Accounts using Tableau

oYear TO Date and Quarterly Sales Revenue Reports from Inbound Digital / Direct Marketing Channels

oEngaging Data Marketing Team with Data Point Enhancement from Various Data Sources to Enhance Market Target on Digital Inbound Sales Channel

oUsing Python on for File Sorting and Data Transformation Prior to loading to Staging Serve

oEstablish Functional and Physical Business Requirements from Stakeholders Prior to Preparing Data Integrity Guideline Prior to Appended Enriched Data to the Sale Force Database Platform using Alteryx

oExtracting and Transforming various Lead data sources and Loading to AWS DataLake, Preforming Queries in line with Business Requirements and then using Alteryx to load to various Output formats including Tableau, Excel and Oracle

oDeveloping Analytic Reports on Starts Revenue Comparing Inbound Revenue Channels with Outbound Sales using Excel Pivot Charts and Tableau

oMeasuring Variation Metrics in Opportunity Sales based on Outbound Marketing Sales Vs Non Paid

Inbound Sales Channels

05/2021 to 05/22 Senior Data Analytics Consultant -Chik-fill-A /Thompson technologies

Atlanta GA

oDeveloping SQL queries representing business requirements gathering for data validity /integration into Data Warehouse and Source for Business Analytics

oProviding Data Analytics Reports on Tableau for COGS (Cost of Goods Sold)trends for Restaurant Inventory by Suppliers, Distributors and Quarterly Business Review Reports

oData Integration from MySQL Tables into Amazon Redshift using AWS Data Pipeline Templates

oCreating Dashboards on Tableau to measure Performance Metrics for Suppliers/ Distributors and Restaurants

oDeveloping Datawarehouse for Monitoring Traceability Metrics Analytics for supply chain management,

oData Archiving and retrieval for History Matching and Forecasting the future enables the Business Improve Quality and Transformation needed in the Supply chain to make a positive Impact on the Profitability of Chik-Fil-A QSR (Quick Service Restaurant)

oDeveloping automated Alteryx workflows for ETL process, transformation and eventual load into Data Warehouse

oUpdating Alteryx Transformation and Data Prep tools in workflows to identify nonconformity in Data to Business Process

oFacilitating meeting with Stakeholders including Business, Technical Stewards and Asset Manager on Data Lineage Control process in Compliance with the Data Governance Requirements of the Organization

oTranslating Business Requirements for Upload, Prepping and Load Master Data Files into AWS Redshift tables using SQL Queries

oEnsuring Data Governance Policies are enshrined by Technical and Business Stewards by Cataloging Pertinent Datasets in Conformity with Business Rules, Policies, Regulations and Security

oDeveloping Strategy for ETL Mater Data File Movement with Python Tool on Alteryx

oMonitoring Warehouse Inventory Feasibility and Reconciliation with third Party Data Provider by Prepping and Scrubbing Data on Alteryx Tools

oPerforming Analytics on Restaurant Profitability and ROI on Menu Input Items with Ontime Menu Input Performance Impact Monitoring using Tableau

11/2019 to 12/2020 Senior Business Analyst Data analytics - 03 Cards

oProviding Business Analytics Insights in our client’s company operations with goal of identifying areas to reduce OPEX Costs and thereby Improve profitability

oProviding Analytics Reports on Merchant Utilization of E-platform solution Products to be able to assist on Cash Back Programs and Discounts

oUsing SQL Queries to represent Business Requirements and Performing User Acceptance Testing

oCreating waterfall Charts for Profit Margins and Sales Map Dashboards on Tableau

oUsing Alteryx for Data Consolidation, Mapping and Transformation and then Load to Stage Database

oEnhancing Business Process Roadmap by interacting with Stake holders to get Business Requirement Documentation to establish effective Use cases for Asset management Reporting Platform

oMeeting with Development Team to Establish the Product Backlog for Sprint Release

oAutomating Alteryx workflows on Consumer Cashback Datasets to filter Most and underperforming customers

oOrganizing Stakeholder meetings on Data Asset Protection and Regulations for Customer Personal Data

In conformance with Data Governance Guidelines

oData Integration from s3 Buckets into MySQL Tables using AWS Pipelines

oConnecting Tableau Analytics reporting to Excel Data Sets for Dashboard Reports

oDeveloping SQL Queries for Data Extract from SQL Server as Per Business Requirements

oData Migrating and on boarding into s3 Buckets in AWS Cloud Architecture for Redshift Datawarehouse

oData Consolidation and Cleansing as per Business Requirements using Alteryx

10/2018 to 04/2019 Senior Business Systems Analyst - Koch Business Solutions / The Judge Group

I managed analytical reports used by senior leadership to drive day-to-day and optimize long-term business decisions.

oProviding Business Use Cases for Updating the MYHR Report Analytics for Optimization on Human Resource Relationship between Employee and Supervisor by Measuring Metrics Like Staff Retention / Turnover, Vacation Time Utilization using Report Rendering Dashboards on Tableau with the Ultimate Goal of enabling Senior Management make decisions to improve Employee Performance

oFacilitating Data Loads, Consolidation and Mapping Using SQL Server SSIS

oProviding Business Requirement Documentation for User Views and Navigation based on Talent Hierarchy Application for Tableau Dashboard Reports.

oData Integration from s3 Bucket into Redshift Data Warehouse using AWS Pipeline Services

oUsing Alteryx Workflow for Data Prep and consolidation prior to Update to Data Mart on AWS Redshift

oUsing In-DB Tools in Alteryx to Consolidate and Validate Data on Workflows from different Data Sources prior to output in Stage Database

oEnsuring Data Standards are my for-Privacy Requirements on New Hire Interview Process and Credit

Validation Metrix using third Party Tool

oInteraction with Data Stewards and Product Owners to encapsulate Security framework for Data Uploads from third Party Sources, when scrubbing Data for Supply Chain analytics Reporting

oEnsuring Metadata Access for Data Uploads Conforms with Privacy, Legal Requirements as stipulated by the Data Stewards or Center of Excellence

oUpdating Business Requirement Documents with Clarifications based on input from Developers on the MyTime GP Application and Grooming Backlog Stories in Conformity with Accepted Clarifications by User

oProviding Business Process Roadmap in Estimating Tableau board Metrics (Calculated Fields) for Measures like Number of Days in Response Time from Supervisors for Employee Request to change Timecard Edits, Meal Break Exceptions e.tc with the Ultimate Goal of Improving behavioral relationship between Employees and Supervisors

oDesign UML Modelling on Business Process for myGP application on Supervisor /Subordinate Behavior

oEstablishing Requirements for SQL Queries and Stored Procedures Using Alteryx for Data Load to AWS Platform S3 Buckets and Other Data Formats for Human Resource Report Analytics on Tableaux

oForecasting Models on Tableau for future Resource Hires and Retention Ratio

oProviding Trend Reports and Forecast reports for Talent Hire and retention using Tableau Charts

oReporting with Tableau Data Lakes on AWS Platform with AWS Redshift for HR Analytic Reports and Dashboards on Tableau

06/2018 to 10/2018 Senior Data Analytics

- Equifax / Robert Half, Atlanta, GA

For Equifax, a credit monitoring/financial agency with multiple data asset channels, I managed reporting and analytics to improve the data governance program with streamlined process and system automation.

oMonitoring Completed Data Ask Reviews for Enterprise Data Council on archer PMO Platform

oData Assets Sales Forecast Dashboard on Power BI

oRequest Processing Tool and Using them in Sprint meetings, Providing Back log Burn Rate and Other Business Trend Metrics using PowerBI Reports

oUsing Alteryx In-DB tool to Migrate Data from different sources to be stored on the PMO Platform Application

oEnsuring Data Governance by Validating Privacy Requirements are Followed for DATA ASKs by Consulting with SMES

oProviding Business Workflows for Data Access while ensuring GDPR (General Data Protection Act) with regards to Consumer Data Privacy

oEnsuring Metadata of Master Database Supporting the ASK Data Project Monitoring Software is Stable and Effective for Data Transfer while ensuring Privacy and Regulatory requirements are met

oMonitored Completed Data Ask Reviews for Enterprise Data Council using Tableau

oPerformed UI Business process modelling and mapping for New Version AskData application

oPerformed Requirements Gathering from SME (Subject Matter Experts) in Privacy, Compliance and Security ARMS of Enterprise Data Governance, Consolidating from Various Data Formats using Alteryx and Storing Data in SQL Server

oUsed Tableau to Provide Chart Visualization on Performance Metris Like Data Requests Turnover, Data Asset Revenue e.tc.

oUML Business Processing for Customer Value on New Data Request App on third Party Applications

oProvide Report Dash board from Big Data Lakes on AWS Redshift using PowerBI

oKPI monitoring of Business Units from Tableau Dashboard Reports using Score Chart Visualizations

oConsolidation and Power Query Transformation of Measures (Count of Asks, Asset Value) which are then pulled in Power BI Plat form for Rendering as Bar Charts of Number of Data Request by Units e.tc

oProvided Alignment in User Stories from Customer Requests with Acceptance Criteria to effectively Communicated with SCRUM team and Program Manager by effectively grooming Story Backlogs and committing to releasable product increment with Development team within the Sprint timeframe

oParticipated in backlog remediation sessions during Scrum Sprints to refine user stories

oData Consolidation and modeling from Various Data Sources including SQL Server, Excel and Access Database Using Alteryx, indexing SQL queries for better Data Retrieval, Data transfer from SQL, Access and Excel into Central Tableau analytic Reporting Platform

oCreated Indexed Views, Stored Procedures and Functions

oFacilitated effective development Process for Optimum return on Investment for Customer and Product Sponsor Requests by interacting in Sprint Review with Program Managers and other stakeholders to ensure the goals are attained for each Iteration of Sprint

oAgile Project Management on Development of Custom Application (AskData) on Archer Application that builds on common USE CASES which require Business Requirements on Requests for Data Assets of Equifax by ensuring they Comply with Privacy, Legal, Security and General Data Governance Regulations

oUsed JIRA as Project Management Tool to Prioritize User Stories on Scope for Intended Sprint and also Managed the Workflow from ToDo Tasks to Done for a Particular Release in Application Increment for Automation of Data Ask Requests from Users and Approval by Data Advisors

06/2016 to 05/2018 Senior Business Data Analyst -Knights & Associates, Atlanta, GA

For this company that provides concrete embankments for side works and other related construction, I developed reports, gathered requirements and performed in-depth analytics utilizing Tableau and writing & running SQL complex queries.

Created Dashboards on SQL Reporting based on SQL Server Data Warehouses having Consolidated Data

Created Queries in MS Access based on Business requirements for Reporting

Designed Data Visualization of Pie Charts of Vendors By Region, Budgeted Expense Vas Real Expense on Bar and Pie Charts on Tableau

SQL Datamart for Data Source on Profitability Contribution Charts using Tableau.

Performing Left Outer Joins on data sources to provide Sales Water Fall Charts on Tableau

Providing Stacked Bar and Pie charts on Regional Sales Compared to Products we Provide

Consolidation and Query of Data Sources on Power Query, then Rendering Reports on PowerBI

Performed VLOOKUPS, FUNCTIONS, PIVOTABLE and PIVOT QUERY in Excel for Data Analysis, Modelling and Slicing

Planned Development team Capacity and Velocity for Projects during Scrum meeting

Perform Table Indexing to Archive Old data and Improve Performance

Liaison between various Stakeholders of the Business and the Applications Development Team

Developed Business Requirement Documentation on SDLC for Inventory Monitoring App

Data Consolidation, Cleaning and Loading to Stage Tables from Various Data Sources including Text Files, Access, Excel Files and other SQL Servers using SQL SSIS, Alteryx

Ensured ROI on Established Sprint Planned events using the Agile Methodology

Communicated and Collaborated Clearly with Peers in both Business Functions and Technical Area to deliver Effective Applications in Line with Corporate Objectives

Configured SSRS Reporting Services to Pull Data from Indexed Views

Created Use-Case on Business Requirements as it creates value to end user or System

06/2009 to 02/2016 Senior Business Data Analyst -Zone International Petroleum/ MTN Communications

For this company that provides mobile telecommunication services in Africa with assets of over $10Billion, I designed KPI’s, Cubes for Multidimensional Analytic Reporting, ETL Packages in SSIS for Data, in addition to gathering requirements and performing in-depth analytics utilizing Power BI and writing & running SQL complex queries.

Use Case Development for Custom Application on Remote Assets Management using the Agile Methodology

Wrote SQL Stored Procedures and Queries that Provide Data for Reporting on Fuel Consumption and Delivery Per Region and State.

Established BRD based on interaction with Stakeholders using their Case Stories and Creating Functional Specs to meet the Business Requirement Deadlines

Data Visualization on Sales By Customers, Sales By Region on Pie Charts using Tableau

KPI Measurement of Remote Site Engineers on Fuel Shrinkage Delivery Percent using Score Charts on Tableau

Created Macros that Supported Importation of Flat File Data in to a Table in Excel

User Story Backlog Remediation to ensure we get Product Owner Changes in Sprint Session

Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle

Developed Excel Pivot Tables based on Data imported from SQL Server, linking SQL Data with MS Access Tables and Creating JOINS on MS Access Queries for Reporting on Tableau

Created UNION JOINS on SQL View on MS Access to Provide Queries for Reports

Designed Dashboards and KPIs in SSRS to Measure Performance Trends and to Drill down to Root Causes for Deviations from Prescribed goals

Performed Requirements Gathering and Prioritization during the SDLC Process

Determined Project Scope and Requirements with Timelines and Expected Results with SMEs both within Business and Technical Functions

Used SQL SSAS to design Cubes for Multidimensional Analytic Reporting

Interviewed Subject Matter Experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people.

Interacted between the Client and IT Dept. Obtaining Business Requirements and benchmarks for development of Database Architecture, Application Development, Testing and then Production

Designed ETL Packages in SSIS for Data Validation, consolidation and Reporting with Power Pivot

Creating Indexed Views, Stored Procedures and Functions.

06/2008 to 03/2009,Snr Business Analyst - Virtual Premise /Hayes Consulting

Company is an Applications Service Provider based in Atlanta that primarily provides strategic intelligent online business reporting for Fortune 500 companies

Implementation of Decision Support System to Measure Key Performance Indices for various industries using Microsoft SQL Server Decision Support Tools.

Interacted with Sales Departments to Determine Business Requirements for Online SQL Reports that needed to be developed by IT Dept. Also established benchmarks for Trend lines in Matrix Reports needed by Sales Dept.

Creating BRD Control Flow for Process Required for Timely Completion on Projects

Creating SQL Views that Encapsulate the Business Requirements and then Providing Analytic Drill Down Reports with Groups based on the SQL Views using Reporting Wizard on BIDS.

Uses UML Diagrams to Document Business Process flow particularly with interaction between business Requirements and Application Development

Creating Stored Procedures and Functions to Enforce Business Requirements

Strategic Analysis of Exchange Rate Exposure for Western Union (One of our Clients) using online application reports provided by SQL reporting and Office writer for Excel. This enabled the customer analyze rate trends for various risk exposures, hence they were able to Hedge better and reduce their quarterly costs by fifty million dollars.

Provided Documentation Control for Software Life Cycle Development during Hiring, Software Development and Testing Programs Developed in house and Provided by Vendors

Designed SSIS Packages for Data Migration against Data Warehouse to Define Unique Real Estate Opportunities

Design and Optimization of Data Access by providing Central Repositories for Client’s data. SQL Reporting enabled our clients to access data provided by various business units from various locations and with Office Writer Software they were able to access complex reports in as little as ten seconds compared to a week under prior dispensation. This improved productivity by 50%.

Provision of Analytical reports for our clients with Fixed Assets on average value of $2billion dollars. This are mainly real estate assets with high cost of maintenance. The reports provide Key performance indices like Vacancy Rate per Region per broker amongst other indices. We can then advice our clients on Productivity, Retention and disposal of costly assets early, saving our clients 10 to 20% on depreciation /operational costs.

05/06 to 10/06, Financial Data Analyst -Cingular Wireless -Horn Muddock Cole

Multibillion Dollar Cell phone Technology Company in Atlanta, GA

Design Access Tables for Clients in Telecommunications Industry using MS Access.

Analysis of Budget Vs Actual expenses and revenues using data from SQL, Access

Preparing financial Statements for the Period on Access Tables

SQL Queries to determine optimal Sales per Unit in Access Databases

SQL Reporting services to monitor sales based on Wireless Telecom Contracts

Update Queries in Access to populate tables to be used for final report.

Design, Update and Modify reports in Access, showing global sales distribution

05/05 to 04/06, Snr SQL Developer -Data Analyst. Prg Schultz

Multibillion Dollar Company based in Atlanta engages in Financial and Medical Audit for Fortune 1000 Clients

Managed Resources for Commercial Healthcare Claims Audit report to identify overpayments made to Providers of Healthcare by Commercial

Healthcare Insurance Companies.

Prepared Journal Entries in Peoplesoft 9.0 General Ledger

Prepared SQR Reports on Expenses from Peoplesoft

Prepared Monthly Budget for Audit group

Evaluated Business Requirements in Process Flow BRD documents the Provided Rules for Filtering Incompatible ICD-9 Codes VS CPT Codes where Modifiers where not well Stipulated.

Update and Add new Journal Entries into Detail Segments on Peoplesoft Accounts Payable Application

Run Process Scheduler to Process Journals based on Run Control ID in Peoplesoft

Use Process Scheduler to Schedule SQR Reports from Peoplesoft Database

Liaised with various stakeholders including Billing, Programmers and Executive Management on Business Requirements for Audit Procedure in Conjunction with HIPAA Regulation.

Audit reports have helped saved commercial clients an average of $4million a quarter.

Savings Analyses for Claims using IF function, HLOOKUP on Excel Spread Sheets.

Sources and Uses of Cash Flow reports and real rate of return for Medicare Claims Cost Analysis reports.

06/2003 to 04/2004,Senior Data Analyst- Nextel Communications /(TekSystems )

Multibillion dollar Company recently merged with sprint is one of the three main cellular telecommunication companies in United States

Monthly revenue analysis reports from General Ledger for referral credit program using Excel Spread Sheets

Run Income Statement Reports using Process Scheduler on PeopleSoft 8.0

Run PS /Nvision Expense Reports using PeopleSoft

Measuring ARPU (Average Revenue per Unit) per unit on a monthly basis and analysis on Excel Spreadsheets

General Ledger on Receivables and revenue for month end on Access database

Maintained $50 million quarterly budget for Sales Promotion Expenses

Determination of Fixed and Variable Costs of Churn programs for Income Statement using Queries in Access

Expense reporting for Sales Commission on Post- Paid business

Analysis and reporting for Cash Flow from New Program contracts

Monthly Sales Receipts Cash flow Reports on various business units

Designed Star Data Warehouse on the SQL Server for OLAP Application to provide aggregate reports on Customer Churn Activity, Monthly and Quarterly Revenue Reports and using Crystal Analysis Reports as a front end Application

03/2003 to 06/2003, Senior Financial Analyst -LaSalle Bank

Multibillion Dollar Company acquired by ABN AMRO BANK is a whole sale investment banking unit with over 10billion dollars in Asset Management

Month –end Closing on General Ledger for Collateralized Security Account

Variance analysis on Profitability ratios for Fixed income Securities

Designing Financial Models used in Fixed Income Analysis using SQL/Excel

Excel Spreadsheet for Reports used in determining Projected Interest on Asset Backed Securities

Determining Net Present Values and IRR on Projected Cash flows for Collaterals of Asset Backed Securities

Calculation of Variances and Limitation Tests on Over Collateralization and Interest Coverages on Trenches of the Bond Allocation

Analyzing web reports and creating new stored procedures that provide reports on demand using crystal reports.

Daily Financial Statements and Investor Reports needed for Budgeting and Planning

Developing Reports used for Account Summary of Collateralized Debts Obligations using Crystal reports based on SQL /Access Data

Analysis of Income Statement using Excel

04/2002 to 01/2003, Senior Report Analyst -

Fortis USA (Core Inc.)

Multibillion Dollar Investment and Insurance based out of Maine, New York

Developing SQL/Access reports for managing the quarterly budget on Crystal report

Fixed Costs and relative variable costs for quarterly Budget Statement

Creating reports for projected cash flow from Eligibility status using Crystal OLAP reports

Quality Analysis of data to make sure it conforms to specification

Projecting Present Value of Cash Flows from premium payments

Developing reports for period costs to Fortis as a result of short-term disability gross benefit

Responsible for transfer and normalization of data between Access and SQL for Eligibility Reports

Creating Access database that generate reports for cost-analysis

Creating data objects to be used for OLAP reports using the star data schema

Using Spreadsheet to determine Operating Cash flow

Daily Account Summery on Profit projections

03/2001 to 02/2002, Quadramed (OAO HealthCare) -

SQL Developer /Business Analyst

Designing Stored Procedures that Manage Customer Login online and provide unique Characters with login values

Designing Queries with Active Server Pages for Report Generation

Data Access on SQL Server with ASP

Designing Excel Macros to determine Period costs and Overhead

Writing Stored Procedures that monitor Licensing Sales and providing profitability reports

Using the Management Console on Crystal Enterprise to manage users and groups based on Windows security architecture

Upgrading from SQL 7.0 to SQL 2000

Performance Tuning on SQL 7.0 and SQL 2000

Creating and Maintaining access/ SQL database with Entity Relationship Diagrams

Optimization and Performance tuning of Indexes

Scheduling Jobs for Replication and Designing database Maintenance

Performance Monitoring of the Servers using Counters, Alerts and SQL Profiler

Creating Customized queries on access database with forms using Active Server Pages

Developing Distributed Applications for Data Entry and Manipulation on the database using a Customized front end developed with Visual Basic and ADO data Control

Data Ware housing and producing ad hoc SQL Reports with OLAP services of SQL Server (Star Schema)

09/2000 to 02/2001, Sr SQL Programmer/Data analyst - Citibank

Designing SQL Database Schemas for integration with Crystal Reports for on-line transactions

Upgrading Access Database to SQL using DTS

Designing Stored Procedures for Business Reports

Batch Updates from Text files to SQL Server

Creating Database Scripts with Query Analyzer and Enterprise Manager

Using SQL server to configure transactional replications

Setting Up standby Server as Backup strategy

Creating SQL Cube Reports using OLAP services of SQL Server

10/1999 to 09/2000,Financial Analyst/Staff Accountant -KPMG

Peat Marwick (through ABACUS Staffing), the apparel industry) and Fox Sports Finance: (through Accountants on Call) based in California

Prepared and analyzed monthly consolidated financial statements

Performed extensive general ledger account reconciliations, analysis and journal entries

General Ledger Entries for Expenses using PeopleSoft 8.0

Actual cost and expenses general ledger on PeopleSoft for Program Contracts

Prepared quarterly and annual budgets

Reconciled complex bank accounts

Performed month-end close duties

Revenue research and analysis using PeopleSoft Financials and produced custom query reports using Nvision and Crystal Report

Determined Net Present Value on projected cash flows as per the Budget

Prepared cash flow projections based on operational and financial activities in the various business units

Reconciled accounts payable and accounts receivable thereby determining the weekly flash reports and balance sheet

Created weekly flash reports and prepared budget analysis

- Master’s in Business Administration, University Of Hartford.

- Masters of Science, University Of Southern California



Contact this candidate