Gopalakrishnan Pitchaiah, Developer in Redmond, WA, United States
Gopalakrishnan is available for hire
Hire Gopalakrishnan

Gopalakrishnan Pitchaiah

Verified Expert  in Engineering

Software Developer

Location
Redmond, WA, United States
Toptal Member Since
August 11, 2021

Gopal has over 20 years of experience in software development, testing and program management. He has a track record of developing new systems in partnership with software engineers to enable quick and easy data consumption. Gopal has demonstrated the ability to architect and launch new data models that provide intuitive analytics. He has proven success in building data warehouses and analytical reports and is well-versed in data management principles, testing, and program management.

Portfolio

Freelance
Microsoft SQL Server, SQL Server Analysis Services (SSAS)...
Startup
C#.NET, ASP.NET MVC, Facebook API, Azure SQL, Knockout (Knockout.js), JsRender...
Freelance
ADO.NET, C#.NET, ASP.NET, Microsoft Silverlight, Ajax, Microsoft SQL Server...

Experience

Availability

Part-time

Preferred Environment

Microsoft SQL Server, Python, Windows, Visual Studio Code (VS Code)

The most amazing...

...thing I have developed is the marketing intelligence solution for a big software company that is being treated as one version of the truth.

Work Experience

Senior Data Engineer

2009 - PRESENT
Freelance
  • Provided technical leadership and hands-on implementation role in the areas of data techs including data access, integration, modeling, visualization, design, and implementation. I developed logical and physical data models for the data warehouse.
  • Designed and developed data pipelines, code, and scripts that leverage structured and unstructured data integrated from multiple sources. Moreover, I designed and developed reporting tracker, and shared growth analysis tools for financial planners.
  • Worked closely with a global team of data scientists, domain experts and data engineers to create business impacting data analytics services. In addition, I used BI and intuitive visuals to empower non-tech customers to drive their own analytics.
  • Established data management, governance, and metadata processes and standards. I have expertise in all areas of data warehousing, including architecture, data sourcing and acquisition, integration, transformation, and presentation.
  • Promoted teamwork and effective communication to develop interdepartmental relations with partnering teams across the globe.
Technologies: Microsoft SQL Server, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft Power BI, C#, Python, Azure Data Lake, Azure Data Factory, Azure Synapse, Spark SQL, jQuery, JavaScript, Data Engineering, Databases, Dashboards, Dashboard Design, Data Migration, Multidimensional Expressions (MDX), DAX, ASP.NET MVC, JSON REST APIs, WCF Web Services, Windows Communication Foundation (WCF), Microsoft Silverlight, SharePoint, ADO.NET, AngularJS, Dimensional Modeling, Star Schema, Data Modeling, Data Warehousing, Azure, SQL, Data Pipelines, Data Integration, ETL, T-SQL (Transact-SQL), Business Intelligence (BI)

Senior Software Engineer

2013 - 2016
Startup
  • Worked as a senior software engineer for the development of social media advertising framework user interface and back-end functions.
  • Designed and developed REST APIs using ASP.NET MVC and Facebook Graph API to get Facebook resource data for users.
  • Developed user interfaces that seamlessly work with REST API JSON calls that connect to Facebook. I have used jQuery along with JsRender and Knockout.js for client-side scripting.
  • Developed data models to provide analytics based on the use of the application used to provide propagation and sharing of advertised components and widgets.
  • Created key rendering and multimedia interactive components to be integrated as part of the advertising widget.
Technologies: C#.NET, ASP.NET MVC, Facebook API, Azure SQL, Knockout (Knockout.js), JsRender, jQuery, JavaScript, REST APIs

Lead Developer

2008 - 2009
Freelance
  • Designed and developed ASP.NET custom web parts using C#, Ajax, Dundas controls, and Silverlight controls.
  • Developed and designed KPIs, scorecards, dashboards, reports, charts, and decomposition trees using PPS, SSRS, SSAS, and ProClarity.
  • Configured deployment, integration and security of MOSS, PPS, SSRS, ProClarity, SSAS, and SQL server components.
  • Served as key technical contact to troubleshoot technical issues from vendor and client internal teams on PPS, ProClarity, SSRS, and MOSS components.
  • Involved in maintenance and enhancement of MEC framework, Silverlight-based web parts used for graphic charts in MEC.
