We provide IT Staff Augmentation Services!

Sql Server Bi Developer (ssis) Resume

3.00 Rating

Richmond, VA

SUMMARY

  • Around 8 years of experience in MS SQL Server 2016/2014/2012/2008/2005/2000 and worked extensively on Integration services (SSIS), Reporting services (SSRS) and Analysis services (SSAS).
  • Created Management Reports through SQL Server Reporting Service on demand.
  • Used Query Analyzer, Execution Plan to optimize SQL Queries.
  • Expert in creating objects like Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
  • Extensive knowledge in T - SQL queries (DDL and DML).
  • Expertise in Extract, Transform and Load (ETL) using SSIS and various tools including Bulk insert, BCP, Import Export data, DTS packages and SQL Server Integration Analyzed, designed and developed for a Data Warehousing and Data Migrations.
  • Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
  • Deploy packages to file system and schedule the jobs using SQL Server Agent.
  • Good experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server Clustering.
  • Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
  • Migrated Organization, Orders, Adjustments, Objectives and data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
  • Experience in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
  • Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.
  • Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
  • Experience in creating ETL mappings in Informatica to load data from different sources to different target databases.
  • Creating the Cubes and Dimensions building, deploying, processing and maintaining Cubes using SQL Server Analysis Services (SSAS).
  • Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for developing Cubes using MDX in SSAS.
  • Development Projects in SQL Server 2000/2005/2008 and Microsoft.Net.
  • Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional Tables and Operational Data Store (ODS).
  • Excellent Communication and interpersonal skills and strong ability and experience in seeking solutions effectively and aggressively in challenging environments.

TECHNICAL SKILLS

ETL Tools: SSIS (SQL server Integration services), Export & Import (DTS) and Data Stage

Reporting Tools: SSRS (SQL server reporting services),Crystal Reports, Report Builder, SSAS (SQL server Analysis services)

RDBMS: MS SQL SERVER 2008/2005, MS ACCESS, MS EXCEL.

Languages: SQL, T-SQL, PL/SQL, VB.Net.

Software: SQL Toad, Visio

Databases: SQL server 2008/2008 R2/2005/2000, Oracle 9i/10g, MS Access

Operating Systems: Windows2000/XP/2003/2008, MS DOS

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

SQL Server BI Developer (SSIS)

Responsibilities:

  • Involved in Planning, Defining and Designing data, based on business requirements and provided documentation.
  • Hands on experience with EDI Files 834,835,837.
  • Upgraded MS SQL Server 2005 database to MS SQL Server 2012/2014, by using Detach/Attach, Back up & Recovery.
  • Designed Data Mapping documents, DDL scripts, Data Dictionary and meta data of the models and maintained them.
  • Developed SQL scripts, indexes, complex queries for data analysis and extraction.
  • Used .NET provider Data Reader Source Task to Read from RDBMS sources.
  • Worked in ASP.NET Web forms, State management and Caching feature.
  • Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
  • Involved in migration from MS Web Toolkit for WebServices in VBA to VSTO
  • Designed SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle 11g, flat file, Text file, Teradata) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
  • Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
  • Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
  • Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
  • Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule SSIS Packages.
  • Involved in developing database objects such as procedures, triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures.
  • Developed SSIS packages for File Transfer from one location to the other using FTP task
  • Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
  • Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
  • Generated ad-hoc reports using MS Reporting services and Crystal reports.
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS. Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.
  • Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
  • Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications.
  • Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
  • Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
  • Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients, and managers
  • Performed Documentation for all kinds of reports, DTS and SSIS packages.
  • Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T-SQL.
  • Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
  • Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
  • Created Linked Servers for data retrieval using OLE DB data sources and providers.
  • Design and implementation of stored procedures and triggers for automating tasks.
  • Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
  • Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
  • Created Views to reduce database complexities for the end users.
  • Created Provided assistance to development teams on Tuning Data, Indexes and Queries.
  • Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
  • Created Functions, Stored Procedures, Database Triggers
  • Created checks and constraints to maintain data integrity.
  • Involved in De-Normalization of existing tables for faster query retrieval.
  • Involved in development, enhancement, testing and performance tuning of the application.
  • Developed Multi dimensional Objects (Cubes, Dimensions) using MS Analysis services (SSAS).
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Identified Key Performance Indicators (KPI) and Metrics for Business needs in SSAS
  • Created Production Deployment Scripts for SSAS Cube & Roles
  • Developing OLAP cubes by identifying tables (fact and dimension), data source and data source views attributes and dimension members using SQL Server Analysis Services (SSAS).Created SSAS storage and partitions, and Aggregations, calculation of queries with MDX.
  • Developed many MDX queries for creating measures that fits business logic
  • Developed a dashboard solution for analyzing STD statistics by building SSAS 2008 cubes and Tableau
  • Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: MS SQL Server 2008, SSIS, SSRS, SSAS, T-SQL, DTS, C#.net, XML, Windows 2003 Server, IIS5.0, 6.0, 7.0.

Confidential, Montgomery, AL

SQL Server BI Developer

