Gopalakrishnan Pitchaiah, Software Developer in Redmond, WA, United States
Gopalakrishnan Pitchaiah

Software Developer in Redmond, WA, United States

Member since June 25, 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.
Gopalakrishnan is now available for hire

Portfolio

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

Location

Redmond, WA, United States

Availability

Part-time

Preferred Environment

Microsoft SQL Server, Python, Windows, 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.

Employment

  • 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 Framework (WCF), Silverlight, SharePoint, ADO.NET, AngularJS, Dimensional Modeling, Star Schema, Data Modeling, Data Warehousing, Azure, SQL, Data Pipelines, Data Integration, ETL, T-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, SQL Azure, 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, Silverlight, Ajax, Microsoft SQL Server, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Performance Point Server, SharePoint, JavaScript, jQuery, SQL, T-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, VisualBasic, PowerBuilder, Oracle, Java, JavaScript, SQL, Data Pipelines

Experience

  • 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.

Skills

  • Languages

    Python, C#, JavaScript, C#.NET, SQL, T-SQL, Java
  • Frameworks

    ASP.NET MVC, Windows Communication Framework (WCF), Silverlight, ADO.NET, AngularJS, ASP.NET, Knockout.js
  • Tools

    Microsoft Power BI, VS Code, Spark SQL
  • Paradigms

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

    Azure, Windows, Oracle, SharePoint
  • Storage

    Microsoft SQL Server, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Database Management Systems (DBMS), Databases, SQL Azure, 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, Ajax, Star Schema, Data Warehousing, Azure Data Factory, Azure Data Lake, Azure Synapse, DAX, Performance Point Server, JsRender
  • Libraries/APIs

    jQuery, Facebook API, REST APIs

Education

  • Bachelor's Degree in Computer Science and Engineering
    1989 - 1993
    Government College of Technology - India

Certifications

  • Apache Spark with Scala, Hands on with Big Data
    JUNE 2020 - PRESENT
    Udemy
  • The Ultimate Hands-on Hadoop, Tame Your Big Data
    MARCH 2020 - PRESENT
    Udemy

To view more profiles

Join Toptal
Share it with others