SUMMARY:

• Over 13+ Years of IT experience with an accomplished Business Systems Analyst of seven years experience in gathering Business and Functional Requirements, developing Use Cases, conducting GAP analysis, SWOT analysis, Cost benefit analysis, Risk analysis, modeling Businesses Processes, reengineering business processes, and preparing Training manuals.
• Proficient working with fast - paced projects where deadlines are a priority, identify and resolve complex problems, and develop innovative solutions using Business Process Modeling Notation (BPMN) framework.
• Experience of working with MS Project to develop and monitor project plans.
• Comprehensive experience in Project Management, cost/benefit analysis, testing, development of business requirements specifications, and project planning working with project managers and business sponsors.
• Data Conversion from Flat files to Oracle using Oracle SQL* Loader and SQL*Loader scripts.
• Having Good Knowledge on Oracle SOA Components (BPEL, MEDIATOR, ADAPTORS).
• Proficient in using XML related technologies including XSLT, XPATH and XQUERY.
• Extensive knowledge of standard SDLC methodologies, including RUP, MSF, Prototype and Spiral.
• Knowledge of Data Warehouse concepts, applications, and ETL tools
• Solid Experience in developing Scope/Vision Documentation and Project Plan.
• Strong Knowledge of SDLC, RUP methodology, and Project life cycles.
• Proficient at creating and transforming business requirements into Software Requirements Specification (SRS) using Rational Requisite Pro and designing business models using UML diagrams such as Activity Diagrams, Sequence Diagrams and Collaboration Diagrams using latest BPMN 2.0 Standards in Rational Rose and MS Visio
• Solid understanding of Rational Unified Process (RUP) using Rational Rose, Requisite Pro, Unified Modeling Language (UML), Object Modeling Technique (OMT), Extreme Programming (XP), and Object Oriented Analysis (OOA).
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Expertise in developing test cases for ETL processes.
• Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, and FSD
• Involved in batch processing of mainframe to update policies
• Proficient in creating Use Cases, Use Case Diagrams, Activity Diagrams etc.
• Expertise in the management of User Request Change, and handle User Conflicts.
• Expertise in developing QA Test Plan, Test Conditions, and Test Cases; ensuring adequate testing of software both before and after completion; conducting and documenting UAT.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture.
• Strong oral and exceptional written business communication skills
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL
• Hard working, positive thinking, self starter with a strong goal orientation
• Excel spreadsheetlent meetings facilitator with excel spreadsheetlent inter-personal and conflict resolving skills.
• Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.

TECHNICAL SKILLS:

• C#.Net
• VB.Net
• AS 400
• Goldmine
• Windchill 8.0
• Mainframe
• HL7
• SQL
• IDMS
• QTP
• MS Windows NT 4.0/2000
• Windows 95/98
• Windows XP
• MS Visual Studio.Net
• IBM WebSphere 5.0
• Power Builder 5, 6.5, 7
• Rational Rose
• UML 2.0
• RUP
• OOAD
• MS Visio and Visual Studio.Net
• Sybase SQl Anywhere 5/6
• Adaptive Server Anywhere
• MSSQL 7
• Oracle 6 / 7.x / 8i / 9i/ 11
• Oracle - TOAD
• Informatica
• Bbusiness Object
• ETL
• Cognos
• Erwin7.0
• Visual Source Safe 6.0
• Cobol
• Source Off-Site
• Round-Table
• Win CVS
• NUnit.net
• MS Project
• MS-Office

PROFESSIONAL EXPERIENCE:

Confidential, Foutain Valley, CA

Business Systems & Data Analyst

Responsibilities:

