SUMMARY

• Experience in Systems and Business Analysis with over seven years of experience in Programming, Research, Design and Development.
• I have formed a concrete basis in valuations, costing, and projections as well as expertise in probability, options and future markets, statistical analysis, risk management and financial analysis through both work and educational experience.
• I have demonstrated exceptional accuracy in quantitative/qualitative research; accomplished in management of multifaceted research and technical report development.
• In both large corporations, traditional and small enterprise entrepreneurial environments, I have constantly surpassed organizational expectations with exceptional, administrative, and operations skills.
• 7+ years of extensive experience as an Enterprise Liaison between End Users and Technical Groups. Business System Analyst in JAD sessions, face to face requirements gathering with subject matter experts (SME) and end users to translate all requirements into use cases and development artifacts.
• 7+ years of experience in RDBMS (Oracle, SQL Server), SQL, PL/SQL, Procedures and Functions.
• Ability to contribute to the entire software development cycle (SDLC), from gathering requirements through implementation and maintenance.
• Proven mastery of Dimensional Data Modeling, Star Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Strong working experience on Data Warehousing applications, great understanding of the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Strong analytical skills used in business and requirements analysis for a variety of industries.
• Methodology development, process re-engineering, facilitated sessions, proposal development, functional testing and software metrics & other quality assurance techniques.
• Keen problem solving skills, allowing rapid assimilation and resolution of complex problems.
• Excellent written and oral communication skills with the ability to communicate appropriately in business and technical situations at all levels.
• Highly organized and multi tasking; entrusted by management with confidential materials. Adapt quickly to new and evolving environment.
• Focused and hardworking, aptitude for programming, good communication and interpersonal skills.

TECHNICAL SKILLS

Operating System: UNIX 11i, Windows 2000/XP Professional

Languages: INFORMATICA Power Center 6.2/7.1, SQL

RDBMS: Oracle 8, Oracle 9i, SQL Server

Tools: SQL Navigator 4.0, SQL Server 2000/2005/2008 , Varicent 6/7 (COINS), IBM Rational Clear Quest, TOAD for Oracle, Microsoft Visual Studio 2010, Balsamiq Mockups

PROFESSIONAL EXPERIENCE

Business Analyst II

Confidential, Bowie MD

Responsibilities:

• Elicited and documented user requirements and functional specifications using interviews, requirements workshops, business process descriptions, use cases, business analysis, document analysis, and task and workflow analysis.
• Conducted Sprint Planning meetings to analyze and prioritize Sprint Backlog Items.
• Critically evaluated information gathered from multiple sources and product owners, reconciled conflicts, decomposed high-level information into details, and distinguished user requests from the underlying true needs.
• Proactively communicated and collaborated with external and internal customers to analyze information needs and functional requirements and deliver the following artifacts as needed: (Functional requirements Use Cases, GUI: Screen and Interface designs).
• Determined solutions to business problems including support for process improvement, organizational change, or policy development.
• Worked independently with users to define concepts and under direction of project managers.
• Served as the conduit between the customer community (internal and external customers) and the software development team for requirements and translated the requirements to both teams and coordinated User Acceptance Testing.
• Collaborated with developers and subject matter experts to identify technology solutions that address business needs.
• Modeled business processes and workflows to define current and future departmental processes.

Data Analyst II

Confidential, Bowie MD

Responsibilities:

• Provided accurate and appropriate translation of data, applying knowledge to evaluation, analysis and interpretation of data.
• Developed appropriate methodologies for collecting, analyzing and presenting data products by creating the IHA database that was specific to the department.
• Created and maintained the IHA (In-Home Assessment) database and was the technical lead for any data loads and updates to the database.
• Worked closely with various departments within the Prospective Advantage team to provide input into requirements that impacted process, procedures and workflows.
• Worked with the Prospective Advantage team's management, to proactively assess, promote and implement quality assurance management best practices as it relates to data.
• Authored SOP (Standard Operating Procedure) documents and workflows for processes in the Prospective Advantage team.

Programmer/Systems Analyst II

Confidential, Arden Hills, Minnesota

Responsibilities:

• Authored, edited and achieved approval for the RFP (Request for Proposal), distributed it to the vendors and convened conferences to assess the vendor presentations with the IS team and business users.
• Served as the technical point of contact to the vendors for any application and design related questions to assist them in preparing their responses to the RFP.
• Contributed to business requirements gathering and was a liaison between the application development team and the Information Systems team.
• Created the Requirements Traceability Matrix document for the CRV project.
• Extracted and transformed data from PeopleSoft, SAP and flat files and loaded into Varicent using Informatica.
• Assisted the WWSDB (Worldwide Sales Database) team by moving jobs from SQL Server 2005 to SQL Server 2008.
• Organized the IS Sales and Marketing all department meeting and to discuss any issues addressed by members and the future expectations of the team.
• Provided production support in Varicent COINS.

Confidential

Programmer/Systems Analyst I

Responsibilities:

• Accountable for job scheduling and monitoring, performance management, data management, application upgrades, code and data migrations and backup/recovery.
• Provided production support to the business by actively monitoring the existing applications and seeking to improve application availability, quality and performance by ensuring achievement of Service Level Agreements (SLA) and participating in required on-call support.
• Accountable for technical issue resolution including diagnosis of problem, recommendations for workarounds, and defect correction.
• Created and maintained all required technical documentation per IS methodology and processes.
• Maintained collaborative working relationship with IS business partners, IS services (database, data center, servers, desktop, networking, security), and software vendors (Varicent).
• Prepared the weekly issues list and distributed it to the IS Sales and Marketing department.
• Organized and hosted weekly production support meetings with the business and IS team to address the issues list and to discuss future releases and emergency bug fixes.
• Effectively liaised between the business users and IS team.
• Created test scripts and test cases for each production release and vaulted all documents after approval.
• Ensured successful UAT (User Acceptance Testing) after each release.
• Provided training to the business users to assist them in installing software to their machines after system upgrades.

Systems Analyst

Confidential, MN

Responsibilities:

• Liaised with business and functional owners during institution-level review sessions to describe scope and execute action plans, while meeting deadlines and satisfying the data modeling standards.
• Interacted with the data modeler to translate the functional requirements collected from the end users and to make sure that the objects that were provided were completely and accurately represented on the Entity Relationship for Windows (ERWIN) tool.
• Assisted the Quality Assurance (QA) team to design test plans and test cases for User Acceptance Testing (UAT).
• Ensured that all documents complied with corporate Software Development Life Cycle (SDLC) policies and guidelines.
• Prioritized outstanding defects and system problems, ensuring accuracy and timeliness.
• Conducted Joint Application Development (JAD) sessions with stakeholders throughout SDLC to resolve open issues.
• Validated technical designs created by the developers against functional specifications.
• Assisted the developers in troubleshooting problems by checking sessions and error logs.
• Participated in performance tuning for existing INFORMATICA mappings and created and updated the software best practices documents.
• Created Modification Requests (MR) to report errors or bugs in the software.