Below are the 4 Systems Analysts, 4 Functional Analysts & 4 Business Analysts with Oracle & other systems experience. The Thor Group® provides financial analysts, developers, systems administrators & Oracle software implementation consultants with your industry & systems experience on a consulting, contracting or direct hire basis.

Does a systems analyst who is knowledgeable in Oracle, as well as experienced in retail, financial services and publication industries pique your interest? Technical knowledge includes Oracle, UNIX, Linux and SQL. Background in Oracle Tools, Active Database, Objects, Financials, Incentive Compensation and Fixed Assets is also shown. Core competencies include deep understanding of coding standards, strict implementation of the same during the development life cycle and Oracle TAR management. Educational background includes Bachelor of Science in Computer Science.

One of the major responsibilities of this systems analyst included working closely with end-users, internal developers and vendors to create business/ functional requirements, system flow diagrams and other documentation required to support or enhance internal applications. Functional and technical roles were performed, including requirements gathering, system analysis, design, development, configuration, implementation, continued upgrade, enhancement and support for the Oracle Financials 11i Payables, Incentive Compensation, Fixed Assets, Receivables and General Ledger. Creating SQL queries, analyzing the data and working with reporting tools to provide alternative workflows and solutions to assist with business needs and issues were efficiently handled. The job covered using available tools (SQL Developer) and prior experience to analyze business needs to provide data extracts and reports. Tasks consisted of creating and manipulating data for testing and production data needs.

Functions in another job included overseeing the implementation of third party tools and additions to the overall system application was carried out. This included the installation and configuration of the Tidal scheduling software (new install for Oracle R12 implementation), More4Apps and PrintPro.

How can your organization gain an advantage with the help of a systems analyst who is skilled in Oracle Database with work background in a university hospital and a tertiary care hospital? Technical skills cover Oracle Database, McKesson, BusinessObjects, Active Directory, SQL Database and Crystal Reports. Educational attainment includes Ph.D. in Higher Education Administration, Master of Science in Education Administration and Bachelor of Science in Sociology.

While working for a university hospital, one of the main functions of this systems analyst was composed of serving as high level analyst controlling pharmacy and patient usage information through complex application systems and databases. This individual was responsible for large client/server system called Omnicell which controlled Access to pharmacy items at cabinets through-out the hospital and maintained inventory on local foxfire databases. Monitoring, maintaining and proactively modifying daily, weekly and monthly reports of pharmacy information for several departments at the hospital using Access and Excel were some of the duties. An additional role involved overseeing the correct usage of large desktop application called HMM (McKesson Company), supported by large back end Oracle database, in which pharmacists entered usage of pharmaceutical items for in-patient care.

Notable tasks included assuring the communication between pharmacy department and hospital wide patient information systems through proprietary communication systems and diagramming process flows between various client server interfaces using Visio. Systems which billed and credited pharmaceutical items were also managed. Reports were implemented using BusinessObjects and users were trained on specific ways to maximize their reporting.

Could the future success of your organization be helped by this systems analyst who is proficient in Oracle RDBMS, Report Builder, Forms, Financials, SR and BI Publisher with work experience in government, education and nonprofit industries? Technical competencies involve Oracle RDBMS, Report Builder, Forms and BI Publisher. Educational background includes Bachelor in Computer Science (BS), Master in Mathematics (MS) and Master in Business Administration.

Important contributions of this systems analyst included handling Oracle Financials ERP projects and providing ongoing support or upgrade of the client’s financial systems and reporting needs. The job entailed performing and participating in all phases of the Safe Agile planning and iteration planning as part of ESC Scaled Agile framework. Tasks covered performing and participating in one phase of the Agile planning and scrum meetings for the Oracle R12.2 upgrade. Collaborating and working with the team on all phases of development and functional aspects of P2P projects or Reporting projects were efficiently managed. Coordination with users and other cross domain/cross functional teams for Oracle SR’s remedy tickets, SCR’s and work Order requests to fix issues was carried out.

This specialist understood business needs and created/developed solutions to develop and implement the business requirements. Creating, assigning and setting profile options, while also creating user responsibilities, creating concurrent programs and executables, as well as creating extracts/ files for load and build data were skills brought to the table. One of the functions involved working on creating Oracle forms, form menu, form lookups, form functions, form setup and form personalizations.

