We provide IT Staff Augmentation Services!

.net/sql Server/ Msbi Developer Resume Profile

Virginia Beach, VA

PROFESSIONAL SUMMARY

  • More than 6 years of Total Experience in IT Industry in various domains like Healthcare Insurance/Retails in both waterfall and Agile methodology.
  • MCTS - Microsoft Certification completed for Dot Net framework 2.0 3.5
  • MCTS - Microsoft Certification done for SQL Server 2008 Development.
  • Strong Skills with Visual Studio 2008, .Net framework 3.5, C .Net, SSIS.
  • SQL Server 2005/2008/2012 RDBMS database development including T-SQL programming.
  • Working Experience on SQL 2000/2005/2008/R2/2012 including DTS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
  • Microsoft Certified Technology Specialist in Business Intelligence and SQL Server 2008 R2.
  • Good experience in SQL server 2008, SSRS.
  • Worked on reporting services, power view, powerpivot and powerview with Sharepoint integration.
  • SQL Server 2008 OLAP database development including KPIs, Data mining, working with changing dimensions.
  • Very Good Understanding and Experience in SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS and SQL Server Reporting Services SSRS .
  • Developing reports on SSAS SSRS on SQL Server 2005/2008/2008R2/2012 . Sound Experience and understanding of SSAS, OLAP cube and Architecture.
  • Good knowledge on CBO and TPL for healthcare
  • Experienced in integrating different Microsoft BackOffice Components such as SharePoint and IIS with MS SQL Server.
  • ETL implementation using SQL Server Integration Services SSIS in OLTP and Data warehouse Environment.
  • Working Experience on slowly changing dimensions and creating SSIS packages using Active X scripts with Error Handling.
  • Strong knowledge in Relational Database Management Systems and experience in writing SQL scripts, Stored Procedures, User Defined Functions and Triggers for SQL Server 2000/2005/2008 and Oracle.
  • Created complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server 2005/2008/2012 and Transformation.
  • Experience with AJAX Library/AJAX Toolkit and creating high responsive User Interface.
  • Skilled in web building technologies like HTML, HTML5, DHTML, JavaScript, Jquery, CSS, XML, XSL, XSLT, DTD/Schemas and AJAX.
  • Good knowledge in Property tax Domain system.
  • Experience in developing MS Excel/MS Word applications using VSTO.
  • Good experience with Crystal reports and SQL Reporting Services.
  • Worked on calling Web Services from client side using AJAX Libraries
  • Developed web services .asmx/WCF based on SOAP/JSON
  • Involved with MVC architectural design pattern and used MVC in integration with JavaScript framework.
  • Experience in writing SSIS Packages/SSRS in SQL Server
  • Experience in Agile methodology and developing projects using TDD Test Driven Development and various testing frameworks like NUnit, MSTest, Pex using different Mock framework like Typemock, NMock and coverage tool NCover
  • Experience with Microsoft TEAM Foundation Server for Code Repository, Deployment and Version control.
  • Experience in developing/consuming WCF Windows Communication Foundation services.
  • Worked on win services/WCF and MVC architecture in Dot Net.
  • Experience of working in UIP architecture with TDD.
  • Have good knowledge of WF, WCF, WPF, SilverLight, Blaze Rules Engine

SUMMARY OF SKILLS

.NET Technologies

Microsoft .NET Framework CLR, CLS, CTS , C , VB.NET, ASP.NET, ADO.NET, XML Web Services, Win Forms, Web Forms, SOAP 1.1, WSDL, UDDI, .NET Remoting, COM/COM Interoperability, NUnit, WCF, WPF.

Web Development

ASP.NET, ASP.NET MVC, ASP, IIS 6.0, VBScript, JavaScript, CSS, , HTML, HTML5, AJAX, XML, XSL, XSLT,CAML, XPath, XQuery, ExtJs, JQuery, JSON.

Programming Languages

C , ASP.NET, VB.NET, ADO.NET, JAVA, XML, XSL, XSLT, C, C , VC , VB6.0, ASP, Transact SQL T-SQL , PL/SQL, C, C , VB Script

Development Tools

Visual Studio .NET 2003 /2005 /2008 /2010 /2012, Visual Source Safe, Microsoft Visio, Microsoft Team Foundation Server, Microsoft Application Center Test, JBuilder, Net Beans, Agile Methodology, Rational Rose, UML, Microsoft Office Visio, Toad for Oracle 11g, SSIS Process Studio

