Senior Business Analyst Resume
West Chester, PA
SUMMARY
- System/Business Analyst with 8 years of IT experience in deployment of web - based, Client-Server applications, developing business processes and system solutions for HealthCare, Banking, Automobile, Insurance and Financial Industries for various projects from conceptualization to implementation.
- Experience in documenting Business Requirements, Use Case Specification, Functional and Non-Functional specification, UML diagrams including Use Case diagram, Activity diagram, Class diagram, Sequence diagram, Data Flow diagram (DFD), Entity-Relationship diagram (ERD), Requirement Traceability Matrix (RTM), Change-Version Control, Training and User Manuals with extensive knowledge of Unified Modeling Language (UML), Software Development Life Cycle (SDLC), Object Oriented Analysis and Design (OOAD), Business Process Re-engineering (BPR), Testing Lifecycle, Data Modeling, GAP analysis, risk analysis, cost-benefit analysis, conducting Joint Application Development Sessions (JAD) and various methodologies including Waterfall, Agile and SCRUM, Prototyping, Rapid Application Development (RAD) and Rational Unified Process (RUP).
- Proficient in the Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) specialized in Quality Assurance Process, Verification, Validation, Testing and Reporting across multiple platforms.
- Experience with Web Development E commerce projects.
- Extensive knowledge and experience of n-tier architecture, web controls, web services implementations in a SOA environment.
- Experienced in MS SQL-Server 2005/2008/2008 r2/2012 (T-SQL) Database design, Development, Data modeling, writing queries, Constraints (Domain and Entity), Indexes, Views, Stored Procedures, LINQ to SQL, SSIS Packages, Cursors, Triggers, User Defined Functions.
- Skilled in performing Database backend testing and in writing SQL queries and checking the code for SQL injection attacks.
- Excellent Team player to work in conjunction with testers (QA), developers and other team members in validation and testing of complex project scenarios and in the maintenance of Quality Standards of projects.
- Experience with Web Development E commerce projects.
- Fluent in a broad range of technologies, including business process tools such as MS Project, Excel, Access and Visio.
- Experience working in CMMI, ITIL and Six Sigma methodologies.
- Have experience with various defect tracking tools: Quality Center, Clear Quest.
- Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
- Strong Analytical and Problem Solving skills, Multi-Tasking abilities, with proven experience in utilizing people and process knowledge to assist enterprises in making critical decision.
- Expertise in analysis of current Business Practices and Analysis of current IT Systems and Procedures and Documentation of workflow and Business Process Reengineering.
- Ability to handle independently projects, Team player and an individual contributor with steep learning curve and in on application architecture design, assist in developing project plans, and good interpersonal skills.
TECHNICAL SKILLS
Business Skills: Business Process Analysis & Design, Gap Analysis, Impact Analysis, JAD/JRP Sessions Requirement Gathering, and Use Case Modeling
Models & Methodologies: Agile, RUP, and Waterfall, RAD, SCRUM
Languages: C#, VB.NET, VB6, VB 9.0, SQL, PL/SQL.
Operating Systems: Windows Server 2008/R2, Windows 7, Windows XP, Windows 2000, Windows NT, Windows98.
Web Technologies: ASP.Net, IIS, HTML, DHTML, XML, XSLT, XSD, SOAP, J2EE, AJAX, Silverlight, Web Services, JavaScript, AJAX, MVC, JAVA, PHP, Adobe Photoshop, Adobe Illustrator.
Database Technologies: SQL Server 2000/2005/2008, MS-Access, LINQ, Stored Procedures, triggers, ADO.Net, SSIS Packages, Oracle, DB2
CASE Tools/Other Tools: Crystal Reports, SSRS, MS Office Suite (Word, Excel, Power Point, Outlook), MS SharePoint, MS Visio, MS Project, and MS FrontPage, Rally, Clear Quest, Clear Case, MS Visio, Rational Suite, Requisite Pro, SQL Server management Studio.
PROFESSIONAL EXPERIENCE
Confidential
Systems Analyst (Performance Analyst)
Responsibilities:
- Gathered business requirements and performed gap analysis for every release.
- Conducted the JAD Sessions with stakeholders and developers to have a clear picture of a project.
- Implemented agile methodology for iterative and incremental development of the system.
- Developed Epics, themes and stories based on User Narratives and created Backlogs.
- Adept in creating Agenda for Sprint Planning and Review Meetings.
- Developed test cases and test plans on the basis of Acceptance Criteria detailed in User Stories and also performed testing of the functionality of the application to ensure that the application is able to handle huge data.
- Used UML to create use case diagrams, sequence diagrams and activity diagrams.
- Developed HTML prototypes and UI deliverables, such as wireframes, flowcharts, screen mock-ups, and interface design specifications.
- Produced design presentations. Determined screen flow, navigation, and labeling. Designed screen interactions and behaviors.
- Performed Backend testing by using PL/SQL queries to test the integrity of the application.
- Developed flowchart and process diagram using MS Visio.
- Conducted interviews with clients to analyze their data and gather requirements.
- Clarified QA team issues and reviewed test plans and test scripts developed by development team and
- QA team to make sure all requirements have been covered in scripts and tested properly
- Was in regular contact with Business partners on the status of issues, action plans and timeframe for resolution throughout the development cycle.
- Identified bugs during the test phase and reported them using HP Quality Center.
- Created user manuals and help files for different user groups
Environment: MS SharePoint 2010, MS Lync, MS SQL Server 2008 R2, MS Office, MS Visio, MS Project, SharePoint Designer, Adobe Photoshop, Illustrator, Visual Studio, Team Foundation Server, Rational requisite pro.
Confidential
Senior Business Analyst
Responsibilities:
- Gathered User and Business Requirements through interviews, surveys, prototyping and observing Stored and modified requirements.
- Utilized Software Development Life Cycle (SDLC) to configure and develop process, standards procedures.
- Provide user interface design for Web-based projects, including dashboards, widgets, and products.
- Conducted ROI, Technical feasibility and Operational feasibility studies.
- Thoroughly studied the requirements for the process re-engineering.
- Created Need Analysis Documents of the requirements gathered through JAD and JRP individual elicitation sessions using MS Word.
- Created User Requirement Specifications (URS), Business Requirement Document (BRD) and Functional Document Specifications (FDS) documents.
- Created Use cases, Use Case Diagrams, Activity Diagrams, Business Flow Diagrams and Business flow Diagram using Rational Rose and Rational Requisite Pro.
- Involved in analysis of the technical specifications of the current system and the infrastructure needs performed Gap analysis.
- Created complex stored procedures using SQL with multiple table joins and comprehended and isolated problems areas.
- Experience with Business Reporting Tools such as Crystal Reports.
- Understanding the underlying constructs associated with each application (Clinical and Financial systems) access control rules and creating Application Assessment Documents.
- Create Requirement specifications document and Roles based matrix document for Roles Based Access Control to enable driver development for each application.
- Used MS Visio to construct user creation/ user provisioning process flow diagrams.
- Prepare Requirement Traceability Matrix, Test plan and Test cases document.
- Document test results and obtain end user validation document sign off.
- Run LDAP Queries on Apache Directory Studio to retrieve user data for data analysis.
- Create requirement specifications and define data elements for key performance metrics.
- Followed the extreme/agile methodology throughout the entire project life cycle. Followed the SCRUM Methodology for small progressive iteration development.
- Experience with Healthcare EDI (ANSI X12) and regulatory requirements (HIPAA).
- Assisted Project Manager in creating resources allocation in MS project for the team for the new enhancement projects.
- Developed validations using JavaScript and JQuery.
- Utilized Microsoft Team Foundation Server (TFS) to manage the team's software development lifecycle including deriving product backlog items, assigning sprint work items to developers and conducting sprint review meetings.
- Responsible for the integration of software modules (version control and packaging releases).
- Organized and shared electronic documents using Open Text Live Link (ECM).
- Responsible for documenting the defects and assigning the defects to the responsible people. Was also involved in tracking the status of the defects on a day to day basis to provide an update to the testing coordinator and the project manager.
Environment: MS Office Suite 2010, Adobe Photoshop, Illustrator, MS Visio, SQL Server 2008 R2, Team Foundation Server 2010, T-SQL, RDBMS, JQuery, JavaScript, Crystal Reports.
Confidential, Newyork, NY
Senior System Analyst
Responsibilities:
- Assured thatbusiness objectives and priorities are aligned by collecting business requirements precisely.
- Managed and analyzed the project, coordinated between team members and created test plans as per the collected requirements.
- Facilitated and actively participated in the interactive sessions with various groups about Confidential t care, includingbusinessowners, SMEs and marketing team, for effectively gathering requirements.
- Developed Process Model and detailedBusinessPolicies ensuring HIPAA guidelines.
- Effectively understand the clinical trial operations andbusinessproblems of the pharmaceutical, biotechnology, device and Clinical Research organizations and effectively gather requirements.
- Followed the RUP methodology for the entire SDLC, documented product requirements in the developmental stage to functional specifications.
- Designed user interface for desktop and Web-based products, from conceptualization and detailed user interface and functionality design through implementation.
- Created Use case scenarios according tobusinessneeds and other UML diagrams to design Use Case Diagrams, Data Flow Diagrams, Activity Diagrams, Sequence Diagram and ER diagrams
- Assure the Traceability of application functional, performance, and security requirements to the businessprocess steps.
- Used HP Quality Center to look up defects and issues raised by testing activities.
- Interacted with developers and various members of my team to discuss and resolve defects and their priorities.
- Involved in service-oriented architectures (SOA) suitable for secure, reliable, and high-performance deployment.
- Produced and managed documentation on release activities to support problem resolution.
- Reviewed and evaluated all the modules of the software before delivery to users to confirm meeting the standard criteria.
- Performed basic UAT with the different customers and differentbusiness modules
Environment: Rational Clear Quest, MS-Visio, WSDL, Test Director, UNIX, Windows NT, C#, HTML, HP Quality Center, Oracle, SOAP, BPEL
Confidential, West Chester, PA
System Analyst
Responsibilities:
- Involved in requirements gathering, system analysis, design and development of a custom 3-tier web based system for an inventory tracking and management system using ASP.NET, C#, MVC, SQL Server, XML, JQuery, JavaScript, XSLT, XPATH.
- Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
- Utilized RUP to configure and develop process, standards, and procedures.
- Aided management in standardizing Web applications by preparing GUI standards and recommending alternatives for in corporation in phased, iterative manner.
- Performed GAP and Risk analysis of existing system and evaluated benefits of new system.
- Conducted Joint Application Development (JAD) sessions with stakeholders throughout SDLC to resolve open issues.
- Validated technical designs created by IT developers against functional specifications.
- Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).
- Coordinated work plans between project manager and client using MS Project.
- Created documentation for training and Help Desk teams.
- Followed the extreme/agile programming methodology throughout the entire project life cycle. Designed applications using UML - Modeling by applying Object Oriented Analysis and Design (OOAD).
- Involved in Unit testing and Integration Testing for the entire system.
- Involved in preparation of Cascade Style Sheet (CSS) files. Involved in Code review phase.
- Maintained the version of the project by using module developed with latest version in TFS.
Environment: Visual Studio 2010/2008, Crystal Reports 9, TFS, JavaScript, IIS, Web Services, SSIS, VSS, MS SQL Server 2008, T-SQL, RDBMS, Windows Server 2008, Rational Rose Enterprise Edition UML, MS Project.
Confidential
Senior Programmer Analyst
Responsibilities:
- Involved in requirements understanding, validating and realizing them to design documents and in turn will be converted to software components.
- Analysis, Design & Development of local data management modules for different Departments using Visual Studio 2010, ASP.NET, C#, SQL Server, XML, AJAX and JavaScript.
- Extensively Involved in Web & Win Forms coding and implementation phase using C#.
- Developed the modules to control and guide the movements of the robot. Involved in controlling the movements to take proper readings.
- Developed the simulation testing modules. Tested different configurations taken up by the robot.
- Developed Administration Modules to display configuration, settings and test results using ASP.NET, C#, AJAX, HTML and JAVA Script.
- Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
- Responsible for setting and execution of Service Oriented Application systems by following standard testing methodologies
- Developed and consumed Web Services in C# used for authentication of user.
- Implemented Model-View-Controller (MVC 3) Architecture, enabling multiple developers to work on separate modules simultaneously, reducing effort time for the project.
- Migrated COM components in VB 6.0 to VB.Net components. Extensive use of Third party COM libraries like Mitsubishi and Allen Bradley COM Components.
- Created SQL queries, stored procedures, functions and triggers and implemented SQL queries in the C# code to provide features like automated synchronization.
- Database Schema design, Implementation, development, Query development, indexing, maintenance and configuration in MS SQL server 2008.
- Involved in Data-driven testing, Integration testing, Stress testing.
- The reports were created using Crystal Reports 9.0, C#, ADO.Net and SQL Server and later using SQL Server Reporting Services (SSRS).
- Involved in designing and documentation of flows and functional diagrams using Visio 2010.
Environment: Visual Studio 2010, ASP.NET 3.5, C#, VB.NET, MVC 3, SSIS, Crystal Reports 9, ADO.NET, JavaScript, IIS, Web Services, VSS, MS SQL Server 2008, T-SQL, RDBMS, COM, XML, XSL Visual Studio .NET, Windows Server 2008, MS Project.
Confidential, Wilmington, DE
Sr .Net Programmer
Responsibilities:
- Designed and implemented a front end using ASP.NET and VB.NET & C#.NET that involved the usage of Visual Studio 2005 Framework
- Implemented forms authentication or administration of role based security using Active Directory.
- Played a major role in production of SSIS jobs. Used custom .NET assemblies for Script Task in SSIS.
- Used JavaScript to highlight user selections in the data grid with Dynamic Controls and CSS
- Involved in Web parts development using HTML, XML, XSLT, and classic ASP and create and process XML documents, including using XML Serialization
- Written SQL Queries, Stored Procedures, Triggers, Database restoring, Defining roles, creating users, Assigning Roles to users and relational database design(RDBMS) in SQL Server 2005
- Involved in the development of module using Object Oriented Methodologies like UML.
- Involved in the deployment of the entire application using Microsoft Internet Information Service (IIS).Involved in EDI process of file transfer between clients
- Extensively involved in creating the Ajax components using ATLAS framework. For multiple updates in datagrids. Used other AJAX library such as Update Panel and Model Popup Extender within some web pages.
- Performed Unit testing by using Nunit 2.4 Beta1 version and performance tuning of the application by populating and creating indexes in the database.
- Extensively Involved in WinForms coding and implementation phase using C# 2008.
- Extensively involved in .Net exception handling management, debugging, user controls in GUI.
- Prepared project plan using Microsoft Project Plan 2003 and Function Point Analysis
- Involved in designing and documentation of flows and functional diagrams using Visio 2003
- Responsible for configuration management (Configuring the Project in VSS, Taking VSS backup)
- Done unit testing, integration testing and regression testing.
Environment: ASP.NET 3.0, C#.NET 3.0, VB.NET, COM, DCOM, SSIS, SOA, EDI, ADO.NET, JavaScript, VB6.0, MS Access 7.0/2000, IIS, VSS, SQL Server 2005, T-SQL, XML, HTML, DHTML, SSIS, ASP, Visual Studio 2005, UML.
Confidential, New Jersey
.NET Programmer
Responsibilities:
- Prepared High Level Functional Document for Application.
- Involved in Screen Designing for Prototyping approvals.
- Developed Web User Control, which can display Current Date, Current User in Uniform way in all Web Forms.
- Involved in Developing Business layer using C#.NET.
- Extensively Used Grid View, Form View, Detail View Controls with Object Data Source Controls.
- Implemented Master Pages and Tree View Control with Site Map Data Source.
- Implemented Data Access Layer in New Manner with Table Adapters.
- Involved in writing Stored Procedures using SQL SERVER 2000.
- Used Confidential Compare version merge tool to merge various developers code with VSS.
- Involved in System testing to make sure all functionality of the application.
- Used Bug tracker to track all bugs of the application and it helps us to track and solve the bugs in efficient manner.
- Analyzed the business requirements and documented the functional requirement blocks
- Created procedural flow charts, application flow diagrams and process flow diagrams.
- Documented the design specifications and technical specifications, technical procedures to support the functional implementations.
- Created and executed Unit/Integration/System test cases and documented the test results.
- Responsible for interfacing with the business analysts in understanding the business requirements and converting functional requirements in to logical test suites.
- Involved in reviewing the test cases with the testing coordinators and performing the quality checks.
- Worked closely with the development teams in understanding the technical implementation blocks and documenting the unit, integration test plans and designing the unit and integration test cases.
- As a member of the development team, I was responsible for executing the test cases and documenting the test results.
- Responsible for documenting the defects and assigning the defects to the responsible people. Was also involved in tracking the status of the defects on a day to day basis to provide an update to the testing coordinator and the project manager.
- Responsible for reviewing the test results with the business partners and technical team leads and documenting the test metrics.
Environment: MS Visual Studio 2003, Microsoft .Net Framework 2.0, C#.NET, ASP.Net, ADO.Net, SQL Server 2000, Crystal Reports, MS Visual SourceSafe, CSS (Cascading Style Sheets), UML, XML, Java Script, XML Web Services.