Sql Server Project Management Development .Net Developer

V ishal Patil (Atlanta GA) 201-***-****

*************@*****.***

Summa ry

I have around 10 years of r ich experience in Information Technology with proficiency in software

development, database programming and administration, implementing BI solutions, project management,

business process automation, management and support of key business processes. I am a dedicated

p rofessional who is committed to continual learning and advancing my technical expertise and am proficient

w ith a variety of Microsoft key technologies and development languages which provide a valuable skill set

t hat includes:

Desig Visio, Erwin, Enterprise Architect (Sparx)

ning

Tools

:

OS MS SQL Server, Windows and Windows Server, Unix,

P latf DOS

orms:

Lang C#, VB.Net, VBA, Java/JavaScript, HTM L, XML.

uages

:

Data M S SQL 2008R2/2012, SSIS/SSRS/SSAS 2008R2/2012

bases

/DW:

Dom Taxation, Financial Services, HR, Media and

ains: M anufacturing.

Third BI Express, SQL sentry

party

t ools:

Soft Effective wri t ten and oral communication, meticulous

Skills a ttention to detail, mentoring and leadership,

: client/SME interaction

Educ Bachelor of Electronics and Telecommunication

ation:

Mumbai University, India.

Employment H istory:

• Hexaware Technologies Pvt. Ltd. – May 2011 - till date

1

Designation: System Analyst Role: MSBI Lead (SSIS/SSRS/SQL) Clients: Ernst & Young.

• L &T Infotech Pvt. L td. – December 2006 - May 2011

Designation: Project Leader Role: MSBI Lead (SSIS/SSRS/SSAS/SQL) Clients: Scania/Citi/L &T

T reasury.

• Syntel Inc – July 2006 - Dec 2006

Designation: Senior Programmer Analyst Role: Senior Developer (SSIS /SQL) Clients: News Market

(US).

• UBICS Technologies – July 2004 - July 2006

