SUMMARY

• Around 8 years of experience in Information Technology Industry as Business / System Analyst Healthcare, Pharmaceutical, Finance industries.
• Proficient in all phases of Software Development Life Cycle (SDLC) achieving milestone using Agile, Rational Unified Process (RUP) and waterfall model.
• Expertise in writing Business Requirement Document (BRD), Functional Requirement Document (FRD), and System Requirement Specification (SRS)
• Thorough knowledge in UML Modeling, including Activity Diagram, Sequence Diagram, Use Cases, State Chart Diagram, Deployment Diagram, Class Diagram, and Component Diagram
• Have extensive knowledge in Data flow modeling and Object modeling, case analysis and functional decomposition analysis
• Created Project schedules, task, monitor them using MS project.
• Proficient at drawing Business Process Diagram, Workflow Diagram, Swim Lanes using Visio.
• Expert in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS) of MS SQL server 2005/2008
• Experienced Business Intelligence / Data Warehousing, gathered business requirements and designed solutions that delivered real business value. Efficient in each phase of Business Intelligence Development life cycle, from Business Analysis to Data Warehouse Design and Implementation.
• Experience in Agile methodology created user stories, conducted scrum meeting, sprint meeting, daily stand up meetings.
• Used JIRA for documenting requirements and performing testing.
• Optimizing Informatica Mappings and Sessions to improve the performance
• Skilled in developing Data Warehouses, Data marts using Star Schemas and Snow Flake Schema.
• 4+ years of experience in creating reports using SQL Server Reporting Services sourcing OLAP cubes and data warehouse, data marts as well as transactional systems
• Created Business process model by using BPMN as well as identify the customer choices and demand by using MS CRM
• Skilled in leading teams of diverse backgrounds to make sound business decisions based on analyses of short and long term business needs

TECHNICAL SKILLS

Methodologies: Agile, RUP and Waterfall

Modeling & Analysis Tools: Rational Rose, MS Visio, Rational Requisite Pro, Caliber RM

Languages: C, C++, SQL, PL/SQL, C#, HTML and XML

Database: MS SQL Server, Oracle, Visual Studio, MS Access, ETL tools

Operating Systems: Windows Vista, Windows 95/2000/XP/7, and MS - DOS

Microsoft tools: MS Office Suite (Word, Excel, Power Point, Outlook), MS SharePoint, and MS Project

PROFESSIONAL EXPERIENCE

Confidential, NJ

Responsibilities:

• Worked as an interface between the users and the different teams involved in application development for better understanding of the business and IT processes
• Worked with business requirements analysts/subject matter experts to identify and understand requirements. Conducted user interviews anddata analysisreview meetings.
• Gathered requirements through Joint Application Development (JAD) sessions involving Project Manager, Technical Lead, QA Lead and SMEs for conflict resolution
• Refined requirements using iterative approach
• Analyzed and prioritized requirements. Created Business Requirements Document and Use Case Documents using Rational RequisitePro
• Involved in Design changes for existing mappings as per business requirements.
• Worked with PeopleSoft team to ensure compatibility of the feed with enterprise-wide PeopleSoft guidelines.
• Act as a subject matter expert for data within the Data Warehouse, Data Governance and Solutions and its use across reporting tools and analytical applications
• Requirement Analysis and Impact Analysis for the Enhancements/ new processes.
• Worked with business requirements analysts/subject matter experts to identify and understand requirements. Conducted user interviews anddata analysisreview meetings.
• Documented AS IS process and TO BE process
• Worked with data (warehouse) optimized through data integrity and an entity-relationship model
• Created UML diagrams like Use Case diagrams and Activity diagrams using MS Visio
• Created UI mock-ups for PSGL Resend GUI
• Optimized/Tuned mappings for betterperformanceand efficiency.Performancetuning of SQL Queries, Sources, Targets and sessions.
• Involved inperformancetuning and optimization
• Maintained traceability between requirements and test cases using Traceability Metrics in Rational RequisitePro
• Worked on MS CRM Dynamics for handling the customer claim inquiries, Validation and case creation.
• Developed various performance management dashboards enabling business intelligence reporting for application portfolio.
• Created reusable mapplets to perform functionalities which were used in many mappings.
• Overlooked an off-shore team assure that all requirements were being completed

