15 years of experience of Software Design/Development including SQL and ASP.Net core and MVC development & Database Performance Tuning, CRM Practice and Product Management. Leading CRM Application (Cloud Based) for 2 large enterprise customers in Canon India & Singapore Mapping client requirements with CRM application functionality; identifying creative work around when necessary or customizations/custom development. Served in key positions as an Architect and Consultant for Relational Database, Business Intelligence and Analytics for multiple large and complex enterprise programs Experience in Project Management, System Analysis, Software Development, Team Management, end-to-end development of software products from project initiation, planning, executing, monitoring & supporting and closing. Expert in optimizing performance of various long running queries and stored procedures using SQL Profiler and Database tuning wizard, Query Analyzer and Index Tuning. Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/work flows to extract data from Heterogeneous sources and load into various Business Entities.
AWS Automation: Implemented Automation agile methodologies in AWS for Build, maintain, and scale infrastructure for Production, QA, and Dev environments with CI/CD tools and processes. Operating Systems: Linux, Windows Server. Continues integration and Continues Deployment (CI/CD) using AWS Code Pipeline (AWS Code Build, AWS Code Deploy) with GIT Hub as version control system and Elastic Bean Stalk.
Education
MCA (2016) from Arunachal University of Studies.
DNIIT(2000)
B.Com (1999)
10+2(1996)
Work Experience
Since Jan-2018 with Quick link Consultancy Pvt Ltd.
Growth Path:
AS a Technical Project Manager
Project: Ajman Public Transport Corp. (UAE) Technologies : ASP.net MVC, C#, SQL Server 2012/Couch based DB
Project Summary: Ajman GO is a proposed Customer Relationship Management (CRM system) for Ajman Public Transport Corporation. It provides functionality to manage report on and analyze all Ajman PTC relations and interactions with existing and potential customers, with the goal of improving customer service relationships and assisting on driving happiness to the customers.
Roles & responsibilities
Handling team to use existing infrastructure to achieve Maximum benefit to reduce cost and maximum performance. Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters. Creating Technical Architecture, Database Design, Coding, Testing, Deployment, Post Production Support. Implemented Infrastructure Automation agile methodologies in AWS for Build, maintain, and scale infrastructure for Production, QA, and Dev environments with CI/CD tools and processes. In Windows server. Conducting periodical code reviews, process improvement meeting and peer-to-peer testing Support Activities - Maintenance and enhancement of applications Interfacing with Business, and other client teams for clarification on requirements. Status updates, escalates issues and facilitates resolution Participate in Knowledge Sharing sessions and code walkthrough Fast track Change Request resolution Project Management process Handling Global Team (India, UK and Bahrain)
Previous Work Experience
Nov-2014- Jan2018 with Canon India Pvt. Ltd.
Growth Path:
As a Assistant Manager Application IT
Project: PEP. (INIDA) Technologies : ASP.net, C#, SQL Server 2012/SSRS
Project Summary: PEP, (Partner Excellence Program) is an integrated web based Partner Management solution both for our Partner & Sales force to log Sales Order, Manage Stock & Sales, retrieve Secondary Sales etc. A multiple reporting hierarchy is formed from partner’s reports to Canon Sales Hierarchy. Sales and Stock Module contains Opening stock, sales update, sales report, stock report etc. are manage between dealers and their sub-dealers (CEP). Schemes settlement reflects the different schemes launched for the dealers, a helpdesk link is provided where Dealers/Partners can raise their queries which subsequently handled by the help desk agents. This portal enables both our Partners and Sales force to streamline and execute their sales effectively.
Project: MLZ. (INIDA) Technologies: ASP.net, C#, SQL Server 2012/SSRS.
Project Summary: PEP, (Partner Excellence Program) is an integrated web based Partner Management solution both for our Partner & Sales force to log Sales Order, Manage Stock & Sales, retrieve Secondary Sales etc. A multiple reporting hierarchy is formed from partner’s reports to Canon Sales Hierarchy. Sales and Stock Module contains Opening stock, sales update, sales report, stock report etc. are manage between dealers and their sub-dealers (CEP). Schemes settlement reflects the different schemes launched for the dealers, a helpdesk link is provided where Dealers/Partners can raise their queries which subsequently handled by the help desk agents. This portal enables both our Partners and Sales force to streamline and execute their sales effectively.
Roles & responsibilities
Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters. Creating Technical Architecture, Database Design, Coding, Testing, Deployment, Post Production Support. Implemented agile methodology in team. Conducting periodical code reviews, process improvement meeting and peer-to-peer testing Support Activities - Maintenance and enhancement of applications Requirement gathering, analysis and estimation. Database design, worked on SQL complex query, indexes and performance tuning. Efficient in T-SQL e.g. creating table, view, Index, stored procedure, function, trigger etc. Created SSIS Packages using Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task, lookup etc.
May-2008-Nov-2014 with FCS Software Solution Ltd., Noida
Growth Path:
As a Project Lead
Project: Canon PrintEaze Technologies : ASP.net, C#, SQL Server 2008
Project Summary: PrintEaze is a comprehensive solution that lets you control the printing, copying, faxing, and scanning costs in Indian SMEs the solution is designed to help organizations control their printing cost. It does that by allowing you to define the cost of printing for various types and sizes of documents, and then setting the maximum cost limit per user or group, with automatic email alerts if they exceed a particular threshold. For instance, you can define that users in the accounts department are not allowed to take prints of more than Rs. 50 per user, with an automatic email alert at Rs. 45. Further still, you can do even more fine-grain control by breaking up that cost by color and size of printing. Roles & responsibilities
Analyze, design, coordinate and supervise the development of software systems. Installation and Configuration of SQL Server. Involved in coding and development SQL server - Creating SSIS package, table, views, SP’s, managed performance of SQL queries, responsible for analysis of current programs including performance, diagnosis and troubleshooting of problem programs, and designing solutions to problematic programming. Develop SQL complex query, stored procedure and index’s performance tuning. Developed complex SSRS reports as per client requirement. Review and repair legacy code.
May -2007- May-2008 with Portion info System Pvt Ltd., Noida
Growth Path:
As a Sr. Software Eng.
Project: Energy Technologies : ASP.net Core, C#, SQL Server 2008
Project Summary: It is a solution based on CRM web environment developed in .Net, SQL Server 2000 as backhand. Sync patient inquiries and appointment requests from all your awareness campaigns. This includes - external partners all over the web , referral partners, like doctors, diagnostic centers, pharmacists & others, online channels, like PPC ads, social media, website etc., and traditional channels, like newspaper ads, billboards, TV ads, events etc. Assign patients to different centers, clinics or doctors based on patient's location, preferences, condition and doctors' availability and specialty. The calls get directly routed to the relevant front-desk, reducing patient wait-time and improving relationships.
April-2004 – May 2007 with In Net IT & Telecom, new Delhi.
Growth Path:
As a Software Eng.
Project: Telecom Projects for MTNL and BSNL. Technologies : ASP, SQL Server 2000
Personal Details Date of Birth: 24th Dec 1977 Languages Known: English & Hindi Address: 906, G.F, sector-1,Vasundhara, Ghaziyabad-201012, Uttar Pradesh