We provide IT Staff Augmentation Services!

Sql Server Developer Resume

NJ

SUMMARY:

  • I have around 12+ years of work experience in MS SQL Server database technology of versions 2016, 2012, 2008R2, 2005, & 2000.
  • In - depth knowledge of SQL (DQL,DML,DDL,TCL,DCL) and T-SQL (CTE, PIVOT, UNPIVOT& etc.)procedural language.
  • Extensive Experience of writing new complex Stored Procedures, Functions, Triggers, Cursors & Views and having good knowledge of analyzing the business logic of existing SP’s, UDF’s, TRG’s and Views were updated with new implementation of business logic.
  • Complex Stored Procedures were created as they involved in gathering and aggregating data from various tables and databases using multiple joins giving me an excellent experience to create most complex queries.
  • Good knowledge of performance tuning, query optimization by using indexes & few tips to improve performance to execute complex quires fast. Interacted with SQL Server Profiler and display estimated execution plan tools for the same.
  • Experience in MS SQL Server Administration, installation, configuration, query optimization, back-up/recovery, running database consistency checks using DBCC, and trouble shooting.
  • I have 10 years of work experience in Integration Services(MSBI-SSIS) ETL technology of versions 2005, 2008R2, & 2012.
  • Extensive experience of ETL tools including Data Transformation Service (DTS) and SQL Server Integration Services (SSIS) in development, deployment and administration as well.
  • Expertise in extracting, transforming and loading data between homogeneous and heterogeneous systems like SQL Server, Oracle, DB2, TERADATA, MS Access, Excel, Flat File and etc using SSIS packages.
  • Having good experience in Incremental Loading and Data Matching.
  • Good experience of using transformations like Data conversion, Derived column, Conditional split, Merge Join, Look up & etc in SSIS complex packages.
  • Experience of scheduling the SSIS packages execution in SQL Server Agent and tracking the success or failure of the execution of SSIS Packages. And configuring the email notifications through SQL Server Agent.
  • 8 years of work experience in Reporting Services(MSBI-SSRS) reporting technology of versions 2005, 2008R2, 2012 & 2016.
  • Familiar with SSRS server configuration, deployment & administration of Report Manager.
  • I have good overview knowledge in Analysis Services(MSBI-SSAS) cube technology of version 2008R2.
  • Good knowledge of SSAS dimensions and cube development.
  • Having good experience of OLAP database models such as star and snow flake schemas.
  • Good knowledge of developing and deploying WPF & ASP.NET web technologies.
  • Excellent communication skills, preparing project related documentation, knowledge transferring and sharing innovative ideas with team and end user client. Working dedicatedly on projects and understanding the client requirements and delivering projects/tasks on time to the full satisfaction of the client.

TECHNICAL SKILLS:

