We provide IT Staff Augmentation Services!

Sr. Sql/ssis/ssas Developer Resume

Seattle, WA

Professional Summary:

  • More than 9+ years of IT experience in the Analysis, Design, Development, Implementing and Testing Client/Server applications using Microsoft SQL Server 2005/2008 and BI Suite.
  • Extensive experience with all phases of Software Development Life Cycle (Analysis, Design, Implementation, Testing, and debugging).
  • Strong experience in SQL Server Database Administration, Management, Upgrading, Migrations and Development in Production\Nonproduction environment and clustered environments.
  • Experience with Installation and Configuration of MS SQL Server 2012/ 2008/2005/2000.
  • xperience in planning and implementation of Microsoft SQL Server Security and Database permissions.Experience with Database Backup, Recovery and Disaster Recovery Procedures.
  • Experience in Relational Database Management Systems and Database Design.
  • Experience in implementing different types of Replication Models such as Transactional, Snapshot and Merge in SQL Server 2012/ 2008/2005/2000 in OLTP environments.
  • Excellent work experience in MS SQL Server development including designing logical/physical databases, DTS packages, Microsoft Reporting Services (SSRS), Integration services (SSIS), and Analysis services (SSAS), performance tuning and Troubleshooting.
  • In-depth knowledge of T-SQL, OLTP, OLAP in designing database and data warehousing.
  • Ø Experience in various Extracting, Transforming and Loading (ETL) tasks using SSIS including tools like BCP utility, DTS and SSIS 2005 / 2008 Packages with appropriate control & data flow elements.
  • Experience in using transformations like Aggregate, Multicast, Data conversion, Merge Join etc.
  • Experience in logical, physical and dimensional data modeling, data mapping and data normalization, well verse in ERWIN.
  • Experience with ad-hoc reporting, regular reporting, parameterized, Custom Reporting, power view reports, power pivots, and graphical reporting using SSRS for daily/weekly/bi-weekly/monthly reports and from SSAS cubes as well.
  • Experience in creating Power Pivot data models to provide the data to Power View dashboards.
  • Created and implemented cubes, transaction to reporting solutions with SQL Server Analysis services.
  • Experience in Microsoft.net technologies using C#, ASP.NET 1.1/2.0/3.0/3.5 , ADO.NET, Language integrated Query (LINQ), WCF, WPF, Windows Forms, Windows Controls, XML, JavaScript, Web Services, Web controls, Web Forms, and Visual Studio.NET2005/2008.
  • Experience with Installation and Configuration of MS SQL Server 2008/2005/2000 and in planning and implementation of MSSQL Server Security and Database permissions.
  • Ø Extensive work experience with Database Backup, Recovery and Disaster Recovery Procedures and in configuring Database High Availability techniques like Database Mirroring, Log Shipping, Clustering and Recovery on SQL Server 2005 and 2008.
  • Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
  • Involved in DBA activities such as backups, restores, replication of data.
  • SQL Server 2005 OLAP database development including KPIs, Data mining, working with slowly changing dimensions (Fixed, Changing and Historical).

Skill set:

C/C++, C#, T-SQL, PL/SQL, SQL Server 2000/2005/2008/2012 , Oracle 9i/10g, MS Management Studio, Business Intelligence Development Studio, Microsoft SharePoint 2013, OLAP, OLTP, Query Analyzer, Data Tuning, DTS, SQL Server Integration Services(SSIS), SQL Server Reporting Services( SSRS), SQL Server Analysis Services (SSAS), MDX, BCP, Import/Export Wizard, Erwin 3.x/4.x/7.x,MS VISIO 2000/2003, ASP.NET, ADO.NET, LINQ, Web Services, WSDL, SOAP,AJAX, .Net framework 3.0/3.5 with Windows Communication Foundation(WCF) / Windows Presentation Foundation (WPF), BizTalk Server 2004/2006, Crystal Reports XI/8.5/8.0 , Business Objects, Visual Studio 2005/2008/2010 , MS Visual Source Safe , MS Performance Point Server, Windows 98/XP/Vista, Unix/Linux , MS Office 2000/2003/2007.

Projects Summary:

Confidential

Sr. SQL/SSIS/SSAS Developer

