Experience

Intact

• Ireland
• Software Development
• 100 - 200 Employee

• SQL/Power BI Developer

  • Mar 2021 - Present

  -Installed and Configured SQL Server 2014 and Visual studio 2015. Wrote complex T-SQL queries and stored procedures. Using Visual Studio Premium 2013, JQuery and Sync fusion Controls for User Interface. - Developed simple to complex visualization reports using Tableau as well as DOMO. Developed MicroStrategy Documents involving various objects like Datasets, Metrics, Level Metrics, Filters, Prompts, Custom Groups and Consolidations. Worked on MDX queries while creating and customizing Cubes using SQL server Analysis Services (SSAS). - Creation of HANA Models (Attribute Views/Analytical Views/Calculation Views) - Expert with BigData toolset HDFS, MapReduce, Hive, beeline, Impala, Hue, and Spark. - Automate file transfer to AWS cloud by writing lambda functions in python, reducing the transfer time by 80%. - Imported data from SQL Server DB, Azure SQL DB to generate Power BI reports. - Involved in conversion of existing reports in Tableau and WebFocus to DOMO and DataStream. - Extensively participating in importing the data from Google Big Query for use in reporting software tools Power BI and Looker for providing graphs, and flowchartsDeveloper Oracle SQL scripts. - Implemented complex USQL queries in ADLA for the different stages of data movement. - Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into a data warehouse database. - Maintained Data warehouse, Created ETL Jobs, Created new database objects and SSIS Packages. Deployed and hosted Web Applications in Azure created Application Insights for monitoring the applications. Created SSIS packages as per the business requirements and moved data to different levels of databases. - Built Azure Analysis Service models in cloud pulling data from both On-prem (SQL) and Azure Data Lake Store (ADLS). Involved in designing of Data Marts and Data Warehouse by using star schema and snowflake schema. Show less



BDO

• Belgium
• Accounting
• 700 & Above Employee

• SQL Server/ BI Developer

  • Aug 2019 - Mar 2021

  - Involved into data analysis, design to fulfill the entire QRM requirement based on technical and functional understanding. Verify specialized and / or new reports for accuracy through the use of SAP Business Objects(BOXI) Web Intelligence (WEBI). - Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager. Back-end testing on Oracle SQL Developer. - Designed facts and dimension tables and defined relationship between facts and dimensions with Star Schema and Snowflake Schema in SSAS. - Secured the Cloudera Hadoop Cluster with Kerberos in Active Directory. Creating users, permissions and running jobs through MicroStrategy developer. Created different QA branches and deployed SSIS packages in QA. - Expert with BigData tools Hadoop, MapReduce, Pig, Hive, Impala, Spark, Python. - Wrote a lambda function in python to create monitors and trigger alarms for other lambda functions. - Migrated users from AD Domain Services to Azure AD using Microsoft Azure Active Directory Connect. In depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server. - Used to connect different data sources like SQL DB (SQL Query), Tabular Model (DAX Query), Web Trends to Power BI and generate reports with different visualizations. - Worked on the performance tuning of the data warehouse and modified the procedures and tables to enhance the performance of the data warehouse. - Using CSS files and Java script for MicroStrategy Plugins. Created SSIS Packages to migrate slowly changing dimensions. Scheduling the SSIS packages and Jobs. Design and develop dataset and dashboards from different data sources including SQL server, Excel and flat file using Tableau. Automated data warehouse build including AWS infrastructure and Matillion process flows. Preparing Dashboards using calculations, parameters in Tableau. Show less



Cisco

• United States
• Software Development
• 700 & Above Employee

• SQL/Data Analyst/ Power BI Developer

  • Aug 2018 - Aug 2019

  -Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share Dashboards. -Designing Logical and Physical Data Model with Erwin tools. -Created a variety of Reports as Drill-Down reports, ad-hoc reports, Tabular reports, and Matrix reports by using SSRS to increase efficiency and flexibility of Analytical Reports with using Power BI, Power view, Tableau, etc. -Executed payroll project from end to end starting from Requirements analysis phase followed by application architecture, designing, development, testing and post implementation support using IBM InfoSphere DataStage 8.5/8.1, Information Analyzer, UNIX and Oracle. - Design/develop the Data Warehousing/Business Intelligence application using Oracle SQL, PLSQL, Oracle Data Integrator (ODI), Datastage, OBIEE, Tableau. -Involved in the maintenance of the existing cubes of the data warehouse by adding additional dimensions, user-defined hierarchies and calculated members using SSAS and wrote MDX scripts while developing the reports from the cubes using SSRS. -Maintain records to gauge contracted agents’ performance, such as monitoring scores and schedule adherence, using MicroStrategy reports and MS office programs (Excel, Word, PowerPoint, OneNote, etc.) - Experience with SQL Data Warehouse, Azure Data Lakes, Azure Data Factory, HDInsight. - Responsible for performing all the validation and QA work against the EX and JICS system. -Created SSIS packages to populate data from various data sources like oracle using PL/SQL queries. -Migrated data from on-premises data servers onto Microsoft Azure cloud platform utilizing Azure data factory and experience with Data Lake. - Involved in data moving from SQL Server to GUIDEWIRE Claim Central using GUIDEWIRE Claim Central Commands. Show less