Sign in

Business systems analyst

New Rochelle, New York, United States
February 07, 2018

Contact this candidate


David T. Robinson

New Rochelle, NY *****, 646-***-****

Qualifications Summary

Experienced in IT/BA Analysis Applications Support, QA testing, and process/ team Management. Strong analytical skills combined with efficient work ethic to meet organizational goals. Ability to problem solve and communicate clearly in a fast paced work environment. Adeptness to work with limited or no supervision while being proactive with the eagerness to learn.

Skills: Analytical, System configuration, Technical Support, Written and Verbal communications, Issue Resolution, Inventory Control and Tracking, Customer Service and Response, SDLC.

Languages: Visio, C++, JAVA, HTML, Visual Basic, SQL, MYSQL, UNIX, LINUX, PHP, CSS, Redhat

Systems/Applications: Siebel, Selenium, RightFax, Active Directory, SharePoint, Workbench, Supportworks, Ubuntu, BugZilla, Google Adwords, Google Analytics, Dynamo,Preqin. MS Exchange, Citrix, SAP, SAAS, JIRA, AWS, Salesforce, Starconnect, Blackberry Enterprise Server, Avaya, Microsoft Power BI, Tableau.

Certifications: PMP (currently studying), Licensed Real Estate Agent

Others: Basketball Collegiate (Cobleskill) Professional (Germany)

Professional Experience

Hudson Technologies 4/2017-current

Sr Data Analyst/Business Analyst

Supporting the department in driving changes to ensure that their Data can be efficiently utilized by key stakeholders Liaise and bridge the gap between Technology and the business engaging directing with other business streams.

Interpret data, analyze results using statistical techniques and provide ongoing reporting, scheduled and ad hoc(Ms Access, SQL, MS Power BI, SSAS)

Develop and implement data collection systems(SSIS)

Acquire data from multiple sources and maintain databases

Accountable for preparing and providing financial reports to various departments and leadership

Manage all reporting requests to ensure accurate, quality data is provided.

Identify and analyze trends or patterns in complex revenue cycle data

Document business requirements and technical designs and implementations.

Port Authority NY & NJ 6/2015-2/2017

Sr IT Business Systems Analyst/ Data Analyst

Responsible for managing monthly and weekly statistics within the violations department. Creating trend analysis to predict future violations and income revenue. Using results to pinpoint systematic or user errors throughout violations group. Facilitate and direct the efforts for the full life cycle of these updates and reports with leadership.

●Running queries to gather data and creating dashboards for information groups (SQL Oracle, Crystal Reports,VBA).

●Provide support of daily and ad-hoc requests Perform validation of models to ensure adequacy, define data requirements, gather and validate information, applying judgment and statistical tests (MS Power BI, Tableau)

●Create performance measurements and analytical tools to improve profitability and planning processes.

●Develop periodic reports on a wide range of strategic and tactical analysis and projects outlining key business drivers, and present original analysis and strategies to senior management.

●Define, analyze, and implement strategies based on project objectives towards business goals and KPI’s

●Provides high-level technical consulting support on projects.

●Build comprehensive documentation for all business processes (MS SharePoint, Salesforce).

●Participates with other IT members, customers and other stakeholders in new product reviews, tests and pilots.

Libremax Capital Hedge Fund 9/2014-11/2014

Sr Data Analyst/ System Analyst (Contract)

Responsible for the gathering and documenting of client data requirements for both new and modified client implementations. This individual will work in a diverse and dynamic environment with a team of business analysts, project managers, QA analysts and developers.

●Work directly with clients to determine data requirements for both new and modified client implementations.

●Work with Project Managers and Engineering leads to determine scope and effort required for data handling.

●Prepare data mapping requirements documents that the engineering and QA teams will use during design, development and testing efforts. Assist in corporate systems reporting (Google Analytics)

●Analyze existing client data files to determine accurate mapping specifications (Dynamo, Preqin)

●Serve as a Subject Matter Expert to answer client questions and guide clients on data best practices.

●Respond to development and testing requests for requirements clarifications, consulting clients as needed.

●Participate in requirements overview meetings. Perform pre-implementation data file validation.

●Set data mapping and handling standards to be followed during design and development.

●Assist in developing data validation test cases. Perform tests to determine application performance, including effect on existing, or planned changes, to functionalities.

Starwood Hotels & Resorts 4/2014-8/2014

ISAC Data Migration Analyst/ Application Analyst (Contract)

Assisted in preparation for hotels converting from their existing Sales & Catering Applications to ISAC system( SaaS). Worked with Project Managers, Trainers and QA team, utilizing the SDLC Agile process on projects from conception to production.

●Work with Implementation team for property setup into ISAC user interface, TLPe user interface, Galaxy user interface and Valhalla user interface. Validate data and ensure on time and accurate delivery of conversion items.

