LiveCareer-Resume

sql ssis ssrs power bi developer resume example with 7+ years of experience

Jessica Claire
  • , , 609 Johnson Ave., 49204, Tulsa, OK 100 Montgomery St. 10th Floor
  • Home: (555) 432-1000
  • Cell:
  • resumesample@example.com
Summary

Over 7+ years of IT Experience in Database Design, Development and business intelligence of SSMS, SSIS, SSRS, SSAS and Tableau/Power BI in Development, Test and Production Environments on various business domains like Health Care, Finance and Insurance. Expertise in Microsoft Business Intelligence (MSBI), OLTP and OLAP using SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), ETL Data Warehouse, SQL Server Analysis Services (SSAS) and MS SQL Server (2008,2012,2014,2016,2019) Experience in creating Parameterized Reports. Profound Knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Complex views, Dynamic SQL, Triggers, Cursors and ER Diagrams. Working experience in creating Database Objects like tables, Constraints (Primary key, Foreign key, Unique, Default), Views and Indexes. Experience in developing the applications using T-SQL Programming (DDL, DML and DCL). Having experience in data analysis SQL server database development and maintenance, data modeling that support day to day business operations and auditing of databases for user transactions, login and database actions and removing orphan users. Expertise in writing T-SQL Queries, Complex Stored Procedures, creating Triggers, Cursors, User-Defined Functions, Joins and Common Table Expressions (CTE). Expertise in Extracting, Transformation and Loading (ETL) using various tools like export/import data and SQL Server Integration Services. Created, Developed, Tested and Deployed Packages into production servers by creating package configurations. Advanced in creating ETL process, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies, Including Star and Snowflake schema. Expertise in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through Drill Down reports using SSRS. Very good knowledge in fine tuning long running T-SQL scripts to simple ones, Creating Indexes, Updating statistics and so on. Experience in transforming data using Data Flow Tasks like Derived Column, Audit, Slowly Changing Dimension, Data Conversion, Row Count, Merge Join, Lookups, Union All etc. Experience in implementing various SSIS features like Event Handling, Precedence Constraints, Breakpoints, Checkpoints and Logging for Complex SSIS Packages. Experience in migration of on-premise SQL Server schemas to the cloud of Azure SQL Server DB and Azure VM, developed and maintained databases across both on-premise and cloud deployments. Experience in Advanced Excel like Power View, Power BI, Power Pivot and Excel Data Connection Adequate in creating and changing the data visualizations in Power BI reports and Dashboards on client requests. Have some experience to use C#, visual basics. Net for script tasks and script components with variables in SSIS. Excellent Analytical, Interpersonal and Communication skills, fast learner, hardworking and versatile team player.

Skills
  • TECHNICAL SKILLS
  • Operating Systems
  • Windows 2012/2008 R2/2003/2000 Server, Windows NT 4.0/3.5. Unix/Linux
  • Database tools
  • SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS), Microsoft Azure
  • Languages
  • T-SQL, PL/SQL, MDX, DAX, C#, VB.NET, XML, ASP.NET, .NET Framework
  • Web Tools
  • C#.Net, ASP.Net, VB.Net, Visual Studio.Net
  • ETL & Reporting
  • SSDT 2017/16/14/12, BIDS 2008R2/08, SQL Server Integration Services (SSIS 2017/16/ 2014/2012/2008R2), SQL Server Reporting Services (SSRS 2016/2014/2012 /2008R2), PowerBI, SQL Server Analysis Services (SSAS)
  • Others
  • MS Office, Crystal Reports XI, Visio, SQL Server Notification Services, Visual web developer, MS FrontPage, Windows Scripting Host, MS Visual, SAS/Access, Crystal Reports SAP Business Objects, Micro Strategy, ER-Studio, Microsoft TFS, Microsoft GIT, MS VSS, HP Quality Center & JIRA, TFS,Python
Experience
SQL/SSIS/SSRS Power BI Developer, 08/2019 to Current
Blue Shield Of CaliforniaCity, STATE,
  • Developed SSIS packages using Fuzzy Lookup and Fuzzy Grouping for data cleansing purposes
  • Used SSIS Variables for storing the values, which are used in various components of Data Flow Task
  • Developed Unit Test Plans for SSIS packages for checking the functionality of each component
  • Modified the existing SSIS packages to meet the changes specified by the users
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL Task, Script Task and Send Mail task etc
  • Developed Aggregations, Partitions and Calculated Members for cube as per business requirements
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008
  • Worked on formatting SSRS reports using the Global variables and Expressions
  • Created Parameterized reports, Drill down and Drill through reports using SSRS
  • Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
  • Responsible for Monitoring and Tuning Report performance
  • Configured the report viewing security for various users at various levels using Report Manager
ETL/SSIS Developer, 12/2016 to 07/2019
AmerigroupCity, STATE,
  • Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS and performed documentation for all kinds of reports and SSIS packages
  • Developed data standards, data exchange, XML data standard or data sharing model
  • Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy LookUps, and Derived Columns with Multiple Data Flow tasks
  • Generated Daily, Weekly, Monthly, Subscriptions, Dashboard reports for the analysis of managers and end users by using SSRS
  • Worked with redirecting outputs into different formats including XML Files and various other data sources
  • Involved in automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler, and third-party tools
  • Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more
  • Worked on XML Web Services Control Flow task to read from XML Source
  • Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages
  • Developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File and DB2 into the data warehouse
  • Created, maintained and updated ETL packages loading from/to both OLTP and OLAP database tables
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load
  • Identify, analyze, and interpret trends or patterns in complex data sets
  • Involved in Planning, Defining and Designing data based on business requirements and provided documentation
  • Converted old ETL packages to the new version (did optimization by applying more stored procedures instead of using control flow tasks).
ETL/SQL BI Developer, 09/2014 to 11/2016
KeyBankCity, STATE,
  • Designed SSIS packages and/or enhanced the existing SSIS packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Conditional Split, Aggregate, Execute SQL Task and Data Flow Task etc
  • To extract data from disparate sources (SQL Server, Oracle, Teradata, Access and Excel) to generate underlying data for the reports
  • Developed T-SQL query, stored procedures and functions to retrieve data for reporting
  • Validated the daily, weekly, monthly grain transformed data by comparing it with the source system
  • Worked with internal customers to gather and analyze business requirements in order to identify and solve problems
  • Responsible for building the report solution like drill-down, drill-through and linked reports using SSRS, testing for quality and finally reviewing the customer to ensure the solution meets requirements
  • Supported the efficient delivery of standard and ad-hoc reports with an emphasis on automating where possible
  • Generated weekly, monthly and quarterly reports for the management using different techniques like data filtering, adding interactivity, deploying reports to the report server in SSRS.
Education and Training
Bachelor: Accounting and Audit, Expected in 01/2012
Fergana Polytechnic Institute - ,
GPA:

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Fergana Polytechnic Institute

Job Titles Held:

  • SQL/SSIS/SSRS Power BI Developer
  • ETL/SSIS Developer
  • ETL/SQL BI Developer

Degrees

  • Bachelor

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: