We provide IT Staff Augmentation Services!

Senior Systems Consultant Resume

5.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY:

Professional experience in an area of Information Technology in diverse aspects of systems analysis, development, reporting, testing, software implementation, severs administration and configuration of Service Oriented Architecture Applications. My background, proficiency and experience include the following:

  • Administered SQL Server 2008 Enterprise Edition
  • Produced numerous financial reports and developed dashboards
  • Programmed extensively in SAS creating tools and performed statistical analysis using large data files
  • Performed administration of SAS Environment
  • Wrote various Stored Procedures and SQL Ad-hoc queries
  • Developed End-to-End component-based Applications running in SOA environments
  • Used Java/JavaScript/Net.Data in accessing, modifying and displaying Legacy data
  • Developed and hosted Internet/Intranet Web Applications
  • Programmed in C/C++ developing API's
  • Worked with Large Enterprise Relational Databases
  • Performed data mining, modeling, and conversion from multiple sources
  • Conducted Quality Assurance and UAT Testing
  • Performed Software Configuration Management
  • Managed mid size team in fast-paced, high-stress and deadline-oriented environment
  • Delivered training, presentations, and performed technical interviews
  • Applied Best Practice and conducted Post Implementation Support
  • Involved in improving Business/Customer relationship within Private and Federal Government sectors
  • Worked as a contractor and a permanent employee

CAREER DEVELOPMENT:

JUL 2010 - PRESENT Senior Systems Consultant - Confidential, Arlington, VA

  • Worked as a contractor at the U.S. General Services Administration (GSA) Federal Acquisition Service (FAS) Agency to provide expertise in various areas of Information Technology, especially database administration of MS SQL Server 2008 Enterprise Edition environment, relational database design, data storage, normalization and retrieval. Utilized SQL Server Database to develop reporting dashboards and implement solutions that increased Global Supply business operations of FAS Portfolio. Engaged in Business Operations Support modernization efforts to improve efficiency of core systems. Conducted analysis and prepared requirement documents to resolve current system issues and improve interfaces used for exchange of sales data between GSA and Department of Defense. Automated numerous monthly and weekly financial reports. Helped the client to move forward with a process of transforming GSA to result-oriented agency that better responds to other government agencies and private business inquiries.

Environment and Tools: SQL Server Enterprise 2008, T-SQL, Business Object, MS Project, sFTP, MS Office, MS Visio

FEB 1999 - MAR 2010 Software Engineer - Confidential, Ashburn, VA

  • Performed systems analysis, administration of SAS Environment and developed wide range of statistical research tools utilizing SAS/GRAPH, SAS/STAT, SAS/FREQ, SAS/REPORT, SAS/TABULATE, SAS/MEANS, SAS/SQL and SAS/ETL which helped client to gather information that was critical for him to prepare for FCC Virginia Long Distance Filling and testimony at District Court that proven to be successful.
  • Created and hosted VZ450 state-of-the-art Quality Web site running on WebSphere Application Server installed on OS/390/400 platform to improve timelines of interfacing applications. Developed real time reporting and tracking alerts of data content and transferred verification checkpoints between various servers using JavaScript, Java, DB2, NET.DATA, SAS/SQL, SAS/ETL and Flash. Delivered solutions to resolved data errors, improved system effectiveness, functions reusability and decreased CPU usage. Performed Server Administration tasks that included: tuning, backup, configuration, etc. Efforts lead to the second Excellence Award recognition.
  • Supervising multifunctional IT team of six members developed BOS/BDT validation tools for Electronic Form of billing for CLEC customers using Mainframe version of SAS 9.x, C programming language, JCL, DB2, MS Access Database, CA-7 and WinCron scheduler. New tools extremely expedited time consuming verification process and insured the quality of data being passed down stream. Additionally, they reduced overall processing time by 18% and eliminated interaction with legacy system. In final stage of project completed documentation and performed training on new software functionality. Efforts were recognized with presentation of the Excellence Award.
  • Conducted successfully software Configuration Management tasks to implement new software into production for large number of releases. Delivered seven brand new API's for software application acquired from Group1 by Verizon to manipulate AFP IBM format at machine level using C and C++ programming languages running on MS Visual Studio Platform. Performed day to day support of large business customers using Web and Batch Applications to bring up optimization, decrease cost, increase performance, enhance quality and apply the best Information Technology solutions available on the market. Conducted QA functions to validate final program elements and install new jobs to Production environment. Multiple times proved to Senior Management Team how to deliver outstanding performance while working on large scale mission critical projects from initiation phase until production implementation.
  • Established new Application Test team for ExpressMedia Group. Developed required processes for the most effective way of testing software at Application and UAT level. Conducted intensive training via Power Point presentation sessions for new team members that included: creation of test cases, extraction of test data, execution, troubleshooting and detail validation. Participated in process of interviewing and hiring new employees for different positions on Application Test and Development Teams. Hosted and represented Application Test Team during numerous project meetings across organization and tracked projects status using MS Project software. Worked with Development Team to find the best and most feasible solutions to satisfy business needs and implement quality software. Completed successfully configuration management requirement and software production implementation for significant number of releases.