●Modify and develop data per customer specifications. Performed stress tests and validation for application and systems. Design and create solutions for load, migrations, and integrating multiple datasets. Configuration management and Production application acceptance testing in UAT, Dev, QA, JAVA, and Production environments.

●Participation in software release management and system configuration for application changes.

●Conduct tasks related to weekend conversion. Not limited to late night tasks of ISAC setup, Delta workbook completion, post conversion ISAC Setup tasks, validation of data migrated from Delphi to ISAC with use of ETL propriety and DataStage, then smoke testing. This also includes resolving data discrepancies once checks are run and preparing summary and action items for implementation team to review with the hotels on Go Live Monday.

●Maintain communication between teams by updating deployment management system and responding promptly to issues reported by tech team and hotel teams during week of go live. Work with tech and hotel teams to put closure to conversion items during the week of go live.

●Create and update defect tracking logs and works with development teams and users to ensure that all defects are resolved. Perform root cause analysis and successfully engage in multiple initiatives simultaneously. (JIRA, Starconnect, Selenium)

●Work with Business and Conversion Units to create Functional Requirement Documents, Business Requirements and Technical Specifications. Develop and manage functional change requests throughout the project lifecycle, as new requirements arise or a discovery time-lapse in the requirement.

●Maintain current and create new documentation to assist the new ISAC properties in preparation of their ISAC conversion. Assist with special projects as needed.

National Basketball Association (Barclays Center) 11/2013- 4/2014

Digital Systems Analyst/ Data Application Analyst (Part Time)

Responsible for supporting the instant replay and video review applications for NBA games. The primary focus is to support the referees (on site) and remotely the NBA Operations engineers.

●Support the Replay related video applications and systems before, during, and after games. Includes proactively monitoring applications and systems, addressing and resolving issues as they arise, and coordinating resolution with other departments where applicable.

●Execute designated Pre-Game Operation Check-in procedures for Video Review and HSAN connectivity; escalate to on-call staff when required.

●Verify all associated metadata feeds for these systems from NBA Headquarters

●First line of defense to troubleshoot and resolve software, hardware and network and video issues related to the video review system and applications. QA testing of relay and mobile application platforms.

●Work with engineers and technicians to resolve video issues with the review servers. Work with local and network broadcasters to help resolve connection issues.

●Complete special projects through life cycle related to game and broadcast support; coordinating resources and equipment, following set procedures and providing regular status updates.

●Build and manage relationships with the end user community.

●Obtain and maintain a high level of expertise in business processes and applications related to games, broadcasts,, and packaged software that are utilized by the NBA, WNBA and NBA D-League.

Budget Promotions Inc 7/2012-11/2013

Senior Applications Systems Analyst (Contract)

Provided production support and new development for the Applications Team and assisted in building new applications based on customer specification, involvement in the entire Agile SDLC process. 40% QA testing, 40% support 20 % implementation while managing a team of three.

●Performed software coding, testing, debugging, documentation, and installation tasks for on-line processes with design documents and specific internal procedures with Win and Mac environment (SQL, MYSQL, JAVA, proprietary systems).

●Defined testing strategy and coordinated testing activities with all departments impacted by the application changes being tested to ensure the quality of the project and software.

●Acted as a focal point to deliver status updates to those groups needing information for their activities.

●Used QA testing (unit, integration, acceptance, load and regression) for software application platform. Created automated testing scripts (Selenium), while utilizing business knowledge to support the applications.

●Participated in the analysis of efficient, cost effective application solutions which supported client business processes and functional requirements (SharePoint, Hyperion).

●Supported programming changes during user acceptance testing and post implementation to ensure integrity of application (proprietary application GUI).

●Problem solved and diagnosed a wide variety of issues regarding computer hardware, operating systems, peripheral devices and software applications Tier 2/3 (IOS Android).

●Provided support for global virtual infrastructure, responsible for delivering capacity planning, analysis, and monitoring.

●Created, managed and troubleshoot internal cloud management systems (blueprints, reservations, provisioning groups and customized workflows.) and external integration points (external cloud provider and storage endpoints as they relate to the hybrid cloud platform).

