SUMMARY

• Around seven years of proficient experience as Business Analyst in Pharmacy & Health care, Insurance, Media/Telecommunication.
• Experienced in gathering user and business process requirements and creating Business Requirement Documents (BRD), Use Cases, Functional Requirement Specifications (FRS) and Requirements Traceability Matrix (RTM).
• Experience working with Agile Scrum SDLC.
• Experienced in creating Use Case Diagrams, Business Flow Diagrams, Activity diagrams and Sequence diagrams using MS Visio.
• Experience in facilitating Joint Requirement Planning (JRP) sessions, Joint Application Development (JAD) sessions with the business, IT team, stakeholders, and client team members.
• Database knowledge of design and development in SQL Server 2000 and Access 2000.
• Expertise with analytical reporting using Advanced Excel features like Pivot tables and charts.
• Data structuring, Data Modeling and building various data models and ERM (Entity Relationship Model).
• Strong analytical, pattern detection and problem solving abilities.
• Experience in various testing strategies likes Unit Testing, User Acceptance Testing (UAT) and manual testing (GUI testing, Field Validation testing, and Functionality Testing).
• Skilled in interpersonal communication and quick to adapt to new environment with strong problem solving and trouble shooting skills.

TECHNICAL SKILLS

Languages: C#, Java and .NET (Overview), XML, C, C++, HTML, SQL.

RDBMS and Tools: SQL Server, MS Access and AS400 (Overview).

Operating Systems: Windows XP/2000/98/95.

Testing Tools: Quick Test Pro and Quality Center.

Business Tools: MS Office suite, MS Excel, MS Visio, MS Project, MS SharePoint 2007 and MS Access

Reporting Tools: Crystal Report 9, XI.

PROFESSIONAL EXPERIENCE

Confidential - Lincolnshire, IL

Business Analyst

Responsibilities:

• Contributed towards the initial analysis of the project scope and definition document.
• Coordinated with Business Process Re-engineering team to work on integration plans.
• Facilitated project meetings and compiled meeting minutes.
• Facilitated JAD/JAR and brainstorming sessions to gather requirements.
• Analyzed, elicited, and documented user and system requirements for each functional area.
• Performed data analysis and prepared data flow diagrams and wire frames using MS Visio.
• Responsible for functional requirements and design document.
• Knowledge of AS400 with RECAP and RxClaim systems.
• Documented Requirement Traceability Matrix (RTM) for traceability of requirements.
• Conducted system functional document walk-through with the SMEs.
• Used excel functions like lookup, math functions and if functions.
• Prepared detailed test scripts, test plans and assisted in integration testing.
• Responsible for weekly status reporting and status update.

Confidential, Charlotte NC

Business Systems Analyst

Responsibilities:

• Worked through the entire SDLC starting from the proposal to the implementation of the system.
• Facilitated joint requirements planning (JRP) sessions and brainstorming sessions.
• Prepared Business and Functional Requirements documents (BRD & FRD).
• Conducted and participated in walkthroughs with business & development team.
• Prepared high-level business and system use cases. Used MS Visio to model Use Case Diagrams, Activity Diagrams, Business Process, Work Flow diagrams and Sequence diagrams.
• Designed and developed user interface. Conducted Impact Analysis of change requests from work stream owners and the project management team.
• Extensively used SQL queries to extract data from various sources for data validation and analysis.
• Used excel Pivot table and Pivot chart to analyze and organize the data.
• Worked with various data models: ERM, Logical and Physical data model.
• Involved in test data preparation and manual & automated testing.
• Created test plans, test cases and test scenarios along with the testing team to facilitate the testing process and also executed the functional test cases.

Confidential, New York NY

Business Analyst

Responsibilities:

• Led business analysis for Confidential ’s e-commerce experience large product website for advertising sales division.
• Worked with the team to identify scope document.
• Facilitated requirements planning sessions (JRP/JAD) involving operations and technology team.
• Documented current processes, created workflow processes and design documents.
• Prepared detailed business & functional requirements, business needs and project objectives via feedback sessions and client meetings.
• Agile environment elicited, analyzed, documented and communicated requirements for implementation and build out of automated billing process.
• Created a branding guideline for the SharePoint portal and team site master pages, content pages, site definitions, and template feature stapling which was documented in the style guide provided to the client as part of the Design phase.
• Knowledge of Data modeling and working knowledge with Data flows.
• Experience with database management and fetching techniques in MS Excel.
• Database knowledge of design and development in SQL Server 2000.
• Leveraged technology and business process enhancements to deliver on stated requirements.
• Executed user acceptance testing (UAT) and implemented issue tracking.
• Create technical documentation on recommendations for a SharePoint 2010 deployment for the client.

Confidential

Business Analyst/ System Analyst:

Responsibilities:

• Gathered requirements from client to ensure their local and regional requirements are met.
• Evaluated complex business requirements; performed process analysis of customer activities to determine alternative business solutions.
• Analyzed and documented business problems and provided recommendations based on research of industry trends, business products, competitors and performance analysis for optimal business solutions.
• Created Business Requirement Documents, Function Specification document.
• Participated in research, data gathering, business analysis and development of strategies to support business decision-making and business process requirements.
• Organized and facilitated problem-solving discussions with the client, internal operations team, and project managers to resolve issues requiring a focused approach to maintain project continuity and requirements.
• Acted as a liaison between the business and IT technical resources