We provide IT Staff Augmentation Services!

Data Analyst Resume

2.00/5 (Submit Your Rating)

Dallas, TX

TECHNICAL SKILLS

Programming: SQL, J2EE, Eclipse, VBA, shell scripting, JavaScript, HTML, XML, FpML

Databases & OS: Oracle, SQL Server, MySQL, UNIX, Linux, Greenplum, MS Access, Mongo DB, Windows

Analysis Tools: MS Excel, R, Splunk, Tableau, SSIS, SSAS, Weka, Google Analytics

Software & Tools: Visio, PowerPoint, Service Now, SharePoint, DataStage, Autosys, Netcool, IBM MQ Certification SAS Certified Base Programmer for SAS 9

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Data Analyst

Responsibilities:

  • Deploy stored procedures with senior developer and performance consultants, and coordinate and perform function and performance testing prior to Production and UAT migration release.
  • Reduce manual reporting process to eventually reduce operating cost by designing BASH scripts and SQL stored procedures scheduled on AUTOSYS to generate reports weekly/on - demand
  • Deploy business intelligence dashboard for Real-Time Dissemination to synchronously reflect top 10 clients who made submissions to GTR and who received NACKs out of thousands of clients.
  • Analyzing complex cross functional business processes and defines integrated requirements for Application Development teams, and providing support to AD migrations to ensure delivery.
  • Investigated root causes of global rejected trade submissions and failed testing submissions via SFTP, Message Queue, and web uploading across all OTC and ETD assets in CSV and FpML formats.
  • Overseeing permit to operate documents to ensure all onboarding applications are properly taken on by AD teams, and communicating with business team to ensure expectations are fully implemented.
  • Troubleshoot any Global Trade Repository related issue resulting in failure or disruption, escalated critical issue for resolution breaching SLAs, and performed daily regional handover activities.
  • Assisted ETL team, DBAs, and Regulator Reporting team in Commodities and Equities application releases and merges weekly on position calculation, ETL, report validation, and report publishing.

Confidential, Lewisville, TX

Business Analyst

Responsibilities:

  • Analyzed business processes for departments including project management, HR, and inventory, and utilized modeling, pivot table, and VBA in MS Excel for business analysis and measurements.
  • Assisted in moving traditional business architecture to cloud with layer patterns analysis, workload analysis, database and storage isolation, and dependency analysis.
  • Collected data from multiple sources using SSIS, and automated daily reports generation processes.

We'd love your feedback!