Summary

As a technology specialist, I assess myself as a result-oriented

professional with ability to analyze, present solutions, and steer projects

through to completion. I am recognized for my creativity, teamwork, and

excellent interpersonal and technical skills.

I have a total experience of twelve years in the IT industry that spans the

Finance and Enterprise analysis verticals. During this period I have gained

a good understanding of the various phases involved in the project

development execution and maintenance as per CMMI 3. During my tenure, I

have worked on various technologies as per project need. It includes .Net,

wcf, 1.1,2.0,3.5, 4.0, VB6.0, C, oracle, MSsqlserver 2000/2005, Business

Objects, Informatica, IBM web sphere, MSCRM, Java, Hadoop, Tableau and

Qlikview . I have worked as a project manager and development lead in my

current role.

Technical Skills

In my total work experience till date, I have effectively and efficiently

exhibited the following technological skills:

Skill Name Proficiency Last Used Years of

Experience

Asp.net with c# Expert 2014 12 years

Mssql server Expert 2014 10 years

Oracle 8i, 9i, 11g Expert 2014 4.0 years

Data warehouse Expert 2014 4 year

modeling

Moss Expert 2014 2 years

Business Objects Expert 2014 1.5 years

IBM web sphere Intermediate 2009 5 months

Informatica Intermediate 2013 6 months

WCF/design pattern, Intermediate 2010 1 year

mvc

Crystal reports Expert 2008 2.00

Xcelsius Intermediate 2010 year

Data warehouse expert 2012 4 year

modeling

Hadoop Intermediate 2014 6 months

Vb 6.0 Expert 2005 2.00

ASP Expert 2005 1.00

Technical and Functional Skills

In my total work experience till date, I have effectively and efficiently

exhibited the following skills:

. Well verge with all project management processes up to CMMI 3 level

. Trade life cycle on DTCC

. Team handling up to 6-7 developers

. Learn any new technology and train to other developers as per project

requirement

. Ability to design complex database, complex procedures and implement

business logic layer within database. Data modeling

. Implement data warehouse, data integration using informatica and

reporting using BO.

. Implement MSCRM 4.0, customization, custom reports

. I have developed so many projects few have been listed below

Experience

Company Tenure Designation

eClerx Services 5th Jul 2005 to till Date Senior Process Manager

Ltd.

QualSoft Services 1st Feb 2005 to 28 Jun 2005 Senior Software Developer

Cyber indigo pvt Oct 2004- Jan 2005 Software developer

Ltd.

Tenet InfoTech Sep 2004 to Sep 2005 Software developer

Ltd

Web Atrium Aug 2003 to Aug 2004 Software developer

PROJECT'S and WORKING EXPERIENCE

Current Employer: eClerx Services Ltd.

Project: OCRM

Technology used: Asp.net, OpenXml SDK, MSSql Server 2008.

Team size: 6

This is reporting tool by using Microsoft PowerPoint 2013. There is a

report build in PowerPoint going to senior managers after each month. There

40+ slides and each slide contain 6 graphs + tables and texts contains the

information about the various the performance in various fields. To prepare

this presentation manually is a very hectic and time consuming task. So

this tool is taking input directly from various extracts and calculates the

measures and displaced on charts. We have used Open xml sdk for this

assignment.

Project: Task Tracker

Technology used: SharePoint, jquery. SP services

Team size: 6

This tool is used for logging the time tracker entries in matrix format.

This 700 employees users are using this application by selecting time vs

Activity matrix. This tool is totally configurable by tool administrator.

The reports have been built in excel by using macro.

Project: MI dashboard

Tools: Java, Oracle 11g, BO3.1

Description:

This is dashboard, developed in BO reporting tool by using its out of

box functionality. There are more than 80 extract files have been imported

in the tool by using informatica. We do processing on the data and more

than 50 KPI's are getting calculated and displayed on the dashboard. The

dashboard is available more than 150 users across the globe and divided in

four functions. The reports have built in BO and enclosed by java wrapper.

It has been designed such that the user can drill down till four levels.

All reports are dynamic in nature and user can filter the reports with 13

filters. Dashboard shows KPI's current values, YTD values and target

