SUMMARY

• Overall 8 years of IT experience in the field ofData / Business Analysis, DataModeling and Project Management.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data conversion, Data Quality,DataGovernance,DataIntegration and Metadata Management Services andConfiguration Management.
• Experience in creating Ad - hoc Reports,Data-driven Subscription Reports by using SQL.
• Competent in Software Development Life Cycle methodology (SDLC)and Software Testing Life Cycle(STLC) which includes RUP, Agile and Waterfall Methodology.
• Preparation of Test plan document and proficiency in conducting different types of testing.
• Experience in gathering and writing detailed business requirement and translating them into TechnicalSpecifications/ System Requirement Specifications (SRS) and design identifying interface and BusinessProcess Specifications.
• Hands-on experience using Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling,Fact and Dimension Tables, Physical and Logical Data Modeling.
• Expertise in Teradata, Oracle, SQL Server, Google Analytics, MicrosoftOffice Suite.
• Extracted data from different data sources like Oracle, DB2 loaded in data warehouse depends on thebusiness logics.
• Experience in creating Logical tables and columns, Dimensional Hierarchies, Level-Based Measures,Time-Series data.
• Knowledgeable inDataConversion, Normalization, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake Dimensional Schema using
• Erwin Tool.
• Strong experience in interacting with stakeholders/customers, gathering requirements throughinterviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Extensive experience in writing Complex SQL Queries, Sub-queries, Dynamic SQL queries etc.
• Experience in various phases of Software Development life cycle (Analysis, Requirements gathering,
• Designing) with expertise in documenting various requirement specifications, functional specifications,Test Plans, Source to Target mappings, SQL Joins.
• Good experience in development of reports using Statistical and Data Reports.
• Good experience in development of reports using Statistical and Data Reports and also expertise in generating business process flows using MS Visio.
• Excellent interpersonal skills and leadership abilities. Fast learner with excellent analytical and communication skills.

TECHNICAL SKILLS

Operating Systems: Windows, LINUX.

Languages: HTML, CSS and Python

Database Systems/Tools: Oracle, SQL, SQL Server

Software: MS Word, Excel, PowerPoint, Visio

Issue Tracking system: JIRA, Redmine

Testing tools: Selenium

Code Control Tools: GitHub, BitBucket

Web/ Application Server: Tomcat, Apache

SDLC: Agile, Scrum, Kanban, Scrumban

PROFESSIONAL EXPERIENCE

Scrum Master

Responsibilities:

• Have experience as Business analyst in Health Care Domain Business analysis, Medical Management, Care Management and SQL.
• Ensure that Agile principles, methodologies, and concepts are consistently adhered to and guide the team through Agile activities as requested or needed.
• Capture and use Agile metrics and retrospective actions with an eye on assessing Agile maturity and process andpractice improvement.
• Heavily involved with setting up recurring status meetings with the business, fielding questions from the business, aswell as handling issues that arise from the business.
• Act as the primary interface between project managers, product owners and the development function
• Ensuring User Stories are properly described, estimated, and managed according to a Definition of Ready.
• Supports the teams estimating efforts. Guides them in establishing normalized estimating approach.
• Complete understanding and strong experience of Agile Scrum delivery
• Demonstrable experience of leading transformation to agile practices or continuous improvements in newly establishedagile teams
• Monitored and track progress, prepare status reports, resolve issues, coordinate tasks, and activities directed towardcompleting the project goals.
• Closely worked with product owners to ensure understanding of user stories and keeping the backlog groomed.
• Monitored the Sprint Burndown and conducted daily stand up, encouraging open communication in the team.
• Gathering and updating project materials, completing budgeting, forecasting, project documentation, business flows,and lessons learned documents.
• Coordinate all Scrum Ceremonies including Sprint Planning, Daily Standups, Sprint retrospectives, Sprint Demos, StoryGrooming, and Release Planning
• Coaching and mentoring other Scrum Masters on our program team. Partnering to ensure that our ways of working areconsistent across teams.
• Assist in defining and deploying new product development processes and in facilitating the continuous improvement ofexisting processes.
• Liaising between developers and project stakeholders; fostering quality communication between engineering disciplines
• Assist team members in identifying, prioritizing and either clearing or escalating impediments.
• Ensures that the process is followed, including issuing invitations to daily scrums, sprint reviews, and sprint planning and sprint retrospective.
• Updates the metrics dashboard and reports.
• Manage requirements elicitation, analysis and documentation processes to capture business and end user needs.
• Prioritize needs within and across projects based on business impact.
• Support business case creation.
• Communicate solution tradeoffs to business partners to frame and influence project decisions.
• Engage delivery teams to communicate solution vision and priorities.
• Promote architectural standards and consistency.
• Promote usability standards and design solutions with a high-quality, effortless UX.
• Assess the risks of solution options and develop plans to mitigate them.
• Support enterprise digital strategy and organizational change management.
• Define, set up, and execute test cases to validate that the solution meets functional and non-functional requirements.
• Provide consultative support and advice on technology projects led by business partners.
• Document requirements as user stories.
• Partner with business stakeholders and product owners to manage requirements reprioritization processes throughoutthe delivery lifecycle.
• Use co-design and prototyping approaches to design and iterate on high-value solutions.
• Participate in ongoing meetings to support project delivery, including team stand-ups, solution show-and-tells, andsprint planning.
• Participate in other delivery activities (e.g., testing, coding) as required in collaboration with other delivery teammembers to support solution delivery objectives.
• Serve as a champion foragilemethods across the delivery team and organization.

Confidential

Business Analyst

Responsibilities:

• Gathered requirements from stakeholders and acted as bridge between stakeholders, managers,and developers.
• Conducted user interviews and documentedbusinessand functional requirements.
• Tracked bugs and ensure issues are resolved before going to production
• Collaborated with business and technology leads to identify the appropriate data for testing, andprepare that data for the test cases.
• Worked with the QA and Testing team to help with reviews on Test Plans and Test Cases forfunctional and integration testing.
• Maintained the requirements traceability matrix to track requirements coverage.
• Documented any issues or defects and eventually got the sign off from the right parties.
• Manually verified the validity of the failed test cases. Performed Positive, Negative and BlackBox testing on the application.
• Assist in weekly status meetings with Development Team, QA Manager, clients and developmeeting-minutes.
• Designed and developed test scenarios and test cases based on business requirements, technical specifications, and use cases.

Confidential

Business Analyst

Responsibilities:

• Worked closely with Sr. Business Analyst’s and Project Manager’s in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
• Extensively uploaded test cases from MS Excel, MS Word to Test Director & Quality Center.
• Identified internal and external system Requirements, design, and configuration set-up.
• Involved in strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.
• Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
• Involved in designing the Project document templates based on SDLC methodology.
• Involved in the development Business Requirement Document as well as High-Level Project Plan.
• Involved in writing the functional Specification Documents and Supplementary Specification (non-functional) Documents.
• Incorporated Rational Unified Process (RUP) to create Requirement Document Specifications using Visible Analyst.
• Involved in the implementation of data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
• Collaborated with the development team in validating requirements for out of box requirements.
• Involved in managing the defect lifecycle - conducting daily defect tracking meeting, reporting, and reviewing the defects, assigning the open defects to developers, and re-testing the fixed defects.
• Participated in the Logical and Physical Design sessions and Design Documents.
• Worked with developers to make sure that they understand the Use Cases.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Created and executed test plans for Smart Stream, Cognos, and Oracle users.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Develop User Manuals, and Training Manuals as per Project Specifications and timelines.