SUMMARY:

• Energetic customer service, administrative and technical data management professional with a comprehensive background in supporting diverse teams in industries such as retail, banking, manufacturing, engineering, accounting, food distribution and product service.
• Significant focus on managing and coordinating administrative tasks for cross functional departments simultaneously.
• Strive to create a positive, efficient and productive working environment.
• Demonstrate ability to learn new processes quickly, adapt to a fast paced changing environment, multi task, set priorities, communicate ideas to key stakeholders, and respond positively to demanding situations.
• MS Office Suite 2010 & Access, Excel spreadsheets, formulas & VBA, macros, pivot tables, charts
• Principles of accounting knowledge
• Data Analysis & Records management specialist, relational database skills
• Collaborative & Customer oriented
• Organization, prioritization, analytical, detailed oriented
• Rational ClearQuest, Oracle Apps
• Business Intelligence reporting, NICE Business Analyzer
• TeamCenter, LiveLink, SharePoint, Concur, CRM, SAP, Vantage(MRP)
• Process improvement driven, problem solving skills & proactive follow - up skills

PROFESSIONAL EXPERIENCE:

Confidential

Reporting Specialist (Data Analysis)

Responsibilities:

• Provide data analysis and reporting tasks to a call center operations group for the Making Homes Affordable program, a government mortgage loan modification program; reports such as daily call operations stats and Homeowner and Treasury cases, Case Management tool and Quality Assurance audits to show pipelines, budget, forecast and expenses, and Case Analysis trending information; create scorecards to reflect individual performance and Management Business Review which provides a summary of overall operations, import and export database management tasks.
• Collect, organize, manipulate and analyze datasets with attention to detail and produce a myriad of reports on a daily, weekly and monthly basis for both internal and external audience according to arduous constraints
• Execute existing metrics-based reports and implement new reporting as needed; perform data validation and explore new data sources to transform data into impactful information intelligence; maintain supporting documentation of methodologies; eager to learn the processes underlying the reports owned by the Operations team
• Utilize a multitude of sources such as MS Excel w/ VBA to sort and calculate data, CRM databases, NICE Business Analyzer and Corporate report center
• Creation, maintenance, and evolution of standard report formats and templates; update templates as business needs change, test new template versions and provide analytical feedback
• Analyze Excel formulas and macros for accuracy and validity; interpret data mined from queries also identifying trends, data integrity issues and coaching opportunities for staff
• Set-up and maintain report subscriptions pertinent to static reporting dashboards and billing statistics; update daily reporting tasks and provide electronic signature to tasks pertinent to scheduling, tracking and personal performance
• Create department scorecards on SharePoint site which requires updating data file connections to other sources and documents, a complex set of Excel documents fed by an Access database
• Perform back-up procedure to Access databases that feed other data tables required for other reports; organize and maintain electronic records
• Stewardship for reporting business requirements, including KPI, maintain inventory of MHA related business reports and data mapping of metrics to existing reports

Confidential

Sales Commissions Analyst

Responsibilities:

• Gained knowledge of communications industry sales channels and compensation pay policy
• Provided timely and accurate support to Inbound and Retention Sales Channels processing commission payouts based on performance, goals, and policy terms
• Extracted agent performance data from Scorecard (Excel) and import to Access, ran queries and summarized final payout in Excel, and submitted to Vendor Coordinator for payment; respond to inquiries on payouts providing answers on policy terms and performance data
• Performed User Acceptance Testing in a Business Intelligence and Quality Assurance environment on supervisor reporting tools, comparing data to other reports, identify errors and capture screenshots to report results to software development team for repair and production deployment
• Utilized Oracle STAR application to maintain Resources (group, role, status) and to perform service transactions moves between Resources; all critical to correct commission pay
• Documented Manual Pay adjustment Process and Temp Labor Manual Calculation Process

Confidential

Operations Assistant

Responsibilities:

• Provided production planning support by reviewing manufacturing requirements in Vantage for parts ready for production, release jobs, matched required material certificates, produce job routers and distribute. Performed ad hoc queries on material orders for upcoming part requirements and inventory on hand, as well as jobs in process
• Performed transactions in Vantage such as produced pack slips according to order/part type i.e., consignment/non-consignment, research purchase orders and receipt entry
• Supported Sales by reviewing customer web portal for hard purchase orders and customer delivery receipts, enter Sales order in Vantage; obtain corporate PO required for invoicing, follow up on open details as needed; researched part price table and update product pricing
• Utilized Vantage to provide A/P support by receiving on purchase orders and researched line items to reconcile invoices
• Generated open P.O. and SN # report from Vantage with vendor and tracked in Excel to reconcile line items for parts being sent daily for outside processing, tracking items through month end for reconcile
• Supported human resource functions with recruiting, onboarding of employees by setting up EID in timekeeping system, obtained pertinent forms such I9’s and tax forms, administered benefits and Safety orientation; summarized overtime in Excel and updated graph chart for management
• Maintained current subcontractor liability insurance certificates and tracked in Excel spreadsheet