Environment: Agile, Rational RequisiteP.ro v, 7.1.2, Microsoft Visio, Java, SQL, SharePoint 2013, InfoPath MS Office Suite (Word Excel, PowerPoint), Microsoft Outlook, MS CRM

Confidential, Woodland Hills, CA

Sr Business Analyst

Responsibilities:

• Performed workflow analysis to understand the inefficiencies in the AS-IS system and documented them accordingly.
• Documented Current State vs. Future State for a Referral Web Portal.
• Created process flow diagrams describing provider and member access to the web portals
• Created user stories and uploaded on JIRA.
• Conducted scrum meeting with scrum master and product owner and defined all requirements and documented on JIRA.
• Involved in analyzing the bugs,performanceof PL/SQL Queries and provided solutions to improve the same.
• Worked with data modelers in developing database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy
• Created test scenarios, test plan and test case documents and performed automation testing.
• Obtained business sign offs on the documents after thorough review.
• Assisted in creation of the Functional Design Document from the Business Requirements Document which was used as the by the development team while preparing the design and held the responsibility of the required data setup for unit testing.
• Translated business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Tuned the mappings and involved inperformanceimprovement phase.
• Created database objects such as tables, views, store procedures for reporting purpose.
• Written basic SQL joins (inner join, Left join, Right join and full join) for reporting purpose and created tabular and matrix reports.
• Led the Change Control Process for changes submitted for the BRD after initial sign off with all stakeholders.
• Skilled in developing Data Warehouses, Data marts using Star Schemas and Snow Flake Schema
• Extensively worked in mappings to Extract, transform and load large volume of records of Equities and intraday market data.
• Created a UAT Plan in conjunction with the UAT Team to ensure all acceptance criteria has been included.
• Created project plan, task and schedule and monitor them using MS Project.
• Created and maintained documentation for end users.
• Maintained a Traceability Matrix to uniquely trace and ensure all requirements requested have been addressed, developed, and tested in the project.

Environment: MS Visio, MS Project, JIRA, Word, Excel, PowerPoint, SQL, Oracle, HP Quality Center, J2EE technology

Confidential, Richmond, VA

Sr.Business Analyst

Responsibilities:

• Created and validated business process models using techniques such as system flow diagrams context diagrams, data flow diagrams, activity diagrams, and swimlane diagrams that includes modeling of all the activities of the business from the conceptual to procedural level.
• Helped enhance and convert existing Visio workflow diagrams.
• Facilitated business requirements gathering sessions with the client, and manage the creation of Business Requirement Document (BRD), Functional Requirement Specification (FRS) and user story.
• Created reading material for better analysis and explanation of system flows.
• Involved in business analysis of the existing tools and configuring new feature set up.
• Produced the key deliverables by understanding the Application design.
• Involved in preparation of test cases and testing of mapping.
• Implemented optimization techniques for performance tuning and wrote necessary Pre & Post session shell scripts.
• Configured the sessions using workflow manager to have multiple partitions on source data and to improve performance.
• Experience in gathering reporting requirements from the business users for business intelligence, data warehouse application.
• Proficient in Dimensional Modeling using Kimball and Inmon methodologies for Star and Snowflake schema designs of Data Warehouse and Data Integration projects.
• Analyze business requirements and develop metadata mappings.
• Involved in end-to-end system testing, performance and regression testing and data validations.
• Jointly manage project resource allocations, planning and status updates to senior management.
• Participated in Daily Scrum Meetings to discuss project status and resolve issues.
• Initiated and managed cross sessions between onsite and offsite team members.
• Worked together with the development team and the Project Coordination Team to ensure that client's business needs have been met.
• Created Test Plans, Test scenario and Test cases for UAT.

Environment: MS Office Suite (Word Excel, Powerpoint), MSP, MS Visio, Windows XP/2000, Caliber RM, Business Process Modeling Notation, HP Quality Center, Dot.net 2.0

Confidential, Atlanta,GA

Business Analyst

Responsibilities:

