We provide IT Staff Augmentation Services!

Sql/bi (ssis/ssrs/ssas) Developer Resume

0/5 (Submit Your Rating)

CA

SUMMARY

  • A competent software professional with 8+ years of experience in the field of Database Solutions and Business Intelligence Solutions using Microsoft Technologies in SQL SERVER 2008R 2/2012/2014/2016.
  • Nearly6 Yearsof experience in Microsoft BI stack (SSIS/SSRS/SSAS).
  • Experienced in Data modeling, Design, Development, Support of Database systems using Microsoft SQL .. for OLTP as well as OLAP Systems.
  • Experienced in Extracting, Transforming and Loading (ETL) from heterogenous Data sources like Oracle, Flat file, Raw file, XML, Excel and OLE DB to Flat file, XML, Excel, OLE DB Destinations using various Connection managers.
  • Performed Various SSIS control flow tasks and Data transformation tasks like Data conversion, Derived column, Script task, Look - up, Merge, Bulk Insert, Fuzzy Look-up.
  • Worked with configuring Check points, Data viewers, Break points, providing logging, Debugging and Error handling for the SSIS packages created.
  • Created SQL Server jobs to automate the execution of SSIS packages at desired time according to business needs.
  • Experience in creating SSRS reports using SQL Queries and Stored procedures which has Sub-reports, Drill-Down and Drill Through reports and Charts.
  • Experience in creating various reports like Dynamic, Linked, Parameterized, Matrix and Gauge and Dashboard using SSRS based on OLTP and OLAP Databases.
  • Experience in creating different types of reports using Reporting Services and Report Builder.
  • Created Subscriptions and Data driven subscription reports and performing Performance Tuning.
  • Knowledge in writing Parameterized queries for various types of reports using Expressions, Variables and Functions.
  • Experience in deployment of created reports in various sources like Web Services URL.
  • Designed and developed Tabular and Dashboard reports using Power BI features and enhanced based on user requirements.
  • Extensive experience in creating SQL Server Analysis Services (SSAS) Cubes, calculating measures, measure groups and dimensions using multi-dimensional expressions(MDX).
  • Design and Developed Star Flake and Snow Flake Schemas.
  • Created Relationships, Calculations, KPI’s, Actions, Partitions, Aggregations, Perspectives, Hierarchies and Translations.
  • Experienced creating Databases and Database Objects like Tables, Stored Procedure, Stored Functions, Triggers, Views, Indexes, Cursors and Common Table Expressions (CTEs) using Transact SQL in SQL Server Management Studio(SSMS).
  • Experience inwriting complex T-SQL queries, Sub-queries, Co-related sub-queries and joins.
  • Hands on Experience in Query Optimization and Performance Tuning using SQL Profiler and Database tuning wizard.
  • Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by creating Primary and Foreign keys.
  • Exposure and knowledge of designing logical and physical data model in Relational Database Management System (RDBMS).
  • Good knowledge in database modelling (ERD) using TOAD Data Modelling tool.
  • Basic Knowledge in Programming with ‘R’ and knowledge of MongoDb.
  • Strong Communication, Interpersonal and Problem-Solving skills.

TECHNICAL SKILLS

Tools: MS SQL Server Integration Services(SSIS), Analysis Services(SSAS),reporting services (SSRS)

Development tools: SQL*PLUS, Sql Assistant, TOAD, MS Analysis

Development Skills: T-SQL, DAX, MDX

BI Reporting Tools: Power BI, Reporting Services(SSRS).

Operating Systems: MS DOS, MS Windows

Software: MS Works, MS Office, Lotus Notes, MS Outlook, SharePoint

Relational Databases: Oracle 9i and 10g, MS Access 97, MS SQL Server 2005/2008/2012/2014/2016.

Methodologies: RUP, Relational database Methodologies, SOA (service-oriented architecture), Rapid Application Development,Agile Methodology

PROFESSIONAL EXPERIENCE

Confidential, Rolling Meadows - IL

MS BI Developer

