vyne uppuluri ba

Click here to load reader

Post on 21-Feb-2017



Data & Analytics

0 download

Embed Size (px)


Vyne Uppuluri4 Gardenia ct Business AnalystDayton, NJ 08810Tel: 732 742 0885email: [email protected]


Experience in the field of Business Analysis, Systems Analysis and Data analysis. Collaborate with peers in both business and technical areas to deliver optimal business process solutions, in line with corporate priorities. Experience in closely working with Stakeholders, SMEs and PMOs. Proficient in all phases of requirement management that includes SSD and SDLC.

Experience in Finance (Compliance, Credit Risk, Operational Risk, ADR, Collaterals and Fixed Income), Pharmaceutical (sampling services, Pharmacy Benefit Management), Wealth (IRA Rollover), Life Insurance, Health care (Affordable Health) and Product Life Cycle Management (PLM) domains


Physical and Logical Data Modeling Proficient in PL/SQL (Select statements, Stored procedure and Triggers), MS Office, MS Project, Pivot Tables, Share Point, Reference Data, Data Analysis and Data Mapping. Reviewing test cases making sure they are in accordance with requirements, and assist the overall testing process by activities such as change and defect management and conducting user acceptance testing (SAT and UAT) Documenting requirements using Unified Modeling Language (Use Cases, Work Flow Diagrams and Activity Diagrams) building business process flow charts using tools such as Visio Agile Scrum methodology.


Developing Superior Business Requirements with USE CASE Methodology, USA


Sogeti USA, Bridgewater, NJ Mar 2016 - PresentPrincipal Consultant

Express Scripts, NJ Apr 2016 Jul 2016Business Analyst

Provide integrated PBM (Pharmacy Benefit Management) services including network-pharmacy claims processing and home delivery pharmacy services Analyze the existing system and the future system Interact with the various team members to gather the information. Prepare HLR (High Level Requirement) document and DLR (Detail Level Requirement) document

Procter and Gamble, OH Aug 2016 PresentBusiness Analyst

Migration of Packaging spec origination of CSS to ENOVIA Implementing the PLM packaging capability parts and specs origination process in ENOVIAs Digital Spec Management (DSM) application. Build the data assets (like common performance specifications and material compositions) in libraries and mapped to specifications for maximum reuse. Creation and release of an FPP(Finished Product Part) that include materials, Customer Units and Consumer Units

Bank of America, NJ Sep 2015 Feb 2016 Business Analyst

Purpose of ORCIT (Operational Risk & Compliance Integrated Technology) is to provide the components Compliance Risk Assessment Monitoring and testing activity Metrics and key risk indicators Identification and reporting of compliance risk issues and exams Regulatory inventories and regulatory change management process

Responsibilities Analyze the existing systems and the futures system Interact with the various system team members to gather the information. Prepare source and target data mapping Involve in preparing the future architectural diagram

Knipper - Pharmaceutical Sampling Services, NJ Mar 2014 Dec 2014 Business Analyst

Pharmaceutical Sampling services system to refine the customer sampling strategies to achieve clients highest impact with lowest cost while insuring PDMA compliance.

Prepare SRS to validate the client source data to Target system. Practitioner Validation to support PDMA compliance. Responsible for data analysis and mapping of external source data to the internal target system. Responsible for analyzing the Internal and external source data with the reference data for creating the staging data Use of TOAD to run the SQL queries for data validation Interact with the systems for testing and report generation

Independent BlueCross, Philadelphia May 2013 - Feb 201 Affordable Health CareBusiness Analyst

The purpose of the Affordable Health Care Act is to assure that all Americans have access to affordable Health insurance. Prepare the BRD for HIPAA transactions, 834 and 837 for on exchange and off exchange enrollments file from IBC exchange gateway to EDI platform that routed to AEDW. Prepare the Business System Requirement Document with use cases for Health Care Reform Billing System. Used data analysis techniques to validate business rules and identify low quality missing data in the existing enterprise data warehouse (EDW) to populate the internal DB tables. Prepare the Interface Control Document (ICD). The purpose of this document is to Gather the data elements (Field Types, Field Length etc) of the existing systems Analyze the data elements of each source and destination of all the systems Analyze the data redundancy to crate the data dictionary.

Lincoln Financial Group , Philadelphia Sep 2012 - Mar 2013Business Analyst

Unified Account Opening system (UAO) is to provide a common solution for advisors to initiate, track, and gain approval for new accounts across multiple channels.Products include Life, Term, Annuities and Disability Project initiate and prepare BRD, SSD, Use Case details, Use Case Diagrams, Activity Diagrams, Process Diagrams of Unified Account Opening system. Data mapping of different source data, reference data for migration to a new system.

Wealth Management Systems, NY May 2010 - Aug 2012 Business Analyst

Wealth Management Systems Inc. (WMSI) is the leading provider of rollover products and services in the financial services industry major clients: LPL Financial, Merrill Wealth Management, Pershing, Franklin Templeton, and Fidelity

The Rollover Desk Portal is designed to be used by client call center to support participant services and facilitate IRA rollover transactions. The rollover desk portal will provide call center representatives the ability to review complete participant data, refer rollover request to specific plan and Wealth Management Advisors. Gather information to prepare the rollover desk portal, advisor portal and advisor call center application for a new IRA and existing IRA. The primary information required for IRA rollover Prepare the Business Requirement Documents (BRDs), Functional Requirement Specifications (FRS) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype, Use Cases, Flow diagrams for overall system Prepare the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge for the User

JP Morgan Chase, NY Sep 2008 Dec 2009 Global Credit Risk ManagementBusiness Analyst

Project initiation, documentation of Data Acquisition and Control components of Credit Infrastructure Transformation program initiated by Global Credit Risk Management. Worked with internal architects and, assisting in the development of current and target state enterprise data architectures Worked with project team representatives to ensure that logical and physical data models developed in line with corporate standards and guidelines. Involved in defining the source to target data mappings, business rules and data definitions. Responsible for defining the key identifiers for each mapping/interface. Responsible for defining the functional requirement documents for each source to target interface Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team. Reverse engineered all the Source Database's using Erwin. Extensively used SQL queries to generate the reports. Documented data quality and traceability documents for each source interface. Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions. Worked closely with development team to prepare the statement like: collateral, credit limits, Credit Risk and Basel II

Application Development

Johnson & Johnson, NJ Data model and data migration of taxonomy data from different databases to a single database Erwin Data Modeling and Sybase

Credit Suisse First Boston, NY Global Price Testing, Dividend Received Deductions and Y2K Erwin Data Modeling, PowerBuilder and Sybase

New York Life Insurance, NY- Fixed Income Research Management, Fixed Income Compliance reports, Foreign Holding report Erwin Data Modeling, PowerBuilder and Sybase

Prudential Health Care, NJ Performance Management Workstation to design dimension data model PowerBuilder and Sybase

JP Morgan Chase, NY and DE Parallel Reporting Information system, Transaction Management System, Money Transfer Module via SWIFT messages, ADR via SWIFT messages, TRIPARTY and collateral services PowerBuilder and SybaseFinish Paper Mills Association, Helsinki, Finland Build worldwide network and renew all new applications to support international marketing and delivery of paper and paper products VAX/XMS with ADABAS/Natural

Education: Bachelor of Science from Andhra University, India Post Graduate diploma in Computer Science, India

Vyne Uppuluri Page: 4/4