Software Development Financial Analyst

Steven Janow, MBA

Business Analyst, Financial Analyst, Accountant, Management, IT Developer/Programmer LinkedIn: http://www.LinkedIn.com/pub/steven-janow/17/375/953 69 Chestnut Street Rhinebeck, NY 12572 Cell: 845-***-**** ad5o43@r.postjobfree.com Twitter: StevenJanow Dedicated, focused, and flexible business and financial analyst manager with proven experience and insight that delivers continuous improvement and maintenance of efficiency, operations, and revenue. Strategies are crafted with due diligence centering around the unique characteristics and situation of the company and its business environment with team collaborations, independently, or both.

SKILLS

General Business Financial IT

SQL, Reporting, QA Data Modeling Analysis/ Reporting SQL QA / Testing Strategic Planning Management General Ledger Software Development Ecommerce Project Management Business Development Cost/Benefit Analysis Needs Assessment PCI Compliance Agile and Waterfall Sales Analysis Accounts Payable / Programmer / Full Stack Web Design BRD, FSD Analysis Marketing Analysis Accounts Receivable Data Warehousing Internet Marketing Process Improvement Branding Budgeting Online Security Deployment/Migrations Negotiations Trend Tracking Cost Accounting Process Improvement dashboards

** TLDG – Two-time participant in the Thayer Leader Development Group, West Point Military Academy, NY September 2016, April 2018. This is used by many fortune 500 companies’ executive level employees. Business and Financial Analysis includes a wide variety of reporting which includes report creation and maintaining, a variety of analysis, summaries and projections, monthly budget variances/ expense reports, cost benefit analyses, variances, trends, cyclical events, risk, budgets, forecasts, statistical reports, cash flow projections, business forecasts, in-process and completed projects including dollar and time perspectives, spending monitor, investigate and resolve variances, average rate tables, IT finance, and much more.

Financial and Excel skills include ERP, Power BI, Excel (Expert level), various management software, SQL, and SQL reporting software, pivot tables, data analysis ratios and reporting summaries, sophisticated cell calculations such as VLOOKUP, macros, and much more. IT skills include SQL (Microsoft and Oracle), programming and development problem solving skills and experience, full stack software development and programming, ColdFusion 11 (very similar to asp.NET, PHP), Windows Server, HTML, JavaScript, C, C++, Java, Object Oriented Programming, and much more.

EXPERIENCE

Voting Machine Inspector - Dutchess County Board of Elections Poughkeepsie, NY March 2024 - Present

● Assist and work with individual voters to facilitate each voter’s vote for federal, state, or local elections.

● Determine sequence of work and coordinate it.

● Troubleshoot problems and develop plans to resolve them. Business Analyst, Business Systems Analyst – FIS Global Headquarters / T. Rowe Price Fully Remote April 2023 – June 2023

Various reporting, analysis and report creation with Excel, SharePoint, and more. Business Analyst, Business Systems Analyst – Precision Pipeline Solutions Headquarters New Windsor, NY April 2022 – July 2022

Various reporting, analysis and report creation with Power BI reports, Excel, and more. Data Analyst / Enumerator - US 2020 Census Poughkeepsie, NY (Seasonal work) July 2020 – October 2020

On site data analysis via one-to-one interviews

Earned various performance bonuses

Contributed to data reporting enhancements

Data and Reporting Analyst - Vassar Nurses Alumni - temporary independent work for social network November 2018 – December 2020

Analysis, review, one on one conversations and review with clients for dramatic improvement of various data and reporting, using business and data analysis, original advanced Excel programming and project – oriented problem solving, Word, data capture and final project hand-off to clients.

Full end to end improvement of internal data tracking, reporting, and subsequent efficiency in overall operations. Steven Janow ad5o43@r.postjobfree.com 845-***-**** Cell

Planning and Forecasting: analysis of user end clients and careful spreadsheet design resulting in highly satisfied clients. Business Analyst / Data Manager – Astor Services for Children and Families, Rhinebeck, NY April 2016 – April 2017 This not-for-profit organization received a government grant for self-improvement, with which this one-year data manager position was created.

Dramatically improved quality, details, and employee usage (over 40%), and innovated electronic reporting via Oracle SQL programming and development, Excel, Pentaho report writer, and more.