Responsibilities:

  • Creation, Development and Maintenance of SSIS packages and SSRS reports.
  • Designed and Managed ETL codes using SSIS and SQL server fetching data from various source systems into specified Data Warehouse.
  • Design and implement ETL processes using SSIS which involves in collection of data from sources like SQL Server 2008R 2/2012/2014/2016.
  • Develop SSIS, SSRS, T-SQL code and schedule jobs for monitoring automation,
  • Created ETL packages using different data sources like SQL server, Oracle Database, Excel and Flat File.
  • Loaded data into destination by performing various transformations like Look-up, Merge, Look-up, Derived column and Script task using SSIS packages.
  • Deployed and Administered the SSIS packages with BI development studio.
  • Configured Checkpoints, package logging, error logging and event handling to redirect the error rows and fix these in SSIS.
  • Created SSIS packages for File Transfer from one location to another using FTP task.
  • Automates execution process, scheduling and deployment of packages using SQL server agents by creating jobs and error reports using SQL Mail Agent, Alerts and FTP.
  • Created and deployed parameterized reports using SSRS and created hierarchies in SSRS reports.
  • Creating reports with features like Charts, Filters, Sub-reports, Drill down, Drill through and Dashboards.
  • Designed and created Report templates, Bar graphs and Pie charts based on the data using SSRS.
  • Created, Maintained and Schedules various reports in Power BI like Tabular reports.
  • Explore data in variety of ways and across multiple visualizations using Power BI.
  • Designed, Developed and Published Power BI reports, Power BI Dashboard.
  • Created effective reports using visualizations such as Bar chart, Clustered Column chart, Waterfall chart, Gauge, Pie chart in Power BI.
  • Troubleshooting report issues, ETL job failures and optimizing query performances.
  • Loaded Fact and Dimension tables as part of modified data warehouse solutions.
  • Processed SSAS cubes to store data into OLAP databases.
  • Written Multidimensional queries (MDX) for the analysis of cube data.
  • Extensive knowledge in creating Relationships, Measures, partitions, Calculations using DAX and KPIs in SSAS Tabular model.
  • Design Perspectives and Hierarchies in SSAS Tabular model.
  • Extensively used joins and Sub-queries to simplify complex queries involving multiple tables.
  • Responsible for debug, performance checks and performed index tuning and query optimization.
  • Worked closely with business customers, end users and resolved related business issues.

Environment: Microsoft SQL server 2016/2014/2008 R2/2008, Visual Studio 2013, Oracle, SSIS/SSRS/SSAS, SSMS, Power BI, SQL server agent, MS Office.

Confidential - CA

SQL/BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

  • Migrated data from various data sources (DB2, Oracle, Access, Excel) to the centralized SQL server databases using SSIS.
  • Created SSIS packaged to validate, Extract, Transform and Load data to a centralized SQL server using OLE DB providers from existing data sources.
  • Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in BI studies using SSIS.
  • Debugged SSIS packages using Data Viewers, Breakpoints.
  • Used various Transforms like Pivot, Un-pivot, Copy column, Merge, Merge join, Look up etc.
  • Created SSIS packages using Execute SQL task, File system task, Execute package task, Send mail task, Execute Process task, Sequence Container and Foreach Loop Container.
  • Used C# Scripts to write MessageBox in the custom logging feature in SSIS package
  • Developed and Designed Dashboards using SSRS.
  • Generated reports like Tabular reports, Sub reports, Matrix reports, Drill down reports and Charts using SSRS.
  • Generated Weekly, Monthly, Quarterly and Annual reports as per requirements and assigned roles, user access with respect to security in report manager.
  • Created OLAP cubes, Facts and Dimensions for the analysis of sales in different locations and process data from data mart using SSAS.
  • Written Multidimensional Expression (MDX) queries for manipulating and calculating the data stored in the OLAP cubes.
  • Involved in building in Dimensions, Cubes with Star schema and Snow Flake schema using SSAS.
  • Worked with RDBMS concepts for creating database objects like Tables, Functions, Stored procedures, Indexes and Views.
  • Involved in performance tuning of SQL queries.

Environment: MS SQL server 2014/2012, MS SQL server management studio (SSMS), MS SQL SSIS/SSRS/SSAS, MS Visual Studio 2010, MS Excel, C# scripts and T-SQL.

