Prateek Shakyawal

Experience

1. Senior Project Manager

   Cardinal Health

   Jun 2015 — Present · US

   Successful in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) using Rational Rose & MS Visio. Documented and maintained RTM to ensure that all requirements are traceable from top to bottom and to provide a basis for the test plan. Expertise in using Rational tools for creating use cases, version control, and defect tracking and monitoring and used the Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC). Ability to gather business and Technical Requirements from both formal and informal sessions utilizing a variety of software methodologies including, Use Cases and the Rational Unified Process. Created Requirements Traceability Matrix (RTM) mapping Requirement to Design Artifacts to UAT Cases. Experience in designing and presenting UML (Use Case Diagrams, Data Flow Diagrams, Sequence Diagrams, and Activity Diagrams), visualization of web pages in the form of mock-ups and wireframe using MS Visio. Expertise in T-SQL in creating and using Views, User Defined Functions, Indexes, Stored procedures involving joins, sub-queries from multiple tables and established relationships between the tables using primary and foreign key constraints. Well versed in writing SQL queries or scripts for data analysis and writing test strategies, test plans, test cases, defect reports and developing test scripts, traceability matrices and test environments. Expertise in using Microsoft Visual Studio Team System for requirement management and work item tracking. Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Business Process Analysis, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling.