Sql Server Project

Masthan PMJ

.Net Developer

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

Contact: +1 -224- 201- 2400

Personal Summary

A multi-skilled software developer with comprehensive experience of designing, developing and deploying architectures for software applications. Possessing a proven ability to lead project teams to successfully deliver agreed upon solutions of the highest quality, often in complex and challenging environments.

Have 12 Years of experience in Analysis, Design, Development, Implementation and Production support of various applications

Worked in Customer location for 5 years in United States of America, executed nearshore based project from LATAM.

Have experience in Managing a Geographically Dispersed Team

Experience with software architecture design methodologies such as Agile and Waterfall model and implementation.

Excellent analytical and problem solving skills and ability to work on own besides being a valuable and contributing team player.

TECH SKILLS

●C#

●Angular 2

●Typescript

●VB.Net/VB

●Web API

●Couchbase

●.Net Core

●Jenkins

●Splunk

●Microsoft SQL Server

●ASP.NET

●Agile Methodologies

●SharePoint 2007/2010/2013

●JSON

●Microservices

●WCF

●ASP

●Automation

●Software Development Architecture

●JavaScript

●JQuery

●Mongo DB

PROFESSIONAL CERTIFICATIONS

Certified ScrumMaster

Microsoft Certified Application Developer

Microsoft Certified Technology Specialist

MapR Certified Hadoop Developer

Understanding the Cassandra architecture

Scrum Product Owner Accredited Certification

PROJECTS

Project: Genesis Support system

Role: Sr Developer / Release and Build Engineer

Duration: Oct 2015 To till Date

Genesis Support system is the e-commerce platform based on MVC, APS.NET for US major e-commerce office supplies store. Genesis Support System aims to provide support to the web sites developed over the Genesis platform predominantly using Microsoft Technologies (.NET, SQL Server, etc.). Fourteen such functional websites built over this platform and rolled out to different business units in US and Europe.

Responsibilities:

●Developing projects for optimizing e-commerce functionalities like SEO,SKU pages, Landing pages and Transactions .

●Developed cache layer based on Microservices using Web API, Couchbase

●Creating and managing branches, defining branching and merging strategies.

●Automating build and deployment using tools like Jenkins, MS Build and PowerShell.

●Facilitating Planning and release meetings.

●Environment management activities like setting up new Agile Trains, issue tracking and resolution in production and QA environment.

●Coordinating with Dev, QA and Project management team during release.

●Worked in creating and implementing system health and monitoring tools like Splunk, Soasta and Dynatrace Keynote.

●Developed Real user monitoring called Site Readiness using .Net and MongoDB

Environment: Visual Studio 2012/2015, Jenkins, Splunk, Soasta, Keynote, Powershell, Mongodb, Couchbase, .Net Core, Web API

Project: Demand Planning and Replenishment Phase I & II

Role: Developer

Duration: Feb 2012 To Sep 2012 /Feb 2015 To Sep 2015

Description:

Demand Planning Replenishment is the primary system for Merchandising planning at US Major Retail store to maintain Forecast and Plan inventory orders. This system was developed in Two Phases with one year gap between each phase. This is MVC based application developed .Net and DB2 as backend. This is used to do Planning and Forecasting can help to predict demand. By analyzing historical demand data for each product, the solution can automatically apply the algorithm that will produce the most accurate forecast result.

Responsibilities:

• Analysis, design, development, testing, implementation, and post-production support.

• Participated in Daily Stand-up meeting.

• Updating Burn-down excel sheet to generate Dash board.

• Created Database Design and Application architecture design

• Devised and implemented packaging and deployment strategy.

• Worked as Onsite coordinator Facilitated meeting between Product owner and Offshore development team.

• Facilitating the daily scrum meetings, sprint planning, sprint review, and sprint retrospective.

• Provide visibility to team impediments/risks and helps eliminate them

• Sharing Weekly dashboard with Stakeholders.

• Worked on Application redesign. Migrated Project to VS 2012, involved in architecture design.

• Working with stakeholders / product owners to prioritize the requirements for sprint.

• Encouraging the team to come up with reusable elements and use the best practices.

• Helped the product owners to come up with set of stories for better understanding for estimate and development.

