Data Analyst

Skills

Employment History:

Confidential

Systems Analyst/Business Analyst

Responsibilities:

• Perform monitoring, maintenance, Unix commands, crontab file maintenance, server software maintenance, log analysis, and recovery testing for 2 Windows 2003 file servers, 3 Windows 2003 Virtual Servers, 2 Unix servers, 1 Web Server running Unify Vision processes, 2 IBM CDROM printers, and 2 Linux database servers.
• Worked on SDLC IT project management experience and good understanding of Agile methodologies
• Experienced in design, development, and testing, and managing small IT projects with minimal oversight.
• As a business analyst I used to focus on requirements gathering necessary to analyze data.
• Developed SQL queries used in dashboard application creation.
• Developed reports using a variety of business intelligence tools.
• Creating functional and technical requirements, documentation, use cases and test plans.
• Extensive experience in analyzing, compiling, verifying, extracting, converting data, validating data and identifying data inconsistencies and errors.
• Creating metadata/data dictionaries and designing and implementing reports and creating database views on multiple government projects.
• Had knowledge of data warehousing concepts
• Worked with data architects in the design of database schemas.
• Provided troubleshooting, operations, maintenance, and database support for an Oracle database using SQL Navigator 4.2 for USPTO's Order Entry Management System.

Confidential

Database Analyst/ Business Analyst

Responsibilities:

• Working in support of the Assistant Chief of Staff for Installation Management's Installation Status Report program.
• Assists in designing, and implementing the Dept of Army real property Database.
• Such activities involve interaction with developmentand end-user personnel to determine application data access, change requirements, and other pertinentdata required to develop and maintain databases.
• As a business analyst I used to focus on requirements gathering necessary to analyze data.
• Developed SQL queries used in dashboard application creation.
• Responsible for analysis and design activities associated with the development and maintenance of the database.
• Worked on SDLC IT project management experience and good understanding of Agile methodologies
• Experienced in design, development, and testing, and managing small IT projects with minimal oversight
• Works independently in most phases of database management.
• Developed reports using a variety of business intelligence tools.
• Extensive experience in analyzing, compiling, verifying, extracting, converting data, validating data and identifying data inconsistencies and errors.
• Creating metadata/data dictionaries and designing and implementing reports and creating database views on multiple government projects.
• Had knowledge of data warehousing concepts
• Worked with data architects in the design of database schemas.
• Creating functional and technical requirements, documentation, use cases and test plans.
• Create and implement applications using MS Access, Excel and Visual Basic for Applications VBA ,to support the Installation Status Report Infrastructure ISR-I .

Confidential

Responsibilities:

• Responsible for the initiation, development, implementation, and review on-going policies, programs, and initiatives for HUDsmulti-billion dollarPublic and Indian Housing PIH Capital Fund. The fund supports 3100 public housing agencies in the nation to assist in developing and modernizing public housing.
• Accountable for oversight of management information systems, and provisions of administrative support services required for the operation of the program office.
• As a business analyst I used to focus on requirements gathering necessary to analyze data.
• Developed SQL queries used in dashboard application creation.
• Worked on SDLC IT project management experience and good understanding of Agile methodologies
• Experienced in design, development, and testing, and managing small IT projects with minimal oversight
• Perform duties as the Requirements/Business Analyst by eliciting requirements from stakeholders, analyzed the requirements, documented them, created functional specifications and performed development tasks according to those specifications, in support of the Capital Fund Formula project.
• Provide technical assistance, advice, and solutions for a variety of management information systems MIS , 5 applicationsaffecting certain aspects of the program office.
• Recommend actions and projects as appropriate in outlining needed resources, projected time frames, and required coordination.
• Developed reports using a variety of business intelligence tools.
• Perform segments of complexity and responsible for assignments concerning the planning, designing, developing, implementing, controlling,and coordinatinga unique set of complex management information processing systems.
• Had knowledge of data warehousing concepts
• Worked with data architects in the design of database schemas.
• Provide data to several entities within HUD such as Office of Strategic Planning and Management, Hope VI and Field Office Operations.
• Extensive experience in analyzing, compiling, verifying, extracting, converting data, validating data and identifying data inconsistencies and errors.
• Creating metadata/data dictionaries and designing and implementing reports and creating database views on multiple government projects.
• Provide guidance in the development and implementation of sophisticated management information methods and techniques to carry out direct audits of MIS activities.
• Test and debug critical portions of software used while applying advanced solutions and techniques to critical problems. Create and implement applications using Outlook, Excel, Sharepoint and Access Visual Basic for Applications VBA to support the American Recovery and Reinvestment Act ARRA by supplying, gathering, and reporting information for grant funding to the Public Housing Authority PHA Community as well as the Capital Fund Formula computation.
• Serves as liaison with PHAs to answer questions and solve problems regarding use and operation of Excel VBA Spreadsheet effecting over 3100 PHAs.
• Creating functional and technical requirements, documentation, use cases and test plans.
• Provide data on Obligation and Expenditure deadlines to assist the Capital Fund staff in grant tracking. Gathered data needed to run the Capital Fund Formula computation via Hope VI GMS, Moving to Work MTW , Real Estate Assessment Center REAC , PIH Information Center PIC , Recovery Act Performance Management System RAMPS and other important data entities necessary in theCapital Fund Formula process.

