Sql Server Data Consultant
Resume:
SUHAS MADAPPA
DATA CONSULTANT
PROFESSIONAL PROFILE
A highly-motivated Data Management consultant with a passion for Data, functioning as
**********@*****.***
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