Sign in

Business Analyst

Irving, Texas, United States
February 13, 2018

Contact this candidate


Gayathri Putumbaka

Sr. Business Analyst



Seasoned Business Analysis professional with around 8 years of work experience in Banking, Healthcare and Retail industries.

In-depth knowledge and experience with all phases and methodologies of Software Development Life Cycle including Waterfall, Agile/Scrum and RUP.

Strong experience in Business & Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.

Highly qualified in changing the needs of Business Users and Stakeholders to the Functional/Technical Requirements.

Responsible for understanding and documenting business requirements and for turning abstract information from data analyses into appealing and understandable visualizations that improve business insights from the results of the analyses.

Served as a critical resource and liaised between Subject Matter Experts and Technologists throughout the project life cycle.

Excellent conceptual and technical skills to create Business Requirements Document, Functional Specifications Document, Process Flow Diagram, and Detailed Design Document.

Experience conducting JAD (Joint Application Development) sessions with Stakeholders and Business Partners to resolve issues.

Expertise in creating project artifacts such as Business Requirements Document (BRD), Use Case Documentation, Requirements Traceability Matrix (RTM), Business Rules Spreadsheet (BRS), Functional Requirements Document (FRD), Data Mapping Document, and Systems Requirements Specification.

Strong experience in RUP Business Modeling process, complete UML artifacts related to Business Modeling, Requirement Elicitation, Analysis, Specification, Traceability, Validation and Verification.

Brought deep expertise in data visualization tools and techniques in translating business analytics needs into data visualization and semantic data access requirements.

Performed GAP Analysis, SWOT Analysis, User Acceptance Testing (UAT) and Cost Benefit Analysis.

Proficient in design and execution of Test Strategy, Test Plan, Test Scenarios, and Test Cases based on the requirements for the applications.

Very good understanding of relational database, object oriented programming, data modeling, data mapping and data warehousing.

Proficient in designing, capturing, consolidating, and maintaining key metrics with Agile and Scrum Protocols.

Extensive experience in working with MS Excel. Created various charts, graphs, pivot tables, and ad-hoc reports in Excel.

Ability to work with several partners/colleagues and deliver the results in time and/or resource constrained environments.

Excellent oral and written communication skills.


Sr. Business Analyst

Citigroup, Irving, TX November 2016 – Present

This project involved upgrading the transactional fraud detection application called Falcon on Hadoop eco-system. The application allowed users which were mainly Fraud Analysts to view transactional details with various attributes of the transaction to detect fraudulent transaction.

Facilitated JAD sessions, interviews and quizzes to elicit requirements from the business owners and the technical members of the project to understand the requirements.

Involved in GAP Analysis for the proposed functionalities to understand the changes required and documented those changes.

Implemented a hybrid of waterfall and Scrum as a part of Agile methodology for work management.

Involved in preparing the business requirement document (BRD) using the requirements gathered by elicitation techniques such as Joint application development (JAD), Surveys, Interviews, Brain storming, SWOT Analysis.

Worked extensively on creating UML Diagrams, Use Case Diagrams, Activity Diagrams using business modeling tools such as MS Visio.

Interviewed various Fraud Analysts to determine the functional requirements and document the same.

Involved in developing Case Management Module in Falcon Software.

Involved in logical and physical data modeling documentation.

Performed knowledge transfer around data visualization to business stakeholders.

Designed mock up screens and wire frames to help stakeholders visualize the UI.

Worked closely with Product owner on prioritizing Product Backlog Items.

Collected information about different entities and attributes for integrating application on Hadoop.

Involved in creating Entity Relationship (ER) Diagrams to the proposed database.

Developed Functional Requirement Document (FRD) using detailed use cases, activity diagrams, sequence diagrams and process flow diagrams and converted to Product Backlog Items (PBI).

Involved in managing requirements, prioritizing and grooming the PBI with help of team based on business needs.

Wrote user stories and help team to decompose those user stories using various slicing techniques.

Involved in defining Acceptance Criteria for each user story and Definition of Done for the PSPI.

Visualized data insights using data visualization tools such as Tableau, QlikView.

Conducted meticulous GAP analysis between As-Is system and To-Be solution while successfully reengineering Scrum processes to increase operational efficiency and alignment of business objectives.

Involved in writing Test Scripts, Test Cases and performing User Acceptance Testing.

Involved in the design, review, implementation, testing and release of UI application.

Environment: Waterfall-Scrum Hybrid, Hadoop, MS Visio 2010, MS Excel, MS Word, JIRA, XML, SSIS (SQL Server Data Tools), Tableau, HP Quality Center, Windows 7.

Sr. Business Analyst

Aspen Dental Management, Chicago, IL March 2015 – September 2016

Worked on creation of EDW for the organization. This EDW was divided into various DataMarts where data was migrated from AS-400 which was the old data base to the EDW. Aspen Dental is a dental care provider organization which has around 550 facilities across US for which this database was developed to help them create and maintain their patients and patient related data on day-to-day basis. This data is being migrated using SSIS and SSRS packages.

