Professional Summary:

• Around 7 years of Business Analyst experience in various fields such as Manufacturing, Banking, E-commerce, Pharmaceutical, Healthcare, and Insurance
• Strong Experience in preparing project deliverables such as Software Project Charter, Business Requirements Documents (BRD), Functional Requirement Documents (FRD)
• Excellent knowledge of the Claims processing, Diagnostic codes, Reimbursement processes and HIPAA
• Experience in Software Development Life Cycle (SDLC) models such as Waterfall, RUP and Agile methodologies (SCRUM)
• Excellent hands on testing such as Functional, Regression, System, and UAT.
• In-depth knowledge of SQL, UNIX, XML, XSD, Web service, Data warehousing, and ETL tools such as Informatica
• Excellent knowledge in the field of Investment banking and Commercial banking
• Very proficient in Data Modeling, Data Flow Analysis, Transaction Flow Analysis, Alternative Path analysis and Data Security
• Adept in creating and transforming business requirements into software requirement specification(SRS) and designing business models using business intelligence, use case models, analysis models, class diagram and activity diagram
• Experience in working on DB front end like TOAD, DBVisualizer and SQL Server Studio including installation through remote site, setting up logins to different databases and different schemas
• Excellent hands on experience in conducting GAP Analysis to get a clear picture of AS- IS and TO- BE Scenario. Talent in analyzing problems through SWOT Analysis
• Chaired Requirement Gathering Sessions (RGS), Joint Application Development (JAD) sessions and Joint Application Requirement (JAR) sessions and interviewed Subject Matter Experts (SMEs), and updated the requirements
• Excellent knowledge of implementing N- Tier Architecture in web application
• Excellent working experience in TIBCO Business Works, Administrator, Hawk, Adapters, and Rendezvous and Active MQ
• Extensive experience of workflow and process modeling using Use cases and UML Diagrams
• Excellent knowledge Determining Task Dependencies, Identifying Milestones & Monitoring Critical Paths using Gantt Charts, Resource Plans (Schedule & Allocations), Entity Relationship Diagrams (ERD) and Requirements Traceability Matrix
• Designed and implemented SQL queries using joins, unions, outer joins, group by and aggregate functions to extract data from different databases (Oracle, SQL Server) for timely reporting and Validation
• Worked closely with both development and testing teams to improve quality of the application by actively participating in regression analysis and User Acceptance Testing (UAT)
• Excellent understanding of business processes, proven skill set in Business Process enhancement and their documentation.
• Experience in developing Test Cases from Use Cases, reviewing Test Plans and implementing Manual and Automation Testing using Quick Test Professional.

TECHNICAL EXPERTISE

MS Word, Excel, Access

Operating System

Windows XP/Vista/7, Linux

Web Development Tool

HTML, Photoshop, JSP, .Net, Visual Basic

Business Analysis

Crystal Reports, Rational Rose, UML

Reporting Tools

Crystal Reports, SQL Server Reporting Services,

Project Tools

MS Project, RationalRequisitePro, RationalRose, MS Visio

Testing Tools

Load Runner, QuickTestProfessional, Rational Clear Quest, Quality Center

Methodologies

SDLC, Waterfall, Agile, Spiral, RUP

Middleware

TIBCO BusinessWorks, RV, Hawk, Adapters, Designer

Programming Languages

SQL, Oracle, C,C++, Java, J2EE

Database

Crystal Reports XI, Microsoft SQL Server 2005, Oracle 9i/10g, Tera data, DB2

Professional Experience:

Confidential, Chicago, IL Feb ‘ 10 – Feb ‘ 11
Business Analyst

GCDS Qualification and Monitoring (The New CD system) project was to enhance the business processes(enterprise wide) and technology infrastructure to support the accurate collection and reporting of CD Investments, Loans, Mortgages and Services. The enhanced system will increase efficiency of the qualification process and enable a formal monitoring process with metrics, there by reducing the overall qualification error rates, while supporting additional volume of loans, investments, and services required for Community Impact Reporting.
Responsibilities:

• Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.
• Gathered core Requirements and done thorough framework Analysis.
• Captured data to support the determination of Community Development qualification
• Supported and provided deployment of product enhancements and new functionality. Identified resistance to change through responsive listening skills, pointed out relevant software advantages, provided positive feedback, and follow up support.
• Perform Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Assist with user testing of systems (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Responsible for identifying and documenting business rules and creating detailed Use Case , Conducted User Acceptance Testing.
• Assist in the translation of business data requirements into conceptual, logical, and physical data models.
• Worked with business users for requirements gathering and understanding of user needs.
• Maintain current knowledge of data relationships and system interfaces
• Wrote requirements for high, intermediate, and low-level requirements
• Creating data maps to document data attributes to data sources and data targets, including identification and documentation of data transformation.
• Reviewed and analyzed the business requirements document to derive the functional specifications.
• Designed mock screens for UI screens, reports based on User stories extracting the business process flows and workflows involved in the project using MS-Project, Word and Excel
• Reviewed technical analysis to ensure predefined business requirements were met.
• Analyzed customer requirements, mapped requirements to application solution and developed design documentation.
• Considered impact to current and future business environments and processes, assessing the size of the tasks, technical and application complexity, risk analysis.
• Coordinated work plans between project manager and client using MS Project
• Performed Feasibility, Adaptability and Risk Analysis to identify the business critical and high-risk areas of the application.
• Integrated assets acquired into existing offshore operations, Facilitated the development of initial work plans, budgets, and operating manuals. Communicated and led the implementation of operating and development plans for these assets.
• Increase accuracy of reporting of other public commitments for Community impact reports.
• Participated in different management scenarios like Change control, Quality Assurance, Defect tracking, system integration, people management and scheduling.
• Managed changing requirements and updated specifications using Unified Change Management (UCM) tool
• Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met
• Documented specifications for enhancements by using existing system documentation and procedures.
• Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR)
• Created Project Plans, authored Requirement Documents, designed mock screens for UI screens, reports based on User stories extracting the business process flows and workflows involved in the project using MS-Project, Word and Excel
• Worked with SQL queries for data manipulations with respect to Tera data database
• Configured and used MS-Share Point to maintain all the project related documentation like Project Plans, Requirement documents, Testing documents, Meeting Minutes, Acceptance and Sign-off documents
• Participated in risk analysis, conducted feasibility study and performed impact analysis for proposed enhancements.
• Gathered core Requirements and done thorough framework Analysis.
• Coordinated and conducted Review sessions with the Design and QA team for all test phases: product testing, bug fixes, integration and system testing. Implemented test phase entry and exit quality (UAT) criteria for Release Management.
• Participated in the Application UAT planning Provided Test Scripts and designed the Report outputs to ensure accuracy.

Environment: MS Visio, Rational Unified Process (RUP), SAS EG tool, UML, MS Office, Windows XP/2000, SQL, Tera data, Java/J2EE, HTML, Actuate, OBIEE, XML, Mainframe, XSL,MS Project.

Confidential,Wichita, KS May 2009 – Dec 2009
Sr. Business System Analyst

Responsibilities:

• Responsible for gathering all the initial requirements and documenting them by preparing the BRD, Use Cases and Technical Design Document
• Created Hawk rule base for various integrations to get the information of the process that are hung and get emails for the same.
• Resolved tickets through BMC Remedy while working on the day time support on the Tibco environment
• Excellent hands on experience in gathering requirements and designing the system application and testing them
• Prepared test status reports to the upper management
• Involved in the design of the entire architecture of the new line that was implemented.
• Co- ordinate with the offshore team which was developing the Tibco application on Tibco Designer and suggested changes to them
• Republished the files that had failed during the Web Service call or network failure on the respective Topics and Queues
• Created CRQ and put up a Change control depending upon the severity of the issue as Standard, Emergency or Normal change control
• Created Database tables by using SQL through DB Vizualizer and queried database by using complex SQL queries
• Excellent hands on experience on the reporting tool such as cognos, crystal reports etc
• Managed the team of developers which were offshore and conveyed the requirements and the scope of the project to make sure no requirement is missed from developing
• Performed day time support in the production environment and resolved any problem in data transfer
• Designed the User Interface for better communication to developers
• Created the FAQ documents by fixing the data transfer issues accordingly, which can be used towards the intranet support website
• Co- ordinate with different teams to ensure the data is being processed accurately without errors and also fix the reoccurrence of any repeating issues
• Involved in generating the Hawk rule base/scripts for monitoring the BW engines and Adapters
• Used TIBCO Administrator to manage TIBCO Components, to monitor and manage the deployments
• Created Technical Design specification and Use cases for integrations
• Created Process-Flow documents for clear understanding of the data flow from source to target for all integration
• Checked Database passwords expiration through DB Vizualizer on a daily basis and obfuscated the passwords which were using custom java to Tibco Obfuscation

Environment: TIBCO Business Works, Rendezvous, Active MQ, HAWK, File Adapter and ADB Adapter, XPath, Oracle 10g, XML, DB Vizualizer, UNIX, SQL Server, BMC Remedy. Windows XP, BI Application.

Confidential,Sacramento, CA Oct 2007- Apr 2009
Business Analyst

Responsibilities:

• Gathered requirements for improving cash flow management by enabling the ability to send payments electronically, collect payments and move money across accounts
• Responsible for tracking and recording requirements for transferring money in and out of business and consumer accounts across financial institutions (Dealing with B2B money transfer)
• Supported the design of the payment gateway & reporting gateway.
• Experienced working both independently and in a team-oriented, collaborative environment
• Designed the business requirement collection approach based on the project scope & SDLC Methodology
• Prepared custom reports and performed SQL query, data analysis and verification on MS Access
• Gathered requirements and embedded in BRDs and use cases in Functional Specification Document
• Followed a structured approach to organize requirements into logical groupings of essential Business Processes, Business Rules and Functional specifications, thus ensuring that Critical Requirements are met thoroughly
• Documented test cases during requirements, analysis and design phases
• Designed and developed all Use Cases and UML models using MS Visio and Rational Rose
• Involved in the testing of the application to ensure the right output is gained when executed
• Performed extensive requirement analysis including data analysis and gap analysis
• Conducted several meetings between members of different IT groups and representatives of the higher management to make the “Build or Buy” decision
• Involved in hiring decisions for resources for the project
• Translated the priority requirements into specific goals, objectives, critical success factors, priorities, action plans and deliverables at each iteration using MS Excel, PowerPoint, MS Project, Visio and other MS Office products
• Conducted Sprint Planning Meetings with Project Sponsor, Scrum Master, Team, SMEs/Product Owners, User Representative and Focus Groups to prepare the Sprint Backlog and communicate deliverables
• Co- ordinate with the offshore team that was developing the application

Environment: Rational Rose, Rational Requisite Pro, Java, HTML, XML, Rational Clear Quest, JavaScript, Oracle 10g, MS Visio, MS SharePoint, Windows XP, .NET Framework, Agile Environment, Quality Centre

Confidential,Emeryville, CA Aug 2006-Sep 2007
Business Analyst

Responsibilities:

• Business Analysis and modeling activities by interviewing business users from Vaccines Service Centre, Trade, Operations and IT to identify business requirements, workflows and business rules for processes that included Customer Registration, Vaccines Pre Booking, Order Pull Through and Vaccines Ordering database.
• Created wire frames design for clear understanding of the website that needs to be developed
• Excellent ability to maintain complex workflows and field configuration
• Suggested changes in the Architecture of the ordering process by using MS Visio to create a Gap analysis from AS-IS to TO-BE Scenario
• Created use cases and business use cases model after accessing the scope and status of the project and understanding the business processes from USER perspective
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues, and come to an agreement quickly
• Developed the Project plan for the phased implementation of the website
• Prepared the BRD for the website novartisvaccinesdirect.com using use cases obtained by in from the stakeholders
• Developed time lines for project delivery and managed projects and resources to successful completion
• Assisted the QA team in designing the test strategy, test cases and test scenarios for system testing and user acceptance testing
• Addressed change management issues during website development and after it went live, prepared the Application Transition Plan for transfer of the application support from the vendor to the support team
• Prepared training material on the website and conducted training for Novartis users that comprised of administrators, sales representatives, Vaccine support Center team
• Created Documentation for future use by the Training and Help Desk teams

Environment:Oracle 9i, Test Director, MS Project, MS Office, MS Visio 2003, Windows XP, J2EE, Quick Test Professional

Confidential,Milwaukee, WI March’05- Jul 2006
Business Analyst

Responsibilities:

• Performed extensive requirement analysis including gap analysis
• Developed the business concept and obtain top management approval for the proposal
• Conducted ROI (cost-benefit analysis) resulting in increased efficiency and reduced cost
• Developed timelines for Project delivery, and managed projects and resources to successful completion
• Identified Key Risks, impact and change readiness
• Collected, analyzed, organized and documented business Requirements
• Developed Functional Specification and Non-functional Documentations
• Identified, investigated, analyzed, defined, and documented business processes and Use Case Scenarios
• Provided input and reviewedthe testing scenarios and test cases
• Designed and developed Use Cases, Activity Diagrams, and state Diagrams using UML
• Developed the Requirement Traceability Matrix
• Involved in development of User Interface (UI) mock-ups, operational flow diagrams
• Assisted Quality team in developing and executing test strategies, test plans
• Developed and documented User Acceptance Test (UAT) and User Guide
• Recommended and ensured appropriate training was available for all users

Environment:J2EE, Sun Solaris, JDBC, IBM DB2, MS Visio, MS Project, UML, MS Office, Windows2000, Linux Redhat.

EDUCATION

• Master of Business Administration, (Health Care) Findlay, OH