Gowtam Balasubramaniam

** ***** ******, ***-***· Union city, CA, Zip code -94587 · 469-***-**** · adi4t7@r.postjobfree.com To obtain a full-time job opportunities in the Information Technology field to contribute my skills in programming, web site management, business intelligence, data analysis and data base design to benefit the organization. EDUCATION

MS, Information Technology and Management 3.70/4.0 May 2015 University of Texas at Dallas, Richardson, TX

BE, Electrical and Electronics Engineering 74% June 2009 Anna University, Chennai, India

SKILLS (www.linkedin.com/in/gowtamb)

● Around 10 Years of professional experience in various phases of Software Development Life Cycle including Requirements analysis, Applications Design, Development, Integration, Implementation, Maintenance, Testing, Debugging of various client/server, windows and web applications.

● Frond end design experience using ASP.NET MVC, Angular, Bootstrap, HTML, CSS and JavaScript.

● Experience in building Restful services and creating SQL stored procedures and functions.

● Experience working in SAFe agile team and completed a SAFe agile advanced scrum master certification.

● Experience working in CICD pipelines and GIT source control systems.

● Experienced in writing complex SQL queries, Stored Procedures, Functions, Views and PL/SQL.

● Dynamic results-oriented Business Data Analyst with experience in Business Intelligence and Analysis.

● Strong understanding of statistical and business intelligence concepts with project experience on data analysis using Excel, SAS, Python, Tableau, QlikView, SQL. Good understanding of Data mining concepts.

● Created an ETL workflow to cleanup and transform data using CloverETL for a very large dataset.

● Adept at solving complex problems through a systematic approach that uses innovation and partnering combined with project management principles to maximize return on investment.

● Experienced in analyzing the data and building Dashboards and Reports using Tableau and QlikView.

● Experiences in creating excel macros, VBA, vLookup, pivot table, data table and Goal Seek for data analysis.

● Excellent communication, presentation and analytical skills. Experience in Business Requirement documentation. EXPERIENCE

Senior Full Stack Developer

Ernst & Young LLP, San Francisco, CA, USA June 2015 to Present

● Worked as full stack developer with experience in API development in C#, UI in Angular 8 and database in SQL server Management Studio.

● Responsibilities include designing Unit test cases, producing detailed specifications, writing program codes, system improvement, developing new feature.

● Developed a single page application using Angular 8, typescript, HTML5, CSS and bootstrap. Experience with D3 and YFiles library.

● Developed a Restful services using ASP.NET Web API to provide services to HTTP requests. Experience in writing unit tests.

● Lead the team of developers by assigning projects and verifying the distributed tasks. Mentoring the junior team members.

● Be a part of budgeting, estimation and client engagement meetings and involved in decision making process.

● Create Ad-Hoc queries with SSMS (SQL Server) for advanced analysis of data and report generation. Experience in building SQL stored procedures, functions and triggers.

● Developed a SSIS package to transform and validate the data. Automated the end to end process using scheduler.

● Developed an ETL solution using Python.

Operations Analyst Intern May 2014 to May 2015

Ericsson North America, Plano, Texas, USA

● Developed Dashboards and Reports using QlikView 11 BI tool, pertaining to Financial KPI’s of Ericsson Inc.

● Developed and maintained QlikView Load Scripts across multiple SAP based data sources.

● Automated the creation of monthly and weekly reports which eliminates the human effort and saved time and cost.

● Created a Dashboard and monthly reports using Tableau. Worked on Excel based business modelling and analysis.

● Created a data model using normalization approach to migrate data from Excel into SQL Server 2012.

● Created an ETL workflow using SSIS to extract, transform and load data into database.

● Analyzed the data using QlikView and SQL to find the mapping between two major division networks.

● Developed Dashboards and Reports using Telerik ASP.NET MVC and SQL Server 2012.

● Worked on Data Migration from different sources into SQL Server using SQL Server Integration Services (SSIS). Senior Systems Engineer / Web Application Developer June 2009 to June 2013 Infosys Limited, Mysore, India

● Four years’ experience as a web application developer; developed applications based on .NET, C#, ASP, SharePoint, Silverlight and Oracle platforms to manage data related to oil wells of British Petroleum (BP).

● Gathered requirements, estimated budgets, designed, developed, tested and final support tasks for 12 projects.

● Expertise in designing and developing applications using HTML, CSS, JavaScript, jQuery, AJAX, Web services, SOAP,XML and LINQ. Good experience in development of reports using Crystal Reports and SSRS.

● Travelled to client locations for implementing the solutions and deployments.

● Worked on asp.net MVC, MVMM architecture and WCF based applications.

● Developed a Dash boarding tool using SharePoint and SQL Server. Used free-hand SQL for Analysis purpose.

● Experience in identifying entities and creating a data model using normalization approach.

● Interfaced with business users to prepare and update Business Requirements Document (BRD) and individually resolved the performance issues in client applications.

● Designed and developed SSIS packages, stored procedures, tables, view and functions; Implemented best practices to maintain optimal performance. Worked on SDLC and Agile methodologies.

● Hands on experience in debugging and fixing the bugs and also very good with support and maintenance.

● Lead team of four people in a project which was awarded an “above expectation” rating from client.

● Worked on database design, project plan, billing, software requirement specification, non-functional specification document, UML, Class diagram, use case diagram & Sequence diagrams and test plan for several projects.

● Created the ETL workflow using SQL Server Integration Services. COMPUTER SKILLS

● Dash boarding /Analytics: Qlikview, Tableau.

● Programming Languages: Angular 8, Typescript, SAS, SQL, PL/SQL, Python, C++, C#, Asp .Net, VB.NET, VBA, SAP Crystal Reports, JavaScript, HTML5, jQuery, JavaScript, Web Service, XML, CSS, SharePoint 2010,Winforms.

● Database: Oracle 10g, Oracle 11g, SQL server 2008, MySQL, MS Access.

● ETL Tools: SAP Net weaver, SSIS, SSRS, Business Objects.

● Tools: Proficient in MS Word, Excel, Power point, MS Visio, Microsoft Project, SAS 9.3, Rapid miner, WEKA, SAP BW, Visual Paradigm, Microsoft Visual Studio IDE, Toad. CERTIFICATIONS

● Microsoft Certified Professional (License – 9661694).

● MS: Programming in HTML5 with JavaScript and CSS3.

● UTD SAS Certified in Business Intelligence and Data Mining.

● QlikView Developer Training.

● Certified SAFe Advanced Scrum Master.

CAMPUS & COMMUNITY ACTIVITIES

● Student Worker – Financial Services, UTD Bursar Office

● Web Master – MIS Club, UTD

Contact this candidate