Security Clearance Data Warehousing

Kalyan (KAL) Moharar

U.S. CITIZEN

Email ID: ********@*****.***

Approved U.S. Department of Defense (DOD) TOP SECRET Security Clearance and

Approved Full-Scope Polygraph

SUMMARY

Over 33 years of industry experience – Enterprise level software Architecture design and development, integration and implementation of full life cycle development in Sales force and SQL/data Modeling, Crystal Reports, Tableau and Power BI. Experience in various cloud environments: AWS EC2, S3, RDS, Lambda, MS Azure, MySQL, SQL Server, Oracle, PostgreSQL, No SQL like Mongo DB and ETL Tools like Stream sets, Informatica, Azure data Fabrics, Data bricks and exposure to IBM Cloud Pak.

Expertise in designing modern cloud and hybrid solutions using Big Data Technologies like Databricks/ Spark and Hadoop Ecosystem that runs on Microsoft Azure, including network, storage, monitoring and security.

Expertise in AWS services like EC2, S3, Lambda, RDS, Cloud Front, Cloud Formation, Cloud Watch, etc.

Hands on experience on Unified Data Analysis with Databricks Workspace User interface, Managing Databricks Notebooks, Delta Lake with Python, Delta Lake with Spark SQL.

Good understanding of Spark Architecture with Databricks, Structured Streaming. Setting up AWS and Microsoft Azure with Databricks, Databricks Workspace for business Analytics, and Manage Clusters in Databricks and data factory.

I have extensive experience as a Data Architect in data warehousing, ETL processing, master data, SQL, Business Intelligence, Erwin, ER Studio, Oracle Designer, Stream Sets, Kafka, Scala and various other ETL tools and various DevOps.

Hands on experience in Data extraction (extract, Schemas, corrupt record handling and parallelized code), transformations and loads (user defined functions, join optimizations) and Production (optimize and automate extract, transform and load)

History of delivering data strategy implementations that are high in performance and throughput, emphasize data availability, and are cost efficient and scalable.

Experience with Agile toolsets, such as JIRA and Confluence for maintaining Project management, log and keep tracking software bugs and tracking the user stories.

Over 29 years of experience in ERP projects - Healthcare, Financial, payroll and CRM systems design, implementation, management; An experienced data warehouse consultant with 15 years of experience in multiple roles such as ETL developer, Data Modeler Data Warehouse Consultant and Programmer/Application Analyst.

Key strengths include:

AWS S3 Bucket design

Azure Data Factory

Python for Data Science

SQL and Data Analysis

Simplify Data analysis with Python

IBM Cloud Pak implementation

Manage Clusters Databricks

Data extraction and transformations and load (Databricks and Hadoop)

Linux Commands

EXPERIENCE

Consultant at Dept. of defense (Accenture Federal LLC) - 01/14/24 - Current

(Govt.) – 100% Remote

Sr. Database Architect

Responsibilities

Involved in developing various data warehousing projects, by designing and implementing a Server less architecture leveraging AWS Lambda and Amazon API Gateway, resulting in a Substantial reduction in infrastructure costs and a improvement in system scalability.

Optimized the performance of AWS services, including fine-tuning databases and managing Auto Scaling groups, resulting in a 30% improvement in system response time and a 20% increase in customer satisfaction.

Managed the deployment and troubleshooting of applications on AWS infrastructure, ensuring optimal performance and uptime, resulting in a 25% reduction in production issues and a 15% increase in revenue.

Experience in developing Spark applications using Spark-SQL in Databricks for data extraction, transformation, and aggregation from multiple file formats for Analyzing and transforming the data to uncover insights into customer usage patterns.

Extract Transform and Load data from source Systems to Azure Data Storage services Using a combination of Azure Data Factory, T-SQL, Spark SQL, and U-SQL Azure data Lakes Analytics, Data ingestion to one or multiple Azure services( Azure Data lakes, Azure Storage, Azure SQL, Azure DW) and processing the data in Azure Databricks

Consumed APIs while utilizing Python requests to read numerous JSON reports Designed and configured database and backend applications and programs

Environments: AWS, EC2, S3, and RDS- SQL-Server 2019, MS Azure Data Fabric, Data Bricks, PostgreSQL 16.1, AWS RedShift, Django, Python, SQL Alchemy, Flask, MySQL, JavaScript, Git, HTML, Machine Learning, Mongo DB, Pandas (Software) SQL Linux, NumPy, Web Scraping, AWS RedShift, Cogniti (Cloud).

Consultant at Center for Disease control and 11/2021 -2/2024

Prevention (CDC) – 100% Remote

Sr. Database Architect/Database Administration

Responsibilities

Heavily involved in development of Spark application using pyspark and Spark SQL for data extraction, transformation and aggregation from multiple file formats for analyzing and transforming the data uncover insight into the customer usage patterns

Hands-on experience on developing SQL Scripts for automation

Responsible for estimating the Cluster size, monitoring and troubleshooting of the Spark Databricks cluster

