Harsh Mahatma Email & Phone Number

Melbourne, Fl, Us

San Mateo, Ca, Us

San Mateo, Ca, Us

Austin, Tx, Us

+ Designed next-gen customer data integration microservice architecture on AWS using resources like: API Gateway, S3, SNS, SQS, ECS and Fargate, Secrets Manager and PostgreSQL+ Spearheaded an effort to design and build self-service data warehouse architecture on AWS using technologies like AWS RDS PostgreSQL, Data Build Tool (DBT), PostgreSQL, AWS kinesis, S3, Sisense, and Metabase+ Saved 98% of time compare to previous solution by implementing an automation solution using Pentaho ETL, PostgreSQL, DBT, and Bash Scripting.+ Designed and developed end-to-end data pipeline for analyzing Jira data in data warehouse on AWS

Austin, Tx, Us

Melbourne, Florida, Us

+ Led the effort to establish Enterprise wide modern data platform on Azure and Snowflake to enable data sharing, eliminating data silos, increase collaboration between data community and to help drive business decisions by unlocking value from the data. + Led a project to deploy Snowflake data warehouse on Microsoft Azure Cloud and completed under budget by 20%. Some of the technologies used are: Azure Blob Storage, Python, Azure Data Factory, Snowflake, Tableau.+ Partnered and developed end-to-end engineering solution to capture 25M+ data points per day in AWS RDS PostgreSQL and Redshift data warehouse, supporting mission critical application.+ Led the management and development processes for efficiently processing 60+ TB of Geospatial (GIS) data supporting applications like: ESRI ArcGIS, QGIS, Geoserver and homegrown Python applications+ Led the efforts the put together Tableau Server and Tableau Desktop governance policies+ Designed internal process improvements by automating repetitive tasks and shortening data delivery times by 40%+ Implementing best practices in designing dimensional, relational and data vault data models for data warehouses and OLTP databases+ Identified as database/data subject matter expert (SME) to support multiple business units (BU) in developing scalable architecture, engineering best practices, administration, performance tuning, and automation using Python and Bash scripting languages

Melbourne, Florida, Us

Washington, District Of Columbia, Us

+ Played a key role in implementing end-to-end data pipeline (ELT) and solutions to expand the populations of clients served by the Crimson Care Management (CCM) part of The Advisory Board Company + Worked with customers in gathering, analyzing, and documenting business requirements, making it easier for creating clear and concise user stories+ Collaborate with cross-functional teams in implementing differentiating services and interfaces in the core healthcare product + Identified as Data/Database Subject Matter Expert (SME) to help internal teams in developing Logical/Physical data models using 3NF; also involved in building efficient SQL queries to improve web page rendering times

Deerfield Beach, Florida, Us

+ Responsible for eliciting, understanding, interpreting, and representing business requirements for data integration efforts with Legacy and third-party applications like: DB2 and Mainframe+ Identified as Subject Matter Expert (SME) on designing data models for capturing Metadata and developing common standards for growth and consistency+ Responsible for data profiling and ensuring governance around data quality to match JM Family standards+ Work with QA organization in developing test cases related to data integration and data quality+ Participate in data model reviews, architecture, and design solutions to ensure high quality deliverables for internal/external customers

Sunrise, Fl, Us

Sproutloud is a Marketing Resource Management company devoted to the local marketers of distributed marketing organizations and their respective channel programs. Sproutloud develop technology and service offerings designed to make their clients local marketers successful withintheir respective business communities by enabling integrated local marketing management.Responsibilities:Work closely with marketing professional to design mission critical marketing products that enable marketing professional to reach out and target millions of existing and past customerbase using our highly integrated Direct Mail/Email/Social/SMS technologies, Also works closely with developers/designers to develop mission critical database application using AGILE principles,+ Physical and Logical database modeling+ Load external data into data warehouse using ETL technology+ Database Development e.g Stored Procedures, Functions, Triggers, Indexes, etc ..+ Report Creation based on accounting needs+ Participate in project planning and discussion to gather requirements+ Impact analysis of new project in current database architecture+ Generate test cases in order to help QA and Developers+ Communicate with team on daily basis about outstanding issues and how we can resolve them+ Daily account support

Geostellar provides Earth intelligence for the new energy economy. Our big-data geomatics platform models renewable resource supply in the context of infrastructure, land use, economics and policy.Geostellar models the local availability of resources in high spatial and temporal resolution, then computes the proximity and capacity of infrastructure, regulations, land use and value, markets and economics to produce actionable, location-specific insights. Our Earth intelligence can be searched and shared, providing a foundation of hard data for decision-making throughout the energy industry continuum, from planning through development, to production and trading.Energy producers, utilities, public administrators, property owners and industry suppliers can search, view, analyze and share the most profitable and least risky opportunities to increase the generation of renewable power.Responsibilities:- Logical database modeling/physical database modeling- Develop Stored procedure/ functions/ triggers/ constraint/ views- Maintenance of the database

Sunrise, Fl, Us

Sproutloud is a Marketing Resource Management company devoted to the local marketers of distributed marketing organizations and their respective channel programs. Sproutloud develop technology and service offerings designed to make their clients local marketers successful withintheir respective business communities by enabling integrated local marketing management.Responsibilities:Work closely with marketing professional to design mission critical marketing products that enable marketing professional to reach out and target millions of existing and past customerbase using our highly integrated Direct Mail/Email/Social/SMS technologies, Also works closely with developers/designers to develop mission critical database application- Develop advanced procedures, triggers and functions to implement business logic in Postgresql database.- Involved in desiging physical database model on PostgreSQL Server using Data Definition Language (DDL) and Data Manipulation Languages(DML), implementing triggers, constraint and indexes for data integrity in database- Used COPY statements to copy/load data from csv files into database- Created, developed and understood normalized conceptual, logical and physical data modeling, both normalized and dimensional- Architect and execute Business Intelligence solutions using Kettle ETL, OLAP and reporting requirements- Expertise in analyzing, developing and validating reports for campaigns, surveys and responses to surveys- Participate in change and code reviews to understand the testing needs of the change components- Working on troubleshooting defects in timely manner- Knowledge of PostgreSQL 9.0 streaming replication