Responsibilities:

  • Lead responsibilities in scheduling KT sessions with End client, business to implementation partner.
  • Co ordinate with offshore and onsite by providing in-detail analysis and explanation like KT, shadowing and reverse shadowing tasks.
  • Worked extensively on metadata driven database architecture for all environments, error logs, permissions, changes.
  • Designed, modified and maintained dimensions and measures on SSAS cubes, feed from EDW and extracts to BO reports.
  • Designed and Developed SSIS packages for extracting the data from multiple data source and load into the appropriate tables in the database.
  • Expertise in using tasks like Conditional Split, Derived Column, Lookup, Merge Join etc.
  • Optimized Queries and used SQL Profiler to identify the bottle necks in scripts.
  • Designed and developed an automated process in SSIS to load data on a monthly basis.
  • Created reports from cubes and maintained SSAS cubes, MDX queries using SQL server Analysis Services (SSAS) on very large databases (VLDB).
  • Set up the SharePoint server 2013 and configured it to work with SQL server 2012.
  • Integrated SharePoint and Power Pivot by fetching data from SQL server 2012 and deployed them onto SharePoint site.
  • Created dashboards in Share Point using Power View to display the repots, Provided/configured role based securities for reports.
  • Created custom intermediate schema to store data pulled from original data source.
  • Created Stored Procedures and Views which work on the basis of core business model.
  • Optimized existing stored procedures and tuned queries to run faster consuming less resources.
  • Created views, Indexed Views, Power pivot to support internal Reporting requirements and modified the existing reports based on End User Requirements.
  • Handled and supported BO reports and SSRS reports by providing ad-hoc sql queries and analysis on business changes.
  • Created maintenance reports by using various components like Grouping, Sorting, Filters, bookmarks and Navigation.
  • Worked extensively on unit testing, regression testing for each and every deployment and fix.

Confidential

Sr.SQL Server SSIS/SSRS Developer

Responsibilities:

  • Extensively worked on the extraction of data from file load systems, transformed and loaded to the
  • Data warehouse.
  • Designed and floated multiple report models on views (due to security issues) and deployed them on to the production reporting server.
  • Generated various types of daily, weekly, bi-weekly, monthly, ad-hoc, standard, dynamic reports, power view presentation, in customer level, manger level, and vendor level using Microsoft technologies like SQL Server Reporting Services (SSRS) and SAP technologies like Business Objects.
  • Modified the stored procedures to get the new functionality depending on the business requirement.
  • xtensively used various SSIS Objects such as Dataflow Components, Control Flow Elements,
  • Runtime Events and log providers etc.
  • nvolved in extracting the data from flat files in the development server and loading the clean data
  • to QA, UAT, production servers using SSIS
  • Involved in scheduling packages using SQL Server Agent.
  • Wrote SQL joins, sub queries, tracing and performance tuning for sophisticated SSRS and BO reports.
  • Used SQL Profiler for debugging issue, performance tuning whenever necessary.
  • Extensively involved in solving the production issues when dealing the sales force cases.
  • Gave 24/7 production support whenever required.
  • Processed data from flat files excel files, .csv files into proprietary hierarchical data structure system through SSIS packages and custom procedures.
  • Managed, operated and enhanced a data eco-system that allows for data sets (indexes and images) to be updated and managed on a daily basis.
  • Continued to improve ETL automation of processes enhance the import speed accuracy and quality of daily data updates
  • Analyzed data importing processes and design processes/applications to help increase automation, efficiency, flexibility and extensibility.
  • Designed and developed SSIS packages, stored procedures, configuration files, tables, views, functions and implemented best practices to maintain optimal performance.
  • Worked extensively with complex T-SQL queries, created functions, views and stored procedures.
  • Created many tables with the cluster and non-clustered indexes on columns.
  • Day-to-day Technical Support on MS SQL Server 2005 and 2008 Servers Platform for Production, Test and Development Environments.

