Data Entry

Diana Melnikov

https://www.linkedin.com/in/dianamelnikov Mobile 347-***-**** *****.********@*****.***

Self-motivated, dedicated, detail-oriented financial IT professional with excellent technical and communication skills and extensive experience working with vendors and vendor packages. Succeeded in different capacities that includes work as Business Analyst, Data Analyst, Sample Analyst, MIS Manager, Administrator and Project Coordinator. Performed new projects releases, UAT and production support, analysis, and troubleshooting.

EXPERIENCE

Bank of America - New Jersey, NJ

Business Analyst Consultant, November 2015 – May 2016

Compliance test sampling, validation for sampling independence and remediation. Responsible for reviewing existing sampling processes to ensure they adhere to the Enterprise Compliance Testing Standards and to recommend remediation actions in instances where standards are not met.

Reviewed Sampling documentation and created Data Collection Plans which identified sampling approach, description of test population data sources, procedures or scripts used to pull the data, and sampling parameters.

Updated SharePoint Workflow Review Tool detecting gaps in documentation for the data source and procedures to obtain the data.

Created sampling procedures’ documents validating BRDs, HLDs, LLDs, and provided an overview of data provisioning process with a focus on individual metrics.

Produced Sampling Control Forum forms to be approved for non-statistical sampling methods and stratification adhering to corporate policies in Data Governance.

Identified the law, rule or regulation such as Volcker Rule, Dodd-Frank being tested by the script.

Validated Trade Surveillance alerts generated by Actimize RCM and other systems comply with financial regulations such as FINRA, SEC.

Provided Remediation recommendations where required.

Coordinated contacts with Global Bank’s Operations and Technology Compliance Group managers and the Test Owners, escalated any risk related issues to management.

Handled communication with the Test Owners to validate the independence of data sources, the time period of data population, statistical sampling frequency, and sampling methodology.

Scotiabank - New York, NY

Business Analyst, 2010 - 2015

Management, analysis, support, testing, coordination, and execution of production and non-production applications with solid knowledge of SDLC process and Data Warehouse architecture. Close work with IT and development staff, and Middle and Back Office groups. MS Access database and reporting knowledge. Strong knowledge of Monarch, SQL queries. Extensive communication with vendors Broadridge, Bloomberg, and DTCC.

Drove implementation, installation, and support of new projects for Middle and Back Office groups to successful completion. The results improved the time efficiency and optimized performance.

Maintained liaison between the business units, technology teams and support teams.

Performed Bloomberg reports and Broadridge BPSA database/BPS reports data analysis according to business rules and use cases to grasp users’ goals and actions.

Managed stakeholders’ work sessions to document BRDs.

Translated high level business requirements into functional specifications and managed the changes on IT and Developers level.

Created and maintained traceability matrixes and gap analysis for process improvement.

Created wireframes in order to ensure that client's requirements and objectives were met.

Coordinated the project that presented end result data as Qlikview dashboards. Users had the ability to visualize data with attractive images, graphs and charts of a high level and create historical or current data what if analysis.

Prioritized, scheduled and managed vendor software releases on MS SQL Server UAT and Production.

Performed Qlikview Administrator role managing user access and reports schedule.

Provided weekly updates, reported milestones and outlined risks and issues to the management.

Translated business requirements into ETL design specifications, ETL testing and troubleshooting issues.

Managed action items of IT Operations to support projects: troubleshooting, deploying improvements and fixes to the network and applications infrastructure according to Data Governance standards.

Coordinated weekly interaction with c-level stakeholders.

Created Runbooks instructing offshore support team. Trained and controlled offshore group work.

Handled Testing Status meetings to discuss outstanding issues with IT, development team and vendors.

Identified and facilitated opportunities for process improvement; escalation of relevant issues.

Managed Field Expansion project that introduced changes to the structure of the South American currencies price field in order to comply with Bank standards. Met and overcame challenges related to modifying an existing database in e-delivery and archiving system PostEdge utilizing data analysis software Monarch, testing canned and customized reports’ models according to Data Governance and Data Quality standards. Communication with vendor to evaluate problem and streamline solution.

Delivered solutions that enhanced efficiency and in multiple cases resulted in monetary savings, saved time and human resources, a fact recognized by company as my personal achievement.

Scotiabank - New York, NY

Data Analyst, 2000 - 2010

Administered Datapump reports project using BI tool Monarch from client side, prioritized fixes. The project had a target to produce unique custom reports for Fixed Income, Equity, Operations, and Compliance groups based on Data Quality standards.

Designed and developed custom relational databases in MS Access performing data analysis, data mapping, and data modeling based on Broadridge reports/database or data entry for Operations, Finance, Equity and Risk Management groups.

Handled stakeholders and technical team members work sessions to gather and analyze data requirements.

Created various custom models in PostEdge – Electronic Document delivery and Archival using Monarch.

Provided control, support, and analysis of reporting upgrades for canned, QA, NYA, and custom reports.

Interacted with business groups and users groups to discuss redesign requirements.

Trained and advised users mastering web based E-delivery and Archival application.

Performed Super Access Coordinator role managing user access to the repository services.

Created scripts and controlled NDM server daily jobs. Modified NDM processes to improve performance. Supported Impact QA files testing on a server.

Pitts Financial Group Inc., New York, NY

Programmer/Consultant, 1997-1999

Development and design of Equity Research Analysis System using FoxPro. The system could automatically generate variety of complex financial reports. The goal was to eliminate the need of direct database access as well as many man-hours demanded by this process. Implementing new custom modules in SBT Executive Series software using PowerBuilder and Sybase. Modifying existing structure and creating new summaries and reports to fit client needs.

Participated in design and implementation of object-oriented application framework for Portfolio investment related products using PowerBuilder and Sybase. Implementation of Portfolio Global Assets Allocation system providing accounts analysis, investment policy development, research sessions. Acted as liaison for all portfolio management departments. Played leading role in creation of LCA class library, the architecture process, and base objects inheritance implementation. Developed set of business systems including Global Master Optimizer with external functions calls from custom DLL.

Designed GUI with scripts in PowerBuilder, stored procedures for Sybase. Created triggers to keep large-size tables synchronized.

Customized existing reports according to the functional specifications including General Ledger, Accounts Payable, Sales Orders, and Inventory Control reports.

Development of standard objects for error handling.

Developed data maintenance screens. Performed query optimization.

Touro College, New York, NY

Admission Assistant, 1995-1996

Coordination, control and maintenance of data processing computer system. Installation and supervision of numerous software and utilities to automate tasks. Insurance of accuracy and security with all Data Entry input and output.

COMPUTER SKILLS

Software: Microsoft Office (Outlook, Excel, PowerPoint, Visio, SharePoint), JIRA, PostEdge, Informatica, DTCC, Showcase, Windows Scheduler, VPN, GotoMeeting, ServiceNow.

Operating Systems: Windows8/7/Vista/XP

Databases/ Tools: SQL, MS Access, MS SQL Server, Sybase, Monarch, Qlikview

Methodologies: Waterfall, Agile, UAT Testing, SDLC, CRM, OOAD

STRENGTHS

Self-motivated, dedicated and strongly organized.

Have in depth knowledge in the respective subjects.

Strong ability to reach goals.

Attentive and understand the criticality of resolving production issues.

Detail-Specific.

EDUCATION

Odessa State Academy of Technology, Odessa, Ukraine

MS, Automation Technology and Electrical Engineering

Contact this candidate