Lead Business Analyst
Resume:
Samatha
***********@*****.***
Summary:
* ** ********** ** * business system analyst in various industry domains like healthcare, retail, finance and data technology.
Worked on different types of projects such as business intelligence, process improvement and web development.
Excellent understanding and extensive involvement in various methodologies such as waterfall and AGILE in all stages of software development life cycle.
Identifying and analyzing the project impacts to various systems including enterprise data systems, reporting systems, enterprise integration package and portals.
Facilitating requirement and work product inspection meetings with business users and developers
Conducting JAD/Collaboration/Decomposition Sessions with stakeholders including business users, the technical and testing teams
Liaison between the business teams and technical teams for resolution of pending issues
Adept at using various requirement management tools to keep track of requirement status,including entering, prioritizing and modifying as and when required.
Skilled at building a strong team environment, and have the ability to acclimatize to new technologies, relevant knowledge, skills, conditions and situations with ease, excellent verbal, nonverbal and written communication skills.
Have a good understanding of elicitation techniques such as interviewing, questionnaires, brainstorming, focus groups, prototyping, cost/benefit analysis and risk analysis.
Providing support for multiple projects including user testing, creating bug, tracking defects and reviewing for new business requests or change requests.
Creating, updating and maintaining High Level Requirements, Detailed/Functional Requirement Specifications including data mapping, gap analysis, design documents, process documentation and process flow diagrams.
Expert in creating UML Diagrams including use case diagrams, context diagrams, activity diagrams.
Hands on experience with SQL queries and database objects.
Extensively supported different types of Business Intelligence tools such as digital dashboards, data mining, data warehousing and different BI products.
Successfully worked with different databases for example Oracle, DB2, Teradata, SQL server, etc.
Created Test plans and acceptance criteria and did performance evaluation of test results, coordinate, monitor and support of implementations.
Participated in the Quality Assurance (QA) process and maintained the traceability matrix to ensure requirements are consistent, comprehensible, traceable, feasible, and do conform to standards.
Participated in Bug-Review meetings with software developers, QA engineers, managers and suggested enhancements to the existed application from business perspectives, provided solutions to existing bugs.
Experience in training end users to the new systems and providing assistance for later maintenance as and when required.
Technical Skills:
Type
Tools / Techniques
Web Tools
Adobe DreamweaverCS5
ProgrammingLanguages
SQL Server T-Sql, Oracle Pl Sql
Applications
MS Office,Visio, ERWin, TOAD, Team Foundation Server, Visual Studio 2010/2012, Balsamiq, Power view, .NET Framework 4,4.5, Access, Ad hoc, Tableau, ALM, etc
Team Collaboration Software tools
SharePoint, Team Foundation Server (TFS), etc
Databases
MS SQL Server 2008/2012, MS Access,DB2,Teradata, Oracle7/8i/9i/10g(also R2), etc
Requirement Management tool
Requisite Pro, Rational DOORS, Caliber, Rally, JIRA, VersionOne, ClearQuest, Confluence, LeanKit, etc
Operating System
Windows(32 & 64 bit)
Professional Experience:
Company: Infosys Limited
Client: SunTrust Banks, Atlanta, Georgia June 2016 – Till Date.
Role: Lead Business Analyst
SunTrust is a US based one of the leading banks.
Currently associated as Business analyst consultant for Comprehensive Capital Analysis and Review (CCAR) Model Data Confidence project its initiative was kicked off to assess and document the sufficiency of controls for the data used in the models supporting the CCAR FRY-14A Submission and design and implement a remediation plan to address issues found. The key objectives were to document all data sources, assess the adequacies of existing controls, recommend and design additional data controls to mitigate and identified risk, implement and test the designed controls for the 2016 FRY-14 A submission. This effort will also work to address additional regulatory efforts associated to SR 11-7 and BCBS 239 regulation round data quality, management and governance.
Responsibilities:
Analyze the Model inventory list sent by client, identify the models which are in scope, retired and duplicate.
Key stake holders/SMEs were identified and interviewed to understand the complete flow of data used in execution of the model and any existing controls currently in place.
Analyze/review model data provide and classify on the adequacy of the data controls including the process validation, data reconciliation and data quality checks.
Provided daily status update reports on requirement gathering for Model data.
Document the data and business process flows of all identified data from the Model to source using MS Visio
Document the existing data quality controls in place to ensure correctness, completeness and validity of data.
Document the lineage of identified data from the Model to source, to ensure track ability and correctness of source.
Conducted walkthroughs meeting with ORMS, DMM and BIO teams to help understand model data document and to receive signoffs.
Coordinate/lead with offshore team and review the model data flows, lineage etc. documented by the offshore team.
Develop project schedules, timelines, and status.
Participate and lead project status meetings, project schedules and project work estimates.
Primary Point of contact from the CCARA team to the departments/stake holders involved for any and every issue.
Assisted project manager with the managing of project plan covering Project Schedule, Assignment of tasks, Risk management Plan.
Conduct status meetings with business team, client managers on weekly basis.
Used JIRA to report the project status.
SharePoint repository to save and track all the mode data documented.
Environment: MS Visio, MS Excel, MS word, SharePoint.
Company: Infosys Limited
Client: Bank of America, Charlotte, NC June 2015 – May 2016.
Role: Business Analyst
Bank of America is a US based one of the leading banks. I was associated as Business analyst consultant and providing Tableau software and enterprise business reporting solutions. The project was to build the SRDW (Securities Reporting Data Warehouse) for the corporate marketing department. This was intended to give a complete 360-degree view of the securities portfolio of the customers of the bank, and help the marketing department improve the investment portfolio of the customers.
Responsibilities:
•Identified and established communication with all key stakeholders, contributors, business, operations and technical resources surrounding assigned projects.
•Performed Requirements Gathering and Analysis through interactions, meetings and periodic walkthroughs with potential users of the application along with the creation of Use Case Scenarios based on business requirements and Business Rules.
•Developed system process flows and User Requirements Specifications through surveys and interviews.
•Converted Business specification in Functional Specification documents.
• Conducted Use-Case reviews to identify the deficiencies of the current system and to identify the requirements for the proposed system.
•Participate in collaboration sessions with business users, technical team, DBAs, testing team to analyze and validate the requirements and application lifecycle.
•Utilized tableau for dashboard and user stories creation. Worked closely with the Tableau development team to make sure they understood the reporting requirements and that the Data Marts developed met those requirements.
•Performed UAT on the Data Marts and validated the models against the business requirements.
•Prepared the ETL mapping specifications to extract data from the existing source systems to the Data marts.
•Assisted ETL developers with the design and development of ETL workflows for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
•Maintained data consistency and database integrity and attended team meetings to identify requirements for data loading and reporting.
•Documented data sources and transformation rules required populating and maintaining data warehouse content.
•Created and managed project templates, use case project templates, requirement types and traceability relationships in Requisite Pro and managed the concurrence of the parties involved with respect to the evaluation criterion.
•Documented the Purpose of mapping to facilitate the personnel to understand the process and incorporate the changes as and when necessary.
•Developed strategies with Quality Assurance group to implement Test Cases in Quality Center for stress testing and UAT (User Acceptance Testing).
•Wrote Test Plan and created Test cases and scenarios for the various Reports and Dashboards in accordance with the business requirements. Was responsible for writing and updating test plan documents for every version update to the Data Mart.
•Prepared/Reviewed weekly testing status and reports. Presented program-level testing information at meetings as requested.
Environment: Tableau 8.x, Teradata, Oracle, SQL Server, MS Visio, RUP methodology, Rational Rose, Requisite Pro, Microsoft Office Suite ( Word, Excel, Power Point, Visio)
Company: Cognizant Technology Solutions
Client: JPMC, Dallas, TX Oct 2012 – Dec 2013.
Role: Business Analyst
JPMC is a US-based financial services corporation with assets of approximately $264.3 billion. JPMC operations include a regional banking franchise operating primarily in 15 States and the District of Florida, specialized financial businesses serving companies and government entities, and leading Turnkey Asset Management Program and processing businesses
Responsibilities:
•Interacted with Subject Matter Experts (SME), Project Managers, Developers, QA Resources and Participated in collaboration session for managing requirements and to elicit Use Cases.
•Worked in transforming business requirements into user requirement specification, Functional Requirement Specifications Document (FRD).
•Worked with different business users to develop Business Requirement Specifications and gathered Business Rules, Functional & Non-Functional Requirements.
•Documented the AS-IS Business Work flow adhering to UML standards.
•Created Use Case Diagrams in order to show the interaction between the Actors and Use Cases as well as showing the relationship between the Use Cases.
•Presented information, analysis, ideas, and positions in a clear and convincing manner to both technical and nontechnical audiences.
•Coordinated with QA team to make sure they understood the testing requirement properly.
•Performed smoke, Functional and GUI Testing to ensure that the user acceptance criteria are met.
•Coordinated the UAT with the SME'S to make sure that all the Business Requirements are addressed in the application.
•Performed smoke testing for both canned and Ad-hoc reports.
•Managed and worked smoothly with geo-diversified team in different time zone (developers in India, Business and data vendors in EST/PST/CST USA and Canada)
•Performed data analysis to verify quality of data and escalate to data vendors if any discrepancy identified.
•Designed business rules for process flow for training purposes using MS Visio and Balsamiq.
•Researched and documented data dictionary, glossary via interviews.
•AGILE project management using TFS, including backlog management and maintaining status reports.
•Managed the product backlog of future development tasks and project timelines as part of the agile methodology for software development also providing project estimates and frequently performed gap analysis to reduce any discrepancies when required.
•Responsible for requirements gathering, identifying data set and data analysis of data for dashboards and reports utilizing software for its end users.
•Participate in post-production reviews as needed to re-test, reassess metadata, and update required documents when necessary.
Environment: UML, MS Office Suite, MS Visio, Balsamiq, scrum (pre-Agile) implementation, MS TFS, DW, Adhoc reporting, SharePoint, MS Access
Company: Cognizant Technology Solutions
Client: Inovalon, Bowie, MD June 2011 – Sep 2012.
Role: Business Analyst
Inovalon is a healthcare data technology company.
I worked as a business analyst on Medical Record Review project in which physical data is collected from all across the US, maintained in company’s central data repository, and later leveraged to other product systems for multiple analyses.
Responsibilities:
•Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop. Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specificationsfor Medical Record Review automation efforts.
•Responsible for gathering requirements from various stakeholders and documenting them by creating Product Backlog Items(PBI) using Team Foundation Server (TFS), to be implemented in the sprint and linking PBIs with the roadmap items.
•Performed inception and elaboration of project workflow and approval processes supporting project creation, activation, and shutdown; and data imports.
•Involved in design development and configuration of process flow for import process for site review support application.
•Developed flow diagrams for Business process of the company, UI Wireframes and Mockups using Microsoft Visio and Balsamiq and identifying Business Rules.
•Responsible for meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
•Collaborate with product owners, subject matter experts, and it development and operations teams to develop process flows and data flow diagrams. Utilize TFS, VISIO, and Sharepointto formally document requirements and test cases for the PBIs implemented in a sprint.
•AGILE project management using TFS, including backlog management and maintaining status reports.
•Managed the product backlog of future development tasks and project timelines as part of the agile methodology for software development also providing project estimates and frequently performed gap analysis to reduce any discrepancies when required.
•Involved in functional testing of the product after every release.
•Participate in post-production reviews as needed to re-test, reassess metadata, and update required documents when necessary.
Environment: MS-Office 2010, Team Foundation Server 2010, SQL Server 2008, Balsamiq, Sharepoint 2010, .Net, Agile Scrum
Company: Cognizant Technology Solutions
Client: UnitedHealth Group, Minneapolis, MN Oct 2010 – May 2011
Role: Business Analyst
United Health Group is a leader in the health benefits and services industry.
I worked extensively on OptumHealth, OptumInsight, and OptumRx, which are customer centric web portals. It provides the information, tools and solutions people need to help navigate the health care system finance their needs and achieve their wellness goals, so they can live the healthiest lives possible.
I also worked on United Claim System (UCS), which is a web-based application that providers can use to manage patient information and file claims electronically. It has a reporting tool, which is used to query, print and display tracking reports incompliance to HIPAA standards.
Responsibilities:
•Gathered, analyzed and reviewed the Business Requirements for proposed implementations in the web based applications.
•Organized meetings with business owners and architects to develop a process flow and time line for project work flow and gather necessary analytical data requirements.
•Performed Data mapping and created class diagrams and ER diagrams for Prime Project.
•Data analysis of existing data base to understand the data flow and business rule applied to different data bases.
•Performed impact analysis on business processes, application, medical management, provider reimbursement and reporting.
•AGILE project management using TFS, including backlog management and maintaining status reports.
•Preparing Business Requirements and Functional Requirement Specifications
•Work with team in developing Business Requirement Documents for multiple system change requests and participate in system testing.
•Create UML Diagrams like Use Case and data flow diagrams using MS-Visio.
•Conducted UAT (User Acceptance testing) with client and getting signed off on testing.
•Create monthly/weekly status reports to update the project schedules & deliverable plan.
•Prepared Training Manual for better understanding of the application by its end users
•Work with both developers and QA’s to ensure proactive quality checks within timeline.
•Developed Test Cases, Test plans and strategies with Quality Assurance group to implement them.
•Logged defects into Quality Center/ Application Lifecycle Management while doing Functional Testing and followed through the process until the defects were closed.
•Interacted with the users and logged any defects, enhancements from the UAT.
•Managed the product backlog of future development tasks and project timelines as part of the agile methodology for software development also providing project estimates and frequently performed gap analysis to reduce any discrepancies when required.
Environment: Windows, AGILE, SDLC, UML, MS Office Suite, Teradata, XML, HP Quality center, Rational DOORS
Client: M.M. Creations, Hyderabad, India Oct 2009 – May 2010.
Role: Business Analyst Intern
M.M. Creations (India)a family business leading in retail store industry.
I worked with the data modeling team to gather requirements for an Enterprise Data Warehouse that focused on integrating the data from different dimensions like time, transactions, product etc. in the company’s data warehouse.
Also worked on requirement gathering and scope definition for another product viz. Product Inventory System (PIS) that is a web-based application that is used to manage store inventories and its layout.
Responsibilities:
•Conducted and participated in collaboration/facilitation sessions with stakeholders and system users to collect the software requirement specifications (SRS) and used to maintain the requirements and Business Rules.
•Used UML notations and RUP methodology to analyze and translate business requirements into system specifications.
•Managed traceability matrix to trace business requirements, functional requirements, and use cases
•Performed in-depth gap analysis with different business groups to ensure that the system initiatives are met
•Extensively used SQL for data analysis.
•Create UML Diagrams like Use Case and data flow diagrams using MS-Visio. Also created Data mapping and class diagrams.
•Helped data modelers with their ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) to match with business requirements extensively through ERWin.
•Researched and documented data dictionary, glossary via interviews.
•Extensively helped ETL developers with mapping documents for better understanding of data flow.
•Developed Data Conversion Strategy for converting historical data into the new ORACLE data base including navigating, data scrubbing, conversion and manipulation.
•Conducted user acceptance testing (UAT) of the web based application with the QA team.
•Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing using testing tool and defect management.
•Participated in the team meetings to discuss the issues arising out of testing.
•Successfully worked with Oracle database and related tools, for example TOAD, SQL/PL SQL etc.
Environment: MS office suite, Oracle, HP Quality Center, MS Access, UML, scrum (Pre Agile) implementation, SQL server 2010, Erwin, EDW, Teradata, DB2, HP Quality center
Education:
Master’s in Computer Science from Texas A&M University Kingsville, Kingsville USA –May 2015
Bachelor’s in Computer Science from Bhavan’s Vivekananda College Hyderabad, India –May 2010
Contact this candidate