Sql Server Developer

MD HARIS UDDIN SHARIF

Woodlawn, Baltimore, MD ***07

SENIOR WEB DEVELOPER

Email: ****.*******@*****.***

Phone: 410-***-****

Active: Public Trust Security Clearance

Excellent C#.NET developer and strong systems analysis skill with 8+ years of hands-on experience in working with Microsoft Azure as the key driver behind a variety of web application design and development projects. Expert client consultant able to work with customers to understand their requirements and design leading-edge applications and systems that provides enhanced features and functionality. Proven history of significantly reducing cost, time and effort by automating manual process through technology functions. Excellent testing and troubleshooting skills, able to quickly identify and eliminate the root cause of bugs and performance issues.

Software Engineering Web Application Design & Development Technology Integration Requirements Management Client Consulting Object Oriented Design Coding & Debugging Problem Solving Front-End Architect Design Application Testing Technology Support Technical and Functional Specification

Languages: C#, VB.NET, ASP.NET, Java, C, PHP, JavaScript, Oracle9i

Web: ASP.NET Framework 3.5, 5, Oracle 9i, Visual Studio 2008/2012/2013, SQL Server 2005/2008, PHP, MySQL, JavaScript, jQuery, AJAX, Angular JS, CSS3, HTML5, DHTML, XML,WCF,LINQ.

Databases: Oracle 9i, SQL Server 2005 / 2008, MySQL, T-SQL

Tools: MS Visual Studio 2010/2012/2013, Macromedia Dreamweaver 8, Adobe Dreamweaver CS5, Crystal Reports XI, Adobe Photoshop CS3, StarUML, Visual Paradisiam, Notepad, Wire shark, Net Beans, Eclipse, Scrum (Rally), VISIO

Servers: Apache Glassfish, Tomcat, Wampp, Xampp

Frameworks: jQuery, MVC 4/ MVC 5 (Razor), Entity Framework (.NET3.5/4.0) 6, Spring-Hibernate (Java), Angular JS

Platforms: Windows XP / 7 / Server 2008, Linux

Design Patterns: Integrator • Observer • MVC • Composite • State • Strategy • Singleton • Facade • Mediator • Factory SDLC: Waterfall • Iteration • Agile

Testing QA, N Unite Testing, X Unite Testing, Performance Testing (Load Runner, J. Meter).

Certifications: MCP, MCSA

PROFESSIONAL EXPERIENCE

Title: Senior Web Developer: at Baltimore City Office of IT, Baltimore MD Feb ‘2017

Reliable Software Resources, Inc., USA

Responsibilities: It’s a Baltimore City, Maryland tax credit PILOT application. More than 500 applicants use this application for their credit application; evaluate credit, availability, application process.

Responsibilities:

• Worked Queues, Blobs, and Containers to persist data on Azure Implemented Azure APIM modules for public facing subscription based authentication

• Experience in creating and configuring Azure Virtual Networks (Vnets), subnets, DHCP address blocks, DNS settings, Security policies and routing.

• Created Web App Services and deployed Asp.Net applications through Microsoft Azure Web App services.

• Involved in full Software development life-cycle (SDLC) followed by agile methodologies to produce high quality software model using N-Tier Architecture

• Gathered the requirement and written the Use case for the requirements

• Developed and consumed WCF Services for building Application server components

• Successfully developed web forms in ASP.NET using C# language

• Extensively used the Object Oriented Concepts in building the Application (Inheritance, Polymorphism, Data encapsulation, Abstraction, Aggregation, Association, and Generic Collections)

• Developed database access components using the ADO.NET Entity Framework and utilized LINQ to Entity.

• Responsible for writing the code in Microsoft Visual Studio.Net 2010 with ASP.Net using code behind C# and VB.NET & tested with NUNIT.

• Create ASP.NET Web API Services, WCF Services for Site Core HTML content caching.

• Used Data Grids, Data Sets, Data Views and Data Adapters to extract data from SQL Server 2014/2012

• Developed Database including schema design, T-SQL queries, stored procedures, views, Triggers and ensuring set up relations which included indexing, constraints, foreign keys etc., for SQL server 2012 and 2014.

