EXPERIENCE SUMMARY:

• Over 7 Years of experience in software lifecycle development from requirement specification to product release.
• Diversified experience in Software Development and BI/SQL Development.
• Strong coding skills as .NET developer and SQL developer.
• Proficient in writing T - SQL Queries, Stored Procedures, Functions, Joins, Views, etc.
• Expertise in designing and developing Power BI, SSRS and Crystal Reports.
• Developed various ETL packages using various tasks like Data Flow Tasks, Script Tasks, Azure Blob Tasks, Excel Source, Flat File Source, Conditional Splits, LookUps, Derived Columns, Execute SQL Task.
• Extensive experience in data pull using ETL (SSIS) from various source systems. Azure Data Factory, Pipelines, datasets, Blob containers and Linked Services.
• Better understanding of OLAP data model designing and familiar with SSAS (multidimensional & tabular model)
• Experience in design and development of applications using C#.NET and Web technologies like HTML, CSS, Bootstrap, Ajax, jQuery and JSON in N-tier architecture.
• Extensive experience in monitoring, troubleshooting, migrating and supporting/ Bug fixing.
• Experienced in writing LINQ queries, also Stored procedures in SQL server.
• Worked extensively with Iterative Agile Methodologies (SCRUM), Waterfall Methodologies and Test-Driven Development (TDD).
• Implemented reports in Excel using excel formulas, Pivot & Power Pivots
• Experience in using TFS, SVN and github source control systems.
• Smart enough to work efficiently with emerging technologies.
• Good Knowledge on Azure, Azure Storage Explorer.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, C#.NET, VB.NET

RDBMS: Confidential SQL Server /2014/2017 Oracle 9i, 10g

BI Tools: SSIS, SSAS, SSRS, Power BI & SQL Profiler

Web Technologies: HTML, CSS, jQuery, AngularJS

Tools: Power BI, Crystal Reports, SSRS

.Net Framework: 4.5.2/ 4.0 /3.5 , Visual Studio.Net 2015/2013/2017

Version Control: TFS, Git, SVN

PROFESSIONAL EXPERIENCE:

Confidential

Software: SSIS, SQL Server, Power BI, C#.NET, WEB API services

Full Stack Developer (SQL BI & .Net)

Responsibilities:

• Requirement gathering from clients for different modules
• Developed the various SSIS Packages for ETL
• Extensively used Azure Blob Tasks, Script Tasks, Data Flow Task, Execute SQL Task, Oledb Source, Oledb destination, Derived columns, Look up tasks, Excel Source, Flat File Source and Conditional Splits.
• Created Blob Containers for file uploads and downloads.
• Created Pipelines, Linked Services and Datasets using Azure Data Factory
• Written various T-SQL Queries, Stored Procedures, views for accessing data from the SQL Server 2017
• Monitored the SQL Jobs and Production Support
• Resolving the Help desk tickets daily.
• Design and development of the web application using Angularjs and MVC
• Developed the Rest based Web API controllers.
• Unit Testing & Bug Fixing.
• Created the various Power BI reports, Excel Reports
• Written MDX queries
• Package deployments in SSIS using Environmental Variables.
• .NET application deployments in Azure using profiles

Confidential

Software: SQL Server, Power BI, C#.NET, WEB API services

Full Stack Developer (SQL BI & .Net)

Responsibilities:

• Developed T-SQL Queries, Stored Procedures, views for accessing data from the SQL Server 2014
• Monitored Daily Evaluation SQL Job (Console application) for the performance and response time of Confidential
• Created the Power BI reports for Traffic monitoring the Number of Questions Hourly/Daily/Weekly/Monthly and its performance.
• Created the Knowledge graphs with Entities on Azure machine learning for various categories
• Created the User Queries Dataset from AMLChatBot (telemetry) for azure machine learning
• Design and development of the web application using Angularjs and MVC
• Developed the Rest based Web API controllers.
• Involved in Bug Fixing.

Confidential

Software: SQL Server, Power BI, .NET Framework 4.5, C#.NET, Angularjs

Senior Software Engineer

Responsibilities:

• Developed T-SQL Queries, Stored Procedures, views for accessing data from SQL Server
• Involved in the design and development of application (SQL backend and front end)
• Developed reports in Power BI & Excel to analyze and present data
• Developed the Web API Services using Entity Framework, LINQ and SQL Server
• WEBAPI2 services have been created to upload and download data from database and from sharepoint servers
• Involved in enhancements and Bug Fixing.

Confidential

Software: .NET Framework 4.5, MVC, C#.NET, Entity Framework, Web API

Senior Software Engineer

Responsibilities:

• Involved in Requirement gathering, development and unit testing.
• Responsible for a team of four members
• Experienced in Agile Scrum
• Extensively used Entity Framework and AngularJS
• Developed the Rest based Web API controllers
• Developed Classes against business rules using C# that incorporates both MVC architecture and database connectivity
• Performance tuning, best code review practices
• Developed packages for ETL
• Prepared Technical specs and database schema.
• Involved in Unit Testing and Bug Fixing

Confidential

Software: .NET Framework 4.0, ASP.NET, C#.NET, VB.NET, MVP, MVC, Crystal Reports and Oracle

Senior Software Engineer

Responsibilities:

• Developed Windows Forms, Web Forms for various applications
• Extensively used crystal reports and migration of VB6.0 applications to .Net VS IDE 2010 with VB.Net
• Wrote Triggers, Views, Stored Procedures and Packages in Oracle 10g and T-SQL
• Migration of Windows Applications to .Net VS IDE 2010 with VB.Net
• Involved in development of Web Forms, Classes using C# that incorporates both N-tier architecture and database connectivity
• Performed FxCop Analysis
• Prepared Technical and Functional specs
• Involved in Unit Testing and Bug Fixing

Confidential

Software: .NET Framework 3.5, ASP.NET, C#.NET 3.0, WCF, AJAX, SQL Server 2005, LINQ & SSRS Reports

Software Engineer

Responsibilities:

• Developed Windows Forms, Web Forms for various applications
• Extensively used crystal reports and migration of VB6.0 applications to .Net VS IDE 2010 with VB.Net
• Migration of Windows Applications to .Net VS IDE 2010 with VB.Net
• Involved in development of Web Forms, Classes using C# that incorporates both N-tier architecture and database connectivity
• Wrote Triggers, Views, Stored Procedures and Packages in Oracle 10g and T-SQL
• Performed FxCop Analysis
• Prepared Technical and Functional specs
• Involved in Unit Testing and Bug Fixing

Confidential

Software: .NET Framework 2.0, ASP.NET, C#.NET, XML and SQL Server 2005

Software Engineer

Responsibilities:

• Done everything from User Interface layer to Database layer which includes creating entities, View objects, Request handler, Business layer, Data layer and stored procedures
• Designed the web pages using Ajax and written client side validations using JavaScript
• Involved in creating the prototypes and requirements specifications by understanding and analyzing the requirements
• Used Sql Data Adapters & Datasets extensively for database activity
• Development work to meet acceptance criteria using Agile
• Written stored procedures, triggers using SQL in SQL SERVER 2005
• Co-operating with the team to resolve the issues
• Performed Unit Testing and Bug fixing