Pratik Ravani

•IT experience in ETL Architecture, Development, Enhancement, Maintenance, Production support, Data Modeling, Reporting including Business requirement, system requirement gathering of Enterprise Data warehouses •Extremely motivated, able to work smoothly even under pressure, meet deadlines in advance, ready to accept new challenges and adapt quickly to new technologies. •Excellent technical, communication and interpersonal skills with very good troubleshooting and problem solving skills. Ability to work on multiple tasks in a fast paced environment independently and in a team. •Excellent overall software Development life cycle (SDLC) experience, Conceptual and Logical Thinking, Goal oriented, self-motivated and able to work independently and as a member of a team. •Participated in full software development life cycle using agile methodologies. •Proficient in understanding business processes/requirements and translating them into technical requirements. •Strong in Data warehousing concepts, dimensional Star Schema and Snowflake Schema methodologies, fact and dimension tables and Dimensional modeling, OLAP and OLTP process. •Involved in architecture decisions for ETL and BI Development. •Developed mappings, transformations and workflows for Extract Transform & Load (ETL) processes using SSIS and tuned them for optimized performance. •Architect a custom developed application for Error logging, error handling and quality assurance for the ETL process. •Implemented error handling and roll back process in ETL load. •Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages. •Experience in managing various SSIS Package Configurations in the form of XML Files. •Developed, Deployed and supported complex SSIS Packages for Data Migration and Transferring Oracle/Access/Excel Sheets using SQL Server SSIS. •Proficient in writing SQL scripts for Data Manipulative Language, Data quality Complex Stored Procedures, user defined functions and Indexes.