Reporting Systems Analyst

Ingram Micro Phils. BPO LLC

Reporting Systems Analyst

(National Capital Reg - McKinley Hill, Taguig City)

Responsibilities:
I. SUMMARY:


Responsible to design, develop and implement new as well as maintain all existing MS Access Database applications that are supported and managed within the Center of Excellence Team at the Manila Service Center. Examples of these database functions range from simple reporting of data imported from various types of data types to complex manipulation of stored data through automated application of credit files to open receivables.

Prepares functional system design documents, such as flow charts and data-flow diagrams as well as maintains current policies within desktop procedures. All database applications launched into production should have clear and descriptive notations in the code. Conducts functional unit and integration testing prior to validate accuracy and consistency. Evaluates test results prior to seeking approval by project owners. Develops training material for all new applications and process improvements as well as updates any existing training material with any new policies or changes made to either database applications or processes. Devises and assists in the training of personnel on all new releases and upgrades of applications. Assists in developing and administering training programs for the user community.

Performs daily/weekly/monthly downloads from Ingram Micro’s systems such as but not limited to Kronos Systems and Impulse mainframe. Uploads daily as well as weekly files into MS Access Databases as well as SQL Server Databases through MS Access Database front-end applications.

II. ESSENTIAL FUNCTIONS:

1. Design, develop and deploy MS Access Database Applications and develop processes as well as maintain and update existing database applications and processes.

2. Manage projects from the design phase involving user and manager input to the deployment phase as well as the continued maintenance phase.

3. Perform daily, weekly and monthly downloads, distribute standardized and ad-hoc reporting and upload databases for users throughout Controllership as well as some external department clients.


Requirements:

1. Formal education or training required such as degrees, courses of study, certification:
• Education: BA/BS Degree. Focus in Information Systems/Finance/Accounting preferred.

2. Previous work experience required for a new hire in this position; indicate type of experience and length of experience. If supervisory experience is required, how many years and at what level?

• 3 - 5 years business experience.
• Familiarity with working in a high-volume, highly dynamic rapid paced environment.
• Ability to comprehend various accounting functions and needs into detailed and logical process flows for design and development of new MS Access database applications.
• Highly proficient in ability to write complex modules in MS Access and MS Excel using VBA.
• Self starter and understanding how to develop solutions using any and all means available.

3. Summarize the minimum kinds of knowledge, skills and abilities required to do this job:

A. Complex/advanced and highly proficient level of knowledge in:

• Database Development - MS Access – modules, form objects, report objects, query objects and table objects.
• Spreadsheets - Excel - writing macros, developing formulas, creating and using functions with VBA.
• SQL Server
• VBA (Visual Basic for Applications)
• Business Objects (BOXI)
• MS Visio
• Monarch
• Professional correspondence both oral and written
• Highly detailed oriented
• Excellent problem solving skills
• Advanced judgment with in defined policies
• Intermediate level of proficiency in researching, math, MS Outlook and Word
• Moderate to complex knowledge of accounting systems and accounting cycle, financial business processes

B. Ability to:

• Work in fast paced environment
• Meet Deadlines/Time Management
• Work with others/with other teams
• Ability to work under general supervision and guidance as a self starter/self directed
• Ability to take a moderate leadership role with peers, lower level analysts, and on project teams.
Why is Ingram Micro the Workplace of Choice?
* We drive results through creativity and innovation.
* We are a winning
* team where people are valued for their differences and collaborate to achieve unpararelled success.
* It's here where you will learn new skills, are encouraged to share ideas and see your contributions at work.
* We thrive on change and use challenges as opportunities to grow our business and careers.
* We provide our customers and vendor partners outstanding execution and value everyday.
If you recognize opportunity in change, this is where you will excel.
Company Address: 12/F 3 World Square Mckinley Hill Taguig *
Industry: Call Center / IT-Enabled Services / BPO
Type of Company: Private Limited Company, Local Based Company
Ingram Micro Phils. BPO LLC
12/F 3 World Square Mckinley Hill Taguig *.