• Requirements Gathering/Documentation for Genesis Madelia Customer Service Survey Project - Designed and documented detailed business requirements, functional requirements utilizing PMO & Governance approved templates.
• Validated data extraction logic, data transformation logic and data loading (ETL Testing), Developed SQL scripts for various ETL checks to ensure data integrity, to ensure business rules and logics are properly applied, data flows properly from source to Target tables, to verify the implemented ETL code with reference to the corresponding mapping document, data modal and BTRDs. Confirm the data loads from source files into staging table and staging table to target table.
• Participated testing in ETL mappings/jobs based on the customer requests for SAP & AS400 Analytics.
• Helped create & maintained ETL Guidelines and best practices documents for the entire Enterprise Data Warehousing Jobs.
• Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.
• Reviewed the data model and reporting requirements for Micro Strategy BI Reports with the Data warehouse/ETL and Reporting team.
• Performed database validation in AS400, SAP & SEIBEL plate forms to ensure data load passed through the frond end accurately travels all the way up to the Data Marts
• Validated ETL load strategies and Data mart Load Strategies on an ongoing Basis
• Involved in testing Transformations used in Informatica for ETL process.
• Proficient in process modeling/mapping, requirements gathering/management, systems analysis and design. Documented and restructure those processes and information flows using industry standard UML and the Business Process Modeling Notation (BPMN).
• Worked in Data Analysis, Data Reconciliation and Data Mapping for ETL process
• Designing and customizing data models for Data warehouse supporting data from multiple sources in compliance with EDW Guidelines.
• Interact with Development Teams and Managers to analyze business needs. Provided EDW data model design and development technical roadmap for project lifecycle and beyond.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin Data Modeler.
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
• Was responsible for Index Based Performance Enhancement for the entire EDW data warehouse.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading.
• Develop and maintain reporting using MS Excel, Oracle SQL queries, PL/SQL queries, and MS Access. Produce performance reports and implement changes for improved reporting. Interface with internal customers.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture.
• Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, and FSD
• Deep knowledge of Data Warehouse concepts, applications, specially ETL, BI & Toad for Oracle Data Analytics tools.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Validating Data Conversion from Flat files to Oracle using Oracle SQL* Loader and SQL*Loader scripts.
• Developed detailed and summary reports including trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Scheduled meetings with developers, Business Users and testers to collaborate resource allocation and project completion.
• Possess Good Knowledge on Oracle & ETL SOA Components.

Environment: Oracle Platform 11g, db2, MS Visio, SAP Analytics, AS400 Mainframe, Erwin 7.0, TOAD for Oracle Tool set, SQL Developer, WinSQL, MicroSoft Strategy BI Tool, RUP, Rational Rose 2002, Rational Clear Quest, Rational ClearCase, Rational requisite pro, rational test manager, Rational Robot

Confidential, Hilliard, OH

Business Systems Analyst

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contains the essential business elements and detailed definitions.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Validated data extraction logic, data transformation logic and data loading (ETL Testing), Developed SQL test scripts for various ETL checks to ensure data integrity, to ensure business rules and logics are properly applied, data flows properly from source to Target tables, to verify the implemented ETL code with reference to the corresponding mapping document, data modal and BTRDs. Confirm the data loads from source files into staging table and staging table to target table.
• Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
• Developed a data model (star schema) for the sales data mart using ERwin tool
• Documented the user requirements Analyzed and prioritized them and converted them as system requirements that must be included while developing the software.
• Worked with BPM 2.0 using a notation UML to capture graphical representations of the major processes, flows and stores.
• Extensively used Erwin to create Data Models for relational and dimensional modeling.
• Analyzed data and created class diagrams and ER diagrams for designing databases.
• Suggested web security using encryption and authentication technologies for reporting and complaint filing procedures.
• Participated testing in ETL mappings/Jobs, based on the customer requests for Siebel Analytics.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Tracked change requests and monitored workload and schedule.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
• Scheduled meetings with developers, System Analysts and testers to collaborate resource allocation and project completion.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
• Identified various frequently used modules with in the application as well as the peak user volume for load testing purposes.
• Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
• Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.
• Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing.
• Helped in creating end user manuals and procedure manuals.

