Gowtham Ramamoorthy
Data Architect
Broadlands,VA
Summary
Data warehousing specialist with extensive experience in energy, healthcare, and commercial real estate. Expertise in data analysis and team collaboration, driving significant process improvements. Proven track record of enhancing data management systems and optimizing workflows to increase efficiency.
Overview
15
15
years of professional experience
4
4
Certification
Work History
Datawarehouse Architect
Walker&Dunlop, LLC
09.2023 - Current
- Engineered self-service SSAS tabular cube for commercial real estate data, enabling independent dashboard creation in Power BI.
- Streamlined 250 ETL packages into 4 dynamic SSIS data pipelines, reducing execution time by 37% through parallel bulk insert techniques.
- Migrated enterprise reports from on-premises server to Power BI service, ensuring full data security and zero downtime.
- Designed comprehensive backend architecture for borrower/loan management website, enhancing accessibility and user engagement.
- Collaborated with marketing and finance stakeholders to develop scalable datasets and data models measuring ROI of marketing initiatives.
- Led discussions to standardize marketing campaign metrics, creating analytics frameworks that facilitated data-driven investment decisions.
Senior Staff Datawarehouse Engineer
Walker&Dunlop, LLC
09.2021 - 08.2023
- Migrated legacy data warehouse servers from SQL Server 2012 to Azure Data Warehouse (SQL server 2019), achieving a 65% improvement in report data retrieval.
- Implemented fast data transfer process from Salesforce to PostgreSQL using SOAP API, providing financial team with timely insights on data changes.
- Designed and established dynamic data pipelines to transfer files between SFTP sites, enhancing cross-company data accessibility.
- Engineered Airflow data pipelines to extract data from diverse API sources, consolidating it into a centralized AWS Redshift data warehouse to support the data science team's analytics effort.
Business Intelligence Architect/Manager
Pantheon, Inc
06.2020 - 08.2021
- Led a team of 4 in developing data models and pipelines using AZURE Analysis service & (ADF V2) for national energy clients.
- Mentored the team to improve the existing integration engine running for 8 hours to under 30 minutes by replacing the sequential architecture to parallel execution.
- Restructured existing dashboards & reports for easier maintenance and enabled data security and tracking for different business groups.
- Migrated huge JSON files in relational DB to a document DB (MongoDB) using Node.js and used Tableau as a reporting tool for visualizations.
- Designed interactive visualizations/charts, enabling health care analyst to efficiently analyze patient data.
Senior Business Intelligence Engineer
ICF Resources, Inc
06.2018 - 06.2020
- Created an automated dynamic Integration process which replaced the existing 130 SSIS packages with one single package and reduced the development hours by (40%).
- Designed and developed automated ETL packages using SQL server data tools (SSIS), CozyROC and TaskFactory and reduced significant (40%) time in delivering the output files to clients.
- Created various SSRS reports, Interactive BI reports, performed database backup and restore process and used PowerShell scripts to automate ICF data analysis report from various active directories.
Database Design Engineer
ICF Resources, Inc
07.2017 - 06.2020
- Designed various data models, partitioned big data tables, big data migration, performance tuning and invoked automated documentation using Redgate tool belt.
- Designed and developed a dynamic ETL integration process to stream MS CRM dynamics data into a centralized database system using FetchXML and SSIS.
Database Developer
USDA/Economic Research Service
08.2015 - 05.2017
- Reduced time and manual effort to calculate dynamic business formulas by creating unique stored procedure using recursive, common table expressions and dynamic SQL.
- Performed database management, research and development in commodity specific databases and published a research paper.
Senior Software Engineer
Mindtree India Ltd
03.2013 - 07.2015
- Removed many application dependencies by creating a single orchestration module to replace three individual modules using BizTalk 2013 integration tool.
- Implemented the business process in orchestration modules, performed testing and deployment using orchestration debugger and BizTalk administration console.
- Led cross-functional teams to enhance application performance and user experience.
Software Engineer
Sopra Steria
07.2011 - 02.2013
- Designed and integrated web applications with SQL database on Windows Azure using BizTalk 2010 integration tool.
- Gathered requirements, analyzed designs, and reviewed code for multiple web applications.
- Conducted unit testing and resolved defects to enhance application performance.
Education
Master of Science - Computer Engineering
George Mason University
Fairfax, Virginia, USA05-2017
Bachelor of Engineering - Electrical and Electronics Engineering
Anna University
Chennai, Tamilnadu, India05-2011
Skills
- ELT / ETL Integration specialist
- Data modeling
- Cloud data management
- Power BI visualization
- Data governance and Security
- Data encryption strategies
- Data pipeline optimization
- Data warehouse design
- Dimensional modeling
- Database design
- Data analysis techniques
- Business analytics
Certification
- Microsoft Certified Solution Associate (MCSA) in Database Development (SQL 2016), 03/01/19, Present, H057-0604
- Certified Scrum Master, 02/01/22, Present
- Digital Marketing Analytics, 10/01/24, Present
Publications
Intelligent Automation Tools and Software Engines for Managing Federal Agricultural Data, Batarseh, F., Ramamoorthy, G., Dashora, M., Yang, R., Federal Data Science and Advanced Analytics in Agricultural Science: Transforming Government and Policy using Artificial Intelligence, Elsevier's Academic Press, 2017
Languages And Technologies
SQL, Python, PostgreSQL, T-SQL, C#, Node.JS, PowerShell, Java Script, SSIS, SSAS, SSRS, dbt, Airflow, Redshift, Snowflake, MongoDB, HDFS, Spark, Hive, Data/Dimensional Modeling (Star), Snowflake, MVC 4.0, Web services, XML/XSD, JSON, Power BI, DAX, Tableau, SSRS, Power Pivot, CRM MS Dynamics, Azure, AWS
Timeline
Datawarehouse Architect
Walker&Dunlop, LLC
09.2023 - Current
Senior Staff Datawarehouse Engineer
Walker&Dunlop, LLC
09.2021 - 08.2023
Business Intelligence Architect/Manager
Pantheon, Inc
06.2020 - 08.2021
Senior Business Intelligence Engineer
ICF Resources, Inc
06.2018 - 06.2020
Database Design Engineer
ICF Resources, Inc
07.2017 - 06.2020
Database Developer
USDA/Economic Research Service
08.2015 - 05.2017
Senior Software Engineer
Mindtree India Ltd
03.2013 - 07.2015
Software Engineer
Sopra Steria
07.2011 - 02.2013
Master of Science - Computer Engineering
George Mason University
Bachelor of Engineering - Electrical and Electronics Engineering
Anna University