Around 9 1/2 years of experience as a BI Developer for Data Analytics, Design and Implementation of Business Applications using Kimball Methodology and multiples BI tools like Tableau, SSAS, IBM Cognos 10/11, OBIEE, Google Data Studio, Artus.
• Experience in MS SQL Server 2018/2008 R2 with MSBI stack SSIS, SSAS, and SSRS. Expert in Business Intelligence solutions in Data warehousing / Decision Support Systems using ETL tools and worked on OLAP, OLTP and Data Warehouse Reports.
• Expertise in OLTP/OLAP System Study, Analysis, developing schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Involved in all phases of the Software Development Life Cycle (SDLC) from analysis, design, development, testing, implementation and maintenance with timely delivery, requirements gathering, functional gap analysis, module setup script generation testing and production support.
• Have Excellent Skills in Data Warehouse, Datamining, Relational and Multi-Dimensional databases, Data Migration, System & Data Integration, Reporting Analysis and Software Development and Data Management.
• Extensive experience with Database Backups, Recovery Procedures, Backup strategies and scheduling.
• Experience in working with ETL tools - Toad, Pentaho, Oracle Data Integrator, Datamanager, DataStage, Analytic Canvas, Microsoft SQL Server Integration Services interacting with different databases like - Relational Database Management System (RDBMS) like Microsoft SQL Server, Oracle 11g, MySQL, Pervasive SQL, DB2, MySQL.
• Experienced in Data loading using PL/SQL, SQL Server Integration Services packages (SSIS), developed dashboard reports using SQL Server reporting services (SSRS).
• Worked on Performance Tuning, Query Optimization, Client/Server Connectivity, and running Database
• Experience working with API Google Analytics and Google adWords, extracting data and loading in the Data Warehouse.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in Dimensional Modelling and Data Visualization using IBM Cognos, Tableau desktop, Data Studio and Artus designer.
• Hands on experience with Datamining, Drill-down, Drill-through and Cascading reports.
• Hands on experience with PowerShell Scripting automating multiple servers and jobs to deliver the data in a central server with SFTP for a Project of Financial Consolidation.
• Hands on experience with multiples statistical and visualization techniques like lineal regression, Multidimensional scaling (MDS), Data Mashup, Data presentation, Data Blending, etc
• Experience in creating reports by using Dashboards strategy Experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 10, 2018, 2019
• Experience working in Agile and Waterfall model working methodologies like Scrum.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and soft skills.
• Hands on experience working with Excel charts, Pivot tables, Look up formulas, etc.