SQL Server, SSIS, SSRS and Crystal Report Developer
Resume:
Asha patil
Asha is a Software Engineer for SunGard Global Services' in PUNE office.
She has 4 years of experience in software / IT Services industry. She has
been involved in various stages of software development lifecycle -
Requirement Analysis, Design, Development. She is a good team player and
has an experience in managing project related communications between onsite
and offshore. She is proficient in developing Business Intelligence
solutions using Crystal Report XI, SSRS and also developed reports using
Excel VBA Macros. Asha also has a good working experience in .Net, SQL
server 2005 and SSIS.
Summary
Industry Experience
Organization Name : SunGard Global Services.
Designation : Product Developer / Engineer
Experience : 1.3 Year (May 2011 - August 2012)
Organization Name : Yardi Software India Pvt. Ltd.,Pune.
Designation : Programmer.
Experience : 1.4 Year (December 2010 - April 2011)
Organization Name : Mechatronics System Pvt. Ltd.,Pune.
Designation : Software Engineer.
Experience : 2.2 Years(September 2007 - November 2009)
TECHNICAL SKILLS
Databases: MS-SQL Server 2000/2005, T-SQL, Oracle.
Language: VB.Net, ASP.Net
Reporting Tools: Crystal Reports XI, SSRS,SSIS, VBA
Macro programming
Education
B.E. (Information Technology) from Shivaji University. Kolhapur,
Maharashtra.
Specialization
Microsoft Certified Technology Specialist (MCTS) Certification in (SQL
Server 2005)
DETAILED EXPERIENCE
Organization Name : SunGard Global Services.
Designation : Product Developer / Engineer
Experience : 4 months (April 2012 - August 2012)
Project : Intramis
Environment : SSIS, .NET framework 4.0, ASP.NET MVC 2.0, SVN
Intramis application is mainly used for Failed Trade Reporting and
Reversals/Backdate Workflow Processing. Failed transactions are reported
and users can opt to revert\backdate the transactions based on their role
and the status of the transaction. The older system was built using DTS
packages and PHP web front with third party authentication mechanism called
Siteminder. It had various performance issues. Hence, the system was
migrated to .NET platform. The project involved developing the user
interface with ASP.NET. The database was upgraded from SQL Server 2000 to
SQL Server 2008. The DTS packages were replaced by SSIS packages. The
application uses WCF Services to expose the backend functionality to web
front.
Responsibilities :
. Requirement Analysis, Implementation, Unit Testing, Bug fixing,
feature enhancements & Client Communication
. Written SSIS packages for data tranformations.
. Developing ASP.net pages for front, creating services
. Written SQL stored procedures.
. Conducting training sessions of SSIS.
Organization Name : SunGard Global Services.
Designation : Product Developer / Engineer
Experience : 6 months (Oct 2011 - March 2012)
Project : Investran
Environment : SSRS, .NET framework 4.0, ASP.NET MVC 2.0, SVN
Developed SSRS report in Investran, Investran in Sungard's reporting
Wizard.
The Investran RW OLEDB Provider is a standards-based client/server
middleware product that allows clients to access the Investran reporting
databases using existing software, operating systems, and network
infrastructures. The RW OLEDB Provider is an independent component that can
work in tandem with an Investran suite installation. Alternatively, the RW
OLEDB Provider can be independently registered and installed on a
workstation or system that does not have any Investran modules installed,
provided that the target workstation has network access to the database
servers.
Responsibilities :
. Requirement Analysis, Implementation, Unit Testing, Bug fixing,
feature enhancements & Client Communication
. Written SSIS packages for data tranformations.
. Written SQL stored procedures.
. Conducting training sessions of SSRS .
. Conducting training sessions of Investran Reporting Wizard.
This reports was developed for private equity client like advent
international and EQT . This report are integrated in Sungards's Reporting
wizard Investran
Organization Name : SunGard Global Services.
Designation : Product Developer / Engineer
Experience : 4 months (Aug 2011 - Sept 2011)
Project : CAIC-SAS
Environment : SSRS, .NET framework 4.0, ASP.NET MVC 2.0, SVN
CAIC currently uses an outdated fat client system called Primea. Primea is
not meeting the needs of CAIC as they grow and expand into new markets.
CAIC-SAS is Optimized for low bandwidth high latency scenarios, Highly
structured / organized solution, Intuitive - easy to use screens, Elegant,
but simple application architecture, Design which scales as the company
grows, Readily provide data needed to its users so they can make smart,
timely business decisions. This application can be used by customers to buy
policies online, can be used by agents, general agents to enter offline
sold policy details. Underwriter can use this application to validate and
approve policy. Auditors can use it to audit the policy. Reports have been
integrated for management to make smart and timely business decisions.
Responsibilities :
. Requirement Analysis, Implementation, Unit Testing, Bug fixing,
feature enhancements & Client Communication
. Creation of Policy Aging report in SSRS. Policy Aging report is a
receivable report, which looks at policies that have not been marked
as paid and / or that have been partially paid
. Creation of Inventory receipt report in SSRS. Inventory receipt report
shows all the inventory policies per prefix/product assigned to an
agent
. Creation of Production report in SSRS. Production report is an
extension of existing UPR report, wherein current UPR report scopes in
only active policies and this new report considers all policies.
Organization Name : Yardi Software India Pvt. Ltd.Pune.
Designation : Programmer.
Experience : 1 Year(December 2010 - Dec 2011)
Project : Yardi Voyager
Environment : Crystal Report 9, SQL server 2005
Yardi is the product base company, which provides solutions for real estate
management. Voyager is the web-based software, which manages the various
needs of the property managers, owners and investors. Voyager has different
modules like Residential, Commercial, International, Affordable, Student
Housing, Public housing. I was working in Custom Programming team that
provides custom programs/ modules to the clients as per their requirement.
Responsibilities:
. Customize the crystal reports as per client's requirements.
. Designed new reports.
. Fixed data issues.
. Designing & developing stored procedures, functions, triggers &
indexes etc database objects.
. Tuned SQL queries and procedures for better performance.
Developing crystal reports, Excel reports, HTML/ASP pages for front
end reporting & supportive data entry screens
. Involved in the client and account manager call.
. Conducting training sessions to new employee of crystal reports,
coding guidelines.
Organization Name : Mechatronics System Pvt. Ltd.,Pune.
Designation : Software Engineer.
Experience : 2 Years(September 2007 - November 2009)
Project : Monitoring System for Water Distribution
Client : Nagpur Municipal Corporation.
Technology : VB.Net, ASP.Net
Database : SQL Server 2005.
There are existing 32 locations of ESRs/GSRs/MBRs locations which would be
monitored by this system for various parameters like flow, level, pressure,
residual chlorine etc. To list some of the functionalities,
1. It provides continuous real time data monitoring from Municipal head
office of water inventory. And in flows at each ESR and water
inventory at MBR.
2. It provides graphical trending diagrams of water balance (Pie Chart)
of all ESRs/GSRs.
3. It Provides Water Audit Chart
4. It Provides alerts, in case of emergency, to the appropriate
authorities to quickly initiate actions for disaster management.
5. Sending alarm SMS messages in case of emergency, to NMC engineers.
Responsibilities:
. Requirement Gathering and Understanding.
. Written code in VB.net for developing software.
. Written code for sending SMS using GSM Modem.
. Created report in crystal XI.
. Created Assemblies in Vb.net.
. Written Stored Procedure and functions in SQL 2005.
2
TITLE
2
Resume: Asha patil
ASHA PATIL
1
Contact this candidate