Mounika Devi K
Austin,TX
Summary
5 Years of IT experience involving project development, implementation, deployment and maintenance using bigdata Hadoop Ecosystem and Cloud related technologies in various sectors with multiprogramming language expertise like Scala, Spark. Worked on Azure data factory (ADF) and Azure SQL Server, Azure Data Lake Store, Azure Blob Storage Account. Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing. Worked on complex transformations by using Pyspark in Azure data bricks. Worked on minor transformations by using different activities available in Azure data factory. Created Azure data factory Pipelines to pull data from Blob Storage account to Azure SQL Data warehouse, Azure SQL Data base and Azure Data Lake storage as a full/Incremental load based on frequency at which the data arrives in to corresponding tables/folders. Experience in working with SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle/ Sybase databases.
Overview
5
5
years of professional experience
Work History
Azure Data Engineer
Anthem Inc
10.2023 - Current
- Extracted data from various sources like Oracle, Manual files, Blob Storage
- Created tables on top of the data using Azure Data bricks
- Performed basic transformation and joins on the temporary table data
- Created the Pipelines on premises DB2 database to Azure SQL Server using Azure Data Factory (Using Copy Activity)
- Crated Notifications and Alters in Azure
- Created SQL queries and performance tuning
- Developed data pipeline using Data Factory to ingest the data from Source Systems to Azure Data Lake Gen1
- Loaded the data from SQL server to synapse by using azure data factory and data bricks
- Developed the Spark-SQL Scripts in Databricks and running those notebooks in Pipelines
- Developed Apache Spark Applications by using python and Implemented Apache Spark data processing project to handle data from various Data Lake
- Created azure data workflows to ingest the data from various sources to Azure
- Used sparkSQL for reading data from external sources and processes the data using Python computation framework
- Created and deployed Reports and Dashboards in Power BI web services
- Environment: Azure Data factory, Azure Databricks, Azure Data Lake, Pyspark, Spark SQL, MS-SQL, Synapse
Data Engineer
Checks Info Soft
02.2021 - 11.2022
- Worked as a Data Engineer to review business requirement and compose source to target data mapping documents
- Responsible for data warehousing, data modeling, data governance, standards, methodologies, guidelines, and techniques
- Participated in JAD session with business users, sponsors, and subject matter experts to understand the business requirement document
- Worked with DBAs to create a best fit physical data model from the logical data model
- Translated business requirements into detailed, production-level technical specifications, new features, and created conceptual modeling
- Created 3NF business area data modeling with de-normalized physical implementation data and information requirements analysis using Erwin tool
- Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP and DW)
- Developed Star and Snowflake schemas based dimensional model to develop the data warehouse
- Generate the DDL of the target data model and attached it to the Jira to be deployed in different Environments
- Created reports from several discovered patterns using Microsoft excel to analyze pertinent data by pivoting
- Worked on AWS Redshift and RDS for implementing models and data on RDS and Redshift
- Applied Data Governance rules (primary qualifier, class words and valid abbreviation in Table name and Column names)
- Environment: Apache Hive 2.1, HDFS, Sqoop 1.4, HBase 1.2 OLTP, Jira, Teradata r14, SQL, Azure, MS Visio, DB2, PL/SQL, T-SQL, SAS, SQL Server, MS Access, MySQL, Crystal Reports
Data Analyst/Data Modeler
Mold Tek Technologies
02.2020 - 01.2021
- Interacted with cross-functional teams to facilitate Gathering of business requirements
- Identified business requirements and translated it to functional specifications
- Identified gap and conducted gap analysis between current system and new system
- Captured the key performance indicators and metrics that help stakeholders to observe the performance of the existing business system
- Performed Data Profiling, Data cleaning, Data Integration, transformation, Data Mapping, data modeling, and extracted and loaded data to the final destination from multiple data source systems
- Created data models such as Logical and Physical data models
- Created tables, constrain, views, CTEs, Stored Procedures, User-Defined Functions, Join, Indexes, recursive CTE, Pivot, unpivot, and other T-SQL Scripts
- Created various dynamic reports using SSRS and Crystal Report
- Created Packages in SSIS (ETL) to extract, transform and load data from different sources to the destination
- Environment: Windows 2008, Waterfall, Agile Scrum, SQL, T-SQL, Microsoft SQL Server 20028R2/2012, MS Access, Oracle 10g, MS Excel, MS Office, SSIS, SSAS, Microsoft Visual Studio, SQL Server Data Tools(SSDT), SQL Server Management Studio(SSMS), Crystal Reports, SSRS
Education
Master’s - Information Technology Management
Campbellsville University
Kent, OH08.2024
Bachelor’s - Computer Science And Engineering
Vignan University
India05.2022
Skills
- Azure Data Factory
- Azure Data bricks
- Azure Date Lake
- Oracle
- SQL-Server
- Python
- SQL
- Shell Scripting
- UNIX/Linux
- Windows
- Mac OS
- Power BI
- GIT
- SSIS
Timeline
Azure Data Engineer
Anthem Inc
10.2023 - Current
Data Engineer
Checks Info Soft
02.2021 - 11.2022
Data Analyst/Data Modeler
Mold Tek Technologies
02.2020 - 01.2021
Master’s - Information Technology Management
Campbellsville University
Bachelor’s - Computer Science And Engineering
Vignan University
Similar Profiles
Kim LavigneKim Lavigne
Broker Service Representative at Anthem IncBroker Service Representative at Anthem Inc
Amee WildeyAmee Wildey
Director II/Staff Vice President at Anthem IncDirector II/Staff Vice President at Anthem Inc
Sophia StewartSophia Stewart
Performance Quality Auditor at Anthem IncPerformance Quality Auditor at Anthem Inc