SUMMARY

• Bachelor of Science from Confidential .
• Business Analyst with 3 years of extensive experience in data warehouse, web - based asset management, and finance with specialization in project coordination, business analysis, and quality assurance.
• Strong knowledge of requirement gathering, business process, and risk-impact analysis.
• Extensive experience in requirement gathering, including creation of data-flow, use case, process diagrams/flow-charts, and current & future data for detail analysis.
• Experienced with assisting SMEs in designing front end applications (UI/UX) using the Macromedia tool (Flash-Dream Weaver) for prototypes.
• Experience in running related jobs of the project using JS Console - Batch Processing.
• Experienced in designing XSD schema to paste XML data into EDS (stage), along with transforming XML data into Open Format using XSLT processor.
• Experienced in performing User Acceptance Testing (UAT) and QA portion of the project.

TECHNICAL SKILLS

Business Modeling Tools: Rational Rose, Microsoft Visio, Macromedia Flash, Dream weaver, Infomatica PowerCenter v7.x,8.x,9.x, Abinitio, XML, XSD, XSLT

Testing Tools: Test Director, Win Runner, JS Console, AutoSys

Operating Systems: MS Windows 95/98/2000/XP/Vista/7, Linux/UNIX, Sun Solaris

Mgmt & Req. Tools: MS Project 2000, Clinical Trial (CTMS)

RDBMS: MS Access, ORACLE 8i, 9i,10g,11g Embarcadero RapidSQL, MYSQL, SQL Assistant, SQL Server

Reporting Tools: MS Word, MS PowerPoint, MS Excel

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

System Analyst

Responsibilities:

• Participated in Inception phase of the Project. Working with Business in complete Project Charter. Ensuring Project Vision meet with the Business Projection.
• Business Requirements Verification and Validation to meet with End User’s needs.
• Feasibility Analysis with Developers to confirm the Technical Specifications.
• JAD sessions with all SMEs to sign-off on Requirements.
• Data Architecture design to meet with Business Rules.
• Data Integration between IAM and Web Portal involved synchronizing Data Base, Web App, and Connection Protocol (batches, data profiling, source files, source to target mapping, etc.).
• Worked with Architect lead to resolve Operation and/or Production Issue.

Environment: Clinical Trial Management System - CTMS, Active Directory - AD, MS Window Server, SQL Developer, Notepad++, WinCDemu, TortoiseSVN, TopTeam, Oracle 12g.

Confidential, Riverwoods, IL

Business Analyst

Responsibilities:

• Participated in Project Management to determine the scope of the project and creating Gantt chart for schedules and milestones.
• Implementing in all phases of the Project; design, development, testing, and deployment within Data Warehouse Environment (Teradata).
• Requirement Gathering includes creation of the Data-flow, Use Case, and Process Diagrams/Flow-charts, Current & Future Data for detail analysis.
• Source-to-Target Execution, analyze the source data, design data mapping based on ETL & Database constraints and business rules.
• Involving in Design & Implement DW, Database Operation; loading procedures, back-up & recovery/mitigation plans.Source to Target Analysis and documentation.
• Assist with SMEs designing Front End App (UI/UX) using Macromedia Tool (flash-Dream Weaver) for prototypes.
• Running related Jobs of the Project using JS Console - Batch Processing.
• Collaborate with various teams (BA, Dev) throughout Application Development.
• Facilitated Join Application Development (JAD) sessions with business and technical users to resolve issues on Business Requirements.
• Conducted Walk-through with Subject Matter Experts to baseline the business architecture.
• Design XSD schema to paste XML data into EDS (Stage).
• Transform XML data into Open Format using XSLT processor.
• Create & Validate SQL statements (DDL) reflecting Data Modeling.
• Optimize the Data Warehouse Operation by revising robust codes.
• Provide solution to Production Issues, as assigned by the Operation Team.
• Using Mload, Fastload, and other Teradata Utilities for the creation of tables, loading process and procedure in according to gathered requirements.
• Active Stakeholder Engagement. Being a liaison between Business and Technical Teams.
• Involved in creating User Manuals as well as providing Training to ensure that End User’s understand thoroughly on Application.