RDBMS

MS-SQL Server 2000/2005/2008/2012, Oracle, DB2, MySQL.

Operating Systems

Windows Vista/XP/2000/NT/98/7/8, DOS.

DB Modeling Tools

MS Visio, Erwin

Reporting Tools:

SQL Server Reporting Services SSRS , Crystal reports 8.0/9.0/10.0,MS Excel.

PROJECT EXPERIENCE

Confidential

Role: .Net/SQL Server/ MSBI Developer

Technical Skills - ASP.Net C 2010, .NET Framework 4.0, ASP.NET 3.5, C , Visual studio 2010, SQL Server2012,SSIS/SSRS/SSAS, Oracle, Agile

Responsibilities/Roles

  • Working as a MS SQL and MSBI developer for Facets financial system of Wellpoint.
  • Basically involved in the huge level migration for financial data / system from Amerigroup to WellPoint Since WellPoint has taken over Amerigroup.
  • Understanding application business and existing system of Amerigroup including SSIS packages SSRS reports.
  • Developing new SSIS packages and SSRS reports for WellPoint system to get the data / business migrated from legacy Amerigroup warehouse to Wellpoint System.
  • Developing new database Schemas according to the data migration requirement for WellPoint's ETL process.
  • Acquiring new Development/ working environment and getting familiar with system of WellPoint along with Agile methodology.
  • Getting involved in the datatransfer from various data sources/business systems including Oracle, MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS/ETL using various data transformations components like data conversion, look up transformations etc. Created derived columns from the present columns for the given requirements
  • Creating Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
  • Working under test driven development TDD .

Confidential

Role: .Net/SQL Server Developer

Technical Skills - ASP.Net C 2010, .NET Framework 4.0, ASP.NET 3.5, IIS 7.0, Windows Services, C , HTML,C , WCF, MVC, NUnit, Visual studio 2010,SQL Server2012,SSIS/SSRS/SSAS,Oracle, Site core Agile

Responsibilities/Roles

  • Working as a BE developer having interaction with 'Sitecore' as FE content management system.
  • Understanding application business and successfully done development of the application 'Member portal face of humana ' and 'Employer Portal' till production deployment.
  • Responsible for WCF service implementation with UIP MVC architecture and module testing.
  • Developed the Web Application in ASP.Net 3.5 using Master Page, Themes skins to maintain the consistent look and feel throughout the application.
  • Develop Business logic layer by implementing Object Oriented Programming languages OOPS CONCEPTS abstraction, encapsulation, inheritance, polymorphism in C .
  • Involved in developing Web Service classes using SOAP to communicate with legacy systems and also deployed web services as per business requirement.
  • Used JavaScript and .NET Validation Controls for performing client-side validations.
  • Designed a Master Page and used CSS for to provide a consistent look and feel of inherited web pages.
  • Involved in the Analysis, Design and Development of the Web Based Intranet Application using ASP.NET, C , mutliview, jquery, javascript, session states.
  • Designed and Developed Web Services to synchronize data from Remote application database to Online Database using C .Net, ASP.Net, Visual Studio.
  • Acquiring new technology like Blaze to interact via dotnet the application.
  • Transferred data from various data sources/business systems including DB2 AS400 , MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS/ETL using various data transformations components like data conversion, look up transformations etc. Created derived columns from the present columns for the given requirements
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
  • Created a Reporting Services report that is based on a PowerPivot workbook that has been published to SharePoint. Reporting Services offers rich data visualization through charts and maps, additional rendering formats such as PDF or Word, and comprehensive subscription and delivery options. Using Reporting Services to visualize, render, or distribute PowerPivot data gives you powerful alternatives for making business intelligence data available to other people in your organization
  • Understanding and working under test driven development TDD .
  • Responsible for code review and review implementations.
  • Done Deployment of Websites till Prod Servers.

Confidential

Role: .Net/SQL Server Developer

Technical Skills - ASP.Net C 2008, SSIS, SSRS, SQL Server 2008 R2, Blaze Adviser Agile , NET Framework 4.0, Visual Studio 2010, Web services, SQL SERVER 2008, CSS, C ,JavaScript, HTML,DHTML XML ,SOAP, AJAX, WCF, SQL, LINQ, IIS, SVN, Visual Studio Test Professional

Responsibilities/Roles

  • Designed and developed matrix and tabular reports with drill down, drill through and drop down menu and used gauge reports with KPI's in SSRS.
  • Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Excellent in Data Extraction, Transforming and Loading ETL using SQL Server Integration Services SSIS , DTS, Bulk Insert, BCP.
  • Generated reports using SSRS.
  • Used TFS for version control,
  • Involved in testing and fixing the issues occurred in the testing process.
  • Involved in Unit Testing, Functional testing, API Testing using Microsoft testing Framework, NUnit.
  • Used LINQ to manipulate and fetch the data from database.
  • Extensively used ASP.NET, C .NET Validation Controls, jquery and JavaScript for client side validations in the Web Pages.
  • Involved in implementing the logic using C and oops concept.
  • Developed Web services using C .
  • Used ASP.NET web form controls such as Grid View, List View, etc. for displaying data.
  • Involved in developing WCF Web Service using SOAP/HTTP to communicate with legacy systems.
  • Used front end web development tools like CSS, JavaScript, DHTML.
  • Involved in development of MVC patterns for client server interaction.
  • Understanding application business and successfully done development of the application 'Rewards Website' till production deployment.
  • Responsible for WCF Win service implementation, console application development with UIP MVC architecture and module testing.
  • Responsible for database stored procedure creation with testing execution.
  • Understanding and creation of SSIS packages for application flow.
  • Acquiring new technology like Blaze to interact via dotnet the application.
  • Understanding and working under test driven development TDD .
  • Responsible for creation of UTPs Unit test Plans .
  • Responsible for code review and review implementations.
  • Done Deployment of Websites till Prod Servers.

Confidential

Role: .Net/SQL Server Developer

Technical Skills - ASP.Net C 2010, WCF 4.0 RESTFUL, SQL Server 2008 R2 Agile ,SSIS,SSRS,ASP.NET 4.0, C 4.0, C ,JavaScript, CSS, HTML, jQuery, AJAX SQL Server 2008, Oracle, Visual Studio.NET 2010, IIS 6.0

Responsibilities/Roles

  • Understanding previous version of HADS with required new enhancement in expected version 2.0
  • Responsible for RESTFUL WCF architecture development with help of fiddler tool.
  • Responsible for database stored procedure creation with testing execution.
  • Designed, developed and supported a complete website using ASP.Net, C , JavaScript, CSS, HTML, jQuery, AJAX, IIS 6.0.
  • Experience as a Subject Matter Expert, understood the Business requirement and designed the application accordingly.
  • Implemented several validations using validation controls.
  • Used Microsoft Team Foundation Server for source repository and version control.
  • Hosted and deployed the website on IIS 6.0 on the server. Experience as IIS admin.
  • Used Microsoft SharePoint services as a repository for all the project and related documentation.
  • Acquiring new technology like RESTFUL WCF to implement.
  • Understanding and working under test driven development TDD .
  • Responsible for creation of UTPs Unit test Plans .
  • Responsible for code review and review implementations.
  • Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.
  • Experience in creating SSIS packages using dashboard.
  • Involved in writing classes for business logic layer using C .
  • Back end Experience in MS SQL Server development, writing T-SQL stored procedures, coding, triggers and cursors
  • Used Sql Profiler for troubleshooting, monitoring, optimization of SQL server 2008/2012 and SQL code.
  • Optimized the database by creating various clustered, non-clustered indexes and indexed views.
  • Taking Database full Backup, Transaction log backup differential backup in daily Routine.

Confidential

Role: .Net/SQL Server Developer

Technical Skills - ASP.Net C 2008, SSIS, SSRS, SQL Server 2008 Agile , ADO.Net, HTML, XML, jQuery, DHTML, CSS, Web Services, C ,MS Visio, UML, JavaScript, SSIS, SSRS, T-SQL

