Gowtham Ramar Email & Phone Number

Boston, Ma, Us

Boston, Ma, Us

New York, Ny, Us

Greenwood Village, Colorado, Us

Weston, Massachusetts, Us

Defined and designed the data architecture to implement data modelling solutions to bring in data from various data feeds, data lakes• Communicated with product owners, prepared high level design, and implemented a Data Dictionary system which covers 100% of database tables.• Created and maintained ETL workflow on SQL to ensure company’s financial compliance withstate law.• Created data pipelines to process unstructured data by integrating 2 million of raw data from various data sources.• Wrote complex SQL code and strong SQL optimization and performance tuning skills• Experience with building data pipelines for streaming big data • Developed Python scripts to automate the ETL workflow as a part of Data Ingestion• Partner with leadership, product managers and customer experience to implement SQL backed Tableau dashboards to monitor application’s downtime thereby saving several hours of manual work for company.• Achieved 95% accuracy in reengineering and strategizing ETL data pipelines that were reporting inaccurate data due to scalability issues.

Norwell, Ma, Us

• Developed detailed and interactive PowerBI dashboards and SSRS reports pulling data from multiple sources including SQL, Excel and helped business to look up the trend and the forecast• Used BI reporting tools to create ad hoc queries and reports including complex drill down matrix and tabular reports• Gained extensive knowledge in query optimization that includes performance tuning on company’s legacy• applications using Execution plans and reduced the execution time by 80%• Strong SQL knowledge and ability to code complex SQL functions, stored procedures including Dynamic SQL and Indexing.• Established data warehouse solutions with reusable ETL packages using SSIS to extract data from multi formatted flat files.• Interacted with the business to gather requirements and worked with many teams to create SQL code for the applications in an Agile Environment• Designed and coded a data model to store the customer logos in the database that eliminated the manual hardcoding, every time a new customer is added to the business.

Norwell, Ma, Us

Played a key role in enhancing the company’s applications by automating the web features that saved nearly 240 hours of an employee’s time using MVC5Experienced in object-oriented software development in an Agile Environment for the company’s Inventory HandlingWrote back end code using object-oriented approach to develop a module that maintains thecompany’s invoices for the customers.

Masters, Management Information Systems, General

Bachelors, Computer Science And Engineering