SUMMARY

• Business/Systems Analyst wif 6 years of experience in business process analysis/modeling, business requirements gathering, database design and development of Web Based, and Client/Server applications.
• Proficient in business process modeling, documentation, and testing using Rational Suite (Rational Rose, RequisitePro, SoDA, ClearQuest, Robot) as well as MS Visio and MS Project in combination wif UML 2.0 diagramming techniques.
• Strong IBM Mainframe/AS400 technical background and programming skills
• In - depth knowledge of creating use case, activity, logical, component and deployment views wif rational tools to extract business process flows and workflows thereby halping development and quality assurance teams in understanding teh requirements.
• Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator wif excellent interpersonal skills.
• Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions
• Performed Gap Analysis to check teh compatibility of teh existing system infrastructure wif teh new business requirements
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Strong oral and exceptional written business communication skills
• Hard working, positive thinking, self-starter wif a strong goal orientation
• Excellent meetings facilitator wif excellent inter-personal and conflict resolving skills.
• Proven success as a Systems analyst through teh years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.

TECHNICAL SKILLS

• OOAD (OOA/OOD)
• RUP
• UML
• SDLC
• Waterfall
• QA
• WAP
• MS Access
• SQL Server
• MySQL
• PL/SQL
• Oracle DBA
• Mainframe
• AIX
• Windows 98/2000/XP basic UNIX
• HTML basic DHTML basic XML
• MS Office Suite-Excel Macros
• Project
• Visio
• Adobe Photoshop
• Flash
• Rational- Rational Rose
• Rational XDE
• DOORS
• RequisitePro
• SQL
• JCL
• Mainframe
• CaliberRM
• Crystal Reports
• Sprint CCT/CMS various NIKU products
• C
• C++
• BASIC beginner level-Visual Basic

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Sr. Business/System Analyst

Responsibilities:

• Gathered and documented business requirements for existing and future business systems.
• Captured requirements for TDS billing enhancements and performed source to target data mapping for TDS billing ODS
• Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.
• Maintenance on a Work Order Management System.
• Delivered business requirements, high level and detailed technical specifications and tan lead teh development and business teams through design, testing and implementation phases.
• Performed testing on a data warehouse platform, including data integrity and data validation.
• Assisted wif writing of Test Plan for teh Financial Data Mart implementation effort.
• Performed report validation writing sql queries using TOAD on an Oracle database.
• Created Billing Quality Assurance Sarbanes-Oxley Narrative and Testing Documentation for teh Enhanced Traffic Systems Mediation Platform, including fmCI and fWCOM switched traffic plus fmCI Operator Service Traffic.
• Ensured dat project requirements are properly tracked and documented.
• Used MS-Visio for flow-charting, process model and architectural design of teh application.
• Used MS-Project for status reporting and planning.
• Establish Test/Development to Production Export/Import EDI Transport from AS/400 to UNIX and assist in transition from legacy system(s).
• Experience in writing extensive SQL Queries on AS/400.
• Worked on several mainframe based applications running on an AS/400 platform.
• Implemented Enterprise Architecture Repository and associated reports and process support using IBM/ Telelogic System Architect.
• Upon successful IBM/ Telelogic System Architect software implementation created role based training and user guide to cover information organization, artifact management rules, and product customizations.
• Implemented RUP recommended visual models to draft business requirements by using Use Cases.
• Worked wif SQL queries using MS Access for data manipulations.
• Extensively used SQL to query teh database and created ad hoc reports and validated data
• Created test scripts and plans for UAT Phase
• Conducted UAT (User Acceptance Testing) to make sure dat all teh user requirements are catered by teh application.
• Wrote Test Cases in Mercury Quality center dat would test various Test scenarios.
• Rational ClearCase was used to manage all teh changes and change requests in teh projects. Worked wif QA team wif teh aid of ClearQuest for teh bug tracking.
• Monitored test scripts developed by QA team to check teh integrity of teh test plans.

Environment: MS Visio, MS Project, MS Excel, RUP, UML, SQL Server, AIX, Cobol, PL/SQL, Kenan Billing, OMS / EMS, JCL, .NET, Oracle, Clear Case, Clear Quest, Rational Requisite pro, HTML, Mainframe

Confidential, Richardson, TX

Sr. Business Analyst/Data Analyst

Responsibilities:

