SUMMARY:

• IT consultant providing excellent business analysis, data quality assessment, requirements definition, and software testing support to corporate and government user bases.
• Works closely with corporate/gov’t personnel and business users in the development and implementation of information technology and data quality initiatives that support the strategic objectives of the organization.
• Applies deep expertise in information quality assessment and business process reengineering to develop metrics that improve the reliability of an organization’s critical information.
• Proactively supports the customer by analyzing business needs, developing detailed requirements, and validating solutions using existing SDLC/PMLC protocols.
• Acts as a SME and effective liaison between the business users and technical implementers of the system.

SKILL:

HARDWARE: IBM, various PCs

PROCESSES: Agile, SDLC, Waterfall, SQL, TIQM, ISO, ISO9001 CMMI Level 3, SPC, UML, BPR/BPM

LANGUAGES: Java Swing/Java Foundation classes, OO design and analysis, XML. Other Javascript, PHP, Perl

SOFTWARE: DOORS, XML Spy, HP Application Life Cycle Management (ALM), Visio, PVCS Tracker, HP Quality Center, TOAD, Rally Software, Rational ClearQuest, EDW (SAS), Ascential s Integrity Designer, Interwoven 5.0, MS Front/Page, Home/Site, Dreamweaver, Adobe Photoshop, Apache Tomcat 4.0, IBM Websphere 3.5, Blazix, Perforce, CVS, Visual Age for Java, Visual Caf 4.0, JBuilder, IBM Host Publisher, IBM Host Simulator, Talisma, WS FTP32.

DATABASES: SQL Server, Sybase, Oracle, DB2, Access 2010, Mail.dat

EMPLOYMENT HISTORY:

Confidential

Sr. Business Analyst

Responsibilities:

• Provided business and functional analysis support to the Benefits Management Application (BMA) suite, consisting of Spectrum, AWA and SAT.
• Provided development, modernization and enhancement (DME) support utilizing Oracle technologies, TOAD, and HP Quality Center.
• Created the Agile Process Guidebook and Phase 2 user stories for the P3M Integration and Implementation project team

Sr. Business Analyst

Confidential, Reston, VA

Responsibilities:

• Supported the Confidential ’s Enterprise Services, Architecture and Governance organization on the Data Rights, Usage and Management (DRUM) project, as well as the National Merit Scholarship data cleanup initiative.
• Reviewed requirements and other artifacts and decomposed into activity diagrams, source to target mappings, system use cases and supplemental specifications.
• Developed SQL using TOAD to analyze the data quality of school/student data and recommend improvements.

Sr. Business Analyst

Confidential, Herndon, VA

Responsibilities:

• Performed detailed metadata analysis for data attributes feeding the Multifamily Target State warehouse.
• Collaborated with data modelers to ensure that the data model met business requirements.
• Worked with business leads and users to ensure alignment with industry data standards while identifying potential data gaps. Interviewed SME’s to improve metadata in the data mart and developed weekly metrics and other reports for stakeholders.
• Developed SQL using TOAD to identify business rule/data quality noncompliance for Critical Data Elements ( Confidential ) and set specifications for acceptable data quality thresholds to ensure Confidential ’s met quality needs.

Sr. Business Analyst

Confidential, Washington, DC

Responsibilities:

• Provided on - going business analysis and technical support of the PostalOne System throughout the Software Development Lifecycle (SDLC) of design, development, testing, deployment, and maintenance, using HP Application Life Cycle Management (ALM) requirements storage/tracking tool.
• Collaborated closely with IBM business analysts and testers to complete deliverables.
• Conducted data analysis and wrote business rules against the data specifications known as Mail.dat and Mail.XML which are the core of the Confidential IMb full-service program.
• Communicated and collaborated with external and internal customers to analyze information needs and functional requirements, and delivered the following artifacts as needed: Business Requirements Document, Process Flow, work flow and data flow documents, Use Cases, training guides and materials, user and technical guides.
• Served as the conduit between the customer community (internal and external customers) and the software development team through requirements flow and developed requirements specifications according to standard templates, using natural language. Collaborated with developers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs.
• Provided technical expertise in an Agile (scrum) environment to support Customer Reg system address data cleanup; developed SQL to identify business rule/data quality noncompliance. Created the user story for the Address Quality Meter.

Senior Business Analyst

Confidential, Washington, DC

Responsibilities:

• Prepared the SDLC deliverables and supported user acceptance test process for the Case Management System ( Confidential ) version 3.0 upgrade. Confidential is the legacy application managing cases in which Confidential has assumed payment of benefits to plan participants.
• Developed and tracked Confidential requirements using HP Quality Center; monitored Confidential internal and external user incident reporting using PVCS Tracker.
• Created SQL scripts using TOAD to query the Confidential Oracle 10g database for eliciting data business rules and allowable values
• Wrote functional and non-functional specifications through UML use cases, interaction diagrams, and technical modeling
• Negotiated conflicts between Confidential ’s Enterprise Data Model and Confidential subject areas.
• Developed Interface Control Document (ICD) agreements between provider and interfacing apps about what/how data was exchanged and procedures for updating exchanges.
• Facilitated information quality standards and Enterprise Data Dictionary best practices at Confidential .

Data Quality Specialist

Confidential, Arlington, VA

Responsibilities:

