vinod meena
67
reputation
6
- 5+ years of experience in BI development, data warehouse designing and maintenance with industry standards. Worked in verticals such as Healthcare, Telecom, FMCG, manufacturing etc.
- Proven knowledge and experience with all aspects of data management like data modelling, data transferring, data analysis, and data reporting.
- Expertise in building ETL Packages and automation for various business processes.
- Specialized in creating several reports like drill down, drill through, linked and sub reports using SSRS.
- Experience in High Level Design of ETL packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Flat File, Oracle) by using multiple transformations.
- Experience in implementing data warehouse, data mart and reports solutions.
- Experience of working with huge databases in Teradata (size>1B rows).
- Hands on experience in Data Modelling using SAP Hana.
- Experience in T-SQL to write: stored procedures, functions, tables, views, indexes and relational database models.
- Experience in tuning T-SQL queries to improve database performance using tools like SQL Profiler, Query Analyser and Execution plan.
- Knowledge of Data warehousing, Operational Data Store (ODS), Dimensional Data Modelling, Star Schema Modelling, Snow-Flake Modelling, Lookup, Dimensions and FACT Tables.
- Experience in RDBMS Designing, Normalization and building Referential Integrity Constraints. Built tables, FKs, PKs, etc. by providing a structure that meets the business needs.