Sr Developer & Analyst

Soumya Ghosh

**** ********* **, *** ***, Houston, Texas 77077

Desk Phone: 281-***-****, Cell Phone: 337-***-**** Email: *******@*****.***

Summary

Over 3+years of extensive experience in Database Administration, Database Development, Maintenance & Support of MS SQL Server 2008/2005/2000 in production and development environments

• Has 3+ years of experience in SQL Server DBA/ETL developer with 5+ years of experience in the design, development, implementation, testing and maintenance of application systems in the internet/intranet, client-server environments

• Expertise in installation, configuration and maintenance of SQL Server.

• Experience in Data Modeling (Logical and Physical design of databases), Normalization and building Referential Integrity Constraints.

• Excellent backend skills of creating SQL Server objects including Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, User defined Data Types, File Groups and Functions.

• Excellent T-SQL Programming skills. Experience in Query optimization and performance tuning using tools, e.g. SQL Profiler, Database Tuning Advisor, Windows Performance Monitor and DBCC commands

• Experience in Database High Availability including routine backup, disaster recovery, database mirroring and log shipping.

• Experience in database replication: transactional, snapshot, merge

• Expertise in building SQL Server Cluster environment for failover to maintain high availability.

• Has extensive knowledge in complete ETL cycle including data analysis, data design, data mapping, conversion and data load.

• Built complex DTS packages for data migration and transformation from Oracle/Access/Excel sheets to SQL Server

• Worked in OLTP & OLAP environment that includes production (24x7) and development databases in SQL Server

• Experience in Dimensional Modeling, ER Modeling, Star Schema, Snowflake Schema, Fact and Dimension tables and Operational data store

• Has a very good professional experience in SSIS, SSRS, SSAS in SQL Server 2008/2005

• Experience in Database migration from SQL Server 2000 to SQL Server 2005/2008

• Extensive Knowledge in design and development of User Interfaces using ASP.NET, Visual Basic, C# and Visual Studio.

• Expertise in Web Development - HTML, DHTML, XML, XSL, VBScript, JavaScript, ASP, ASP.Net, IIS, Visual Interdev, VSS

• Strong in Object oriented Programming, Problem Solving skills and SDLC

• Possess excellent management and communication skills.

• A good team player with strong abilities to adapt quickly to new environments and technologies.

Technical Skills

Databases : SQL Server 7.0/2000, 2005, 2008, Microsoft Access, Oracle SQL

SQL Server Tools : SSIS, SSMS, SSRS, SSAS, Database Tuning Advisor, SQL Profiler

SQL Server Business Intelligence Development Studio,

Query Analyzer, Data Transformation Service, DTS xChange,

Replication & Upgrade wizards, MS Visio

.NET Technology : VB.NET 2005/08, C#, ASP.NET, ADO.NET, Visual Studio.NET

Languages : Visual Basic (VB 6.0), C#, XML

IDE : Visual Studio.NET 2005, Visual Studio.NET 2008, Dreamweaver

Operating Systems : Windows XP/2000/2003/NT/98/95/Vista

Reporting : Microsoft Reporting Services, Crystal Reports

Utility Tools : MS Office, MS Project, MOM 2005

Education

• Masters in Computer Science

• Bachelors in Electrical Engineering

Additional Training

• Official Microsoft Training : MS 2778A (Writing Queries Using Microsoft SQL Server 2008 Transact-SQL)

• Official Microsoft Training : MS 6231A (Maintaining a Microsoft SQL Server 2008 Database)

• Official Microsoft Training : MS 6232A (Implementing a Microsoft SQL Server 2008 Database)

FORUM ENERGY TECHNOLOGIES, Houston, TX Feb’ 09 – Current

http://www.f-e-t.com

Database Administrator

Forum Energy Technologies is one of the companies who work as major onshore & offshore drilling contractors, support drilling equipment rental companies, Oilfield Service companies and assemblers of drilling and well servicing equipment.

Responsibilities

• Involved in installation and configuration of SQL Server 2000/2005/2008 on DELL Servers. Applying patches and latest service packs to keep the databases updated with latest patch level.

• Developing Business Systems & Administrating Corporate wide Database.

• Migration of Databases from SQL Server 2000 to SQL Server 2005/2008

• Conversion of Legacy systems data into SQL Server 2005 using DTS packages

• Copying and restoring Production Databases to Test Server

• Building maintenance plans to backup, shrink, check integrity, rebuild indexes, update statistics & clean up history and maintenance task periodically (nightly & weekly).

• Building maintenance plans to backup and shrink transaction logs periodically to prevent them from growing large in size.

• Monitoring Database Server performance using Windows Perfmon, SQL profiler to monitor different performance counters to determine the health of the server.

• Monitor & troubleshoot performance bottlenecks related to CPU, Memory, Operating System, Disk and network.

• Tune SQL Queries using SQL Profiler. Included in tuning the database

• Using SQL Profiler to identify locks, deadlocks on database servers and finding resolution.

• Implemented Database standards and naming conventions for the database objects.

• Building SQL Server Cluster environment for possible failovers

• Based on Business needs, set up replication and log shipping to maintain high availability.

• Suggested Disk capacity, CPU and Memory required based on capacity planning.