• Prepared Business Requirements Document (BRD) by gathering requirements from all the stakeholders; translated BRD to Functional Specifications Document (FSD) and created prototypes.
• Developed Use Cases as well as flow charts based on the proposed enhancement for the system
• Developed manuals for end users and for customers.
• Developed Stored Procedures and views to generate various Drill-through reports, parameterized reports using SSRS.
• Created logical and physical design of database and created various objects schemas, tables, views performed various type of joins for reporting purpose.
• Maintained project task, schedules and timelines in MS project.
• Created use case diagram, class, activity and object diagrams and flow charts for developers to understand the business process.
• Created mock ups based on the change in requirements and to make the system more user friendly for customers and end users.
• Created test scenario, test plans and test case documents and performed manual testing.
• Created issue log sheet and submitted to developers for the gap analysis.
• Maintained requirements in RTM to keep track what requirements are ready to publish on live production.
• Created use case documents with main flow and alternate flow based on need from developer submitted to development team.
• Extensively interacted with both user group and development team in coming up with structured charts, class and sequence diagrams
• Took on responsibility for executing Volume Testing, Compliance Testing, Data Quality Testing.

Environment: Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), MS Access, MS Project, Rational Rose, MySQL, Clear Case, Requisite Pro.

Confidential, Roanoke, VA

Business Analyst

Responsibilities:

• Gathering and documenting the requirements that are critical to the business and using those requirements to design application software. Prepared business requirement documents using Rational Requisite Pro
• Understand and articulate business requirements from user interviews and then convert requirements into technical specifications
• Derived Functional Requirement Specifications (FRS) based on User Requirement Specification URS
• Analyzed business requirements and segregated them into high level and low level Use Cases, Activity and Sequence using Rational Rose according to UML methodology
• Implemented RUP and followed iterative process for Use Case driven processes of requirement documentation and their deployments and also created a Traceability Matrix
• Held regular JAD sessions with the system architects, developers, database developers, quality testers during the entire project to assure that the critical as well as the minute details of the project were discussed and issues were resolved beforehand
• Followed the UML based methods using Rational Rose to artifacts like Use Cases, Activity Diagrams and Sequence Diagrams
• Built and maintained close relationships with internal customers and retail systems vendor to ensure efficient development processes are being followed and that business priorities are met, and that projects/development are on schedule
• Assisted technical teams in integrating ‘Customer Relationship Management’ and ‘Procurement’ module into Oracle E-Business Suite
• Assisted with the system testing/user acceptance testing of the functional enhancements as needed
• Assisted with the development of Policy, Procedures and Best Practices for retail operations in alignment with system capabilities
• Used MS Office suite (Word, Excel, Access, Power Point), HTML for project tracking, documentation and presentation
• Verified the Business Scenarios on new builds to allow extended testing by QA team

Environment: Data marts, Rational Rose, RUP, Windows XP, J2EE, Test Director

Confidential, Menomonee, WI

Business Analyst

Responsibilities:

• Worked with the business users to define business requirements and analyze the possible technical solutions.
• Conducted user interviews, gathered requirements, analyzed, and documented Business requirements based on the analysis of loan processing workflow model.
• Modeled AS IS and TO BE processes using MS Visio
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements
• Build dashboard for decision making based on past sales trend and market research analysis.
• Analyzed the Business and System Requirements of the application as well as Provide ad-hoc reporting and analysis.
• Created Use case documents based on need from developer.
• Created Business process model by using BPMN as well as identify the customer choices and demand by using MS CRM
• Performed User Acceptance Testing (UAT) for various web based and database related applications.
• Interacting with the development and testing teams to improve overall quality of the software.
• Developed Use case, Functional, Object diagrams using Rational Rose.
• Analyzed user problems, including automated and manual business processes and identified, researched, investigated, defined and documented business processes
• Act as a resource in understanding how IS systems carry out business functions and assists in ensuring the timely and effective implementation.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Worked extensively with Mercury quality center
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.

Environment: RUP, MS office 2003, MS Visio, MS Project, MS Share Point, Rational Test Manager, Data Stage, Mercury quality center, MS CRM.