Confidential

Business Analyst/Software Interface Engineering Consultant

Responsibilities:

• Participated in several Use Case sessions to review, analyze, and evaluate business systems and user needs.
• Documented requirements, defined scope and objectives, and formulated systems to parallel overall business strategies in order to create Interface documents used as a segment of the Automated Commercial Environment ACE Modernization Project.
• As a business analyst used to focus on requirements gathering necessary to analyze data.
• Developed SQL queries used in dashboard application creation.
• Worked on SDLC IT project management experience and good understanding of Agile methodologies
• Experienced in design, development, and testing, and managing small IT projects with minimal oversight
• Supported work for the Interface Control Document ICD Microsoft Access Database.
• Performed analysis of the ICD database to determine problems as well as ways to better access and process the ICD information.
• Maintained many ICD documents on Serena Dimensions Software.
• Worked closely with IBM professionals as the primary Software Interface Engineer in a state of the art enterprise environment.
• Utilized a Software/System Development Life Cycle SDLC Methodology implemented to modernize a system that has existed for many years at US Customs and Border Protection using native COBOL/DATACOM database.
• Had knowledge of data warehousing concepts
• Worked with data architects in the design of database schemas.
• Researched the possibility of using the IBM CICS Transaction Gateway product as an interface to allow a JAVA Client to communicate with a CICS/COBOL server application.
• Created documents addressing certain areas and submitted the documents to government officials.
• Responsible for the various exchanges of information between the new system and an external systemas part of a single interface.
• Extensive experience in analyzing, compiling, verifying, extracting, converting data, validating data and identifying data inconsistencies and errors.
• Creating metadata/data dictionaries and designing and implementing reports and creating database views on multiple government projects.
• Creating functional and technical requirements, documentation, use cases and test plans.
• Used this database to query information to determine data consistency as well as reporting and analyzinginformation to maintain the interface documents.
• Used Microsoft Access to evaluate and report all interface components.
• Accountable for attending meetings in gathering requirements through case and business rule sessions with government officials.

Confidential

Senior Systems Engineer Consultant/Business Analyst

Responsibilities:

• Responsible for system maintenance, system enhancements, and production support of several applications. Analyzed, designed, developed, tested, and implemented CICS Advantage Gen Online procedures, COBOL external Action Blocks, and Advantage Gen batch programs.
• Performed data modeling and constructed PRADs, PADs, and on-line screens.
• Served as team lead of three developers to update several of the project's export applications to support evolving requirements for the Customs and Border Protection Automated Export System.
• Worked on SDLC IT project management experience and good understanding of Agile methodologies
• Experienced in design, development, and testing, and managing small IT projects with minimal oversight.
• Creating functional and technical requirements, documentation, use cases and test plans.
• As a business analyst used to focus on requirements gathering necessary to analyze data.
• Developed SQL queries used in dashboard application creation.
• Creating metadata/data dictionaries and designing and implementing reports and creating database views on multiple government projects.
• Provided technical solutions in DB2/Advantage Gen performance issues, also participated as a Program Developer on the Commodity Redesign project.

Confidential

Senior Systems Engineer Consultant

Responsibilities:

• Accountablefor the technical design of documents as well as the construction and testing of Advantage Gen 6.0 component based/client server insurance claims processing system.
• Tested components, common action blocks and client/server procedures with a test harness.
• Ensured the Visual Basic client application interconnected with Advantage Gen Component Based servers residing on a tandemplatform with an SQL database management system using SQLCI to access the data.
• Employed Client Server Encyclopedia and Guardian 5.3/Task Assistant for file transfers.
• Operated Oracle Enterprise Manager to access data for local testing.
• Designed data flow diagrams fortechnicallydesigned documents utilizing Visio Professional.

Confidential

Senior System Engineer Consultant, Capability Maturity Model CMM Level 3

Responsibilities:

• Maintained the Application and Business Architectures to support development and maintenance of a National Student Loan Data system.
• Documented the as-is architecture and reviewed existing systems and interviewed system users.
• Completed analysis and system specification documents, developed COOL: Gen batch procedures with COBOL external action blocks utilizing SQL, DB2 and MVS JCL.
• Limited maintenance of WEB based applications and targeted an Application Service Provider ASP client and a DB2 server using COOL: Gen Proxy to manage client/server communications.
• Served as team lead on a large development effort of ten developers to update the project's Application and Business Architectures to support evolving requirements for the National Student Loan Data System.
• Exposed to CMM level 3 Software Practices and CMM Level 3 Project Management.
• Created software development plans, requirement documents, preliminary design documents, and detail design documents using CMM level 3 practices.