●Utilized Amazon Cloud Computing (EC2, VPC, and Elastic IP's) along with Web Mapping.

SThree Plc. 1/2012-6/2012

USA Region Site Support Manager

Provided IT Support to user communities and managed several office sites for all IT needs in the North & South America Region of a Global staffing company. This role is a combination of internal Help Desk Support (QA), Business Analyst and Project Manager. Managed a team of six, frequently travelled to all US sites and occasional trips to the United Kingdom.

•Proactively took ownership of IT Support issues specific to each site location as defined by the Regional Site Support Senior Manager.

•Supported hardware, network and software issues for seven site locations of 1,500 users.

•Help Desk Support (level 2 &3) also support level 1 for backup during certain times throughout work shift.

•Main liaison for outside party software and hardware companies to interact with for each site requirements.

•Installed, built, configured, tested, maintained, monitored and troubleshot end user workstation hardware, networked peripheral devices (Active Directory, Siebel,) and local networking hardware products (Cisco, Citrix).

•Implementation of Windows 7, Windows XP, and Citrix across mobile platforms (IOS, Android, Blackberry, GOOD) and user desktops.

•Managed Video Conferencing, Audio Visual and Telephony (Polycom, Avaya) in regional sites either through active engagement with third party vendors or by traveling when required.

•Involvement in office site setups, refurbishment and retirement of equipment Hardware and Software.

•Promptly analyzed and resolved problems encountered by customers in using Commodity (Supportworks) and Customer IT services in a professional and helpful manner.

•Experience in client relationship management problems and service requests on-site and virtual.

•Acted as the main liaison between the IT Service Desk and Network team to ensure the problems were appropriately tracked and escalated.

•Established strong relationships between clients and Group IT; ensuring Group IT and customers understood each other’s needs.

Mansonpowers LLC 6/2010-8/2010(Contract) 11/2010-4/2011(Contract)

Network Manager

Planned, directed, designed, coordinated and administered network systems. Monitored workstations for network operational issues maintained computer & network hardware. Provided information and recommendations regarding computer equipment, software and network trends.

•Maintained network operations, computer hardware, and/or software applications (servers (file, print, application,

WEB, database, proxy, etc.), operating systems) for the purpose of ensuring efficient operations.

•Monitored district servers, website, and related hardware and supporting software (switches, patch panels, racks)

for the purpose of ensuring that resources and technology are available and utilized effectively.

•Researched software applications and hardware requirements in order to provide recommendations regarding

applications and purchases and ensuring availability of materials.

•Served as liaison to software/hardware providers for the purpose of providing and/or gathering information and

coordinating district activities (Cisco, HP, Facet).

•Trained participating district and related site staff (email, Internet access/resources, multi-platform applications) for

the purpose of providing information on the operation and maintenance of computer systems and/or providing

instruction on technology integration into the location.

Hewitt Associates 8/2008-4/2010

Setup Configuration Analyst (QA Analyst/QA Tester)

As a member of a global/ virtual team that handled issue resolution, analysis and debugging processes. Responsible for configuring and testing Hewitt’s proprietary system to meet the needs of client’s testing requirements. Provided support, testing and configuration for fortune 500 & 250 companies, Morgan Stanley, Campbell’s Soup, JP Morgan, Novartis,

●Used proprietary systems, Selenium, SQL, Oracle and tools to setup and configure tables/parameters in the Hewitt system as defined by the analysis of the Systems Analyst, prepare and execute all testing (unit, integration, acceptance and regression), White box and Black box testing.

●Provided testing and support of GUI interface for internal and external clients.

●Utilized relevant problem-solving resources and communication skills (verbal and written) as needed when unexpected results occur.

●In charge of project management for an open project list, providing daily status updates to management and periodic reports to internal teams supervise processes and provide daily analytical support surrounding reports to managers utilized Gannt, SharePoint, Pert charts, and Workbench.

●Participated in conference calls and meeting with clients to provide support, feedback and updates on open projects while setting and exceeding expectations.

●Worked directly with Implementation Managers, Project Managers and System Analysts as support on assigned projects.

United Stationers Supply Company 8/2007-5/2008

Ecommerce Support Analyst

Provided superior assistance to large corporations for a national wholesaler. Serviced Costco, and account managers with any issues or orders they have.

●In charge of fulfilling all client requests such as freight estimates, stock examinations, tracking and placing orders, providing invoices and proof of deliveries and corresponding with account managers (Siebel, Google Analytics).

●Handled and maintained several fax and email accounts to assure accurate and timely order placement address account inquiries, maintain EDI processing, while handling incoming calls.

●Recognized in monthly awards program for 98% occupancy and completing over 1,100 requests per month from August 2007 to February 2008.

●Acted as team player by accommodating to company needs, by taking on special projects and volunteering for overtime.

LocalNet 2/2007-8/2007

Technical Support Representative

Technical support representative for a major internet provider. Provided advanced troubleshooting to customers regarding internet services and their Operating systems.

Provided tier 1 technical support, promoted to tier 2 within two months of the role.

Built rapport quickly in order to aid customers with technical issues for their home computer(s).

Developed a professional relationship with the customer for any future needs while giving any additional product knowledge needed.

Achieved above average quality reports and acknowledged for maintaining an exemplary attitude and phone etiquette.

Education and Training

Buffalo State College Buffalo, NY, 2008

BS, Individualized Studies; concentration in CIS, Business Administration, Communications and Ecommerce

SUNY Cobleskill Cobleskill, NY, 2002

AAS, Computer Information Systems

Contact this candidate