We provide IT Staff Augmentation Services!

Sql Bi Developer/ssis/ssrs/ssas Resume

Kansas, MO

PROFESSIONAL SUMMARY:

  • Over 6 years of Experience in Database Design, BI - Development of Microsoft SQL Server 2014/2012/2008 R2 various development, test and production environments with various business domains like Financial, Healthcare, Insurance and Manufacturing
  • Experience in Installation, Configuration, Management and Troubleshooting SQL Server.
  • Expertise in Business Intelligence Development Studio (BIDS), which includes SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
  • Proficient in writing and tuning SQL queries and improving the query performance, working on DTS, Data Cleansing and Data Migration.
  • Expertise in creating/modifying Tables, Views, Triggers, Joins, cursors, User Functions, Indexes, user profiles, relational database models, data dictionaries, Stored Procedures and in depth knowledge in query optimization & performance tuning.
  • Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
  • Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
  • Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
  • Used SSIS Import/Export Wizard for performing the ETL operations.
  • Experience in SQL Server Analysis Services (SSAS 2008/2012) OLAP Cubes.
  • Expertise in creating Configurations to make package portable and Event handlers for handling package error.
  • Created SSIS packages to Extract, Transform and load (ETL) data from Excel, Database, XML File and Flat file source by using different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension (SCD), Merge Join and Union
  • Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
  • Proficient in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
  • Expertise in creating and Configuring Data Source & Data Source Views, Dimensions, Cubes, Measures using SQL Server Analysis Services.
  • Expertise in using Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security and has an ability to define and develop Report Structure with data definition, report layout and report definition language.
  • Expert in calculating measures, mathematical formulas and user-defined functions (DAX) in Power pivot reports.
  • Expertise in creating InfoPath solutions and publish into SharePoint form Libraries for sharing information, implementation of Out-of-box workflows designed using SharePoint designer 2013.
  • Experienced in Upgrading and Migrating sites and site collections implementation to SharePoint 2013 environment.
  • Worked with SharePoint designer workflow for updating team work progress on project day to day development.
  • Experienced in organizing and customizing SharePoint Sites, Web Parts, Connectable Web Parts and deployment of Web Parts with SharePoint Server.
  • Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS 20012/2008.
  • Proficient in creating Data Mapping Document for providing source and destination mappings. Deployed reports on report server.
  • Experience in SQL database design, architecture, data modeling using Erwin; Data Warehousing and analysis skills: ETL tools, MDX, OLAP (MOLAP, HOLAP, and ROLAP), dimensional modeling, star schema and snowflake schema.
  • Proficient in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
  • SQL Server OLAP Database Development including KPIs, Data mining, working with changing dimensions.

TECHNICAL SKILLS:

RDBM/Databases: MSSQL Server 2000/ 2005/2008/2012 , Oracle 8i & 9i, Sybase, MS Access 97/2000/2003/2007 , MYSQL.

Programming Languages: T-SQL, PL/SQL, Dynamic SQL, C, DHTML, Shell Scripting, Visual Basic 6.0.

Data Modeling: MS Visio, ERWIN 4.5/4.0, FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-Normalization Techniques, MS- Access.

ETL-Tools: DTS, SQL Server Integration Services (SSIS).

BI Tools: SQL, SQL Server Integration Services (SSIS 2005/2008/2012 ), SQL Server Reporting Services (SSRS 2005/2008/2012 ) SQL Server Analytical Services (SSAS 2005/2008/2012 ), Data Transformation Services (DTS), Visual Studio, BIDS.

Tools: /Database Utilities:: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Visual Studio Team Foundation Server (TFS), ERWIN 7.3/7.2.

Application Packages: MS Office, Microsoft SharePoint Server (MOSS) 2007/2010.

PROFESSIONAL EXPERIENCE:

Confidential, Kansas, MO

SQL BI Developer/SSIS/SSRS/SSAS

