SUMMARY:

• Experience as a Project Manager, Business Analyst, Data Analyst, and Developer
• Experience in all phases of the SDLC process

TECHNICAL SKILLS:

Tools: MS SQL Server, MS Project, MS Visio, Sharepoint, MS Access, Oracel PL/SQL, TOAD, Agile, Business Objects, Pledgemanker, Kintera, C++, Visual Basic, HTML, Outlook, Excel, PowerPoint

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Business Analyst

Responsibilities:

• Requirements Analysis: served as a key person between business users and the development team by communicating/evaluating business requests, determining functional requirements (with use case scenarios, process flow and activity diagrams), developing technical solutions, and providing status updates to all stakeholders
• Determined level of effort with developers and database administrators
• Managed Agile sprints and reported sprint statuses to upper management and business users
• Collaborated with the development team and the training team to ensure requested functionality, including system or process workarounds, was represented in the systems training content prior to production releases
• Subject matter expert for various processes: (1) grant applications (2) modifications, cancellations, or extensions to existing grants (3) Portal functionality (4) internal applications: monitoring grants and creating issues for existing grants
• Created, managed, and maintained a backlog of business requests and provided a summary and level of effort for each request
• Developed test plans with Quality Assurance and tested to determine requirements were satisfactorily developed
• Participated in UAT testing and reported defects to the development team
• Wrote and maintained business user aplication documentation and User Guides
• Reported statuses in various forums

Confidential, Washington, DC

Business Analyst

Responsibilities:

• Evaluated loosely defined business requests and determined technical solutions which would fit within the existing technical environment
• Based on the proposed technical solutions, I wrote detailed functional requirements. Requirements were supported with mockups, use case scenarios, and process flow or activity diagrams.
• Presented functional requirements to business analysts, legal users, database administrators, developers, and upper IT managers in JAD sessions to ensure viability and accuracy of the requirements
• Collaborated with developers during the development phase to ensure development complied with requirements
• Collaborated with quality assurance analysts in developing test plans, tested during the QA phase, and reported defects to developers, upper IT management, and business users
• Wrote nine functional requirement packages of medium to advanced complexity. Examples: (1) functionality to swap existing subscriptions to new radios (2) functionality to accept debit cards as a payment option (3) functionality to provide discounted costs for customers with multiple radios

Confidential, Washington, DC

Systems Analyst

Responsibilities:

• Wrote functional requirements which improved the evaluation of grantee quarterly reports: (1) added functionality to create new reports to identify trends (2) to collect additional data from the quarterly reports (3) created new internal reports to better present the information submitted by grantees. All requirements were supported with use case scenarios, report mockups, and process flow or activity diagrams
• Presented proposed requirements to business users, in JAD sessions, to ensure the viability of the solution
• Proposed technical solutions if business requests were deficient
• Developed test plans with quality assurance analysts
• Participated in QA and UAT testing and reported defects to developers
• Provided status reports to the Project Manager and Federal Staff for development tasks
• Maintained/updated business user manuals

Confidential, Washington, DC

Systems Analyst, Database Analyst, Project Manager

Responsibilities:

• Data Analysis:
• Created data dictionaries which identified data for a proposed system which was to be developed and to be based on two Federal immigration forms:
• Form 9089, Application for Permanent Employment Certification
• Form 9035, Labor Condition Application, for H - 1B Nonimmigrants
• Created logical data models and Entity Relationship Diagramts for the proposed system
• Developed ad hoc queries (SQL) against the existing database when business requests were submitted to IT
• Project Management:
• Developed project scope documents, project plans and schedules
• Evaluated functional requirements with system and business analysts in JAD sessions
• Monitored issues with development team to ensure tasks were on schedule
• Reported on status to business users and upper management
• Developed test plans with quality assurance analysts
• Assisted in UAT testing / Communicated defects to development team
• Maintained project documentation including business user manuals
• Collaborated with system administrators, database administrators to ensure project was deployed to the production environment
• Responded to Help Desk inquiries from the public

Confidential, Annapolis, MD

Senior Systems Analyst

Responsibilities:

