Santaram Padaval

Over 15+ years of experience in information technology with expertise in ETL, Database Design and Development. Having Extensive experience in database modeling, performance tuning and Query Optimization and data migration. Also, I have expertise in data warehouse development, BI solution and EDWM architect. Forward-thinking Business Data Analyst with extensive experience evaluating operational processes, systems. Strengths include identifying and documenting opportunities for innovation, designing automated solutions and implementing efficiencies. Have knowledge on various business domains like Finance, Insurance and repair/service center. Have knowledge on various business domains like Finance, Insurance and repair/service center. - Experience in design, data modeling and ETL in large scale data warehouse and reporting environments from beginning to rolling out DWH/BI solutions to end users. - Strong knowledge of a scripting language (Python, Unix Shell) - Strong Communication & Management skills with Excellent Role playing capabilities. - Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert. - Experience in BI Development and Deployment of SSIS and SSRS. - Experience in developing Strategies for Extraction, Transformation and Loading (ETL) mechanism using Informatica Power Center. - Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, - Excellent problem-solving and analytical skills used in business and requirements analysis for financial, manufacturing and commercial companies. - Managing, leading the project team and Coordinate with internal and external teams (on site/offshore) - Participating and leading client engagement in developing plans and strategies of data management processes and IT programs for the clients, providing hands on assistance in data modeling, technical implementation of vendor products and practices - Data warehouse/Business Intelligence practitioner with full DWH/BI stack experience from analyzing requirements to implementing solution. Experience includes analyzing business; developing enterprise data models at the conceptual, logical, and physical levels; designing data warehouses, and data marts