What can a systems analyst with work background in technology, business services and Marketing industries bring to your organization? Technical specializations involve Oracle OTC, R12, SME, Item Master, Configurator Developer, Advanced Pricing and Bills of Material. Areas of expertise include Oracle OTC modules, administrative management, business process improvement, testing activities and end user training. Educational attainment includes Business Administration A.S. Program (Accounting major), as well as Certificate of Completion in Oracle Database Administration.

Working with areas such as carrying out financial systems transactional functions (using Oracle OTC) and serving as functional lead OTC to track Inventory, Advanced Pricing, Order Management, Service Contracts, AR, Credit Management and Customer Standard modules were some of the responsibilities of this systems analyst. Duties covered defining business processes, gathering and documenting functional requirements, evaluating business needs and establishing solutions for enhancements and upgrades and system implementation of R12. Other functions consisted of collaborating with Oracle SME’s for configuration build out of R12 functionality, authoring detailed test scripts, participating in CRP test cycles and facilitating UAT testing between business units. The job covered demonstrating new functionality of R12, providing hands on training to business users and authoring user guides. Tasks involved pre go-live sanity Check and validation of system functionality based on business requirements.

Functions also consisted of participating and contributing to all phases of system implementation to Oracle R12. This included documenting process flows, gathering requirements and authoring requirement documents, collaborating with development teams and external Oracle SME’s on design and configuration setups under the OTC track.

What can a functional consultant with work background in business services, insurance and telecommunications industries, as well as specializations in Oracle Apps, Oracle Service Procurement and Oracle Contracts Core bring to your organization? Technical specializations involve Oracle Apps, Oracle Service Procurement and Oracle Contracts Core. Other proficiencies include General ledger (GL), Accounts payables (AP), Accounts receivables (AR), Financial accounting hub (HUB), Subledger account (SLA), Purchasing, iProcurement, Oracle service procurement, Oracle contracts core, iSupplier portal and iExpenses. Educational attainment includes B.E. in Computer Science & Engineering.

Working with areas such as working with the core team which was involved in initial assessment, requirements gathering and design of the integration of the loan accounting platform with their enterprise GL through Oracle financial accounting hub (FAH) was one of the responsibilities of this functional consultant. Business requirements documents, solution specs, design documents and BR100 were created during this phase.

Functions in other jobs consisted of implementing the purchasing modules (R12.0.6) – iProcurement, Purchasing, Service Procurement, iSupplier and Contracts Core for close to 40 OUs across the globe. The job covered collaborating with the technical team to translate requirements into technical design and facilitating the development of Oracle XML Publisher Reports. Part of the tasks involved implementing Oracle financial accounting hub (FAH) (R12.1.2) to integrate 36 legacy source systems with PeopleSoft GL using Oracle FAH and AIA/PIP architecture. Tasks involved setting up of customized account derivation rules (ADR) for legacy source system requirements, architecting a custom error handling solution for the end-end integration and collaborating with the technical team to translate requirements into technical design.

Could your organization use a functional consultant who is experienced in IT services, gaming and banking industries, as well as proficient in Oracle Apps, Oracle Forms and Oracle Reports? Technical proficiencies cover Oracle Apps, Oracle Forms and Oracle Reports. Other proficiencies include software design, Application Object Library usage and development experience in Oracle based applications using databases – Oracle 10g/9i/8i SQL, PL/SQL (Triggers, Procedures, Functions and Packages) and Developer 2000 (Forms Builder and Report Builder). This individual is an Oracle Certified Professional.

Some impact contributions of this functional consultant included providing support and maintenance for Oracle Financials – Accounts Payables and General Ledger modules as well as other peripheral systems. The company has implemented Oracle Applications Financials and Purchasing modules for their operations. Functions covered studying the functional requirements documents and interacting with the client for any Open issues. The job consisted of preparing technical specs design documentation for solutions, monitoring interfaces developed to maintain the lease information, as well as monitoring and supporting the daily lockbox-payment batch processes. Skills brought to the table involved creating, modifying and troubleshooting complex Oracle Reports.

In other jobs, aside from studying the functional requirements documents and interacting with the client for any Open issues, technical specs design documentation for solutions was prepared. This individual designed mapping documents for object migration and completed AOL code migration from one instance to another instance using FNDLOAD utility. Key roles covered creating, modifying and troubleshooting complex Oracle Reports. The development as well as migration using FND_CONCURRENT and PL/SQL scripts were completed, along with coordinating with the onsite team for data validation and conversion using standard API’s.

