SUMMARY:

• Experienced Business/Systems Analyst with 7+ years of extensive industry experience specializing in object - oriented analysis (OOA), design (OOD), and programming (OOP).
• Expertise in the use of tools such as Caliber RM, Rational Rose, Requisite Pro, Starteam, Test Director
• Proficient experience in Manual and Automated Testing of GUI and functional aspects of the Client-Server and Web based Applications on multiple levels of SDLC and Testing Life Cycle (STLC)
• Experience with Caliber RM, StarTeam, Test Director, Info Make
• Expert in user interface designing and creating screenshots using wire frames and comps, and expert in using tools like MS Project and MS Visio.
• Extensive experience developing Unit Tests using MS Test or a similar framework.
• In-depth knowledge of creating Use Case, Activity, logical, component and deployment views with Rational tools to extract business process flows and workflows thereby helping development and quality assurance teams in understanding the requirements.
• Strong business analysis skills and a sound understanding of the Software Development Life Cycle (SDLC) utilizing Rational Unified Process (RUP) methodology.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases.
• Excellent understanding of web security technologies.
• Experience with data migration (ETL development), document data manipulation processes and scripts
• Proficient in developing and executing Test Procedures, Test plans, Test scripts, test result validation, performing functional, usability, stress testing and ensuring that the software meets the system requirements.
• Excellent Documentation skills using Rational Requisite Pro for creating detailed functional specifications.
• Experienced in conducting JAD sessions with excellent inter-personal and conflict resolving skills.
• Expert in Root Cause Analysis, Feasibility studies, Risk Assessment studies.
• Responsible for supporting and managing database activity during the development cycle.
• Expertise in broad range of technologies, including business process tools such as CMM, technical assessment tools and Data Warehousing concepts.
• Excellent in data analysis and data modeling.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Strong communication skills when working with developers, project managers, subject-matter experts, stakeholders, system implementers, and application end-users.
• Creative and aggressive self-starter with integrative thinking skills, capable of forming and maintaining positive working relationships in internal, external, independent, and team environments.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Visio.

TECHNICAL SKILLS:

Software/Hardware: C#.Net, VB.Net, JDK 1.4, Delphi 5, 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, ASP.Net, DotNet and Java WebServices, JSP 1.x, Servlet 2.x, J2EE, EAS, XML/XSL, JavaScript/VBScript, DOM, HTML, Power Builder Distributed Application Library, J2ME, CLDC 1.0, MIDP 1.0, Data Stage, DOORS, 4.0, IIS 5.0, IBM WebSphere - WAS, Rational Rose, UML 2.0, RUP, OOAD, ETL, Informatica, IBM Optim, MS Visio and Visual Studio.Net, Sybase SQl Anywhere 5/6, Adaptive Server Anywhere, MSSQL 7, Oracle 6 / 7.x / 8i / 9i, Oracle - TOAD, ODBC, Visual Source Safe 6.0, Source Off-Site, Round-Table, Win CVS, NUnit.net, MS Project, MS-Office

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. IT/Business System Analyst

Responsibilities:

• Facilitated collection of requirements from system users, and prepared Business and Requirement Specification documents.
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Worked on following applications Business Objects, Enterprise Architect, Toad, PlanView (project management), Microsoft Suite (Word, Excel, PowerPoint, Visio, Access, Project)
• Did Integration Testing, GUI testing, Smoke and Sanity Testing, and Acceptance testing in the new builds for Basic Functionality Checking.
• Gathered user requirements for new reports through JAD/JAR sessions, which eliminated duplicate and obsolete data and provided a uniform reporting environment across the multiple trading desks.
• Responsible to import the parts of the existing reports using Business Objects Live Office to develop the required reports in Microsoft Excel and Word.
• Responsible to import the data from Crystal reports by using Business Objects Live office into Microsoft Excel and Word.
• Designed the universes by creating the Business Objects data model.
• Defined ETL strategy to capture new data, store historical data and update data warehouse in the most efficient way
• Gathered the various server data from all the Infra Business/ IT teams to build a centralized inventory of the most updated Server information for L2 and L3 support teams and other stakeholders.
• Performed Business Process Mapping and performed AS IS and TO BE analysis
• Established & Monitored the processes for issue management, change management
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Created Use Case Diagrams, Activity Diagrams and Sequence Diagrams in MS Visio
• Installing, patching and administering Oracle 10g database server.
• Gathered user and business requirements through open-ended discussions, brainstorming and prototyping
• The tests also included GUI testing: Testing for validation and display of screens
• Prepared and documented System Requirements and workflows for the Content Management Application tool Interwoven.
• Design and develop the data load process using Informatica PowerCenter and XML Style sheets and ACORD XML.
• Involved in Writing test scripts for all classes of VB.NET and calling them from NUNIT for testing
• Used JavaScript for client side validations extensively along with .NET validation controls.
• Interacted with business partners to perform the Initial Project Analysis define new and document retail sales reporting requirements and Change Requests (CRs) in Borland CaliberRM.
• Created Use Case diagrams, Scenarios, and Narratives using the UML techniques.
• Created Activity Diagrams, Sequence Diagrams, and ER Diagrams.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Participated in designing and coding for web forms of the application with ASP.NET.
• Lead the effort of Data Migration from disparate data sources into normalized data to eliminate redundant information and organizing the tables to easily maintain the table structures.
• 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 members.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.

