• Over 9+ years of experience in IT Industry with experience in Data Warehousing/Business Intelligence, requirement gathering, system analysis, and data Modelling, development and testing for any web based applications in Financial, Retail and Health Care Domains.
• Experienced in creating visualizations, dashboards and reporting solution using BI applications like Cognos Analytics and Tableau software and SQL Queries.
• IBM Certified Cognos Modeler and Developer with extensive experience in Cognos Analytics, Cognos 10 BI modeling, Report Studio (Active Reports), Metric Studio and Analysis Studio, Transformer. Hands on Experience in Cognos Analytics (Cognos Version 11)
• Knowledgeable in BI reporting tools such as Qlikview, Microstrategy, Business objects, Cognos Transformer Power cubes, Cognos 10 dynamic Cube Design and Roambi Analytics.
• Excellent Knowledge in OLAP, ETL, Data Marts, Data Warehousing Concepts (Facts, Dimensions, Star schema, Snow flake schema, concepts etc. and RDBMS SQL, Meta Data Modelling etc.
• Good understanding of PL/SQL concepts, procedures, functions, cursors, triggers, DB links and other database objects
• Experienced in Splunk queries.
• Experience in writing use cases and Business specification documents. Collaboration with Cross functional teams. Schedule and drive the client/ business meeting.
• Involved in Performance tuning while working with large data sets. Create job aids for applications.
• Skilled in Excel VLOOKUP, formula development