Project Manager
CurrentProject Management:• Increased billing for L&T Infotech by 30% by improving delivery performance and resulting in improvement of Customer Satisfaction Survey (CSS) index from 3.8 to 4.4• Implemented cloud based Workday Payroll application for one of the largest media group in US• Led team to develop L&T InfoTech’s home-grown data profiling tool ADAPT++ (Automated Data Analysis and Profiling Tool) for reducing time required for data analysis and profiling• Created Star/Snowflake… Show more Project Management:• Increased billing for L&T Infotech by 30% by improving delivery performance and resulting in improvement of Customer Satisfaction Survey (CSS) index from 3.8 to 4.4• Implemented cloud based Workday Payroll application for one of the largest media group in US• Led team to develop L&T InfoTech’s home-grown data profiling tool ADAPT++ (Automated Data Analysis and Profiling Tool) for reducing time required for data analysis and profiling• Created Star/Snowflake Dimensional or Normalized (3rd NF) Entity Relational Data Models and designed data flow from source systems to staging tables and then to the target system• Used progressive data modeling concepts such as Family of Stars, Confirmed Dimensions and Bus Matrix to handle complex situations• Translated the business requirements into working logical model by identifying the gaps and communicating the needs to the development team Data Modeling:• Adapted to the incremental data processing method to load data into warehouse thus reducing the processing time by 75%• Designed data flow from source systems to staging tables and then to the Target system by developing logical and physical data model • Created and maintained a Logical Data Model (LDM) and a Physical Data Model (PDM) for the project including documentation of all entities, attributes, primary and foreign key structures, permissible values, codes, business rules and glossary terms• Handled complex situations using progressive data modeling concepts such as Family of Stars, Confirmed Dimensions and Bus Matrix • Designed the database and created table as well as column level constraints using the suggested naming conventions for constraint keys• Supported and captured data after demonetization for creating a massive impact countrywide from over 15K reporting entities via more than 60K XML files• Improved the performance batch and response time of data for users by optimizing and tuning views and SQLs Show less