Environment: UML 2.0, Rational Rose, MS-Visio, C#.Net, MS SQL Server 2000, DOORS, HTML, ETL, Data Stage, FrontPage (for prototype and Screen Shots), SOA Infra,TOAD, MS-Project, MS-Office.

Confidential, Seattle, WA

IT/Business System Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Conducted extensive requirement analysis
• Design and develop the Test data Environment strategy using IBM Optim.
• Conducted JAD Sessions to present several prototypes and to elicit missing requirements in the models for sign-off
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Developed applications using Business Objects, PL/SQL and Toad
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Generated XML documents using the XML Output Stage.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• 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.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Database table review and data mapping for large scale data conversion project Oracle database to Mainframe.
• Coordinate Databases and Server requirements with Infra and development teams
• Provided technical support to the Database Team on Oracle 9/10 based architecture, developed SQL queries for data extraction purposes.
• Developed business process models in RUP to document existing and future business processes.
• Created .NET Reports which are used to present the data in different views and are effectively consumed using Crystal Reports.
• Facilitated JAD sessions for communicating and managing expectations with final users of the product.
• Developed the GUI using Custom and Web Controls in ASP.NET with VB.NET as code-Behind.
• Wrote Test plan and Test cases for the Integration testing and system testing.
• Responsible for GUI design, Workflow analysis, Prototyping and Business development
• Designed and developed project document templates based on SDLC methodology.
• Developed business requirement specification documents as well as high-level project plan.
• Designed and developed all Use Cases and UML models using Rational.
• Coordinated various kinds of User Acceptance Testing (UAT) including regression testing, system testing, integration testing, functional testing, alpha & beta testing.
• Worked with marketing team in knowing what exactly bank’s client wants.
• Partnered with the technical areas in the research and resolution of system and process problems.
• 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 Mercury Test Director for stress testing and UAT (User Acceptance Testing).

Environment: Windows NT 4.0, Erwin, XML, Dbase3, DOS and UNIX Sequential Files, IBM Optim, DOORS, CaliberRM, Java, NUnit, Data Stage, ETL, MS Access, TOAD, HTML, ERWIN

Confidential, Portland, OR

Business System Analyst

Responsibilities:

• Responsible for requirements gathering, analysis, detailed process flow design, user acceptance testing and rollout of new & modified feature functionality deployed on website applications.
• Conducted project discovery through the interviewing of key stakeholders' to flush out business rules, operational specifications and interface specification solutions to address identified business opportunities and/or strategic initiatives.
• Developed schemas for extraction, transaction, and loading (ETL) using Solonde Warehouse Workbench to expedite data integration between systems.
• Gathered and validated requirements, resulting in detailed business rules, functional requirements and process design.
• Created business requirement document (BRD), functional requirements document (FRD), improved process flow and Use Case diagram.
• Assisted PM with project planning, estimating, budgeting, resource allocation, collaboration and time capture using Clarity Project Manager
• Prepared graphical depictions of use cases (activity diagrams, system context diagrams, sequence
• Involved in the analysis of the data in the existing system, decoding AS400 programs from the mainframes applications.
• Diagrams use case diagrams, wire frames, etc...)
• Conducted user interviews, gathered requirements, analysed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro
• Identified system, data and process dependencies for upstream and downstream application data flow.
• Worked with development team on Agile methodology of Software Development Lifecycle.
• Participated in three company conversions to JDE OneWorld. Once as Power User and twice as Application Specialist
• Accumulated system requirements from various departments through surveys and interviews.
• Involved in prioritizing the defects and writing business requirements to resolve them.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Conducted user interviews, gathered Requirements, analyzed the Requirements and managed changes using Rational Suite.
• Create technical design documentation for the data models, data flow control process, metadata management.
• Analyzed the data collected and process maps to determine the root causes and identify opportunities. underlying platform functionality