Environment: Java, J2EE technology, Windows 2000 Advanced Server, UNIX / Oracle Platform 11g, db2, MS Visio, Mainframe, Erwin 7.0, RUP, Rational Rose 2002, Rational Clear Quest, Rational ClearCase, Rational requisite pro, rational test manager, Rational Robot

Confidential, Torrance, CA

Business Systems Analyst

Responsibilities:

• Drafted the project scope and vision and presented the same to the management committee.
• Provided expertise in strategic planning, business process modeling, business process analysis, object-oriented analysis & design, use case modeling, use case analysis, component-based development, and quality assurance.
• Expertise in ETL process using Informatica
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing
• Initiated and created business specific certification databases to ensure all personnel are in compliance with the set requirements.
• Perform automated and manual testing based on written test-plans and test cases, knowledge rqmts and of end-user needs
• Designing logical and physical data models using ERWIN Tool after analysing and understanding the Business processes in detailed
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Involved in testing Transformations used in Informatica for ETL process.
• Was responsible for indexing of the tables in that data warehouse.
• Involved in mapping and testing custodian data such as holdings, transactions and pending transactions. Worked with SWIFT securities reporting messages
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies. Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project as per BPMN 2.0 STANDARDS
• Conducted JAD sessions with SMEs and technological experts to gather data requirements such as securities pricing, corporate actions, trade and custodial data.
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting. Interface with internal customers.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Design and developed Use Cases, Activity Diagram, Sequence Diagrams. OOD using UML.
• Building a high level business case based on the above findings and suggest a transformation roadmap to the future.
• Extensively used Aris Business Designer for building process maps, system maps and data flow maps.

Environment: Microsoft Office Suite, MS Access, Microsoft Visio, Unix, ClearQuest, Documentum, Windows NT/XP, JCL, Oracle, SQL, SQL Server, Sybase, Teradata, PL/SQL VBScript, C#. Agile, Scrum, C++, NET, ASP.NET, Business Objects, TestDirector, LoadRunner

Confidential, Dallas, TX

Business Systems Analyst

Responsibilities:

• Gathering market data including real time and historical price data, financial data, and trading news using financial data source named Bloomberg.
• XML order header and order detail data transfer; inventory/supply chain management modules
• Validated ETL DW load statistics and Data mart Loads on an Ongoing Basis
• Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
• Solid Experience in developing Scope/Vision Documentation and Project Plan, as well as tracking Project Process, and manage resources to ensure successful delivery
• Developed test plans with QA team and helped test every scenario using Mercury TestDirector Tool for system testing
• Used Test Director, PL/SQL for testing the application
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Wrote detailed specifications for various reports generated using Cognos
• Design and develop the data load process using XML Style sheets and ACORD.
• Efficient in MS Project for planning and status reporting.
• Deep understanding of Structured System Development Methodologies
• Designing and customizing data models for Data warehouse supporting data from multiple sources
• Collaborated with External Auditors and documented SOX compliance requirements
• Assisted Project Management in developing Scope/ Vision Documentation and Project Plan, tracking project process, and developed Risk Mitigation Plan
• Responsible for creating a business process and workflow documentation using BPMN standards.
• Worked in Data Analysis, Data Reconciliation and Data Mapping for ETL process
• Ensured that the Reference data repository was setup in case of emergency or unavailability of data.
• Used MS Visio for Process modeling and Business Process flow diagrams
• Solid Experience in Collection, analyses, and documentation of User Requirements, as well as Organizing interviews, User meetings, workshops, JAD sessions and requirement elicitation sessions
• Proficient in creating Use Cases, Use Case Diagrams, Activity Diagrams etc.

Environment: Windows, MS Access, MS Office(MS Word, MS Excel, MS Powerpoint, MS Visio), ETL, .NET, Oracle, JCL, Windchill 8.0, Crystal reports, RUP Mainframe, UML, SQL, SWOT analysis, ClearQuest, GAP Analysis, Win Runner

Confidential, Auburn Hills, MI

Business Systems Analyst

