SUMMARY:

• Self - motivated, dedicated, detail-oriented financial IT professional with excellent technical and communication skills.
• Succeeded in different capacities that includes work as Senior Business Analyst, Data Steward Analyst, Data Analyst, Sample Analyst
• Access Administrator and Project Coordinator. Performed Data Management and Data Governance projects, new projects releases, UAT and production support, analysis, and troubleshooting.

TECHNICAL SKILLS:

Software: Microsoft Office (Outlook, Excel, PowerPoint, Visio, SharePoint), JIRA, PostEdge, Informatica, IBM InfoSphere Business Glossary (IBM Information Governance Catalog), ERwin, IBM BlueWorkslife, Collibra, Confidential, AVOX, Showcase, Windows Scheduler, VPN, GotoMeeting, ServiceNow

Databases/Tools: SQL, MS Access, MS SQL Server, Sybase, Monarch, Qlikview, Cognos, Advanced Query Tool v9

PROFESSIONAL EXPERIENCE:

Confidential - Jersey City, NJ

Senior Business Analyst Consultant

Responsibilities:

• Documentation and identification of key data elements, related controls, deficiencies and remediation requirements in liaison with Data Stewards, Data Owners, SMEs and ITs.
• Lineage mapping for trade processing systems through to the general ledger.
• Execution and implementation of the data governance framework consistent with data management requirements for regulatory compliance.

Confidential - Jersey City, NJ

EDM Senior Business Analyst Consultant

Responsibilities:

• Managed data profiling process in conjunction with application development teams identifying critical data elements’ (business terms) requirements and rules.
• Performed data lineage process demonstrating understanding of system data flows and technical platforms.
• Led multiple initiatives ensuring ample value addition in each phase of the project life cycle.
• Used IBM Business Glossary to create, classify and manage the organizational vocabulary and business definitions providing better alignment between business and IT users, greater awareness on the information sources, representation and stewardship.
• Created Flow Mockups in Powerpoint and Visio for Data Quality group to show data flow between Salesforce application and DB2 databases.
• Utilized ErWin to create Conceptual and Logical Data Models, and Logical Data Dictionary.
• Led Client Data migration to Collibra and created new metadata Business Assets, Attributes and Relations establishing policies and standards for governance, improving the quality, traceability.
• Performed KYC Data Quality management, analysis, and cleanup.
• Identified data issues creating SQL queries in MS Access. Performed route cause analysis and recommended solutions for data remediation.

Confidential - Jersey City, NJ

Business Analyst Consultant

Responsibilities:

• 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.
• Initiated and managed the data sources and processes validation tests for independency to indicate and control the data quality.
• Produced Sampling Control Forum forms to be approved for non-statistical sampling methods and data source independence adhering to EIT Policy and Standards.
• Validated Trade Surveillance alerts generated by systems comply with financial regulations.
• Reconciled gaps, overlaps, and inconsistencies in the test documents and recommended remediation.
• 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.

Confidential - New York, NY

Business Data Analyst

Responsibilities:

• 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.
• Collaborated effectively with business users and Subject Matter Experts to formulate optimal business solutions and facilitated development of IT solutions that delivered envisioned business value.
• Supported lines of business by advising on guidelines and providing to address any gaps in Data Management.
• Identified and facilitated opportunities for process improvement to ensure Data Governance delivers sustainable processes.
• Experienced in Data Management practices including data profiling, data dictionaries, and metrics and data quality management tools.
• Proactively assisted Business, Operations, Compliance, and IT management in understanding the impact of business initiatives onData Management processes.
• Controlled and defined data schema to ensure that the information can be accessed and analyzed to the best effect across an organization.
• 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.
• Coordinated the data migration project that presented end result data as Qlikview dashboards.
• Prioritized, scheduled and managed vendor software releases on MS SQL Server UAT and Production.
• 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.
• 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.
• 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 .

Confidential - New York, NY

Data Analyst

Responsibilities:

• Administered Data Migration 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 Management and Data Quality standards.
• Designed and developed custom relational databases in MS Access performing SQL 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 for Middle and Back Office groups. Interacted with business groups to discuss redesign 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.
• Trained and advised users mastering web based E-delivery and Archival application.
• Created scripts and controlled NDM server daily jobs. Modified NDM processes to improve performance. Supported Impact QA files testing on a server.