Project Management Data

Prathyusha Atluri #512-***-**** (Mobile)

***********@*****.*** #737-***-**** (Home)

Have 6+ years of work experience in Project Management, Business Analysis, Data Analysis and User Acceptance Testing (UAT) with proficiency in Functional, Database and ETL Testing

Summary

Project Management: Managed projects, typically from initiation through delivery within given constraints of scope and schedule. Recommend effective solutions to highly complicated business and technical issues

Business Analysis: Worked with business users across diverse functional areas to understand, document and analyze business requirements, document analysis, process discovery and business process improvement, process mapping. Elicit requirements, User Stories, Business Rules, and Process Flow Diagrams. Document review, surveys, JAD sessions and SME of multiple products

Data Analysis: Preparation of Test Data, data design, data mapping, data modeling, document data requirements, end to end processing of data flows. Very good understanding of Data Warehousing concepts and various ETL Tools and Utilities. Experience with SQL Server and the ability to write own SQL statements/ MS Excel functions to pull data from multiple sources

Test Management: Understanding business requirements, analyzing & translating them to test cases and test scenarios. Developing test strategies, authoring test cases, configuring and installing test systems. Creation, execution & Peer reviewing of Use cases, Test Cases, Traceability Matrix. Performing System, Integration, Smoke, Sanity, Regression and Retesting and UAT. Creating and maintaining Test Status Reports

Defect Management: Analyzing Defects and test results, Debugging, Identify, analyze and respond to defects based on their severity, Defect Reports, Triage of Issues, Reporting bugs. Troubleshooting, reproducing, and verifying issues

Good understanding of SDLC & STLC, Agile methodology and BFSI domain experience

Strong knowledge of Black Box Testing, ETL and Reporting Tools

Able to work in various environments: Windows, Unix/ Linux, Mainframe

Experience in Configuration Management Tools

Coordinated with onshore & offshore teams across geographies. Capable in working with large virtual teams

Quick learner, adept at multitasking & troubleshooting skills, Process oriented, keen to learn & work on new technologies

Technical Skills

Testing Knowledge : Manual, Database, SOAP UI & XML Data base : Oracle, SQL Server, DB2, MS Access

ETL Tools : Informatica, Cognos, Business Objects, XML Gateway

Operating System : Windows, UNIX, Mainframes

Other Tools : HP ALM/ QC, JIRA, Rational Tools, Rally, MS Visio

Projects Profile

Modernize Portfolio Project Management (MPPM)

Organization: TEK Systems – Austin, Texas

Technologies: Mainframes- DB2, SQL Server 2008, MS Excel, MS Access, MS Visio, HP ALM

Role: Business Data Analyst

Project Duration: Aug 2016- Till Date

Texas Department of Transportation (TxDOT) is one of the largest State agencies in Texas; it is made up of 21 divisions, 6 offices, 4 regional support centers, and 25 geographical districts. TxDOT is revamping their portfolio and project management system (PPM tool) to better streamline their business across the enterprise. The MPPM project initiative is developing a 21st century business model, focused on cost savings, efficiencies, and increased value. It will be replacing TxDOT’s 1970s-era program used for planning and federal funding. The MPPM initiative includes improving, automating and standardizing TxDOT’s practices relating to portfolio management, project management, contract management and grant management at the enterprise level.

Responsibilities/ Contribution:

Working with various internal users of the application across the state in various locations

Utilizing various data systems, extracts raw data from reporting system and conducts in-depth analysis on customer product flow

Collect, develop, and analyze multiple concurrent business requirements and transfer the same knowledge to product owners, senior management by compelling business cases, writing approval documents for both new products and support to existing products

Retrieving data using Excel, compile or manipulate data across multiple sources

Documenting the Process Flows, Use Cases and Data Mappings required for Integration

Creating complex test scenarios and test plans with business and technical groups

Coordinated the review of test plans, scripts and results of system test plans and Executing test plans and script

Coordinate, monitor, and perform system testing and user acceptance testing

Creating Swim Lane diagrams with Process discovery and modeling/documentation

Identifies, analyzes and documents software defects; assists developers in analyzing and resolving defects

Analyzing user requirements and policy and procedures to create system requirements to be used by designers or project team to create computer applications or for RFP

Analyzing the data and creating the Data Mapping solutions

Capturing and documenting business and reporting requirements from multiple sources

