.NET Lead/Application Analyst

Amol Sahasrabudhe

Summary:

Over **+ years of experience using Microsoft technology .NET - .NET 1.1. to 4.5, ASP.NET, Classic ASP, COM Dlls, C#, MVC, WCF, MVP, JQuery, JavaScript, VB 6.0, OO Concepts, CSS, HTML, DHTML, SQL server 2008 / 2012, Oracle 11g, Exadata, COM +, IIS 5.x/ 6.x/ 7.x/ 8.x, Jboss, Apache tomcat, Oracle APEX, TIBCO-Spotfire, WINDOWS 2003 / 2008 R2 / 2012 R1 / R2

Proficient with handling large teams & managerial skills in IT industry, managing portfolio landscape, finding avenues to reduce expenses (licenses, moving applications to more cost effective environment such as AWS cloud, capacity planning reducing disk space), to align with organizations strategy / objective.

Domain Experience: Oil and Gas, Car Rental, Supply Chain & Telecom

Professional Summary:

-Developed & supported 20 applications with .NET 1.1. to 4.5, ASP.NET, Classic ASP, COM Dlls, SQL server 2k8 / 2k12, Oracle 11g / Exadata, COM +, IIS, Jboss, Apache Tomcat, Oracle APEX, Object Oriented Applications, SOA, Microsoft Visio, TIBCO-Spotfire, HTML, JavaScript, XSLT, CSS, XML, MS FrontPage, IIS Web Server, XML Web Services, Dev Express control, windows vista /7/8/10, WINDOWS 2003 / 2008 R2 / 2012 R1 / R2.

-TFS (Team Foundation Server) Administrator: 2010 / 2012

oManaged users and their access, changeset / shelveset tracking and monitoring, change management merging triggering the builds, pilot and implement new features, clean up users after user is terminated to avoid dead code.

-AWS Cloud Migration specialist (using - Wipro cloud gateway interface)

oMigrated application from current landscape using target operating environment, EC2 & EC2 + SQL & RDS. Worked with solution architects to identify gaps in migration & mitigated the issues. Worked on sizing and capacity planning to optimize the application landscape & collaborated with architects on the Step-out and Step-in plan for the Applications

-SQL App DBA: 2008 R2 / 2012 R2

oRefreshing Non-Production database environments, conducting regular backups & restore to avoid data loss, capacity planning, performance tuning, configure SQL mail notification for jobs, implement change tickets in production environment.

-OLM (Operation landscape manager)

oManage asset approval for upstream production, update the application portfolio management system with correct assets, contact information, line of business & stakeholders. Creating new deployments, release schedules & total cost of ownership for a landscape.

-Assisted in architecting & managed enterprise applications, while still hands on with development.

-Developed .NET applications and managing N-Tier Applications using web technologies

-Implemented securities like authentication and authorization using Form-based & Window-based authentication, authorizing users, roles and user account Impersonation using SQL server and Active Directory

-Expert in developing Windows Service automated jobs using C#, .NET

-Expertise working with tables, table normalization, stored procedures, transactions, triggers, Views, functions

-Ability to work under strict deadlines and to quickly adapt to new environment

-Delivered projected using Agile Methodology and Scrum Works, scrum planning & managed backlogs & sprint release schedules.

-Excellent analytical, communication, team and interpersonal skills, highly motivated, and ability to face a challenging work environment.

-Conducted team meetings to review the status and exchange ideas on process improvements

-Regular interaction with clients for requirement gathering, status updates, change control, reviews, bug fixing, and have always been as a single point of contact

-Implemented and responsible for unit testing, integration test, performance test, load test of the application.

Technical:

Languages : C#, VB6.0, ASP.Net

Database : MS-SQL 2008 R2, 2012 / 2014 Oracle 11 g, Exadata

DWH : SSIS, MS OLAP, MDX queries, Cube Processing

Application Servers : COM+ / MTS, MSMQ

