| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Street Address N. Humphrey Ave.Oak Park, IL Street Address
Mobile: PHONE NUMBER AVAILABLEEMAIL AVAILABLEPROFESSIONAL PROFILEExperienced Data Analyst with a background in managing and analyzing data across various ERP systems, creating/maintaining Excel reports utilizing SQL to perform data quality checks, and collaborating with cross-functional teams to identify gaps in data. Seeking a challenging role in a dynamic organization where I can leverage my skills to drive impactful results.PROFESSIONAL EXPERIENCEAmerican Red Cross, (APN Software Services, Newark, CA)Data Quality Analyst, January 2024 May 2024ContractoroDevelop, document, and maintain data quality goalsoMonitor compliance of data flows against data quality standardsoResolve data quality issues through error detection and correction test proceduresoReview root-cause analysis associated with data integrity issuesoImplement best practices and proceduresoPerform data quality edits and validations to be built into interfaces and systemsoOrganize, direct, manage, and control activities for assigned data quality projectsoFacilitate deep dive sessions regarding common data challenges and trendsAntylia Scientific, Vernon Hills, ILData Quality Analyst, August 16 May 23oCreate and maintain Excel reports utilizing SQL to perform data quality checksoAdminister data loads and maintenance of dataoPartner with international sales team to help guide and assist in customer performance, forecasting and rebate eligibilityoCollaborate with business partners to identify gaps in dataoTrain international peers on roles and responsibilitiesoDevelop and introduce streamlined processes for saving time in validating and cleaning dataoAdministrator for the Customer Information Management (CIM) databaseoMonitoring customer data submissions via AS400 to identify data qualityoReview Quality Control procedures to identify errors in workflowoValidate logic of customer data to ensure that proper entry standards are followed, correcting records to conform to the standard.Urban Partnership Bank, Chicago, ILBusiness/Operations Analyst, July 15 June 16ContractoroCreate spreadsheets, pivot tables, reports, and dashboard from the data extraction of CRM banking systems (Fiserv, Director and Navigator)oResponsible for validating good data and purging invalid/bad data. Collect user requirements and conduct project status meetings to ensure project deliverables are met.oExtensive data cleansing and analysis, using pivot tables, charts, formulas (v-lookups/slicers and macros), data validation, conditional formatting, and graph and chart manipulation.oCreated and developed a database in Access to be used as a quick reference tool for customer service to provide New Servicer contact information to the Borrower(s) of loan(s) sold in the Loss Share Note Sale Project.oAnalyzing data to help upper management make critical discussion on their strategic processes for the note sale project.oDevelopment of project plan, assigning resources to task, tracking progress, and analyzing the workload via MS Project.oAttend weekly meetings with vendors on the note sale initiative and gathering minutes from those meetings to evaluate progression.oSteering Committee, Documentation, and Deal Executives on a weekly basis.oProvide project management and status reporting to the Steering Committee, A&R, Board, and RegulatorsoProvide all FiServ data required for a successful bidBank of America, Chicago, ILOperations Specialist III, Jan15 July 15ContractoroTrack and control the safekeeping of physical securities, letters of credit and other valued assets for GCAS and Collateral Groups which result in organized professional records reflecting current holdings for clients.oSupport domestic and international trade and cash settlement, safekeeping of assets and documents, collection of income (e.g., dividends, interest payments), processing of corporate actions, pledging of securities to third parties, cash payments via SWIFT, and wire and check processing.oProvide Custody support, which can include registrar/transfer agent services, payment services, and client inquiry/reporting services.oReceive free receive and deliver instructions and post into Global Plus (proprietary software)oTransfer securities between existing portfoliosoProcess all vault deposits and withdrawals to GCSO vault; as well as all vault deposits and withdrawals to DTCC vaultJP Morgan Chase, Chicago, ILMigration Data\Transmission Analyst, Mar. 11 Aug. 13ContractoroDrafted effective and thorough system tests with customersoGathered data, requirements and tested new requests from customers (such as changes to the profile before and after they go live in production).oNegotiated quality criteria with customers and clarified use cases for test production environmentoProvided quality check of the customer supplemental setups before going live.oFocused on day-to-day batch operation tasks and deliverables within R1 (RemitOne) implementation batch processing.oDeveloped and executed test scenarios to ensure all customers requirements were tested including creating formats, test batches which includes different test scenarios, sort patterns and apply custom codes to the customer profile setup (edits, exits) if required.oPerformed quality assurance audits to the customer profile setup, format, and test file and test scenarios for any discrepancies to find source of error.oPerformed system testing for new supplemental setups and system production changesoPerformed system configurations of bank lockboxes to ensure that all data within the lockboxes are transformed accurately and according to business rules and/or specifications.oDocumented test results and evaluated results to determine defectsoGain awareness of system application and validate requirements against user expectationsoAnalyzed and resolved moderately to complex issues specific to the batch processes that support the clients processing stream.oSupport developers to design testable code through verification and recommendationsoTroubleshoot and implemented end-to-end test resolutions for quality assuranceoMigrated bank lockboxes from Cash Management Solution (CMS) to R1 (RemitOne) environment after end-to-end testing has been performed, the customers data and image files has been reviewed and approved by the customer.IBM/SPSS, Willis Tower, Chicago, ILMarketing Asset Manager, Sept. 10 Dec. 10ContractorProvide administrative and database management services to IBM/SPSS in order to manage and catalog marketing collateral assets (e.g. brochures, product spec sheets, datasheets, and white papers).oManaged workflow of output from Creative Team into a variety of internal document repositories.oMaintained catalogue spreadsheet of assets, document code numbers and URLsoGained proficiency in Lotus Symphony as well as a variety of internal, proprietary enablement systems.Federal Home Loan Bank of Chicago, IL Jun. 10 Jul. 10AdministratorContractoroContact members of the housing finance institution to review application for loan.oDisburse funds to members.RSM McGladrey, Inc., Schaumburg, ILReport Processing Specialist, Nov. 09 Apr. 10ContractorPrimary responsibilities include the production of financial reports for all Chicagoland locations.oPrepared correspondenceoProofread documents and financial statements for grammatical and statistical errorsoCross checked numbers between financial statementsoCopied and bind folders for distributionFifth Third Bank, Chicago, ILJr. Financial Analyst, May 05 Mar. 09Perform finance activities for Investment Advisors (Wealth Management) Division for Fifth Third Bank Chicago, reporting to Divisional CFO. Provide support to the following four business lines within Investment Advisors: Private Banking; Private Client; Institutional Client and Securities. Responsibilities include:oProgrammed and prepared monthly scorecards using Excel (Input formulas into Excel to assist the CFO in managing the production of the Sales and Investment teams; these reports were done on a weekly, biweekly and monthly basis-using a percent to goal ratio.)oExtensive Excel work using pivot tables and complex formulas to manipulate large data structures.oUse of Excel to manipulate large amounts of data in order to perform data analysis, and preparation of a broad range of reports.oPrepared monthly financial reports and supporting analysis, including graphs, and created graphs to support the monthly scorecards.EDUCATIONMS in Information Systems, DePaul University, Chicago, ILGraduated: June 08BS in Applied Science, Robert Morris College, Chicago, ILGraduated: June 05TECHNICAL SKILLSoProgramming Languages: HTML, SQLoSoftware: MS Office (Access, Excel, Outlook, PowerPoint, SharePoint), Navigator, DirectoroDatabase: Access, SQLoAdobe Photoshop, Macromedia Dreamweaver, FlashoQlik SenseoShowcaseoAS400TECHNOLOGY TRAININGDirections Training: January 2014 November 20142625 Butterfield Road. Oak Brook, IL 60523Microsoft Windows Server 2008/2012oMaintaining a Microsoft SQL 2008 R2 DatabaseoBusiness AnalysisoQuerying Microsoft SQL Server 2012Related Coursework:oCreated business application through real-world case scenarios and practice exercised, including gathering application requirements.oDevelopment toolsoDatabase designoApplication structureoQuery design |
