CITIGROUP TECHNOLOGY INC.
Data Analyst/Business Planning & Analysis Analyst II
May 2014 — Present
Experience with query building and execution, data extraction and mining from Enterprise Data Warehouse, data analysis/trends/metrics, data validation, root cause analysis and business process improvement.
• Data Analysis
o Created and modified SQL queries within Oracle SQL Developer and Microsoft Access to effectively retrieve and analyze data for reporting purposes.
o Extensive knowledge of manipulation of large volumes of data in MS Access, Oracle SQL Developer and MS Excel.
o Created custom front-end reporting tools using Microsoft Access and Excel to assist Account Payable Operations teams to define, improve and deliver metrics and scorecards, perform ad-hoc reports and "deep dive" analysis to document report processes and parameters – on time.
o Performed proactive analysis of database reporting tools and BI metrics on the Procure to Pay Fixed Assets module and Expense General Ledger module on an ongoing basis to further increase efficiency and automation in reporting.
• Data Quality
o Built data expertise and own data quality for allocated areas of ownership.
o Managed data warehouse plans and SLA for all data sets in allocated areas of ownership and identify gaps and inconsistencies.
o Designed, built, and launched data extraction, transformation and loading processes in production.
o Supported and streamlined processes regarding data flow and data quality in production to improve data accuracy, completeness and validity.
o Successfully completed SDLC activities and deployment of approved Procure to Pay Enhancements Requests raised to address gaps in the Procure to Pay supplier maintenance process.
o Worked collaboratively between the functional and development teams to perform testing of BAW test scripts within SQL Developer and Business Objects.