HIGHLIGHTS:
Over * years’ experience in IT Industry with 4.5 years’ experience as Business Analyst.
Experience with Object Oriented Analysis and Design using UML, Rational Unified Process (RUP), Rational Rose, Requisite Pro, Rational Clear Case and MS Visio.
Excellent Business Analysis skills and extensive experience documenting Use Case Requirements, Requirements gathering, Gap Analysis, and full life cycle development.
Strong experience in Requirements elicitation techniques - conducting user interviews and JAD sessions with the SMEs to review business requirement.
Efficient in translating Business Requirements into Functional and Non-Functional Requirements using UML diagrams and RUP.
Proficient in creating Use Case Diagrams, Data Flow Diagrams (DFDs), Activity Diagrams, Deployment Views and wireframes/screen mock ups using MS Visio
Efficient in translating Business Requirements into Functional and Non-Functional Requirements using UML diagrams and RUP.
Experienced in software testing which involved development of test cases and test scripts, and User Acceptance Testing (UAT).
Excellent skills Data Analysis, Data Mining, Data Warehousing (ETL), Data Mapping, Requirement Analysis, Business Modeling and Proficient in customizing workflows, activities and deliverables of existing business practices
Strong Knowledge of Software Development lifecycle and methodologies like Waterfall, agile methodology and Scrum approach.
Proficient in Microsoft Office Suite - Word, PowerPoint, Excel, Outlook, Access, Project and Visio.
Strong analytical and problem solving skills, excellent planning and multi-tasking abilities, with proven experience in utilizing people and process knowledge to help enterprises make critical decisions.
Excellent communication skills, leadership, management abilities, and team spirit.
Reputation for dedicated teamwork, high energy, work ethics and commitment with capability to handle new technologies and situations.
Team player, result-oriented, fast learner, excellent communication skills with strong research capability.
Methodologies
SDLC, RUP, UML, JAD, CMM, RAD, Waterfall, Agile
Testing Tools
Rational Enterprise Suite
Business Modeling
Tools
Rational Rose, MS Visio, Rational Requisite Pro
Databases
SQL, PL/SQL, MS Access, Oracle
Operating Systems
Windows XP/Vista
Software Application
MS Office enterprise, MS Office SharePoint, Adobe software application, MS Visio and TFS.
ETL Tools
Informatica Power Center 9.1/8.x/7.1
Data Modeling
ERWIN 4.x/3.x, Ralph-Kimball Methodology, Bill-Inmon Methodology, Star Schema, Snow Flake Schema, Physical And Logical Modeling, Dimension Data Modeling, Fact Tables, Dimension Tables
Programming
SQL, PL/SQL, HTML.
Business Analyst: Conduent (Spin-off from Xerox), Inc. Naperville, IL Sept 2015 Present
Handle different projects related to healthcare and insurance.
Proficient use of agile methodology.
Elicit, capture and review business requirements and develop functional requirements to meet overall business objectives.
Create Product Backlog, Sprint Backlog and manage User stories.
Transform complex business requirements into simple acceptance criteria and User stories.
Maintain traceability and track progress through TFS.
Extensive use of Visio and BPMN to document workflows.
Participate in sprint planning, daily scrums, testing, retrospectives and sprint reviews.
Facilitate JAD/JAR sessions with stakeholders to refine functional requirement
Working with internal and external clients.
Independently manage multiple projects at the same time.
Lead business process and workflow mapping/analysis using data.
Performed key role in call center turn around project resulting in reducing caller waiting time, improving call response times
Developed and maintain great working relationship with clients.
Participate in entire SDLC.
Working as a lead BA on projects.
Train and coach other BA’s
Work with Project Managers to write up Scope document and Project plan.
Work Environment: MS Office SharePoint, and MS Visio, Microsoft PowerPoint, and TFS (Team Foundation Server)
Business Analyst: North shore University Health Systems, Skokie, IL Dec 2014 ---Jul 2015
Gathered and reviewed business requirements, functional specifications, documentation, test plan and developed functional requirements to meet overall business objectives.
Developed functional specifications and system design specifications for client engagements.
Worked closely with Team Lead and other business team members to clarify/focus project scope and requirements.
Worked closely with the data analysis and data warehousing team to ensure all the reports from the work stream are documented and the data elements (business names for the fields) are captured.
Created activity diagram using MS Visio to describe activities and actions taking place in a system.
Created Use Cases to capture just-in-time requirements and plugged it into Use Case Model.
Used SQL, Toad, Data Warehousing, Data Analysis, Data cleansing for the arrangement of customer data.
Created UML diagrams such as Use Case Diagrams, Activity Diagrams, and Sequence Diagrams to graphically represent roles, responsibilities and business artifacts that are engaged in a business process & communicate the use of the business-modeling artifacts as an input to system definition.
Work Environment: Oracle 11i, RUP, UML, MS Office SharePoint, and MS Visio, Microsoft PowerPoint Paint, and MS Access, Oracle 9i, HTML
Business Analyst at Avalon Funding Inc., IL Jun 2012 Dec 2014
Experience with Software development life cycle (SDLC) methodology, Framing out Business Transaction rules and related Documentation, creating Test Plans based on Functionality and Business rules.
Conducted Surveys and Brainstorming sessions with SMEs for requirement gathering and prepared User Requirement Specifications document.
Interacted with Compliance department to understand the Business Rules.
Performed Gap Analysis; appraised project status to upper management on weekly basis using Weekly Status Report
Managed requirements and communicated with Users, Test Team and Project Manager using RequisitePro.
Reviewed and prioritized Use Case, Entity Relation, Logical, Physical and Conceptual Diagrams using Visio with Developers providing clear-cut picture to the developers.
Created Use Case Diagram, Class Diagram, Activity Diagram, State Diagram and Interaction Diagram using Microsoft Visio and Rational Rose.
Conducted reviews with the SMEs to obtain sign off on requirements.
Assisted Development Team by conducting Unit Tests and Smoke Tests.
Responsible for creating Test Plans & Test Scripts and execute them.
Created Requirements Traceability Matrix to trace the requirements back to the Features.
RUP was used to define the design process using Use Case methodology.
Created UML diagrams such as Use Case Diagrams, Activity Diagrams, and Sequence Diagrams
Work Environment : Windows XP, Rational Rose, Rational Requisite Pro, Rational Clear Case, Rational Clear Quest, MS Word, MS Excel, Oracle 8i, UML, RUP, MS Excel, MS Word, MS PowerPoint, SQL.
ETL Developer: Abbott Laboratories, Lake Forest, IL March 2010 May 2012
Developed data warehouse for healthcare research by gathering data for various diseases.
Designed and developed many simple as well as Complex Mappings, from varied transformation logic using Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
Implemented Slowly Changing Dimensions - Type I and Type II in different mappings as per the requirements.
Involved in gathering requirements and created design documents and mapping documents.
Fine-tuned existing Informatica maps for performance optimization.
Using Informatica Power Center Designer analysed the source data to Extract & Transform from various source systems (oracle 10g, and flat files) by incorporating business rules using different objects and functions that the tool supports.
Worked on different tasks in Workflow Manager .
Extensively used workflow variables, mapping parameters and mapping variables.
Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
Implemented Informatica recommendations, methodologies and best practices.
Written documentation to describe program development, logic, coding, testing, changes and corrections.
Work Environment: Informatica Power center 9.0, Oracle 9i, OLAP, Oracle 11g, MS Excel 97, Flat files, Erwin 7.5, Toad 7.0, Windows 2007, HP-UX, and Unix Shell Scripting.
ETL Developer at North shore University Health Systems, Skokie, IL June 2009 Dec 2009
Developed data warehouse for healthcare research by gathering data for various diseases.
Designed and developed many simple as well as Complex Mappings, from varied transformation logic using Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
Involved in gathering requirements and created design documents and mapping documents.
Involved in design and development complex ETL mappings and stored procedures in an optimized manner
Extensively used Power Center to design multiple mappings with embedded business logic.
Work Environment: Informatica Power center 9.0, Oracle 9i, OLAP, Oracle 11g, MS Excel 97, Flat files, Erwin 7.5, Toad 7.0, Windows 2007.
Education: Bachelor of Science, University of Mumbai 1994