Environment: Visual Studio.Net 2008/2010/2012, C#,DB2, ERWin, ASP.Net, Web API, IIS 6.0/7.0.

Project: PDX EPS Development and Rollout

Role: Implementation Coordinator

Duration: May 2013 to Jan 2015

The PDX EPS (Enterprise Pharmacy System) Program is an initiative to implement a new enterprise pharmacy system into all pharmacies for US Retailer. The new PDX EPS system will help retailer to stay flexible and competitive in the pharmacy marketplace, improve efficiencies in the pharmacy, and enhance guest safety

Responsibilities:

●

●Worked on Automation of Monitoring activities using Blade Logic and Shell scripting.

●Created/reviewed Java utilities for LDAP monitoring, auto fill validation etc.

●Organized Team Building activities to help the team performing efficiently.

●Facilitated War-Room during the rollout days

●Tracking of Incident from Opening to Closure, with timely communication to business.

●Team Progress Tracking.

●Reviewing SLA performance and recommend corrective action.

●Worked in Incident Management and Problem tracking.

●Preparing Key Operating Procedures, Documents of Understanding and Run Books during Transition.

●Publishing Aging incidents in the Weekly dashboard report and updating the same in Known Error Database and Root Cause Analysis report.

Environment: Unix, Splunk, Java, PDX EPS, Oracle, BMC BladeLogic, Service-now

Project: Business Partner Management -ATG to Spring Migration-BPM

Role: Project Leader

Duration: Sep 2012 To Apr 2013

Business Partner Management (BPM) is a web-based application proprietary to US Major Retail Chain that is part of Partners Online. BPM is a database which houses all Business Partner information at a broader level such as contacts, capabilities, and partnerships.

A Business Partner (BP) is created within the BPM system to represent the business partner’s total perspective of how they are positioned within the retail industry. ATG Rewrite is the rewrite of existing BPM application which is in ATG Framework and Repository DB Interaction to Spring Framework and migrated from Stellant content to SharePoint 2010.

Responsibilities:

●Manage software system development and integration projects through all phases of project life cycle - analysis, design, development, testing, implementation, and post-production support.

●Involved in all the phases of SDLC from Software Requirements Phase to Design, Implementation, Testing, Debugging and Documentation.

●Created Automation Job that will migrate content from Stellant to sharepoint

Environment: Java, Web services (SOAP and RESTful) in web sphere, Spring Framework, SQL, JSP, MQ, Java Batches SharePoint 2010, Visual Studio.Net 2010, C#

Project: SharePoint Development

Role: Tech Lead

Duration: Feb 2011 To Jan 2012

The Core objective of the project is to develop SharePoint portal for US retail chain’s Intranet, Stores and Vendor Partners Online Portals. Microsoft SharePoint 2010 was used as the primary technology for this project. It provides enterprise information including the tools and resources needed to do job. Implemented 6 portals in SharePoint 2010

Responsibilities:

●Manage software system development and integration projects through all phases of project life cycle - analysis, design, development, testing, implementation, and post-production support.

●Involved in all the phases of SDLC from Software Requirements Phase to Design, Implementation, Testing, Debugging and Documentation.

●Created SharePoint 2010 OOB work flows, site pages

●Created and configured various SharePoint Lists and Libraries for information sharing and Document Management within the organization.

●Worked on customized Master Page and Content Pages using SharePoint Designer 2010 to implement consistent look and feel.

●Created InfoPath Forms and integrated with SharePoint Form Libraries with custom content types.

●Customized Publishing pages with Workflows in SharePoint Designer and Visual Studio 2010.

●Performed typical administrative activities such as Backup, Restore, Site Creation, and User Issue Resolution.

●Customized out of the box pages, created Custom Pages, Field Types, Web Parts, Event Receivers, etc. Created Web Service components and integrated them.

●Devised and implemented packaging and deployment strategy.

●Customized SharePoint Sites, developed Visual Web Parts, Custom Workflows, Master Pages, Custom Pages and Feature Packages

Environment: SharePoint 2010, SharePoint Designer 2010,UAG, Visual Studio.Net 2010, C#, CSS, JavaScript, ASP.Net, InfoPath 2010, CSS, MS SQL Server 2005/2008, IIS 6.0/7.0.

Project: Integration CoE- SharePoint Integration

Role: Tech Lead

Duration: Feb 2010 To Jan 2011

Description: The Integration CoE team of US Retail chain is primarily built for creating integration layers between various Systems. ICOE team is responsible for taking the request from various teams and delivers the solution based on the project team requirements. As part of this project we migrated the existing application to SharePoint 2007, we migrated around 20 applications from various tools such as File Maker, Stellent to SharePoint 2007.SharePoint 2007 and InfoPath 2007 is used and the Automation tool for capturing the Project team requirements and transform it to workflow . As a SharePoint Developer working on the development of ICoE Automation workflow application, which provides ICOE services team, programs and policies at one place. This Project is executed in Agile Methodology.

Responsibilities:

• Manage software system development and integration projects through all phases of project life cycle - analysis, design, development, testing, implementation, and post-production support.

• Helped proposals in response to RFP and win new contracts for Implementing workflow using Microsoft SharePoint based Solution. Manage multiple contracts and negotiate new teams for contract extension.

• Involved in Analyzing existing application and migration to SharePoint 2007.

• Involved in all the phases of SDLC from Software Requirements Phase to Design, Implementation, Testing, Debugging and Documentation.

• Customized out of the box pages, created Custom Pages, Field Types, Web Parts, Event Receivers, etc. Created Web Service components and integrated them.

• Devised and implemented packaging and deployment strategy.

• Customized SharePoint Sites, developed Visual Web Parts, Custom Workflows, Master Pages, Custom Pages and Feature Packages.

• Participated in Daily Stand-up meeting.

Environment: SharePoint 2007/2010, SharePoint Designer 2007/2010, Visual Studio.Net 2008/2010, C#, CSS, JavaScript, ASP.Net, InfoPath 2007, CSS, MS SQL Server 2005/2008, IIS 6.0/7.0.

Project: Enterprise Pricing

Role: Sr Programmer

Duration: July 2009 to Dec 2009

Description: EPR provides new and improved pricing capabilities that allow merchandising departments to maximize sales and margin through better price management. These capabilities will improve regular Price Administration and Price Monitoring functionality. 1) Price Administration - Functionality that supports the management of Pricing Parameters, Price Configuration, and Retail/U&C Price Calculations. 2) Price Monitoring - Functionality that supports the management of Price Analytics Scope:

-EPR is a J2EE application that has the User interface to administer and Monitor the Prices. We have another application Called Red Rock which needs the Price information for the Pharmacy product. Red Rock is a .Net Application

-The Scope of .Net in EPR is to develop a Component for the RedRock .Net application and a WCF Web service for the J2EE application.

Responsibilities:

• Involved in all the phases of SDLC from Software Requirements Phase to Design, Implementation, testing, debugging and Documentation.

• Created proto-type of the application for demo before developing the application.

• Developed web based application using ASP.NET, C#, ADO.NET, SQL Server 2008, IIS, Visual Studio.NET 2008, Windows XP

• Interacting with the Users to collect the requirements and translating Functional Requirements to Technical requirements.

• Implemented Impersonation to give role based access to application.

• Developed Web forms, Presentation layer, Business layer and Data layer for various modules in the application

• Developed Web Services for gathering of the requirement specifications from the customer

• Invoked in the design of the database for respective modules and developed Stored Procedures and Triggers using TSQL.

• Involved in Project Management related activities

• Actively involved in implementation of quality standards in the projects.

• Responsible for adhering to quality process and procedures in the projects.

Environment: ASP.NET, C#, ADO.NET, XML, XSL, IIS, UML, Visio, Team Foundation Server, MS SQL Server 2008, Visual Studio.NET 2008, Windows XP.

Project: Merchandising Presentation Department-Assortment Analysis

Role: Programmer

Duration: Dec 2008 To Jun 2009

Description: Assortment Analysis is aimed at developing cluster level ranked list assortments to match the guest shopping patterns in major US Retail stores

Scope of Assortment Analysis:

– Develop an assortment analysis tool that generates ranked list of assortment and reporting to support cluster/store level review. Develop a “FIT” application & business process to integrate assortment analysis and POG (Prospace) information.

– Develop an assortment analysis tool that helps to create an assortment request based on predefined selection criteria

– View the Sales historical metrics for the assortment request selected.

