We provide IT Staff Augmentation Services!

Dba/sql Server Bi Developer (ssis, Ssas And Ssrs) Resume

St Louis, MO

OBJECTIVE:

Seeking a Entry/Junior - level position where I can apply and grow in creative and technical problem solving skills related to software Engineering/development and work in conjunction with organization’s goal.

SUMMARY:

  • Experienced on IT industry as a SQL Server BI Developer( SSIS,SSAS,SSRS ).
  • Hands on experience with installing, configuring and deploying MS SQL Server suite of products that includes SSIS, SSRS, SSAS for2014, 2012, 2008 R2, 2008.
  • Experience in SQL Server Developer Skills including writing Stored Procedures, User-Defined Functions, Triggers, Views and Indexes.
  • Experience in creating and populating data warehouses OLTP data with various SSIS ETL packages with transformations, containers, variables, configurations and schedules. Debugging knowledge with loggers and event handlers.
  • Extensive experience in Data Migration between homogeneous & heterogeneous systems using various tools (DTS Import Export Data, DTS Packages, Bulk Insert and BCP, SSIS).
  • Extensive Experience in creating Reports of all types in SSRSlike Ad-hoc Reports, Drill-Down Reports, Pivot and Tabular Reports.
  • Hands on experience and knowledge of high availability SQL Server solutions, including replication, log shipping, Database Mirroring.
  • Excellent skills in Database backup, Replication, recovery, restoration, DTS and Linkedservers.
  • Experience in using Teradata tools and utilities like SQL Assistant, Teradata Administrator, Teradata Manager, Teradata Workload Analyzer and BTEQ, Fastload, Multiload, TPump, FastExport, TPT.
  • Designed, developed, tested and supported Extract, Transform and Load (ETL) processes necessary to load and validate datawarehouse using UNIX shell scripting.
  • Worked on features of oracle for PL/SQL programming like using records, collections, Ref, cursors, Nested tables and Dynamic SQL.
  • Experience in gathering business requirements and translating them into technical specification and creating reports with respect to business requirement.
  • Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
  • Experience in translation business goals and requirements into the realization of planning solutions.

TECHNICAL SKILLS:

Languages Databases: T-SQL, PL/SQL, MDX, C, XML, Shell Scripting Oracle, MS-Access, Teradata, MS SQL Server (2014, 2012, 2008R2, 2008), Oracle 9i/10g (SQL, PL/SQL, Stored Procedures, Triggers)

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports.

Design & Modeling: MS Visio, FACT & Dimensions tables, Physical & logical data modeling and De-normalization techniques, Fact, Physical and logical data modeling.

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, DTS, Business Intelligence Development Studio (BIDS),Crystal Reports, Power Pivot, Microsoft Office, Excel Power Pivot. Excel Data Explorer.

Operating Systems: Windows Vista/XP, NT, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, St.Louis, MO

DBA/SQL SERVER BI Developer (SSIS, SSAS and SSRS)

Responsibilities:

  • Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, and Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
  • Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
  • Worked with various SSIS control flow tasks and datatransformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, script task, etc. as part of ETL.
  • Created OLAP cubes, facts and dimensions for the analysis of sales in different locations and process data from data mart using SSAS.
  • Developed dashboard reports using Reporting - Services, Report Model using Report Builder.
  • Migrated packages from development server to production server using package configuration.
  • Improved Performance of the database by creating clustered and non-clustered indexes and by optimizing the T-SQL statements using SQL profiler.
  • Made use of content negotiation (XML, JSON text/plain) using JAXB, GSON, Jackson, and XStream.
  • Scheduled jobs to call packages and stored procedures, and also create alerts for successful and unsuccessful completion of schedule jobs, performance tune ETL processes.
  • Works with various teams in developing automation of manual activities in accordance with Devops principles.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Experienced in working with agile methodology.

