We provide IT Staff Augmentation Services!

Sr. Sql Server Bi Developer Resume

Irving, TX

SUMMARY:

  • Over 11 years of experience in application development using Microsoft SQL Server, C#, VB.NET, ASP.NET and related technologies.
  • Over 7 years of experience as a Microsoft SQL Server BI Developer.
  • Experience in T - SQL, SSIS, SSAS and SSRS.
  • Experience in Relational database programming using Microsoft SQL Server.
  • Experience in Object Oriented Programming.
  • Experience in the entire Software Development Life Cycle (SDLC).
  • Experience in creating and consuming Web Services and developing n-tier applications in .NET.
  • Experience in Windows Forms and Web Forms.
  • Good analytical, problem solving, and communication skills.
  • Permanent Resident in the U.S.

TECHNICAL SKILLS:

RDBMS: SQL Server 2012/2008/2005/2000/7.0 , Oracle 9i/8i, MS Access

ETL/OLAP/Reporting Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)

.NET Skill Set: ASP.NET 4.0/3.5/2.0/1.1 , ADO.NET, .NET Framework 4.0/3.5/2.0/1.1 , WCF, WPF, WF

Languages: T-SQL, C#, VB.NET, VB 6.0, Java, C++, C

Web Development: HTML, DHTML, ASP, XML, XSL, CSS, JSP, AJAX

Scripting Languages: JavaScript, VBScript

Operating Systems: Windows Server 2003, Windows 2K/98/95/NT, Windows XP, Windows 7.0

Development Tools: Visual Studio, Visual SourceSafe, Team Foundation Server

Third Party Software: Pragmatic Works BIXpress, Pragmatic Works TaskFactory 3.5, BMC Control 9.0/8.0, Infragistics 6.3, BIML

Methodologies: Waterfall, Agile/Scrum

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Sr. SQL Server BI Developer

Responsibilities:

  • Led, Designed and developed a complete ETL solution in SSIS 2012, Stored procedures, etc., with dynamic connections, error handling capabilities and validations where applicable, to extract data from various sources such as Flat files, XML files, SQL Server tables, etc., for all PMS loads, with very minimal or no changes and also trained and mentored other team members in implementing the same.
  • Designed and developed an ETL solution using SSIS 2008 R2, Stored procedures, Package Configurations, etc., to export data to other sources, to be delivered to external clients.
  • Trained the junior team members in developing and supporting new and existing ETL processes.
  • Involved in the entire project development life cycle.
  • Interacted with the Business Analysts and Users in gathering requirements.
  • Supported and maintained the existing processes using Stored Procedures, SSIS packages, Functions, Views within the SQL Server environment.
  • Used Pragmatic Works Task Factory for Upsert Tasks, Error Handling and Send Mail Tasks.
  • Involved in generating multiple packages using BIML code.
  • Used Pragmatic Works BIXpress Auditing and Notification Frameworks to monitor SSIS packages during production loads.
  • Created and supported SQL Agent jobs and Control-M jobs in production to run and monitor ETL processes on a daily, weekly and monthly basis.
  • Migrated SSIS projects from SVN to TFS and created and maintained database projects in TFS.
  • Worked with DBA team in resolving performance issues by code modification and indexing .
  • Interacted with the QA team and Users in resolving bugs and production issues.
  • Involved in creating Change requests in Footprints and ServiceNow.
  • Deployed SSIS Packages and code to production.

Environment: SQL Server 2012/2008R2(T-SQL, SSIS, SQL Agent), BIDS 2012/2008 R2, BIML Tortoise/Visual SVN, Team Foundation Server 2012/2013, BMC Control - M 9.0/8.0, BIML, Mingle.

Confidential, Irving, TX

SQL Server BI Developer

Responsibilities:

  • Involved in the entire project development life cycle.
  • Gather requirements from the Business users and translate them to code.
  • Build an Enterprise Data Warehouse to store data and process the data in an effective manner, to manage claims for the UMWA Health and Retirement Funds using Stored Procedures, SSIS packages, and SSRS reports within the SQL Server environment.
  • Create and maintain necessary database objects such as tables, views, stored procedures, functions, etc., in SQL Server 2012.
  • Schedule SQL Agent jobs to run the ETL processes and Reports.
  • Interact with the Users in resolving the bugs.