• Used ASP.NET AJAX Toolkit controls like Script Manager, Update Panel and Timer in some web pages.

•Used Windows Communication Foundation (WCF) to connect the front end to the database.

• Transferred all data into SQL Server from different data sources using SSIS/ETL.

• Developed link reports, sub reports, standalone reports with SSRS and integrated with ASP pages.

• Hands on experience in using the xml serialization provided by .net.

• Involved in handling ASP.NET client side state management (view state, cookies and query strings) and server side state management (application state and session state)

• Automated and scheduled the Informatics jobs using Control-M and monitored the application submitted by finance team through Baltimore City Finance Department.

• Resolved and helped in production issues/deployment.

• Developed and maintained windows application utilities to verify the inbound data in XML and to create the automated SQL scripts.

Environment: Visual Studio.NET 2010/2015, AZURE CLOUD, Bootstrap, jQuery, Angular JS, MVC5,ASP.NET 4.5,ADO.NET,XML Web Service, AJAX, C#, T-SQL, LINQ, Entity Framework, WCF, UML, CSS, JavaScript, SQL Server 2008, Team Foundation Server(TFS),VSS

Title: Subject Metter Expert of SCCM: at Social Security Administration, MD

Sep ‘2015 to Feb ‘2017

Ctel Inc., USA

Responsibilities:

• Responsible and active in the analysis, definition, design, implementation, management, and deployment of full software development life cycle of project and Migration, Deployment.

• Writing the Stored Procedure and SQL queries for SSRS report.

• Created Integration Services SSIS package to import raw data from MS Excel to the SQL Server.

• Extensively involved in developing components for Business Layer and Data Layer.

• Developed customer facing web application using ASP.NET 4.0 C# and convert to XML data file.

• Developed a new WCF service to get the information from the database. Worked on Data contract, operation contract, service Contract, Endpoints, binding etc.

• Used Microsoft SQL Server for creating T-SQL Stored Procedures, Views, functions and Indexes

• Require the need to remotely access devices on SSA's network to manually install required SSA application that may have failed via CM2012 and check CM2012 client configuration issues and make required changes when needed. Also tasked with the follow-up on CAPRS tickets assigned to CSSMT.

• Microsoft SQL query and Development of SSRS report using Microsoft SQL Server Reporting Service for internal application.

• Building, configuring, managing, and troubleshooting software distribution infrastructure.

• Systems Management Software (SMS) and System Center Configuration Manager (SCCM).

• Installation non-successful software (includes failed/ missed/incomplete client health)

• Support and troubleshoot SCCM 2007 R3 and 2012 site-to-site package distribution, clients, and site backup and disaster recovery methodology.

• Resolve Client operation issues, Prepare and execute the To-be-Model workflows. Install, uninstall and re-install the SCCM 2007 R3 and 2012 clients when necessary.

• Confirm that the SCCM clients perform for client policy, Hardware inventory, Software inventory, Status messages

• Document Client and software deployment stats, Verify Client status and Health Manager

• Created Inbound and outbound WCF Services to integrate with support applications using C#.Net.

• Monitoring the database performances, debugging the web services and client applications using Ignite database monitoring tool.

• Created Windows communication foundation WCF Services using SOA and consumed it in client application.

• Created most of the data models, Business services and repositories in the application.

• Providing expert, independent support and leadership by coordinating, producing, or reviewing processes and documentation on complex issues, such as systems design, architecture, feasibility studies, system specifications reflecting detailed knowledge of technical areas as identified in task order requirements.

• Developed through the W3C process in cooperation with individuals and organizations using Web Content Accessibility Guidelines (WCAG).

• Involved in Design and Development of the User Interface using WPF, XAML, VS2013, Expression Blend

Skills Used : Visual Studio 2013/15, .Net Framework 4.5, C#, HTML/XML, WSDL, ASP.NET, MVC, TFS, JQuery, JavaScript, JSON,WCF Service, LINQ, SQL, SSRS, HP Service Manger(CAPRS), Ignite8.0, System Center Configuration Manager (SCCM).