Environment: Windows 2012/ 2008/2003/2000/ NT4.0, MS-SQL Server 2008/2005/2000 , Visual Studio 2010/2008, Team Foundation Server (TFS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Red gate, DTS, Performance Tuning, trouble shooting, Clustering.

Confidential

Sr.SQL Server SSIS/SSRS Developer / DBA

Responsibilities :

  • Installed and configured SQL Server 2008 and 2008 R2 Enterprise Edition Environment.
  • Installed and Configured Microsoft SQL Server 2008 R2 on different domain servers like dev, QA, UAT and production on Windows operating system.
  • Worked independently on multiple projects with minimal supervision and in agile SCRUM environment.
  • Day-to-day Technical Support on MS SQL Server 2005 and 2008 Servers Platform for Production, Test and Development Environments.
  • Designed, Developed and tested packages to extract, transform and load data using SQL Server integration services (SSIS).
  • Developed advanced ETL import packages using SSIS , T-SQL, and other tools to transform and import raw index data into database tables.
  • Processed data from flat files excel files, .csv files into proprietary hierarchical data structure system through SSIS packages and custom procedures.
  • Manage, operate and enhanced a data eco-system that allows for data sets (indexes and images) to be updated and managed on a daily basis.
  • Continue to improve ETL automation of processes enhance the import speed accuracy and quality of daily data updates
  • Analyze data importing processes and design processes/applications to help increase automation, efficiency, flexibility and extensibility.
  • Worked on various reports like parameterized reports, cascading reports, ad-hoc reports and dynamic reports using SQL Server Reporting Services (SSRS) and Crystal reports on daily/weekly/bi-weekly/monthly basis.
  • Implement code changes, bug fixes and configuration changes (if needed) and other development and administrative activities.
  • Created Snapshot and Transactional replication and performed backup and restore operations as well.
  • Technical support to users for various purposes like Access change, performance issues and storage space
  • Work in cooperation with other teams and business analysts for achievement of efficient database access and for processing applications. This includes activities like designing, adding, eliminating, or maintaining indexes, organizing tables, recommending SQL scripts to application development teams.
  • To ensure all scheduled administrative/business jobs are running/completed for daily/adhoc business cycle on Microsoft SQL Servers in Production, Dev and QA Environment.
  • Running various DBCC commands for administration of database objects and system performance.
  • To ensure all scheduled administrative jobs are running/completed for Microsoft SQL Servers.
  • Involved in working with the system/storage administrators to appropriately spread files across the SAN drives.

Environment: Windows 2008/2003/2000/ NT4.0, MS-SQL Server 2008/2005/2000 , Visual Studio 2010/2008, LINQ, WCF, Team Foundation Server(TFS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MDX queries, Red gate, SQL Profiler, Auto sys, System Monitor/ Performance Monitor, DTS, Performance Tuning, trouble shooting, Clustering.

Confidential

SQL Server SSIS/SSRS/SSAS Developer/DBA

Responsibilities:

  • Responsible to Install, Upgrade, Design, and Implementation of SQL Server 2008/2005/2000. Enterprise database environment for multiple client sites.
  • Set up, oversee, and trouble shoot network architecture, server side configuration, client side configuration, connection, manager, and security.
  • Implemented Database Maintenance Plans, Reports and Monitoring.
  • Resolved database performance issues (IO saturation, disk bottleneck, network bottleneck, etc…), database capacity issues, replication, and other distributed data issues.
  • Create and implement best backup and recovery strategies (Full Backup Model with 4 hours period transaction logs backup).
  • Responsible for creating jobs in SQL Server Agent.
  • Assistance to database developers and web programmers in query writing, query optimization, Performance Tuning on very large volume of databases (VLDB) in terabytes.
  • Evaluate back-up and recovery hardware and software and make recommendations to management to automate and implement on-going improvements.
  • Involved in creation of Windows clustering (active/passive) nodes.
  • Created Snapshot, Merge and Transactional replication and replication Issues.
  • Designed and implemented Disaster Recovery site using Log Shipping.
  • Used Database Mirroring for increasing database availability.
  • Involved in Capacity planning of the database system.
  • reated Test Plans with the help of QA Teams and conducting Unit, Integration and System Testing.
  • Proficient with SQL Server tools, including Enterprise Manager, Management Studio, Query Analyzer, Profiler , SQL Server Agent, DTS and SSIS.
  • Transformed data from various data sources like MS Access, Oracle 9i/10g, DB2 using ODBC connection by creating various ETL packages.
  • Involved in extracting the data using SSIS from OLTP to OLAP.
  • Created complex Tabular and Matrix reports using SSRS.
  • Used ADO.NET components like Data Adapter, Data Reader and Dataset to display data on web pages.

Hardware/Software:

Windows 2003/2000, MS-SQL Server 2008/2005/2000 , SQL Server Integration Services (SSIS), System Monitor/ Performance Monitor, DTS, Performance Tuning, Clustering, C#, ASP.NET, VB Script and Team Foundation Server.

Confidential

SQL Server SSIS/SSRS Developer

Responsibilities:

  • Debugged and deployed reports in SSRS.
  • Used SSRS to create, execute, and deliver tabular, matrix, and charts reports.
  • Created several SSIS packages in Microsoft SQL Server 2005.
  • Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
  • Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases
  • Wrote several complex stored procedures for the ease of application.
  • Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
  • Constructed Cubes based on data volumes mostly adhering to Star Schema.

Hire Now