Environment: SQL Server 2012, SSIS 2012, SSRS 2012, SQL Agent, Visual Studio Data Tools 2010

Confidential, Plano, TX

SQL Server BI Developer

Responsibilities:

  • Part of a team that creates and uses a data warehouse to store data and process the data in an effective manner.
  • Involve in the entire project development life cycle.
  • Interact with the Users in gathering the requirements.
  • Create and maintain necessary database objects such as tables, views, stored procedures, functions, etc., in SQL Server 2008R2/2005.
  • Develop new production ETL processes and Reports and support and maintain the existing ones using Stored Procedures, SSIS packages, and SSRS reports within the SQL Server environment.
  • Schedule SQL Agent jobs to run the ETL processes and Reports.
  • Interact with the QA and Users in resolving the bugs.
  • Convert the existing SQL Server 2000 DTS packages to SQL Server 2005 SSIS packages and SQL Server 2005 SSIS packages and SSRS Reports to SQL Server 2008.

Environment: SQL Server 2008/2005(T-SQL, SSIS, SSRS, SQL Agent), BIDS 2008/2005, Team Foundation Server 2010

Confidential, Lewisville, TX

SQL Server BI Developer

Responsibilities:

  • Part of a team that created and used a data warehouse to store data and process the data as per User’s requirements.
  • Involved in the entire project development life cycle.
  • Created and maintained necessary database objects such as tables, views, stored procedures, functions, etc., in SQL Server 2008 R2.
  • Developed new production ETL processes and Reports and supported and maintained the existing ones using Stored Procedures, SSIS packages within the SQL Server environment.
  • Scheduled SQL Agent jobs to run the ETL processes and cubes on a daily, weekly and monthly basis.
  • Interacted with Users in resolving the bugs and production issues.

Environment: SQL Server 2008 R2 (T-SQL, SSIS, SSAS, SSRS, SQL Agent), BIDS 2008, Team Foundation Server

Confidential, Addison, TX

SQL Server BI Developer

Responsibilities:

  • Part of a team that creates and uses a data warehouse to store data and process the data in an effective manner.
  • Involve in the entire project development life cycle.
  • Interact with the Users in gathering the requirements.
  • Create and maintain necessary database objects such as tables, views, stored procedures, functions, etc., in SQL Server 2008/2005.
  • Develop new production ETL processes and reports and support and maintain the existing ones using Stored Procedures, SSIS packages, SSAS cubes and SSRS reports within the SQL Server environment.
  • Schedule SQL Agent jobs to run the ETL processes and cubes on a daily, weekly and monthly basis based on the Calendar day/Business day of the month.
  • Interact with the QA and Users in resolving the bugs and production issues.
  • Migrate the existing database objects, SSIS Packages, SSAS cubes, SSRS reports and jobs from Legacy servers to the new servers.
  • Convert the existing SQL Server 2000 DTS packages to SQL Server 2005 SSIS packages and SQL Server 2005 SSIS packages to SQL Server 2008.

Environment: SQL Server 2008/2005(T-SQL, SSIS, SSAS, SSRS, SQL Agent), BIDS 2008/2005, Visual Source Safe 2005, Team Foundation Server 2008/2010

Confidential

SQL Server BI Developer

Responsibilities:

  • Migrated the existing database objects from old server to the new server.
  • Supported and created necessary database objects such as SQL queries and stored procedures in SQL Server 2008/2005.
  • Designed and developed ASP.NET pages using Master Pages and Themes, C#, CSS, HTML and AJAX to create the Confidential Website.
  • Used Team Foundation Server and Visual Source Safe for Source Control and Code Tracking.

Environment: SQL Server 2005, SSIS, SSRS, .NET 3.5 using C# as the language in VS.NET 2008, Team Foundation Server 2008/2010, Visual Source Safe 2005, CSS, AJAX

Confidential, Carrollton, TX

Web Developer