Operating Systems: Windows Servers (NT/ 2003/20 /XP/VISTA/7/8

Programming Languages: T-SQL, MDX, PL/SQL, C#, VB, Java, C, C++

Database Servers: MS SQL Server 2000/2005/2008 R2/2012/2016, Oracle 9iDB2, TERADATA, MS Access

MSBI Services & Tools: Services( SSIS, SSRS, SSAS)

Reporting Services: Configuration Manager) Tools(BIDS, DTUTIL, DTEXECUI, DTEXEC

Server side Technologies: ASP.NET, .NET, ASP, Web Services

Windows Technologies: WPF, Winforms

Other Servers: IIS, FTP, SMTP

Internet Tools: ASP.NET, AJAX, HTML, CSS, JavaScript and VBScript

Version Control Tools: Team Foundation Server, Visual SourceSafe 6.0

XML Technologies: XML, XSL, XSLT

Reporting Tools: SSRS, Spotfire, QlikView, Crystal Reports, Dundas Reports, Ad-Hoc

PROFESSIONAL EXPERIENCE:

Confidential, NJ

SQL Server Developer

Responsibilities:

  • Interacted with various teams and gathered the business requirements and analyzed the requirements before starting the development.
  • Developed new SSIS packages based on given requirements.
  • Migrated 2008 SSIS packages to 2016 SSIS packages.
  • Extensively used Execute SQL Task, Data Flow Task, Script Task, FTP Task, Mail Task, For Each Loop Container and many more components.
  • Created efficient Stored Procs, UDFs, and Views having complex queries to enforce the business rules to load the valid data in the destination tables.
  • Enabled the SQL Server table logging feature to each SSIS package.
  • Created the email logic in each SSIS package which sends the email notification on the package failure.
  • Debugging the production errors and quickly fixing them in an efficient manner.
  • Thoroughly unit testing the SSIS package and SQL scripts while developing on Dev and QA environments.
  • Enhanced the existing stored procs to improve the performance using the advance queries
  • Responsible for handling end to end ETL development which includes gathering requirements, developing of SSIS packages and SQL scripts, unit testing, performance tuning as required and deployment.

Environment: SQL Server 2016/2008R2, SSIS, SSMS, AQT, TSQL, MS Excel, CVS, XML, MS Windows 7, PVCS and etc.

Confidential

Sr. Technical Lead Consultant

Responsibilities:

  • Analyzed existing EMS Database & functional architecture design
  • Assigned the tasks to the appropriate team member based on the complexity of the requirements after thorough analysis of the sprint user stories.
  • Supported the team members technically on critical issues. Monitored the team and reviewed the code on daily/weekly basis to maintain the book of quality.
  • Incorporated the new business logic in the existing stored procedures & other SQL Server objects.
  • Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
  • Extensively used the SQL profiler to trace out the execution of SQL objects and capturing the input parameter values of the stored procedures.
  • Optimized the database by creating various clustered, non-clustered indexes and indexed views.
  • Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
  • Created SSIS Packages which loads the data from the CMS to the EMS library database.
  • Extensively used data flow task with many transformations like lookup, union all, conditional split, data conversion, derived column, multi cast, script component, row count & sort
  • Involved in daily standup meeting with offshore & onsite teams to discuss on daily tasks, show stoppers, bug fixes & upcoming tasks & etc.
  • Proactively interacted with testing team and PP team to get the clarity on the bugs & new requirements.

Environment: SQL Server 2012, SSIS, TFS, SAC, SCM, SSMS, TSQL, MS Excel, CVS, XML, MS Windows Server 2012 /Windows 8 and etc.

Confidential

Sr. SSIS & SQL Server Developer

Responsibilities:

  • Analyzed all existing SSIS packages, SQL Server objects & new functional specs
  • Created technical specs for the quarterly projects based on functional specs approved by several project managers.
  • Assigned the tasks to the appropriate resources based on the complexity of the requirements after thorough analysis of the project workflow.
  • Supported the team members technically on critical issues. Monitored the team and reviewed the code on daily/weekly basis to maintain the book of quality.
  • Added new items to legacy SSIS packages, stored procedures & other SQL Server objects.
  • Loaded data(Full/Incremental) from different sources to SA & EA layers of various databases
  • Having good experience in debugging and identifying the unexpected real-time issues in the production server SSIS packages
  • Enhanced the SSIS package logging system.
  • Pro-actively implemented the new SSIS packages within the short timeline, completed Unit, DIT, SIT & UAT testing and deployed to the production server.
  • Implemented SQL Server 2012 AlwaysON new feature on couple of databases.
  • Prepared each project technical specs, test cases plan & test results documents.
  • All over the SSIS packages, used C# expressions to control the flow of tasks, to set the dynamic file paths & other expressions.
  • Created parent & child SSIS packages to break-down the business logic structure to improve the performance.
  • Extensively used data flow task with many transformations like lookup, union all, conditional split, data conversion, derived column, multi cast, script component, row count & sort
  • Enabled the SSIS package configuration to make the flexibility to pass the connection strings to connection managers and values to package variables explicitly based on environments

Environment: SQL Server 2012, SSIS, TFS, SAC, SCM, SSMS, TSQL, MS Excel, CVS, XML, MS Windows Server 2012 /Windows 8 and etc.

Confidential

Sr. SSIS & SQL Server Developer

Responsibilities:

  • Analyzed all existing SSIS packages & SQL Server objects
  • Added new items to old SSIS packages, stored procedures & table columns
  • Enhanced the SSIS package logging system.
  • Loaded full load & incremental data from CSV, EXCEL & CTL files to SA & EA layer tables for various databases
  • Extensively used FtpClientConnection.NET class in Script Task to do FTP operations
  • Frequently used SmtpClient & NetworkCredential .NET classes in Script Task to send SSIS package success or error email to admin in HTML format.
  • Having good experience in debugging and identifying the unexpected real-time issues in the production server SSIS packages
  • Pro-actively implemented the new SSIS packages within the short timeline, completed Unit, SIT & UAT testing and deployed to the production server.
  • Prepared each project technical specs, test cases plan & test results documents.
  • All over the SSIS packages used C# expressions to control the flow of tasks, to set the dynamic file paths &other expressions.
  • Created parent & child SSIS packages to organize the business logic structure
  • Extensively used data flow task with many transformations like lookup, union all, conditional split, data conversion, derived column, multi cast, script component, row count & sort
  • Enabled the SSIS package configuration to make flexibility to pass the connection strings to connection managers and values to package variables explicitly based on environments

Environment: SQL Server 2008 R2, SSIS, SSRS, TFS, SAC, SCM, SSMS, TSQL, MS Excel, CVS, XML, MS Windows Server 2008 /Windows XP and etc.

Confidential

Sr. SSIS & SQL Server Developer

Responsibilities:

  • Analyzed existing complicated stored procedures and modified with new logic
  • Configured the mapping tables to organize the macro application execution structure to generate the business reports
  • Improved the performance tuning on huge data tables select queries by using indexes, temp tables & etc.
  • Unit testing done on several business reports to get the accurate information
  • Daily interacted with business users to get the requirements & delivery the related market business reports
  • Debugged the complicated stored procedures
  • Migrated the data from production environment to development data warehouse using SSIS (ETL) services

Environment: SQL Server 2005, SSIS, SSRS, TFS, SAC, SCM, SSMS, TSQL, MS Excel, CVS, XML, MS Windows Server 2003 /Windows XP and etc.

Confidential

Sr. SSIS & SQL Server Developer

Responsibilities:

  • Analyzed all IT AM Finance project related documents
  • Created business related basic standard SSIS Template Package useful while developing new SSIS Package.
  • In SSIS ETL Packages, integrated .NET Web Services, SQL Server Objects, Share Point Methods, and SSAS Dimensions and Partition Processing.
  • Extensively used Execute SQL Task, Data Flow Task, Script Task, Analysis Services Processing Task, Execute Package Task, For Each Loop Container, and Sequence Container in the control section of SSIS Package.
  • In all SSIS Packages OnPreExecute, OnPostExecute and OnError event handlers used with separate business logic to set the status like start, update, success, or failure for the whole process.
  • In few SSIS Packages used Data Flow Task to refresh the data into data warehouse from staging area. Used transformations such as Flat File Source, OLE DB Source and Aggregate, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Merge Join, Multi Cast, OLE DB Command, Pivot, Row Count, Script Component, Union All and Unpivot transformations and OLE DB Destination in the Data Pipeline section to load the data in the dimension and fact tables.
  • While developing the SSIS Packages, handled the various errors by using the techniques such as setting the break points on required events of the task in the control flow section, the data viewers on the data pipelines in the data flow section.
  • Handled runtime errors by using the techniques like enabling the logging system in the package for the each task of particular events, into the SQL Server table and sending the error description email to the support team.
  • Enabled SSIS Configurations in the packages for the required package variable values and connection strings which can explicitly set these values in the SSIS Configurations table and XML file as per DEV, QA, UAT, PROD servers.
  • Enabled Transactions in the SSIS packages for the tasks which are loading the data into dimensions and fact tables.
  • Used extensively Precedence Constraints and Expression Conditions to control the flow of the next task.
  • Used DTUTIL cmd line deployment utility to deploy the packages into different SSIS servers.
  • Created very complex Stored Procedures and User Defined Functions as per business requirements.
  • Created and stored the Dynamic Queries in a table. These queries are used like Validation Rules to validate the source data and valid data loads into data warehouse tables.
  • Extensively used Temp Tables, Table Variables, Expressions and Exists keyword.
  • Created TRY and CATCH blocks and Transactions in a few stored procedures.
  • Used Common Table Expression with recursive query to retrieve the hierarchical result set.
  • Created Clustered and Non Clustered Indexes on the tables to improve the query performance.
  • Created Test cases and implemented Unit Testing for each developed SSIS package.
  • Maintained all the SSIS packages and related queries in the TFS (Team Foundation Server).
  • Created SSIS Package functionality documentation for the future reference purpose.

Environment: SQL Server 2005, SSIS, SSRS, TFS, SAC, SCM, SSMS, TSQL, MS Excel, CVS, XML, MS Windows Server 2003 /Windows 7 and etc.

Confidential, VA

SQL Server Developer

Responsibilities:

  • Understanding the client business requirements
  • Developed Stored Procedures, Functions, Triggers, Views, and Tables as per business requirement
  • Developed recursive CTE (Common Table Expression) queries.
  • Developed Joins like inner, left, right, cross and self-join as per queries requirement.
  • Migrated data from Oracle 9i Server, CSV and EXCEL to SQL Server 2005 Using ETL tool of SSIS Packages
  • Developed optimized SSIS packages to give efficient performance.
  • Developed SSRS reports like tabular, matrix and dundas speed dial reports from data source SQL Server 2005
  • Developed more than ten administration tools by using ASP.NET 2.0/3.5
  • Used NETIPC component in ASP.NET projects which interacts between the web pages and UNIX environment
  • Strong Data layer created in asp.net web projects to communicates with Oracle 9i Server and SQL Server 2005
  • Created centralized web project to maintain the all administration web tools.
  • Shared knowledge of the developed administration tools to the offshore team.
  • Documented about all tasks describing detail, how it works and what is the business logic involved to accomplish the task.
  • Created and managed database objects such as Tables, Views and Triggers. Maintained Referential Integrity.
  • Modified the existing Stored Procedures for implementing new business logic and enhancing purpose.
  • Created complex Views definition contains many Joins, Where clause with multiple conditions, Group by clause, expressions, Case control flow and sub queries
  • Used DBCC utilities, update statistics for rebuild the indexes, monitored database and disk space, involved in security issues and scheduled tasks.
  • Involved in performance tuning and database optimization. Worked on creating SQL Traces using SQL Profiler Wizard.
  • Performed administrative activities like creating users with appropriate roles, granting and denying users privileges.
  • Performed full, differential and transaction log Backups. Restored them whenever necessary. Created backup strategies and worked on scheduling the backups.
  • Converted all DTS packages into SSIS DTSX packages .
  • Created SSIS DTSX packages to extracted the data from Oracle, Sybase and CSV files and loaded into destination SQL Server 2005.
  • Deployed SSIS packages into MSDB system database and schedule those packages by using SQL Server Agent Jobs .
  • Created tabular and Matrix reports by using SSRS as per business requirements.
  • Documented about all tasks describing detail, how it works and what is the business logic involved to accomplish the task.

Environment: SQL Server 2005, Oracle 9i, SSIS, SSRS, ASP.NET 2.0/3.5, SAC, SCM, SSMS, TSQL, MS Excel, CSV, XML, MS Windows Server 2003 /XP and etc.

Hire Now