Confidential

Sales Assistant

Responsibilities:

• Utilized SAP to issue debits / credits for customers and perform ad hoc queries for customer sales, account status, product price, usage, and freight price, etc.
• Utilized Excel to set up new and modified contracts for product and freight pricing on material pertinent to shipping terms. Provided shipping point and ship to details, processed credit applications and tax status forms, collaborated with the Sales team as needed
• Generated weekly report on regional sales forecast, actuals and cost of sales from BEX
• Collaborated with various departments (credit, customer service, plant personnel etc.) to investigate customer order matters related to invoices. Issued debits and credits in SAP accordingly on material and freight

Confidential

Sr. Administrative Assistant

Responsibilities:

• Provided cross-functional administrative support to the Senior Quality Manager, Operations personnel and the Integrative Supply Chain Management team in support of the Confidential Operating System
• Supported key Confidential customers and Operations employees by coordinating visitors, on-boarding employees, facility matters, computer malfunctions and peripheral products critical to perform job duties and functionality
• Ordered office supplies and maintained stock levels, as well as performed research to acquire best pricing for non-stock items needed to support operation requirements
• Created a master supply item list in Excel to include part numbers and vendors to help monitor ordering needs
• Built relationships with Confidential vendors and Buyers to procure non-catalog items
• Utilized PowerPoint and SharePoint to update organization charts and processed expense reports in Concur

Confidential

Administrative Assistant

Responsibilities:

• Provided administrative support to the Center Director and Deputy Director managing calendars, scheduled appointments, attended meetings to compose notes, typed and distributed information to the management team, planned meetings inviting community business partners to support program funding
• Coordinated air, car and hotel travel reservations and submitted expense reports
• Produced weekly statistical reports on student productivity and critical issues pertinent to Center operations; Maintained electronic and paper correspondence files which requires obtaining signatures from outside sources
• Maintained Policy Requirements Handbook to insure it was current and Standard Operating Procedure manuals with updates from internal audit findings complete with required signatures

Confidential, Scottsdale, AZ

Configuration Analyst, Information Configuration Management

Responsibilities:

• Received documents and verified that documents were submitted according to statement of work, utilized Excel to log and track the approval status timeline. Distributed documents via E-mail and maintained SDRL reference catalog in Livelink; certain documents are processed differently according to subcontractor, document type and sector
• Processed Release Notices, Changed Orders and Variation Authorizations for engineering group and incorporated for formal release in TeamCenter (document vault). Promoted engineering documents in Pro/E and routed back to engineering team
• Provided support to the Planning team by scheduling document review meetings, documenting notes, and communicating back to SubK manager. Managed R21 site data in Excel, imported data to the Access database, and produced reports. Compiled all documents for the M24 package of deliverable documents to the Coast Guard, as well as other pertinent documents copied to CD-ROM
• Cataloged data into Rational Clear Quest database based on site requirements such as Sector, Systems & Components. Verified and tracked resources in boxes to the lists supplied by the Materials group and assigned ICM numbers. Prepared a variety of records for storage according to company policy and retention schedule
• Received emails communicating site status which must be incorporated into the trackers or technical documents
• Managed controlled documents in Teamcenter, Livelink, and SharePoint. Updated Excel spreadsheets, reviewed technical documents, maintained subcontractors statement of work, and updated weekly metric reports

Confidential, Phoenix, AZ

Administrative Assistant

Responsibilities:

• Supported two Comptrollers and department staff; scheduled meetings, managed calendars and screened calls accordingly
• Provided excellent customer service to State employees and general public answering inquiries to payroll, vendor payments, W2’s, 1099’s, etc. Handled critical documents for signature, investigation, and response
• Reviewed employee time sheets for completeness and accuracy and processed time sheet adjustments
• Performed Front Desk duties such as distributing warrants and payroll, answering phones and handling inquiries
• Maintained accurate filing system of correspondence signed by the State Comptroller and incoming correspondence. Utilized MS Access to log pertinent documents requiring investigation and resolution
• Prepared for meetings by printing materials and setting up equipment

Confidential, Phoenix, AZ

Administrative Assistant, Purchasing

Responsibilities:

• Supported the Purchasing team by generating management reports, trained colleagues how to perform various functions in SAP, and assisted employees with cell phone technical matters.
• Created new part numbers in Systems Application & Products Database for material planning and purchasing
• Set-up new vendors in SAP, created “remit to” accounts, made changes and extensions for other company codes
• Placed purchase orders in SAP to vendors such as Grainger and McMaster-Carr and maintained delivery dates
• Utilized Excel and SAP to generate monthly reports pertaining to supplier performance, Buyer statistics, inventory accuracy, and cost savings.
• Performed ad hoc queries in SAP and exported data to Excel for manipulation and analysis
• Updated various Excel spreadsheets for regulatory documents such as International Standards Organization certificates required for audits and the Value Analysis spreadsheet with vendor, part number and negotiated savings eligible for a 12 month period