Business Analyst Project Management
Resume:
VICTOR T. MARTINEZ
New York, NY *****
ad69d5@r.postjobfree.com
Summary
Tenured Business Analyst with 15+ years in experience supporting business solution software. Successfully analyzed and implemented new business operations for executives. Proactive and personable leader with top-notch skills in streamlining information, project management, and approaching issues with an analytical mindset. Excellent skills in documenting Business Requirements Document (BRD), Functional Requirements Document (FRD), System Requirement Specifications (SRS), Use Cases and Test Cases.Bringing years of experience with a consistent track record of success.
Currently pursuing Project Management/SCRUM certification- 6/2024
Education: B.S. in Mathematics (Computer Science) from Mercy College
Skills:
User Acceptance Testing
Project Management
Data Mining & Analytics
SAP/Salesforce Solutions
Prototyping / Wire Framing
Informatica
Power Point presentation (PPT)
Integrated Reporting Information System (IRIS)
SQL, PL-SQL, Oracle, Crystal Reports, Excel Analytics, QAD, VBA, Microsoft SharePoint, C#, Java script, VB script, Banking Regulatory Compliance
Client Management
Experience:
Dept. of Education. Brooklyn, NY 10/2023– Pres.
• Evaluate existing reporting methods, recommend improvements, and implement authorized changes; develop new reporting methods based on assessment of new reporting requests.
• Analyze and organize large sets of purchasing and contracts data using Microsoft Excel, and SQL.
• Analyze and summarize data into presentations for all levels of staff and leadership with data visualizations and written reports.
• Lead data cleaning and standardization efforts in Contract Tracking System (CTS), including ongoing data quality reviews.
• Improve tracking systems for new and replacement procurements and track progress and cycle times of procurements currently underway.
• Discussed the significance of incorporating Data Governance tools like Collibra and Informatica for enhancement of data quality specifically regarding accuracy and completeness.
Support a variety of special projects that require a high degree of research, analysis, strategic thinking, and problem solving.
BNY Mellon New York 10/2021 – 12/2022
Business Analyst – 12 mo project
Wrote Business Functional Specification Documents (BFS) to advise external team members of system architecture modifications.
To maintain compliance with banking regulatory standards, routine monitoring of data at rest and in-transit was employed via regular expression algorithms implemented in email and database servers.
DCP policy was strictly enforced and reviewed for data integrity.
Using Collibra/Informatica, reviewed business contracts identifying ‘Know Your Customer’ key attributes. Trend analysis on clients critical data elements were verified via Informatica’s data measurement dashboard.
Authoritative Data Source datasets were developed for specific LOBs as part of a corporate IT Data Quality data hydration procedure.
Python was implemented for Excel xl function to modify existing ranges in regulatory queries.
Modified existing Microsoft Access/Oracle dashboard to include additional business metrics for Wealth Management data model. Enhance existing architecture utilizing WM datasets.
Hydration procedure requires AML, CM and additional regulatory data be included as attributes for datasets in migration process.
Engaged in routine communication with fellow data stewards, data leaders, data owners and IT software developers via AGILE methodology to ensure projects were completed on time
Precisely New York 02/2016 - 06/2021
Business Analyst
Manages four major software systems and upholds maintenance.
Ensured monthly reporting for corporate accounting, funds disbursement for AP, order management and report services were available via Crystal Reports.
The QAD Account management system was utilized as the main platform to monitor all AR/AP transactions including G/L, funding disbursement, etc. Responsibilities included previewing initial accounts received and ensuring reports listed key metric components necessary to post account to GL.
Provides DBA-based responsibilities to ensure existing software is available to global users.
Creates/modifies Oracle scripts via Oracle client, document management ensure all daily records accounted for. SQL Tools, SQL Developer were utilized as well.
Managed development phase UI Design team in all phases of the Development, clearing expectations with help of various Wire-framing tools.
Utilizes Microsoft SharePoint Workflow owner and facilitates users entering customer invoice orders.
Administrates QAD application for order-entry, reporting and forecasting.
Exports QAD data to Microsoft Great Plains system in UK.
Monitors UNIX-based environment to ensure QAD production and synchronized data (chron-job) backups are performed nightly.
Updates SalesForce renewal-based accounts in SAP to system-generated version.
Identifies key growth and contribution opportunities for business through descriptive statistical review and trend analysis.
Conducts operational efficiencies and gathering requirements for feasibility review of software procurement.
Was responsible for gathering requirements both functional and non-functional based on interactions
with the process owners and business team.
Prepares business cases for software-related procurement.
Managed data integration projects including Oracle ERP & Oracle Netsuite (smaller corp. with less components) and served as primary liaison between internal groups and client. Managed data migration from Microsoft Dynamics 365 to Oracle NetSuite.
Conducts root cause analyses to formulate countermeasures to business missteps and improve operations.
Provide monthly frequency count of ‘posted’ G/L account attributes and statistical summaries via Python.
Enhanced new system via data migration integrating SSIS & Talend for data cleaning and ETL migration project
Sorting, parsing algorithm for Excel key metric data created.
Pinpoint inefficiencies in business processes and recommended improved policies.
Michael C. Fina New York 07/2015 - 01/2016
IT Database Management Specialist
Reconciled award recognition data for various clients.
Utilized Talend and SQL queries to manage data files received daily for subsequent upload to client(s) website.
Developed, maintained, and reported essential data analytical assignments.
Cleansed invoice files of invalid characters and updated to SFTP server via SSIS Participated in routine daily meetings to discuss current assignments and modifications to existing workload.
Attended touch point discussions with account managers to ensure coding is up to date with client's expectations.
Provided UAT environment for code testing and design changes.
Wrote documentation, program manual(s)/DDR specific to each client.
Developed macros in Excel/Access 2010 for required reports.
Caturra Coffee Westchester, NY 10/2012 - 06/2015
IT Business Systems Analyst
Establishment of project scope, process flow diagrams and Power Point presentation development.
Addressed client’s research needs and reported deficiencies.
Optimized their data assets and provided tools for them to extract key consumer insight from survey data so that they could strategically align the coffee product with modern consumer expectations.
Operated corporate databases and addressed technical deficiencies to optimize the data systems.
Filtered, analyzed, and extracted key metrics that to provide data insights for client.
Designed the UI of the application, prototyping and wire framing in MS Visio for better illustration of the Generated wireframes and prototype for the GUI.
Facilitated the launch of products through research deliverables and reporting analyses.
Utilized Crystal Reports to develop reports for management and other end users Modified existing front-middle and backend code to include latest product, equipment etc.
Designed hashing algorithm for password security identification Developed queries to ensure data integrity Identified/analyzed multiple elements necessary for determining new products, product design, product packaging, via Excel SPSS, etc.
Harlem United New York 11/2007 - 07/2012
Business System Analyst
Developed database projects and documented technical specs for C-Level Non-Profit Executives
Reconciled financial services offered by three associated non-profit programs
Extracted data via SSIS from multiple folders and perform statistical test on aggregate data Utilize C#, LINQ, WPF/ADO.Net with SQL 2008, SSIS and SSRS in developing small to medium sized apps for data entry log & maintenance purposes.
Designed SQL queries, stored procedures, functions, and tracked services provided by inferential report data.
Analyzed business requirements and segregated them into Use Cases. Created Use case diagrams using MS Visio.
Generated multiple pivot tables, v-look up tables from data archives to ensure funding guidelines were met.
Reviewed financial expenditures and medical/nutritional data
Utilized C#, LINQ, WPF/ADO.Net with SQL 2008, SSIS and SSRS in developing small to medium sized apps for data entry log & maintenance purposes.
Designed SQL queries, stored procedures, functions, views Tracked services and provided inferential data report.
Developed client-services application to track body metrics
Contact this candidate