Environment: Unix, DB2 UDB, MS Power Point, TOAD, MS Excel, COGNOS, RUP, UML, SAS, Rational Rose, Oracle, Testing Strategies.

Confidential, Long Island, NY

Business System Analyst

Responsibilities:

• Documented requirements associated change requests with requirements and connected requirements with Use cases.
• Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology.
• Managed the Order Management team for the in time delivery of the User Stories and faults.
• Configures base tables and manages database for TMS( Transportation Management System) JDA Transport so routing algorithm will properly identify proper business rules.
• Analysis of JIRA as Agile and bug tracking tool; recommendations of custom configurations to support Agile methodology.
• Creator and co-owner of Product Backlog, BRD and Test Case templates design, taking into account waterfall PMO requirements and agile philosophy.
• Gather requirements by conducting meetings and brainstorming sessions with senior management of the Research Group and SMEs and document them.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose.
• Performed Interface Validation for interfaces between RMS and Academy Legacy Systems.
• Facilitation of reporting requirements via JAD sessions, interviews; user stories, requirements analysis, process flows, development of small business reporting solution, QA oversight, UAT (test cases), and training (including documentation); Agile methodology(scrum)
• Conducted Web application UI and functionality validation followed by functional validation after migration to the new environment
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Utilized Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.
• Intricately involved in Business Process Flow development, Business Process Modeling, and ad hoc Analysis
• Used MS Visio for Process modelling, Process mapping and Business Process flow diagrams.
• Test Case creation in the HP Quality Center / ALM Test Case repository.
• Participated in Team Foundation Server/Visual Studio Agile Management Sysstem implementation to support enterprise utilization of agile methodologies and procedures.
• Created Functional Unit/String test cases for Order Management, Warehouse & Inventory Mgmt, and Planning & Procurement.
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Responsible for implementing supply chain management and operations solutions in the exploration & production lines
• Conducted User Acceptance Testing (UAT) and documentation of Test Cases.
• Interfaced with developers to identify and resolve technical issues and bugs in the software to validate end-user requirements.
• Involved with Salesforce.com Premier Support and handled the support cases with the help salesforce.com support.
• Participated in the Logical and Physical Design sessions and developed Design Documents.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Responsible for managing the migration of the department’s website using Web Builder and ensuring that there are no broken links on the intranet.

Environment: UAT, Gap Analysis, MS Visio, MS Powerpoint, Agile, SQL, SQL Queries,IBM Rational Clear Quest, SharePoint

Confidential, Mooresville, NC

Business Analyst

Responsibilities:

• Interfaced with the client as part of the Requirements Engineering team to finalize the project scope.
• Facilitated JAD sessions and gathered business requirements
• Conducted user interviews, gathered requirements, analyzed the requirements and managed changes using Rational Suite.
• Taken up responsibilities within Project Management in keeping track of the project.
• Conducted weekly status meetings with testing and development teams.
• Worked with the Sales & Operations team in the monthly planning activities.
• Worked on Order Management Systems.
• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
• Ensured that development teams are practicing Scrum Master and Agile principles
• Analyze requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)
• Exposed to Agile methodology.
• Maintained a traceability matrix for all requirements and mapping to various Data Reporting Manuals, User Guides.
• Performed acceptance testing using AS400/SQL and development changes in a highly integrated environment following established methodologies and tools for providing regular reporting on results
• Used Rational Requisite Pro as requirement gathering tool.
• 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.
• Was actively involved in the design of BRD, FRD, Use Case diagrams and Activity diagrams using MS Visio.
• Worked on SEO and Usability to have a better navigation to the customer.
• Worked with the UI team in defining the Usability requirements.
• Assisted Project Management activities with the help of applications like MS Project, Visio and WebEx presentations to the onsite/offshore team.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Performed extensive requirement analysis including data analysis and gap analysis.
• Designed and developed project document templates based on Agile methodology.
• Created user stories, storyboards and conducted stand up meetings.
• Followed Agile methodology throughout the project.
• Created user stories and worked with the team members.
• Participated in various stages of data and requirement analysis for project needs.
• Designed and developed use cases, activity diagrams, sequence diagrams, OOD using UML.
• Assumed ownership of use case diagrams, use case narratives and other various artifacts.
• Relieved pressure off the PM by maintaining artifacts and portions of the project binder
• Assisted with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Conducted User Acceptance Testing (UAT).
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project life cycle.
• Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
• Assisted the PM in performing risk assessment, management and mitigation
• Powered with strong verbal and written communication skills.

Environment: Windows 2000/XP, Microsoft Office SharePoint 2007,Agile, Rational Requisite Pro, MS Office, SQL Queries, MS Project, MS FrontPage 2003, MS Access, Snagit, Documentum2.0. UML.