Development Analyst

Posted on: 2006-07-13

Pronati Debnath 3694 Corners Way Norcross, GA 30092 Voice: (770) 448-3135 Email: [email protected] SUMMARY:  Degreed IT Professional with 8 years of experience in analysis, design, testing, development, documentation and implementation of applications.  Over 5 years of database-driven applications experience utilizing C#, VB.NET, Active Server Pages 3.0, MS SQL Server 6.5/7.0/2000, Visual Basic 6.0, Microsoft FrontPage 98/2000/XP, Hyper-text Markup Language (HTML), Dynamic HTML, Java Script, VB Script  Experience in coding using SQL, PL/SQL, Stored Procedures/Functions and Triggers, SQL 2000 Enterprise manager and SQL Query Analyzer  Good Knowledge in DTS, backend database programming with Stored Procedures using SQL 2000  Good Knowledge in ASP.NET, C#, VB.NET, ASP, Java Scripting and HTML.  Interacted extensively with clients to gather requirements and perform analysis and design to meet end user requirements.  Excellent communication and interpersonal skills. TECHNICAL SKILLS: Programming C#, ASP.NET, VB.NET, Visual Basic 6.0, Active Server Pages 3.0, Microsoft FrontPage 98/2000/XP, HTML, Dynamic HTML, Java Script, VB Script, C++, Oracle 8, T-SQL/PL/SQL Web Technologies C#, VB.NET, ASP 3.0, JavaScript, HTML 4.0 Tools TOAD, MS Access Reports, ETL, Informatica Power Center, Visual SourceSafe Databases DB2, MS SQL Server 6.5/7.0/2000, Oracle 8, MS Access 2000/2002 Web Servers PWS, IIS 4.0/5.0/5.1 Operating Systems Windows NT, 98, 2000, XP, 2003, DOS, MVS /JCL, UNIX PROFESSIONAL EXPERIENCE: Title: Development Analyst 6/2005 – May 2006 Client: Radiotherapy Clinics of Georgia, Atlanta, GA Radiotherapy Clinics of Georgia is among the largest and most successful programs in the world for the treatment of men with prostate cancer. Using RCOG Web site, you can get detailed information from Dr. Frank Critz, founder of Radiotherapy Clinics of Georgia. Responsibilities:  Developed, tested and executed database-driven Corporate Directory.  Developed, tested and executed database-driven Intranet for RCOG.  Created database-driven Patient reports using Crystal Reports 11 report writer. Environment: SQL server 2000, C#, Crystal Report 11, HTML and JavaScript Title: Database Coordinator 8/2004 – 8/2005 Client: Secretary Of State, Georgia Archives, Atlanta, GA Georgia Archives works to make a difference on behalf of all Georgia citizens. They save taxpayer money by helping state and local governments operate more efficiently. Because they document state government decisions and help state and local governments meet open records requirements, they make government more accountable. By preserving property records and other legal documents they safeguard the rights of Georgia’s citizens. Responsibilities:  Developed, Tested and executed database-driven website for Georgia Archives Virtual Vault. Worked with SQL 2000 and its suite of products  Developed, Tested and executed database-driven website for Georgia Archives Postcard Collections. Worked with SQL 2000 and its suite of products  Developed, Tested and executed database-driven website for Georgia Archives Confederate Enlistment Oaths and Documents. Worked with SQL 2000 and its suite of products  Developed, Tested and executed database-driven website for Georgia Archives Confederate pension application. Worked with SQL 2000 and its suite of products  Created database, ETL and stored procedure using in SQL Database Environment: SQL server 2000, ASP.NET, HTML, JavaScript Title: Programmer/Analyst 8/2003 – 7/2004 Client: eConsultants, Inc, Atlanta, GA eConsultants, Inc. is a software, services and a product company, dedicated to providing our customers with software solutions across the enterprise, for a competitive advantage. Responsibilities:  Developed, Tested and Executed PL/SQL Packages and Procedures. Worked with Oracle RDBMS and its suite of products  Installation of Oracle Database for testing it with LearnIty  Creation of Procedures using PL/SQL in oracle Database  Integration and Testing of LearnIty with Oracle Database Environment: Oracle, Application Development, SQL Plus Title: Application Developer 7/2003 – 7/2003 Client: TechDiscovery, Atlanta, GA TechDiscovery is the trusted technology partner for Atlanta-based companies. Responsibilities:  Redesigned and developed database-driven website for a school using standard Microsoft Internet Technologies including: ASP, HTML, VB Script, JavaScript, and SQL to run on Microsoft IIS Web Server and used Microsoft SQL Server 2000 for the database Environment: ASP, HTML, JavaScript, Microsoft IIS Web Server, Microsoft SQL Server 2000. Title: Application Developer 12/2002 – 4/2003 Client: AGCO Corporation, Atlanta, GA AGCO Corporation is one of the world\'s largest manufacturers, designers and distributors of agricultural equipment. AGCO\'s products are sold in more than 140 countries. Responsibilities:  Designed and developed various SQR reports using SQR, SQL, SQRW and TOAD with CodeWright being the editor.  Created, Maintain, Analyze and Optimize ORACLE SQL Scripts using SQL Navigator and Toad Software.  Developed, Tested, Maintained, Executed PL/SQL Packages and Procedures for the day to day and monthly needs.  Analyzed and Solve issues in DCARS, a SQL Windows based homegrown System, and perform customer follow-up to ensure problem resolution.  Performed AR-Balancing for the AGCO Dealer Network to corrected error using Oracle SQL.  Supported different Systems that are being used by 450 users across North America using VANTIVE, a PeopleSoft CRM helpdesk solution.  Created, Maintained and Executed Unix kron Shell scripts in on Sequent Unix platform.  Responsible for designing, developing and testing all modules involved in the data process to run report from various databases.  Developed PL/SQL procedures and UNIX Shell Scripts. Environment: Oracle 8i/8.0, Microsoft Excel, TOAD, SQR, SQL Navigator, PL/SQL, PeopleSoft CRM, SQL Windows, UNIX and Windows NT 4.0. Title: Programmer / Analyst 09/ 2000 - 08/2002 Client: PROMINA Health Systems, Atlanta, GA PROMINA is Georgia\'s largest not-for-profit healthcare system comprised of metro Atlanta\'s preferred doctors and hospitals. Responsibilities:  Designed and developed database-driven Pre-admission forms for all LIDS using ASP 3.0 and SQL server 2000. Maternity patients now can fill out their form online so they do not need to make the extra trip to the hospital.  Designed and developed database-driven applications for Gwinnett Managed Care Organization. People can view meeting schedule and register for an upcoming meeting  Developed database-driven applications using for Institutional Claims, Pre-certification and Health Plan Summaries  Developed Cloverleaf project to connect through an HL7 interface and web-based application to view the data  Maintained DTS for weekly job posting for all LIDS using SQL server 2000  Migration from Access database to SQL database  Verified program logic by preparing test data and conducting unit tests.  Participated in the systems testing and user acceptance testing.  Supported the implementation of applications into production. Environment: ASP 3.0, VB Script, HTML, JavaScript, MS SQL Server 2000, Microsoft FrontPage 2000, Enterprise Manager, Windows 98/2000,and Windows NT. Title: Web Developer 03/2000– 09/2000 Client: Sys.com International, Inc. Atlanta, GA SYS.COM International, Inc. is a fast growing global Information Technology, Consulting and Solutions Company, specializing in providing Enterprise Solutions using Emerging Technologies. Responsibilities:  Designed and developed website for Sys.com International, Inc.  Extensively used HTML and Java Script, DHTML, Java Applet  Database Maintained on Oracle 8  Interacted with various users to collect the specifications. Environment: HTML, Microsoft FrontPage 98, MS Access 97, Windows 98 and Windows NT. Title: Faculty Assistant/Programmer 10/1998 - 02/2000 Client: DeVry Institution of Technology, Atlanta, GA DeVry University is one of the largest degree-granting higher education systems in North America. Responsibilities:  Supported and maintained web pages and application for faculties  Supervised and assisted student in the CIS Lab Maintained dot matrix and Laser printers  Designed and developed database using Oracle 8, MS Access  Created program for Banking Services using C++  Created a script in vi to echo the text, and a menu with commands/choices to exit the script, and created a phone list with vi filename using Unix  Involved in the development of a database for a Lawn Mower Company using Oracle 8, PL /SQL  Created database triggers and procedures.  Designed and created an Oracle database for the department.  Created a front-end using Visual Basic. Environment: Microsoft Office 98, Microsoft Excel, Microsoft Access, Oracle 8, UNIX, IIS 4.0/5.0 and Windows NT. EDUCATION:  Bachelor of Science, Computer Information Systems DeVry University, Atlanta, GA. Dean’s List 7 trimesters GPA: 3.76/4.00 Feb, 2000  Bachelor of Education, University of Burdwan, Calcutta, India  Bachelor of Science (Biology), University of Calcutta, Calcutta, India  Trilingual TRAINING / CERTIFICATION:  Active Server Pages Oglethorpe University, 2001 STATUS:  US citizen PERSONAL:  Effective public speaking and communication skills and well developed organizational and technical writing skills.  I am a team player who takes and gives direction in the true spirit of the term “teamwork”.