Reporting, Planning and Forecasting: analysis of anticipated needs of end user clients, 3rd party improvement transformations with change management, future projections of various user needs compared to resources and length of government grant

o This directly assisted a dramatic increase in billing accuracy and efficiency, and various government and other grant increases (431%, 6% total revenue increase).

Liaison between non-IT supervisors, IT department, executive management, and two 3rd party IT companies. o Participated in and contributed to executive committees dealing with various operations and IT concerns and projects, directly assisting with or cause of success of projects. o Single handedly negotiated and persuaded a four-way compromise during a conference call involving two internal departments, and two 3rd party IT organizations that are essentially competitors. The compromise dealt with an impasse that had been stalling productivity since before I began working there. The breakthrough allowed a major data project to approach fruition.

Created Executive Dashboard using Excel and their cloud software custom tailored to their specifications and data requirements, received high acclaim from executive management and founders. Business Analyst / Ecommerce Web Programmer - SCA-Corp, Red Hook, NY September 2010 – February 2016 This approximately $1 million company specializes in software for municipal governments, which includes various packages for property tax, online tax payments, property assessments & online assessment lookup, parcel inspection tracking, permits, online permit applications and other local government concerns that are custom designed.

Reporting, Planning, Forecasting: continuous analysis of end client needs, company resources, internal tracking of client product success combined with reporting, original design of software tools for end user clients for their reporting needs, software service procurement, anticipation of future company resource needs and potential client needs

Increasing sales and usage 25% to 1,400% along with brand image, reputation, goodwill & web presence via improving and expanding programming and website features, working with clients directly, and analyzing general business concerns both present and future, and rewrote almost all of the website software from scratch, using an Agile methodology.

Supervising several coworkers & managing web presence resulting in continuously increasing web usage by public citizens, up 11% in 2012, and new government clients, up 25% in 2013 and up 32% going into 2014.

Resolved and improved monthly online PCI security compliance measures resulting in company’s best security rating.

Resolving business and technical internal and external issues among coworkers, clients and software efficiently and with decorum that maximize short term and long-term business and financial returns.

Innovative business development with server side ColdFusion, SQL, Windows Server admin, client side JavaScript, HTML, graphic design resulting in dramatically improved website performance and customer satisfaction. Quality Control Analyst - US Census Poughkeepsie, NY (Seasonal work) March 2010 – July 2010

Utilized business analysis to maintain above-average completion schedules and high-quality reports.

Inspected census workers’ data and re-did failed work, interviewed people which included explaining significance and helping to improve people’s morale about the census with citizens.

Improved payroll and administrative methods to increase accuracy and productivity, & instructed workers; improved process efficiency to over 60% and helped bring lagging division up to speed; division did not need to hire more. Business Analyst / Financial Analyst - Empire Merchants North, Kingston, NY Feb 2009 – June 09 A $500 million supply chain distributor of premium and mid-range wines and spirits; warehouse closed/merged; position downsized. This position involved sales analysis, procurement, variance, economic, strategic, macro & micro analysis, reporting, cost/benefit analysis, financial statements, AP/AR, adjusting entries, supervision of other analysts and accountants, forecasting, and more.

Reporting, Planning, Forecasting: Continuous sales analysis, anticipation of future sales via previous sales data, current and projected economic data in the Great Recession, projection of sales among many different product lines and niche markets

Strategized and collaborated and with brand managers of various suppliers to maintain and increase growth between 5% and 45% during recession using a variety of pricing, economic and sales strategies and analysis.

Improved and innovated reporting efficiency, detail and accuracy; instructed manager

Innovated and facilitated high volume daily, weekly & monthly reports for multiple suppliers and brand managers. Business Financial Analyst/Accountant - Taro Pharmaceutical HQ, Hawthorne, NY December 2007– Dec. 2007 Steven Janow ad5o43@r.postjobfree.com 845-***-**** Cell

Staff Accountant Consultant /Temp – Michael Page Placement This international company with headquarters in Israel develops and markets prescription topical creams and ointments. I organized, prepared and facilitated bi-weekly and monthly financial and accounting reports for senior review, facilitated and managed accounts payable and international wire transfers.

Facilitated critical account analysis for integrity and consistency of all international accounts and raising red flags