• Coordinated participation and sign-off of various business partners and customers.
• Created business requirement documents and integrated teh requirements and underlying platform functionality.
• Created UI specifications for Cingular Customer Service applications in order to improvise screen layouts for customer complaint registrations
• Generated Surrogate ID’s for teh dimensions in teh fact table for indexed and faster access of data.
• Worked on Trade Life Cycle as well as teh Order Management System (OMS)
• Converted various SQL statements into stored procedures thereby reducing teh Number of database accesses.
• Created surrogate key tables to map teh required dimensions.
• Data transfers from text files and Access databases using BCP and DTS; Data mapping and transformations while loading data using VBScript
• Created hash tables used for referential integrity and/or otherwise while transforming teh data representing valid information.
• Worked on requirements management processes and tools including IBM Rational Requisite Pro and Telelogic DOORS.
• Extensive use of Telelogic System Architect for enterprise architecture and business process analysis
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised teh development of User Manuals for customers.
• Used Query Analyzer, Execution Plan to optimize SQL Queries
• Enabled Proper selection of teh hash table design parameters for faster table look-up.
• Interfaced between Business new product builders and System platform builders.
• Worked wif systems area to translate business needs into system requirements.
• Made sure teh test cases and test process guarantee accountability to business and systems requirements.
• Involved in teh testing phase right from teh Unit testing to teh User Acceptance testing.
• Tracked UAT issues/bugs and prepared reports.
• Used SDLC (System Development Life Cycle) methodologies like teh RUP and teh waterfall.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Extensive use of MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint MS Project for data migration in to teh CI System Knowledge Data Base in Microsoft Share Point.

Environment: RUP, UAT, GAD (Gap Analysis Document), MS Visio, SQL, HTML, Windows, Rational Requisite Pro, Clear Case, Clear Quest, Mercury Test Director Oracle, .Net

Confidential, Denver, CO

Business Analyst/Data Analyst

Responsibilities:

• Served as a liaison between mortgage specialists and teh project team.
• Tasked to design, document and develop business process to automate and standardize Work Order Management process.
• Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different business groups and programmers.
• Led and conducted JAD sessions for requirements gathering, analysis and design of teh system.
• Created context and workflow models, information and business rule models, Use Case and Object Models during teh analysis using rational tools.
• Prepared UAT Materials, including teh UAT Process, UAT Test document which would include step-by step process for UAT as well as all teh tests dat would cover all requirements.
• Interacted wif teh users and logged any defects, enhancements from teh UAT.
• Designed teh system, prepared UML and sequence diagrams using Rational Rose.
• Responsible for writing detailed descriptions of user needs, program functions, and steps required for developing or modifying software programs using Rational Rose (UML).
• Prepared Functional Specification Documentation (FSD) and communicated these to teh stakeholders.
• Actively interacted wif different business groups to perform Gap analysis to identify teh deficiencies in teh system by comparing teh actual objectives wif teh system objectives desired.
• Conducted Business Requirements, Functional and Technical meetings wif Business groups.
• Used MS Visio for Process modelling and Business Process flow diagrams.
• Extensively involved in regression testing during various phases of teh application.

Environment: Rational Rose, Rational Req Pro, RUP, WinRunner, LoadRunner, HTML, SQL Server. PL/SQL, MS Office, MS Excel, MS Project, MS Visio

Confidential, New York, NY

Business/System Analyst

Responsibilities:

• Analyzed teh data collected and process maps to determine teh root causes and identify opportunities.
• Performed Gap analysis for teh modules in production, conducted feasibility study and performed impact analysis for enhancements, Cost benefit analysis and ROI analysis.
• Developed and maintained an SMTP interface enabling e-mail creation from an AS/400 application
• Invented a successful scripting methodology for AS/400 applications using Rational Functional Tester
• Develop teh test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge
• Assisted Test Lead, Testers understanding business process and halp them successful completion of Testing
• Documented process flows, process dependencies, and production environment configuration.
• Install, deploy and configure applications, perform installation verification
• Apply vendor patches as released, software testing, certification and implementation of NPA
• Writing queries or data analysis and QA report testing
• Coordinate and install new vendor releases, and assisted users wif troubleshooting functionality issues
• Managed project initiation, planning, execution, controlling, scheduling, support test, training, and production environment management.
• Manage change, release, and problem events, produce tech plans for new or changed solutions

Environment: Solaris 8.0, Oracle, Informix, NPA 4.0/5.0, Test Director, Win Runner, Load Runner, CORBA, Apache, MS Project, MS office Suite