Responsibilities:

• Gathered and documented business requirements for existing and future business systems.
• Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.
• Ensured that project requirements are properly tracked and documented.
• Interact with Development Teams and Managers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Developed Software Requirements Specification (SRS) and documented product design utilizing UML.
• Participated testing in ETL mappings, based on the customer requests for Business Objects
• Used MS-Visio for flow-charting, process model and architectural design of the application.
• Conducted JAD sessions. Involved in preparing project plans and identifying major milestones for each stage as per the SDLC model (RUP Methodology).
• Core of PLM creation and central management of a product data and the technology used to access all information and knowledge.
• Gathered requirements from JAD/JAR sections with developers and business clients.
• Worked on several mainframe based applications running on an AS/400 platform.
• Used MS-Project for status reporting and planning.
• Requirements Gathering/Documentation - Designed and documented detailed business requirements, functional requirements utilizing PMO & Governance approved templates.
• Conducted JOINT APPLICATIONS DEVELOPMENT (JAD) sessions with the participation of the users and the stakeholders to gather requirements.
• Implemented RUP recommended visual models to draft business requirements by using Use Cases.
• Created ETL Guidelines and best practices documents for Data stage Job.
• Developed Components using Struts Framework, J2EE; Coding for Components using JSP, Java Beans.
• Rational ClearCase was used to manage all the changes and change requests in the projects. Worked with QA team with the aid of ClearQuest for the bug tracking.
• Monitored test scripts developed by QA team to check the integrity of the test plans.
• Involved in end to end testing from Quick Quote to the policy activation in both frond end application and in the mainframe.
• Dedicated a good portion of time with the QA team in front-end, back-end and Regression testing.
• Drafted business Use Cases such that any future changes could be easily managed.

Environment: MS Visio, MS Project, UML, PL/SQL, .NET, IMS, Mainframe, Visual Source Safe, Clear Case, db2, Access, Excel spreadsheet, Pivot tables

Confidential, Annapolis, MD

Business Analyst

Responsibilities:

• Coordinated participation and sign-off of various business partners and customers.
• Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Followed solely RUP methodologies during the course of the project.
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
• Accumulated system requirements from various departments through surveys and interviews.
• Involved in Prioritizing the defects and writing business requirements to resolve them.
• Performed database validation in the Mainframe to ensure the data entered through the frond end reached the database.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Conducted and Managed JAD sessions with SMEs and Business departments, for planning and Requirements Gathering.
• Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• Interfaced between Business new product builders and System platform builders.
• Worked with systems area to translate business needs into system requirements.
• Made sure the test cases and test process guarantee accountability to business and systems requirements.
• J2EE Front-End and Back-End support in business logic, integration and persistence.
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.

Environment: RUP, UAT, GAD (Gap Analysis Document), db2, .NET, J2EE, Visual Source Safe, MS Visio, Windows, data mining, data modeling, db2, sql, oracle, business objects, SAP

Confidential, Edison, NJ

Web Developer/ Web Architect

Responsibilities:

• Analyzed the functionality of the application.
• Created Auto responders - system generated emails
• Coded & Developed OMS - online order management system .
• Coded & Developed transactional module for Orders, Invoices & Sales Memo.
• Developed a full-fledged Online Inventory Management Module
• Developed extendable and distributable Web Services module to talk with web based external XML applications.
• Designed and developed a 3-tier Pricing web application that advised potential buyers on item price, condition, and date, designer's webpage and Jewelry online catalogue.
• Developed SQL stored procedures for integration of warehouse management system with product distribution (AR) and integration of purchasing (AP) between old and new ERP system (MS Dynamics)
• Created SQL stored procedures and BizTalk applications for online processing of purchase orders, invoices and advance shipping notices.

Environment: Visual SourceSafe, Visual Basic 6.0; ASP 6.0; Visio; MS Access 2000; FoxIT Reader; FarPoint Tab Pro, Microsoft SQL Server 2000.