Technologies: ADO.NET, C#.NET, ASP.NET, Microsoft Silverlight, Ajax, Microsoft SQL Server, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SharePoint, JavaScript, jQuery, SQL, T-SQL (Transact-SQL), ETL

Lead Developer | Program Manager

1993 - 2007
Wipro Technologies
  • Designed and developed custom client and server, web and business intelligence applications, reports, data pipelines, and scorecards.
  • Handled project management organization activities such as project scheduling, resource planning, coordinating and managing resources, and software quality and release management.
  • Coordinated with technical teams at multiple geo-locations for project execution.
Technologies: Microsoft SQL Server, C#.NET, Oracle, Java, JavaScript, SQL, Data Pipelines

Market Intelligence Solution

I have joined the Market Intelligence team 12 years back and built the Market Intelligence solution that provides intelligence data points for the product and services at various internal dimensions.

My roles and responsibilities were to:
• Oversee all aspects of data warehousing, including data sourcing, architecture, acquisition, and transformation.
• Build data pipelines, scripts, and codes that leverage data integration from various sources.
• Create physical and logical data models for a data warehouse in line with data management, governance, and metadata standards.
• Implement data techniques related to data design, access, visualization, and modeling.
• Design several applications and drive the architectural vision of the solution.
• Develop business impacting data analytics services by liaising with an international team of product managers, domain experts, and data engineers and scientists.
• Empower internal and non-technical clients to drive reporting and analytics using business intelligence and visualization software.

Enterprise Cube

Enterprise Cube is designed to provide industry verticals with real-time, end-to-end performance management analytical solutions that target the client’s pain points and provide a low cost of implementation, quick time to production with a rapid return-on-investment. These solutions are comprised of the Microsoft BI product stack SQL, PPS, and MOSS. They include content built around vertical industry business pain points such as standards and best-practices-based data models, predictive analytical models, KPIs, reports and workflow.

My roles and responsibilities:
• Served as development lead for the team.
• Designed and developed ASP.NET custom web parts using C#, Ajax, Dundas controls, and Silverlight controls.
• Designed and developed KPIs, scorecards, dashboards, reports, charts and decomposition trees using PPS, SSRS, SSAS, and ProClarity.
• Configured deployment, integration and security of MOSS, PPS, SSRS, ProClarity, SSAS, and SQL Server components.
• Served as key technical contact to troubleshoot technical issues from vendor and client internal teams on PPS, ProClarity, SSRS, and MOSS components.

Social Media Advertising Platform

Development of Facebook Graph API-based social media advertising platform to enable users to share and propagate advertising collages for a start up company.

My roles and responsibilities:
• Served as a senior software engineer involved in the development of user interface and REST APIs using C# and Facebook Graph API.
• Developed data models to provide analytics based on application usage to propagate and share advertised components and widgets.
• Developed key rendering and multimedia interactive components to be integrated as part of the advertising widget.

Languages

Python, C#, JavaScript, C#.NET, SQL, T-SQL (Transact-SQL), Java

Frameworks

ASP.NET MVC, ADO.NET, AngularJS, ASP.NET, Knockout (Knockout.js)

Tools

Microsoft Power BI, Microsoft Silverlight, Spark SQL

Paradigms

Object-oriented Programming (OOP), Dimensional Modeling, ETL, Business Intelligence (BI)

Platforms

Azure, Azure Synapse, Windows, Oracle, SharePoint, Visual Studio Code (VS Code)

Storage

Microsoft SQL Server, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Database Management Systems (DBMS), Databases, Azure SQL, Data Pipelines, Data Integration

Other

Software Engineering, Data Modeling, Data Migration, Data Engineering, Dashboards, Dashboard Design, Multidimensional Expressions (MDX), JSON REST APIs, WCF Web Services, Windows Communication Foundation (WCF), Ajax, Star Schema, Data Warehousing, Azure Data Factory, Azure Data Lake, DAX, JsRender

Libraries/APIs

jQuery, Facebook API, REST APIs

1989 - 1993

Bachelor's Degree in Computer Science and Engineering

Government College of Technology - India

JUNE 2020 - PRESENT

Apache Spark with Scala, Hands on with Big Data

Udemy

MARCH 2020 - PRESENT

The Ultimate Hands-on Hadoop, Tame Your Big Data

Udemy

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring