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

Confidential,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 reviewed the 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.
Confidential,Columbus,OH Dec 2004- Dec 2005
Business Analyst

Responsibilities:

• Played a significant role in the performance improvement of the Statewide Automated Child Welfare Information System (SACWIS) monthly batch processing, with particular emphases on improved throughput and quality.
• Excellent understanding of HIPAA in security, privacy, and code sets
• Enhanced efficiency resulted in the monthly batch-processing window to shrink by approximately 40%
• Interacted with Business Users to generate and review business test cases to upgrade User Interface system.
• Designed the business requirement collection approach based on the project scope & SDLC Methodology.
• Gathered requirements and embedded in BRDs and use cases in Functional Specification Document.
• Designed and developed all Use Cases and UML models using MS Visio and Rational Rose Developed Sequence Diagrams, Activity Diagrams.
• Conducted interviews with key business users to collect requirement and business process information.
• Developed Business Process Modeling using MS. Visio and Rational Rose.
• Experience with Agile, worked as SCRUM master in a fast paced environment
• 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.
• Performed extensive requirement analysis including data analysis and gap analysis.
• Held periodic status meetings with various stakeholders.
• Facilitated and managed meeting sessions with committee of SMEs Conducted several meetings between members of different IT groups and representatives of the higher management to make the “Build or Buy” decision.

Environment: C++, VBScript, XML, MS office, MS Visio, Windows XP Pro, Quality Center, Quick TestPro, Weblogic and Web Sphere, Oracle10g, Rational Requisite Pro, MS Project.

Confidential,Los Angeles, CA Jul 2004- Dec 2004
Business Analyst

Responsibilities:

• Interacted with the project team to help define the business and system objectives, confirmation of scope, identify constraints and the measures of success for the system to be developed
• Gathered user and business requirements (BRD) for UI through interviewing Subject Matter Expert, and technical group to explore potential solutions
• Identified the rules used in processes that implement business policies to ensure the quality and identify any conflicts
• Clear understanding of the CPT codes and ICD codes such as ICD-9, ICD-10
• Recommended suggestions for improving the business process
• Understanding of the fundamentals ofCommercial Property Casualtyinsurance operations including underwriting, marketing and claims.
• Documented and delivered Functional Specification Document to the project team.
• Created UML based diagrams using Rational Rose and MS-Visio for Use Cases and Activity Diagrams, for better understanding of the layout of the new process
• Gathered primary requirements and input/output requirements and modeled the processes using Rational Rose.
• Identified the data exchange with various engines and preparing detailed data flow diagrams.
• Gathered requirements from users for Screen Design, Navigation Design, Report Layouts (Prototypes), frequency of report generation and report size.
• Interacting with the developers on resolving the reported bugs and various technical issues.
• Queried the database using complex SQL queries
• Worked with the QA team in designing the Test Plan and Test Cases for User Acceptance testing

Environment: Oracle 9i, Test Director, Rational Rose, Windows XP, J2EE, Informatica, IBM DB2, MS Office.

EDUCATION

• Master of Business Administration