Giancarlo G. Cerza

*** ****** ******, ***********, ** 28117 704-***-**** ad0x89@r.postjobfree.com

Bank of America – IT Project Manager Support : January, 2023 – Present

Contract. Support for Digital Channels and Payment Trains in SDLC development phases with focus on Planning,Testing, Artifacts and Deliverables . Main areas :ISO,RTP,Fedwire,ACH SWIFT. Worked with all team members ( Jira administrators,Scrum Masters,Project Owners,Reporters) to meet Sprints and Release Timelines. Creation of Dashboards,JQL Queries to track Epics,Stories and Defects in timely manner,meetings with Test Leads and Engineers to discuss environmental issues,constraints, timelines. Posting and creation of Dashboards, MRA Reports, ALM ( Test Cases in Test Plan and Test Runs in Test Lab) .Import and export of ALM Test Runs. Deviations Reports to meet OTA standards to include Activities Categories and defining Acceptance Criteria in Userstories. Review of E2E, Regression Tests, Sanity (Validations), SIT, UAT ( Performance). Experienced in Java Script,Python and SQL. Previous Experience in C. Full Cycle SDLC.

Testing: Splunk, API Testing ( Postman). In process of achiving certifications for Scrum Master,Splunk and Postman.

Pregel America Inc. Concord, NC: January 2022- December 2022

Reporting Analyst/ Data Analyst: Contract Exporting critical data (ETL) from SAP BI and Oracle to create financial models using SQL (SAP BI Generator), Excel and Python to interpret, validate, wrangle, and model data. Use of data analysis and Solver in Excel to create data, models, regressions, and hypothesis tests. Visualizations of Dashboards via Tableau. Competence in SAS, and Excel (Tasks, Pivot Tables, Lookup). Ability to draw conclusions and findings.

Cognizant, Winston Salem, NC : September 2020 to September 2021:

Data Analyst for Pepsi Inc sub-account. Contract. Responsible for updating daily shipping and order flow. Inbound Call Center to meet KPIs and data gathering.

DATA ANALYST LSEG-LONDON STOCK EXCHANGE-FORT MILL, SC FROM 08/2017-8/2020;

Classifications Team. Responsible for classifying via Industry Classification Benchmark listed and non-listed financial instruments, using ICB and NICB to meet Russell Index requirements. Use of identifiers such as Sedol, Exchange Codes, ISIN, CUSIP, Ric. responsible for updating data files and eliminating errors. Use of vendor-based software like renaissance capital, IDS, Uni Vista, Thompson Reuters Eikon, Bloomberg, and FactSet. Update and retrieve information via SQL. Reconstitution of indexes and focus on corporate events like mergers, acquisitions, and demergers.

ESG Analyst. Responsible for reviewing and updating Environmental, Social and Governance data of listed companies from company filings, codes, documents to meet investor and industry demand on socially responsible, thematic and impact investing. Main focus on Paris Accords with focus on stakeholder relationships within organization. Emphasis on updating Index, Sector and Industry analysis. Additional responsibilities included reviewing international initiatives and legislation.

CUSTOMER SERVICE- ANALYST UNITED HEALTHCARE -CONCORD, NC 11/2015-07/2017;

Customer Service Line for Medicaid recipients to include explanations of benefits and services provided by the Affordable Care Act.

DATA ANALYST FEDEX EXPRESS CANADA-CONCORD, NC 11/2013-07/2015;

Shipping analyst and customer service for FedEx Canada Responsible in monitoring accounts, promote services. Responsible in monitoring profitability, volume, delivery, accounts payable, logistics. General Ledger duties. Updating spreadsheets, Salesforce and Beta terminals. Analysis of cash flow and profitability. Focus on domestic and international shipping which emphasis on regulations and trade agreements.

RECOVERY ANALYST APEX ANALYTICS- GREENSBORO, NC FROM 07/2013-10/2013;

Account Analyst with emphasis on retrieving credit memos, returns, remittances, from backdated invoices. Responsible to determine root cause of account imbalances, adjust and update account activity in order to determine profitability, cashflows and credits.

FINANCIAL ADVISOR-ANALYST WACHOVIA SECURITIES-LOS ANGELES-CHARLOTTE FROM 08/199*-**-****;

Capital Markets advisor to corresponding international banks(BUY SIDE)with emphasis on equity, fixed income, derivatives (SWAPS) and currencies. Focus on international portfolios, assets classes, correlation, and liquidity constraints. Valuation of risk and return, risk assessment and rebalancing portfolios. Exposure to FASB, IFRS accounting, risk management (credit risk, counterparty risk, pricing risk). Analysis of measurement. Prime Brokerage Accounts.

Analysis of standard deviation, duration and Vale at Risk. Exposure to foreign asset classes, currencies, commodities and indexes. Use of Greeks. Advanced knowledge of settlements, security identification (CUSIP, ISIN), middle office functions with trade capture, P&L. Delivery via DTC, CLEARSTREAM, EUROCLEAR, CEDEL, SWIFT and FEDWIRE. Advanced knowledge of regulations to include BASEL I, II and III AML’s, company filings and disclosures. Bloomberg and Reuters.

SPECIAL SKILLS SOFTWARE AND TECHNOLOGY

Advanced Quantitative Methods and Mathematics to include Statistics (Inferential Analysis). Financial Analysis and Accounting to include IFRS and FASB Reporting. Capital Markets and Banking (SWIFT, ACH, CEDEL, FED WIRE). Microsoft Outlook, Word, Excel, Access, Edge. SAS, R, MATH-LAB, SAP BI- BLOOMBERG, SHARE POINT, MATTERMOST, BROADRIDGE, SALES-FORCE, JIRA, TABLEAU, AGILE (SDLC, Waterfall and Scrum).

TECNOLOGY: ALM (Application Lifecycle Management), SQL, JQL, CONFLUENCE, PYTHON (LIBRARIES), ORACLE VISUAL STUDIO, NODE, JAVASCRIPT, GITHUB, POSTMAN, UNIX, LINUX, C++, SPLUNK, SELENIUM, ITIL.

Education

·Masters: Finance – New England School of Business and Finance (2011)

·Bachelors: Economics – SUNY -State University New York -2008

·Liceo Classico Virgilio- Italy 1984

COMMUNICATION

·Fluent in French, Spanish and Italian (FAO Proficiency Level). Portuguese (FAO Level B).

INTERESTS

Data Analysis and Technology. Coding.

Contact this candidate