CAREER OBJECTIVE:

IT, Finance or Operations as a MIS Manager, or Database Designer that utilizes my extensive technical skills and strong background in project management experience and/or business analysis or technical support and automation.

SUMMARY:

• Financial background, providing guidance and direction to staff; including setting performance standards and monitoring activities.
• Analyzing internal processes and planning or implementing procedural and policy changes to improve operations. Model development to analyze and forecast market trends and Project Management.
• Extensive knowledge and experience in application development and administration, Oracle Hyperion Essbase 11.1, 9.3, 7.5, 6.5, MaxL, EssCmd and Batch Script development for Automation. Developing ASO and BSO applications, SQL and flap file Load Rules and complex Calculation Scripts. Stored procedures with SQL and SQL Table and View creations
• Designed built and implemented automation solution to retrieve source data from various AR platforms, while building strong valuation tools to ensure data accuracy and integrity via VBA macro creation
• Designed and built integrated Essbase Databases to house all credit and reserve information for 26 international and US markets. Built complex calculations to consolidate and report all key metrics in USD by applying Exchange rate rules and development of Essbase Currency databases.
• Worldwide reporting of credit metrics with the development of complex financial metric definitions and calculations.
• Built capability to fully automate reporting for our business partners, dramatically improving the report generation time frame and provided additional flexibility for end - user ad-hoc reports
• Provided end-user training worldwide
• Change Management, Product Lifecycle Management, Agile Scrum and Rally SDLC Development cycle methodology
• Salesforce Report Development, Oracle SQL, TSQL, MySQL, Data mining, SAP Business Objects using WEBI, Rich Client, Xcelsius Dashboard
• Extensive experience in the following software applications with the ability to enhance business information and analytical needs: Project Management, Microsoft Project, Hyperion Essbase Certifications 6.5, 7.5, 9.3and 11. FMIS/OFSAA reporting, Toad, SQL Server 2000, SAS, Microsoft Server 2003, V.B 6.0, VB.Net, Crystal Reports, SharePoint site development using libraries, views and metadata, XML, ASP and .Net updates, Power Point, Word, Excel, Access, Visio and NT Operations, PageMaker, FileMaker Pro, FoxPro, MS Outlook, DOS Utilities and numerous WMS systems, company specific programs and training end-users.

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, Az

Senior Business Systems Analyst

• As the Senior Business System Analyst was responsible for analyzing data from Confidential financial systems to deplore to new software Platform
• Deep data analysis, SME on Data and reconciliations were part of my daily operations.
• VBA, SQL and system knowledge were key factors in my day to day Scrum Stand-up engagements

Confidential, Phoenix, Az

Senior Business IT Analyst

• As the Senior Business IT Analyst for the Absence Management (AM) team some of my core responsibilities are: Extracting data from PeopleSoft via SQL Developer, Access and VBA to drive automation for independent AM Audit testing.
• Data mining to ensure accuracy in reporting
• Developing and maintaining complex Excel workbook for AM Audit and resource planning.
• Driving the Automation project to delivery Automation solutions to AM Audit team for production improvements.
• Resolving complex data issues to get core requirements to perform independent Audits

Confidential, Scottsdale, Az

Senior Business Intelligence Analyst

• Client facing role responsible for working closely with both internal teams and external customers to define and produce program reports
• Designed, create and implement reports to analyze and display data for all assigned projects and client requests utilizing SQL, SalesForce, and Business Objects.
• Ensure reports are scheduled, audited and delivered according to client expectations and established Service Level Agreements (SLAs).
• Dissecting and deriving solutions to business or technical problems
• Dashboard development via SAP WEBI, BO and Rich Client
• Report analysis/development via SalesForce
• Deep dive analytic using Oracle SQL via Toad for Claims, Call stats, Benefit analyst, adherence, and triage
• SME on Medical transaction analytics metrics and reporting
• Agile scrum work environment, user story development and processing

Confidential, Phoenix, Az

Senior Software Engineer Consultant

• Hyperion Essbase Database Development BSO applications, Calc Scripts and Load Rule creations
• Data mining to identify new key metrics
• Sybase Data extraction for automation to FMIS/OFSAA reporting management tools and Hyperion Essbase via SQL load rules
• End-user training and report automation.
• VBA macro creation to automate and extract data from mainframe
• SME on Financial metrics and reporting
• Agile scrum work environment, user story development and processing
• Process improvement