Web Servers : IIS 8.5/ 7.0 / 6.0 / 5.0 / 4.0

Others : Microsoft office automation (Writing Macros)

Miscellaneous : Capacity planning, batch monitoring, process/report automation

OS : WIN 2008 R2 /WIN 2012 R1 and R2, RedHat Linux 6.4

Web tools : XML, XSLT, Java script, JQuery, VB Script, HTML, DHTML, XSD

AWS : IaaS, PaaS, Desktop as a service.

Version Tools : TFS for ALM (Microsoft Visual Studio 2010/2013), VSS

Framework : MVC / MVP and project specific n-Tier framework

Professional Experience:

SHELL Oil (The United Solution Group Inc.) Jan’12 - Till Date

Houston, TX

Roles: Application specialist / SQL App DBA / AWS Cloud Migration specialist / Operation landscape manager / TFS Administrator.

Project: Production and Exploration

Description: Designed, Developed & supported application(s) under the production and exploration portfolio, which involves on-shore dashboards, MIDAS, production dashboards, which displays daily well production, deferments, allocations, well test information to all the stakeholders.

-Cost performance Improvement

oConducted gap analysis & landscape architectural assessment, strategized on migrating the non-productive landscape, moved non-production environment.

oUsing Infrastructure as a service (IaaS) on Amazon web services (AWS) cloud, moved the Non production applications to AWS cloud to improve on cost\performance and scalability

oUsing Desktop as a Service from Amazon web services (AWS) cloud, moved the developer environment to cloud to improve on cost & enabled faster build developer environment.

-Run and maintain (Production Support)

oProblem solving

Resolve tickets (All severities) using HP SM9 and TFS work items for bug tracking

Ad hoc queries on the application (Functional / Design)

oBatch monitoring, bill runs, daily QA, capacity planning / reporting / raising alarms, Ad hoc reporting

-Enhancements

oConduct impact analysis, estimation of the work

oRequirement analysis, tech specs design, writing test cases, coding, testing, UAT, implementations

oCustomer interaction, planning and tracking of the assigned work

Environment: ASP.NET using C#, Third Party Controls, User Interface (GUI), MSOLAP, .NET 4.0, Oracle 11, SQL 2008 R2 \ SQL 2012 upgradeable to 2014, TFS (2010/2012) (Microsoft Visual Studio 2010/2013) for ALM, Project planning resources planning AJAX, jQuery, entity frame work suing Telerik ORM, IIS 7 / 8 using OS WIN 2012 R1 / R2 and WIN 2008 R2

AIG VAIC (Mphasis, an HP Company) Jul’10 – Dec’11

Houston, TX

Role: Tech Lead /Project Lead / SQL App DBA / TFS Administrator

Project: AGILENet Intranet Portal

Description: VALIC (Variable Annuity Life Insurance Company) helps plan for and enjoy a secure retirement. AGILENet Internet portal, VALIC online helps advisors, call centre and business operations.

-Managed the work breakdown structure, identifying resource required for a project, estimated time lines, high level estimate coordinate with various project team, Interacting with Stake holders, understanding Business requirement

-Technical Leadership

oAnalysing various products

oProof of concept

oMentoring team / Building team on new technology

-Conducted Impact analysis, estimation of the work, Review design documents and testing strategy, Requirement analysis, tech specs analysis, Non-functional requirements (NFR)

-Signoff from business and production implementations

-Project Presentation to the steering committee on a weekly basis on the project status & reports.

Environment: ASP.NET using C#, Third Party Controls, MSOLAP, .NET 4.0, User Interface (GUI), Oracle 11, SQL 2008 R2 / SQL 2012 upgradeable to 2014, TFS 2010 for ALM, Project planning resources planning AJAX, jQuery, entity frame work suing Telerik ORM, IIS 7 / 8 using OS WIN 2012 R1 / R2 and WIN 2008 r2.

DTAG: Dollar Thrifty Automotive Group (Mphasis, an HP Company) Oct’06 – Jun’10

