Resume of Analyst/Reports Developer

Title
Analyst/Reports Developer

Primary Skills
Reports Developer & Business Analyst

Location
US-TX-San Antonio

Posted
Jun-13-08

Senior BI/BW Analyst & Reports Developer

OBJECTIVE: Position as a Senior BI/BW analyst and/or reports developer.

SUMMARY OF QUALIFICATIONS:
• Ability to improve operating efficiencies in most business units through new or improved procedures, processes and/or systems.
• Ability to work closely with owners and senior management to help identify business goals and to manage the development and placement of personnel, systems and procedures to meet these goals.
• Ability to manage complex projects and to resolve significant business and systems issues.
• Ability to work with and manage company support personnel in a dynamic and changing environment.
• Advanced level of familiarity with MS-Office tools including: Excel (vlookups, VBA & macros, Pivot Tables and linkage to external data)
• Varying degrees of experience and capability with an assortment of development, database, reporting and productivity tools including: Crystal Reports (Ver: 8 to XI), Business Objects Enterprise, Xcelsius, FRx, SQL, MS-Access, Dreamweaver, HTML, Cobol, Business Basic, Visual Basic, VBA, C++, Assembler, Visio, XML, Paradox, dBase,
• Experience with design, development and ETL of, and reporting from, RDMS, OLTP, OLAP and DW data warehouse systems including SAP BI/BW, Cognos, Hyperion Essbase.
• Experienced with a variety of packaged and custom Accounting/ERP/CRM systems including: SAP R/3, SAP Business One, Peoplesoft, Great Plains (MS DynamicsGP), MAS-90, BusinessWorks, Open Systems, Peachtree, Quickbooks, Salesforce.com and numerous custom and vertical market packages.
• Experienced with international outsourcing including IT development & support teams located in India, Pakistan, Philippines, China, Brazil & Argentina.
• Experienced with SOX 404 compliance requirements.

EXPERIENCE DETAIL:

Jan 2007/Current Independent Consultant
• For large distribution and supply company utilizing SAP & BW - design/develop/maintain sophisticated BI reports with Business Objects Crystal XI having interfaces to SAP R/3 tables & functions, SAP BW queries and a variety of external databases under both Oracle & SQL environments.
• GL team lead during the merger of two large (>$500+ million) consumer product companies. Worked closely with senior management from both companies. Responsibilities included integrating the GL modules of the ERP systems of both companies, one system being PeopleSoft and the other SAP, SAP being the surviving system. My team was responsible for developing a new organizational structure which facilitated legal, tax, functional and SEC segment reporting. We were also responsible for integration and mapping of master data including GL accounts and related cost and profit centers and then reconciliation of financial data for the merged operation. Used SQL, MS-Access, Crystal Reports and Excel as tools. Additionally we were required to develop numerous reports using the SAP Report Painter tool and our Hyperion Essbase OLAP environments. Upon my recommendation we also implemented the new WinShuttle mass-maintenance and query tools to provide additional functionality. Utilized automated SOX tracking tools to maintain and monitor status of SOX compliance documents for myself and my staff.
• Worked on a couple of other small IT projects including:
o Medical equipment manufacturer -- assisted them with implementation of their SAP B1 ERP system and developed several complex reports using Business Objects Crystal Reports Version XI.
o Printing company - assisted them with implementation of their vertical market ERP system.

June 2005/Jan 2007 Founder - Virtual Offices of San Antonio
• Attempted to establish an IT related incubation company. Did not succeed!
Established a company, “Virtual Offices of San Antonio”, with intent of providing a central location and focus point for independent and small groups of technology service providers. I also established the AICSP (Association of Internet and Computer Solutions Providers) -- see . Ultimately I discovered less demand for the services than anticipated and terminated operations after a year an a half.

Oct 1992/May 2005 Sr. Accounting and Technical Consultant for Worldwide Beverage Distributor
This consulting engagement lasted 13 years! Project Manager and/or lead Business/IT analyst and first line of support for both accounting and systems issues for multiple accounting managers and financial analysts of this $700 million manufacturing/distribution company. Reported to Sr. VP of Finance.
• Responsibilities included working with senior business managers to identify and document functional business requirements then translate them into technical specifications for systems development.
• Project manager and lead design, development and implementation analyst for a number of custom Accounting/ERP modules for company plant & office locations throughout the US. Included: GL, Payables & Disbursements, Orders and Invoicing, Receivables and Cash Receipts, Banking (EFT/ACH), MRP and Inventory Control, Budgeting and numerous custom reports.
• Throughout the acquisition of a major industry competitor I was responsible for successfully managing the integration of the accounting and financial systems, training the accounting personnel and otherwise ensuring a smooth transition with minimal interruption to business processes.
• Worked closely with Big-4 auditors to retrieve and analyze accounting and financial data.
• Researched & selected a simplified manual SOX compliance system.

Summary: Over the term of this lengthy engagement I participated in a major turnaround and restructuring of the company that resulted in a tripling of sales and significantly increased profitability and cash flow. The company was transformed from a stagnant manufacturer of a commodity product operating in a mature industry to an efficient marketing and service-based company utilizing aggressive management techniques and state-of-the-art technology.

The automated systems and procedures I assisted in designing and implementing significantly improved performance and reduced labor costs at the company's multiple plant locations and helped position the company to make a major acquisition of a much larger industry competitor.

At the conclusion of my engagement I participated in replacing our legacy accounting system with the Great Plains client/server/SQL based accounting suite from Microsoft (now referred to as DynamicsGP) along with a COGNOS Data Warehouse.

Jan 1990/Oct 1992 Independent Contract Programmer
• Developed custom accounting business and accounting applications for local companies.

Mar 1987/Jan 1990 Manager of Computer Services for Local CPA Firm
• Managed the computer services division of the company. Responsibilities included marketing, budgeting, staff supervision, client consulting and in-house systems support.

May 1982/Feb 1987 Founder of Computer Services Company
• Provided nationwide sales and installations of multi-user computer systems and integrated sales/accounting software for the construction industry. Merged with local CPA firm in 1987.

Apr 1980/Mar 1982 Coordinator of Corporate Development (Financial Analyst) for Houston Energy Co.
• A $billion energy company that was eventually acquired. My responsibilities included: financial analysis and evaluations of special projects and acquisition candidates. I also coordinated efforts between the Corporate Development, Finance, Planning and Accounting departments.

Jul 1977/Apr 1980 Systems Analyst/Programmer for Andersen Consulting (now Accenture)
• Participated in the design and implementation of many computer and management related projects for a variety of the firm's largest clients, including:

1. Computerized patient admissions/records system for a major hospital.
2. Materials management system for a major utility.
3. Departmental management information system for major oil company.
4. Dental claims processing system for a major insurance company.
5. Payroll/Personnel system for worldwide construction company.

EDUCATION: University of Texas at Austin
BBA - Management, 1975 (honors)
MBA - Finance & Accounting, 1977 (honors)
*CPA - (Texas - 1981, Certificate #24764 -- *no longer maintained due to IT concentration)
CCP - (Certified Computer Professional - #931611)

REFERENCES: Many personal and professional references can be provided upon request.

Certifications
MBA, CPA

CONTACT DETAILS

You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-TX-San Antonio »
View all resumes in US-TX »

View other Analyst/Reports Developer resumes