• Reconcile administrative accounting subsystems in the general ledger SAP to the posted transactions in Illinois Office of Comptroller general ledger.• Reconcile State of Illinois cashed based General Ledger for expenditures, revenue and cash to Department of Employment Security records.• Perform reconciliations between Federal Reporting Systems of Federal Department of Labor and the General Ledger of Department of Employment Security.• Analyze accounting transaction to ensure accuracy.• Review and evaluates financial standards and systems to determine potential effect on the General Ledger in SAP.• Complete quarterly grant reporting package for DOL for attestation from CFO to ensure grant compliance using SAP HANA database. • Perform year end reconciliation of department’s accounting system, converting Comptroller’s cash-based journal into accrual bases ensuring that accounting systems and subsystem are balance and consistent with GAAP (Generally Accepted Accounting Principles), Comptroller’s Office and Federal guidelines. • Submit necessary documentation for closing Federal Programs in the accounting systems and subsystems and submit to CFO for review.• Review and analyze accounting system and subsystems to ensure the expenditures charged and are in compliance with GAAP (Generally Accepted Accounting Principles), Comptroller’s Office and Federal guidelines.• Compile, modify and maintain reports in SAP HANA database for departmental and inter-departmental request. • Prepare, review and perform month end accrual entry and indirect cost allocation entry. • Consult and interact with the Accounting Reporting Transaction unit to ensure appropriate corrections are made.

- Support divisional traffic needs (quotes and rate verification).- Responsible for analyzing freight reports to identify cost savings opportunities, trends and billing or routing errors.- Develop and maintain data preparation and validation routines to support the reporting of clinical metrics and cost information.- Automate data load and data analysis programs with a goal of improving efficiencies across distribution centers.- Select, recommend and apply appropriate analytic and statistical methodologies and techniques for Business Process Analystics.- Develop innovative and/or customized templates and report formats- Process and analyze data to support clinical and financial initiatives.- Performs ad-hoc analysis.

• Project lead for whole project life cycle initiated for integration of Boot Alliance Planogram in Walgreens.• Responsible for implementation and maintenance of subscriptions of 200k plus Departments of 2000 Walgreens Stores.• Integrate robust data analysis and variables to develop and maintain planograms reflecting the category’s strategic vision, most optimal assortments, mass localization, merchandising guidelines and size requirements.• Recommends and executes on assortment recommendations with category managers for revisions that directly contribute to improved category performance including but not limited to: Sales, Gross Profit, Days of Supply, Turns and GMROI.• Responsible for reporting on Master Data for supporting of business intelligence, analysis and reporting solutions. • Responsible for data modeling, designing and developing reporting solutions in a Microsoft tools environment and responsible for adhering to current reporting procedures and techniques• Year round innovation, enhancement and maintenance of strategic sets used in executive reviews.• Collaborates with suppliers, third party vendors, contractors and project teams.• Develops and works with Company specific analytical tool to deliver upon ad-hoc space productivity analysis, Including tables, highlights, charts, labels and reports within the JDA Intactix Suite and Data Manager.• Trained Managers and Associate for whole project life cycle process of subscription side Data integration, Data Extraction and Validation Process.• Communicates and presents to Category Managers, Divisional Space Management Managers, General Space Management Managers and Senior Executives.

Assisted staff with the design and implementation of projects outlined in the City Treasurer’s Aggregate Price Initiative and also performed related administrative and research duties.Drafted financial reports. conduct data skimming and financial analysis, create presentations, and help with quarterly reporting.Issued and compiled Request for Information (RFI) questionnaire to facilitate annual qualification of each broker/dealer interested in working with the City investments.Assisted Investment Office evaluate interested broker/dealers on the basis of criteria set by the City Treasurer, including the firm’s prior experience, financial stability, and other requirements deemed necessary by the Office, the Municipal Code or other applicable government agencies.

• Review financial statements and analyze sales revenues, costs, expenses, and tax rates for all companies assigned. • Develop detailed spreadsheets to identify trends and develop forecasts. Consolidate and analyze monthly results and budgets. • Identify, quantify and provide recommendations on short-and long-range ROI. Identifying key risk factors and forecasting investment viability. • Established new forecasting tracking and management reporting system to improve availability and accuracy of financial data, triggering 15% increase in accuracy. • Conducted quantitative analysis of financial data to forecast revenue, identify future trends, and assess risk associated with capital expenditures, acquisitions, and joint-venture projects for large firm. • Compiled and reviewed complex data to assess multimillion Rupees accounts and business units. Developed comprehensive reports, abstracts, and charts to present data and guide investment strategies.• Performed ad-hoc analysis and reporting. • Integral in ensuring due diligence involving multi-million real-estate investment.• Improved operational efficiency of finance systems through implementation of streamlined data management procedures by implementation of ERP system within all business units.• Contributed to 12% growth in investment portfolio by developing strategic planning and recommendation regarding long-range investments.• Assisted with financial analysis forecasting, and risk assessment within firm.• Supported and collaborated with Senior Financial Analyst in executing buy sell process.