Sql Server Project
Resume:
Ms. Arati Awati
Software Developer
**********@*****.***
Professional Summary
. Software professional with 12+ years of experience in design,
development and implementation of large business and database
applications.
. Core skills in VBA, VB 6.0, VB.Net, C#, MS SQL Server, MS Access,
Excel, SSIS, Crystal Reports.
. Proven experience in delivering solutions for Financial Services and
ERP domain.
. Deep expertise in MSSQL Server, TSQL, complex Stored Procedures,
Queries, Views, triggers etc.
. Hands-on experience in application, product development / service
provider organization. Worked on offshore-onsite model.
. Performed role of team leader / senior developer and successfully
completed multiple projects with team size from 5 to 25.
. Expertise in requirement analysis, data modeling, application design
and development, QA and complete software development lifecycle
[SDLC].
. Familiar with scrum master activities / methodology.
Strengths
. Focused approach towards achieving goals.
. Ability to work on multiple projects and with multiple teams.
. Strong Analytical skills.
. Self-Driven.
. Reliable, Resourceful and Efficient team player.
. Ability to adapt quickly to new technologies and tools.
. Excellent oral and written communication skills.
Technical Skills
. Programming Languages: VBA, VB 6.0, VB.net, C#, XML, TSQL
. Database: MS-SQL Server 2000/2005/2008, MS Access, Excel.
. ETL Tools: SSIS
. Modeling Tools: Erwin, MS Visio and Enterprise Architect.
. Packages: MS Office 2010, VSS, TFS, Crystal Report, MS Project
. ERP: Microsoft Dynamics NAV 2009, Sixth Sense V2.0.
Education
. Masters in Computer Application (MCA), IGNOU (INDIA)
. Bachelor in Computer Science (BCS), University of Pune (INDIA).
Certifications
. Microsoft Certified Technology Specialist: Web Application development
using ASP.NET, C#.
. Microsoft Certified IT Professional: Developer for Microsoft Dynamics
NAV 2009 [C/SIDE Introduction, C/SIDE Solution Development, Core Setup
and Finance].
Work Experience
. CPG, New York, NY (Employer: Sunray Corporation) : [Financial Services
Domain, Check Processing, Payments Processing, WEB ADI] - (From Jan
2014)
. Protos Solutions LLC. (Employer: Sunray Corporation) [Finance
domain, Project Accounting/Portfolio Management] - 16 Months (Oct
2012 to Jan 2014)
. Credit Suisse, New York, NY. (Employer: Letse Software & Services )
[Financial Services Domain, product for Portfolio Management] - 10
Months (From Sep 2010 to June 2011)
. Iota Technologies Limited. Involved in building large applications for
ERP domain. - 5 Years (Sep 2005 to Sep 2010).
. C-DAC, Pune, India. Senior Software Engineer - 5.7 years.
. Spectron Powerbus. Software Engineer. - 2 years.
Project Details
1. Duration : From Jan 2014
Employer: Sunray Corporation. Client: Church Pension Group (New York)
> Project Description: Payments Processing.
The project involves interfacing several spreadsheets with
Oracle database for carrying out payments processing workflow
and reports. Primary technology used was VBA, Excel 2010 and SQL
Server.
Responsibilities:
. Analyze existing system design and user requirements.
. Design and development using VBA to meet the requirements.
. Unit testing and assistance for QA and UAT.
. Migration of code from Excel 2003 to Excel 2010.
. Refactoring of legacy code for smooth functioning.
Technologies:
. Excel 2010 and VBA.
. SQL Server.
2. Duration : Oct-2013 to Jan-2014
Employer: Sunray Corporation. Client: Protos Solutions LLC (Phoenix,
AZ)
> Project Description:
Project portfolio accounting system is an automation project of a
highly distributed environment where project expenses and work
details flow in through spreadsheets from hundreds of projects
sites. The sheets are processed using VBA to pass the claims and
expenses, import bank statements and reconcile it with the bills to
generate outstanding amounts for each bproject as well for the
whole portfolio.
Responsibilities:
. Analyzing the workflow and dataflow.
. Interaction with business users for requirements signoff and
prototype approval.
. Development of business logic using SQL Server.
. Coding for functionality using VBA and VB6.0
. SSIS package development for import of data.
. Unit testing and assistance for QA and UAT.
Technologies: VBA, SQL Server, Excel, SSIS.
3. Duration : Sep 2010 - Jun 2011
Employer: Letse Software & Services. Client: Credit-
Suisse (New York)
> Project Description: Portfolio Management System.
. The project aims at transforming the client's wealth management
review, client reporting system from older disintegrated model to
single integrated wealth management and advisory system for
maximizing portfolio manager's productivity and enhanced client
experience for various geographies.
. The system contains data aggregation (Asset classes like Equity,
Asset Management, Bank Accounts, Mutual funds, Structured
Products etc.)
. Client Portfolio and Performance Management.
. Reviews, Financial planning, Sales Prospecting, Order Processing,
Application Administration.
Responsibilities:
. Development of business logic using SQL Server.
. Coding for functionality using C#, VB6.0
. SSIS package development.
. Internal quality checking of product.
. High level sequence and data flow diagrams for iteration
requirements.
Technologies: VB6.0, SQL Server, SSIS, C#(.Net4.0)
4. Duration : Sep 2005 - Sep 2010
Employer: Iota Technologies Ltd (INDIA)
> Project Description: Task Management System [PMS].
. The Product aims at resource management and daily task
management of resources working on project. Useful for all type
of projects in various industries.
. Automated process starting from requirement given by business up
to QA final status remark.
. Facility for client to enter feedback against deployed
application / module / deliverable.
. Facility to convert client feedback into task to concern
department / resource.
. Approval and check facility to approve client / business
requirements by senior authorities.
. Report generation for management and senior authorities as well.
Responsibilities:
. Business process and requirement clarification with client top
management, end users as well.
. Conversion of requirements into technical as well as functional
specifications.
. Development of business logic using SQL Server.
. Coding for functionality using VB6, VBA and VB.Net
. Internal quality checking of product.
. Report generation / design using Crystal Report.
. SSIS package development
Technologies: VBA, VB6, VB.Net (3.5), SQL Server, Crystal Report,
XML.
> Project Description: ERP System.
. The project aims at Enterprise Resource Planning for medium and
small scale manufacturing industry, diverse domains like
automotive, electrical, electronics, logistics, projects,
trading.
. Automating the entire business process of industry through single
software, starting from Inventory to Excise.
. Various modules like Production, Inventory, Finance, Excise, TDS,
Payroll, HR, Sales and Purchase.
. Integrating processes like AR/AP/GL with other business
processes.
. Designed framework to import master data from external systems to
generate base for ERP modules. The system uses three tire
architecture with strong database support for application
performance and also XML to save and load data.
. Report generation for MIS reports and other statutory documents.
Responsibilities:
. Business process and requirement clarification with client top
management, end users as well.
. Conversion of requirements into technical as well as functional
specifications.
. Development of business logic using SQL Server.
. Coding for functionality using VB6 and VBA.
. Internal quality checking of product.
. Report generation / design using Crystal Report and XML.
Technologies: VB6, VBA, SQL Server, Crystal Report,
XML, SSIS.
> Project Description: Application software for Bank Reconciliation
for trading unit [Client: Protos Solutions LLC, Arizona, USA]
Responsibilities: Technical Lead
Technologies: VB.Net, VBA, Access, Excel.
> Project Description: Content Management System for real estate
portal [USA]
Responsibilities: Senior Developer.
Technologies: VB.Net, MySQL.
5. Duration: Feb 2000 - Sep 2005.
Employer: C-DAC: Center for Development of Advanced Computing (INDIA).
> Project Description: Development and Maintenance of various
application software for ALL India Education Network of C-DAC, like
1. Center Management System,
2. Revenue Management System,
3. Student Enrolment System.
4. E-Exam system.
5. MIS report generation using Excel and Crystal Reports.
6. Consolidated application for all developed systems.
7. Support to web based development team.
Responsibilities: Senior Developer.
Technologies: VB6.0, VBA, SQL Server, MS Access, Crystal Report,
.Net2.0
6. Duration: Oct 1994 - Oct 1996.
Employer: Spectron Powerbus Pvt Ltd. (INDIA).
> Project Description: Small ERP system for UPS manufacturing
company. Modules like Sales, Purchase and Inventory.
Responsibilities: Software Developer.
> Project Description: Fixed Deposit Management System, for investors
in manufacturing company.
Responsibilities: Software Developer.
> Project Description: Analogue Data Acquisition System for
electronics component manufacturing company.
Responsibilities: Software Developer.
Selected Achievements
. Received appreciation letter from client for documentation and client
communication.
. Received Best Performer of the year for continuous 3 years.
. Received twice Appreciation Letter from Customer for achieving go-live
targets.
. Received Appreciation Letter for design and development of Application
software 'DC Converter' for Analogue Data Acquisition System.
[pic][pic][pic]
Contact this candidate