values. RAG's are showing with comparison between current value and target

values. We are also showing daily, weekly and monthly trending of KPIs on

drill down of each KPI.

My role is to design the ware house and staging database environment.

Guiding to the developers for writing stored procedures, are building

universe and BO reports, performance tuning in Database.

Project: eClerx.com

Tools: SharePoint 2010, sqlserver, .net

Description:

This is our organizational website build in SharePoint 2010 CMS. We build

the site in SharePoint because user can easily manage the content with any

technical person's help. We have 10 developers worked on it for building

site for more than 12 months. We have built more than 50 web parts for

supporting CMS. We have also integrated Pardot as a marking tool for

storing whitepapers and mails blasts. Pardot tracks all visitors are give

comprehensive reports.

My Role is to design page layouts, master pages, train the resources on

SharePoint CMS development. Development of Mobile compatibility site is our

next agenda.

Project: T0 Confirmation (trade reconciliation) on DTCC

Software: .net, C++, IBM Web sphere, sqlserver 2005

Description

The project was long project i.e. more than 3000 man hrs. By using this

project our clients were able to find the breaks between their trades and

counterparties trades and fix the breaks. This helps banks to confirm their

trade portfolio in T0 time. The project was dividing in three phases

1. Receiving messages from DTCC via MQ

2. Parsing messages and generates a raw data for reconciliation tool

Reconciliation tool, which is itself a big asp.net application developed by

myself

In this project I install IBM web sphere client and connected to DTCC live

IBM Web sphere server. The installation of IBM Web sphere was very tedious

task, after lot of trials we were able to connect DTCC server. We developed

required c++ routines and embed in IBM Web Sphere.

For next phase we developed a windows application in c# to extract

message from IBM Web sphere and stores at shared folder. There is another

application for reading these messages. These messages are in FPmL so we

were able to store them sqlserver table and were parsed in sqlserver

itself. The message contains the information about trade transactions. We

prepare the raw data same as DTCC provides us. Then we send the data to

particular client server for further processing.

Project: DTCC BAU trade reconciliation Tool

Software: Asp.net, MSSql Server 2005

Description

In this project we take raw data from DTCC. Mainly the data contains the

trade transactions before confirmation. Our business is to suggest pairs

unconfirmed and allege trade, so that client easily understand the field

break and place correct value at DTCC and trade get confirm less than T5

time. My business analyst seat together and wrote an algorithm. We break

whole project into three modules

1. Pairing the trades

2. Reconciliation between pairs

3. Reporting to client

For pairing we created, we choose few economic fields and prepared 17

scenarios and set the priorities of each scenario as per weitaghes given by

DTCC. We also find the logic for resolving multiples and make a single

pair.

In reconciliation module, we chose more than 60 fields as per DTCC rules

and find breaks. After reconciliation we were studying the trades and

suggesting actions to client that who to change the value. We also prepared

some reports using excel graphs. For web development we decide to use

xcelcius graphs. Were created few templates but after consistent change

client requirement we drop that idea.

Project: Dynamic Data Capture tool

Software: Asp.net, sqlserver

Description:

We have another business to reconcile paper trades. For that we have

different teams to manual capture data from Pdf files and reconcile this

capture data with actual system data which is exists in xml. This tool has

three modules

1. Analyst

2. Auditor

3. Team lead

In all project these three roles are constant, but for different type of

pdf we require different tool. The fields to capture were also keeps

varying as per nature of product of trade. So to develop a tool for capture

500 fields we require at least 2000 man hrs and spend at least 3 months. So

I had an idea to populate a field on page by some DB configuration. So I

created a module that populates a field from DB on page. By using this

module I was able to implement an analyst module and other modules also.

Now days, we are able to create a tool within 100 man hrs work.

Previous Employer: Qualsoft services

Project: Sophia

Software: Asp, sqlserver2000

Description:

This project was created to digital university of Dutch. This was in

education domain. The student can study online through the Internet. It has

administrator, student, mentor and associate mentor roles. Each role has

specific functionality. To complete this project we traveled to Holland and

study their working and modified their existing tool.

Previous Employer: Cyberindogo net

