SUMMARY

• Experienced Business Systems Analyst with 7+ years of extensive industry experience specializing in object - oriented analysis (OOA), design (OOD), and programming (OOP).
• Expert in software development on the Microsoft .NET Framework including C#. Net, VB.Net, ASP.Net, ADO.Net and Web Services.
• MCP in developing and implementing web-based applications with C# and MS Visual Studio .NET.
• Extensive with ecommerce applications in B2C and B2B environments
• Experienced in multi-tier, database-driven, client-server, Internet, Web, and wireless development.
• Focus on making systems better through Agile Methodologies, re-architecture, re-factoring, code cleanup, and redesign.
• Expert in formulating Business Process Reengineering by means of RUP methodology and enterprise wide systems implementation taking into account continuous improvement techniques like Kaizen and Balanced Score Card.
• 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 nUnit, MSTest 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, Apache Tomcat Server 4.0, IIS 5.0, IBM WebSphere - WAS, Rational Rose, UML 2.0, RUP, OOAD, ETL, Informatica, 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. Business Systems 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.
• Gathered user and business requirements through open-ended discussions, brainstorming sessions, and role-playing.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, and Test Criteria
• 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 MSVisio.
• Worked in Data Analysis, Data Reconciliation and Data Mapping for ETL process
• Involved in Writing test scripts for all classes of VB.NET and calling them from NUNIT for testing
• Create and maintain data model/architecture standards, including master data management (MDM)
• Prepared Test Plans for each release, written Test Cases and executed them as part of Functional Testing.
• Prepared Test Reports and Deliverables and submitted for version releases.
• Develop and maintainNUnitsoftware modules using Microsoft Visual Studio
• Created Use Case diagrams, Scenarios, and Narratives using the UML techniques.
• Created Activity Diagrams, Sequence Diagrams, and ER Diagrams.
• Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
• Created workflow scenarios, designed new process flows and documented the Business Process various Business Scenarios and activities of the Business from the conceptual to procedural level.
• 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.
• Performed activities supporting the roll out e.g. the UAT template for Business User for QA, QA Action Item Register Template, and the User Sign Off, the Help Desk Script and Action Steps and Site Maintenance document.

Environment: UML 2.0, Rational Rose, MS-Visio, C#.Net, MS SQL Server 2000, HTML, ETL, Data Stage, FrontPage (for prototype and Screen Shots), IIS 5.0, Java/J2EE, MS-Project, MS-Office 2000

Confidential, Seattle, WA

Business Systems 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
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Extensively used Visual Basic to create macros in order to make data migration testing more useful and compared results from the legacy databases to the new CRM database.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• 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
• Conducted GAP Analysis between the existing projects and the proposed project to map the systems and evaluate their utility toward the new project.
• Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements.
• Developed business process models in RUP to document existing and future business processes.
• Coordinated re-architecturing the existing VBA/Access system into ASP.net environment and existing table structure, stored procedures, and functions in MS SQL environment.
• Wrote Test plan and Test cases for the Integration testing and system testing.
• 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.
• Developed Sequence Diagrams, OOD using UML.
• Established a business analysis methodology around the RUP (Rational Unified Process). Helped develop use cases, project plans and manage scope.
• 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, Java, NUnit, Data Stage, ETL, MS Access, HTML, ERWIN

Confidential, Austin TX

Business Analyst

Responsibilities:

• Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro.
• Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Execute test scripts, coordinated & conducted UAT testing.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Prepared and maintain Business Rules Spreadsheets (BRS) identifying Rules, Triggers and corresponding data fields from Legacy to target CRM application.
• Actively interacted with different business groups to perform Gap analysis to identify the deficiencies in the system by comparing the actual objectives with the system objectives desired.
• Prepared Use cases and activity diagrams for a source system using Enterprise Architecture (EA) tool.
• Used BEA (BPM Tool) to map Process flows and migrated Visio Process flows into BEA Tool.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP, OLTP reports requirements.
• Define Testing strategies and design Test Plans to test each system Interface output and rigorously test each system Interface based on its Test Plan.
• Detect and document the defects using Mercury Quality Center.
• Use of data transformation tools such as DTS, SSIS, Informatica or Data Stage.
• Coordinate the activities of subordinates in the Interface Team and organize weekly status Meetings.
• Created Test plans/ Scripts and conducted UAT

Environment: Microsoft SQL Server, Microsoft Data Transformation Services, Data Stage, Query Analyzer, J2EE Framework, Microsoft Visio Professional 2002, ETL, Mercury Quality Center 8.2 (formerly TestDirector), WinSQL.

Confidential, Keene, NH

Business Analyst

Responsibilities:

• Researched the various steps in the lifecycle of Agency Appointment and Audit process and then facilitated to construct the System
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology.
• Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Creating, Process Flow Diagram, Context Diagram and Activity diagrams using UML.
• Documented Business Transaction Rules
• Documented the mappings used in ETL processes.
• Designed and developed Use Cases, Work flows and Activity Diagrams using UML
• Assisted with design and development teams for missing functionality while designing and implementing
• Interacted with the development and testing teams to improve the quality and functionality of the application.
• Reviewed test plans, test cases for testing the project
• Facilitated UAT (User Acceptance Testing) with Business Users
• Involved in generating Periodic Status Reports

Environment: Uml, MS-Project, MS-Office Suite, MS Visio, MS Visual Source Safe (VSS), Bugzilla, Java, J2EE, Web Sphere, XML, SQL Server 2000, Windows 2000