SUHAS MADAPPA

DATA CONSULTANT

PROFESSIONAL PROFILE

480-***-****

A highly-motivated Data Management consultant with a passion for Data, functioning as

ad1ixs@r.postjobfree.com

Suhas Madappa

4331 E Roma Avenue Phoenix AZ 85018

EDUCATION

Bachelor of Engineering-VTU

2000-2004

` SKILLS

Snowflake, Microsoft Sql Server

DBT, Python Microsoft SSIS/SSAS Scribe/MuleSoft Tableau /Power BI ETL/Data Warehouse

CERTIFICATES

SnowPro Core Certified Microsoft Certified Database Architect

ITIL V3 Foundation Certified

Data Consultant with more than 17 years of database encounter with experience using Snowflake/ Microsoft SQL Server / PostGresql. Extensive knowledge of REIT best practices in database design & modelling, Data Integration using Mulesoft /SSIS /Scribe/Amazon Glue and migration methods, techniques.

PROFESSIONAL EXPERIENCE

JOB POSITION

Jun 2016 – till date: Invitation Homes/Colony Starwood Homes, Scottsdale, AZ

As Data Consultant

Environment : Yardi, Snowflake,DBT, ETL, MS Azure, Data warehouse, Analytical Reports, Salesforce

Deliverables :

-Functioning as Data Consultant; carrying out tasks related to SFR Property Data Integration.

-Requirement analysis, identifying source system, design, & implementation between Yardi & downstream systems.

-Lead the data migration project from On Perm SQL server/ SSIS instance to Cloud DW involving 95,000 properties, performing a phased cutover with full data migration to Snowflake on AWS instance using DBT

JOB POSITION

Jan 2013-June 2016: Progress Residential, Scottsdale, AZ As Data Engineer Consultant

Environment : MS SQL Server 2016, Scribe Insight/On Premise, CRM Dynamics

Synopsis : CRM Dynamics is back office Property management system that provides the operational functions for Leasing, Construction & Account department in Progress Residential. It is a customizable role-based system for users with different activity authorization. The users of this system will be able to view information based on their roles and perform operations.

Deliverables :

-Functioning as Database Architect; carrying out tasks related to database design, Maintenance activity & implementation

-Heavily employed Microsoft database tools including SQL Server 2000-2012 Relational

Engine, Integration Services and Computer Associate’s ERwin data modeling tools and experience with Analysis Services

-Data integration across platforms from SQL Server to MS CRM Dynamics

-Process Developer -1 certified professional in Boomi Integration Tool.

Jan ’2011 – Jan’2013: American Homes 4 Rent, Agoura Hills, CA/Beazer Homes, Scottsdale

As Data Consultant

Role : Database Architect/SQL DBA

Environment : Yardi, ETL, SSIS, Microsoft C#.Net, Asp.net

Deliverables :

-Functioning as SQL Architect; carrying out tasks related to database design, Maintenance activity & implementation.

-Develop & Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues. Proficient with Server-Side System Default & Black box Traces to analyze other issues on the server.

-Migrated standalone database to a SQL Failover Clustered environment

-Perform regular maintenance including index optimization, consistency checks, and data file and

-Transaction log size monitoring using built-in tools, custom written T-SQL scripts, SQL Agent Jobs, and Database Mail

-Worked and resolved issues around too any indexes on frequently updated (inclusive of inserts, updates and deletes) tables incur extra index maintenance overhead. Generally, OLTP database designs should keep the number of indexes to a functional minimum, again due to the high volumes of similar transactions combined with the cost of index maintenance.

JOB POSITION

Apr’ 2008 - Nov’ 2010: Infosys Technologies Ltd., Bangalore

Environment : MS SQL Server 2005/2008, Asp.Net, SSRS, SSIS

Synopsis : The project dealt with refinery related analyzer data of the British Petroleum products. The application was used by the Site Engineer to take security and safety action based on the analyzer data fetched from the refinery sites.

Deliverables :

-Functioning as SQL Server DBA; involved in the planning, analysis, design & implementation of databases & be a primary resource for new application implementation. Provided appropriate consulting, interfacing, and training for users.

-Collaborate with developers, network administrators, system administrators to implement secure, reliable database environments.

-Ensure high availability in a mission-critical, secure production environment including backups, disaster recovery, and real-time system monitoring.

-Implementing Quality Management System procedures; conducting with unit testing & deployment.

-Maintain thorough and rigorous documentation related to database server configuration, operation, and database change management

JOB POSITION

Apr’06-Apr’08: Hewlett Packard, Bangalore/Munich - Senior Software Engineer Environment : C#, Asp.net and SQL Server

Synopsis : The project aimed at developing an application that provided assistance in sales related activities of the HP products. It was mainly used by the Sales Representative to claim the compensation of the complex and meta deals.

Deliverables :

-Facilitating as Software Engineer, responsible for design and coding of the application using design patterns

-200 hand-programmed stored procedures, with parameters, RETURN values, complex multi-table JOINs, and cursors when necessary

-All tables indexed and tuned, then de-normalized when necessary to improve performance

-Performance tested and optimized using SQL Profiler, Index Tuning Wizard and Query Analyzer

-Carrying out unit and user acceptance testing with debugging functions

-Perform regular maintenance including index rebuilds, reorganization and statistics updates.

-Visiting client place - Germany for a period of 5 months for business requirement analysis and design discussion

Sep’04-Apr’06 : Excel Soft India Pvt. Ltd Mysuru

Environment : C# (Win forms) and SQL Server

Synopsis : The project was based on designing a an industry-recognized anatomic pathology information system designed for the unique workflow requirements of the anatomic pathology department.

Deliverables :

-Designing, coding and testing of application.

-Maintain thorough and rigorous documentation related to database server configuration, operation, and database change management

-Data imported and manipulated with DTS and BCP as needed.

PROFESSIONAL DEVELOPMENT

Technical:

Databases : Snowflake(AWS, Azure), MS Sql ServeMongoDB

ERP : Microsoft CRM Dynamics, Salesforce & Yardi 7S

Scripting Languages : Python, JavaScript and PowerShell Script

Reports : Tableau, Power BI

Data Integration : MS SSIS, ETL Packaging

Data Analysis : SSAS, MDF Queries.

Tools : Jira, ASANA, Rally Dev, Github, TFS, SVN

Contact this candidate