Environment: MS SQL Server (2014, 2012 2008R2, 2008) SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS),Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SVN (source control), MS Visual Studio.NET, Visual Studio 14.0/VB.net, VB Script and Windows 2012 Server.

Confidential, Sacramento, CA

DBA/SQL SERVER BI Developer (SSIS, SSAS and SSRS)

Responsibilities:

  • Created SSIS packages and used Analysis Services processing task to update the cube with current data.
  • Worked with different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task.
  • Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
  • Hands on experience on SSAS tabular model.
  • Worked on Power Pivot to Generate reports and create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and PivotCharts etc.
  • Used DDL and DML for writing triggers, functions, stored procedures and data manipulation.
  • Performed Regular Database Maintenance process, checking the disk Defrag procedures in different environments.
  • Used datasets and ADO.Net to retrieve data from the databases.
  • Implemented backups (hot amp; cold back-ups) along with disaster recovery, exporting / importing databases, monitoring procedures and ongoing support.
  • Optimized the T-SQL query performance with modifications in T-SQL queries, removing unnecessary columns, establishing necessary joins.
  • Leveraged appropriate AWS services
  • Used SQL Analyzer and Profiler for monitoring the SQL statements and procedures.

Environment: MS-SQL Server 2012 / 2008 R2 / 2005, SharePoint, Clustering, VB.Net scripting, SSIS, SSRS, T-SQL, GEM Fusion, Visual Studio 2013, Toad, Cluster, .Net Framework 3.5, 4.0, snapshot, backup/restore, MS Office suite 2003.

Confidential, Nashville, TN

DBA/SQL SERVER BI Developer (SSIS, SSAS and SSRS)

Responsibilities:

  • Interacted with third party vendors and identified different external and internal homogeneous and heterogeneous sources and extracted and integrated data from flat files, Oracle, SQL server sources and loaded to staging area and database/Dartmart tables.
  • Helped in integration of the front end with the SQL Server backend.
  • Wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL queries.
  • Involved in performance tuning of T-SQL queries and Stored Procedures.
  • Used DDL and DML for writing triggers, functions, stored procedures and data manipulation.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.
  • Created data queries and reports using WellView, QlikView, Visual Studio, SQL Server Management Studio, SSRS, and Excel. Created custom queries/reports designed for quality verification and information sharing.
  • Created Joins and Sub-Queries for complex queries involving multiple tables.
  • Performed Regular Database Maintenance process, checking the disk Defrag procedures in different environments.
  • Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
  • Used datasets and ADO.Net to retrieve data from the databases.
  • Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.

Environment: MS SQL Server, MS SQL Server Reporting Services, SQL, MS Excel, MS word, Visual Studio, Manager, Teradata SQL Assistant.

Confidential

SQL DEVELOPER

Responsibilities:

  • Defined and designed the data sourcing and data flows, data quality analysis.
  • Identified the data source and defined them to build the data source views.
  • Creating Stored Procedures in MS SQL Server 2008.
  • Experience in writing complex SQL queries involving multiple tables inner and outer joins, temporary tables, table variables.
  • Strong SQL programming skills and some stored procedure development experience
  • String technical knowledge in Troubleshooting and performance tuning .
  • Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
  • Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.
  • Designing flow of data from daily tables to weekly tables and monthly aggregates in the billing Data marts
  • Identified and modified the KPI’s, measures in co-ordinance with the requirement and created calculate members in cube using MDX queries in Business Intelligence Studio using SSAS.
  • Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Created/ Modified SSRS based reports based on T-SQL and Stored Procedure with Input parameters.
  • Worked with RDBMS objects such as tables, views, indexes, stored procedures, functions, and triggers in MS SQL Server Management Studio (SSMS) to make data transformation services (DTS) effective.
  • Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS 2005 and then created reports using this data using SSRS.
  • Configured and maintained Report Manager and Report Server for SSRS.Environment:MS SQL Server, MS SQL Server Reporting Services, SQL, MS Excel, MS word, Visual Studio 2008.

Hire Now