Would a functional consultant with familiarity in retail, communications and media industries help your organization achieve greater success? Technical specializations cover Oracle EBS, ODC, I/PM, BPM, AME, EM and SA. Educational attainment includes Computer Science (coursework), Technical Degree Computer Science, Certificates in CL/ RPG programming and Program Design/Development (Programming coursework).

Making a positive difference with providing Oracle EBS application support and creating multiple SQL Queries for several modules to perform data extracts were some of the key focuses of this functional consultant. Responsibilities covered verifying data extracts to conform with needed EIB layout for new system and handling multi-level verification of extracted Oracle data using various SQL Queries.

Notable tasks in other jobs included providing Oracle EBS application support (AP, IExp, GL, PO, PA) and using SQL Developer for the analysis of interface processing, data issues and reporting. This individual created business requirements, created test scenarios and scripts and performed configuration changes. This individual ensured changes were constructed, tested and implemented. PCG and Oracle personalization were used to restrict Access at responsibility/function level. Duties consisted of providing Oracle EBS application support (AP staff augmentation), handling various staff requests to support data integration/processing and updating system setups to accommodate project changes. Oracle Alerts and scheduling were managed. Oracle Workflow was used to maintain and/or update vacation rules/approval notification processes. Toad/SQL Developer was used for the analysis of interface processing and data issues. Serving as part of the Enterprise solution support team Member providing production support for user community to include case creation and/or management and resolution was handled.

Could your organization use a functional analyst who is experienced in transportation, manufacturing and financial services? Technical proficiencies cover Oracle E-Business Suite (EBS), Oracle Financials and Oracle AIM Methodology. Core competencies include all financial modules and end to end knowledge on the functional flow of other modules with an integration of financial modules in both 11i and R12 versions of Oracle EBS. Educational attainment includes Master of Business Administration (MBA) and Bachelor of Commerce.

Primary tasks of this functional analyst included carrying out the implementation of Oracle R12.1.3 and was responsible for GL, AP and CE right from the project kick off phase. Requirements gathering, current business process analysis, re-engineering/ designing of business process, system configuration and system testing were also handled. Key roles covered reviewing the current business process and documenting the business procedures for procure-to-pay and project invoicing to Cash receipts. Cash management was integrated with Payables and Receivables modules for reconciliation. Auto import and reconciliation of bank statement, bank file integration and mapping were efficiently completed.

Contributions in another job involved reviewing the business requirements documents with the business and development teams and analyzing the functionality of the Oracle applications to finalize the solution. Identifying standard functionality, analyzing gaps document and designing solution for GL & AR depending on business requirements were also managed. This individual set-up AR System options, payment terms and auto accounting. Skills brought to the table consisted of gathering business requirements and preparing RD020. Configuring multi-org business structure in Oracle, ledger setup, legal entity, establishment setups and MOAC security was also completed.

Could your organization use a business analyst who is experienced in IT services, printing and education industries, as well as proficient in Oracle EBS and Oracle Financials? Technical proficiencies cover Oracle E-Business Suite (EBS), Oracle Data Integrator and Oracle Financials. Areas of expertise include Oracle ERP implementations, upgrades and providing support mainly for Financials, General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets, Cash Management, Purchasing, Inventory and Order Management modules. Educational attainment includes Master’s of International Business, B. Comp Economics & Finance, as well as Advanced Certificate in Mathematics, Accounts and Management of Business.

One of the primary tasks of this business analyst included hands on role in working closely with finance to support their Oracle E-Business Suite development, analysis and user support needs. Business process analysis and vision were applied to achieve the company’s finance objectives through EBS. Key roles covered working with Oracle by opening SRs and implement solutions, as well as performing testing and helping users in conducting UAT. Troubleshoot issues with GL, AP, FA, AR, CM, PO and OM was also completed.

Contributions in other jobs involved carrying out an implementation and testing of Oracle Applications Financial R12 GL, AP, AR and CM modules. This individual was involved in requirement gathering using industry standard analysis techniques such as data flow modeling and object modeling, case analysis, workflow analysis, and functional decomposition analysis, as well as analysis and design of the application. Working with the client team to understand the current business process, developing test plans/ scripts and conducting testing for quality assurance were efficiently handled. GL and AP modules were configured in the R12 environment.