Performing analysis, organize data and create reports from various sources

Developing the requirement, processes and procedures for all required project documentation

Working with cross-agency Stakeholders to gather business requirements from various locations and offices throughout the state

Assist with project budgets, schedules, work plans, resource requirements, and cost estimates and projections

Chase – FORCE product

Organization: JP Morgan Chase Services

Technologies: Oracle 10g - SQL, MS Excel, MS Access, HP ALM, Cognos Report Studio 10.2, Unix

Role: Business Analyst

Project Duration: Oct 2015 – July 2016

Corporate Technology and Risk LOB of JP Morgan Chase ensure the security and resiliency of the Firm’s computing environment, protect customer and employee confidential information, and comply with regulatory requirements globally. This product is replacement of Phoenix Risk Analysis Tool which has high quality security solutions and services that are focused on improving the Firm's risk posture which consist of Investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management, and private equity.

Responsibilities/ Contribution:

Worked with business users across diverse functional areas to define, map and analyze existing business process

Document and analyze business requirements that drive the development and design of reports

Understanding business data and its consumption by the business and downstream users and systems

Communicate with internal sourcing, finance, project management teams to educate, gather feedback, gain approvals and resolve product financial issues

Analyze and dissect system requirements and technical specifications to create and execute test cases for large business initiatives

Tested Dashboards and Reports in different environments and platforms using Cognos

Worked in Functionality testing, Database Testing, GUI testing, System testing, Ad-hoc testing, Regression testing and E2E testing

Key role in the planning, testing, and implementation of business enhancements or changes in Agile Methodology

Involved in testing Business Report developed in Cognos

Understanding the Source and Target systems and understand the BI reports

Performed GAP analysis and provided suitable reports for analysis

SQL query creation, execution and result verification

Created and maintained test data in complex SQL distributed databases

Analyzed data trends, draw conclusions and recommend direction as it applies to defect resolution

Work with Data Mapping, process flows and other UML diagrams using MS Visio

Coordinated with onshore & offshore development teams and discussed technical problems & defects

Participated in weekly Review meetings and Status meetings

Able to perform database/data manipulation to generate required result sets

Transamerica Life Insurance (AEGON)

Organization: Computer Sciences Corporation (CSC)

Technologies: Mainframes (CICS, ISPF, DB2 - SQL), XML Gateway Mapper, SOAP UI, MS Excel, MS Access, MS Visio, IBM Rational Tools, Clear Quest

Role: Business Systems Test Analyst (BSTA)

Project Duration: Aug 2011 – Oct 2015

Vantage One is the CSC enterprise-wide system for life and annuities, providing production support to Transamerica (AEGON) and for enhancement in the existing system as per the business requirement. AEGON has few closed and open block business which uses VANTAGE policy administrative system. This project deals with various enhancements and maintenance work related to B2B, JETS, DSS and RPS Systems.

Responsibilities/ Contribution:

Understanding of Users high level Business requirements & converting to low level Business Specification Design

Initiate and facilitate JAD sessions and requirement walk through’s before entering into the development phase, participate in peer reviews of tests with onshore/offshore teams

Create requirements traceability, Enter and manipulate requirements stored in the requirements management tool

Manage system integration, verification and validation tasking by managing requirements in IBM Rational Tools

Writing Use Cases and Process flows diagrams

Acted as Subject Matter Expert for Policy Life Cycle

Responsible for extracting data from different source systems using XML Gateway mapper into a staging area and loading into data marts and verified the reports

Preparation of mapping specifications and conversions

Good experience with CRUD (Create, Read. Update & Delete) data cycles

Testing of mainframe applications, verifying mainframe files, submitting the JCL batch jobs and verifying the logs on CICS and keying transactions using TSO and ISPF commands and menus and utilities

Working on DB2 database files

Exhaustive Test Planning to cover Systems Testing, Regression Testing and E2E Testing scenarios

System Testing of Modifications and reporting defects

Integration Testing and UAT and providing BA SIGN OFF

Analyzing and Documenting the Business Requirements

Work with Data Mapping, process flows and other UML diagrams using MS Visio

Key role in the planning, testing, and implementation of business enhancements or changes

Exhaustive Test Planning to cover Systems Testing, Regression Testing, Integration Testing and UAT

Recreate policy in test regions for testing & usability testing in B2B sites