Responsibilities:

  • Analyzed the Business requirements and developing user interfaces using ASP.NET.
  • Developed new modules and supported existing modules within the ASP.NET environment.
  • Designed and developed ASP.NET pages using Visual Studio 2008, HTML, and C #.
  • Used JavaScript for Client side validations.
  • Used ADO.NET, LINQ to interact with SQL Server 2008 tables and created and maintained necessary database objects such as SQL queries and stored procedures in SQL Server 2008.
  • Manually tested the application.
  • Interacted with the end users in resolving the bugs.

Environment: .NET 3.5 using C# as the language, ASP, WCF, Team Foundation Server, SQL Server 2008, CSS, HTML, Javascript, AJAX

Confidential, Addison, TX

.Net Developer

Responsibilities:

  • Developed web pages as per the business specifications.
  • Developed new modules and supported existing modules within the ASP.NET environment.
  • Designed and developed ASP.NET pages using Visual Studio 2005/2008 HTML, C# and VB.NET.
  • Used Master Pages and Themes to have a consistent look and feel across the pages.
  • Used Validation controls to validate user input on Server side.
  • Used JavaScript for Client side validations.
  • Used ADO.NET to interact with SQL Server 2005 tables and created and maintained necessary database objects such as SQL queries and stored procedures in SQL Server 2005.
  • Developed new SSIS Packages and supported and maintained them within the SQL Server environment.
  • Manually tested the application.
  • Interacted with the users in resolving the bugs.

Environment: .NET 2.0/3.5 using VB.NET, C# as languages in VS.NET 2005/2008, BIDS 2005, Team Foundation Server, Visual Source Safe, SSIS, SQL Server 2005, SSIS,CSS, JavaScript, AJAX

Confidential, Plano, TX

.Net Developer

Responsibilities:

  • Involved in the entire project development life cycle.
  • Analyzed, designed and developed applications as per the business requirements.
  • Made enhancements to the ETL tool using Windows Forms and C# as the language in Visual Studio 2005 and Infragistics as the third party software for developing a user friendly interface.
  • Integrated the code with Windows Services.
  • Used ADO.NET to interact with SQL Server 2005 tables and created and maintained necessary database objects such as SQL queries and stored procedures in SQL Server 2005.
  • Developed new SSIS Packages and supported and maintained the existing ones within the SQL Server environment.
  • Manually tested the application.
  • Prepared technical documentation.
  • Interacted with the QA team in resolving the bugs.

Environment: Visual Studio 2005, BIDS 2005, C# 2.0, Windows Forms, Windows Services, Infragistics 6.3, SQL Server 2005, SSIS, Visual SourceSafe

Confidential, Houston, TX

.Net Developer

Responsibilities:

  • Developed applications according to the business specifications.
  • Provided support for existing web applications, automated procedures, and solutions as needed.
  • Designed and developed ASP.NET pages using Visual Studio 2005 and HTML.
  • Used validation controls to validate the user input.
  • Used ADO.NET to interact with SQL Server 2005 tables and created and maintained necessary database objects such as SQL queries, stored procedures, etc., in SQL Server 2005.
  • Manually tested the application and resolved the bugs.

Environment: ASP.NET 2.0 using C# as the language in VS.NET 2005, IIS 6.0, SQL Server 2005, Visual SourceSafe

Confidential, Ft. Lauderdale, Florida

.NET Developer

Responsibilities:

  • Involved in developing the application and reports.
  • Worked on the Preventive healthcare module, which has information about doctors and patients.
  • Created stored procedures in SQL server 2000
  • Developed server-side code in C# and utilized within the ASP.NET code.

Environment: ASP.NET 1.1 using C# as the language, SQL Server 2000, IIS 5.0, ADO.NET, Visual Source Safe.

Confidential, Milpitas, CA

ASP.NET Developer

Responsibilities:

  • Involved in the design and development of web pages.
  • Interacted heavily with end-users, throughout the development life cycle, including requirements gathering, testing and implementation.
  • Developed ASP.NET pages using web forms, win forms, server, validation and user controls using C# and VB.NET.
  • Used ADO.NET extensively to interact with SQL Server 2000 databases and created stored procedures in SQL server and also developed server-side scripts in C# and utilized within the ASP.NET code.
  • Client-side validations using JavaScript

Environment: ASP.NET 1.1 using VB.NET/C# as the languages, SQL Server 2000, IIS 5.0, ADO.NET, Visual Source safe and JavaScript

Hire Now