Manager, Financial Systems - It Resume
SUMMARY:
Seasoned professional with a strong technical background and a deep understanding of all aspects of the business landscape. History of success in roles ranging from systems development and support to operations management to data mining, integration, warehousing, analysis and visualization. Focus and passion for contributing to and leading BI projects partnering business users and management with IT resources to solve complex data collection, storage, integration and presentation challenges.
TECHNICAL SKILLS:
Databases: Oracle, Teradata, Netezza, SQL Server
Languages: SQL, PL/SQL, T - SQL, Unix Scripting, VBA
ETL/Data Integration: HVR for Teradata, TOAD DataPoint, SQL Server SSIS, Informatica
Presentation/Visualization: Tableau, Qlik Sense, Cognos, Business Objects, TM1
General: ETL, SDLC, Database and Data Warehouse design, Data Modeling, Data Governance, Master Data Management, JIRA
PROFESSIONAL EXPERIENCE:
Confidential
Manager, Financial Systems - IT
- Manager on team responsible for the installation, configuration and operation of the TAS platform and peripherals including Erwin data modelling tool, HVR replication utility, Teradata Workflow Manager and Qlik Sense data visualization.
- Worked with vendors, DBAs, report developers and users to document and streamline data ingestion process, model data mappings, validate data, resolve issues and enhance overall performance.
- Created automated solutions using Unix shell scripting, Oracle SQL and Teradata TPT/BTEQ utilities to provide statistical analytics and visibility to performance metrics and gap analysis.
- Worked with vendor, business analysts and end users on installation and integration of Qlik Sense data visualization tool with underlying Teradata model.
- Provided back end support for legacy Business Objects ledger report environment.
- During merger of XO to Confidential, led team that created the initial data feed of XO revenue system data in to the Confidential warehouse reporting environment.
Confidential
Senior Manager, Financial Analysis and Reporting
- Managed team in the collection and distribution of key analytical data to support business intelligence, executive level revenue analysis, KPIs and financial models for functional areas including: Accounting, Planning, Customer Care, Billing, Sales, Product Management, Tax and Regulatory.
- Managed development and maintenance of automated data collection/distribution processes to support executive level and business unit analytics, leveraging tools including Oracle, SQL Server, Netezza, TOAD Datapoint and Tableau.
- Successfully led the migration of automated ETL processes from SQL Server 2000 DTS driven platform to 2008 R2 SSIS platform, as well as the re-engineering of automated report distribution from TM1 and Excel files via email to web-based delivery via SharePoint and ultimately interactive visualization via Tableau.
Senior Manager
Confidential
- Led project with Confidential to design and implement a billed revenue data mart in Oracle and Netezza to capture all billed line items from 4 separate billing systems and store in a single standardized star schema table structure via Informatica.
- Integrated data from Customer Care, Building Inventory, Network Provisioning and Cost systems in to the revenue warehouse to provide critical strategic visibility to customer, market and product profitability metrics for all levels of users.
Manager, Business Systems Analysis
Confidential
- Developed and managed SQL Server warehouse environment which executed ETL processes via the job scheduler to extract billed revenue and cost detail from Oracle source schemas via DTS packages firing SQL and PL/SQL scripts.
- Worked directly with end users and management to development, maintain and distribute ad-hoc and automated reporting which drove key corporate level and business unit analytics, leveraging tools including Oracle, SQL Server, and Access with VBA.