Sangeeta Dutta
SUMMARY:
• Microsoft and Sun certified professional with 7 plus years of experience in
Application Development.
• Experienced in N-Tier client/Server/Cluster/Virtualization, Data Management
(Data Warehouse, Data Mart, OLTP, DSS).
• Experience in Oracle 8/9/10g, SQL server 2000/2005, MS Access.
• Skilled in Web Development with both Oracle and Microsoft SQL Server Databases
and Visual Studio.Net product suite with C# .Net ,VB.Net, ADO.Net, ASP.NET
Framework.
• Experience ASP.Net and WCF Web Service Developer
• Very good experience in Stored Procedures, Triggers, PL/SQL
• Proficient with Data Loading Mechanism (ETL) – BCP, Bulk Insert, SSIS
• Enhanced trouble shooting skills along with experience working with Oracle
DBA, System and Network Engineers.
• Good understanding of Backup and Recovery.
• Excellent communication skills with the ability to act as a bridge between the
technical and the non-technical.
• Ability to learn and understand business logic associated with a complex
environment.
CERTIFICATION :
• Working towards Microsoft Certified Technology Specialist (MCTS) – DBA and
Developer
• Microsoft Certified Technology Specialist (MCTS) - .Net Framework 2.0
• Microsoft Certified technology Specialist(MCTS) - Web Application
• Sun Certified Java Programmer (SCJP)
• Sun Certified Unix System Administrator
• Oracle Certified Database Administrator
TECHNICAL SKILLS:
Relational Databases MS SQL Server 2000/2005, Oracle 9i/10g, Sybase, MS Access
RDBMS Tools PL/SQL, T-SQL,SQL*Plus,BCP,SQL*Loader, TOAD, ERWIN.
Reporting Tools Crystal Reports, Business Objects 6.0
ETL Tools Informatica PowerCenter/ PowerMart, Ascential DataStage 7.x, 6.x, 5.x
Programming Languages Visual Basic, C, C#, .NET 1.x/2.0/3.0 Frameworks, ASP.NET,
ADO.NET, PL/SQL, SQL/T-SQL HTML, SOAP/XML, JavaScript/AJAX, Java, JBuilder
Operating Systems Windows NT 4.0/95, Windows Server 200/2003, Red Hat Linux 4,
Solaris 10,
IBM AIX
Web Server IIS, HTTP, Oracle Application Server.
Others Moda, Trackwise, Power designer, CVS etc.
PROFESSIONAL EXPERIENCE:
Auxilium, Malvern, PA JUL 2007 – March 2009
Programmer Analyst
• Actively involve in the design, coding, testing, support and debugging of any
new software or enhancements to existing software
• Web Form design and coding using Master Pages, Server controls, Cascading
Style sheet, JavaScript html.
• Writing business logic code in C# code behind files to read data from database
stored procedures.
• Writing business logic code using Java1.4 and JDBC to interact with the Oracle
database.
• Writing T-SQL and PL/SQL queries in creating views and stored procedures in
SQL Server2005 and Oracle 10g.
• Regular OS, Database and Application log monitoring and analyze them for
reporting
• Managed database using OEM
• Data Migration using BCP, Bulk Insert, SSIS etc.
• Creating Reports using SSRS.
• Database and Server Monitoring and Tuning SQL Server and Oracle Databases.
Environment: Dell 1955 Blade, Dell Power edge 2900, Microsoft Server 2000,
Redhat Linux 4, Oracle 9i/10g database, Oracle Enterprise Manager, Microsoft SQL
server 2005 Database, Visual Studio 2005, .Net 2.0/3.0, C# ,ASP.Net, ADO.Net,
Java1.4, JDBC , Jbuilder 2005, Microsoft IIS, Toad, Erwin, Oracle Grid Control.
Strand Communication, Toronto, CA April 2006-June 2007
Programmer Analyst
• Identify performance bottleneck issues and suggest logical as well as physical
database layout changes for performance enhancement
• Logical and Physical data modeling using ERWIN.
• Used SHOWPLAN utility to analyze query plan and carry out performance tuning.
• Writing DDL with Declarative Integrity for generating tables.
• Migrating data from SQL Server 2000 to SQL Server 2005
• Creation of Triggers for enforcing business rules.
• Creation of Views for users to query a selected set of data.
• Writing Stored Procedures, Functions and Packages.
• Managed Database using Oracle Enterprise Manager and also assisted development
teams by writing complex SQL queries.
• Developed user interface (Web Forms) for the modules used ASP.NET server
controls, Validation controls, XML, HTML.
• Implemented business logic using C#.Net and backend connectivity using
ADO.Net
Environment: RedHat 3, Solaris 8, Oracle 10g Database, Oracle Grid Control,
Oracle Enterprise Manager, Microsoft server 2003, Microsoft SQL Server 2005,
Toad, BMC Patrol, Erwin, Database Export-Import, Oracle Standby Database, Moda,
Trackwise.
Microhard Technologies Inc., Toronto, CA Oct 2004- Mar 2006
Programmer Analyst
• Review Logical Design to ensure a match between Functional Requirement Vs
Logical Database Design. This required a good understanding of Functional
Requirement and Logical Design represented by ER diagram.
• Performance tuning T-SQL queries.
• Writing database triggers to enforce business rules.
• Writing Stored Procedures.
• Implemented business logic using C#.Net, ASP.Net and backend connectivity
using ADO.Net
• Responsible for daily backup
• Participated in code reviews, created test cases and performed unit testing.
Environment: Windows NT /Windows2000, Microsoft Sql Server 2000, Toad, BMC
Patrol, Erwin, Database Export-Import, Visual Studio 2003, Net 1.1/2.X, C#,
ASP.Net, SOAP, XML, ADO.Net, SQL Server 2000, HTML, Classic ASP, Javascript ,
Crystal Reports, Moda, Trackwise.
Isopia Interactive Network Inc. (Sun Microsystems) Toronto, (Canada) Mar 2002-
Sept2004
Java Developer
Project Name: ISIS,
Client: ElementK, USA (http://www.elementk.com)
• Implement software modules or subsystems using Java and related technologies
• Write code based on software designs or product specifications, using standard
coding practices and guidelines provided by the company
• Developed stateless session beans EJB for checking the Authentication of the
user logged into the system.
• Used JDBC API for integrating application with Oracle database RDMS and
developed functions, stored procedures, triggers and SQL Queries using PL/SQL.
• Maintained Programs using CVS in MyEclipse.
• Involved in Design, coding, testing and debugging the application.
• Create and update required documentation for all work products
• Adhere to source code control and management policies
• Assist in testing or development of test plans
Environment: Java 2, Enterprise Java Beans 1.0 and 1.1, BEA’s Weblogic 4.5.1 and
5.1.0, IBM Rational Rose Software Development Platform powered by Eclipse, Visual
café 4.0, CVS (Concurrent Version System), Oracle 8i, JNDI, JMS, UML, J2EE,
Servlets, JSP, JBuilder, JSTL, Struts Frame Work, Tiles, MVC Architecture,
Hibernate, Oracle, RDBMS, MVC2, ANT, JUnit, JDBC, CSS, Javascript, CVS,Log4J,
Linux Server, XML, XSL, XSD, OOP Methodology.
EDUCATION:
BS in Computer Science
|