Confidential, Hermitage - PA

SQL Server / BI Developer

Responsibilities:

  • Worked with the banking projects and business analysts for requirement gathering, designing the database and creating workflow for reports.
  • Responsible for creating database objects like Indexes, Tables, Views, Stored procedures and Functions using Transact SQL to provide structure to store the data and maintain the database efficiently.
  • Being the part of Database designing team, to identify integrity constraints for data integrity like referential integrity using primary and foreign key relationships.
  • Designed the staging database in order to extract and load the data from various data sources.
  • Developed Execution handling process and audit process for each ETL package.
  • Created different types of reports like Parameterized, Linked, Drilldown, Drill through, Customized and dashboards using SSRS tool.
  • Scheduled jobs using SQL agent to execute SSIS packages.
  • Developed SQL code such as writing complex queries, Stored procedures etc.

Environment: SQL server 2014/2012. SSIS, SSRS, Visual Studio 2015, Windows Server 2008R2, C#.Net.

Confidential, Northbrook -IL

MSBI Developer

Responsibilities:

  • Working with various requirements for clients (SSRS, SSIS, T-SQL, VBScript)
  • Designing of SSRS reports and deploying these reports in reporting server and internal reporting system.
  • Using SSRS web based reports for health-related applications and transactions.
  • Created number of Drill through, Drill down, Parameterized and Sub-reports reports using SSRS.
  • Deployed and configured the reports in the Report Server.
  • Created packages using Import/Export wizard. Designed packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL tool.
  • Created ETL packages for transforming the excel files into the database using various transformation using transformation in SSIS.
  • Created SSIS packages and used to load data from different sources like Excel, Flat Files and SQL Server to the Data Warehouse.
  • Performed Logging operation, Error handling by using Event Handler and Custom Logging for SSIS Packages.
  • Wrote queries using Multidimensional Expression (MDX) queries.
  • Experienced in designing the OLPA systems for data mart application using SQL Server Analysis services.
  • Writing Stored procedures, Triggers and Views according to the business requirements.
  • Performing the Query performance tuning.
  • Working in the tracking of the issues based on the priority in accordance with internal ticketing system.
  • Ensuring the quality of deliverables and schedule adherence and performing end to end testing.

Environment: MS SQL server 2008R2, MS SQL server management studio (SSMS), MS SQL SSIS/SSRS/SSAS, MS Visual Studio 2010, MS Excel, C# .Net, ASP.Net and T-SQL.

Confidential - Mequon, WI

SQL Server Database Developer

Responsibilities:

  • Involved in upgrading, installing and configuring the databases and SQL servers 2008 and 2008R2.
  • Created technical design specification documents based on the functional design and physical data model.
  • Developed databases and their objects like, tables, Stored procedures, Functions, Triggers, Views and Indexes.
  • Optimized Stored procedures and long running queries using indexing strategies and query optimization techniques.
  • Defined Data manipulation language (DML) and Data Definition Language (DDL).
  • Created Triggers on tables enforcing data validation for better quality.
  • Query Optimization and Performance tuning.
  • Performed backup and restore of database objects such as tables, procedures, triggers, indexes and views.
  • Involved in designing and applying constraints and rules for data integrity.
  • Developed Temporary tables as per the requirements.

Environment: MS SQL Server 2008/2008R2, Microsoft Visual Studio 2005,2008.

Confidential

Database Developer

Responsibilities:

  • Analyzing different user requirements and providing solutions for various database applications.
  • Developing database application which are automated.
  • Planning and implementing capacity expansion in order to ensure that the databases are scalable.
  • Diagnosing and resolving database access and checking on performance issues.
  • Developed various SQL servers and ensured that they were properly maintained and supported.
  • Creation of complex database queries and indexes.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
  • Design, develop, automation and maintenance of inbound and outbound data transformation solutions.
  • Designing and creating SQL server tables.
  • Writing SWL server stored procedures using Transact SQL.
  • Transferring databases including TempDB to new servers using Transact SQL scripts.

Environment: MS SQL Server 2008/2008R2, Microsoft Visual Studio 2005,2008.

We'd love your feedback!