Manager, Finance Services II Resume

SUMMARY:

8 years’ experience with relational database systems design and business intelligence data warehousing and reporting
16 years’ cumulative experience in software design and development
Strong cross - functional technical and business communication skills

TECHNICAL SKILLS:

MS SQL, Oracle
SSIS, SSRS
Strong SQL skills

PROFESSIONAL EXPERIENCE:

Manager, Finance Services II

Confidential

Define and implement strategies for extracting, transforming and loading data from multiple data sources into enterprise data warehouse
Consult with business/collaborate with business analysts on business requirements definition
Lead BI application design and development
Create and deploy reports
Configure, deploy and maintain database servers
Write relational and multidimensional database queries
Understand stakeholder business needs/requirements and transforming the information into meaningful, graphical representations using a BI tool
Serve as Subject Matter Expert (SME) and “Go-To" person for BI product line
Support and enhance the Capital Reporting and Forecasting Tool (CRAFT) utilizing SSIS, SSAS, SQL, T-SQL, Stored Procedures, SAP and Excel
Support the ongoing business processes for the Foodservice “PLUS” planning and reporting tool
Support Planning & Forecasting System Upgrades, Enhancements, and Changes
Address Known Internal Control Risks in Planning and Forecasting Systems
Support and Created Management Reporting system tools and processes
SQL Server Database Administration and Development along with Oracle connection to the PLUS system
SSIS Package Development and Administration for process improvement on various validation steps and reporting by developing or enhancing new tools as necessary

ETL / Database Administrator

Confidential

Engineered and executed an ETL process for a large scale transaction processing system
Modified and monitored existing DTS production jobs that produced and distributed over 50 manufacturing reports on a daily basis
Implemented and monitored over 50 electronic files into monthly databases
Facilitated the implementation of stored procedures using SQL and the deployment of enterprise-level data integration and data transformation solutions using Microsoft SQL Server Integration Services (SSIS)
Developed logical and physical data models data flows using SSIS
Designed and deployed the ETL process which is used to transfer data from Oracle databases to a consolidated SQL database repository
Designed and deployed SSIS applications which use stored procedures to extract and transfer data from MS SQL tables to FTP sites and various internal and external client sites
Analyzed and served as team lead with developers in the design, code review and implementation of a Payment Card Industry Data Security Standard ( PCI DSS) conversion
Designed and developed reporting process for our Quarterly IRS reports
Implemented and improved several processes by rewriting them in SSIS
Prepared regulatory reports that contained critical and sensitive information that was used to ensure VISA/MasterCard compliance with state and federal credit card regulations.
Designed reporting solutions for the business
Led a team of DBAs modifying a constantly growing database application
Maintained the integrity and performance of mission critical databases
Created stored procedures, triggers, and functions
Reviewed stored procedures submitted by application developers, making changes as necessary to ensure consistent performance and availability of the system
Participated in team discussions to design solutions to meet business requirements
Responsible for one of the company’s largest internal applications
Led an initiative to convert legacy VB transaction management process to C#
Improved performance of existing ETL routines over sixfold
Demonstrated expertise in a variety of the field's concepts, practices, and procedures
Reviewed, analyzed, and modified programming systems including encoding, testing, debugging and installing to support an organization's client / server software applications
Assist in managing daily operations of development team and support channels; these include handling build releases and deployments, database deployments, production environment access and user accounts for our developed applications and tool
Updated job knowledge by researching new intranet technologies and software products
Completed applications development by coordinating requirements; contributing to team collaboration; troubleshooting development and production problems across multiple environments; support users and other developers
Follow proper procedures to resolve operational issues
Work to complete all assigned tasks on time with quality and consistency

Desktop Support

Confidential

Diagnosed and repaired internal users’ computers and applications
Set up new user accounts and computers
Managed the support ticketing system

Technician

Confidential

Built computers to customer specifications, from parts in a large warehouse

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship