Ssis Sql Server Developer resume example with 13+ years of experience
Jessica
Claire
resumesample@example.com
(555) 432-1000,
Montgomery Street, San Francisco, CA94105
:
Professional Summary
V K Over 9 years of extensive work experience as a SQL Server Developer and in depth proficient experience in Microsoft Business Intelligence stack, OLTP, Operational Data Source (ODS), Tabular & Multidimensional Modeling, Performance Tuning, Data warehouse, OLAP and Database technologies. Demonstrated expertise in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS and SSAS in BIDS. Experience in installation, upgrade and configuration of Microsoft SQL Server databases. Over 5 years of extensive experience in T-SQL Programming in developing Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) XML and Complex Queries on SQL Server 2005/2008/2012/2014. Broad experience in Query Optimization and performance tuning of TSQL stored procedures, functions, SSIS packages, SSRS Reports etc. Over 3 year's Strong experience in SSRS development skills, experience including tablix, Matrix, chart, graphic scorecard reports, Performance Summary Dashboards, sub-reports. Experience in creating Adhoc reporting ready universes using Business Objects Universe Designer. Have good understanding of Tableau architecture, development and end user experience. Application Clusters specializing in tuning & monitoring of high availability in Oracle & SQL Server. Over 4 year's experience in utilizing ETL tools, including SSIS, DTS and ETL Package design. Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages through scheduler such as Autosys and SQL Server Agent. Over 3 year's experience in SSAS (SQL Server Analysis Services) 2005/2008/2012/2014. Have good experience with designing and implementing MDX queries, OLAP architecture, MOLAP, ROLAP and HOLAP. Experience in development of coding in VB.NET, C# while working with SSIS. Interaction with the Users and Business Analysts for better understanding of business & reporting requirements.
Education
JNTUINDIA, Expected in ā āBachelor of Science:computer science - GPA:
MS SQL Server2014, 2012, 2008R2, 2008, 2005, Oracle, SAP, Siebel, Microsoft Office 2007/2003, MS-Access.
Language
C, C++ ,XML,TSQL,VB.NET,C#,MDX,DAX
Operating System
Windows XP/NT/2000/2003/2008, DOS
Tools & Applications
Erwin Data Modeler, MS Visio, Business Objects XI 3.1/3.0, Cognos, Crystal Reports 10,Microsoft office 2003/2007, Tableau Server 8.2,Power Pivot 2010, SharePoint 2010, Excel Services 2010,LANDesk
TransAmerica - SSIS/SQL SERVER Developer City, STATE, 2015 - Current
TransAmerica is a multinational life insurance, pensions and asset Management Company.
Transamerica's businesses focus on life insurance and pensions, savings and asset management products.
The group is also active in accident and supplemental health insurance and general insurance, and has limited banking activities.
Transamerica has major operations in the United States Responsibilities: Working on the Data migration project called ECB (Environmental Control Board) to migrate the ticket finder data from ADABASE, DB2, and MS ACCESS to SQL Server.
Assisted with Database design, extensive data analysis of all 3 source systems & implemented the ETL architecture to support the migration.
Created ETL Extraction Strategy architecture as part of Development plan to extract & load data from source systems to staging and to ECB Destination servers.
Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into target tables.
Worked extensively on complete data mapping of all source systems as part of data analysis.
Extensively used SSIS transformations such as Script component, Pivot/Unpivot, Multicast, Derived column, Data conversion, Row count and Send Mail task etc.
Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with VB.NET in SSIS.
Improved the Performance of Packages by configuring the Component Properties like MaxConcurrentExecutables, Default Buffer Size, Engine threads & Delay Validation etc.
Worked on the data archival process by transferring data crossing different platforms, validating data during transferring, and archived data files for different DBMS by creating dynamic SSIS packages.
Worked with the application developers and provide necessary SQL Scripts using T-SQL.
Involved in the Production support for TLC application & generated the reports based on Case counts, Hearing decisions etc as per Users requirements.
Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
Interfaced with business analysts, developers and technical support to determine the best requirement specifications.
Siemens HealthCare - SSIS/SSRS Lead Developer City, STATE, 2014 - 10/2014
Siemens Healthcare provides sustainable healthcare technology - solutions engineered to improve patient outcomes while reducing costs - across a complete portfolio of imaging and therapy systems, laboratory diagnostics, and healthcare IT.
Responsibilities
Stored, retrieved and manipulated data for close analysis of system capabilities.
PriceWaterHouse Coopers - SQL Server/BI Technical Lead Developer City, STATE, 2013 - 11/2013
PwC focuses on audit and assurance, tax and consulting services.
Additionally, in the US, PwC concentrates on 16 key industries and provides targeted services that include - but are not limited to - human resources, deals, forensics, and consulting services.
They help resolve complex issues and identify opportunities.
Responsibilities
Interfaced with business analysts, developers and technical support to determine the best requirement specifications.
Frontier Communications - SQL Server Developer /SSIS Developer City, STATE, 06/2010 - 11/2012
Worked on different types of Source systems like SAP, Clarity, Siebel, eFrontOffice and matched with the measures of EDW and stored it in SQL Server Database Using SSIS.
Prepared technical documentation for every stored procedure and updated those stored procedures with new data elements.
Designed & Developed Type 2 Slowly Changing Dimensions inorder to maintain the historical changes for the business purposes.
Worked on the Existing (legacy) SSIS packages and modified the same packages to match it for different sources for integration.
Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
Used 3rd party tools like Upsert task and modified & replaced the complex legacy system package structure with newer elements.
Used OnPostExecute and On Error event handlers to update the each task logging in SSIS log table.
Used Script task component and established iterative load for faster retrieval & to improve performance.
Used different transformations like lookup, condition split, and row count Transformation, Derived Column, Data Conversion etc.
Created Stored Procedures for package Initialization and end package information to update the package log table.
Created Package Configuration file with connection information source, staging and destination databases and send mail task connection information and log directory path value.
VERIZON - SQL Server Developer/SSIS/SSRS City, STATE, 2007 - 05/2010
Verizon built and operates the nation's most reliable wireless network.
Verizon has the largest number of retail customers in the industry and is the most profitable wireless company in the U.S.
The company is a joint venture of Verizon Communications and Vodafone.
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.