IT Business Analyst - Manager Resume - Hire IT People

PROFESSIONAL EXPERIENCE

Confidential

IT Business Analyst - Manager

Responsibilities:

Researched cloud-based software applications comparing functionality and pricing to replace current accounting package that used in-house servers.
Directed a committee of auditor and tax partners to assist with the comparison of various software applications.
Advised upper management to use a right-sized file storage system rather than a document management system which resulted in saving the company $60,000 annually.
Collaborated with individual departments to migrate their server data to the new file storage system.
Assisted with the implementation of a cloud-based tax application.
Launched an online recruiting application to replace a paper system.
Created and modified Excel macro reports using Visual Basic for Applications (VBA).
Produced an automated system using VBA which populated HUD audit information into a government Financial Assessment system.
Leverage SQL Server Integration Services (SSIS) to extract, transform, and load data from different databases and flat files to create dashboards using our Smartsheet data visualization tool.
Document business process flows, application best practices, and troubleshooting guides.
Manage one employee by communicating job expectations, monitoring assignment workload, and providing career coaching.

Confidential

Associate Consultant SME - Global Data Delivery

Responsibilities:

Served as global subject matter expert for Oracle’s electronic data capture InForm 5.5 and InForm 6.0 software, providing support for users in India, Australia, Japan, Canada, Latin America, Russia, Turkey, United States, and all of Europe.
Served as subject matter expert for Oracle’s InForm security setup using Oracle’s User Management Tool.
Provided customer support to Lilly Clinical Data Analysts as well as third party organization personnel on InForm and User Management Tool functionality.
Managed problem resolution to clinical trial processing issues by analyzing data within the application interface, audit trails, or ad hoc reporting.
Supported Clinical Operations and site users by providing guidance in alignment with InForm training and reference materials.
Adhered to Lilly policies and procedures to ensure patient data privacy.
Tested new releases of the User Management Tool software.
Analyzed new versions of InForm leading the requirement modifications, testing, review, and implementation for newer versions of InForm software.
Developed business relationships by being a liaison between the customers and Oracle to provide system improvements and right-sizing newer versions of the InForm software.
Updated training materials with recent software and business process modifications.
Provided InForm training sessions for clinical data analysts, third party organization, and site personnel.
Ensured security operating procedures contained current documentation updates.
Strategized best processes for InForm usage with the Central Designer programmers as well as the impact to downstream systems from InForm.

Associate IT Consultant

Confidential

Responsibilities:

Programmed modifications to Elanco Sales Tracking and Automated Reporting (ESTAR) invoicing system using Informatica, Oracle PL/SQL using T.O.A.D., and Unix.
Updated Elanco Sales Tracking and Automated Reporting (ESTAR) invoicing system to be compliant with Global Data Warehouse using Informatica ETL tool and Oracle databases.
Delegated development tasks to contractors for Global Data Warehouse project.
Lead the design, testing with the creation and execution of test cases, and implementation of a Global Data Warehouse project for Elanco Sales and Marketing using Informatica, Oracle PL/SQL using T.O.A.D., Unix, and ODBC connectivity.
Supported the Global Data Warehouse software for Elanco Sales and Marketing.
Prioritized enhancements and fixes to the Global Data Warehouse centered on customer feedback and information gathering.
Improved efficiency for data flow entering and exiting Global Data Warehouse.
Set up new OUS affiliates in Global Data Warehouse.
Documented system modifications to keep validation package current.
Replaced the Datacore vendor customer matching and merging process used by Global Data Warehouse with Trillium software vendor package used by Lilly.
Implemented interface between Siebel and the Global Data Warehouse to handle retail customer orders for Posilac.

We provide IT Staff Augmentation Services!

It Business Analyst - Manager Resume

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship