Darshan Ingale
[pic]
Mobile: +91-981*******
Email: ****.*******@*****.***
In quest of assignments in the domain of Software Development preferably in
Business Intelligence to deliver solutions for complex technical
requirements.
PROFESSIONAL ABRIDGEMENT
A dynamic professional with more than 6 years of rich experience in
Software Development. Currently associated with Emerson Export Engineering
Centre as SQL Developer.
Expertise in end-to-end development of applications from Requirement
Analysis to System Study, Documentation and Testing. Demonstrated abilities
in analyzing information system needs, evaluating end-user requirements.
Strong Problem Solving & Technical Skills coupled with confident decision
making for enabling effective solutions leading to high customer
satisfaction.
IT SKILLS
Development Tools Visual Studio 2003, 2005, 2008.PL-SQL
Developer,TOAD, SSIS,SSRS and SSAS, Clarity 12.1.0
Languages C#/VB.Net (Web & Windows), LINQ, JavaScript, ADO.Net,
Classic ASP
Technologies ASP.Net, Crystal Reports XI
Database SQL 2000, SQL 2005,SQL2008, Oracle 9i
Source Control Visual Sourcesafe
Basic knowledge of Oracle 11g .
CAREER CONTOUR
Apr'12 - till date Emerson Export Engineering Centre
(Through e-Zest Solutions Ltd)
Nov'11 - Apr' 12 Royal Bank of Scotland, Mumbai as Executive
Jun'10 - Oct' 11 Royal Bank of Scotland, Mumbai as Senior Software Engineer
(Through Agile Financial Technologies Ltd)
Jun '07 - Jun'10 ICICI Bank Ltd, Mumbai as Software Engineer
(Through Techprocess Solutions Ltd)
Core Competencies:
Software Development
< Conducting system study, system design and integration, implementation
etc.
< Understanding business requirements, identifying systems and getting it
developed and maintained.
< Resolving queries regarding the application developed and maintenance of
software support.
Project Management
< Mapping requirements and providing best solutions involving evaluation
and definition of scope of project and finalization of project
requirements.
< Holding review meetings to monitor progress of the project as per the
schedule and ensuring timely completion and delivery of project to the
client.
Major Projects Handled:
Project and Resource Management (Ongoing maintenance Project)
- This is web based project and resource management tool which is
developed by Clarity and SQL server 2008. This is a ongoing
activity for some kind of maintenance and enhancement.
- Front End - Clarity v12 by CA
- Back End - SQL SERVER 2008 R2
Role: Clarity & SQL Developer.
o Have created multiple tools for Clarity related maintainance such as
Bulk Project Load, Bulk Resource Load thereby reducing load of
Support team.
o Undertaken tasks which comprised of converting Traditional Data
Extracts to Daily/Weekly Schedulers thereby reducing human
intervention in daily-to-day extracts.
o Undertaken tasks to convert process of Manual Data load of Clarity to
ETL packages thereby achieving better error logging and reduction of
manual efforts.
o Design and develop T-SQL procedures, query performance tunings.
o Weekly meetings with UK and USA clients related to business
enhancement.
o Plan, design, and implement application database code objects, such as
stored procedures, User Defined Functions and views.
o Build and maintain SQL scripts, indexes, and complex queries for data
analysis and extraction.
o Support team in Resolving SQL Reporting services and T-SQL related
complex issues.
[pic]
Project Survey Tool (PST)
- This project is used to take end user survey for different phases
(i.e. Post-FEED, Post-DE&D, Post-FAT, Post -Project). The primary
users are World Area Quality Leader, Project Manager, Project
Planner and Admin.
- Front End - .Net 3.5
- Back End - SQL SERVER 2008 R2
Role: SQL Developer.
o Database design and development according to user requirements.
o Implement application database code objects, such as stored
procedures, User Defined Functions and views.
o Development & maintainance of cubes designed to fetch data from
Clarity and used in PST.
o Developing Interface of PST with Clarity Database.
o Developing Reports in Crystal Reports XI in Clarity based on PST data.
[pic]
Private Banking Datawarehouse Application (PBDWH)
- Project is a tool to automate MIS generation process and help
enhance various dimensions of the Decision support and Sales
Management activity.
- Front End - DatawareHouse Project (Vb.Net) with VS 2008
- Back End - SQL 2005
Role: Software Developer
o Development in application and database level as per client requirements
of Private Banking group.
o Releasing the requirements on production and technical support for issues
and new requirements.
o Integration of data feeds done from various system into the Data
Warehouse to provide near real-time MIS information to stakeholders.
o Information related to AUM, Revenue, NNA, client count, etc., collated
from various source systems across product lines.
o Implementation of graphical representation of the data with capability to
drill down to the transaction level and also roll up to the Branch,
Market & Country level where applicable.
o Slice & Dice tool made available for various analysis to Decision Support
and Sales management team.
[pic]
Agent Partner Banking Interface System (APBIS)
- Project is a tool for data transfer between back office systems of
the National Australia bank and 3rd party customers.
- Front End - Console Application with Vb.Net 2005.
- Back End - Oracle 9i
Role: Software Developer
o Development in application and database level as per client requirements
in Australia and Unit Testing of the same.
o Releasing the requirements on production and technical support for issues
and new requirements.
o Validation and processing of different types of input files basis the
business norms and posting the data to SCORE system or ACME database as
per its categorization.
o Outgoing clearing transactions extracted from ACME database and passed to
Partner Bank for central clearing.
o Transaction and summarized reports made available to operations team on
daily basis.
[pic]
Integrated Treasury Limits Application (ITLA)
- A web based application used by Treasury Middle Office Group of
ICICI BANK LTD to create counterparty groups and allocation of
limits.
- Front End - Web Application with ASP.Net 3.5
- Back End - Oracle 9i
Role: Software Developer
o Development in application and database level as per bank's requirement
and Unit testing of the same.
o Releasing the requirements on production and technical support for issues
and new requirements.
[pic]
Integrated Approval System (IAS)
- A web based application to keep track of the compensation given to
the customers and approvals given by the approving authority at
various levels, as well as provide MIS reports for the same.
- Front End - Web Application with ASP.Net 2.0
- Back End - SQL SERVER 2005
Role: Software Developer
o Maintenance of the application at the application and database level.
o Resolving bugs and issues and provide technical support.
SCHOLASTICS
o B.E in Information Technology from VESIT, Chembur. Mumbai University.
o 12th from K.V.Pendharkar College, Dombivli. HSC Board
o 10th from Sister Nivedita School, Dombivli. SSC Board.
PERSONAL FORTE
Marital Status Married
Sex Male
Date of Birth 05 June 1983
Languages Known English, Hindi, Marathi
Address S.No-48/1/1,48/2/1,Flat No 701,K-3, Katepuram Phase II,Pimple
Gurav,Pune 411027.INDIA
Passport No G6842834
REFERENCES
Name Aniket Pathak
Job Title Program Manager (HSBC)
Contact 981-***-****
Name Bhushan Daga
Job Title Project Leader (RBS)
Contact 989-***-****