We provide IT Staff Augmentation Services!

Technical Support / Data Analyst Resume

Hayward, CA

OBJECTIVE:

  • Seeking a position as a Software Applications Consultant

SUMMARY:

  • Over sixteen years of experience in the financial, and banking industries, designing, developing, quality assurance, and implementing software solutions to support strategic business objectives for open systems operating environments, and enterprise applications.
  • A proven hard worker willing to put in the extra time and effort to get the job done.
  • Outstanding work ethic and effective interactions with all stakeholders.
  • Familiarity with the software development life cycle, from identifying requirements, design, developing, testing, quality assurance, integration, implementation, and continual support.

TECHNICAL SKILLS:

Languages: SQL, Shell Scripting, Ab initio, XML, C/C++, Cobol, JCL, Perl, HTML

Operating Systems: UNIX (AIX, Solaris), MVS/390, IBM USS

Databases: IBM DB/2, UDB, DDL, DML, Data Mapping

Development Tools: Sync sort, SFTP, Cleartool / Clearquest, Universal Modified Format ( UMF ) Data, Toad for UDB, Aqua Data Studio, File Aid, TSO/ISPF, CA Endevor, Erwin, NDM, ISPF

Testing Tools: SoapUI, HP Quality Center

Current Learning: Python, SSIS and SSRS packages

PROFESSIONAL EXPERIENCE:

Confidential, Hayward, CA

Technical Support / Data Analyst

Responsibilities:

  • Gathered all the financial data records, reconciled them with the bank statements
  • Assisted the organization on technical support issues
  • Completed all financial tax documents needed to bring the organization up to legal status
  • Completed and filed state documents in order to get exempt tax filing status from the state
  • Created the bylaws of the organizations status with the state secretary office in California state
  • Promoted the organization using the Web for all the community events

Confidential, San Francisco, CA

Senior Software Consultant

Responsibilities:

  • Wrote wrapper run scripts ( Korn shell / Ab initio ) that executed application ETL jobs
  • Validated report fields using SQL queries
  • Wrote extract graphs to gather the specific data per the application plan requirements
  • Worked with development to analyze code defects that required changes
  • Wrote overall test plans, and detailed test cases
  • Conducted test plan and test case acceptance review meetings with business clients, and developers
  • Conducted web browser ( IE, Firefox) user interface ( UI ) testing
  • Loaded required test data in to the Micro Strategy Servers
  • Provided configuration help and mentored on testing approaches to subordinate testers
  • Supported User Acceptance Testing (UAT) for business clients & production implementations
  • Conducted end to end application testing for downstream applications
  • Conducted application bench mark performance regression tests

Confidential, Milpitas, CA

Senior Software Developer

Responsibilities:

  • Developed applications with embedded SQL code within Ab initio that used different schemas of databases
  • Design, developed, implemented, documented multiyear projects using SQL, and Ab initio ETL tool
  • Developed applications that consumed 100 million large record data sets using Ab initio
  • Developed graphs with continuous flows, using different platforms, ( MVS/Open Systems)
  • Developed graphs with Ab initio Conduct - it software
  • Analyzed data at the field level on a conversion application project.
  • Converted EU data feeds that were on MVS ( USS) to AIX servers on two centers primary/secondary
  • Maintained Confidential internal data (UMF) format parser written in C++ and Ab initio custom component
  • Conducted sizing and estimates of development costs and timings
  • Documented Analysis and Design for core application projects
  • Conducted end to end application testing for downstream applications
  • Conducted numerous application bench mark performance tests
  • Trained operational and support staff on applications

Confidential, Orangevale, FL

Senior Software Developer

Responsibilities:

  • Developed the applications were two different processes were combined into one continuous running ETL solution
  • Conducted in-depth research on field mismatches with front end written in TPF transaction services
  • Documented Analysis and Design for core application projects
  • Conducted end to end application testing for downstream applications, with internal and offshore teams
  • Conducted performance tests of the Ab initio written code, this allowed the code to be optimized
  • Trained operational and support staff on applications

Confidential, Foster City, CA

Senior Software Developer

Responsibilities:

  • Developed mission critical applications using Ab initio, Shell scripting, COBOL, JCL, SQL
  • Maintained Confidential internal data ( UMF ) format parser written in C++ and Ab initio custom component
  • Lead Developer on a multiyear projects to convert extract applications from MVS/Cobol to Unix/Ab initio
  • Designed, coded, tested to efficiently manage storage of 3000 files produced daily
  • Developed and maintained a multi-terabyte BI data warehouse that housed over 150 tables in support of approximately 15 applications
  • Converted legacy applications written in Cobol I that was using datasets to Cobol II for DB/2
  • Created data dictionaries in conjunction with business analysts, and DBA
  • Assisted business users with Micro Strategy reporting
  • Supported Quality Assurance through functional, regression and end to end testing
  • Performed analysis and enhancements to existing applications on business releases
  • Coordinated semi-annual business releases with all other divisions in the company and all bank member customers
  • Thoroughly researched very complex transactional issues and questions for business clients
  • Provided on call support 24 by 7 on a bi-weekly basics
  • Mentored junior team members

Hire Now