Tulsa, OK

Role: SME /Tech Lead /Module Lead

Project: ROC à COCI [Check Out Check In]

Description: “Rent our cars” encompasses the rental agreement process from the legacy system and strives to include all the major functionality (Open RA, Vehicle, Reservation, Charge, Form of Payment) that involves the counter agent. ROC is designed in a way that will allow it to adapt to changes in the business quickly which is built upon Microsoft .NET 3.0 uses server-oriented architecture (SOA), MVP Pattern and Smart client for its offline capability and Rich UI. The presentation layer is built upon Winforms. It uses Janus controls for look and feel. Calls to business layer are encapsulated in WCF wrappers, Validation(s) @ Server and Client.

-Interacting with stake holders, understanding business requirement, Impact analysis, estimation of the work, Requirement analysis

-Conduct a technical specification analysis, writing test cases, Coding, testing, UAT & production implementations

-Performed SQL query tuning for performance improvements

-Client interaction and status reporting

-Planning and tracking of the assigned work

-Encrypting and decrypting the confidential information

-Assigning work to the team.

-Delivering on time

-Client Server / N-Tier architecture

Environment: .NET 3.0, WCF, C#, Win Forms, Oracle 10g, Signature Capture Device, CC Scanners, TFS 2010 for ALM, Project planning resources planning AJAX, jQuery, custom written entity frame work using EDS home grown tools, IIS 7, using OS WIN 2008 R2 using N-Tier architecture

Telstra (EDS) - India Mar’05 – Oct’06

Role: Information Analyst

Project Name: BRSSPlus (Bill reporting self-serve Plus)

Description: BRSSPlus is an internet based bill reporting and analysis tool. Tailored to customer’s organization structure and business reporting requirement. Suitable for customers with large volumes of billing information for analysis. Owned by Telstra, maintained by EDS. Self-Serve approach

-Non-Discretionary (Production Support)

oProblem solving

Solve tickets (All severities)

Ad hoc queries on the application (Functional / Design)

oBatch monitoring, bill runs, daily QA

oCapacity planning / reporting / raising alarms

oAd hoc reporting

-Enhancements

oConduct Impact analysis, estimation of the work

oRequirement analysis,tech specs design, writing test cases, Coding, testing, UAT, Implementations

oCustomer interaction, Planning and tracking of the assigned work

Environment: VB 6.0, ASP, User Interface (GUI), XML, XSLT, JAVASCRIPT, VBSCRIPT, DHTML, HTML, SQL 2000, MSMQ, IIS, COM+, MS OLAP (Cube processing, MDX queries)

SCB Bank (20TWENTY) (Indus Software) - India Dec’04 – Mar‘05

Role: Sr. System Analyst

Project Name: SCB Collections

Description: This Product helps SCB Bank to track and recover money for the delinquent customers. It helps the bank to route the cases through different levels of collector e.g.: - field collectors, lawyers depending on predefined criteria helping them to organize the process of collecting money for the delinquent customers. It also helps them to measure the performance of a particular collector. In order to improve collector effectiveness, the solution had to accommodate for global action that can be taken on any case in the system by all collectors, interface with SMS messaging software to send SMS / E-Mail’s on customers.

Role:

-Estimation of the work and work allocation

-Client interaction and status reporting

-Requirement analysis and designing

-Coding and testing of the bugs and enhancement

Environment: ASP, XML, User Interface (GUI), XSLT, JAVASCRIPT, VBSCRIPT, ORACLE 9i, HTML, DHTML, IIS

Eaton Electrical (LNT InfoTech) - India Mar’04 – Dec’05

Role: Project Leader

Project: Order Manager (OMAN)

Description: Order Manager is an order entry and order management tool used for processing orders generated from Bid Manager quotations. It is used to enter specific and general order information and format it in a way that can be processed and stored in Vista. Order Manager is used by e-Support.

Role:

-Estimation of the work and work allocation

-Client interaction and status reporting

