Data Analyst Resume , San Francisco, CA - Hire IT People

SUMMARY:

Over twenty - six years of information technology experience holding various technical specialist positions relating primarily to the design, construction and maintenance of large software systems.

Hands-on experience in all stages of system development efforts, including requirements definition, design, data modeling, architecture, testing and support.
Particularly skilled at problem analysis and resolution
Self taught in many job skills and able to apply previous experiences into new areas quickly.
Demonstrated capacity to design and implement complex algorithms and program logic.

TECHNICAL SKILLS:

Languages: JavaScript, DB2 Stored procedures, Excel VBA, XML, Micro Focus, SQL, HPS, COBOL II, PL/SQL, Easytrieve, JCL, REXX, TSO CLIST.

Databases: DB2 (MF), DB2/2 (PC), Oracle, SQL Server, IMS/DB, CA-IDMS, VSAM, Datacom.

Operating Systems/TP Monitors: CICS, IMS-DC, VSAM, MVS/ESA, OS2, Windows NT/XP, UNIX

Data Transmission: Connect Direct/Enterprise (NDM/mailbox), MQ Series, FTP

Tools: Tableau, SSMS, Excel, ETL, TSP/ISPF, Micro Focus Workbench, ABEND-AID, File-AID, QMF, SPUFI, XPEDITOR, SmartTest, InterTest, PDX, Changeman, ETL Process, Endevor, Eclipse.

Hardware: IBM 43xx/309x, OS/370, OS/390, IBM PC

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Data Analyst

Responsibilities:

Data analyst on a Finance project to enhance existing reporting to both improve the quality of the source data and satisfy a number of audit requirements.
Delivered a data mapping document that mapped the projects financial reporting data to the PWM HUB warehouse data.
Implemented an enhanced version of the Banks scheduled financial reporting, using the HUB data that included new SQL server database, stored procedures, a new UI, VBA code and Control-M scheduling.
Final implementation stored our golden version of the reporting data in the PWM HUB making it available for other downstream consumers.

Confidential San Francisco, CA

Lead Analyst/Developer

Responsibilities:

Lead analyst on a project tasked with enhancing and performance tuning our external communications with third parties from the Schwab mainframe using DB2 data. Our changes resulted in a sixty percent improvement in overall Mainframe DB2 batch times for our DTCC account registration and customer position reporting.
Lead a team of analysts on a high priority SEC research project analyzing Schwab's mainframe transactional data on all Mutual fund trading over a six-year period. By developing several high-volume processes executing COBOL, Easytrieve programs using DB2, Oracle and VSAM flat files we delivered a scope of impact to senior management presented in Tableau.
Moved the security master team initially to tackle long standing technical issues with the way their batch processing was performing. In the first six months, after performance tuning the executing DB2 SQL statements, we were able to reduce key batch process runtimes by close to eighty percent.
I was the backend lead analyst/developer on the multi-year project to modernize our underlying core securities data and transition the applications that use it. I was responsible for the research and delivery of a comprehensive Security Master Data dictionary and field mapping document as well as the design and creation of the XML/Cobol translation layer that allowed us to maintain the old and new data sources. Although this go-live had a hard delivery date and was considered high risk we went live on time with very little issue.
Joined Schwab to work on a first of a kind BPM project using Lombardi Teamworks. The project required us to integrate many Schwab services into the Lombardi product as well as an external portal for fund companies. Over the course of the two-year project we implemented a workflow that had the effect of reducing the new Mutual Fund setup times by up to sixty percent. The workflow application team won a Schwab excellence after go-live.

Confidential, Cary, NC

Software Consultant

Responsibilities:

Recruited to Mutual Funds to assist with a companywide initiative to retire all Schwab applications that rely on the obsolete HPS runtime, replacing where necessary with CICS/COBOL DB2 applications. I developed a method of monitoring all HPS activity in Production, converted several batch and online transactions and devised a method of routing transactions without the need for client changes.
Cashiering had a need for HPS/CICS/Cobol DB2 expertise. Projects completed included the design and development of electronic enrollment to allow cash transfers (web and VB clients), cash posting re-write, new IRA regulatory changes. In 2003 funding was approved for a full rewrite of the move money application. We engaged offshore resources to deliver code based on our requirements specification written from the application HPS code and went live toward the end of 2004.
Developed a multi-tiered distributed Human Resource application using the Seer*HPS toolset from the analysis, design, construction to the mentoring of both client and consulting staff.

We provide IT Staff Augmentation Services!

Data Analyst Resume

San Francisco, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship