Data Analyst Systems

Donovan C. McGill

**** ****** ***, *****, ** ****9

Cell: 917-***-****/Email: ********@***.***

Summary:

Proven experience in Business Analysis/Systems Design, Software Programming and Project Management.

Solid experience in the analysis, design, development, implementation, maintenance, and management of functional computer systems (using SDLC and Agile/Waterfall); DevOps, and the preparation of supporting documentation.

Experience working with functional/business users, supervising programmers, and working independently in challenging/team-oriented environments.

Experience developing System Flow Diagrams (using Visio) to show the sequence of processing that would be used to accomplish the desired processing.

Experience working with the User Acceptance Testing group to ensure that the software implemented was working correctly, and to obtain User Sign-off.

Performed data analysis and developed different types of data structures to meet system needs and used SQL to process data/generate reports.

Technical Skills:

Business Analysis: Develop Documents (BRD, FRD, Tech DD), Meet with Functional Users and establish Requirements, Manage Projects (MS Project), Set Timelines and Develop Estimates.

Data Analysis: Data Modeling, ETL, SSIS/SSRS, MicroStrategy, Tableau, and Data Visualization.

Testing: (Used different test types to ensure system integrity, based on project): Regression Testing, Smoke Tests, Functional Testing, End-to-End Testing, Security Testing, BDD, TDD, Etc.

Coding: SQL, Python, Java, COBOL, C++, C#, Angular, DotNet., React, and MS Dynamics CRM.

IBM MVS, z/OS: CICS, TSO/ISPF, DB2 (Relational DB), SQL, XML, MQ/Websphere, VSAM, IMS, CA7, FileAid, Xpediter, Endevor, QMF, Syncsort, Stored Procedures, Assembler, and JCL.

Others: Integrated Banking systems (Systematics), Integrated Hospital Systems (EPIC), Support CI/CD Development, Credit Card/ATM Card systems, JAD, Tandem NS, JIRA, Visio, EDI, Data Warehouse, and API Development, JavaScript, Salesforce.

Windows MS Office: PowerPoint, Excel (Dashboards, Formula, Pivot Tables, V-Lookups, etc.), TFS/DevOps, VBA, MS Project, Access, SharePoint, Outlook, and Word.

Professional Experience:

Raymond James Financial (RJF)/Excelgens, Inc., NYC, NY (Remote Work) 5/2022 to Present

Business Systems Analyst/Data Analyst /Development Consultant

Responsibilities/Accomplishments:

Work as a Contractor with Business Analysts and Developers from the Tampa, Florida Office to manage and service Investment Products that are administered by the company. I often meet with team members online (MS Teams/Zoom) to discuss what solutions and projects are to be completed and the dates. We use the Agile methodology and sprints to manage the work accomplishments.

Developed and review System Flow charts and diagrams for use in systems design and implementation of financial products.

Meet regularly with experts in the company to determine the best solutions and security for future processing.

Develop systems (Excel/Access/SharePoint/PowerPoint) with SQL, *.NET, C#, MS Dynamics, VBA and other tools to analyze and present information on work in progress. Large volumes of data are processed to get results.

Conduct Quality Control review to ensure compliance with higher levels of auditing and company regulations.

Participate in Project Reviews (walk-thru) to identify and correct issues with specific projects.

Tata Consultancy Services (TCS) /US Group, Inc., NYC, NY (Remote Work.) 7/2021 to 1/2022

Business Systems Analyst /Data Analyst

Responsibilities/Accomplishments:

Perform work as a contract employee by coordinating and planning for the conversion of Arconic (formerly Alcoa) Legacy plant manufacturing software systems to work with newer server-based distributed systems (Java/Dot.Net) developed by the Rockwell corporation. The Rockwell MES (Manufacturing Execution System) will be used to replace some activities that are conducted on the Unisys 2200 mainframe, VAX mini, and other outdated machines. Perform data analysis functions.

Develop and publish requirements documents using MS Word, Visio, Excel, and SharePoint that are used by the User and technical design groups to plan for migration/conversion work that will be done in the future.

Review and validate software code on the Unisys 2200 mainframe to determine data extraction requirements, and to develop new formats for the data to be sent to the MS Server systems.

Work with Vendor and other staff to resolve system flow problems and develop diagrams to clarify the new processing requirements.

