Engineer Software

Ketaki Kulkarni

*** ***** ***** ******, *** ** E, Jersey City, NJ 07306

Contact: 551-***-****

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

[pic]

Work Experience

. Team Lead, Persistent Systems Ltd, Pune - Sept 2006 to

present

Skills

. ETL Tools: Informatica 8.6, Informatica Data Quality,

DataStage

. Databases: Oracle 10g, MS SQL Server 2005

. Worked in PL-SQL and T-SQL

. Scripting languages: Ruby, JavaScript

. Tools: SQL Developer, Tortoise SVN, ClearCase, QC

. Other technologies/tools - MySQL, Ruby on Rails, IBM Tivoli

Monitoring, CSS, BizTalk Server, C++, C#.Net, ASP.Net, DB2,

CMVC

Education

. B.E. Computer in July 2006 from Modern Education Society's

College Of Engineering (MESCOE), Pune

. Diploma in Computer Engineering in July 2003 from Sri

Savitribai Phule Polytechnic (Maharashtra Institute of

Technology), Pune

Personal Details

. Date of Birth: Aug 18th, 1985

. Permanent Resident of USA (hold Green Card)

Summary of Projects

Project Wells Fargo

Description Maintaining reference data, profiling it for quality for Wells

Fargo's loan system

Role Senior Computer Programmer Analyst, Consultant

Work San Leandro, CA, USA

Location

Technology Informatica 9.1, Informatica Analyst, Oracle, MS SQL Server

Duration May 2012 - July 2012

Work details Played the role of Business Analyst for gathering the

requirements for reference data maintenance

Prepared BRDs for the reference data of different entities

like Legal Entities, System Code

Played the role of Data Analyst for a subject area

Analyzed the data for the quality based on different DQ

dimensions

Suggested the business rules to improve the data quality and

its completeness

Project Wells Fargo

Description Data warehouse of Wells Fargo's different SORs of loan systems

Role Computer Programmer Analyst, Consultant

Work Fremont, CA, USA

Location

Technology DataStage, Oracle, PL-SQL, Tortoise SVN

Duration May 2011 - Nov 2011

Work details Data warehouse of different SORs for front end applications to

consume data easily

Worked closely with data analysts

Contributed to design decisions

Development of different subject areas

Worked on integration of the solution

Project Wells Fargo

Description Database Migration from Wachovia to Wells Fargo

Role Module Lead

Work Pune, India

Location

Technology Informatica 8.6, Oracle, PL-SQL, Stored Procedures, MS SQL

Server 2005, Tortoise SVN, QC

Duration Aug 2009 - May 2011, Dec 2011 - Apr 2012

Work details Contribution to design of applications

Implemented the ETL solution

Analyzed requirements and worked on estimates

Handled a team of 3-4 members; mentored them on Informatica,

domain, architecture of the project; guided them with the

design of applications

Worked on applications like Wires transfer, Basic banking,

Statements and Notices, EBox, Lockbox, Common part of the

project like billing used across different applications,

concept of entitlements/authorizations

Worked as an onsite coordinator, deployment engineer for 6

months in San Leandro, CA, USA (Feb 2010 - July 2010)

Provided support to migration runs in various environments

like SIT, UAT, PROD

Worked on generating reports using PL-SQL

Received a SPOT award twice for the work at onsite

Project Wells Fargo

Description Database Migration from Wachovia to Wells Fargo.

Role Software Engineer

Work Pune, India

Location

Technology Informatica, Oracle, PL-SQL, Stored Procedures, MS SQL Server

2005, T-SQL, Tortoise SVN

Duration April 2009 - July 2009

Work details Contribute to design of application

Implementation of the ETL solution

Worked on integration of the solution

Analyzed requirements and worked on estimates

Mentored team members with design and implementation

Developed different POCs to generalize the tasks

Delivered good quality under extremely tight deadlines, with a

load of work

Worked on performance improvement of Informatica mappings

Project Accept Software

Description Development of a SaaS web application

Role Software Engineer

Work Pune, India

Location

Technology Ruby on Rails, JavaScript, CSS, MySQL

Duration June 2008 - March 2009

Work details Implementation of new features and enhancements

Interaction with client located in CA, USA for understanding

the requirements

Suggesting different ways of implementing features to the

client

Bug fixing

Worked under extremely tight schedule of deadlines throughout

the project span, with frequently changing requirements

Project IBM

Description Development of monitoring agents for Microsoft applications

Role Software Engineer

Work Pune, India

Location

Technology .Net Framework 2.0, Microsoft BizTalk Server 2006, DB2,

ClearCase, CMVC

Duration April 2007 - May 2008

Work details Worked extensively on Microsoft BizTalk Server Agent 2006

Played the role of Lead Developer for Microsoft BizTalk Server

Agent

Took important decisions during design phase of agent

Worked on integration

Interaction with client from day one of the project

Involved heavily in preparing design document, getting it

approved from client

Being the lead developer, responsible for triggering the

builds on the server, generating build report and circulate

across different audience like client, QAs, BAs

Contributed to Microsoft .Net Agent development

Contributed to the POC of the project during initial phase of

the project

Educated QA team and juniors with the architecture and domain

of the projects; arranged different KT sessions for them

In House Projects:

Project Development of Plugins for Ruby on Rails Center of Excellence

Description Development of different generalized plugins in RoR, which can

be integrated and used by any RoR applications to make the

development faster.

Role Software Engineer

Work Pune, India

Location

Technology Ruby on Rails, JavaScript, CSS, MySQL

Duration 2 months

Work details Plugin for Online Help Generation

Plugin for Online Survey

Project AJAX driven page pre-fetch

Description Pre-fetching the data using AJAX to make web application work

faster

Role Software Engineer

Work Pune, India

Location

Technology .Net 2.0, ASP.Net, XML web services, JavaScript

Duration 2 months

Work details Pre-fetching the data using AJAX to make web application work

faster

Project Remote Monitoring and Controlling System

Description Remote Monitoring and Controlling System

Role Software Engineer

Work Pune, India

Location

Technology C++, Embedded VC++

Duration 2 months

Work details Developed the server for socket implementation

Contact this candidate