| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
New York, NY Street Address
PHONE NUMBER AVAILABLEEMAIL AVAILABLESummaryTenured 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/2024Education: B.S. in Mathematics (Computer Science) from Mercy CollegeSkills:User Acceptance TestingProject ManagementData Mining & AnalyticsSAP/Salesforce SolutionsPrototyping / Wire FramingInformaticaPower 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 ComplianceClient ManagementExperience: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. Support or manage 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/2022Business Analyst 12 mo projectWrote 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, developed business contracts identifying Know Your Customer key attributes.Authoritative Data Source datasets were developed for specific LOBs as part of a corporate IT Data Quality data hydration procedurePython 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 timePrecisely New York 02/2016 - 06/2021Business AnalystManages 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 interactionswith 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 projectSorting, 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/2016IT Database Management SpecialistReconciled 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/2015IT Business Systems AnalystEstablishment of project scope, process flow diagrams and Power Point presentation development.Addressed clients 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/2012Business System AnalystDeveloped database projects and documented technical specs for C-Level Non-Profit ExecutivesReconciled financial services offered by three associated non-profit programsExtracted 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 dataUtilized 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 |