• Written Stored Procedures, Triggers & Functions required for Intranet Applications.

• Building Dimension, Fact tables & data cubes on a server dedicated to Data Warehouse needs, using SQL Server 2008 Analysis Services & BIDS

• Using SSIS to automate data import, table update/delete, refresh data cubes & other user operations.

• Implementing security policy on the database servers.

• Using IIS to implement SSRS 2005/2008, MOM 2005.

• Building Organization Intranet and Extranet web applications using VB.NET, IIS as webserver.

• Deploying company and its associate companies’ external websites on IIS on our dedicated Web Server.

• Use of tools e.g. Activity monitor, Resource Governor, Event notifications to ensure optimal performance.

• Set up alerts on SSIS packages in SQL Server to send email notifications on an event of failure.

• Design and developing the reports using SQLSERVER Reporting Service

• Building Intranet & Extranet applications using VB.NET & Visual Studio

• Worked in Spiceworks & Kaseya ticketing system to resolve tickets.

• Monitor web applications & external websites using tools e.g. Archin, Google analytics, AWSTATS.

ENVIRONMENT: SQL Server 2000/2005/2008, XML, SSIS, SSAS, SSRS, VB.NET 2008, .NET 3.5, C#, Java Script, VisualStudio2005, VisualStudio2008, IIS 6.0, Windows Server 2003 (x64), Windows Server 2008, Windows performance monitor, SAN Arrays

FORUM ENERGY TECHNOLOGIES, Lafayette, LA June 08 – February 09

IT Analyst

www.f-e-t.com

Forum Energy Technologies is one of the companies who work as major onshore & offshore drilling contractors, support drilling equipment rental companies, Oilfield Service companies and assemblers of drilling and well servicing equipment.

Responsibilities

• Developing & Maintaining Database driven web applications for companywide intranet and extranet system needs.

• Administering SQL Server 2000 Databases & Pervasive SQL Databases for web applications and Legacy ERP tools.

• Working with SQL Server services and SQL Agent to build and implement ETL processes for business intelligence needs.

• Backup SQL Server Databases. Implement maintenance plans for databases. Work on database high availability.

• Tune SQL Queries. Write stored procedures. Create views.

• Performance monitoring of SQL Servers and other file and data servers.

• Administrate & Support Legacy ERP Systems and its users.

• Build & manage network connectivity. Work on LAN, WAN.

• Support about 100 Desktop & Laptop users.

• Administrate Windows Servers.

Environment: Windows Server 2003, SQL Server 2000, Windows XP

WEBSCALERS L.L.C, Lafayette, LA May 07 - September 07

Database Developer

Title: Database Development of Web Search Engine ‘MySearchView’

Webscalers provides solutions to various business problems associated with online search coverage, quality, and effectiveness. Created customizable & extensible search technologies designed to address your specific business requirements. The search engines can be specially adapted for marketing, manufacturing, accounting, legal & other services.

Responsibilities:

• Built the ER Diagram and developed the database schema at the start of the Search Engine development.

• Developed complex user and multi-dimensional application databases using SQL Server 2000

• Built stored procedures, views, triggers and cursors

• Built DTS packages to insert/delete/update database tables and objects.

• Responsible for database creation, tuning, performance planning and database administration

• Designed and implemented comprehensive backup plans and disaster recovery strategies.

• Extensively working on update statistics, rebuilding indexes at regular interval for better performance.

• Create and manage user accounts and audit user activities as and when required.

• Managed disk space, memory and user connections.

• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support

Environment: Stored Procedures, SQL Server 2000, Crystal Reports, Windows XP, IIS

Center for Business & Information Technology, LA Dec’ 05 – April’ 07

Database & Application Developer

Visionary OFFICE™ PM offers an easy to use Windows interface featuring a seamless integration of Medical Billing, Appointment Scheduling and Patient Information, providing the physician a tool that contains all the financial, clinical, and operational elements of a successful running practice. This Application is developed for Doctor’s Practice management.

Responsibilities:

• Created numerous simple to complex queries involving self joins, correlated sub queries and XML techniques for diverse business requirements.

• Tuning queries, altering database design, analyzing different query options, and indexing strategies.

• As part of a team, analyzed the business requirements and systematically designed a database.

• Created various reports according to business requirements.

• Implemented numerous backup and recovery plans based on data availability requirements and the potential impact of data loss.

• Implemented SQL Logins, Roles and Authentication Modes according to the business requirements.

• ATR: (http://www.access2recovery.info:8080) ATR provides information and resources on how to address post-disaster needs for States and Policymaker Service Providers, Consumers, Families, and Individuals, Children and Teens, School Administrators and Teachers, Parents and Caregivers of the state of Louisiana.

• Access Sites: (www.access.louisiana.gov) Access Sites provides the site selector information on not only what sites and buildings are available within the state of Louisiana, but also with tools for analysis on selecting the best location based on the needs of a specific business or industry.

• Developing the website and maintaining various applications that can be viewed in the website using .NET Technologies.

Environment: SQL Server 2000, VB.NET, Visual Basic 6.0, ADO.NET XML, XSLT, Visual Studio, IIS, Win Forms, Windows XP

Contact this candidate