Mandar Dani

Toronto, Canada 647-***-**** acxps8@r.postjobfree.com

Summary

16+ Years of IT Experience, proven track record of managing all phases of Software Development Life Cycle (SDLC), analysis to implementation, support & maintenance activities. Methodologies: Waterfall, Agile – Scrum, TDD

Experience in Oracle, SQL Server, design & development of application database and objects, database migration, data modelling, analysis & administration

Experience in Maintaining & Supporting applications, Front end development and maintenance in JSP, Servlet, Java beans, POJO, Classic ASP, Asp.net, C#

Involved in supporting sales team, contributed in RFP, Product Demo, Project Meetings, Follow-up, client interaction

Proven Team Leading capabilities, excellent team player with good interpersonal, communication skills, quick learner, Involved in opening Center of Excellence in Insurance product –Duck Creek

Dedicated to Departmental and Corporate Objectives

Education & Certification

Bachelor Of Engineering (Electronics)

Post-Graduation Diploma in Business Management

Post-Graduation Diploma in Advance Computing

PMI PMP Certified.

IKM Oracle 11g PL/SQL Programming

SCJP certified.

Microsoft certification for SQL2005 70-431.

INS 21 certified.

Technical Expertise

Languages: Strong - SQL, PL/SQL, T-SQL, Experience in Java2.0, JSP, JDBC, Java Beans, Servlets, Experience on Microsoft Platform- C#, Classic asp, Web App Security Fixes, JavaScript, VBScript, UML, Unix shell scripting (entry level)

Database: Oracle 9i, 10g, 11g, MS SQL Server 2005, 2008, 2012, MS ACESS

Tools: TOAD, SQL Developer, SSMS, Visio, TFS, VSS, SVN, Argo UML, Duck Creek, Crystal Reports.

Academic: Hadoop Eco Systems – MapReduce, Hive, Scoop, Pig

Project Details:

Name: Automated Data Transfer

Date: Sept 2016 – Till Date

Client: George Brown College, Toronto

Role: Programmer Analyst

Contribution:

Designed steps for integration process, software requirement specification

Completed outbound file programming file extraction before deadline, Inbound data integration in progress, worked on production tickets

Programming: Staging tables, constraint, Packages, procedures, functions, shell scripting, helped testing team by preparing test data & configuration scripts.

Technologies: Oracle 11g, PL/SQL, Unix shell script, IP switch

Tools: Putty, Harvest, Toad

July 2005 to Sept 2016 –L&T Infotech Ltd in India, USA & Canada as Sr. Database Developer & Project Coordinator/ Manager

Name: Application Portfolio Management

Date: Sept 2015 – Sept 2016

Client: Mercer, Toronto, ON

Role: Sr. Database developer, Onsite Project Coordinator

Contribution:

Successfully executed pilot applications implementation in Managed Service Mode, Implemented application security fixes (understanding project requirements, coding), Documented Applications in Production with the help of SME, Support,maintenance production application by resolving defects in predefined SLAs

Created Knowledge Capture Documents which includes Application Overview, Technical Architecture, Data dictionary, Screen flow, Transaction flow, Environment, Testing processes, Batch processes, Typical problem areas, Reports, Release information, Managing documentation on share point platform

Acted as single point of contact between business – SMEs and offshore team members.

Value add: Worked on front end classic Asp code fixes, end to end application testing

Achieved Customer Satisfaction Index 4.8/5.0

Technologies: Oracle 11g, PL/SQL, SQL Server 2008, TSQL, Classic Asp, JavaScript, C#

Tools: PL/SQL Developer, SSMS, TFS, VSS, Visual studio 2012, SharePoint

Name: COE for Insurance product Duck Creek

Date: Aug 2014 – Jul 2015

Client: North Bridge, Toronto, ON

Role: Sr. Database developer, Onsite Project Coordinator

I was part of team who opened Centre of Excellence for Insurance Product Duck Creek

Designed training modules (domain + technical training), Data shredding & integration use case development, Team building strategies

Presentation preparation - Duck Creek Capabilities for partnership with Accenture

Played role in first implementation (phase 1) through duck creek COE for North Bridge

Tools & Technologies: Duck Creek, SQL Server, SSMS, .Net, share point

Name: Web App For Commercial Line Insurance

Date: Mar 2012 – Aug 2014

Client: Munich Re, Toronto, ON

Role: Sr. Database developer, Onsite Project Coordinator

Contribution:

Major part of work was to understand the BRDs and develop solution.

