We provide IT Staff Augmentation Services!

Sr. Software Engineer Resume

SUMMARY

  • Over 15 years of comprehensive knowledge of concepts, principles, practices and procedures in Database and Software development including Agile and SDLC methodology for medium to large size organizations.
  • 15 years of database modeling, design and development using MS SQL Server and Oracle.
  • Expert in building, managing and optimizing ETL processes using Microsoft SSIS and programming languages.
  • Working knowledge of SaaS products like SuccessFactors, leverage APIs and report development using Plateau Designer.
  • Work with Azure and AWS cloud platforms for database and building APIs.
  • Proficient in writing, analyzing and tuning complex SQL queries, stored procedures and functions. software engineering experience of working with C# and writing APIs and .NET applications.
  • 10 years of Reports and Dashboard development using Tableau, SQL Reporting Services (SSRS), Crystal Reports and Custom Reports using C# .NET
  • Over 15 years of hands - on experience supporting and maintaining enterprise level data solutions including end-user support.
  • Good understanding of Data Visualization concepts and ability to identify trends & patterns in the data for providing actionable insights.
  • 8 years of Software development using Agile and Scrum process.
  • Strong time management skills with ability to participate in multiple projects/work streams simultaneously as well as strong analytical/problem solving skills.
  • Highly motivated individual with excellent organizational and interpersonal skills.

TECHNICAL SKILLS

Databases: SQL Server 2019, 2016,2012 Oracle 8i, 9i, Fox Pro 2.5

ETL Tool: SSIS

Cloud Platforms: AWS - RDS for SQL Server; Azure SQL Database and API

Reporting Tools: Tableau, SQL Server Reporting Services, Crystal Reports, Plateau Designer

Modeling Tool: ERWin 7.3

DB Dev Ops: Redgate SQL Compare and Source Control

API: JSON, SOAP, REST, XML

Web Systems: .NET Framework 4.4, C#, ASP.NET, Silverlight, Winforms, ASP, HTML, XML, DHTML, CSS

GUI Tools: Visual Studio 2019, 2016, 2012, Jira, Confluence, MS Teams, Team Foundation Server (TFS) 2016

PROFESSIONAL EXPERIENCE

Confidential

Sr. Software Engineer

Responsibilities:

  • Analyze and understand business users' requirements, clarifying inconsistencies, conflicts or ambiguities to effectively design, develop, configure, implement, test and support data centric solutions for Learning Management Systems (LMS).
  • Create and maintain single data model and codebase supporting hundreds of LMS clients. Generic data model and process automation enabled company to sign up hundreds of clients with minimum incremental cost.
  • Develop data mapping specifications - source to target mappings for ETL processes.
  • Database development on Azure SQL Database. Data integration and API development with Microsoft Azure.
  • Database migration to AWS RDS for SQL Server.
  • Design, development, implementation, unit testing, Troubleshooting and support of ETL process using SQL Server Integration Services (SSIS). Optimize ETL processes to reduce data load times.
  • API and report development on SaaS platform (SuccessFactors).
  • Analysis, design and implementation of data migration.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau, SSRS and Plateau Designer.
  • Write complex SQL queries, stored procedures, triggers and performance tuning queries.
  • Import and export large amounts of data in formats like CSV, JSON, XML, etc.
  • Participates in a team-based, scrum development environment.
  • Work with software developers, lead and architect to implement new solutions for LMS customers.
  • Ensure data integrity, restorability and appropriately handle data loading errors.
  • Spearhead code review quality assurance and acceptance process.
  • Troubleshoot system errors and performance issues.

Environment: SQL Server 2019, SSIS, Tableau, SSRS, Visual Studio 2019

Confidential

Sr. Database Developer

Responsibilities:

  • Collaborate with business leaders and technical teams in conceptualizing, designing and developing new data centric software applications and enhancements.
  • Data Modeling, Design and Development
  • Write complex SQL queries, stored procedures, triggers and performance tuning queries.
  • Develop data mapping specifications - source to target mappings for ETL processes.
  • Develop the workflow and dataflow of SSIS ETL processes to support many different file structures and business processes. Optimize ETL processes to reduce data load times.
  • Collaborate with programmers and quality assurance testers to ensure professional deliveries.
  • Building and publishing customized interactive reports and dashboards using Tableau.
  • Created parameterized, drill down and ad hoc - standard, cross tab, sub reports using SSRS
  • Utilize programming languages to create complex functions for use in databases.
  • Analyze potential data quality issues to determine the root cause and create effective solutions.
  • Spearhead code review quality assurance and acceptance processes.

Environment: SQL Server 2012, SSIS, Tableau, SSRS, Power Pivot, Visual Studio 2012

Confidential

Sr. Software Developer

Responsibilities:

  • Database Design and Development
  • Query optimization and tuning of databases
  • Develop reports using SSRS and PowerPivot
  • Writing SSIS packages for ETL dataflow
  • Writing Stored Procedures and triggers
  • Gather user requirements and translate them into technical solutions
  • Creating stored procedures, SSIS packages, and using other methods to import/translate/manipulate data.

Environment: SQL Server 2008, SSRS, SSIS, ERWin 7.3

Hire Now