Ability to apply the Spark DataFrame API to complete Data manipulations with spark session

Exposure to Apache Spark, Apache Hadoop, Scala, AWS – good understanding of the Spark architecture including spark core, Spark SQL DataFrame, Spark streaming, Driver Node, worker Node, Stages, Executors and Tasks, deployments modes, the Execution hierarchy, fault tolerance, and collections

Experience with Agile toolsets, such as JIRA and Confluence for maintaining Project management, log and keep tracking software bugs and tracking the user stories.

Environments: AWS, EC2, S3, and RDS- SQL-Server 2019, MS Azure Data Fabrics,

Data Bricks, PostgreSQL 16.1, AWS RedShift, Django, Python, SQL Alchemy, Flask, MySQL, JavaScript, Git, Machine Learning, Mongo DB, Pandas (Software) SQL Linux, NumPy, Web Scraping, Cogniti

Consult at Office of Personal management 10/2019 – 08/2022

(Govt.) - Washington DC

Database Architect/Database Administration

Responsibilities

Involved in design, development, testing of processed Data into HDFS by developing solutions, analyzed the data using MapReduce

Import Data from various sources to support and reporting of Medical Insurance Processing includes Benefit Plan, Claims processing systems – like MYSQL into HDFS

Extensively involved in development of Table creation and transformed large amount of data (Big data platform), data warehousing, ETL processing, master data, SQL, Business Intelligence, Erwin, ER Studio, Oracle Designer, Stream Sets, Kafka, Scala and various other ETL tools and various DevOps.

Involved on loading and transforming large sets of structured, semi structured and unstructured data – extract, parsing, Cleansing and ingest data

Also, I worked on various Tableau reporting and Power BI Reporting as and when needed.

Experience with Agile toolsets, such as JIRA and Confluence for maintaining Project management, log and keep tracking software bugs and tracking the user stories.

Monitor System health & logs and respond accordingly to any warning or failure conditions

Managed and reviewed Hadoop log files

Involving in loading data from Unix files systems to HDFS

Environments: AWS, EC2, S3, and RDS- SQL-Server 2019, MS Azure Data Febric, Data Bricks, PostgreSQL 16.1, AWS Red Shift, Django, Python, SQL Alchemy, Flask, MySQL, JavaScript, Git, HTML, Machine Learning, Mongo DB, Pandas (Software) SQL Linux, NumPy, Web Scraping, Cogniti (Cloud), Tableau, Hadoop.

General Dynamics Inc. (GDIT Inc.) 10/2014 - 10/2019

Principal Database Developer/Engineer

Responsibilities

Primary responsibilities include design, development, testing, deployment, support and reporting of Center for Medicare/Medicaid system (CMS)

for the USA government Agency.

I was involved in developing data warehousing, ETL processing, master data, SQL, Business Intelligence, and DevOps. Extensively worked on developing Crystal Reports for the Healthcare system of US Government. Also, worked on various Tableau reporting and Power BI Reporting as and when needed.

Working extensively with RDMS databases like SQL SERVER 2016/2017, JavaScript framework, Oracle 11g and NO SQL databases like Redis, Mongo and Cloud Database Platforms.

Environment: Oracle 11g, SQL Server 2016/2017 Enterprise, .NET, Microsoft Visio, AWS, Big-data, Micro service Architecture, REST, and SQL/data Modeling, Azure cloud database environment, Team Foundation Server (TFS), No SQL database system MongoDB .

GODADDY.COM 10/2013 – 03/2015

ETL Architect

Responsibilities

Day to day Activities involved in development in Agile Methodology - as a FULL STACK Software Developer/Engineer in enterprise level software - Architecture design and development and integration and implementation of SOA/Micro service architecture.

Environment: Oracle 10g, Visual Studio 2010, C#, ASP, .NET, Crystal Reports

XI, SQL-Server 2012, SQL/Plus, Microsoft Reporting Services, SQL,Crystal reports, Visio, Mongo DB (NOSQL)

PRIOR EMPLOYMENT

Raytheon (Rockwell Collins Inc.) 05/06 - 10/13

IBM Inc. - Sr. Peoplesoft ERP Consultant 03/02 – 05/06

Accenture Inc, MD - Sr. Peoplesoft ERP Consultant 2001 – 2002

Aegon USA Inc., IA - Sr. EPR Engineer (Consultant) 2000 – 2001

TECHNICAL TRAINING

Training on SQL Server Analysis services, System Analysis & Design, C#, Avionics Fundamentals, Lab View, Oracle DB, SQL-Server, ERP development, Developer 2000, Designer 2000, Web Server, HTML, FORTRAN 77, UNIX, C++, C, ASP.NET

EDUCATION

Master’s degree in computer science – University of Calcutta

Master's degree in Electronics and Telecommunications – University of Calcutta

Bachelor’s degree in physics– University of Calcutta

Attended training on “Fundamental of Avionics” conducted by University of Kansas and Embry-Riddle Aeronautical University.

Current member of the “Toastmasters International” organization.

Contact this candidate