SUMMARY:

• Over 12 years of diversified experience as a Business Analyst in Health, Insurance, Government, Mortgage, Banking, Financial and Telecom industry.
• In - depth knowledge of the Iterative Software Development Life Cycle ( SDLC ) using Rational Unified Process ( RUP ) . Expertise in implementing RUP through all the phases. i.e. Inception, Elaboration, Construction and Transition.
• Proven ability in Gathering, Understanding and Analyzing Business Requirements and optimizing Business Processes.
• Good understanding of key Project Management aspects, including Planning, Scheduling, Monitoring and Problem Solving.
• Extensive experience in creating documentation for Requirements Management using Rational RequisitePro, Test Director to organize, track requirements and change requests, Rational ClearCase for configuration and Rational ClearQuest for defect and change management.
• Proficient in modeling Business Processes using UML diagrams in EA,Rational Rose and MS-Visio.
• Experience in gathering requirements for Data Extraction, Data Processing, Data Transformation and Data Loading using ETL tools like Informatica and generating reports on Business Objects.
• Proficient in Data Mapping/Modeling and Designing Relational Data Base in Normalized form.
• Assisted in developing Test Cases and Test Data and conducted User Acceptance Test (UAT). Assisted in creating Test Plan and Test Metrics.
• Posess excellent Interpersonal and Communication skills. An excellent Team Player with critical thinking and advanced problem-solving skills
• Adept at using various software tools for communication.
• Experience in conducting Joint Application Development (JAD) sessions to deal and resolve issues.
• Good understanding of XML and WebMethods for business integration.
• Good understanding of Object Oriented Programming, OO Modeling and Design, Client/Server and Web architecture.
• Working knowledge of Oracle and SQL Server. Proficient in SQL, PL/SQL and UNIX.
• Developed Application Code using Visual Basic, Stored Procedures and Triggers using PL/SQL and GUI interface for end users.
• Intermediate knowledge of ETL tools like Brio, Informatica and Business Objects.

TECHNICAL SKILLS:

GUI: Visual Basic(5/6), VB.Net, ASP.Net,D2K

Languages: C, C++, SQL,PL/SQL,XML,Java

Databases: Oracle(7.3/8/9i), Teradata, SQL Server

Operating Systems: Windows 95/98/NT/2000/XP, UNIX

Requirement Management Tools: EA,Rational RequisitePro, Test Director

Defect Tracking Tools: JIRA,Rational ClearQuest, Test Director

Business Modeling Tools: MS Visio, Rational Rose, DOORS

Change Management Tool: Rational ClearCase

Business Analysis Methodologies/Tools: Rational Unified Process, Waterfall, UML, AgileApplication Programs: MS Word, Excel, PowerPoint, Project

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Responsibilities:

• Assess system interfaces, end-to-end data flows, and data storage and retrieval solutions for data modeling.
• Map legacy data stores/formats to logical and physical data models.
• Create data element definitions and dictionaries.
• Create, submit, analyze, and review data model change requests and change proposals.
• Perform requirements analysis.
• Coordinate Stakeholder input for model development and Technical Peer Review.
• Research and evaluate data standards.

Environment: .Net, SharePoint, SQL Server, Team Foundation Server (TFS), Mainframe,Visio.

Business Systems Analyst

Responsibilities:

• Work with internal and external clients to understand their business, data, and systems to help keep our product in line with our client’s needs.
• Perform extensive process analysis, data analysis, Root Cause Analysis and SQL scripting to gather client’s needs.
• Evaluated and documented data elements to understand their usage, transformations, lifecycle and quality/suitability
• Documented source to target mappings, data flow diagrams (DFD) and Meta data.
• Interpreted data, analyzed results, and provided information insights to clients to help them prioritize business needs
• Identified and defined both process and data improvements;
• Elicited and produced detailed system requirements based on research and client interaction
• Conducted Requirements and Functional Analysis to develop high level system design requirements and detailed software level requirements.
• Supported regression testing and key testing of enhancement functionality prior to software deployment. Collaborate with testing team extensively.

Environment: .Net, SharePoint, SQL Server, Team Foundation Server (TFS)

Programmer Analyst

Responsibilities:

• Perform requirements gathering and code analysis for state government data systems.
• Analyze existing Mainframe systems, batch processes and workflows.
• Work with internal business and Operations to identify business needs and translate those into business/functional requirements, UML and BPMN Diagrams and other project artifacts.
• Performed system analysis and developed Business flow diagrams, Systems Use Case, Activity diagrams and Sequence diagrams using Enterprise Architect.
• Created and maintained detailed RTM, process maps, gap analysis, data mapping and support.
• Researched methods of integrating by identifying the data feeds to be fed from one system to the other to enable successful integration
• Used Enterprise Architect for Business Process Re-engineering.
• Help quality assurance team in translating requirements into formal test cases and test scripts.

Environment: IBM Mainframe, COBOL, SQL Server, XML, .NET, JIRA, Enterprise Architect

