We provide IT Staff Augmentation Services!

Systems Analyst Resume

3.00/5 (Submit Your Rating)

SUMMARY:

Over 25 years of experience supervising, designing, planning, managing and implementing current and new technology for implementing project applications which that provide solutions to business problems. Provide team leadership in the development of innovative solutions to manage the collection, reporting and dissemination of data from a variety of data collection activities that include interactive field, paper and web surveys, medical record abstraction, intelligent scanning of documents, and manually keyed data. He fosters team collaboration with a focus on the overall process of the primary objective of the project.

TECHNICAL EXPERIENCE:

SAS: SAS AF, SAS SCL, SAS Macros, Base SAS, Full Screen products, SAS SQL, SAS Connect

Visual Studio: VB/c#.NET/WPF

Databases: MS SQL Server, Oracle, MySQL, PostGreSQL, SQL Lite

Operating Systems: Unix, Windows XP/7/10 Microsoft Team Foundation Server /Agile Scrum

IBM Mainframes: MVS/JES/TSO/JCL

Test systems: JIRA, Microsoft test system

Source Control: Microsoft TFS, GIT

TECHNICAL EXPERIENCE:

Confidential

Systems analyst

Responsibilities:

  • Consults with clients to identify requirements for applications and systems, develops detailed specifications, and develops custom software applications and systems.
  • Ensures quality, testing, debugging and refining software applications, documenting outcomes and processes. Recommends appropriate hardware and software, integrates files across platforms, and performs troubleshooting.
  • Set up muti - tier development environments for
  • UAT (Independent User Acceptance Testing)
  • Used with client and data provider to independently validate and verify performance
  • Application
  • Database
  • QA First level test mode
  • Production
  • Trains clients and staff in the use of software applications and systems and provides ongoing technical support. Writes and maintains user documentation.
  • Identifies new business opportunities, develops technical approach for work, and prepares time and cost estimates. May make technical presentations to prospective clients.
  • Supervises programming staff, assigning programming activities, guiding and reviewing work, and evaluating performance.
  • Assign task and activities
  • Monitor progress
  • Review performance
  • Provides technical consulting as required with technology and application development
  • Application architecture
  • Software development
  • Maintains technical knowledge by reviewing publications on current trends and developments. Recommends system and software upgrades as appropriate.
  • Database architect for large SQL databases in support of web applications
  • Internally supported SQL databases
  • Cloud based Azure SQL databases (CSP)
  • Works with network staff for FISMA compliancy for CSP and internally supported databases
  • Implement data transfer and migration (ETL) of large scale databases between a variety of database platforms including SAS, Oracle, PostGreSQL, MySql
  • Work with networking staff to manage
  • FISMA compliancy
  • Risk management
  • Develop and implement data quality standards and methods into process workflows
  • Test case development
  • Risk assessment, management, and mitigation
  • Test tool evaluation and implementation
  • CMMI Level 3 certified/compliant
  • Agile/Scrum environment
  • TFS (Team Foundation Server)
  • Apply task driven Project Management skills within a variety of Project Management scenario’s, Agile, TFS, Scrum using Team Foundation Server for
  • Requirements tracking and validation with respect to testing, specific test cases
  • Risk management, mitigation, and documentation that is bound to requirements and tasks
  • Test Case planning and management that is bound to tasks, requirements, and bugs
  • Integrated requirements tracking and validation with respect to workflow, effort, risk

Confidential

Senior systems analyst

Responsibilities:

  • Supervised and managed a team of developers that supported the management (acquisition to delivery) of data for a NCI contract. This involved regular interaction with the client which included peer review discussions and presentations as well as project review discussions (requirements, scope, resource and budget allocations). Projects were managed through resource and task assignments based on budget and resource requirements and task specifications that were driven by the project schedule.
  • Planned, designed, and implemented a VB.NET DPQA application that for Confidential contract that performed database architect and generation functions based on metadata and application parameters. The application significantly reduced the time to develop custom databases that are based on metadata and application parameters.
  • Planned, designed, and implemented a VB.NET web application integrated with other ICR/OCR COTS applications (Teleform, SAS and Dataflux, Active PDF, Adobe SDK) which successfully integrated the collection of data from WEB interfaces, incoming faxes, emails, remote and locally scanned documents into one common database. This eliminated the need to maintain a web of individual applications and databases.
  • Reverse engineered and performance tuned a large scale process based on a Visual Basic/XML/SAS/SQL Server application that transformed legacy data structures to and from relational database structures using ETL cycle techniques which used metadata based algorithms. Dramatic performance improvements were achieved by including DTS packages, table indexes, stored procedures and functions as well as tuning of queries and consolidation simple queries into single queries which produced large scale result sets. SAS AF GUI application was used to generate the results of exhaustive data comparisons based on defined protocols in addition to the management of the process control based on monitoring data/work flow through all stages of data management.
  • Planned, developed, and implemented a large scale process based on SAS/AF and SAS/Connect that achieved the transformation of hundreds of thousands of IBM mainframe tape and disk files driven by a major operating system upgrade.
  • This included the conversion of SAS datasets and format libraries that were created using versions of SAS used in the 1960’s and 1970’s all the way to the current versions of SAS.
  • Managing the process involved the development of SAS application code that performed detailed data comparisons of data included in all file formats (VSAM, PS, PDS, binary, SAS datasets and format libraries, etc)
  • Maintained and managed a large scale process which controlled the flow of data from sample generation, field survey, and data collection and ultimately delivery of data to the client. The process included SQL Server, Oracle, and MS Access databases, MS Access applications and reports, as well as SAS application code that generated detailed management summaries that reported on the status of the data flow in addition to sophisticated data integrity quality control checks.
  • Planned, developed, and implemented a large scale VB/Oracle/SAS system that managed cohort samples for several medical research studies.
  • This included the integration of large scale data updates from a variety of disparate data sources.
  • SAS application code was developed that summarized, analyzed, and reported on cohort data.

Confidential

Senior systems analyst

Responsibilities:

  • Managed a regional information center responsible for training and empowering users to develop user generated mainframe and PC based business applications.
  • Planned, developed, and implemented IBM Token Ring (Local and wide area) and X.25 packet switched networks.
  • Planned and developed SAS applications that managed business activity related database based applications as well as a SAS application used to manage and diagnose underground electrical network failures which significantly reduced the time to locate and repair the cable failures.

Confidential

Senior systems analyst

Responsibilities:

  • Led, managed, and supervised development of leading edge analytical automotive thermal engineering software and hardware applications at the Confidential A/C component supplier.
  • Developed SAS Graph drivers for use with HP graphic peripherals (plotters, terminals) to produce engineering, management and marketing presentations.

Confidential

Engineer

Responsibilities:

  • Maintained and supported large scale mainframe based engineering applications.
  • Developed code management techniques designed to realize significant performance improvements through system load module linking overlays and sophisticated memory caching techniques.

We'd love your feedback!