Tenure: Oct 2004- Jan 2005

Project: LPG shipping

Tool: asp.net, oracle

Description:

This project is developed for HPCL. HPCL is old shipping company and it has

its own several ships to carry oil across various part of country. It also

hires few ships from other shipping companies. Our tool was developed the

ship activities. i.e. what is current location of ship? How much fuel used

for ship? It has three roles

1. Admin

2. Port users

3. Member

4. Admin- to maintain the application

Port users- enter ship details since its arrival to departure to a

particular port

Members- these are members within ship.

Project Content management system

Tool: asp.net, sql server

Description: I have completed two web base projects under this system.

1) http://www.giftcertificates.com/ and http://www.giftingresources.com/

2) http://www.stockguru.net/

This system consist of two modules

1. Administrator modules

2. Viewer Module

In administrator module

This system is basically used to maintain the web site dynamic as well as

static contents. It Consist of two modules

In administrator module web sites dynamic as well as static contents are

defined.

Previous Employer: Tenet Infotech Pvt. Ltd

Tenure: From 1-Sep-2003 to 25 sep 2004

Project: CRM

Tools: Vb6.0, Ms Access

Description

This software is bridge between the customers and company management

through the call centers or service centers. This Software is in two

versions.

1. Client version

2. Server Version

3. Data uploading

Client version:

This version is installed at call centers or service centers. Godrej has 64

service centers all over India. All service centers this software is

installed.

It consists of two modules.

1) Call management: This module manages all call data, customer

data and call update data. It also manages masters, transaction models

as well as several types of reports.

2) Material management: this module manages all material store at

service center. It also manages different masters and transactions,

several reports and several utilities such backup, import model

masters, sending data to server place.

It also manages data replication at some service centers.

This model also includes some useful utilizes as like data backup,

Import models and part masters, send data to H.O through ftp.

Server Version:

This software is installed at central place (i.e. at Boyce & H.O.

Godrej Pvt. Ltd. Vikroli, Mumbai). This version manages consists of

different types of reports and utilities. The management team analyses

the data of particular branch or service center or zone. So it is easy

to monitor the service centers from H.O. they can also View CRT, FRT,

Repeat calls report, Call summery, Cash Collection, Technician

performance reports. These reports are franchise wise, branch wise and

zone wise.

Data Uploading:

Data uploading Utility is placed on server of godrej. All xml files

came from Clients are stored at ftp server. This utility fetches these

xml files and uploads in to Informix database. The Confirmation of

uploading xml data file is informed to concern person by an auto

email. This email also goes to respective branch manager and zone

manger.

Previous Employer: Web atrium infomedia

Tenure: Aug 2002- Aug 2003

Project: Planning software

Tools : VB6.0, oracle

Description : This is an ERP tool. It has three roles. Admin, manager,

user.

Many times manager want to monitor the users activity. Once any large

company gets an order from its client to create an transformer. the users

has some preassigned activities with specific time frame. So manager come

to know what activities have been pending from which user and which work

order.

Project: Temperature measurement system

Tools : vb, ms access

There is hardware device to measure the temperature of various part of a

machine. There were 24 device connected to device to control the

temperature of a machine. Our tool was design to view the temperature

measured by device on the computer. For that we designed a protocol for

transmitting data from device to computer. The device was connected to one

of com port of computer and our tool was reading data from memory location

of that port.

Education

B.Sc Tech (Software Technology), Watumull Engineering College, Mumbai

University. (60%) 1998-2002

Post graduate Diploma in management and administration, symbiosis, 64 %,

2013.

B.Sc (Physics), Pune University 64%, 1995-1998

HSC- 60%, 1995

SSC- 79.85%, 1993

Certification training

1) I undergone PMP training

2) MOSS development

3) Cloud computing by using Amazon web services

Achievements

PM of semester in eClerx

Spot reward for developing dynamic data capture tool

Personal Details

Name: Balasaheb Bodake

Contact Number: 986-***-****

Email: acoew0@r.postjobfree.com

Marital: Married

Current location: 102, H wing, mithul enclave, anik village, chembur(E),

Mumbai,74.

Contact this candidate