Played key role in Enhancement releases & defect fix release development, testing, support.

improved performance of reports, worked on query tuning

Develop & enhance Packages, procedures, trigger, functions & views.

Designed new holding tables and metadata tables

Created test data for BA and QA

Created integration & incremented deliveries.

Value add: Asp.NET, C# defect fixing, Crystal reports enhancement, end to end testing

Managed, Delivered Knowledge Captured Documentation on Share Point platform

Worked as coordinator between onsite – offshore team.

Maintained Customer Satisfaction Index above 4.5/5.0

Technologies: Oracle 11g, PL/SQL, ASP.NET, Java-script, Crystal Report 2008

Tools: TFS, PL/SQL Developer, Share point

Name: ICD9 to ICD10 conversion, 5010 upgrade for 837-EDI

Date: Feb 2011 – Mar 2012

Client: Windsor Health Insurance, Bellingham, WA, USA

Role: Sr. Database developer, Onsite Project Lead

Contribution:

Completed project before deadline, mandated date mentioned by statutory body

Understood existing system and modify according to new requirements

Designed new staging tables & holding tables, introduced new packages, procedures, functions, views, Enhanced existing packages, procedures, views

Defined & delivered work items for team in line with business & delivery dates

Translate requirements into tech specs, communicated with Business, offshore, QA

Introduced new logic for logging errors in batch processing

Technologies: Oracle 10g, PL/SQL, PB9.0

Tools: SVN, SQL Developer

Name: Group Benefit Platform for Group Insurance

Date: Aug 2008 – Jan 2011

Client: Harleysville Insurance Company, Harleysville, PA, USA

Role: Sr. Database Developer /Offshore Project Lead, Onsite Coordinator ( 6 Months)

Contribution:

Participated in requirement gathering phase, involved in brain storming meetings

Involved in designing Conceptual & logical data model and developing database

Designed Procedure, functions, triggers, Views

Designed Database driven workflow

Completed Feasibility study of enhancements and change requests

Implemented very complex legacy integration, in which data is sent to legacy from GBP application and vice versa.

Created database deployment package using DB Pro tool for various environments like development, testing and production.

Worked with front end team in designing DB objects as per requirements

Visited onsite for major releases and sorting out issues

Technologies: SQL SERVER 2005, 2008, INFOPATH, Visual studio 2005

Tools: Team Foundation Server, Red gate, SSMS, Share point

Name: Premium Pipeline-Integration platform for Policy

Date: Jul 2007 – Aug 2008

Client: Travelers, Hartford, CT, USA

Role: Database Developer /Module Lead

Contribution:

Understood requirements of Earning module, EARNINGS module written in PL/SQL

Defined Use cases and created tasks.

Created Packages, procedures and views for reports

Coordination with client.

Created and assigned tasks

Tools & Technologies: Java, Web Sphere, Oracle 9i, VSS, RAD7.0

Name: Insurance Domain Multiple projects – Cobol to Java Migration, Vehicle Identification Verification

Date: Jul 2005 – Jul 2007

Client: Nordea Denmark, Travelers Hartford, CT, USA

Role: Sr. Software Engineer, Module Lead

Contribution:

Worked as Java developer on multiple module, Database Packages, procedure writing

Documentation – Program specification, test case documentation

Tools & Technologies: Java, Web Sphere, Oracle 9i, VSS, RAD7.0

Feb 2000 to Jun 2005 – Comsoft Infotech in India & Singapore as Analyst Programmer

Name: Financial Integration Platform

Date: May 2003 – May 2005

Client: JP Morgan Chase, Singapore

Role: Analyst Programmer

Contribution:

Understood payable, receivable requirements

Created screens and holder java classes, Database Packages, procedure writing

Documentation – Program specification, test case documentation

Technologies: JSP, Servlet, Java Beans, JavaScript, HTML/DHTML, oracle 9i

Tools: Kawa, Edit Plus, Home Page, Argo UML

Name: Financial Integration Platform, Web based ERP

Date: Feb 2000 – May 2003

Client: Formica India, In-house product development

Role: Analyst Programmer

Contribution:

Understood HRMS, Inventory requirements

Created screens and holder java classes, Database Packages, procedure writing

Documentation – Program specification, test case documentation

Implementation of Product, data migration

Technologies: JSP, Servlet, Java Beans, JavaScript, HTML/DHTML, oracle 9i

Tools: Kawa, Edit Plus, Home Page, Argo UML

Contact this candidate