Constantly ensuring deliverables are met at the required time

Engaged to work on various modifications and service projects simultaneously from Offshore and Onshore.

Involved in mentoring the new joiners on the application flow

Oracle Mantas Product

Organization: Globallogic (Oracle Financial Services Software)

Technologies: Oracle 9i - SQL, Informatica Power Center 8.1, SOAP & XML Testing, Unix, HP-QC

Role: Hotfix Business Analyst

Project Duration: Aug 2010 – Jul 2011

The Oracle Mantas Behavior Detection Platform is the industry's most comprehensive solution for avoiding risk, exceeding regulatory requirements, and enhancing customer relationships.

It provides financial services providers with next-generation analytic applications that address their risk management, performance management, Fraud detection and operational analysis needs. It strengthens Governance, Risk and Compliance (GRC) Framework to Help Financial Institutions Meet Financial Crime and Compliance Management Demands. It provides enterprise-wide Anti- Money Laundering, Surveillance and Trading compliance software for the world's largest financial institutions including ABN Amro, BOA, BOS, Citibank, Deutsche Bank, Keybank, Maybank, Merrill Lynch, OCBC, PNC, Standard Chartered Bank etc.

Responsibilities/Contribution:

Involved in Installation Testing using Solaris / Linux, Database Validation Testing

Build Deployment, Hot Fix Installation & verification

Worked in demanding customer environment and work with large teams in global delivery model

Responsible for on-time delivery of assigned Hotfix with high-quality

Verifying the Mappings and Map Flows using Informatica for different Hotfixes

Created ETL test data for all ETL mapping rules to test the functionality using SQL queries

Tested the ETL mappings and other ETL Processes flow for Hotfixes

Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases,

Written Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables

Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies

Build Data subset strategy to create subset of data from production and maintain and refresh the Test data as per the application needs

Prioritized the delivery of Hotfixes based on the client requirement

Keeping an updated local environment for replication of issues

Worked on Unix shell scripts and executing batch jobs and cycles and monitoring

Running the jobs/Workflows for ETL process

Verifying the ETL data in target database

Verified column mapping between source and target

Manually tested XML & SOAP, Provided RCA reports on the environmental issues

Prepared P&C, Design and Control Data for different Scenarios execution

Worked in close co-ordination with multiple teams

Ebix – Advantage Web product

Organization: Ebix Software Pvt Ltd

Technologies: Manual Testing, Database Testing(SQL Server 2008), MS Excel, JIRA, VSS

Role: Agile Business Systems Analyst

Project Duration: March 2010 – Aug 2010

Advantage Web is an Enterprise Solution for Property & Casualty Insurance based on INS standards. It is a comprehensive, fully integrated, client server technology policy and claims administration system designed for small to medium-size property and casualty insurers and it is the system of choice by larger organizations to administer niche products and specialty lines of

Business. It can be installed as the entire system, or portions of each subsystem, as required by an organization. It includes rating and underwriting, policy production and customer correspondence, real-time data exchanges and business intelligence. Additionally, insurers may elect to customize each selected component to match their unique processing and reporting needs.

Responsibilities/ Contribution:

Analyzed Requirements document and actively engaged in client meetings

Translated business requirements to test cases and test scenarios to ensure that each business requirement is converted into logical flow of the system

With the help of SQL queries verified the data on the front-end application against the back-end database

Performed and participated in all aspects of verification, feature/functional, integration, regression, ad-hoc (exploratory) and sanity (smoke) testing

Worked in Agile development methodology

Developed user stories and acceptance criteria

Developed, executed & reviewed Use Cases and Test cases

Worked closely with other QA resources to effectively validate test features/functionality to meet or exceed sprint test deliverable deadline

Created Test Data as per business requirement which is used for Functional testing using MS Excel

Performed functional testing to check the stability of the application

Participated in manual and usability testing of Generic Claims and Policy issuance Modules

Performed GUI Testing, Regression testing and Integration testing

Engaged to work on various modifications and service projects simultaneously from Offshore and Onshore

Involved in mentoring the new joiners on the application flow

Ability to effectively and professionally communicate, both orally and in writing, while also articulating and translating technical language to non-technical customers

Academic Record

Masters of Engineering Graduated in 2008 with 7.1 GPA

Bachelors of Engineering Graduated in 2005 with 7.6 GPA

Contact this candidate