Sql Server Data
Resume:
CURRICULUM VITAE
Nibedita Ray
Phone No. : 404-***-**** Email ID: ********.*****@*****.***
PROFESSIONAL EXPERIENCE
. Working as System Analyst in Larsen & Toubro LTD,India from Sept 3rd
2007 to Sept 2010.
. Worked as a Software Engineer in Sytran Solutions,India from Jun 2006
to June 2007.
. Worked as a computer programmer in OSL,ORISSA,India from May 2005 to
June 2006
INDUSTRIAL EXPOSURE
. Have 5+ years of Professional experience in database analysis,
design and development.
. Have 3+ years of experience in Finance domain like General ledger
processing, Accounting, ERA credit, Trial balance/Bank book etc.
. Experience in complex database queries, creating Tables,
Constraints, Indexes, Views in Oracle9i/10g.
. Proficient in developing Windows-based and Web-based applications
in VB.NET, ASP.NET, Visual Studio.NET using various Frameworks.
. Strong UI design skills in HTML/DHTML, JavaScript
. Expert in Database Design and writing Stored Procedures using
Oracle9i/10g.
. Expert in writing Packages using Oracle 9i/10g
. Experience in Cursor, Ref Cursor and Dynamic sql using Oracle
9i/10g.
. Database Optimization and Performance Tuning using Toad.
. Expert in writing Functions and Triggers using Oracle 9i/10g.
. Good understanding of data structures and algorithms.
. Ability to work within a fast-paced environment, self-starter and
highly motivated individual with excellent problem solving skills
and leading teams of small size.
. Outstanding problem solving, strategic thinking and data analysis
skills.
TECHNICAL STRENGTH
.NET Technologies ASP.NET 3.0, VB.NET
Web Technologies JavaScript, AJAX, VBScript, XSD
Databases Oracle 9i/10g, SQL server
MS SQL Server 2000/2005/2008, Oracle 9i/10g, MS
Access.
Development Tools Visual Studio.NET 2005/2008, SQL Server Management
Studio, SQL Server Enterprise Manager, Query
Analyzer, MSBuild, NAnt, NUnit
Operating Systems Windows 2000/XP/NT/98/Vista, UNIX
Web Server IIS 5.0/6.0.
Middleware Web services, .NET Remoting, DTS
Reporting Tools Crystal Reports 9/10, SQL Server Reporting
Services (SSRS)
Query Languages PL/SQL (Oracle), T-SQL (SQL)
CERTIFICATIONS
# Certification Type Grades Remarks
1 OCA 9i Level 1(SQL)(1z0 007 73.1%
2 OCA 9i Level 2(PL/SQL)(1z0 147 89.4% OCA 9i Certified
3 Oracle 9i Form Developer(1z0 141 85.6% OCP 9i Certified
ACADEMICS
Completed Bachelor of Engineering with (COMPUTER SCIENCE) in June 2005
from BPUT, Orissa.
Completed Higher Secondary Education (12th Standard) in June 2000 from
C.H.S.E, Orissa.
Completed Secondary School Certification Education (10th Standard) in
June 1998 from BSE,Orissa
PROJECTS DONE
Project 1:
Title : RBS (Retirement Benefit System)
Role : Team Lead
Software : vb.net/Oracle
Client : L&T Group of companies
Description: Currently i am working on Retirement benefits of L&T group
of companies (PF, EPS, Gratuity & SAF etc) . Eligibility criteria,
Contribution Accumulation from Employee(With Payroll Integration - Salary
processed in PRM &With Data upload - Salary processed outside of
PRM),Interest calculation & PF Slip generation, PF Transfer - Inward &
Outward,PF/Gratuity Settlement Processing, Loan Processing, PF/Gratuity
Nomination(s),EPS Register & EPS Slip generation, Accounting & Trial
Balance, Trust wise.
Responsibilities:
Understanding System requirements and Estimating Project
timeline.
Performed design, coding, implementation and support.
Applying the Three Tier Architecture (Presentation Layer, Business
Logic Layer, and Data Access Layer) to the application.
Writing stored procedures, functions, joins, indexes, triggers and
views in Oracle at backend level.
Worked on Toad for Oracle to be more productive by providing an
intuitive graphical user interface to Oracle which is a powerful, low-
overhead tool that makes PL/SQL development faster and easier and
simplifies database administration tasks.
Quest Software has been used to simplify, automate and improve the
quality of application and database development.
Knowledge of Data Model objects.
Gathered requirements and design of Data warehouse and data mart
entities.
Extensively worked with Data Grid, data serialization and generic
classes.
Worked on SSIS for transfer, copy, extracting the data between
different data sources.
Advanced extensible reporting skills using SQL Server Reporting
Services (SSRS)
Implemented the POP3/SMTP email features from the code page.
Involved in Creating Technical Design documents with Flow Charts and
Sequence Diagrams explaining the flow of events.
Extensively worked on master pages and themes.
Secured the System using authentication and authorization.
Environment: Oracle 10g, Toad, SQL Devloper.
Project 2:
Title : EBC (Employee Benefit Claims)
Role : Team Lead
Software : vb.net/Oracle
Client : L&T Group of Companies
Description: This was a developmental project on different benefit claims
of Employee(s) for L&T Group of companies. Based on eligibility,
availability of Claim in portal, lodge the claim, different stages like
(scanning/Receiving of document), approval/Processing and send back
workflow from employee to processor and vice versa. and accounting/Ledger
processing for day to day transaction.
Responsibilities:
Understanding System requirements and Estimating Project
timeline.
Performed design, coding, implementation and support.
Applying the Three Tier Architecture (Presentation Layer, Business
Logic Layer, and Data Access Layer) to the application.
Writing stored procedures, functions, joins, indexes, triggers and
views in Oracle at backend level.
Worked on Toad for Oracle to be more productive by providing an
intuitive graphical user interface to Oracle which is a powerful, low-
overhead tool that makes PL/SQL development faster and easier and
simplifies database administration tasks.
Quest Software has been used to simplify, automate and improve the
quality of application and database development.
Knowledge of Data Model objects.
Gathered requirements and design of Data warehouse and data mart
entities.
Extensively worked with Data Grid, data serialization and generic
classes.
Worked on SSIS for transfer, copy, extracting the data between
different data sources.
Advanced extensible reporting skills using SQL Server Reporting
Services (SSRS)
Implemented the POP3/SMTP email features from the code page.
Involved in Creating Technical Design documents with Flow Charts and
Sequence Diagrams explaining the flow of events.
Extensively worked on master pages and themes.
Secured the System using authentication and authorization.
Environment: Oracle 10g, Toad, SQL Devloper.
Project 3:
Title : Star E-Claims
Role : Analyst
Software : .net/SQL server
Client : Star TV
Description: This was a developmental project on different benefit
claims of Employee(s) for Star group of companies. Based on eligibility,
availability of Claim in portal, lodge the claim, different stages like
(scanning/Receiving of document), approval/Processing and send back
workflow from employee to processor and vice versa. and accounting.
My role in this project was to be a single point of contact from clients
and lead a team of 6 people working to develop star e-claims.
Responsibilities:
Understanding System requirements and Estimating Project
timeline.
Performed design, coding, implementation and support.
Applying the Three Tier Architecture (Presentation Layer, Business
Logic Layer, and Data Access Layer) to the application.
Writing stored procedures, functions, joins, indexes, triggers and
views in Oracle at backend level.
Worked on Toad for Oracle to be more productive by providing an
intuitive graphical user interface to Oracle which is a powerful, low-
overhead tool that makes PL/SQL development faster and easier and
simplifies database administration tasks.
Quest Software has been used to simplify, automate and improve the
quality of application and database development.
Knowledge of Data Model objects.
Gathered requirements and design of Data warehouse and data mart
entities.
Extensively worked with Data Grid, data serialization and generic
classes.
Worked on SSIS for transfer, copy, extracting the data between
different data sources.
Advanced extensible reporting skills using SQL Server Reporting
Services (SSRS)
Implemented the POP3/SMTP email features from the code page.
Involved in Creating Technical Design documents with Flow Charts and
Sequence Diagrams explaining the flow of events.
Extensively worked on master pages and themes.
Secured the System using authentication and authorization.
Environment: Oracle 10g, Toad, SQL Devloper.
Project 4:
Title : PRM (Payroll Management)
Role : Designing, Development and Coding.
Softwares : .net/Oracle
Client : L&T Group of Companies
Description: This project was to develop a web application for the
clients/Employee(s). The application was named Payroll Management (PRM). It
helped the clients to Create the employee, update the status any time and
process the salary for 32 entities based on Employee band and grade.
Generating the Jounals/Bank files and passing the accounting entries.
Responsibilities:
Performed design, coding, implementation and support.
Applying the Three Tier Architecture (Presentation Layer, Business
Logic Layer, and Data Access Layer) to the application.
Writing stored procedures, functions, joins, indexes, triggers and
views in Oracle at backend level.
Worked on Toad for Oracle to be more productive by providing an
intuitive graphical user interface to Oracle which is a powerful, low-
overhead tool that makes PL/SQL development faster and easier and
simplifies database administration tasks.
Quest Software has been used to simplify, automate and improve the
quality of application and database development.
Knowledge of Data Model objects.
Gathered requirements and design of Data warehouse and data mart
entities.
Extensively worked with Data Grid, data serialization and generic
classes.
Worked on SSIS for transfer, copy, extracting the data between
different data sources.
Advanced extensible reporting skills using SQL Server Reporting
Services (SSRS)
Implemented the POP3/SMTP email features from the code page.
Involved in Creating Technical Design documents with Flow Charts and
Sequence Diagrams explaining the flow of events.
Extensively worked on master pages and themes.
Secured the System using authentication and authorization.
Environment: Oracle 10g, Toad, SQL Devloper.
Place:
(Nibedita Ray)
Date :
Contact this candidate