Environment: SQL server, BTEQ Scripts, Ab Initio,JS Console, Teradata Loading Utilities, Teradata V14, Unix, Win SCP, and Secure CRT 6.7, MS Visio, XML, XSD, XSLT.

Confidential, Stamford, CT

Business Analyst

Responsibilities:

• Involved in all phases of Software Development Life Cycle (SDLC) from Planning, Design, Develop, Testing, and Deployment under Agile methodology.
• Created Project Charter, Assumptions, Estimates and Role Responsibilities Documents.
• Defined Project Planning, Business Cases, Scope, Resources, Schedules, Cut-off Date, and Milestones of the projects, and in monitoring progress throughout the projects.
• Data Mining including Data Mapping/ Manipulation of the Current Data to extract relevant data.
• Create As-Is, To-Be Prototypes for the use of GAP Analysis.
• Conducted Requirement Gathering by Interviews, Presentations, Use Cases and Meetings.
• Performed ETL analysis including Source-to-Target Mappings, Impact Analysis.
• In depth knowledge of technical designs and specifications.
• Create Ad-hoc Report & Mock-up data for the Data Prototypes.
• Collaborated Design team in building Web App (UI), and Back-End (UX).
• Verified logical, hierarchical, architectural impact on data modeling design, change proposes.
• Supported DW Operational improvement in Performance Tuning for effective data loads.
• Hosted Weekly meetings, JAD sessions, and provided Status Report to the business users and Off-shore developers to maintain effective communication.
• Data Analysis on multi-dimensional schemas for Issue management and Mitigate plans.
• Converting XML document into Convention Object for Data-Mart using XSLT.
• Involved in Changes Request under supervision of CRB Committee.
• Assisted in verifying Data loads from Staging to Downstream Feeds, JOB Scheduling, and Batching Processing via Unix Scripting, Autosys (Dev), JS CONSOLE (Prod), Appworx, and Informatica Power Center.
• Created the Test Plan, Test Cases, and Implemented Test Scripts to verify the precision of changes met requirements/ business needs as part of the Quality Assurance Performance.
• Formulated/Executed efficient SQL queries for the Data Quality/ Database Management System.
• Facilitated End Users for User Acceptance Testing (UAT).
• Update Architecture Modifications into Data Transformation Matrix (DTM).

Environment: MS Visio, MS Project 2000,Appworx, JS Console, Autosys, Use Case, SQL, XML, XSD, MS Power Point, Excel, Word, WS-FTP, Oracle.

Confidential, Manhattan, NY

QA Analyst

Responsibilities:

• Assisted in development of manual test cases for web based application.
• Provided input and GUI feedback to senior executive management.
• Coordination with Team Lead in the design and documentation of a Test Plan and Test Strategy to ensure Test Cases reflect user need for Functional, User Interface, Performance, and Usability.
• Analyzed Functional Requirement Specification (FRS) and Detailed Use Cases to derive test cases.
• Led functional test case execution efforts and reported findings to head of technical team.
• Analyzed and Approved test cases and test data with Subject Matter Experts.
• Performed Manual Testing based on the User Requirement Document until the application reached stability.

Environment: s: Sun Solaris, Oracle 9i, XML, XSD, Microsoft 2000 Server, MySQL, HTML.

Confidential

Computer Lab Coordinator

Responsibilities:

• Provide assistance to students using Lab.
• Provide Design and Helpdesk services to instructors and students.
• Performed GAP Analysis by comparing Current Process with Future Process to generate the Risk Assessment.

Environment: MS Office: Microsoft Excel, Word, Power Point, And MS Windows.

Confidential, Dallas, TX

Computer/ESL Lab Aide

Responsibilities:

• Translate sentences spoken or written in English into Thai and vice versa
• Check original text to ensure that translation is accurate
• Adapt translations to grade levels as instructed
• Proofread and edit written materials
• Use electronic listening equipment when prompted
• Proofread and edit written materials
• Served as a cultural mediator where necessary
• Translated written documents for different departments

Environment: s: Ms Office Suites, Windows Vista, XP, Rosseta Stones.