Confidential, Phoenix, Az

Senior Systems Consultant

• IVT (Independent Validation Testing) Testing remediation compliancy, via SQL Coding using Toad from SQL Server. SQL Tables and View Development.
• VBA macro creation to automate and extract data from mainframe
• Report analytics to show variance and commentary to explain differences.

Confidential, Phoenix, Az

Business Systems Consultant

• Project to Transitioning Automation via VBA from Essbase Add-in to Smart View, Essbase, and Macros.
• Report Creation and Automation using advance VBA macros and formulas
• SharePoint integration with SQL Server
• Enhancing Xml and ASP files for page layout updates
• Enhancing Web parts, Custom page design
• Automation Report triggers in SharePoint
• SQL Coding/Scripting to extra mainframe data for validation and update SharePoint folders and libraries using metadata for view updates.

Confidential, Phoenix, Az

MIS/Finance Manager

• Led development of Oracle Hyperion Essbase solution from concept to completion, including Hardware and software requirements and company wide deployment
• Automation of data retrieval from multiple platforms for the international financial group using Access, Essbase, and Macros.
• Forecasting, Planning and model creation to ensure compliance with Federal regulation
• Database Creation in Access, Hyperion Essbase, BSO/ASO Applications and load rule development. SQL Store procedures and SQL table and view development
• Create advance formulas and Automation tools using VBA, MaxL Hyperion Commands and SQL in Databases and spreadsheets for business reporting.
• Deep dive data mining for key metrics to calculate Risk and Fraud reserve
• Performing Comparative analyses of Actuals, forecast and budget information using Access, Excel and Essbase and SQL Server.
• Coordinate Markets to ensure accurate reporting and use of best practices.
• Procedure development, Audit compliance, SME and technical audit
• Creation of Validation tools to ensuring accuracy or reported information
• Liaison between SOX and department
• Project Management: Installation and migration of New Servers, SharePoint updates migrations, Transition to New Database applications; New Database Development; SharePoint Development, objects, view and metadata updates.
• Product Lifecycle Management
• Managed SharePoint Team sites for Data Repository, system update information, Web parts and Dashboards updates

Confidential, Phoenix, Az

Operations Manager

• Managed the day to day activities of the delivery business for Confidential .
• Employee hiring and budget maintains.
• Maintained P&L, dispatching operation and third-party relationship.
• Managed Equipment Leasing and Vendor selections.

Confidential, Phoenix, AZ

Business Analyst

• Programmed experience in Microsoft SQL, VB, and Access
• Database/Query Creation using Company Mainframe, Access, Crystal Report, Seagate Analyst; Power Point, Excel, word. Also developed VB.Net applications
• Tracked Business Activity & Company goals progress.
• Resolved and tracked employee Activity & Customer issues.
• Ensured continuous federal compliance in reporting practices
• Responded to Audit issues and Process creation and Documentation.

Confidential

Warehouse/Admin/Delivery Supervisor

• Managed the daily administration operation in the following areas: Billing; Pay Roll Processing; Human
• Resource duties, processing Vacation and Leave of Absence request,
• Interviewing, Hiring, investigating employee issues and providing both background and drug testing results.
• Responsible for the daily operation of Warehousing, Shipping, Inventory Control and Quality Assurance, Customer Service, Routing of both installation and Home Delivery teams.
• Responsible for all DOT regulations, weekly and monthly reporting.
• Employee training, vehicle maintains and record retention was also a part of my daily task.
• Responsible for all vendor operations to include monthly vendor meetings for the purpose of improving vendor relations and increasing vendor performance. Hosted quarterly cycle counts and inventory reconciliation. Consulted on all system enhancements and facility improvements

Confidential

Authorization Systems Manager

• Analyst of all data relating to the authorization of all cardholder.
• Recommended system parameters and policy changes based on my analysis.
• Published daily, weekly and monthly matrix reports.
• Performed Ad Hoc reporting.
• Hosted weekly customer service meetings with out-of -State and in-state department heads to ensure that each department was updated on system enhancements and gave each department head an avenue to address customer issues.
• Reported directly and daily to the vice president of operations.
• Developed numerous spreadsheets in Excel and database programs, in Access, that tracked authorizations, customer spending habits and employee incentive. Automated the extraction of this information between Confidential 's mainframe system and PC applications.
• Interacted with Confidential Corporate office to maintenance and ensure continuous compliance.