NOC Customer Support Specialist Resume , Menlo Park, CA - Hire IT People

SUMMARY:

Recently completed a Certificate in Database and Data Analytics at UCSC Silicon Valley Extension.
Over 14 years of experience as an Application Developer and Support for a mission - critical enterprise data warehouse (Teradata EDW) and Hyperion Essbase cubes for financial reporting systems.

TECHNICAL SKILLS:

Languages: SQL, Python, R, Scala, AWS CLI, Shell Scripting (bash, ksh), MAXL.

Platforms / Frameworks: AWS, Spark, Hadoop, Linux, UNIX, Mac, Windows, Mainframe.

Databases: MongoDB, Teradata, Oracle, Hyperion Essbase, MS Access.

Soft Skills: Facilitation, Requirements Gathering, Strong Verbal and Written Skills.

PROFESSIONAL EXPERIENCE:

Confidential, Menlo Park, CA

NOC Customer Support Specialist

Responsibilities:

Special Project: developed a collection process for shift operator metrics to determine outsourcing feasability.
Provided a weekly dashboard with Excel visualizations to the CEO.
Monitor server status for clients world-wide, identify and escalate issues to on-call engineers and communicate with client on ticket status, and act as first point of contact for inbound service requests.
Performed Windows server updates.

Confidential, Chicago, IL

Sr. Specialist Applications Production

Responsibilities:

Cleansed data from Excel worksheets using MS Access then imported data into Teradata mapping tables.
Created ad hoc reports using SQL Assistant for finance department as needed.
Led efforts to establish procedures and perform knowledge transfer of mission-critical financial reporting applications.
Taught cross-training sessions and created documentation for remote and off-shore team members covering Teradata, Essbase, UNIX and Mainframe concepts and support activities.
Acted as sole 24x7 first-tier point of contact for mission-critical applications, addressing production outages and determining root cause until team was cross trained.
Participated in the migration of an Essbase application and associated Kornshell scripts to new production Unix AIX servers with an upgrade to the Essbase version 11. Tasks include: movement of Essbase cubes and data files to new platforms, modifying/testing of shell scripts and creating new job schedules in APPWORX.
Implemented data retention and roll-off process for Hyperion Cubes.
Led deployments for the Monthly Finance Book Close, Quarterly Restates and Monthly Teradata Table updates and Essbase Outline changes.
Automated manual processes.
Attended Agile Bootcamp.

Confidential, Chicago, IL

Sr Specialist Applications Developer

Responsibilities:

Developed and deployed SQL code to refresh data marts in the Teradata Enterprise Data Warehouse and to create extract files used by Business Intelligence Tools for mission critical financial reporting applications.
Coded data extracts using Teradata SQL and Teradata Utilities to transform/ aggregate data per business requirements.
Developed, deployed and maintained Essbase cubes and Essbase Load Rules.
Created and scheduled shell scripts to load and aggregate the data in the cubes.
Performed ad hoc Teradata table updates via SQL Assistant.
Coordinated with IT Operations for deployment of new code in the Production environment.
Acted as Application DBA to create and maintain Teradata tables and table views, grant user privileges and collect statistics.

Confidential, Hoffman Estates, IL

Applications Development Specialist

Responsibilities:

Sourced operational data into Customer data warehouse for Home Services businesses.
Created / modified data loads using Teradata Utilities and SQL to perform adds/deletes/updates on the Teradata tables
Researched issues from an internal audit of the data warehouse.
Addressed issues of relational integrity, data completeness and data conformance.

Confidential, Mountain View, CA

Volunteer

Responsibilities:

Confidential, Sunyvale, CA

Team Lead

Responsibilities:

Participated in the volunter-based career resource center for professionals, which provides a full array of employment and career services.
Served as a Team Lead for the Technical Services group with duties such as conducting team meetings and ensuring support roles are filled.
Orchestrated audio/visual and operational support for meetings of 150 people.