Hareesh P Email & Phone Number

Fort Worth, Texas, United States

Responsibilities:• Analyze, design, and construct modern data solutions utilizing Azure PaaS services to facilitate data visualization. Comprehend the current production status of the application and assess the impact of new implementations on existing business processes.• Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL, and U-SQL Azure Data Lake Analytics. Data Ingestion to one or more Azure Services- (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in Azure Databricks.• Collaborate with data architect/engineers to establish data governance/cataloging for MDM/ security (key vault, network security schema level & row level), resource groups, integration runtime setting, integration patterns, and aggregated functions for data bricks development.• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool, and backward.• Developed Spark applications using PySpark and Spark-SQL for data extraction, transformation, and aggregation from multiple file formats for analyzing & transforming the data to uncover insights into customer usage patterns.• Expertise in Creating, Debugging, Scheduling, and Monitoring jobs using Airflow and Oozie.• Created data bricks notebooks using Python (PySpark), Scala, and Spark SQL for transforming the data that is stored in Azure Data Lake stored Gen2 from Raw to Stage and Curated zones.• Built numerous technology demonstrators using Confidential Edison Arduino shield using Azure EventHub and Stream Analytics, integrated with Power BI and Azure ML to demonstrate the capabilities of Azure Stream Analytics.• Developed JSON Scripts for deploying the Pipeline in Azure Data Factory (ADF) that processes the data using the SQL Activity.poses.

Richfield, Minnesota, United States

Responsibilities:• Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL.• Architect & implement medium to large-scale BI solutions on Azure using Azure Data Platform services (Azure Data Lake, Data Factory, Data Lake Analytics, Stream Analytics, Azure SQL DW, HDInsight/Databricks, NoSQL DB).• Design & implement migration strategies for traditional systems on Azure (Lift and shift/Azure Migrate, other third-party tools.• Engage with business users to gather requirements, design visualizations and provide training to use self-service BI tools.• Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure, etc.• Propose architectures considering cost/spend in Azure and develop recommendations to right-size data infrastructure.• Created Airflow Scheduling scripts in Python• Develop conceptual solutions & create proof-of-concepts to demonstrate the viability of solutions.• Technically guide projects through to completion within target timeframes.• Collaborate with application architects and DevOps.• Identify and implement best practices, tools, and standards.• Design Setup maintains the Administrator of the Azure SQL Database, Azure Analysis Service, Azure SQL Data warehouse, Azure Data Factory, and Azure SQL Data warehouse.• Build Complex distributed systems involving huge amounts of data handling, collecting metrics building data pipeline, and Analytics.

Richmond, Virginia, United States

Responsibilities:• Used Business Objects to create reports based on SQL queries. Generated executive dashboard reports with the latest company financial data by business unit and by-product.• Implemented Teradata RDBMS analysis with Business Objects to develop reports, interactive drill Charts, balanced scorecards, and dynamic Dashboards. Convert into different Data formats for user/business requirements by streaming data pipeline from various sources Snowflake and unstructured data, Dynamo-db.• Responsible for requirements gathering, status reporting, creating various metrics, and project Deliverables.• Responsible for estimating the cluster size, and monitoring and troubleshooting the Hadoop cluster.• Responsible for managing the MongoDB environment with high availability, performance, and scalability Perspectives.• Replaced the existing Map Reduce programs and Hive Queries into Spark application using Scala.• Developed NoSQL database by using CRUD, Indexing, Replication, and Sharing in MongoDB.• Involved in analyzing and adding new features of Oracle 10g like DBMS SHEDULER creating a directory, Data pump, and CONNECT BY ROOT in existing Oracle 9i application.• Building ETL data pipeline on Hadoop/Teradata using Hadoop/Pig/Hive/UDFs• Extensively used Erwin for data modeling and Dimensional Data Modelling by ERWIN.• Used EXPLAIN PLAN, and TKPROF to tune SQL queries.• Developed BO full client Reports, Web intelligence reports in 6.5 and XI R2, and universes with context and loops.• Set up full CI/CD pipelines so that each commits a developer makes will go through the standard process of the software lifecycle and get tested well enough before it can make it to production.• Created HBase tables to load large sets of structured, semi-structured, and unstructured data coming from UNIX, NoSQL, and a variety of portfolios.