vyne uppuluri ba
Post on 21-Feb-2017
Data & Analytics
Embed Size (px)
Vyne Uppuluri 4 Gardenia ct Business Analyst Dayton, NJ 08810
Tel: 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
Vyne Uppuluri Page: 1/4
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 ENOVIA’s
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 client’s 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
Vyne Uppuluri Page: 2/4
o Gather the data elements (Field Types, Field Length etc) of the existing systemso Analyze the data elements of each source and destination of all the systemso 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 (BRD’s), 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.
Vyne Uppuluri Page: 3/4
Worked closely with development team to prepare the statement like: collateral, credit limits, Credit Risk and Basel II
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