Avinash N.

WORK HISTORY

EDUCATION

SKILLS

ABOUT AVINASH N.

Senior Business Intelligence Consultant with over 11 years of experienced knowledge in the life cycle of Enterprise BI application development beginning from data acquisition and data preparation techniques to data presentation methods.Skilled knowledge on Data Warehousing and Database performing ETL process and BI Reporting utilizing DataStage, Cognos, WebFOCUS, Tableau.Experience in BI Application Development and Self-service applications for enterprise wide implementation using different BI tools and technologies.Experience in preparing metadata in order to enable self service capabilities.Experience with creation of Security groups with pre-defined user privileges.Experience with Report Scheduling and Report Bursting for enterprise Push reporting needs.Strong understanding of the principles of Data Warehousing using fact tables, dimension tables and star/snowflake schema modeling.Experience with ETL processes using IBM Data Stage for building Data Repositories.Developed parallel jobs using different processing stages like Transformer, Aggregator, Lookup, Join, Sort, Copy, Merge, Funnel, CDC, Change Apply and Filter in DataStage.Implemented data security, object Security, and package Security in framework Manager.Designed and developed Transformer models in IBM Cognos Transformer.Experience in relational databases with writing SQL queries in MS SQL Server and Oracle.Working knowledge in Oracle PL/SQL i.e, stored procedures, functions, cursors and triggers.Swiftly adapt and learn innovative technologies and proficiency.Efficiently managed time across multiple tasks and priorities.