Lillian Adams Email & Phone Number

New York, Ny, Us

New York, Ny, Us

Franklin Lakes, New Jersey, United States

• Develop and implement technical tools used to automate GPO’s agreement membership and pricing.• Collaborate with different IT teams to ensure the business requirements and technological functionalities are supported.• Manage MS Access based Tier models for new contract and existing members.

Englewood Cliffs, Nj

Automated the migration of Unilever Food Solutions (UFS) products’ information from various sources and formats into templates for the Salesforce Consumer Engagement Center (CEC) by using Excel formulas and VBA to ensure data quality and reduced the time of completion.• Developed applications to automate manual processes and reports, resulting in data accuracy and reducing time of completion. • Responsible for monthly reporting of product price lists for upper management and field sales force.• Performed data cleansing, data validation and addressed information gaps in the maintenance of the UFS product catalog.• Ensured products’ nutritional facts labels are FDA compliant by implementing a tracking system to maintain data integrity and consistency across departments.• Created guides on how to use and troubleshoot the applications developed and used SharePoint for the distribution.• Streamlined GPO customer approval process utilizing the internal system BlackSmith to collect customer data. • Increased information sharing and product identification by uploading and enhancing the images on the web system.• Managed the customer’s Electronic Data Interchange (EDI) between internal and external systems and validated the information through the use of Microsoft Power BI and salesperson verification.

Performed analysis to assess pricing strategy, customer’s performance and to address impactful issues; extracted data from multiple systems: AS400, Oracle, SQL & DB2 to perform statistical analysis of sales and key performance indicators, to use data visualization, to generate graphs and charts and to identify trends; also, synthesized large data sets to develop analysis and presented project findings.• Created custom pricing models to evaluate item assortments and maximize profits.• Developed applications to streamline workflow and provide status reports to facilitate decision making and document existing and new business leveraging VBA, MS Access and SQL to ensure data integrity.• Generated reports on key metrics to empower management to support strategic decisions.• Implemented pivot tables to performed analysis to assess pricing strategies, customer’s performance and impactful issues.• Administered the Vendavo Pricing Optimization Tool user interface and utilized it for reports and analytics dashboard creation.• Created dashboards to visualize and quickly view varying scenarios such as sales, profit margin and cost variances.• Ensured contract items are government compliant through the use of MS Access and company’s internal application.

Secaucus, Nj

Created databases using MS Access and SQL queries on large data sets to monitor and report on medical event’s statistics.• Liaised between senior management, business users and IT to ensure that application enhancements are communicated to the business and technological divisions and collected feedback for the IT developers.• Prepared monthly ad hoc reporting in alignment with management needs.

Arroyo Hondo, Santo Domingo, Dr

• Taught the functionality of the MS Office Suite and administered the computer lab.• Redesigned the school's website using Dreamweaver, Fireworks, Flash and MS FrontPage.

1 Wtc; New York, Ny

• Confirmed application performance and operation by conducting tests and modifying program’s codes.• Developed website using ASP, HTML and VBScript to display information on different web browsers.

Master Of Science (M.S.), Computer Science

Bachelor Of Science (B.S.), Systems Engineer

Post Graduate Studies, Education