Stan Kessler Email & Phone Number

Chicago, Il, Us

Chicago, Il, Us

• Analyze and maintain timely and accurate data integration from various sources: • Extracts for non-integrated systems and external vendors; • SQL objects utilized by integrated systems • Automated processes • QA integration between external and internal systems (web application, web services, data mapping and validation). • Adapt existing logic/business processes to to new web e-Commerce/e-Store systems • Build and maintain reporting objects and tools used by staff on recurring or ad hoc basis: • Support staff in accomplishing routine/recurring tasks and improving the performance of tasks • Complete ad hoc data aggregation/extraction requests, proactively communicate observations and suggestions to consumers of data • Build/maintain core SQL business objects • Reporting/query tools utilized include SQL Server Mgmt Studio queries/views/procedures, SSRS reports, SSIS, Crystal reports, iMIS IQA queries, • Assessment of existing SQL objects and business reports to ensure accuracy and consistency • Support special projects and initiatives with data, queries, analysis and recommendations

Chicago, Illinois, Us

• QA Testing & SQL data analysis for new FedEx integration with GP application, and SSRS report writing for .Net web application • SQL Report writing utilizing SSRS, Views, DTS\SSIS, Business Objects • ETL, Data Warehousing and Data feeds for KPI reporting & marketing campaigns • System analysis, support, and maintenenance • Daily, weekly and monthly KPI reporting and support • Monitor\troubleshoot data communication for over 80 retail locations • Issue resolution for technical issues • Monitoring proprietary and custom SQL database activity and updates • Cross-functional support and analysis for multiple business units

Chicago, Il, Us

Analyzed and maintained moderately complex Dynamics software implementation across multiple, synchronized Citrix environments (Production, Test, Development). Provided technical support to end-users in order to optimize system use and improve effectiveness and efficiency in meeting the organizations business objectives. • Documented and Managed Dynamics GP/3rd party enterprise software in relationship to external systems • Analyzed and resolved complex system issues through work with implementation teams and operations staff • Worked closely with end users and IS personnel to define objectives and outputs of proposed systems • Participated in developing and managing project plans • Documented fact-finding results and make recommendations and specifications

Lisle, Illinois, Us

MRED LLC was formed through the consolidation of two companies in April 2008. I shared responsibility for post-consolidation integration financial information, establishment of accounting procedures and implemented the accounting system. Functions included: Prepared and analyzed financial information (monthly balance sheet, income statement, cash flow) and reporting changes in financial position/budget variances. Provided monthly management reports. System administrator for Accounting and Financial Reporting systems. Evaluated new products. Streamline monthly close process. Managed AP disbursements expense-related accounting functions. Reconciled balance sheet accounts. Selected contributions include: • Designed new chart of accounts, installed and implemented Dynamics GP financial system, including GL, AP, AR, Invoicing, Bank Reconciliation, Fixed Assets, Integration Manager and FRx Financial Reporting. • Completed integrated monthly close process, ensured recording of proper transaction accounting. • Consolidated and migrated fixed asset data from and established procedures for fixed assets module. • Implemented new cafeteria plan, consulting with HR professionals and setting up new policies & procedures. • Instituted accounting and financial reporting for Preferred Units offering including installment sales.

Responsible for entire accounting process for an Illinois Non-profit business membership organization providing data aggregation services. Reported directly to C.E.O. and was corporate liaison with auditors for annual audit and monthly review of financial statements. Accountability extended from accounting policy to processing monthly close. Supervised two employees and managed infrastructure and processes to ensure proper accounting and reporting for all revenues, expenses and balance sheet items; prepared monthly financial statements, including proofing and analysis; performed P&L forecasting and variance analysis; created and performed quarterly review of annual budget; administered human resource and payroll for staff of 30. Selected Contributions: • Internally Administered cafeteria & SARSEP plans. Implemented Direct Deposit in liaison with bank. • Supervised monthly billing of 14000+ membership subscribers at 400+ locations. Developed billing matrix for conversion to new membership system, built ad hoc reporting for membership fees with links to multiple SQL databases. • Managed financial record keeping for equity memberships. Prepared annual report of net profits from membership fees and computed refunds payable to eligible equity memberships. • Collaborated with external accountants in conjunction with corporate consolidation, prepared final Pro Forma Income Statement and 18-month projections.

Software Lab, Inc. ceased operation as of July 2002.Responsible for developing and implementing project plans for Great Plains Dynamics installations, upgrades and migrations on multiple platforms and involving third party products for Great Plains Value-Added Reseller (VAR). Participated in data conversion and custom programming, designed new procedures and reports. Assisted customers with solutions for long-term and crisis situations, ensuring thorough and pertinent problem resolution.

Member of Finance Department for regional accounting firm with 3 locations, subsidiaries, and staff of 100+. Used Great Plains Accounting and Dynamics C\S+ in the functions of Accounts Payable, Payroll, General Ledger, Report Writer.Transferred to IT Department, participating in conversion of accounting system from DOS-based GPA to Windows\SQL Server-based C\S+. Provided technical support and training for Dynamics clients. Developed and presented courses for Microsoft applications including Access 97, Windows 95, and Internet/Intranet Training.

B.A., Religion, Music

Principles, Financial Accounting

General Studies