We provide IT Staff Augmentation Services!

Software Design Engineer Resume

4.00/5 (Submit Your Rating)

Redmond, WA

TECHNICAL SKILLS:

Programming skills: SQL, .Net, Scala, DAX, Power Query, U - SQL

Big data: Spark, Scala, Azure HDInsight, Azure Databricks, Azure Data Lake Analytics

Cloud: Azure

ETL: Azure Data Factory, Power BI Dataflows, Logic Apps, Power Apps, SSIS

Reporting: Power BI, SSRS, EXCEL

Analytics: SSAS, Azure Analysis Services, SQL Data Warehouse

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

Software Design Engineer

Responsibilities:

  • Integrating cloud native applications with external API’s like Azure Active Directory Graph API and Power BI Embedded API.
  • Involved in Software Development Life Cycle like Requirement Analysis, Design, Implementation and Testing.
  • Working in Confidential Knowledge Group by transforming disparate information (financial and non - financial) across the ecosystem, to build comprehensive customer knowledge platform.
  • Designing and developing data load strategies, transformation for business to analyze the datasets.
  • Processing flat files in various file formats and stored them as in various partition models in Azure storage.
  • Implementing Spark using Scala and Spark SQL for faster testing and processing of data responsible to manage data from different sources.
  • Developing and debugging Spark SQL and Scala scripts to pull and transform the data for reports creation.
  • Using various spark Transformations and Actions for cleansing the input data.
  • Implementing Spark using Scala and Spark SQL for faster testing and processing of data.
  • Implementing Spark using Scala and utilizing Data frames and Spark SQL API for faster processing of data.
  • Orchestrating Azure resources like Azure Data Factory, Storage Accounts, Azure Data Lake, Azure Analysis Services and HDInsight clusters for Big Data processing.
  • Configuring Azure resources with Integration Runtime, Azure Key Vault and Applications to access with service principles.
  • Creating Azure Data Factory V2 Pipelines which fetches data from different Confidential sources into a single platform enabling the availability of diverse data.
  • Data Cleansing and processing using U-SQL in Azure Data Lake Analytics.
  • Developing and Deploying the SSAS Tabular cubes sourcing the data from Azure Data Lake Store.
  • Development of Spark SQL scripts to pull and transform the data for reports creation.
  • Creating Power BI Reports which helps the team in depicting the trends for Product Groups.

Confidential, Bellevue, WA

Software Developer

Responsibilities:

  • Involved in Software Development Life Cycle like Requirement Analysis, Design, Implement and Test.
  • Worked in an Agile team of .NET developers for a fast-paced software development.
  • Worked with engineering team to modify code and debug the issues.
  • Designed and developed various abstract classes, interfaces, classes to construct business logic using C#.Net.
  • Developed new API’s and used external API’s for integrating the embedded applications.
  • Created reports and dashboards based on data from different sources.
  • Wrote complex queries using aggregate functions, joins, subqueries and correlated subqueries.
  • Created objects like views, user defined functions, stored procedures, triggers and indexes.
  • Configured build and release pipelines in Visual Studio Team Services (VSTS) for Continuous Integration (CI) and Continuous Deployment (CD).

Confidential, Russellville, AR

Software Developer Intern

Responsibilities:

  • Gathered and analyzed requirements from a professor.
  • Developed a web-based application which converts visual blocks into Genesis code.
  • Genesis is an algorithmic language which has been using for teaching introductory students, how to write algorithms.
  • This application has been developed using client-side JavaScript framework called Blockly.

Graduate Assistant

Confidential, Russellville, AR

Responsibilities:

  • Supervised and evaluated students' laboratory work.
  • Developed and delivered engaging lectures to undergraduate and graduate students.
  • Guided students in using technology to support educational research.

Confidential

Data Analyst

Responsibilities:

  • Collected, compiled, analyzed and produced useful insight and valuable information from various raw data sources.
  • Modified existing databases to correct errors, upgrade interfaces and improve performance.
  • Directed database design and development while remaining focused on client needs.
  • Designed and coded database tables to store the application's data in normalized form.
  • Writing and debugging complex SQL Queries, stored procedures, functions, triggers, views, cursors, joins, constraints as per business needs.
  • Cleansed raw data using HLOOKUP and VLOOKUP’s in MS Excel.

We'd love your feedback!