Responsibilities/Roles

  • Understanding existing SSIS packages working with prior system and migrating them to new database with desired enhancement.
  • Used MVC architecture for client server interaction.
  • Developed and consumed Web Services to extract information from the database and other services.
  • Created various Web forms for user login, account summary, loan applications and history pages using ASP.Net.
  • Used various advanced Server Controls and developed Custom Controls.
  • Implemented form based authentication and maintained Session State information throughout the web transaction.
  • Implemented server side business logic using C .
  • Implemented Client and Server side validations using JavaScript and ASP.Net validation controls.
  • Configured the WebConfig file for Session Management and trace.
  • Used HTML, DHTML and CSS for developing Web Pages.
  • Designed CSS aiming for a rich personalization of server side controls
  • Provided database connectivity using ADO.Net and created procedures, Indexes and Triggers using MS SQL Server 2008.
  • Back end Experience in MS SQL Server development, writing T-SQL stored procedures, coding, triggers and cursors.
  • Used T-SQL to examine the database information.
  • Using SQL server reporting services SSRS delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
  • Making a Report as per user requirement using MS Reporting Services 2008 SSRS .
  • Created SSIS Packages to migrate slowly changing dimensions
  • Used Data Adapters and Datasets of ADO.Net to manipulate data in the SQL server database.
  • Extensively used Datagrids and Datalists to display account summary, loan history and other information on the web pages.
  • Performed functional testing on various developed modules.
  • Involved in generating and exporting SSRS reports.
  • Responsible for database stored procedure creation with testing execution.
  • Responsible for creation of UTPs Unit test Plans .
  • Responsible for code review and review implementations.
  • Done Deployment of packages till Prod Servers using.

Confidential

Role: .Net/SQL Server Developer

Technical Skills - ASP.Net, SQL Server, Classic ASP, .NET Framework 3.5,Visual Studio 2008, C .NET, SQL SERVER 2008, ADO.NET, Web Services, MS Visio, UML, JavaScript, HTML,XML, jQuery, IIS,DB2 Agile

Responsibilities/Roles

  • Understanding existing application and responsible for enhancement in the same.
  • Responsible for screen design, code development and module testing
  • Responsible for creation of UTPs Unit test Plans , UTRs Unit Test Results , etc
  • Extensively used ASP.NET controls for developing the UI
  • Used C .NET in writing Business classes and Data Access layer methods.
  • Developed Web services for implementing the business logic
  • Designed Class and use case diagrams using MS Visio.
  • A Web service is published as per the business requirements.
  • Attended the code review sessions and have given presentations.
  • Involved in writing stored procedures using SQL Server 2008.
  • Used the ADO.NET SqlClient Objects like SqlConnection, SqlCommand, SqlDataReader and SqlDataAdapter and Dataset object in the Data Access Layer to fetch the data from the SQL Server 2008 database.
  • Involved in creating Views, Stored Procedures and Triggers and calling them from the Data Access Layer.
  • Performed unit testing and functional testing.
  • Responsible for code review and review implementations.
  • Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
  • Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Excellent hands on experience with SQL Server Integration Service SSIS , SQL Analysis Services SSAS and Reporting Services SSRS .
  • Extract Transform Load ETL development using SQL Server 2008 Integration Services SSIS .
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Installation and configuration of SQL Server 2008.
  • Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports,Subreports using Sql Server Reporting Services 2008.

Confidential

Role: .Net/SQL Server Developer

Technical Skills - Visual Basic 6.0, Microsoft Access Waterfall , Visual Studio 2005, C .NET, ASP.NET, ADO.Net, HTML, CSS, Java Script, SQL Server 2005, Windows XP , IIS.

Responsibilities/Roles

  • A part of all documentation for the project such as design document, impact analysis, etc.
  • Involved in designing using UML tools.
  • Developed the application using Waterfall methodologies.
  • Developed front-end UI using ASP.NET web pages.
  • Developed web pages and style sheets using HTML and CSS.
  • Used HTML controls and server controls and developed user controls.
  • Implemented business components and data access code using C .
  • Exceptions and errors are handled throughout the application in such a way that the down time is minimized.
  • Involved in database interactivity using SQL Server 2005.
  • Created SQL nested queries, stored procedures and triggers.
  • Used ADO.Net connectivity objects like Data Sets and Data Adapters.
  • Responsible for interaction with onsite counterparts for business logic.
  • Generated detailed reports using Crystal Reports.
  • Involved in unit testing and system integration testing.
  • Wrote the expressions in SSRS wherever necessary.
  • Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • Modifying report content and exporting reports in multiple formats based on the business requirements.
  • Designed and implemented Parameterized and cascading reports using SSRS 2008.
  • Configured Database Mail for sending automatic emails when a SSIS package is failed or succeed.
  • Developed, deployed and monitored SSIS Packages.
  • Developed custom reports and deployed them on server using SSRS.
  • Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
  • Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS.
  • Understanding existing application and responsible for enhancement in the same.
  • Responsible for testing of whole module and creation of UTPs Unit test Plans , UTRs Unit Test Results , etc

Hire Now