Satish K

Datawarehouse Designer - 12 Years of Experience - Near 78704


Datawarehouse Designer


Austin, TX

Education Level:


Will Relocate:



SUMMARY * Satish Kumar is a seasoned Data Warehouse\Business Intelligence Architect\Data Modeler with 12+ years of experience in Data Modeling, Data Integration, Data Visualization, Data Profiling and Database Design. * Extensive experience in all facets of project life-cycle SDLC, & Agile-Scrum from feasibility analysis and conceptual design through implementation, including documentation, user training and operation support. * Build and managed the 5 members data analytics engineers' team, responsible for Database development, Integration development, Report development, Production Application Deployment and Operations Support. * Expertise in end-to-end data warehouses, Data Marts, ETL solution design to provide structured and timely access to large datasets. * Expertise in Project design, Estimation, Implementation, Upgrade, Migration, client-interaction, maintenance and team management. * Built and Implemented Data Warehouse application from scratch for multinational Currency using tools- Integration Services (SSIS), Analysis Services (SSAS), SAP BODS (Data Services), Informatica, SAP Business Objects, SAP Lumira, MicroStrategy, Cognos Report Suite. * Expertise in Business Objects Configuration, Administration, Universe Design (UDT & IDT), Reporting, Dashboard, Tomcat, CMS Repository, Lumira Stories. * * Built Integration packages (SSIS), SAP BODS & Informatica Power Center for data movement and ETL\ELT process to populate the data warehouse from various source systems. * Built and Implemented Database High Availability and DR Solution for companies like SwissRE, FPI Insurance * Proven Track records of multiple Upgrade\Migration\Development project for various Insurance clients - FPI, FBL, BAHAMAS & Dongbu, SwissRe Insurance * Continuous Skill update with new version of In-Memory Analytics tools like- Tableau, QlikSense, SiSense & Sap Lumira being part of Business Analytics - CoE team. * Experienced in Data Modeling tools like -Erwin, ER\Studio, & Oracle SQL Developer Data Modeler tools * Extensively used Performance Optimization best practices for making database healthy and provide optimal performance including table partitioning, Buffer Sizing, Threading and Indexing strategy. * Analysis of current data, legacy reports, Gathering the business requirement, discussing with Subject Matter Experts (SME's), Gap Analysis of Current requirement, future needs and builds the Logical\Physical Data Model for Enterprise Data Warehouse Application. * Building and Implemented the roadmap and strategy for short term goal and long term goal. * Build the Enterprise Data Warehouse (Stage, ODS & Data Mart) on SQL Server Database Server using Ralph & Kimball methodology. * Involved on Software evaluation Process on Application and Data Warehouse Tool selection and provide an executive recommendation to management. * Experienced Agile-Scrum Model that includes short term goals, iterative development and daily stand-up * Sound Knowledge of Insurance, Healthcare, Life Science, Telecom domains * Goal Oriented individual with 'get the things done' attitude * Partnered with Business to understand the challenges and pain points desired business outcomes and provides technical feasibility insight and solution options.