Responsibilities:

  • Analyzed the Reports, Tables and ETL process, Various ETL Transformation tools were used for Control Flow and Data Flow tasks.
  • Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
  • Created packages using SSIS Designer for exporting heterogeneous data from OLE DB Source.
  • Configured Server for sending automatic mails to the respective people when a SSIS package fails.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • Designed and developed ETL process with SCD (slowly changing dimensions) with T-SQL, SSIS and VBScript.
  • Extensively worked on Data Flow transformations like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
  • Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
  • Created SSRS reports using Report, Drop-Down, Multi-Valued Parameters and Debugging Parameter Issues in Matrix Reports and Charts.
  • Responsible for building Power BI Dashboards for 3M Digital Marketing team using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
  • Import Data into Power BI using different ETL methods, SQL Azure, Direct Query, Restful API Generator, build relational model with in Power BI to generate Marketing Campaigns metrics related to landing pages, Email Analysis and Visitors. Slice data by Month, Campaigns and Area dimensions.
  • Build Tabular, line charts, Graph charts visuals for Marketing KPI's metrics based on fields brought in and transform using Power Query functions and DAX calculated Measures.
  • Design Percentage, Month over Month and Year over Year measures after importing data into PowerBI desktop using DAX and Power Query functions. Slice measure in Power BI tile using calculated Dimension fields in Power BI.
  • Generated reports that can handle dynamic grouping and dynamic sorting.
  • Created drill down, drill through, sub reports and many more complex reports.
  • Permitted access to the reports based on designation of the viewer like store manager or district manager or associate extra.
  • Experience in using SSRS gateway service calls to and from SSRS reports.
  • Experience in modifying SSRS rdl (XML) which is the primary role of SSRS gateway
  • Involved in creating report models and applying row level security filters for report model.
  • Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.
  • Worked on Key Performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
  • Created reports by retrieving the data from cube using MDX reports
  • 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).
  • Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2012.
  • Used Pivot table to provide structure to Reports in proper manner like months etc.
  • Designed different kinds of reports like Linked, cascaded and parameterized reports.
  • Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
  • Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Power BI.
  • Deployment of the developed reports on to the server for the end users.
  • Deployed the developed reports and upgraded the system.
  • Responsible for creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports, Linked Reports, and Reports using stored procedures using SQL Server Reporting Services 2012.
  • Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau.
  • Developed dashboard reports on the Tableau Server so that the end users having access to the server can view the data.
  • Used SQL Server Agent for scheduling jobs and alerts.
  • Written several SQL Scripts such as finding tables with Identity Columns, tables that do not have primary key to streamline the process of replication.

Environment: s: Windows server, MS SQL Server 2016/2012,vTeam Foundation Server (TFS), SQL Server Integration Services (SSIS), SSRS.

Confidential, Allendale, NJ

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

  • Worked with Client/Business Analysts to define data requirements for reporting warehouse.
  • Designing and developing SQL Server 2012 Databases, Tables, Indexes, Stored procedures, Views, Triggers.
  • Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
  • Written complex SQL statements using joins, sub queries and correlated sub queries.
  • Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and un-pivot Control Flow Transformations.
  • Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
  • Created Reports and Dashboards in SSRS, MS Focus, Power Pivot, Power BI and other BI tools for Sales and Services Division of Microsoft.
  • Created Power BI Visualizations and Dashboards as per the requirements.
  • Installed On premise data gateway and scheduled daily data refresh in Power BI.
  • Worked with Power BI mobile app and created mobile layouts to view reports and dashboards effectively.
  • Built Reports in Power BI from the scratch.
  • Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
  • Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and client systems.
  • Designed and developed ETL process with SCD (slowly changing dimensions) with T-SQL, SSIS and VBScript.
  • Loaded data from heterogeneous sources to databases using various tasks and transformations using SSIS.
  • Migrated the data from an Access database to SQL Server 2012.
  • Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.
  • Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
  • Designed best practices document for ETL and Reporting Systems using Data Warehouse concepts.
  • Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
  • Design, deploy and maintain various SSRS Reports in SQL Server 2012.
  • Designed and implemented Parameterized and cascading parameterized reports using SSRS.
  • Involved in the preparation of detail Unit Cost, Price and Volume Trends, Expense Variances and Profitability Reports using SSRS.
  • Created Add-ins, macros, templates, customized Ribbons and write VBA code for all suite applications, especially MS Access, PowerPoint and Excel 2013.
  • Developed the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • Developed many MDX queries for creating measures that fits business logic
  • Used ProClarity for accessing and analyzing cubes and dimensions and worked on integration of SharePoint with SSRS.
  • Worked on Key Performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
  • Created tabular model in SSAS and developed data model in power pivot for excel by using the existing Report.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations using MDX.
  • Created custom calculation in power pivot by using DAX formula
  • 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).
  • Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2008.
  • Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
  • Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2012/2008, Visual Studio 2008, Oracle, Power BI MS SQL Server Management Studio, SSIS, SSRS, SSAS, MS Excel, Teradata, Power Pivot.