Use Excel, MicroStrategy, EDI, SQL, C#, ASP.NET, HTML, CSS, JSON, CRM, and MS Servers on a regular basis to manipulate large datasets and generate reports/charts for the Users.

Participate in meetings (MS Teams) and in-person to discuss critical issues with the TCS Plant on-shore and off-shore teams.

Do research on current processing (Unisys/VAX) to determine better methods of using the computer resources to complete Shop-Floor tasks and activities.

Willis Towers Watson (WTW), Stamford, CT 2/2019 to 5/2021

Business Systems Analyst/Data Analyst (Senior)/Development Consultant

Responsibilities/Accomplishments:

Worked with management staff and Brokers of the Stamford Office to manage and service Insurance Policies for other major US Corporations (AIG, Bank of America, etc.). I often meet with and do conference calls with different development teams to do scope and strategy to complete new and existing projects.

Developed and reviewed System Flow charts and diagrams for use in systems design and implementation.

Meet regularly with experts (and Vendors) from various parts of the company and managers to determine the best solutions for the security and future processing.

Develop systems (Excel/Access/SharePoint/PowerPoint) with SQL, *.NET, C#, MicroStrategy, MS Dynamics, Python, VBA and other tools to analyze and present information on work in progress. Large volumes of data are processed to get results and create reports.

Conduct Quality Control review on individual assessment packages to ensure compliance with higher levels of auditing and company regulations.

Participate in Project Reviews (walk-thru) to identify and correct issues with specific projects.

Montefiore Hospital Systems/RSC Solutions Inc, Westchester, NY 12/2017 to 9/2018

Business Systems Analyst

Responsibilities/Accomplishments:

Worked on contract assignment with management staff and Information Technology (IT) staff to develop new processes and software for use in the management of the Medical Facilities.

Worked to implement the Healthy Planet and Tapestry (Utility Management) modules of the Epic system (Integrated Hospital software used in most major medical facilities in the US) for use in the organizations many facilities.

The Healthy Planet system from EPIC that I helped to install was used to replace the Montefiore Long Term Care (MLTC) system that previously managed the Population Health functions within the organization.

My projects involved working with important details, documenting requirements, creating easy-to-understand documents, SDLC (Agile), flowcharts, and data mapping. Utilized use cases, workflow diagrams, screen mock-ups, SQL Queries, spreadsheets, and process models. Utilized data analysis skills to map and reconcile data issues.

The requirement to store all medical information as Electronic Medical Records (EMR) by the year 2020 is mandated by the Federal Government and is a driving force for developing new procedures that are to be used in the organization.

Used Excel, EDI, SQL, C#, ASP.NET, HTML, CSS, JSON, CRM SDK, and MS Servers on a regular basis to manipulate large datasets, generate reports and charts for review, and I develop some dashboards used for data and systems analysis. Also, worked with Web Access software that allow interaction between systems.

Developed and reviewed System Flow charts and diagrams for use in the technology group.

Met regularly with experts (and Vendors) from various parts of the country and managers to determine the best solutions for the security and future processing of computer systems used at the medical facilities tied to the company.

Developed several Requirements (BRD and FRD) documents to describe the detailed work needed to accomplish the activities required within the organization.

Federal Protective Services (DHS) /E3 Federal Solutions, New York, NY 3/2016 to 9/2017

Management/ Business Analyst

Responsibilities/Accomplishments:

Worked with management staff of the Federal Protective Service (Dept. of Homeland Security) and oversaw the development and publishing of Facility Security Assessment (FSA) packages for government facilities in the Northeast Region (Active Security Clearance obtained).

Utilized computerized security system MIST (Modified Infrastructure Survey Tool) to identify facilities that are scheduled for assessment.

Developed systems (Excel/Access/SharePoint/PowerPoint) with SQL, VBA, C#, MS Dynamics, Dot.Net, and other tools to analyze and present information on work in progress. Large volumes of data were processed to get results.

Conducted Quality Control review on individual assessment packages to ensure compliance with higher levels of government regulations.

Participated in Panel Reviews(walk-thru) to identify and correct issues with specific assessments.

Met with the Chief of Risk Management and Commanders to discuss problems and determine solutions.

Deloitte Consulting/eTeam, Harrisburg, PA 7/2014 to 4/2015

Systems Development Analyst/Consultant