• Development for Maryland Circuit Court programs using Visual Fox Pro, Borland C++, Java
• Data analysis, SQL programming
• Systems Analysis: requirements gathering and Use Case development for a proposed system which would replace the existing Circuit Court’s programs
• Assisted Circuit Court clerks, managers, and technicians with functional and technical issues
• Maintained audit logs for reported production issues

Confidential, Washington, DC

IT Technology Manager

Responsibilities:

• Managed all IT-related issues for this startup
• Developed and deployed the website
• Researched Department of State visa requirements for foreign registered nurses
• Interviewed nurses
• Negotiated contracts with Indian and U.K. partners
• Utlilized search engine optimization techniques to increase visibility for the website

Confidential, Washington, DC

Database Manager

Responsibilities:

• Database Conversion: managed all issues related to an Oracle database conversion (8i to 9i.)
• Collaborated extensively with business users to determine data relationships and with Oracle database administrators to ensure data was accurately converted
• Managed two major financial databases: one on Oracle 9i and the other on MS SQL Server
• Developed SQL scripts for weekly/monthly/annual reports. Utilized PL/SQL and Business Objects Web Intelligence v.10
• Developed (VBA) programs to integrate various interdepartmental processes
• Evaluated business requests relating to the deployment of Plege Maker, a COTS fundraising database
• Maintained the AIDS Walk database which included registration functionality and financial reporting
• Developed email blasts and webpages using Kintera
• Collaborated with the Clinic’s direct mail vendor to evaluate and improve Direct Mail programs
• Developed SQL ad hoc scripts to monitor the efficacy of fundraising efforts
• Developed SQL scripts which charted donor contributions on a weekly, monthly, and annual timelines

Independent Consultant

Confidential

Responsibilities:

• Consultant for small business firms, individuals, and government contractors
• Customized software applications
• Developed Web sites and customer-defined applications

Confidential, Washington, DC

Senior Systems Analyst / Program Manager

Responsibilities:

• Project Management:
• Managed projects which were moved from a mainframe to a client/server environment
• Evaluated business requrests
• Developed functional specifications
• Developing application solutions (Visual Basic, C +)
• Maintained documentation,
• Developed test plans and assisted in quality assurance and UAT testing
• Developed logical and physical relational databases
• Collaborated with end users throughout cycle to ensure fulfillment of needs
• Wrote IT project proposals defining project scope and parameters. Monitored project status, identified/resolved all related issues, and provided technical leadership
• Developed training modules for business users to ensure requested functionality was represented in applications prior to production releases
• System Analysis:
• Gathered requirements, analyzed, designed, programmed, coordinated testing and deployed eight database client-server management systems including the following:
• Telecommunications Billing: centralized disparate financial files into one integrated database
• Event Registration Tracking/Reporting: stored conference registration information for major conference
• Political Action Committee: Political Action Committee: created a critical system which tracked Congressional member voting records on specific education issues, ranked these Congressional members to determine the amount of the Confidential contribution, maintained financial data which resulted in quarterly filings of Federally-mandated reports with Federal Election Commission
• Participated in research committees which evaluated and selected a SDLC methodology and CASE tools for the IT Department
• Participated in a committee to design the Confidential Web Portal
• Developed various MS Access training modules and presented/taught these modules in classroom settings
• Participated in an election campaign in Puerto Rico to promote Confidential candidates. Provided English/Spanish transalations, presentations

Confidential, Washington, DC

Project Leader, Systems Analyst, Developer

Responsibilities:

• Project leader, systems analyst, and programmer for the IRS audit database, Confidential
• Developed weekly programming enhancements based on requirements submitted by Audit analysts
• Developed, tested, debugged, and coordinated within a development team of three colleagues
• Developed COBOL software applications
• Supported the maintenance of existing applications
• Wrote Functional Specifications (requirements) in collaboration with end users
• Developed and deployed a database reconciliation project at ten regional centers resulting in improved management processes
• Designed and developed 3 COBOL online programs in a Unisys environment; maintained CDC3500 assembly language programs
• Maintained weekly project plans and activities, developed projects Functional Specifications, met with client end users to find technical solutions to proposed processing
• Providing coaching and/or on the job training to junior level programmers
• Presented one Unisys database tutorial in a classroom setting