Title: .NET Developer September ‘2014 – April ‘2015

Canopy One, USA

Responsibilities:

• Working in Agile Methodologies for rapid development and regular adaption to the varying requirements and continuous delivery of the working software.

• Expertise in developing applications using Microsoft technologies such as .NET Framework 4.0/3.5 Web applications using ASP.NET, and distributed applications using WCF, XML Web .

• Experience in Writing code and debugging skills with ASP.NET, WCF, WPF, C#, Web services.

• Involved in implementation of Object Oriented Concepts during the development.

• Prepare Technical and Functional Specification for development team review code base on Specification.

• Developing the application using WEB API, MVC5, Entity Data Model and WCF services.

• UI design and creating contracts and classes in WCF for different modules in the application.

• Developed reports using MS SQL Server Reporting Services and Crystal Reports 8.0.

• Implemented UI using WEB API, MVC 5, HTML5, XML, CSS3, JavaScript, Angular JS, AJAX and Bootstrap to create responsive web pages for both mobile and computer app.

• Using Angular JS and JavaScript for implementing client side validations at Controller level.

• Using Angular JS & JSON for dynamic User Interface, retrieval and posting of data.

• Used Team Foundation Server 2008 for Source Code Control, project related document sharing and team collaboration.

• Implemented .Net Security features of Authentication and Authorization using .Net Membership.

• Implemented .Net classes for Business logic Layer using C#.

• Coding and Tuning the queries, stored procedures and functions, Triggers using PL/SQL

• Implemented Data Access Layer using Entity Framework to connect, retrieve and update the data from SQL server.

• Creating Queries and joins on multiple tables, Functions and Triggers using LINQ in SQL 2012 for inserting/updating/ deleting the data into the relational tables.

• Developing various Stored Procedures for the data retrieval from the database and generating different types of reports.

• Involve in object-oriented analysis and design using UML (Unified Modeling Language) such as use case, activity, sequence, class and component diagrams using Visio.

Testing Done of this Project:

• Experience with HP Application Lifecycle Management.

• Written Load Runner Scripts, enhanced scripts with C functions, Parameterized, stored dynamic content in Load Runner functions. Text checks were written.

• Scripting in VBScript using Descriptive Programming technique.

• Created and maintained test plans and scripts, and carried out hands-on testing both manually and using automated test tools to exercise software.

ENVIRONMENT: Visual Studio 2012/13, .Net framework 4.5, MVC 5.0, C#.Net, ADO.net, TFS, Entity Framework 6.0, WCF, SQL Server 2012, RESTful interfaces, Bootstrap, AJAX, XML, JavaScript, Angular JS, JSON, HTML5, CSS3, Angular JS, Crystal Reports. Load Runner, J. Meter, VB Script.

University at MUM: (Academic Projects), USA Jul ’13 to April ‘14

•Java Developer – Student Online Registration and Admission System, Maharishi University of Management: Built a web application allowing online registration, apply for admission, and administration for both end admin and applicant. Implemented diverse based on specific categories and collaborated with staff members on module integration.

•Java Developer – Maharishi Blog Site: Built a nice web application that allowing login as admin, super Admin, general blogger. Blog category wise or as they wish, comments, like, dislike, rating, authentication etc.

•Java Developer – Library Management Software, University of Management: Built a desktop application allowing online book reservation, checkout, and administration for both end users and librarians. Implemented diverse product categories and collaborated with team members on module integration.

Environment: Java, JSP, Springs, Hibernate, Eclipse, WebLogic 10g, jQuery, MVC, Oracle 11g, Angular JS, XML, UML, Web Services, Junit, Servlets, JDBC, SOAP UI, Web Services, JavaBeans, CSS/CSS3, HTML5, DHTML, JavaScript, WebSphere.

Title: Software Engineer at CDIP Oct ’2012 – May ’2013

• Marusho Shinshie Web Portal (PHP): I am a part Development Services team, developing and maintaining SMART (Service Metrics and Reporting Tool) and Service Desk applications. The Organization process approximately 500 tickets per month from 20 Depots and close to 90 stores across the country.

• SexyEatz: is the world’s first-ever social networking site dedicated to bringing together a global community of food lovers and culinary enthusiasts.

• Computer Source: Computer Source Ltd (CSL) is the largest technology distributor of Bangladesh with wide range of IT Products including Dell, Fujitsu, Prolink, Norton, Samsung, Apple and Windows service and systems and so on.

Responsibilities:

• Responsible for the analysis, design, development and support of application systems, Embedded PHP&HTML formatting and JavaScript Validations. Interaction with Remedy Web Services to retrieve store specific information.

• Developed Front end using HTML, CSS. Developed and enhanced Web interactions using JavaScript and frameworks like jQuery. Used command line to write scripts. Used Unit for unit testing

• Used Firebug for tracing, debugging and profiling. Worked with MYSQL database in retrieving the data

• Development, documentation, and maintenance of innovative web-based applications on the portal and premium service platforms. Took Part in Deployment of Code.

Employer: ASKS Feb ’2009 – Sep ’2012

Title: .NET Developer

Project #01 Description: Mother& Child health, Family Planning

Project #02: Online base micro-credit business integration application

Project #03: Aristocrat Garments enterprise web application

Project #04: Human Management and Payment Processing application

Responsibilities:

•Involved in gathering requirements by interacting with the clients and developing GUI /Business tier /Data Access tier design for the web application.

•Extensively used UML in the design process - Use cases, Process diagrams, Sequence diagrams, Class diagrams.

•Used agile methodology for the software development process.

•Created GUI in ASP.Net using .NET controls, C# and writing of common controls (.ascx).

•Designed Data Access Layer (DAL), Business Logic layer (BLL) and other components in C#.Net and also in implementing Business Processes, Abstract factory as part of SIMPLE OBJECT ACCESS PROTOCOL (SOAP).

•Developed application using N-tier architecture. Implemented design patterns and the entire back-end of the application in C#, using various object oriented features like classes, interfaces, inheritance, polymorphism etc and multi-threading.

•Developed web forms using Master Pages, HTML controls and CSS Style sheets for the unique look for the page.

•Created parts of the application using ASP.NET Microsoft AJAX Toolkit controls like Script Manager, Update Panel within some web pages, thus reducing the number of round trips to the server per page and improved user experience.

•Developed the web application using AJAX, JSON, and HTML and performed validation-using JavaScript.

•Experience with Database Programming, designing, modeling and Development using MS SQL Server 2012, MS Access and good experience in SQL (T-SQL), Views and Stored procedures.

•Designed and Scheduled the SSIS packages to migrate data from Excel to SQL Server and Vice-Versa.

•Implemented SQL Server Reporting Service to generate various reports for customers with different rates.

•Used ADO.NET objects like Dataset, Typed Dataset, Data View, Data Adapter and Data Reader for connecting, retrieving and modifying the data in the database.

•Wrote stored procedures, Triggers, Functions, Indexes to improve the throughput of application using optimized queries.

Environment: Windows 2003/2000/XP, .NET Framework 3.5/4.0, VS .NET 2005/2010, SQL Server 2005, C# .NET, ADO.NET, WCF, WPF, Ajax, jQuery, CSS, XSLT, XML, XHTML, Web Services, MVC, JavaScript, SSIS, SSRS, JSON. VB.Net, Bootstrap, CSS3. Load Runner, Performance Center, Quality Center.

EDUCATION

•Master of Science in Computer Science: Maharishi University of Management, Fairfield, Iowa, USA

•Bachelor of Science in Computer Science & Engineering (2009): Darul Ihsan University

PROFESSIONAL CERTIFICATIONS

Microsoft Certified Professional (MCP), 2017

Microsoft Certified Solution Associate (MCSA), 2017

Programming in HTML5 with JavaScript and CSS3 70-480

Developing ASP.NET MVC Web Applications 70-486

Windows Azure and Web Services 70-487

PROFESSIONAL AFFILIATIONS (Publications)

•Publication : International Journal of Computer & Information Technology (IJCIT) : Image processing( Event Detections)

Contact this candidate