SUMMARY:

Over 10 years of experience reconciling data, creating reports, defining, implementing, and documenting business processes.

TECHNICAL SKILLS:

R, Python, SQL Server, Excel VBA, Access VBA, SQL, Oracle

PROFESSIONAL EXPERIENCE:

Confidential, Chantilly, VA

Senior Program Analyst

Responsibilities:

• Reconciled data from various data sources.
• Created reports using R and Excel VBA.
• Documented business processes.

Confidential, Chantilly, VA

Senior Reports Developer

Responsibilities:

• Reconciled data from various data sources.
• Created reports using R and Excel VBA.
• Documented business processes.

Confidential, San Jose, CA

Data Analyst

Responsibilities:

• Extracted lists of employees in VP and SVP organizations from an HR database, validated employee title and location from employee data extracted from OrgStats, and flagged employees that should receive training on how to create diagnostic signatures based on whether the employee had “Tech Lead” or “Engineer” in their job title as part of Confidential ’s diagnostic signature initiative.
• Validated employee title and location for employees that did not have a known job title or location in data extracted from OrgStats or in data extracted from an HR data source in Confidential ’s employee directory known as Confidential .
• Extracted the lists of diagnostic signatures by technology (IOS, Wireless, NXOS) from Confidential ’s QDETTs database and added information pertaining to the diagnostic signatures from bug data extracted from Confidential ’s QDETTs database.
• Prepared reports indicating which bugs had diagnostic signatures created by Confidential ’s Confidential engineers.

Confidential, San Jose, CA

Data Analyst

Responsibilities:

• Reviewed service requests created by Confidential Firepower customers. Provided feedback to management as to how to better improve business processes pertaining to the software licensing process.

Confidential, Pleasanton, CA

Data Analyst

Responsibilities:

• Viewed contracts for Confidential ’s clients and determined contract start date, contract end date, location of data center that Oracle software was running on, and Oracle products that the client had purchased from Oracle.
• Recorded this data on an Excel spreadsheet for presentation to Confidential ’s attorneys so that they could provide this information to Oracle as part of eDiscovery in the lawsuit between Oracle and Confidential .
• Viewed remote access documents for Confidential ’s clients and determined environment, database, and the computer that the Oracle software was running on.
• Recorded this information on an Excel spreadsheet for presentation to Confidential ’s attorneys so that they could provide this information to Oracle as part of eDiscovery in the lawsuit between Oracle and Confidential .

Confidential, Santa Clara, CA

Data Analyst

Responsibilities:

• Worked with directors in order to gather requirements for reports that were needed as part of Applied Material’s “ Confidential ” initiative.
• Created reports using SQL Server Management Studio as part of the “ Confidential ” initiative to ensure that all semiconductor equipment parts that failed in production were returned to Applied Material’s service centers.

Confidential, Milpitas, CA

Data Analyst

Responsibilities:

• Managed the service contracts for Confidential internal gear which consisted of adding equipment to contract that needed to be added to contract and removing equipment from contract that was no longer required to be on contract.
• Worked with Confidential ’s Advanced Services to get a contract created for FedRamp for Confidential - Confidential so that equipment for the FedRamp project could be tracked separately.
• Worked with Advanced Services in order to have Confidential - Confidential specific site ids created that designated the data centers specific to Confidential - Confidential and updated the site ids of equipment already on contract in Confidential ’s contract database known as Confidential Service Contract Center.
• Ensured that Confidential internal gear that failed in production was replaced within the 4 hour SLA.

Confidential, San Jose, CA

IT Analyst

Responsibilities:

• Tracked the allocation of SAN and NAS storage on an Excel spreadsheet for various projects in the GIS-IPL organization.

Confidential, Mountain View, CA

Data Analyst

Responsibilities:

• Mapped Confidential ’s Certified Partners accounts to the Channel Sales accounts.

Confidential, Milpitas, CA

Data Analyst

Responsibilities:

• Ran Excel macros that generated sales inventory reports for the Confidential group from SAP, CM, and Excel VBA macros in the i2 environment for account managers that supported Target, Walgreens, and Walmart accounts.

Confidential, San Jose, CA

Business Data Analyst

Responsibilities:

• Received service agreement contract data for Confidential internal gear in the form of Excel spreadsheets that contained contract start date, contract end date, type of contract, and location of data center from Confidential ’s account managers.
• Validated service agreement contract data by uploading it to an Access database and running the validation process that this database performed.
• Uploaded service agreement contract data to Confidential ’s Service Contract Center database.
• Documented the process of validating the service agreement contract data for Confidential internal gear and uploading the service agreement contract data to Confidential ’s Service Contract Center database.