Responsibilities:

  • Conducted Data Migration processes in the SQL Server environment using SQL Server Integration Services 2005.
  • Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
  • Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, and data integrity.
  • Used different transformations like Conditional Split, Lookup, Merge Join, Aggregate, Fuzzy Grouping etc. for creating many SSIS packages.
  • Created many Variables that were used to pass parameterized values into the package which makes the package Dynamic.
  • Designed many Configuration files that were used to pass parameters from outside the Business Intelligence Development Studio (BIDS) into the packages using XML files.
  • Designed Incremental Load Packages which were used to load the updated and new data into the Enterprise Data Warehouse without removing the existing data.
  • Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions Worked with different methods of logging in SSIS.
  • Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
  • Worked on Event Handlers to do Event handling on error at the package and task level on error, on warning and configured it using send email task and script task.
  • Created packages in SSIS with error handling.
  • Involved in performance tuning and monitoring of T-SQL blocks.
  • Migrated all the packages to Test Environment and finally deployed from Test Environment.
  • Designed reports using SQL Server Reporting Services (SSRS).
  • Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2005
  • Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and deployed SSRS reports.
  • Developed Multi dimensional Objects (Cubes, Dimensions) using MS Analysis services (SSAS).
  • Developed and Modified existing Unix Shell Scripts.

Environment: SQL Server 2008, DTS, VSS, Informatica, VBScript, XHTML, XML, Windows 2003 Server, IIS5.0, 6.0, 7.0.

Confidential, Atlanta, GA

SQL Server BI Developer (SSIS, SSRS)

Responsibilities:

  • Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008
  • Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
  • Wrote T-SQL queries and T-SQL stored procedures in SQL SERVER 2000.
  • Created SSIS packages to clean and load data to data warehouse.
  • Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
  • Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
  • Configured complex SQL queries to meet customer requirements as needed.
  • Worked on Complex SSRS Reports, Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Reports Design.
  • Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications.
  • Experienced in creating SSAS OLAP Cubes and Partitioning Cubes.
  • Experienced in using Dimension Usage, Aggregations, Calculation and Perspective on a Cube.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Experience in SQL joins, sub queries, tracing, usage of Table Variables, Temp tables etc.
  • Involved in optimization of queries, improving the performance by using various approaches from execution plans, Index optimization, and DMV’s.
  • Carry out creation of SDLC documentation for existing applications
  • Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.
  • Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
  • Created checks and constraints to maintain data integrity and created Complex Stored Procedures.

Environment: MS SQL Server 2005, MS SQL Server Management Studio, SSIS-2005, SSRS-2005, Report Builder, SSIS-2005, Office, Excel.

Confidential, Boston, MA

SQL BI Data warehouse Consultant (SSAS, SSRS)

Responsibilities:

  • Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design,
  • Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
  • Developed Cubes using SQL Analysis Services (SSAS).
  • Involved in creating Named calculations and named queries.
  • Created Dimensions with the cube wizard and also individually.
  • Created SSIS packages and used Analysis Services processing task to update the cube with current data.
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems
  • Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
  • Created SSIS packages to load data intoSql Server using various transformations in SSIS.
  • Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of data warehouse.
  • Identified the dimension, fact tables and designed the data warehouse using star schema.
  • Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
  • Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
  • DefinedCalculated members,named sets, and executed other script commandsusingMDXexpressions. Deployedand processedOLAP Cubes.
  • Developed Aggregations, partitions and calculated members for cube as per business requirements.
  • Defined appropriate measure groups and KPIs & deployed cubes.
  • Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS and designed reports using Crystal Reports.
  • Created report snapshots to improve the performance of SSRS.
  • Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2005 database and performed tuning on it.
  • Migrated database from SQL server 2000 to SQL server 2005 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures.
  • Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
  • Transform the data from the staging database and perform the transformation using the Data Flow Tasks
  • Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
  • Experience in Developing and Extending OLAP Cubes, Dimensions and data source view
  • Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
  • Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
  • Build database queries and test cases for the testing team to test the reports
  • Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: MS SQL Server 2005/2008, SSRS, SSIS, .NET Framework, C#, ASP.NET, Windows 2000/2003 Advance Server, HTML, XML, MS Excel, MS Access Reports

Confidential, New York, NY

Responsibilities:

  • Involved in developing database objects such as procedures, triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures.
  • Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes, etc.).
  • Managed Database files, transaction log and estimated space requirements.
  • Monitored database application.
  • Responsible for developing automation of maintenance jobs, tuning SQL Server locks and indexes configurations, administering SQL Server security.
  • Experience in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
  • Designed and implemented several complex reports and administration modules.
  • Designed stored procedures for module integrity and application.
  • Involved in installation, upgrade and configuration of Microsoft SQL Server and databases.
  • Involved in Microsoft SQL Server Database Administration including planning, backup, and recovery strategies.
  • Implemented High availability concepts, Data base Mirroring, Replication and log shipping.
  • Involved in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities.
  • Involved implementing Disaster Recovery for minimal downtime using different types of database backups, restore, and replication.
  • Involved in the entire System study, analysis and Design.
  • Installation, configuration of MS SQL Server 2000 for development and testing purpose
  • Involved in developing database objects such as triggers, constraints, indexes and views.
  • Used T-SQL to build dynamic stored procedures.
  • Managed Database files, transaction log and estimated space requirements.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Developed SQL Queries to fetch complex data from different tables in remote databases. using joins, database links and formatted the results into reports and kept logs.
  • Responsible for developing automation of maintenance jobs, tuning SQL Server locks and indexes configurations, administering SQL Server security.
  • Designed and implemented several complex reports and administration modules.
  • Created DTS package to schedule the jobs for batch processing.
  • Involved in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities.
  • Involved implementing Disaster Recovery for minimal downtime using different types of database backups, restore, and replication.

Environment: MS SQL Server 2005, MS Access 2000, Business Intelligence Development Studio 2005, SSIS, MS Excel, Windows Server 2003/2008.

We'd love your feedback!