Confidential, White Plains, NY

SQL Server SSIS Developer

Responsibilities:

  • Worked on Data Transformation Activities using SSIS Import/ Export for transferring data between Oracles to SQL Server.
  • Moving data to staging tables using SSIS.
  • Wrote T-SQL code for creating cursor and handling the data validations.
  • Writing complex stored procedures and User defined functions and enforced business rules via Checks and Constraints.
  • Created joins and sub-queries for complex queries involving multiple tables.
  • Used DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Created tables, views, clustered & non-clustered indexes, user defined data types, user defined functions and CTE's.
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Migrated packages to SSIS and modified the packages accordingly using the advanced features of Integration Service.
  • Configured Server for sending automatic mails to the respective people when a SSIS package fails.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • Handling the orphan rows in Dimension and Fact tables.
  • Develop the Documents for Logging/Error Handling for SSIS Packages.
  • Involve in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
  • Participated in daily standup, scrum sessions, team retrospective sessions. Participated in a small, experienced, energetic team on a rapid, agile development schedule.
  • Extensively worked with Team Foundation Server (TFS) 2012.

Environment: MS SQL Server 2012/2008R2, T-SQL, SQL Profiler, Rapid SQL (2016), Visual Studio (2012), Team Foundation Server (2012)

Confidential

SQL Server /BI Developer

Responsibilities:

  • Integrate the SSIS package, converting all existing packages to SQL Server 2008 by adding extra SSIS task.
  • Written stored procedures to populate final database tables from staging tables and clean inaccurate data
  • Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and Materialized views for remote instances.
  • Created and maintained versions of SQL Scripts for Tables, Indexes, Constraints, and Views etc. for the entire project.
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems
  • Providing solutions to improve the existing processes and production support for various batch processes and Created the schedule for newly incorporated batch programs and processes.
  • Wrote DDL, DML scripts for Schema, Table space and Cluster creation and alteration.
  • Worked with the Program Architect and Technical Architect in design sessions to develop high-level solutions Architecture for SQL Server Reporting Services solution.
  • Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
  • Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS.
  • Designed different kinds of reports like Linked, cascaded and parameterized reports and Worked on Drill Down and Drill-through Reports.
  • Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
  • Performed data transfers using BCP and BULK INSERT utilities.
  • Wrote stored procedures for report generation in SQL Server 2008/2012.
  • Performed performance tuning by studying Execution Plan, Analyzing Indexes.
  • Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
  • Experienced in developing stored procedure driven reports, building custom application on reports, formula
  • Writing/editing in reports, Report Administration and performance tuning of reports.
  • Generated different types of Reports (Tabular/Matrix) using MS SQL Server Reporting Service (SSRS).
  • Created Technical Documentation for reports and maintenance/enhancements of existing Reports.
  • Actively participated in User Acceptance Testing and Debugging of the system.

Environment: Windows server XP/NT2008/20012, SQL SERVER 2008/2012, Microsoft Reporting Services, Toad, T-SQL, Oracle 10g, Visual Source save (VSS), WIN NT, Erwin and SQL Server Integration Services.

Confidential

SQL Server SSIS Developer

Responsibilities:

  • Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses Column Mapping, Data dictionary and Metadata.
  • Created SSIS Packages for Incremental Loading and slowly changing dimensions.
  • Created and formatted the report layout for end users.
  • Deployment of the developed reports on to the server for the end users.
  • Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
  • Generated Daily, Weekly and monthly reports for the analysis of managers and end users.
  • Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.
  • Designed and created views for security purposes, implemented rules, defaults, data types.
  • Designed and implemented data access stored procedures and triggers for automating tasks.
  • Worked on all types of report types like tables, matrix, charts, sub reports etc.
  • Created Linked reports, Ad-hoc reports etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
  • Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
  • Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
  • Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, (SSRS) 2005/2008
  • Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).

Environment: MS SQL Server 2008, MS SQL Server Reporting service 2008, MS SSIS, T-SQL, Windows

Hire Now