Participation in critical analysis for success of new product line vs. accepting a leveraged buyout from a competitor.

Rewrote the accounts payable process notes, which used advanced excel techniques and older dos software; improved time efficiency to over 30%.

Business Financial Analyst /Accountant - Reader’s Digest HQ, Westchester, NY September 2007 – September 2007 Senior Level Accountant Consultant /Temp – Michael Page Placement

Managed tasks in a high-volume workplace.

Analyzed and checked accuracy for many general ledger sub-accounts for 3rd Quarter closing. Business Financial Analyst /Accountant - GE Finance HQ, Danbury, CT November 2006 – July 2007 Junior Level Accountant Consultant /Temp - K-Force Placement This high-volume division specialized in business personal property and the job required rental & lease analysis, quality control over outsourced financial activities, lien analysis, depreciation & initiating rebuttal of government schedules, adjusting entries, accounts payable with check cutting, negotiating with 3rd party companies in all 50 states

Initiated & improved critical review of fixed assets / business personal property taxes: o Analyzed depreciation, mill rate, property dating o Facilitated updating internal records to coincide with govt. county schedules o Facilitated protests against inconsistent govt. county tax assessments

Innovated methods to increase team efficiency, reporting and analysis accuracy, positive attitude, improved relations with 3rd parties and lowered overhead expenses resulting in over 10% reduction. Business Financial Analyst /Accountant - Ethan Allen HQ, Danbury, CT August 2006 – October 2006 Jr. Level Accountant Consultant – Accountemps, Danbury, CT This company is a market leader in high end furniture and this high- volume accountant analyst position required managing many analytical tasks such as analyzing and posting for all of their product lines, posting to monthly general ledger, managed and facilitated accounts payable and accounts receivable.

Improved and repaired complex Excel financial records to bring general ledger balance to exact cent

Managed and reported financial ratios and other financial analysis across every product line Day Trader, temporary self-employment March 2005 - July 2006 Successful analysis and trading of secondary equities stock market; executing original technique within a very dynamic and intense setting.

EDUCATION

Marist College

Masters of Business Administration (MBA), 3.7 GPA, AACSB Accredited; earned management scholarship, President’s List, Dean’s List, Academic Citation

State University of New York/ Dutchess Community College C++/Java Advanced Programming Certificate; earned academic citation University of Hartford / Hartt School of Music Bachelor of Music (BM), Classical Music Composition, earned awards and fellowship State University of New York/ Dutchess Community College Associates (AA), Liberal Arts / Humanities Please see cover letter on next page.

Steven Janow ad5o43@r.postjobfree.com 845-***-**** Cell

Greetings HR:

I am seeking this position because in addition to years of experience and innovative strategic analysis that has resulted in higher profitability and efficiency, I am a dedicated team player as well as an analytical, detail- and strategic-oriented worker. I use a variety of short, medium- and long-term analysis and projections using a variety of analysis resulting in very highly accurate forecasting and improving efficiency and profitability. This results in having a track record of enhancing reporting, increasing efficiency, improving processes, improving services and products to be more responsive to clients resulting in improved brand awareness and sales, creating more efficient and profitable sales generation through unique analysis and more. This is how I have added value to the team and company for the accounting, business analysis, financial analysis or similar work I have done. Also because of my unique background, I work well with a variety of personalities and the different backgrounds of colleagues. I have always infused a positive, can-do attitude and adjusted quickly to even the most unusual or demanding of situations to ensure deadlines are met with professional quality.

My economic, financial and business analysis experience and knowledge have assisted many business operations with achieving leaner operations with increased sales.

I am an expert with Excel which includes pivot tables and sophisticated logic operations, and I can learn any software quickly because of my computer programming background.

My skills, knowledge and experiences are highly transferable. The teams and groups I work with always achieve excellent and higher than expected results, including decreased overhead, increased revenue and increased quality of the company brand. I bring a great deal of experience, which includes improving and maintaining efficiency, reporting, and profitability, to this job. I have an extensive analytical background, and I achieve both quantity and ultra-high precision of accounting and analysis work as well as learn new processes and procedures quickly. Thank you for your time and consideration.

Sincerely,

Steven Janow, MBA

Contact this candidate