Summary
Overview
Work History
Education
Skills
Certification
System Experience
Training
Timeline
Generic

Antony Kanappilly

Clarksburg,MD

Summary

I have more than 16 years of expertise in Information Technologies, encompassing 14 years dedicated to Data Warehousing and 3 years in Data Analysis. I've managed multiple projects involving ETL processes, Data Migrations, and Visualization throughout the career. I'm proficient in tools like, SQL Server, PostGress, Power BI, Tableau, and SSRS for Data Visualization. Additionally, I hold certifications in Data Analysis, Microsoft Power BI, AWS Solution Architect, and Azure AI, with hands-on experience in both AWS and Azure environments.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Data Engineer

Deloitte
08.2023 - Current
  • Develops interactive Power BI dashboards, reports metrics, data sets and data flows using Microsoft Power BI to meet business requirements
  • Utilize advanced understanding of concepts, methodologies, and techniques within specialized domain of data science to offer technical proficiency in data quality functions and activities, aiding in design, development, and operational phases
  • Managing gathering, analysis, and organization of data while generating corresponding reports using Microsoft Power BI
  • Develop Federal IT systems analysis initiatives and solutions to critical issues
  • Lead technical endeavors in data collection and analysis, collaborating with fellow data scientists
  • Present findings and propose solutions to head of Data Science and Artificial Intelligence Application Branch
  • Development of new concepts, principles, standards, and methods, as well as appropriate application of commercial best practices in data management
  • Act as lead on all facets of data quality pertaining to data requirements
  • Interact with team on application of architecture modeling tool sets used to document, maintain, and enhance architectural planning process
  • Utilize Python and Azure tools such as Power BI, Tableau, and Azure Grafana to craft dynamic visualizations
  • Interpret model outputs to inform strategic decisions, emphasizing energy efficiency and operational enhancements
  • Facilitate effective communication of insights using Azure DevOps and Communication Services
  • Lead operational aspects of data protection, developing strategies for managing permissions, classifying data, controlling access, detecting threats, and conducting security analytics on a day-to-day basis
  • Enhance real-time data collection and processing systems using Python and Azure
  • Employ Azure Event Hubs, Data Lake Storage, and Databricks for efficient data flow, storage, automated cleaning, and scalable machine learning
  • Implement Azure DevOps and Infrastructure as Code for continuous improvement and robust data governance
  • Experienced in writing complex SQL queries to manipulate and extract data from Microsoft SQL server
  • Design, implement and manage integration between Power BI and Microsoft Azure data platform
  • Manage, improve and monitor cloud infrastructure on AWS EC2, S3, RDS.

DevOps Lead Analyst

Merkle Inc
12.2010 - 11.2022
  • Project was design for 20 MM individual operational marketing databases
  • There are 62 feeds were processed from various vendors for marketing purpose
  • Based on data loaded to warehouse, campaign will be run for Direct mail and email marketing purpose
  • This data warehouse used for campaigns, extraction and reporting purpose will handle million individuals and billions of transactions
  • Created various reports involving sub reports, Matrix/Tabular reports, charts and graphs using Power BI and SSRS
  • Reports were scheduled to be delivered by email and file
  • Create and maintain data connections and data refresh schedule to ensure up-to-date and reliable reporting
  • Design and implement efficient data models, ensuring data integrity, accuracy, and optimal performance for Power BI
  • Take charge or contribute to teams composed of subject matter experts and staff members dedicated to addressing particular data quality issues and tasks
  • Created and modified tables, views, stored procedures and functions for SQL server database as per client requirement
  • Conducting continuing evaluations of agency business needs to ensure that IT architecture plans are aligned with those needs and that current and planned IT infrastructure supports architecture plan
  • Experience analyzing and organizing data; using data to conduct analysis; managing multiple projects simultaneously; and creating reports using Power BI
  • Communicating complex technical requirements to non-technical personnel and preparing and presenting briefings to senior management officials on complex/controversial issues
  • Migrated database applications and platform to Cloud (AWS)environment.

SQL Developer

Merkle Inc
04.2007 - 11.2010
  • Interacted with Project Manager, Team Lead and Team Members in understanding business requirements
  • Participated actively in designing system database structure
  • Responsible for table creations, indexes and table references
  • Developed complex stored procedures, T-SQL functions, triggers and views using SQL Server Management Studio
  • Performed performance tuning of stored procedures using SQL Server Profiler
  • Developing solutions to integration/interoperability issues
  • Used MS SQL Server reporting services to created report, sub reports, graphs, matrix control for cross tab reports
  • Created and maintain Data Transformation Service (DTS) package for automation of periodic updates done to client’s databases.

QA/SQL Developer

Merkle Inc
01.2006 - 03.2007
  • Participated in analyzing user requirements and designing database structure
  • Transformed Conceptual Model to Physical Model that includes creation of Tables, Views, Triggers, Stored Procedures and maintained Referential Integrity in SQL Server 2000
  • Modified existing stored procedures, views and triggers to meet current design
  • Communicating complex technical requirements to non-technical personnel and preparing and presenting briefings to senior management
  • Created indexed views in T-SQL to increase query performance.

Education

Skills

Power BI, Azure , SQL Server , Data Analyst, ETL Development, Data Science, AWS, SQL Development

Certification

  • AWS Certified Solution Architect
  • Microsoft Power BI Data Analyst Associate
  • Microsoft Azure AI Fundamentals
  • Microsoft Azure Fundamentals

System Experience

AWS (EC2, Elastick Beanstalk, ELB, S3, CloudFront, SNS, IAM, Cloud Formation), VB.Net,SQL, TSQL, Python, Windows, Linux/Unix, MS SQL Server, Oracle, PostgresSQL, Power BI, SSRS, Crystal reports, Athena, GitHub, SVN, CVS, AWS CloudWatch, MS SQL server SSIS, Airflow, AWS Glue, Jenkins

Training

  • AWS Database Specialty
  • Snowflake – The complete master class
  • Master Langchain Build #15 AI Apps- OpenAI, LLAMA2, HuggingFace

Timeline

Data Engineer

Deloitte
08.2023 - Current

DevOps Lead Analyst

Merkle Inc
12.2010 - 11.2022

SQL Developer

Merkle Inc
04.2007 - 11.2010

QA/SQL Developer

Merkle Inc
01.2006 - 03.2007

Similar Profiles

CREATE PROFILE
Antony Kanappilly