Gathered and created Functional and Non-Functional Requirement Documents, BRDs, FRDs, Use Cases, End-to-End System Workflows, Interface Diagrams, and Mapping Documents.

Facilitated collection of Functional Requirements from system users and prepared business requirement documents.

Created complex workflow diagrams using BPMN 2.0 to represent the existing and the TO-BE process and performed Gap Analysis on it.

Involved in analyzing requirements for data migration, data reconciliation, mapping rules, staging rules and transformation rules for the ETL processes.

Extensively created Business Process Modeling Diagrams/Swim Lane Flows using BPMN notations and MS Visio indicating future state of database.

Created Process Flow Diagram to represent source to target mapping of the data from source to ODS and to EDW.

Proficient in preparing User Stories, Use Cases, Business Process Models by BPMN 2.0 Framework, and Prototypes.

Created FRD for developing the ETL logics and the data maps for loading the tables.

Developed extensive SQLs for testing ETL logic.

Standardized ETL processes across multiple platforms (SQL Server).

Tested data mart prototype SQL, ETL process (SSIS and SSRS) for Dental Patient Management System where data was transferred from AS-400 which was the old Database to EDW.

Created Source to Target mapping for ETL workflows and conveyed the requirements to ETL team.

Documented User Stories using the latest Smartsheet document to be able to more deeply analyze the needs of business team.

Implemented Agile Methodologies (e.g., Sprint Sycle, Burn Down Chart, Velocity, Backlog Grooming) to transform into Agile from waterfall environment.

Created Requirements Traceability Matrix and support in creation of enterprise solution architecture to integrate business rules across domains.

Facilitated Joint Application Development session to create a bridge between Business team and Technical team to be able to identify if there was any difference of opinion between the two.

Created efficient Test Plans to effectively test the migrated data and developed a new template to be used for all future testing for the organization.

Ran complex SQL queries to test if the migrated data had been transformed correctly.

Implemented proficient use of SQL to fetch complex data from the database for testing.

Created Use Cases and Requirements Documents to document business needs.

Created reports using tableau for business to be able to more deeply analyze the needs of improvement in their function.

Environment: MS Word, MS Excel, MS Outlook, Smartsheet, MS PowerPoint, MS Visio, MS SharePoint, Management Studio for SQL, Aldon, Tableau.

Business Systems Analyst

Sears, Hoffman Estates, IL April 2013 – January 2015

As part of the Identity and Access Management SOX Remediation team, worked with Business Owners, Project Management, Application Owners and multiple other teams to design and implement new processes to supplement the quarterly access reviews. The project aimed towards creating and implementing new processes that would better align the business to not only made sure that the correct access was granted but also that the unauthorized access was removed or validated. Applications included in these processes fall under the SOX, HIPPA, PCI, and GLBA compliance. As part of the sub-team under the IAM Solution Center, I worked in the Raw Data team. The primary focus of the team was to identify application owners, communicate the requirements for the Raw Data to provider, collect raw data, perform C&A and Reconciliation Checks, and manually transform the data and upload the data to OIM.

Conducted the AS-IS and TO-BE analysis of the Access Review Process and helped the team devise new processes and help improve current processes by researching alternate solutions.

Worked with the internal and external audit team to identify requirements for collecting user access data from the application.

Worked with the internal audit team to identify requirements for collecting evidence pertaining to the data pull from the application to prove out that the data received was complete and accurate.

Documented the requirements for SOX Compliant application separately and other applications separately.

Documented all the requirements for data and evidence and communicated them to the Application Owners and Data Providers.

Assisted in the development of new processes for collecting, transforming, and reviewing the application data.

Wrote documents defining new processes and procedures, and worked with the Access Review and Audit Team to get a sign-off.

Maintained priority list of applications to be onboarded/connected to Oracle Identity Manager.

Connected with the development team and provided requirements and documentation for creating ETL Jobs to automate the data pull for multiple applications.

Worked with the Business Intelligence team to receive reports from OIM that could be used in Reconciliation of data between the application and OIM.

Performed Completeness and accuracy checks and reconciliation on the data and evidence received.

Worked with the OIM (Oracle Identity Manager) team to perform removals of access from application.

Worked with the Manual Controls team and provided them data for the applications that were not connected to the OIM. Manual controls team then created the Access Reviews manually.

Worked with 3rd party application owners to define and document process to collect their user access data.

Worked closely with the Data Access Modeling team to identify application scope and to resolve any issues identified during reconciliation of data.

Updated the requirements, data transformation, and process documentation as and when needed.

Managed extensive timelines and deadlines for the project and provided daily updates to the team.

Helped the Team Lead in updating the team tracker and the project Dashboard.

Provided training and ongoing help to new team members in understanding of the newly implemented processes and procedures.

