KAVYA SRUTHI N Email: [CONTACT] Contact: *** Summary of experience: Overall 7 years of IT experience in Analysis, Design, Development, Implementation and support Of RDBMS in Production, Development and Test environments using Oracle Tools in client server environments. Understanding of Business Requirement gathering, Business Process flow, Business Process Modeling, Database/Data warehouse and SQL Coding experience to support business solution and analyzing business operations. With a 7 years’ experience as Database Developer in different Relational databases like Oracle,PLSQL and SQL Server and also worked as BUSINESS ANALYST for couple of years. Comprehensive knowledge of Waterfall SDLC, AGILE methodology with Scrum. Good understanding of Software development life cycle (SDLC). Excellent Business writing skills in writing Business Requirements Document (BRD), Functional Requirement Specification (FRS) document, Technical Requirements Document (TRD), User Requirement Specifications (URS), Use Case specifications, functional specifications, systems design specifications, software requirements specifications (SRS). Extensively worked in developing ETL for supporting Data Extraction, transformations and loading using ETL tool Informatica Power Center and PDI( Pentaho Data Integration) using databases like Oracle, SQL Server. Good knowledge in database management system, data modeling, SQL and software engineering concepts. Excellent knowledge of Data modeling using Dimensional Data modeling, Star Join schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling. Highly proficient in database concepts like Data Warehousing, Schema,Data Marts,along with knowledge of Data Modelling, Data Table structures, mapping Schema, Data Marts and OLAP operations such as Roll-up, Drill-down, slice, dice. Design and database development experience with SQL, PL/SQL. Experience in working with oracle 9i/10g. Worked with version control tool tortoise SVN. Experience in using user-friendly tools like Putty, SQL developer and Toad. Gained knowledge in the field of Software Engineering involving Full Software Development Life Cycle (SDLC), Software Architecture. Has very good communication and analytical skills. Technical skills: Software Languages:SQL,PL/SQL ETL Tools:Informatica Power center 8.6, Pentaho Data Integration(Kettle Tool),Talend Databases:Oracle 11g/10g/9i, MS SQL Server 2005 Operating Systems:Windows 98/XP, UNIX, Linux Methodologies:SDLC,Water Fall,AGILE(SCRUM) GUI/ToolsMS Word, MS Excel Documentation ToolTortoise SVN, MS Office Suite (Word/Excel/Power Point) Others:TOAD, Tortoise SVN, putty Education: Master of Science (Information Technology *** BITS Pilani, RJ, India Work History United Health Group Nov 2014-Nov 2015 Role: Business Analyst Project Name: Core Assets (Health Care) Description United Health Group, Inc. engages in the provision of health care coverage, software, and data consultancy services. It operates through the following segments: United Health-care,Optum Health, OptumInsight, and OptumRx. The OptumHealth segment provides health services business serving the broad health care marketplace, including payers, care providers, employers, government, life sciences companies, and consumers. The OptumInsight segment focuses on data and analytics, technology, and information to help major parti...

See full