Prasenjit Nath

Seattle, Wa

Email: acux5y@r.postjobfree.com

Objective: Seeking a database development oriented IT position.

Education: M.S. in Computer Science, Southern Methodist Univ., Dallas, Texas

B.S. in Computer Science, Jadavpur University, Calcutta, India

MBA in Finance, Seattle University, Seattle, Washington

Experience: 10+ years experience in software development on different platforms.

SQL Server/Oracle/Ms Access under Windows and Unix for 10+ yrs

C under Windows / Unix for 5 yrs

VB under Windows for 5 yrs

C++ / MFC under Windows for 2 yrs

Experienced with complete software development life cycle (SDLC) from user requirement, analysis, proof of concept, design, development, data gathering, Business Intelligence (BI), Testing and Implementation.

Expert in bringing “Customer Point of View” to the Project via direct and indirect user interaction and thorough analysis and understanding of the customer requirements.

Experience with Client/Server Multitier application development, with a strong focus on back-end database development using ORACLE, SQL Server, MS Access, SSIS. Proficient in database schema design and implementation, use of triggers and constraints, writing complicated stored procedures, developing cubes, performance tuning, data migration, maintenance and support.

Thorough understanding and experience in performing Functional and Performance testing. Extensive experience in creating and maintaining Manual/Automated scripts for periodic maintenance work.

Good working knowledge of, PERL, Access, ASP, VB Script, Java Script, Tableau

Excellent analytical, problem solving, written and interpersonal communication skills. Ability to work independently as well as a lead developer or team player.

Experience with working under strict deadlines and crunch mode.

Strong academic background in technical field (BS and MS in Computer Science), appropriately complemented with the knowledge of business environment (MBA in Finance)

Employment History:

08/08-03/16: Software Consultant for Boeing, Washington

Worked on various projects, involving SQL Server Backend and MS Access frontend

Developed Mission critical reports, and their daily production by bringing in data

from various sources ( databases/flatfiles/xls ).Good exposure in creating and modifying SSIS Packages to replace VBA applications for better maintenance and efficiency as well as reliable production support.

04/07–07/08 Software Consultant for AT&T, Washington

Building a small Oracle DataWarehouse to support ongoing reporting processes

with Access as front-end and/or staging platform.

Developed new features and maintained a billing application. The Application has Access back-end and C/C++ front end with feeds from SQL Server.

02/07–03/07 Software Consultant for Microsoft Corp, Washington

Developing ETL and testing tools for internal reporting application based on in- house DataMart. The Application has SQL Server and Analytic Server with cubes for backend along with Excel and ASP front end.

11/04 - 03/05 Software Consultant for Washington Mutual Bank, Washington

Built reporting tools with Access front-end and SQL Srvr back-end to store and easy retrieval of security sensitive data, involving extensive schema design, development of stored procedures, data cleansing, uploading and transfer.

05/04 - 11/04 Software Consultant for ATT Wireless, Redmond, Washington

Built reporting tools with Access front-end and Oracle back-end.

The oracle database contained humongous amount of cell phone data. Design, development and performance tuning of stored procedures to retrieve data in a reasonable time-frame was the main challenge.

01/01 - 01/04 Software Consultant for Washing Mutual Bank, Seattle Washington.

Built a small financial application with Oracle back-end and Access front-end, for approximately 500 users, with different level of access privileges and usage requirement, from different parts of the country. Worked in the capacity of a team-leader in a small group of 5 people.

Development of a small Oracle Data-Warehouse to store monthly data from different systems having diverse formats. Worked mostly independently for the whole project with some help for documentation.

The project involved complete database schema design and implementation along with stored procedures and triggers. In the absence of a costly ETL tool, built an access pre-processing platform to massage and homogenize the incoming data and to change them to the required final format.

Built an Access Front end application to generate consistent monthly reports from the data stored in the Data-Warehouse.

09/00 – 12/00 Software Consultant for Tegris, Bellevue, Washington

Web Development using VB/Java script, ASP along with CDO and ADSI. Debugging and modifying existing stored procedures for the back-end SQL Server, to accommodate new user requirement was one of the most important tasks.

05/00 – 08/00 Software Consultant for Casey Family Program, Seattle Washingtion

Database Development ( Data Migration from SQL Server 6 to SQL Server 7 )

Wrote stored procedures and scripts to automate seemless data conversion to the newer upgraded version of the application via an intermediate platform, along with error handling, error correction and error reporting.

11/99 – 05/00 Software Consultant for Ajillus

Software Development utilizing VB 6.0, Sql Server 7.0 and ASP technology.

Developed a VB application to interface with Oracle ERP system and a shipping label generator in automating shipping label generations for an assembly line.

9/98 - 10/99 Software Consultant for Connectware

Development of Software tools using PERL, PL/SQL to interface Oracle ERP applications.

10/97 - 7/98 Software Consultant for Western Wireless

Developed reporting tools, using PERL, SQL ( Ingres/ Unix ) and VB, Access.

SQL stored procedures and scripts were developed for processing data as well as to generate reports.

PERL scripts were used to automate the processes those needed to run periodically depending on specific criteria.

01/95 - 10/97 Software Engineer at SPRY Inc./ CompuServe, Bellevue, WA.

Developed and maintained SPRY dialer that provided Winsock connections over Internet. It was developed using C and C++ languages, under Windows

Developed a TCP/IP application software, using C and C++ languages, to make

PC Winsock applications SOCKS protocol compliant and to provide connections through Firewalls. Involved trapping undocumented WINAPI calls and invoking specific customized functions, instead.

04/94 - 11/94 Software Engineer at Wall Data Inc., Kirkland, Washington

Development/Implementation of Rumba (Unix-Connectivity) product in C/windows

09/91 - 2/94 Software Engineer at Microsoft Corporation, Redmond, Washington

SQL development for library information system with SQL server

back-end and C-DLL interface to a VB front-end.

Developed tools in C under Windows for software localization.

05/89 - 9/91 Programmer at National Data Center, Dallas, Texas

Developed Data acquisition software to fetch time-stamped data, concurrently from multiple databases, synchronize and feed them to display module. Developed software tools for file conversion / file transfer utilities using C / shell programming under Unix.

Contact this candidate