Environment: Agile, SharePoint, Oracle Identity Manager, UML, MS Word, MS Excel, MS Access, Use Case Diagrams, MS Visio, SQL.

Business Analyst

Cigna Healthcare, Bloomfield, CT September 2011 – March 2013

The project involved executing HIPAA 4010A to 5010 Migration projects for all of the Cigna’s health insurance subsidiary companies. HP works with EDIFECS, Deloitte, Oracle and IBM products to upgrade and manage all of the Cigna’s broker gateways and claim engines environments that are aimed to deliver cost-effective, on time and easy flow of EDI transaction for Cigna, which will reduce administrative cost and increase productivity, and will lay a foundation for ICD-10 implementation.

Understood user needs and accurately represented those in a well-documented software Functional Specifications Document and created Test Cases based on that.

Gathered Business Requirements and interacted with the Users, Designers, Developers, Project Manager and QA team to get a better understanding of the business processes.

Interacted with the end-users by interviewing them, by preparing appropriate questionnaire to better understand end-user needs and the business process.

Developed Detailed Design Specifications including service models and message schemas and detailed source-to-target data mapping and data transformation rules.

Supported PL/SQL development for contingency and internal audit reports and also maintained data in warehouse and data marts.

Planned and created Test Scenarios and Test Objectives to ensure that the system modification will meet the specified business requirements.

Developed component level scripts in Quality Center per established standards and maintained daily status.

Followed a structured approach to organize requirements into logical groupings such as requirements for Customer, Client, Group, Member and Reporting that critical requirements were not missed.

Performed GAP Analysis of 5010 EDI transaction using implementation guide to identify the changes in the segments and data elements and also created and maintained data mapping documents for them.

Created Data Mapping Documents, Test Cases for system Testing, Integration Testing (UAT) and Production (Post Implementation Review) in Agile/Scrum environment.

Assisted in several components of the overall ETL process and data warehouse system and also reviewed ETL programs for compliance with best practices, standards, enterprise architecture and documentation requirements.

Directly involved in process improvement plans and implementing business change and health information exchange between trading partners and payers.

Led UAT testing activities done by the business users and securing Sign off on the patches released to UAT.

Environment: Windows XP/NT, UNIX, C++, Java, HTML, XML, Java Script, Oracle, Rational Requisite Pro, UML, Win Runner, Load Runner, Test Director.

Business Analyst

M&T Bank, Baltimore, MD January 2010 – August 2011

M&T wanted to deliver the relationship based marketing strategy that was needed to sustain its business objective of offering custom services directly to its clients. M&T undertook various system enhancement initiatives such as PACE Enhancement, EZ leads upgrade and Business CRM initiative that would allow their personal and business bankers as well as the senior management access to a single view of all the information stored about each customer to provide timely decision-making information concerning customer and financial services trends. As a Business Branch Supervisor, my role was to assist the systems enhancement team to identify, elicit and document the requirements involved with the various systems enhancement initiatives undertaken by M&T Bank.

Worked with business and systems representatives to understand and define business requirements for the proposed system enhancement.

Participated in the user experience sessions and provided input to the system’s team on the usability of the banking systems.

Served as a liaison between system management team and the branch business management team to identify business needs and provided feedback on the systems usability and performance.

Used need based selling to analyze customers’ financial needs and objectives and presented all appropriate options working cooperatively with appropriate business partners to meet those objectives.

Periodically accompanied Business Manager on business meetings to achieve business development expectations.

Assisted in User Acceptance testing (UAT) and helped user select and write cases for UAT.

Reviewed and provided feedback on the training and reference material being created for the system end users and assisted in User training for the new application.

Participated in Gap Analysis to identify banks current marketing and business strategies from “AS-IS” to “TO-BE” business model and helped document the gaps identified in the “AS-IS” to “TO-BE” business model.

Assisted Senior Management in performing KPI Analysis to get in depth information on the banks current marketing model and to develop a logical marketing data model prototype.

Coordinated with the regional checking champion & scheduled weekly conference call to monitor regional checking acquisition efforts & goals.

Tracked and compiled weekly sales figures, compiled weekly star performers and employee of the month report.

Reviewed, monitored and managed budgetary and expense controls for business. Monitored and managed retail and commercial overdraft reports for business.

Understood and translated administrative and operating procedures and policies to ensure efficiency of business activities. Conducted audits on all management control and security items ensuring proper controls were maintained.

Ensured compliance with operational, security and control policies/procedures, preventing fraud and protecting customer assets.

Followed consumer and business banking guidelines for accuracy and proper account handling.

Worked on creating the business development plan, which included information including business activities, anchors, efforts, etc. and tracked the success of the development plan.

Environment: Windows XP/2000, MS Visio, MS Outlook, MS Excel, MS Word, MS PowerPoint MS Visio.


Master of Science in Management

Contact this candidate