What can a business analyst with work background in business services, financial services and software industries, as well as specializations in Oracle Financials bring to your organization? Technical specializations involve Oracle Financials, Oracle Discoverer, Oracle BI and Peachtree/Sage 50. Core competencies include developing, customizing and implementing Oracle Financial modules to solve complex business, accounting and reporting needs. Educational background includes MBA in Finance and BA in Economics & Business Management (minor in Psychology). The professional completed accounting education requirements for CPA exam.

Working with areas such as providing business analysis, development, and customization of Oracle Financials (v12), as well as providing systems implementation of other Oracle Modules (Discoverer and BI) and integration with systems such as Peachtree/Sage 50 were some of the skills brought to the table by this business analyst. This individual served as liaison among IT, accounting and Oracle, providing discovery/requirements definition, translation to functional specifications and troubleshooting. Duties covered developing custom queries, reports, and forms such as balance sheets, income statements, operational variance reports, Cash flow statements, and other Ad hoc reporting requests.

Responsibilities in another job consisted of playing an SME role in the migration of Oracle GL Database (10.7sc) to Oracle Global Database (11i), including all multi-company and multi-currency organization setups. An additional task involved utilizing Oracle ADI for reporting, drill-down and loading budgets/actual data. Aid was provided in defining user requirements, design, creation and testing of reports utilizing Oracle Financial Analyzer extracted from Oracle Database. End users were trained following successful migration from Oracle FSG to OFA Reporting. Work was provided with Oracle to resolve accounting interruptions and implement upgrades.

Could the future success of your organization be helped by this business analyst who worked in construction, business services and technology industries, as well as proficient in Oracle Financials, Oracle Bill of Material and Oracle MRP? Technical competencies involve Oracle Financials, Oracle Bill of Material and Oracle MRP. Educational attainment includes Master of Business Administration and Bachelors of Science in Mathematics.

Important contributions of this business analyst included serving as lead analyst for Enterprise Resource Planning system implementation project which included Oracle 11i financials (Accounts Payables, Accounts Receivable, Fixed Assets, General Ledger, Purchasing, iExpenses, and iProcurement) and 170 systems’ MarkView image management software. Tasks covered creating all documentation for UAT which included resource guides, schedule of events, user scripts, test scenarios, and issue reporting and tracking forms. Skills brought to the table included conducting 2-week User Acceptance Testing (UAT) session identifying issues and tracking to resolution in preparation for go-live, along with developing 6 end-user procedures and document for monthly close of Oracle Financials.

Key roles involved providing post go-live end-user support for all Oracle Financial modules and MarkView, creating 12 support documents for Oracle 11i financial modules, in addition to providing training to 50 level one support staff as part of the project transition team. The job covered developing documentation of 120 requirements for automated computer aided design building program for a company that produced stamp-ready drawings. Project included website GUI, CAD database and CAD file management. Documentation was developed using 85 requirements for hardware and software asset management system to ensure proper licensing for over 15,000 hardware assets and 120 software applications.

Does a business analyst who is experienced in the IT and business services industries pique your interest? Technical knowledge involves Oracle PL/SQL, JavaScript, UNIX Shell Scripting, Packages and Triggers, ODS, DDL scripts, Toad, SQL Navigator, SQL * Loader, SQL* Plus, Java, J2EE and Eclipse. Areas of expertise include IT business analysis, system analysis and data analysis with hands on experience in varied tools and technologies like C, UNIX, Oracle PL/SQL and Java. Educational attainment includes Bachelor of Engineering (Computer Science & Engineering).

Major responsibilities of this business analyst included business analysis, requirements gathering, writing test plan, developing test cases and supporting all environments for testing. Key roles covered getting involved in discussion with business for supporting functional specifications and creating the design and technical specifications for the data flow process of the project. SQL Developer was used to perform manual test in regular basis. UNIX and Oracle were using in this project to write Shell Scripts and SQL Queries. Aside from writing test cases to test the entire application manually, requirements were collected and several business reports were tested. Creating and testing event based schedules of the reports and building an emailing mechanism to indicate success/failure of the schedule were efficiently handled.

The job covered using database query tools for Oracle, SQL and UNIX such as TOAD, SQL Developer and SQL Plus. Experience in data analysis was applied using SQL, PL/SQL and many other queries-based applications. Functions covered extensive data validation using SQL queries and back-end testing, in addition to writing several UNIX shell scripting for file validation and also PL/SQL programming.