Vishesh Patel 862-***-****

SUMMARY:

Very good knowledge on working with SSRS/SSIS/SSAS.

Knowledge SSIS Customization and deployment by extending Business Intelligence Framework.

Expertise in writing complex Stored Procedures and views for SSIS, SSRS in SQL Server.

Expertise in database transactions using SQL Server, Oracle, MS Access. Hands on experience in creating Triggers, Cursors, Views and Indexes.

Knowledge of Stored Procedure performance tuning with good understanding of execution plan.

Can gather business requirements, requirement analysis, system design, data modeling, writing technical specification, and production support.

Can consider myself good coordination, team skills, troubleshooting, and issue resolution capabilities.

Excellent communication, analytical skills and Inter personnel skills.

Exceptional ability to learn new concepts. Skilled at assessing client needs, working in a group, suggesting ideas that enhance efficiency and maximize performance, implementing cutting-edge technology solutions, and training/supporting end users.

Flexible and versatile to adapt to any new environment and work on any project.

SKILLS:

Latest Technical skill Details

. Net Technologies

.Net framework 4.0, 3.5, 3.0 & 2.0, Asp.Net2.0, WCF, C#.Net, ADO.Net

Languages

C#, SQL, C, C++,8086 & 8051 Assembly Language, J2EE

Middleware

SQL Server Integration Services (SSIS), IIS

Web

PHP, WCF, ASP.Net, Ajax, CSS, (X)HTML, HTML

Scripting Languages

VBScript, Java Script, JQuery

Operating Systems

Windows XP/2003/2008, Windows 8, UNIX

DBMS

SQL Server, SSAS, OLAP, Oracle, MySQL, MS-Access, FoxPro

IDE Tools

VS.Net 2012, 2010, 2008, 2005, NetBeans 4.1, SunOne Studio 8, BEA’s Web Logic 8.0

Report Tools

SSRS, Power Pivot, Power View, Crystal Reports,

Webserver

IIS

Version Controller

TFS, VSS

Others

MS Office 2003/2007/2010, FTP, Web analytics tools, UML, Software Engineering, Embedded System

Designing & Animation

Adobe Photoshop, Flash, Dreamweaver

Education:

•Master of Science (Computer Science) from University of Bridgeport, CT, 2010.

•Master of Science (Information Technology) from Veer Narmad South Gujarat University, Gujarat, Jun-2007(68%).

•Bachelor of Science (Information Technology) from Veer Narmad South Gujarat University, Gujarat, June-2005(69%).

Experience:

CIT-Bank - ICSXPress (Inter-Company Cash Settlement) Nov 2014 – Jan 2015

Business Intelligence Developer

CIT Bank finances its operating units across globe. Any cash settlement between these operating units, across currency involves CIT bank directly. It handles Direct and Indirect settlements.

Responsibilities:

•Worked with Business executives to collect integration requirements for Inter Company cash settlement.

•Developed Multi-Dimensional Data Model for Cash Settlements, which is used for analyzing lagging settlements with operating units.

•Responsible for developing store procedures and SSIS packages to import data into ICSXPress from Accurate system.

•Designed and Developed database objects like table, views, Store Procedure, Triggers, Functions and etc., for settlement data integration related processes.

•Cursors were developed to support SSIS Package which generates flat file feed for Cash Settlements.

•To simplify complex queries properly used joins, sub queries, and temporary tables wherever required.

•Consumed Accurate and PeopleSoft services in SSIS packages and import the good-to-settle data; data includes all good –to-settle data which are held from previous settlement period.

•Developed SSIS Packages to handle multiple credits and debits transactions which make up offset, with the help of 6 predefined fields from Accurate System.

•Developed a DB Process to group all matching Auto blocks and Offset transactions in to a batch and non-matching transactions to hold transactions.

•Developed Stored Procedures which are used in configuring and executing auto block rules to hold or un-hold transaction.

•Developed SSIS Packages to handle feedback system on wiring process, which is consumed by PeopleSoft system.

•Taken care performance issues in stored procedures developed by other team members as part of review.

•Developed Notification Model, for all SSIS packages to report about SSIS Job status.

•Cash Settlement Reports are developed in SSRS Parameterized reports, Pivot Reports.

•Taken care of deployment of SSIS packages and SSRS reports with release notes.

•Apart from SSRS reports, developed a workbook and data model in excel using Power Pivot and Power View to fulfill business requirement of balancing payable and receivable accounts.

•Documented Integration & Reporting related design overview including field mapping sheet.

Environment: MSBI 2010, SSIS 2012, SSRS 2012, SSAS 2012, OLAP, C#.Net, SQL Server 2012, TSQL, Power BI

Achievements:

•Won Project competition at state level originated by IBM and GIL (Online District Collectorate Office).

•Won third prize in state level programming competition held at Bharuch, Gujarat (India).

•Won second prize in college level project competition held by M.Sc. (I.T.), Surat, Gujarat (India).

Contact this candidate