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.