Business System Analyst

Responsibilities:

• Involved in gathering requirements, performing and creating detailed technical systems analysis with context diagrams and data flow diagrams.
• Responsible for providing platform and consulting support for IT Systems and business customers across multiple IT platforms and domains pertaining to Loss Mitigation.
• Created process flow documents for Loss Mitigation systems.
• Responsible for managing risk, infrastructure integrity and alignment to domain target architecture for IT systems owned by Loss Mitigation as well as external platforms.
• Analyze, log and document repetitive issues to identify root cause and communicate to resolve technical issues.
• Responsible for the integrity of solutions as well as platform performance of IT systems.
• Actively engage in responding to system outages and participate in anomaly research.
• Worked with Data analysts on database design (Relational Database).
• Retrieve required data elements, assess criticality of incident, categorize incident and escalate when required.

Environment: Agile, Oracle, Teradata, MS-Word, MS-Excel, PowerPoint, Visio, Java, XML, web logic.

Business System Analyst

Responsibilities:

• Facilitated workshops with SMEs to capture and document existing business process flow and systems analysis .
• Depicted AsIs and ToBe business process flow models and performed GAP Analysis.
• Worked extensively with Data Architects on database design and data modeling.
• Played a substantial role in process definitions and created detailed functional requirements and process documents.
• Captured, developed, and documented data definitions, business rules, data quality requirements, and logical and physical data models based on requirements
• Performed extensive data analysis using SQL.
• Performed reverse engineering to document some critical system processes.
• Performed Data Mapping from Source to Target and modifications to User Interface.
• Gathered requirements to create complex tables based on data files specifications.
• Performed manual testing- test case creation and test script execution according to the test plan.

Environment: SQL Server, XML, Java, Informatica. Test Director, VSS, MS Project, MS-Word, MS-Excel, PowerPoint.

Confidential, IL

Business System Analyst

Responsibilities:

• Gathered requirements to write business specifications.
• Interfaced with business customers to determine and document business process flow.
• Depicted AsIs and ToBe business process flow models and performed GAP Analysis.
• Developed UI Prototypes using VISIO.
• Conducted JAD sessions with Business Users, SMEs, Business Analysts and Development team.
• Conducted walk-through and design reviews with Business and Development teams.
• Followed a planned approach to organize requirements into logical groupings of essential business processes, business rules, matching rules and ensured that critical requirements were accounted for.
• Acted as a liaison between business users and technical teams.
• Coordinated with project manager with various status reports.
• Participated with PV (Quality Assurance) testing efforts.
• As a member of Change Management Committee, participated in product and project change management to study impact assessment, prioritization and communication for project requirements and product enhancements
• Review user manual and Help documentation and provide feedback.
• Participated in internal users training.

Environment: Oracle, Java, Clear Case, Clear Quest, VISIO, Project, Excel, and PowerPoint, Rational Rose

Business System Analyst

Responsibilities:

• Conducting meetings/interviews with stakeholders and SMEs to gather requirements for various Data Load’s.
• Worked extensively with Data Architects/data modelers on database design and data modeling.
• Interacting with the stakeholders to review and baseline the design documents.
• Converted Business Requirements to System Requirement Specifications.
• Performed Data Mapping from Source to Target and modifications to User Interface.
• Created metadata and data dictionaries for xml data files.
• Documented process flow for Member Load and Case Load systems.
• Overseeing and helping the QA team to devise the test plan for the application by explaining the business case.

Environment: SQL Server, Java, Informatica, Test Director, VSS, MS-Excel, PowerPoint, MS Project

Confidential, Richmond, VA

Business System Analyst

Responsibilities:

• Worked closely with Managers, Business Users and Customers to determine the reporting infrastructure for conversion.
• Conducted/Organized individual and group (JAD) sessions with business and technical units and gathered requirements.
• Analyzed software requirements, business requirements and functional specifications and reviewed the design documents in different methodologies.
• Determine the rationalization approach and items for local versus centralized control.
• Worked with Data Analysts in grouping of Metrics and Dimensions. Worked on Oracle and TeraData.
• Gathered requirements to determine reports that need to be built new, kill or remediate.
• Compiled list of business metrics and dimensions and determine the use of metrics and dimensions.
• Assisted Functional teams and Business owners to document actions taken from each metric and dimension to understand how they are used.
• Gathered business requirements from the Business User and documented the requirements.
• Conducted FRS and URS reviews and walkthroughs with the designers, developers and stakeholders.

Environment: Agile, Oracle, Teradata, RequisitePro, Clear Case, Excel, PowerPoint, Visio, Brio, Micro Strategy.

Programmer Analyst

Responsibilities:

• Performed Analysis, Design and Development of the system.
• Developed GUI, Database links, Stored Procedures and Functions in Oracle.
• Generated Reports using Crystal Reports and Excel.

Environment: Visual Basic 5, Oracle 7.3, Crystal Reports, SCO UNIX, PL/SQL, SQL, MS Office