Environment and Tools: SAS (9.x,8.x) on MVS and Windows Platform, OS/390/400, UNIX, MS Visual Studio, DB2, Oracle, MS Access, MS Office 2007, JavaScript, Java, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/MEANS, Exposure to SAS 9.1.3 ETL Studio, MS Visio, MS Project, FPT, Flash, SQL, JCL, DOC1, XML, DHTML, VZ450 File Format

OCT 1996 - JAN 1999 Programmer/Analyst Consultant - Confidential, Fairfax, VA

  • Espire - Implemented Arbor Lockbox (LBX) automated payment process that resulted in 20 % increase in application efficiency. Generated the input file for the lockbox application, set up environment, and performed intensive troubleshooting on the part of the software that was never used before. Created API using C and Perl language programs running on UNIX platform to parse and merge data for the lockbox input file. Executed unit, string and UAT test for implemented software. Developed and documented workflow process for LBX using MS Visio. Conducted knowledge transfer to the client in the final stage of the project.
  • Pacific Bell, Bell Atlantic, Ameritech - Performed analysis on the Year Twenty Zero-Zero Project for two systems: Bureau Link and Collection System (CACS). Assessed and evaluated every module on the system for new millennium bug. Executed numerous SQL queries against DB2 Databases to extract date sensitive data. Prepared analysis documents for client system and reusability of year two thousand SoftCare product as an alternative to solve the problem. Completed documents' comparison for NYNEX, Ameritech, and Pacific Bell showing similarities and differences in systems from missing century problem perspectives.
  • Confidential, Brought on board to strengthen base of technical skills for STRATA 3.0 Project that required ability to perform design, development and testing of new online functionality. Additionally, took ownership of setting up mainframe development environment and coded the new letters modification screen in CICS language. Performed modifications of five existing screens and developed test cases to verify data validity in the process of data request and execution/return transaction. Scheduled and managed new JCL Jobs/modules delivery to CBIFT Environment. Participated in all aspects of testing and production readiness activities. Supervised installation of software into Production.
  • Confidential, Worked as a member of team to develop interface between Bureau Link and STRATA software for RAP Project. This effort involved installation of RAP 2.0 Baseline, conforming COBOL, JCL and CICS modules to AT & T conventions and standards, downloading required system files, writing and modifying migration code, running UAT, shipping modules to production and completing online documentation for final product.

Environment and Tools: UNIX, MVS, OS/390, Perl, JCL, COBOL, CICS, DB2, MS Access, VSAM, SQL, JavaScript, HTML, MS Visio

TECHNICAL EXPERTISE:

Programming Languages: SAS, SQL, T-SQL,JAVA, C/C++, C#, DHTML, XML, UML, PERL, ABAP/4, JCL, COBOL, CICS
Operating Systems: UNIX, OS/390/400, MVS, Windows Family
Databases: DB2, Oracle, MS SQL Server, MS Access
Software: MS Project, MSOffice 2007, MS Visio, Lotus Notes, SAS ETL Studio
Others: TCP/IP, Perl/CGI, HTTP, WebSphere Server, J2EE, SOA, TSO/ISPF, CA-7, AUTOSYS, ADO, ASP, Flash, VB, Shell Script, JavaScript, VBScript, DHTML, CSS, sFTP, BCP,WinRunner, VZ450 Billing Format

CERTIFICATIONS:

SAS Certified Platform Administrator for SAS 9
SAS Certified Base Programmer for SAS 9
SAS Certified BI Content Developer for SAS 9

EDUCATION:

M.S., Energy Policy and Climate (in progress)
Training in: Quantitative and Qualitative Methods of Analysis
B.S., Information Technology
Diploma in:Leadership and Management,
Web Programming,
Web Databases,
Web Security

AFFILIATIONS: Member of Project Management Institute
Member of SAS Institute

AWARDS: Bill Manager Footprint Wide Standardization Excellence Award Finalist
BDTQ Excellence Award Finalist

We'd love your feedback!