We provide IT Staff Augmentation Services!

.net Etl Developer Resume

SUMMARY

  • Microsoft Certified Application Developer (MCAD) with 6 years of .NET experience in Web and Windows Applications.
  • Experienced in .NET 4.0,3.5,2.0 & 1.1, C#.NET, VB.NET, ASP.NET,ASP,Silver Light,XAML,WCF,LINQ,XML,XSLT, XML Web Services, Win Forms, Windows Service Components, Ajax, HTTP, C, Visual Basic 6.0,COM, Java Script, Vbscript, VBA for MSOffice, VBA Macros, HTML, CSS, Microsoft Application Blocks, IIS, MTS, COBOL.
  • In - depth understanding & extensive experience in MS SQL SEVER 2008, 2005, as 2000, SQL SERVER Integration Services, DTS, ORACLE 10g, Sybase and MS Access 2003.
  • Extensive working experience in SharePoint server 2007, Commerce Server 2002, Content Management Server 2002 .
  • Good working knowledge on report generation tools like CRYSTAL REPORTS 10 & 11 business objects, SQL Server Reporting Services.
  • Working experience with versioning & Integration tools like Visual source safe and Team Foundation Server.
  • Extensive working experience in NUnit Test Tool, FxCop, Rational Rose, MS Visio 2005, UML and OOAD concepts.
  • Good understanding of EDI ASC X12N 837 (004010X096 & ASC X12N 837 (004010X098)) transactions and HIPPA standards.
  • Good domain knowledge in Insurance & Brokerage, Healthcare and Financial sectors.
  • Proficiency at various levels of application development i.e. on requirement analysis, analysis and design, system and integration testing, implementation and documentation.
  • Experienced in using various methodologies in Software Development Life Cycle (SDLC), Six Sigma standards, SCRUM and AGILE.
  • Excellent customer service orientation and outstanding verbal and written communications skills.

PROFESSIONAL EXPERIENCE

Confidential

.NET ETL Developer

Responsibilities:

  • Involved in analyzing the business rules and come out mapping documents with the rules to be implemented for data migration.
  • Involved in Data Transformation and mapping from the Source Client systems to the Pre staging database. Involved activities as data clean up, data de-duping and data transformation.
  • Performed ETL process using SSIS packages with C#.NET 3.5, visual studio 2010 to process input native Universe DB2 and SQL server to implement the mapping rules to the output SQL server tables.
  • Involved in creating stored procedures, triggers, cursors using T-SQL. Involved in Query tuning and database cleanup before migrations.
  • Integrated SQL server Reporting services to host reports for the business to access it on timely fashion.
  • Used Microsoft Enterprise Library 4.1 Application blocks.
  • Involved in designing the Unit testing for the data migration done in a highly efficient manner capturing and creating reports based on the testing.

Environment: C#.NET 4.0, SQL Server 2008, Visual Studio 2010, Team Foundation server, SSRS,SSIS,ETL, MS Enterprise Library 4.1, Windows application, NUnit.

Confidential, Chicago IL

SharePoint Developer

Responsibilities:

  • Designed the technical design documentation from the requirement specification using MS Visio diagrams. Involved in business meetings for requirement gathering.
  • Implemented a .Net Windows service to talk to MOSS 2007 server for querying and syncing the documents to the SAVO Website. Implemented XML REST over Http to communicate to the API. Involved in creating Dashboards in MOSS 2007.
  • Code was implemented in MOSS 2007, C#.NET 3.5, SQL server 2008, SSIS JavaScript, Windows Service, NUnit, CSS, REST over HTTP, Linq to XML.
  • Developed Site collections and web applications for intranet in SharePoint 2007.
  • Involved in profile maintenance delegation, multiple search options, admin alerts and create site templates.
  • Integrated SQL server Reporting services into MOSS 2007 for report creation.
  • Performed data transformation process (ETL) using SSIS to input data from flat files and Access databases. Data Transformation and mapping to implement complex business logic.
  • Created stored procedures, triggers, cursors using T-SQL. Involved in Query tuning and database cleanup before migrations.
  • Involved in documentation of User manual and all phases of project from requirement gathering to UAT.

Environment: C#.NET 3.5, SQL Server 2008, MOSS 2007, CSS, JScript, JQueryIIS,REST,XML, Team Foundation server, SSRS,SSIS,ETL, Windows Service, NUnit, Virtual Server 2005 R2, Windows server 2003.

Confidential, Bloomington IL

.NET & ETL Developer

Responsibilities:

  • Involved in developing the internal SharePoint Portal website with MOSS 2007.
  • Implemented functionalities for Dashboard for quarterly sales, create and maintain user profiles, In corporate search functionalities, profile maintanence and delegations. developed site templates for web sites for different groups as departments of the company with different conent. Created reports using SQL Server reporting services 2005.
  • Wrote a number of stored procedures to validate the complex mappings using T-SQL. Created and Configured SSIS tasks to load data in to target tables.
  • Test plans for auditing the migration process by creating an Audit Table to log each migration task.

Environment: VB.NET, ASP.NET 3.5, ADO.NET, JQuery, CSS, Visual Studio.NET 2008SQL 2005, SSIS, SSRS, ETL, Visual Source Safe, IIS.

Confidential, Louisville KY

.NET Developer

Responsibilities:

  • Actively involved in developing the Workflows, site templates and mysite collections in MOSS 2007,C#.NET, SQL server 2008.
  • Involved in developing multiple search methodologies, admin alerts, new user profile management and maintenance.
  • Created reports using SQL Server reporting services 2005.
  • Wrote a number of stored procedures to validate the complex mappings using T-SQL. Created and Configured SSIS tasks to load data in to target tables.
  • Test plans for auditing the migration process by creating an Audit Table to log each migration task.

Environment: C#.NET, ASP.NET 3.5,MOSS 2007, ADO.NET, JQuery, CSS, Visual Studio.NET 2008, SQL 2005, SSIS, SSRS, ETL, Visual Source Safe, IIS.

Hire Now