-Planning and tracking of the assigned work

-Requirement analysis and designing

-Coding and testing of the bugs and enhancement

Environment: VB 6.0, Asp, XML, XSLT, JavaScript, Vbscript, Dhtml, Html, Cold fusion, SQL 2000, Third Party API’s like Right Fax, Genifax, MSMQ, IIS, COM+

Johns Manville -Six Sigma Manufacturing Company (LNT InfoTech) - India Jul’03 – Feb’04

Role: Sr. Software Engineer

Project Name: 12 Point Applications

Description: The 12 Point applications are used for tracking of the various business requirements and maintenance of their day-to-day business needs. This project for aimed at maintenance and enhancement of the existing 12 Point applications to make the applications gather more data, simplify the workflow and accommodate the changes needed for the changed business requirements.

The peak advantage is addition to the contractor functionality. This strategic peak advantage program rewards the contractors for implementing high quality, profitable JM approved roofing systems. This will help JM and the user to calculate the Peak $ earned by a particular contractor. The contractor should satisfy the criteria to qualify for the peak advantage as mentioned in the requirement below

Functional Features

-Online look up for JM employees

-Interlinking between applications

-Interface to other systems

-Peak advantage program

Technical features

-Centralized role based security

-Generic client side validation

-The UI and coding standards specification provided by the client JM

-Interface to other systems

-Internet and Extranet interface for some systems (GMS 4.5 / Connexus)

-Auto responders to handle critical errors

Role:

-Requirement analysis, impact analysis of the enhancements, problems.

-Design, Development and Testing of the enhancements, problems.

-Preparing test cases

-Suggest improvements to existing applications for enhancing performance, operational ease and resolving potential problems within the applications

-Versioning issues

-Following quality processes

-24 x 7 support

Environment: ASP, XML, XSLT, JavaScript, Vbscript, Dhtml, Html, Cold fusion, SQL 2000

ICC, Deluxe Labs (Hollywood),

Jupiter [FDS (Fortune Decision Systems)] – India Dec’00 – May’03

Role: Developer

Project: i2 Pronto 5.2 - 6.0 (Scheduler) Supply Chain Management

Description: This product is a scheduling software .It has two parts one is data manager and other is the scheduler. The data manager has different data entry screens such as Machine, Machine Down Times, Routing Sheet, Order Data, BOM, Configuration, Item master. Depending on the Order update given the schedule and update files are modified. The Updated schedule and update files are used for Scheduling and / or Rescheduling of the order. The scheduling of orders is done on basis of some predefined scheduling rules.

Functional Features

-Provides with a WHAT IF? Feature

-Multiple schedule and update files with password protection

-Configuration can be changed as per demand

Technical features

-Multilingual support

-Generic client side validation

-Customized as per requirement in very short time. Tag library makes it easily possible

-Second level of transformation makes it more generic

-The UI has to follow all the FROG UI specification provided by i2.

-Easily changeable skins

Role: Designing Tag Library’s for Rich UI using XSLT and XML, Java script/VB script validation, ASP coding, XML/XSLT designing issues, Making the product multilingual, Testing the vb dll’s, Testing the product. Understanding the product life cycle

Environment: VB, ASP, XML, XSLT, JavaScript, Vbscript, Dhtml, Html

Gurukulonline.com - India Sep’99 – Dec’00

Role: Web-programmer

Web site name:www.gurukulonline.com

Description: Gurukulonline.com is an interactive e-learning portal, it provides different online course in information technology. This company also shoulders the responsibility to deploy e-learning solutions such as “CENTRA” and “IBM Lotus learning space”

Role: Java script/VB script validation, ASP coding, SQL database issues

Environment: ASP, Html, java, JavaScript, Dhtml and FrontPage2000

Education:

Bachelor of Engineering (Electronics) from Govt. College of Engg. And Technology, Nanded, India.

Diploma in Electronics and Telecommunication from Institute of Ankush Polytechnic, Nagpur, India

Contact this candidate