• Developed a Data Quality Management Guidebook and Enterprise Data Dictionary for Salesforce data.
• Developed DQ scoring criteria and assessed the data quality of mission-critical Accounts, Contact, and Activity information.
• Recommended online Data Quality Dashboards for ongoing monitoring of non-compliant Salesforce data.
• Completed a Quality Assurance Audit of the program’s Requirements Development procedures, as required by Confidential ’s ISO 9001:2008 certification, CMMI Maturity Level 3
• Catalogued capability gaps in the existing service architecture (including web architecture) at the Commission and gathered requirements for a new Matter Management Data Mart, using dimensional modeling as the framework.
• Worked closely with Bureau of Competition authorities and other stakeholders to address knowledge gaps in the Commission’s information architecture.
• Assessed the quality of mission-critical data supporting the Data Mart (deficiencies in the data used to update the Physical Data Model).
• Created SQL scripts to elicit data quality business rules and non-compliance thereof.
• Developed new guidance on FTC Metadata Management and Data Standards, and developed a framework for FTC’s Metadata Repository.
• Developed and implemented information quality assessment and improvement programs.
• Oversaw data corrective maintenance initiatives, and recommended improvements to development and business processes.
• Facilitated information quality standards. Coordinated information quality training and delivered seminars on data quality and data management to all levels of the organization.
• Authored 16 data assessment and certification reports per year for major information systems. These reports enabled the organization’s executive management to justify system modification, redesign, retirement, or scrap-and-redevelopment, without loss of data quality and without any downtime in essential business processes or technical functionality performed by the system.
• In addition to the “Total Information Quality Management Operations Guide,” authored the following major reports: “Evaluation of HUD’s Current Data Management Technologies,” “DQ Certified System Repository: Report & Briefing”, and “Annual Performance Plan Data Validation Guidebook.”
• Co-authored HUD’s “Total Information Quality Management Handbook” and “Baseline of Federal Agencies’ Data Management Practices, Policies and Procedures.”
• Acted as a “data archaeologist” to retrieve data documentation from the organization. Was familiar with a variety of media and data collection strategies, and was able to synthesize disparate documentation sources into a unified whole.
• Set data quality criteria (dimensions), prioritized data elements for quality inspection, and formulated precise business rules for testing the elements’ quality.
• Tracked metrics and trends surrounding the input, processing, and output of data from various computer programs or systems (including web systems and business intelligence software) at the organization that were responsible for storing data. Business intelligence tools audited included Cognos and Microstrategy.
• Functioned as review specialist and revision coordinator for newly developed or modified information retrieval systems.
• Completed a new version of the DOI Data Quality Management Guide.
• Developed a Data Quality Training module and trained Bureau ADS Managers.
• Prepared the Confidential Total Information Quality Management Handbook.
• Defined and implemented SBA’s first Data Control Board (DCB), composed of members of the Business Technology Advisory Council (BTAC), whose role is to direct and facilitate the continuous improvement of information quality at SBA.
• Co-authored SBA’s “Assessment of Data Management Procedures, Frameworks and Practices”.
• Coordinated information quality training and delivered briefings on data quality and data management to SBA’s CIO.
• Implemented HUD’s DQIP Methodology and customized its processes to fit the DLIS culture.
• Worked with DLIS’s Data Integrity Branch to develop a strategy for prioritizing and targeting analyses of logistics information systems and areas that could provide the greatest return on investment as measured using the DQIP.
• Provided an understanding of the technical quality of information flow between designated feeder systems into DLIS’s web portal and legacy logistics information system.
• Documented any rule violation -- as well as the forensics -- associated with the information exchanges between these systems.
• Measured the Accuracy, Consistency, Completeness and Concurrence of data identified as “key” for supporting critical legacy system business functions
• When a problem area was identified, developed a problem statement and recommended solutions to enable the Data Integrity Branch to target efforts towards investigating and developing a cohesive and successful corrective action plan.
• Once a Baseline Assessment of the quality of a key business process had been completed and efforts begun to improve data upstream, provided a repeatable process to DLIS Data Quality Monitors to measure key indicators of the quality of the data or data stream.
• Supported the production of a compliancy matrix as a means to measure the effectiveness of the data quality analysis and solutions put in place.
• Converted IBM mainframe 3270 case-database into Java Beans using distributed-object, three-tier Java architecture known as “JADE” to build a web interface of XML, servlets, additional Java Beans and Java Server Pages (JSP) to input and output data to a browser.
• Assigned user stories to develop and test to completion in IBM VisualAge for Java, mapping screen transitions to IBM Host Simulator “trace files.”
• Created State Activity Diagrams in Visio, Java classes, JSPs, “story-test” specifications, and Host Publisher IO’s.

Confidential

Web Developer

Responsibilities:

• Wrote JAVA Servlets/JSP/XML applications and directed two web technicians in website maintenance, content management, and programming support for three of SFA's Internet and intranet sites.
• Assisted the Webmaster in website hosting, server configuration, and load balancing; sites used Interwoven (Web content management software), Home/site 4.2, Java servlets, JSP, and XML.
• Selected as Task Leader to redesign Dept. of Education’s main “SFANet” intranet from a “stovepipe” to a portal concept. Maintained production schedules and worked closely with client to define and document Information Architecture.
• Oversaw development of a Career Zone section of the SFA intranet to enable users to select a course on line and proceed to another website to register. The section features a servlet-enabled feedback page using the JAVA mail API to forward comments on to the Career Zone mailbox.
• Developed and deployed an “Acronym Finder” application using servlets/JSP.
• Developed and deployed a JAVA “XML Generator” application to create XML files on the fly as data suppliers for certain HTML pages, reducing the time it took to create those pages from several hours to just a few minutes