• Liaised with other analysts, project managers and customers to evaluate, create, and deliver propertytaxation solutions.• Liaised with the customer's subject matter experts to attain a thorough understanding of contractual requirements.• Analyze, map/convert source to target data and support the system data conversion from the customer's current system to the new managed service MicroSoft Azure data warehouse.• Lead source to target data mapping with customers and… Show more • Liaised with other analysts, project managers and customers to evaluate, create, and deliver propertytaxation solutions.• Liaised with the customer's subject matter experts to attain a thorough understanding of contractual requirements.• Analyze, map/convert source to target data and support the system data conversion from the customer's current system to the new managed service MicroSoft Azure data warehouse.• Lead source to target data mapping with customers and implementation engineering teams to translate data from source system into standard import table layouts.• Create complex SQL Server queries and stored procedures to map data into target manager service Microsoft Azure Data warehouse.• Create and document bug and requirement user stories in Azure DevOps.• Worked with implementation engineering to ensure data is imported correctly.• Provided quality assurance for imported data using validation scripts and regression testing.• Configure and test the implementation of the Aumentum suite of products.• Compose documentation on SharePoint to address newly added or modified functionality.• Triaged customer-reported defects throughout the conversion/implementation and Go Lives. Show less

Work with the business to understand their data needs to develop and implement solutions in the Enterprise Data Services Organization environment (Data warehouse, Data Marts, Data Lake, Data Enclave and Big data)Gather, analyze, profile and map data into the Enterprise data services organization to meet reporting and analytical business needs.Data SME liaison between the business and IT teams

Develop metrics and reporting to assess performance and impact to client and customers' business, and evaluate planned versus actual results. Create queries and run reports in support of Account Management and their client reporting needs for debit, credit, and commercial products. Provide analysis of client and customers business and operating practices. Develop business case scenarios and models that quantify financial opportunity and evaluate the business, technical and systems feasibility… Show more Develop metrics and reporting to assess performance and impact to client and customers' business, and evaluate planned versus actual results. Create queries and run reports in support of Account Management and their client reporting needs for debit, credit, and commercial products. Provide analysis of client and customers business and operating practices. Develop business case scenarios and models that quantify financial opportunity and evaluate the business, technical and systems feasibility of their implementation through financial analysis and internal and customer research utilizing Micro strategy. Gather detailed requirements and reverse engineer an existing application utilizing Microsoft Access to a Micro strategy environment. Evaluate Complex issues, determine key drivers and identify performance/process improvements. Show less

Business Analyst/Data Warehouse AnalystWorked in the Corporate Data Warehouse (CDW) on multiple projects involving Mortgage-backed securities data, including Single Family Profitability Data Mart, Multi-funding Analytics (Fannie Mae, Freddie Mac and Ginny Mae MBS’s), Collateralized Mortgage Obligations (CMO) and Prepayment Analytics, Fees and Billing from PeopleSoft, Generally Accepted Accounting Principles Guarantee-fee (GAAP G-fee, FAS140/FIN45, Roll-forward), Guarantee Assets/Guarantee… Show more Business Analyst/Data Warehouse AnalystWorked in the Corporate Data Warehouse (CDW) on multiple projects involving Mortgage-backed securities data, including Single Family Profitability Data Mart, Multi-funding Analytics (Fannie Mae, Freddie Mac and Ginny Mae MBS’s), Collateralized Mortgage Obligations (CMO) and Prepayment Analytics, Fees and Billing from PeopleSoft, Generally Accepted Accounting Principles Guarantee-fee (GAAP G-fee, FAS140/FIN45, Roll-forward), Guarantee Assets/Guarantee Obligations (GA/GO), Aladdin Blackrock, SOX Reconciliation/Attestation and Selling Representations and warranties.• Liaison between Business areas and the Data Warehouse development team, identifying business rules for extraction, transformation and loading (ETL) of data, gathering and documenting data and business requirements.• Source to target mapping, maintaining metadata repository (data dictionary), assisted data analysts with data modeling and design of physical database, reviewed and validated Relational and Dimensional Data models.• Gap analysis, impact analysis, data profiling, data analysis, identifying data sources, identifying and resolving data quality issues.• Created System Development Methodology documents and ensured data warehouse standards were followed. • Responsible for integration testing, regression testing, and system testing and assist in user-acceptance testing.• Tracked and resolved problems/issues that required interacting with various Business Area Subject Matter Experts (SME's) other Business Analysts and support personnel. Would look beyond the obvious and don't stop at the first answers, probe all sources for answers, pay attention to details and look at the big picture.• Created complex SQL, used SQL to answer business questions and summarize/explain data differences, created and assisted in the development of Technical Data Quality (TDQ) reports involving source and target data. Show less

Business Analyst/ Technical LeadWithin the Information Reporting and Data Management Groups performed a variety of Roles (Lead Technical Analyst and Business Analyst) on several projects, including the RBC Centura Data Mart (Teradata), Web Banking Conversion and Ad-hoc Reporting.• Responsible for coding, testing, providing technical support, and assisting in user-acceptance testing.• data assessments, data profiling, data analysis, identified data sources, identified and resolved… Show more Business Analyst/ Technical LeadWithin the Information Reporting and Data Management Groups performed a variety of Roles (Lead Technical Analyst and Business Analyst) on several projects, including the RBC Centura Data Mart (Teradata), Web Banking Conversion and Ad-hoc Reporting.• Responsible for coding, testing, providing technical support, and assisting in user-acceptance testing.• data assessments, data profiling, data analysis, identified data sources, identified and resolved data quality issues.• Identified business rules, gathered and documented data and business requirements.• Assisted data architects with data mapping and reviewed/revised Entity Relationship diagrams (ERD).• Created System Development Methodology documents as needed. • Generated and validated ad-hoc reports from business requests.• Tracked and resolved problems/issues that required interacting with Business Units, other Business Analysts and support personnel.• Worked on a variety of applications including Web Banking, Customer Information System (CIS), Deposits (IMPACS), Savings/Time, Retail and Commercial Loans, ATM and Credit Cards.Programmer Analyst/ Project LeadWorked on an Internet Consumer Banking System. This project was an upgrade of a Vendor Software Package on the front-end utilizing MQ-SERIES as the middleware to interface with the Back-end Mainframe Systems. Project leader on a project to implement Electronic Remittance of Bill payments for Credit Cards initiated by Check free through ACH. Member of Core Team on a project to convert the Credit Card System from FDR to TOTAL SYSTEMS (TSYS).• Responsibilities were the monetary interfaces and monetary downstream processes.• Coded, tested, analyzed requirements and interfaced with clients including ACH, IMPACS, TPA (loans), G/L, ATM, VRU and other financial and marketing groups Show less

7/99 – 5/00Senior Programmer/AnalystSales Incentive System.• Responsibilities included analyzing client change request requirements, recommending solutions, coding, and system testing.• Implementation of solutions, performance tuning of DB2 programs, loading and unloading DB2 tables, importing/exporting DB2 data.• Troubleshot and did problem tracking that required interfacing with clients and other support personnel.