Mahesh M Email & Phone Number

Baltimore, Maryland, United States

Designed and setup Enterprise Data Lake to provide support for various uses cases including Storing, processing,Analytics and Reporting of voluminous, rapidly changing data by using various AWS Services. Creating Informatica Mappings and Workflows to load data in Relational tables (In Development, Stage andproduction environment) by applying several transformations. Responsible for Analyzing report requirements and developing the reports by writing Teradata SQL Queries andusing MS Excel, Power Point and UNIX. Wrote several Teradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request. Created Teradata objects like Tables and Views. Extensively worked on to convert ORACLE scripts into Teradata scripts Used Joins like Inner Joins, Outer joins while creating tables from multiple tables. Created Multiset, temporary, derived and volatile tables in Teradata database. Used different type of slicers available in Power BI for creating reports. Used Power BI Gateways to keep the dashboards and reports up to date. Designed, Built and Analyzed data solutions using Azure and Azure Databricks services. Provided dataVisualization using Azure Databricks Dashboards and Power BI and provided data Insights for Business Implement One time Data Migration of Multistate level data from SǪL server to Snowflake by using Python andSnow SǪL. Trained different team managers on Tableau and created best practices document for dashboard development. Developed multiple Tableau dashboards weekly and present to co-operate team Created various views in Tableau-like Tree-maps, Heat Maps, Scatter plots, Radical chart Geographic maps, Linechart, Pie charts, etc Designed and developed ETL mapping for data collection from various data feeds using REST API. Experience in Google cloud ecosystem like big query, big table, cloud proc, dialog flow, cloud

Allen, Texas, United States

Worked on Python Open stack API's and used Python scripts to update content in the database and manipulatefiles. Developed Data Stage extract jobs using SQL server SSIS and load the data into a staging area in the form of flatfiles/Data Sets. Responsible for analysis of requirements and designing generic and standard ETL process to load data fromdifferent source systems Use the RUP and agile methodology to conduct new development and maintaining software. Design and Develop ETL Processes in AWS Glue to migrate Campaign data from external sources like S3,ORC/Parquet/Text Files into AWS Redshift. Create a process to extract email attachments and send required information from Big Query Implemented Lambda to configure Dynamo DB Autoscaling feature and implemented Data Access Layer to accessAWS DynamoDB data. Lead the Enterprise Data Architecture Team that owns all Intellect Product Databases. Review the Data Model with Wellpoint Data Architect Team and obtain Data Model signoff Designed the overall Data Architecture for the Source Data Extraction Change Data Capture CDC Extensive experience in data modeling, data architect, solution architect, data warehousing & businessintelligence concepts and master data management (MDM) concepts.  Expertise in Big Data architecture like hadoop (Azure, Hortonworks, Cloudera) distributed system, MongoDB,NoSQL. Created pivot tables in Excel by getting data from Teradata and Oracle. Helped users by Extracting Mainframe Flat Files (Fixed or CSV) onto UNIX Server and then converting them intoTeradata Tables using BASE SAS Programs. Used SAS PROC IMPORT, DATA and PROC DOWNLOAD procedures to extract the FIXED Format Flat files.

Bengaluru, Karnataka, India

Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination ofAzure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics. Data Ingestion to one or more AzureServices - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks. Monitored UNIX server for CPU Utilization, Memory Utilization, and Disk Utilization and tuned the UNIX serversand suggested solutions to the Application teams/Business. Provided Support for Fixed Income application and batch processes running on UNIX servers. Installation, Configuration and Maintenance of VERITAS cluster server VCS for UNIX boxes. Task included customizing the company's product per client requirements. My work involved managing all themachines and most of them were UNIX based. 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 datainfrastructure. Expertise in Apache Hadoop ecosystem, Spark, Spark SǪL, Spark Streaming, Hive, Kafka, Flume, Sqoop, Scala,,Python, PySpark, Streamsets, Shell Scripting, opentsdb,Cloud Computing(GCP). Utilized Python, Scala, and Shell scripting to automate and customize data processing tasks, improving overallsystem efficiency. Implement One time Data Migration of Multistate level data from SǪL server to Snowflake by using Python andSnowSǪL. Migrating Oracle DB to Big Query and using Power-BI for reporting as a POC. Work related to downloading Big Query data into pandas or Spark data frames for advanced ETL capabilities. Working with GCP cloud using in GCP Cloud storage, Data Proc, Data Flow, Big Query, Cloud Composer, Cloud.

Hyderabad, Telangana, India

Applied statistical techniques, Python programming, and SQL queries to analyze and manipulate data, using tools like Tableau for visualizations to identify patterns and trends within the data, while also contributing to the creation of standard operating procedures (SOPs).Collected raw data from diverse sources, maintained detailed documentation, collaborated with cross-functional teams to align with project requirements and business goals, and identified/resolved data-related challenges, ultimately compiling comprehensive reports with key insights and actionable recommendations.Environment: Python, SQL, Tableau, SOPs, GIT.