Senior ETL Developer Ersumme Profile, NJ

PROFESSIONAL SUMMARY

14 years of IT experience in applications on Microsoft Technologies like VB, .Net, SQL Server 2000/2005/2008/2008R2, SSIS, SSRS, C and Teradata.
Highly skilled in design and development of application software and ETL using SSIS, SQL Server, particularly in the use of Microsoft technologies and also using TERADATA and DMExpress.
Strong background in HealthCare Insurance Domain. Experience working with healthcare data.
Primary responsibilities have included Application development, ETL, Database modeling, system testing, analysis and design, implementation and project documentation.
Solid experience working with SSIS development. Excellent understanding of relational and dimensional data models. Ability to work independently and as part of a team.
Experience in Version Control System SVN, VSS.
Ability to quickly adapt to new environments and learn new technologies.
Excellent analytical capabilities and good communication skills.

TECHNICAL PROFICIENCIES

ETL Tools : DTS, SSIS, DTS Xchange,DMExpress
Reporting Tools : SAP Crystal Reports 2008, SSRS
Relational Databases : TERADATA, SQLServer 7.0/2000/2005/2008/2008R2, Oracle 8i/9i, MS Access
Languages : C , VB 6.0, SQL, PL/SQL , Java, C, COBOL,
Framework : COM, DCOM, .Net
Development Environment : MS Visual Studio.Net, Visual Studio 5.0/6.0
Operating Systems : Windows 95/NT/2000/XP, Red Hat Linux, Unix and DOS 6.2.
Scripting Languages : JavaScript, VBScript, HTML, DHTML and XML.
Web Technologies : Ajax, Web Services
Internet Tools : ASP.NET, Visual Interdev
Web Server : IIS 5.0/4.0
Data Modeling Tools : MS Visio
Others : Agile, MS VSS, Tortoise SVN, MS Project 2007, Zeke.

PROFESSIONAL EXPERIENCE

Confidential

Role Played : Senior ETL Developer

Responsibilities:

Develop and Review Extract, Transform and Load ETL processes programs and scripts, using Teradata , DMExpress, SSIS, SQL Server, Unix.
Perform the role of Database Developer/ETL Architect using TERADATA and DM Express.
Provide guidance on strategies that minimize implementation risk and time and/or improve system reliability and performance.
Performance tuning.
Configuration and Release management using ZEKE.

Confidential

Role Played : Project Lead/ Reporting Manager

Responsibilities:

Develop and Review Extract, Transform and Load ETL processes programs and scripts, using DTS/SSIS SQLServer 2005 /2008/2008R2 Integration Services
Creating Reports in SSRS.
Perform the role of Database Developer/Architect using SQL Server 2000/2005/2008/2008R2
Creating web applications using Technologies like ASP.Net, ADO.Net, WebServices, Ajax, C , ASP, ADO, COM, IIS, VB6.0, JavaScript, VBScript.
Monitored Unit testing ,system testing and creating test cases using SQUIDS
Onsite/Offshore Collaboration
Provide guidance on strategies that minimize implementation risk and time and/or improve system reliability and performance.
Performance tuning using SQL Query Analyser/Management Studio.
Configuration and Release management.
LOB Staffing Management.

Environment : SSIS, SSRS, SQL Server 2008 R2, Pega BPM, Web Services,WCF,.Net Framework 3.5,ADO.net.

Confidential

Designation: Senior Programmer

Responsibilities:

Creating windows applications using Technologies like VB, COM, SQL Server 7, MTS
Architect applications using SQL Server and VB, MTS
Creating Database Design specification
Performance Tuning

Confidential

Designation: Senior Programmer

Responsibilities:

Creating web applications using Technologies such as VBScript, JavaScript, HTML, ASP,IIS, Access 97.
Documentation.SOFSCRIPT is into Healthcare Info solutions .Their other expertise includes Engineering Applications, Commercial

Confidential

Designation: Senior Programmer

Responsibilities:

Creating windows applications using Technologies like VB, COM, SQL Server 7, MTS
Architect applications using SQL Server and VB, MTS
Creating Database Design specification
Performance Tuning