SUMMARY:

• A technocrat with 7+ Years of Experience in Analysis, Design, Development and Implementation of various stand - alone and Web Based Software applications using Microsoft Technologies.
• Expertise in relational database design, data extraction, transformation, writing procedures, functions, triggers from large and complex data sources using MS SQL Server (SQL, T-SQL).
• Responsible for the management of the database performance, backup, replication, capacity and security.
• Experience to create, modify, maintain and optimizing SQL database.
• Experience in supporting database maintenance plans, backup/restore, validating the availability of database.
• Experienced in ASP.NET, .NET Framework 4.5, AngularJS, D3, Ajax, CSS, C#, MVC, Web Services, WCF, LINQ, Silverlight, Windows Phone and Windows 8 modern apps.
• Experienced in Power BI, SSIS, SSAS, SSRS, Java Script, IIS 10/9/8, HTML, XML, Database queries, Stored Procedures, Views, Functions, SQL server tuning, and Triggers Using SQL 2014/2012/2008.
• Hands on experience in Azure technologies including Azure Data Lake, Azure Blob storage and Azure Data Factory. Various kinds of ETL using Azure data factory (ADF).
• Hands on experience in design using Object Oriented Programming Principles like Inheritance, Polymorphism and Design patterns like Singleton, MVC a standard solution to common problems in software design.
• Developed dynamic ASPX pages for Application using ASP.NET MVC 3, C#.NET, HTML and JQuery.
• Extensively involved in developing components for Business and Data tier usingC#.NET, ADO.NET and involved in creating controllers to handle the events raised on the Razor views in ASP.NET MVC 4 framework.
• Very good experience in WPF. Developed many complex UI pages using XAML and WPF.
• Hands on experience in Cosmos platform. Developed complex scope scripts for ETL work.
• Having very good work experience in developing applications using nHibernate.
• Experienced in developing Big data applications using technologies like Spark, Pyspark, Hive and Sqoop. Submitting spark scripts to Spark cluster using Livy API.
• Proven ability to work in both in an individual role as well as in cross - functional teams.
• Possess good technical acumen, oral & written communication, analytical and interpersonal skills.
• Experienced in deploying the Azure hosted web services and Azure Websites.
• Proficiency in software development life cycle (SDLC) for development process and AGILE, SCRUM and Waterfall methodologies of development process such as Requirement Collection, Analysis, Design, Coding, Testing, Implementation and Maintenance.
• Experience in developing SSIS packages and Cubes.
• Interacted with business analysts and translated business requirements into technical specifications in terms of dimensions and account measure.
• Skilled in installations, upgrades, and configuration procedures in client/server environments.
• Thorough understanding of multidimensional and relational database architecture and their applications for effective planning and forecasting procedures

TECHNICAL SKILLS:

Programming Languages: C#, XAML, JavaScript, HTML, CSS, XML, SQL, TSQL and Python

Reporting Tools: Microsoft Power BI, SQL Server Reporting Services

Databases: MS SQL server (2008 - 2016)

Operating System: Windows 10/8/8.1/7, Windows XP, Ubuntu

Project Management Tools: Microsoft Visio (2000 - 2016)

Technologies and Framework: .NET Framework (4.1-4.5.1), Angular JS, Microsoft Azure, ASP.NET, MVC, WCF, WPF, ADO.NET, AJAX, jQuery, Silverlight, Crystal Reports, SSIS, SSRS, IIS 6-10, LINQ and Web services/ Web API s

Development Methodologies: Agile development, Scrum and Waterfall

PROFESSIONAL EXPERIENCE:

Confidential

.Net and Big Data Developer

Responsibilities:

• Business requirement analysis and discussion with team.
• Developing the API by coordinating with offshore team and guiding them according to the requirements.
• Coordinating with the team to have clear insight of the underlying business process and developing functional requirement, Understanding documents. Distribute the tasks to offshore team and make sure to complete the tasks within the timeline.
• Regular code check-in and Code review.
• Building Test Cases and Test Data, Unit Testing, Performance testing.

.Net and Big Data Developer

Responsibilities:

• Business requirement analysis and discussion with team.
• Meeting with the customer to get the clarified information on the requirement.
• Coordinating with the team to have clear insight of the underlying business process and developing functional requirement, Understanding documents. Divide the tasks to offshore team and completed the tasks within the timelines.
• Preparation of High-level design and low-level technical specification document for development.
• Developing the Business Requirements provided by the customer with all the business and data validations
• Used pyspark API to implement the login and do transformations.
• Develop and Monitor multiple pipelines in Azure data factory.

Lead .Net Developer

Responsibilities:

• Business requirement analysis and discussion with team.
• Meeting with the customer to get the clarified information on the requirement.
• Coordinating with the team to have clear insight of the underlying business process and developing functional requirement, Understanding documents. Divide the tasks to offshore team and completed the tasks within the timelines.
• Preparation of High-level design and low-level technical specification document for development.
• Developing the Business Requirements provided by the customer with all the business and data validations
• Implementing the UI using latest D3 controls and Angular JS.
• Implemented complex dynamic SQL queries using proper joins and views and created indexes to increase the query performance.
• Responsible for investigating the cause of production issues and took appropriate action to fix them.
• Verified the query performance and fine-tune it.
• Created user defined functions and stored procedure in SQL server.
• Preparation of unit test cases and execution.

Lead .Net Developer

Responsibilities:

• Business requirement analysis and discussion with stakeholders Development of High level design
• Develop web pages on MVVM platform using XAML and WPF technology.
• Designing UI pages based on the UI mockups provided by UX team.
• Create and modify tables, stored procedures, various clustered and non-clustered indexes, triggers, check constraints and functions.
• Building Test Cases and Test Data, Unit Testing.
• Performing Load Test, Backend Failure Test and Memory Leak Test.
• Issue fixes of existing processes under proper service level agreement.
• Implementing new enhancements in the existing functionality meeting given timelines and with agreed service levels.
• Implementing Quality Standards as per IQMS standards. This system provides guidelines for the conduct of every project and the means for monitoring it. It integrates the various internal processes and intends to provide a process approach for project execution.

Lead .Net Developer

Responsibilities:

• Develop a responsive web site so that it could fit into different devices for example Tablet, Mobile and Normal PC with different screen resolutions.
• Business requirement analysis and discussion with team.
• Joining the customer call with team to get the clarified information on the requirement.
• Coordinating with the team to have clear insight of the underlying business process and developing functional requirement, Understanding documents
• Preparation of High-level design and low-level technical specification document for development.
• Developing the Business Requirements provided by the customer with all the business and data validations
• Implemented SQL queries using proper joins and views and created indexes to increase the query performance.
• Responsible for investigating the cause of production issues and took appropriate action to fix them.
• Verified the query performance and fine-tune it.
• Created user defined functions and stored procedure in SQL server.
• Preparation of unit test cases and execution.

.Net and SQL Developer

Responsibilities:

• Business requirement analysis and discussion with manager about the reports.
• Analysis of the requirements and providing estimation.
• Planned, designed and implemented SSAS Tabular cube and required set up for this project.
• Implemented different stored procedures required to pull the information from the upstream sources and making the required changes.
• Create and modify tables, stored procedures, various clustered and non-clustered indexes, triggers, check constraints and functions.
• Implementing new enhancements in the existing functionality meeting given timelines.

.Net and SQL Developer

Responsibilities:

• Have a Reliable China Ops BI report for the China LT team
• To reduce workload /manpower, increase efficiency for accurate and reliable data
• Automate the data extracts from the multiple applications into a centralized database.
• Automate the deals status update for each deal through linking the data sets as much as possible
• Business requirement analysis and discussion with stakeholders Development of High level design.
• Interacting with the customer for requirements and related clarifications.
• Coordinating with the team to have clear insight of the underlying business process and developing functional requirement, Understanding documents.
• Interacting with onshore on the provided customer requirements and related clarifications.
• Developing the Business Requirements provided by the customer with all the business and data validations.
• Created, tested, performance tuned and implemented stored procedures and queries in Microsoft SQL Server.
• Created simple and complex views and functions using SQL Server 2012.
• Designed SSIS packages to load data from different source files to SQL Server data base tables.
• SQL Agent jobs creation.
• Deploy the web site to IIS and make the site available to restricted members.
• Supporting for the development on TEST, UAT and PROD phases.

.Net and SQL Developer

Responsibilities:

• Working as SSIS and SSAS developer for new enhancements.
• Involved in the DB development and SSIS packages deployment for new enhancements.
• Writing stored procedures, functions using T-SQL
• Involved in Creating Email templates through backend for various client requirements.
• Involved in Designing of Database.
• Created KPI’s, calculated measures and SSAS cube maintenance
• SQL Agent jobs creation
• Create SSIS packages to backup, restore databases, and use notification services for availability of databases.
• Functional Specifications and Technical specification creations for new change requests
• Deployment guide preparation for the Deployment team
• Team foundation server utilization

.Net and SQL Developer

Responsibilities:

• Analysis of the requirements and providing estimation.
• Design new GUI for the application.
• Development of new process.
• Building Test Cases and Test Data, Unit Testing
• Performing Load Test, Backend Failure Test.
• Issue fixes of existing processes under proper service level agreement.
• Implementing new enhancements in the existing functionality meeting given timelines and with agreed service levels.
• Supporting customer ad-hoc requests, Test and UAT environment support.