Experience

Sterling Bank

• Banking
• 700 & Above Employee

• Consultant/Reports Developer

  • Sep 2016 - Present



Nature Portfolio

• United Kingdom
• Book and Periodical Publishing
• 300 - 400 Employee

• Reports Developer

  • Nov 2011 - Apr 2013

   Responsible for the creation, design, implementation and enhancement of more than 200 financial and statistical reports using Crystal Reporting tools and MySQL/MSSQL database engines  Developed strong expertise in producing accurate and timely reports consisting of data from over 10 distinct databases.  Ensured consistent client satisfaction through the creation and scheduling of automated report distribution in client-tailored formats  Utilized Scrum methodology to streamline development  Collaborated with more than 40 colleagues in the United States, England, India, and Japan  Created a SQL commands library for Crystal Reports  Managed multiple concurrent projects and workload using the JIRA issue tracking software  Utilized THINK software to ensure data consistency and integrity Show less



Greater New York Hospital Association

• United States
• Hospitals and Health Care
• 100 - 200 Employee

• Computer Programmer

  • May 2008 - Jun 2011

   Responsible for design, implementation and administration of SAGE Saleslogix, company’s CRM tool, which stores 20,000+ Accounts (Hospitals, Suppliers, Consulting groups, etc), 40,000+ Contacts, 100,000+ Opportunities, Activities, Reports, and various other items  Maintained separate Development and Production environments  Resolved infrastructure and client issues  Expanded functionality by adding custom tables and fields to the SQL database backend  Developed and maintained over 500 Crystal Reports and ad-hoc SQL reports used by more than 150 users, from administrative staff to C-level executives. Major improvements include:  Reduction in time to get to meaningful data from 8 hours to less than one minute  Reduction in user errors by removing the need for manually compiling reports  Advanced data analysis by combining numerous sources into a single report with conditional logic  Enhanced usability and quality by only showing meaningful data in simplified and aesthetic format  Enhanced Saleslogix’s functionality by developing and maintaining over 100 custom forms using Visual Basic. Selected functionality includes:  Automated data entry and validation by allowing users to upload thousands of Opportunities at one time, reducing user error and greatly improving efficiency  Integration with company Intranet, allowing one-click email and fax blasts to Senate and Legislature custom contact groups  Custom integration of various Microsoft Outlook items into Saleslogix  One-click mail merges and address label creation using Saleslogix and Microsoft Word  Involved in weekly meetings with Saleslogix stakeholders to address issues and gather requirements for new features  Trained over 70 people on Saleslogix Show less



New York City Law Department

• United States
• Law Practice
• 500 - 600 Employee

• Intern (IT Department)

  • Jun 2006 - Apr 2008

   Responsible for design and implementation of several projects. These include:  Weekly Newsletter - HTML-based newsletter (DreamWeaver, CSS, and Adobe Professional Suite) received by over 3000 employees  Bi-Weekly Project Planner – Created Excel-based and Visio-based charts for various projects and meetings  MAC Reports – Query-based (Microsoft Access, Crystal Reports) reporting system that generates PDF documents that are sent to upper management  Use collaboration software (SharePoint) to establish document workflow for a 10 person team  Use Adobe Photoshop to convert personnel photos in a recent ID-card migration Show less