LiveCareer-Resume

sql bi developer resume example with 6+ years of experience

JC J S S JS J S S JS J S S JS J S S JS J S S JS J S S JS
Jessica Claire
, , 100 Montgomery St. 10th Floor (555) 432-1000, resumesample@example.com
Professional Summary

· Designing, building, and maintaining metadata models and ETL packages.

· Building SSIS packages involving ETL process, extracting data from various heterogeneous sources like flat files, excel files into SQL Server.

· Strong in ETL, Data warehousing, Operations Data Store concepts, data marts, OLAP and OLTP system

Skills
  • TECHNICAL SKILLS
  • Database: SQL Server 2019, SQL Server 2014, 2012, and 2008R2/2008
  • ETL Tools: SSIS, DTS, BCP
  • Reporting: SSRS (SQL Server Reporting Services/Server)
  • Programming: SQL, T-SQL, PowerShell, and VBScript
  • Operating System: Windows Server 2016/2010/2008R2/2008/
  • Tools and software: MS Office, Power Bi, Visual Basic
Work History
12/2021 to Current SQL/BI Developer Neogenomics Laboratories | Tampa, FL,
  • Involved in planning, defining, and designing data and provided documentation
  • Worked closely with the business to analyze and consolidate request requirements to improve the decision planning process
  • Defined data requirements and report layouts for the business to review
  • Created user stories and scripts based on requirements
  • Name - Jessica zgebre Email – resumesample@example.com Phone Number – (555) 432-1000
  • Generated parameterized reports, ad-hoc reports, sub reports, tabular reports using SSRS
  • Utilized Dataflow with multiple transformations for Incremental loads and truncate reloads
  • Created and modified SQL queries like Views, Functions, and Stored procedures
  • Maintained the table performance by following the tuning tips like creating index and applying best practices
  • Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple information sources
  • Experience in configuring and creating SSIS solution for ETL and business intelligence
  • Introduced SSRS to help the existing reporting process and designed and developed SSRS
  • Created parameterized reports and linked reports thorough knowledge of report server architecture using SSRS
  • Performed minor administrative duties creating folders, monitoring jobs and security related tasks
  • Leverage enterprise business intelligence tools, SQL queries and other tools to develop complex models and reports
  • Create functional / technical specifications to document design approach
  • Environment: MS SQL Server2005/ 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio.NET# 2008, TFS (SharePoint), Visual Basic6.0/VB.net, VB Script and Windows 2008 Server.
11/2018 to 11/2021 SQL/Power BI Developer Ihs Markit | Centreville, VA,
  • Designing, building, and maintaining complex ETL package
  • Strong in ETL, Data warehousing, Operations Data Store concepts, data marts, OLAP and OLTP systems
  • Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task and Script Task in SSIS Designer
  • Automated Power Query refresh using power by using parameter
  • Used various sources to pull data into Power BI such as SQL Server
  • Installed and configured Enterprise gateway and Personal gateway in Power bi service
  • Created Workspace and content packs for business users to view the developed reports
  • Scheduled Automatic refresh and scheduling refresh in power bi service
  • Wrote calculated columns, Measures queries in power bi desktop to show good data analysis
  • Techniques
  • Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily
  • Worked on all types of transformations that are available in Power bi query editor
  • Created stored procedures and SQL queries to pull data into power pivot model
  • Participated in project planning sessions with project managers and team members to analyze business requirements and outline the proposed solution
  • Environment: MS SQL Server 2008R2 SSRS/SSAS/SSIS, Point Services 2010, Microsoft office 2010, T-SQL, Windows 7
05/2016 to 10/2018 SQL Developer Target | City, STATE,

:- Involved in the process of upgrading SQL Server systems to SQL Server 2008 R2 to 2012.

• Extensively worked on tuning stored procedures and queries for optimum performance.

• Designed and Created databases, tables, views, stored procedures, Cursors and DDL & DML triggers.

• Used DBCC commands to check physical and logical consistency of the databases and rebuilt indexes.

• Provided all levels support, including on-call support through rotational basis.

• Provided full support of SQL Server SSIS and SSRS services.

• Designed, implemented, maintained, and provided full support of SQL Server clustering and mirroring.

• Controlled, monitored, and generated an access report process for user access to the database.

• Deployed database objects from development/testing environment to production environment.

• Worked with production team on data warehousing in handling large databases.

• Created logins and users as and when required with specific roles on production server.

• Created SQL alerts, Mail, and linked servers for accessing data from remote servers using jobs.

Environment: MS SQL Server 2008R2/2008, Visual Studio 2008/2008, MS Reporting Services SSRS 2008-R2/2008, MS Office 2007, MS Access, MS Excel, Microsoft Integration Services SSIS, Erwin.

Education
Expected in 06/2001 to to Bachelor of Arts | Addis Ababa University , Ethiopia , GPA:
Additional Information
  • Designing, building, and maintaining metadata models and ETL packages. Building SSIS packages involving ETL process, extracting data from various heterogeneous sources like flat files, excel files into SQL Server. Strong in ETL, Data warehousing, Operations Data Store concepts, data marts, OLAP and OLTP system Writing complex DAX functions in Power BI. Using various sources to pull data into Power BI such as SQL Server Migrating the on-premises database to Cloud and from cloud to on premise using multiple methods. Power BI Desktop and Power BI Service in creating Dashboards Writing complex DAX functions, time intelligence in Power BI Creating in building an automated Power BI report. Creating and Develop Power Apps and integrate power BI Report and Dashboard in Power App and share with user. Use various sources to pull data into Power BI such as SQL Server, SQL Azure etc... knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL. knowledge of Designing, Developing, and deploying various kinds of reports using SSRS using relational and multidimensional data. Working on Microsoft Excels: Lookup, PivotTables, and power pivot Creating various SSRS Reports like Charts, Filters, Sub-Reports, Drilldown and Building SSIS packages involving ETL process, extracting data from various heterogeneous sources like flat files, excel files into SQL Server.

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

  • Addis Ababa University

Job Titles Held:

  • SQL/BI Developer
  • SQL/Power BI Developer
  • SQL Developer

Degrees

  • Bachelor of Arts

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

*As seen in:As seen in: