KEERTI MURUGAN

Boston, MA adm34o@r.postjobfree.com 339-***-**** LinkedIn

TECHNICAL SKILLS

Database: SQL Server, MySQL, Oracle SQL Developer, MongoDb, Azure Cosmos DB (Cassandra, Gremlin API) ETL and Visualization: Tableau, Power BI, SSIS, Talend, SAP BW, Advanced MS Excel Programming Languages: Python, SQL, PL/SQL, R

Cloud Technologies: Microsoft Azure (Azure Data Factory, Azure DevOps), AWS (Athena, RDS, S3, Glue) Big Data Technologies: Hadoop MapReduce, Hive, Pig Tools and Utilities: Power Automate, Azure Logic App, Git, JIRA, Confluence, Microsoft Office Suite EDUCATION

Master of Science in Information Systems (GPA: 3.7) Northeastern University, Boston Expected Aug 2021 Relevant Courses: Data Warehouse and Business Intelligence, Data Science, Advanced Data Science and Architecture, Data Management & Database Design, Advanced Database Management System, Big Data Systems Bachelor of Engineering in Computer Science University of Mumbai, India Aug 2017 PROFESSIONAL EXPERIENCE

Retail Business Services, Quincy, MA Jan 2021 – Present Business Intelligence Developer

• Automated code review/audit using Python scripts to reduce developer efforts and enforce best practices on Azure Data Factory

• Visualized Azure Cost Consumption in Power BI to help management identify & optimize resources to reduce costs

• Configured CI/CD pipelines on Azure DevOps to automate the build and deployment of code from Dev/QA to Production

• Implemented migration of Azure Data Factory pipelines across environments to improve performance using CI/CD Northeastern University, Boston, MA May 2020 – Jan 2021 Data and Operations Analyst

• Elicited and documented requirements for the “College Dashboard Project” which reduced manual work for investigation by 80%

• Developed a data model to stage and load data into a robust and scalable relational database

• Analyzed complex business requirements and identified the technical requirements for designing reports in Power BI

• Improved the operational efficiency and robustness of the reports by using complex DAX queries and Row Level Security

• Created interactive dashboards to measure and communicate the compliance of various KPI metrics to the Senior Management and key stakeholders to help track the impact of COVID on current semesters Capgemini, Mumbai, India

Business Intelligence Analyst Jul 2017 – Aug 2019

• Developed reporting solutions by identifying large source datasets and implemented ETL pipelines in SAP BW

• Collaborated with the cross functional teams to perform root cause analysis for adhoc requests from stakeholders

• Built Process Chain workflows for data validation and monitoring daily master/transactional data loads

• Designed interactive dashboards in Power BI for internal task tracking, lowering overall resource time by 30%

• Provided comprehensive support to all end users and stakeholders through knowledge transfer and documentation

• Experienced in Scrum Agile Methodology (Daily Scrum Meeting, Managing Sprint Backlog) ACADEMIC PROJECTS

Banking Data Warehouse Talend, MS SQL Server, Power BI Feb 2020 – Mar 2020

• Designed a Star-Schema dimensional model in Toad Data Modeler using fact and dimension table after analyzing the data

• Migrated and Staged 5 Gb data to Talend Data Integrator and built end to end ETL pipelines with data cleaning and pre-processing

• Performed error handling and created ETL jobs to ensure one click load to the entire data warehouse through a master job

• Visualized KPIs on Power BI to help track the Revenue, Customer Retention and identify risk factors and areas of improvement Citibike Trips Big Data Analysis MapReduce, Hive, Pig, MongoDB Nov 2020 – Dec 2020

• Performed Secondary Sorting, Filtering and Summarization Patterns using Hadoop MapReduce Jobs

• Measured KPIs like most popular trips, average trip duration, bike ride distribution analysis using Hive Queries and Pig Healthcare NoSQL Data Analysis MongoDB, Mongo Charts Oct 2020 – Dec 2020

• Engineered and implemented a document-based NoSQL data model in MongoDb using Embedding and Referencing

• Measured interesting KPIs like Hospital Availability, Treatment Costs, Mortality Rates using MongoDB Aggregation Pipelines and MapReduce functions on Mongo Shell

• Created dashboards to visualize the KPIs using interactive dashboards in MongoCharts using data imported in MongoDB Atlas Fantasy Football Premier League Database SSMS, Tableau Oct 2019 – Nov 2019

• Developed database design by drafting ERD model of 15 entities to 3NF and implemented it in SQL Server

• Maintained Audit tables to keep track of changing dimensions using triggers and merge queries and scheduled data pipeline jobs

• Improved performance and execution time by using User defined functions, stored procedures, views and indexes

• Developed interactive dashboards to track player performance, fixture stats to help users make player selection strategies