Designation: Programmer Analyst Role: .net Developer (Asp.net with c#) Products:

Ventive/CITIPost/SeeItFirst.

• VCET – November 2003 - July 2004

Designation: Teaching Assistant Role: Network Admin Clients: VCET – EXTC Dept.

Education Qualification:

• Advance diploma in Network Technologies, CMS in 2003 – Distinction

• Bachelor’s Degree in Engg with specialization in E&TC, Mumbai University in 2002 – 1st Class

• Diploma in Industrial Electronics, MSBTE in 1999 – Distinction

T rophies and Achievements:

• Star Performer – L &T Infotech (2009)

• Ace Award – Hexaware Technologies (2012)

P ersonal Details:

• Address: D unwoody, Atlanta, GA

• E-mail: v ************@*****.***

• Phone: 201-***-****

• Passport: K 1909924 Validity: - 12/01/2022

• Valid Visas: H 1B Valid till Aug 2016

Work Experience:

Hexaware Technologies (May 2011 - till date)

Client E &Y, US / UK

P roject: P TS (July 2012 – till date) (Work Location: US/ India) R ole:

M odule Lead (SSIS/SSRS/SQL)

PTS (Partnership Taxation System) is a system used to capture, analyze & calculate and report the incomes,

gains, losses, deductions, credits etc. from the operation of a partnership. T he PTS system comprises of Web

V ishal Patil (Atlanta GA) 201-***-****

*************@*****.***

Interface, Calculation Engine, and Reporting module, it also interfaces with external taxation system (IRS) to

submit 1060 forms.

Responsibilities:

• Interaction with stakeholders to clarify/tailor the requirements, onshore / offshore coordination, WSR and

status calls.

• Designing and development of reporting module.

• Designing and development of Data Import, Data Integration, Data-Calculation and Data-Sync module.

• Leading and managing team of 10 BI developers.

• Performance tuning - analysis and implementation.

• Code reviews, debugging complex issues, handling security and deployment issues etc.

Technical Envi ronment:

SQL Server 2008 R2 db, SQL server 2012, SSIS and SSRS (data tools) 2012, Visio 2007, TFS 2010, Office 2010.

P roject: Anti Money Laundering (Jan 2012 – July2012) (Work Location: I ndia) R ole: Module

L ead (SSIS/SSRS /SQL)

T he AML system focuses to respond to E&Y’s Q&RM’s business case supporting the need of the EU states within

E MEIA to comply with their local laws implementing the Customer Due Diligence requirements of EU

legislations.

Responsibilities:

• Requirement capture and analysis; Client Interaction and Documentation.

• Designing of the database (logical and physical model). Preparation of test/sample data.

• Designing and development of Reporting and Integration modules (integration of AML with GFIS, GTAC

and QMS system)

• Leading and managing team of 4 BI developers and 2 SQL developers.

T echnical Envi ronment:

SQL Server 2008 R, SSIS, SSRS, BIDS 2008, Visio 2007.

P roject: Retain DSL (Oct 2011 – Jan 2012) (Work Location: Netherlands/Belgium)

R ole: B I Consultant (SQL)

Retain is a resource management application. Retain DSL (Data Staging layer) has been designed and developed

to sit over Retain and provide a platform where data from Retain is made available to various other system to

meet the reporting needs.

R esponsibilities:

• Understanding current DSL implementation and Reverse engineering and Documentation.

• Enhancing DSL to handle problems related to performance, security and maintenance.

T echnical Envi ronment:

3

SQL Server 2005/2008 R2, SSIS, Oracle 10 g, Oracle db client – Toad.

P roject: EDW (Ente rp rise Data Warehouse) (May 2011 – Oct 2011) (Work Location: I ndia) R ole:

B I Consultant (SSIS/SQL)

EDW is a module to consolidate data from various cross platform data source systems namely ERPR, GHRDB,

H MT, ADAM into single MSSQL destination which will subsequently be used for reporting purpose and for

p roviding on demand data feeds.

Responsibilities:

• Requirement gathering and analysis; Interaction with SME’s and Documentation.

• Designing and development of integration module.

Technical Envi ronment:

SQL Server 2008 R2, SSIS, BIDS 2008.

Larsen & Toubro I nfotech (Dec 2006 - May 2011)

Client : Scania (Europe).

P roject: SBA (Feb 2010–March 2011) (Work-Location: E U - Various States) Role: B I

Consultant (SSIS/SSRS/SSAS/SQL)

SBA (Scania Business Analyzer) is a business intelligence platform based on a data warehouse structure and

O LAP-cube technology, loading data from the common systems (Axapta, iScala, SDS, AM, RAMAS). Excel and

SSRS were used as clients to present the information.

Responsibilities:

• Requirement capture and analysis; Client Interaction; Documentation and Onsite coordination

• Designing and development of new reports (SSRS based) for CS, SDS system and SDS TVI-France.

• Designing and Development cube for SDS TVI-France and CS (Contracted Services).

• Designing and Development of ETL f low for SDS TVI-France and CS (Contracted Services).

• Migration from SQL 2005 to SQL 2008 R2 (database/Cube) and migration of code from VSS to TFS

2010(Clear cut).

• Maintenance and CR Implementation for SDS and Ramas subsystems.

• Performance tuning - Analysis and Implementation.

• Leading and Managing team of 7 offshore BI developers.

T echnical Envi ronment:

SQL Server 2005/2008 R2.SSIS, SSAS and SSRS, VBA, Microsoft BIP. MDX Studio, VSTS 2008, ASP.Net 3.5 with

C#.

Client: Scania ( Sweden).

P roject: I T OP (Feb 2009 – Feb 2010) (Work-Location: I ndia) R ole: Module Lead

(SSIS/SSRS/SSAS/SQL)

ITOP is an application developed using Microsoft commerce server. I t comprises of sub modules like Web shop,

ordering system, financial approval interface (through SCAR), reporting system, and Access r ight configuration

module

Responsibilities:

V ishal Patil (Atlanta GA) 201-***-****

*************@*****.***

• Database design and development

• Setting up and configuring the data warehouse module of commerce server 2007.

• Design and development of SSIS packages to pull down the data from the old excel based system into new

Commerce server 2007 data warehouse (SQL-2005).

• Design-Development of reports (some against commerce server cube and some against the SQL database

d irectly)

• Design-Development of various QOS (quality of services).

• To interact with client for resolving any functional/technical issues.

• To guide and help the team in various technical aspects encountered during development phase of this

application also to give them the necessary t raining.

Technical Envi ronment:

Microsoft Commerce Server 2007, SQL server – SSIS/SSRS, SQL Server 2005. Visual Studio Team system 2008,

ASP.Net 2.0 with C#, NUNIT, Ajax Toolkit 2.0, Ajax Extensions 1.0, JQuery.

Client: C iti Bank (UK).

P roject: SFE/SME (June 2007-Feb 2009) (Work-Location I ndia) R ole: Sr. B I

D eveloper/TechLead (SSIS/SSRS/SSAS/SQL)

SFE (Secore Front End) is application to capture client instructions as messages from various sources, performs

a ll validations, allow users to fix/repair the messages and then send them to SECORE Custody system. SMI

(Secore Market Interface) applications address the post t rade settlement process for different markets.

R esponsibilities:

• Developing Reports using SQL –2005 Reporting Services (SSRS).

• Database design and development.

• Development of Web-application using c# language as code behind language.

Technical E nvi ronment :

SQL Server 2005, Visual Studio 2005, ASP.Net 2.0, C#.Net 2.0, SQL Server 2000, NUNIT, Ajax Toolkit 2.0

Client: La rsen & Toubro T reasury house

P roject: Kiodex I n tegration System (Dec 2006 –June 2007) (Work-Location I ndia) Role: Senior B I

D eveloper/SQL Developer

L &T Treasury installed Sungard Kiodex Risk Workbench (KRW), as a potential system to address their

commodities t rading needs. Sungard KRW allows t rading on different type of Financial Instruments like single

settlement swap, basis swap, fixed swap, FX forward, spread option, IR swap, futures, option, etc.

R esponsibilities:

• Understanding the business model of L &T Treasury for their cross platform Commodity derivatives t rading

needs.

• Database design of staging db and development.

• Developing data integration packages using MSSQL-2005 SSIS to pull data into staging db for reports.

• Developing Reports using SQL –2005 Reporting Services.

5

T echnical Envi ronment:

SQL Server 2005 business intelligence suite (SSIS, SSRS and SSAS), SQL server 2005.

Syntel I nc (July 2006 - Dec 2006)

Client: News Market ( US)

P roject: TheNewsMarket.com (July 2006 – Dec 2006) (Work-Location: I ndia)

R ole: SQL Developer

The News Market, Inc. is the only video archive and distribution service that enables journalists from around the

world to find, preview and download free broadcast-standard video over the Internet.

R esponsibilities:

• Database design and development.

• Development of SSRS reports.

Technical Envi ronment:

SQL Server 2005 business intelligence suite (SSIS, SSRS and SSAS), SQL server 2005.

Ubics Technologies (July 2004 - July 2006 )

C lient: Ubics Technologies, I ndia (UB Group)

P roducts: Ventive 4.0 / SeeI tFi rst / Citi post (July 2004 - July 2006) (Work-Location: I ndia)

R ole: dotnet Developer

Responsibilities:

• Application Development/Enhancement/customization using minimal build architecture.

• Database design and development.

• Training and demonstrations to clients.

Technical Envi ronment:

VS-2003 and 2005 (ASP.Net, C#, VB.Net), MS SQL Server 2000, 2005, Altova XML Spy, Install shield 11.

Vidyavardhini's College of Engg (VCET) (Nov 2003 - July 2004)

Client: EXTC Dept. VCET

P roject: Network /System Management (Nov 2003 - July 2004) (Work-Location: I ndia) Role:

N etwork/System Admin

Responsibilities:

• Design and Implementation of entire department network.

• Domain administration

Technical Envi ronment:

L inux-Red hat, Windows 2000 Edition, VS-2002, MS SQL Server 2000.

V ishal Patil (Atlanta GA) 201-***-****

*************@*****.***

7

Contact this candidate