Responsibilities/Accomplishments:

Performed contract assignment with the State of PA IT Department to do analysis and develop new software to provide healthcare benefits to individuals as specified in the Affordable Care Act.

New processing and software projects to manage this initiative were developed to meet given timelines using Agile methodology, and Web access software.

Met frequently with user and programming groups to solve problems, participate in UAT testing, and write specifications to describe the work to develop and implement software.

Developed Software for the Healthcare system processing on z/OS and IBM MVS mainframe (Batch and Online) using COBOL/JCL/CICS, JCL, Cognos, MQ Series, ETL, DB2/SQL, IMS, and VSAM databases.

Developed Application Programming Interface (API) modules for use in systems interfaces with C#, JSON, T-SQL, C#, HTML/CSS, CRM SDK, ASP.NET, jQuery, and JavaScript.

Used SQL to process data for analysis and used Tableau for data presentations. And, performed analysis using data from the local data warehouse to identify trends and confirm relationships.

Worked with the Project Manager to develop the Functional Requirements document to describe the system changes that would be made to complete Healthy PA project.

Met with the Users (managers) and systems development staff to discuss project status and resolve day-to-day issues.

Workable agreements would be documented, and the solutions communicated to all members of the group.

Developed System Flow Diagrams (using Visio) to show the sequence of processing that would be used to accomplish the desired processing.

Also worked with the User Acceptance Testing group to ensure that the software implemented was working correctly.

MVP Consulting Inc./IT Department of NY State, Albany, NY 7/2002 to 10/2013

Business Analyst/IT Consultant

Responsibilities:

Provide systems analysis, data analysis, new development and maintenance functions (NY State, Dept of IT) for the SSPS and other financial systems using Agile methodology.

Programs are written in COBOL/UCOB for SSPS and WMS on Unisys 1100/2200 mainframes. Software used include DPS, CIFS-2200, SSG, SORT and MAPPER.

SSPS is a large financial management system used by the state of NY to make payments to vendors. Risk management principles were employed to safeguard the integrity of electronic and standard payments on a weekly basis to multiple vendors.

Ensure the SSPS system comply with State regulations on payments for services.

Worked with the department managers to develop several Business Requirements Documents (BRD) for the various projects that I worked on.

Once the Business Requirement Documents were finalized and sign-off obtained, I continued to work with other analysts and development staff to develop Technical Requirements documents that showed the details of system changes needed, and new processing decided on.

Developed Use Case documents and recorded User Stories for use in system development and documentation.

Participated in User Acceptance Testing activities and helped to obtain User Sign-off on projects prior to production implementation.

Accomplishments Include:

Work with users to develop new procedures and techniques to accomplish objectives.

Write new Systems Requirement documents to describe applications to be developed.

Test and correct software to ensure accuracy (QA), and to achieve business needs.

Trained new State employees to become effective in the programming environment.

Do analysis and design work to build new applications for the user community.

Develop Access and C/C++ software (OOD) for use with data presentation and reporting.

Trouble-shoot problem situations to find source and fixes for problems (UAT).

Used MS Windows, Word, Excel VBA, Project, and PowerPoint to develop new documents.

JP Morgan Chase Corporation (New York City, NY) 9/1997 to 8/2001

Business Systems Analyst

Responsibilities:

Performed hands-on business systems analyst work (as Bank Employee) and programming which included security considerations and the analysis and design of new and modified systems to support the processing and issuance of over four million Chase ATM Debit cards to business and regular-consumer customers.

Risk management concerns were addressed, communicated, and steps taken to mitigate risks.

Software for the card management system (CRF) process on IBM MVS mainframe (Batch and Online) using COBOL/JCL/CICS, JCL, Cognos, MQ Series, ETL, DB2/SQL, IMS, and VSAM databases.

Accomplishments Include:

Managed the development and implementation of a new card system (Logical Cards) that allowed issuance of millions of new ATM cards in the future.

Performed data analysis and data modeling (Use Case) to manage Debit Card processing.

Met with marketing staff and wrote requirements documents for new products.

Developed and tested new COBOL/SQL and Assembler programs to support card maintenance and issuance.

Performed On-Call support for the Card system and resolved DB2/SQL problems daily.

Education:

Bachelor of Science Degree – Information Systems.

Virginia Commonwealth University (Richmond, VA).

Contact this candidate