– Ability to Perform Future Forecast Analysis at the Chain, Cluster Group and Cluster Levels.

– Ability to add new items, model items and exclude Non-Carry forward items from Assortment

– Generate ranked list of items based on a primary weighing objective that includes Sales $ and Gross Margin

– Ability to specify that the assortment at the Chain/Cluster Group/Cluster level is ready for POG Generation.

Responsibilities:

●Designed and developed ASP.NET web pages.

●Created stored procedures and triggers to implement the business logic.

●Maintain a consistent look-and-feel of the application.

●Created classes and modules in C#.

●Ensure compliance with all reporting and portfolio management regulatory requirements, as identified during the requirements phase of the project.

●Created Custom membership provider for Forms Authentication.

●Configured web.config and Global.asax files.

●Created SQL stored procedures in SQL Server database.

Environment: C#, ASP.NET, ADO.NET

Project : Merchandising Presentation Department-System Enhancement

Role: Developer

Duration: May 2006 To Nov 2008

Description: The scope of this project is to improve the efficiency of Planogram save process by converting the existing VB application into .net and introducing concepts such as multithreading. Several windows based applications are developed in order to load and save the Planogram.

System Enhancement 1:

– The purpose of this project is to eliminate the SQL Server dependency on Deferred Save process for BOM & AFC Calculations

– Primary advantage is that the SQL Server tables are eliminated. Time consuming logic involved in concatenating the attributes of Prospace objects (for all Prospace objects) and splitting it again in SQL Server stored procedure is eliminated.

– Time consumed in round trips (involved in executing a stored procedure and returning null record set for non-existing fixture types of the planogram) is eliminated.

– The new design comprises of calculating BOM only for those fixtures that exist in the Planogram.

System Enhancement 2:

– The purpose of this project is to eliminate the prospace dependency on Deferred Save process.

– Time consuming logic involved in concatenating the attributes of prospace objects (for all Prospace objects) is eliminated and the Data are queried from DB2.

– Multithreading Concept is Introduced in Db2Flat (Application To load Planogram from Prospace)

System Enhancement 3:

– Conversion of the existing VB Application Such as Deferred Save and AutoChk Process to.Net.

– Introducing MQ in the Save Process.

– Multithreading Concept is Introduced in Request Processing Application. Hardware IBM 3090, Pentium Workstation, OS/390

Responsibilities:

●Created the Sequence Diagram / Class Diagram.

●Code Development.

●Tracked the defects and fixed the code issues.

Environment: VB.NET, ASP.NET, ADO.NET, SQL Server 2000, and Windows 2000

Project: Digital Image Capture and Delivery System

Role: Developer

Duration : Nov 2004 to March 2006

The DICADS (Digital Image Capture and Delivery System) application speeds up the process of transferring documents among different geographic locations with high security based on the Barcode present in the Document. This Process involves Scanner scans the documents and releases to Quality Checker the QC checks for the quality of the scanned images and releases to the network channel depending upon the Barcode Present.

The channel delivers the images to the destination MQ. The Destination is Message Queue which is running in the AIX Box. Listener Program which is developed in Windows Services picks up the message from the Queue, process it and put it in a File Server. These images will then scan by Telefrom (ICR/OCR) System. The data from the images will be extracted by Teleform and Updated to Database and Status of the Request is Changed to Ready. The Data from the Images and the Image will be displayed in the Separate web application. This application will be used by the Data Entry Operator will use this web application to Validate the Data by verifying the Images displayed.

Responsibilities:

• Analyzed the requirements and designed the program flow.

• Designed the solution using .NET Architecture.

• Responsible for the development of the middle–tier of the product.

• Used Visual Studio.NET as the development tool.

• Created the Sequence Diagram / Class Diagram.

• Code Development.

• Tracked the defects and fixed the code issues.

Environment: Microsoft Visual Studio 2005, IBM DB2 V8.0,IBM MQ

EXPERENCE

1.Tata Consultancy Services Limited

Designation: Assistant Consultant

Duration: 2006 May-Till Date

2.HCL Technologies Ltd

Designation: Software Engineer

Duration: 2004 Oct- 2006 April

EDUCATION

Bachelor of Technology in Information Technology from University of Madras,

Year 2000-2004, with First Class and Distinction

Contact this candidate