LiveCareer-Resume

sql developer resume example with 6+ years of experience

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

Dynamic and ambitious MS BI developer with 7 years of experience in database generation and creation, data warehouses, ETL packages, reports and presentations using BI applications such as SSMS, SSIS, SSRS, Power BI. A well-organized, adaptable and varied team data engineer with the ability to work independently. Extensive professional experience in a variety of companies including sales, service, finance, healthcare and insurance

Skills
  • Windows 2012/2008 R2/2003/2000 Server
  • Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, Microsoft Azure
  • Extraction Transformation and Loading (ETL)
  • SSRS 2017/2016/2012, Excel, Power BI, Tableau.
  • C# | MySQL | PL/SQL | TSQL | PostgreSQL | JavaScript | Node.js | React | CSS | HTML5 | MongoDB| Python | Git | GitHub
  • MS Word, MS Excel, MS Access, MS Project, Visio, SSMS
Work History
SQL Developer, 01/2021 to Current
Fiserv, Inc., , Houston, TX
  • Developed, implemented and optimized stored procedures and functions using T-SQL.
  • Designed and implemented TSQL queries for reporting and complex solution development.
  • Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
  • Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more.
  • Extracted and transformed multi-source data, incorporating assets into unified databases while monitoring integration and replication performance.
  • Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Lookups, and Derived Columns with Multiple Data Flow tasks.
  • Converted old ETL packages to the new version (did optimization by applying more stored procedures instead of using control flow tasks).
Business Intelligence Developer, 11/2018 to 10/2020
1-800-Flowers.Com, Inc., , San Jose, CA
  • Designed customized data collection models for specific visualization tasks.
  • Developed intelligence-sharing dashboards, providing company-wide access to collected data.
  • Used different methods of logging in SSIS Building, publishing customized interactive reports and dashboards, report scheduling using Power BI.
  • Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.
  • Strong understanding of Data Modeling in data warehouse environment such as star schema and snowflake schema.
  • Generated reports, updated spreadsheets and presented results.
  • Tune SQL queries and database performance by improving overall table design, indexing, query plan analysis and refactoring. Create database design documentation at architectural and functional level.
  • Review database objects for data integrity, quality, security, recoverability, scalability, maintenance, and capacity recommend changes as necessary.
BI/SSIS Developer, 04/2017 to 09/2018
General Electric, , Boston, MA
  • Managed the loading and transformation of SQL Server SSIS packages into the SQL Server data warehouse.
  • For several migration projects, I developed SSIS packages, and I gave vendors step-by-step instructions on how to run it and generate files from their databases.
  • Utilized SSIS and extract transform loading (ETL) tool of SQL Server to populate data from different data sources, making packages for various data loading tasks for application, enhancing existing ETLs and creating some new ETL procedures.
  • Created ETL solutions for integrating data from many sources, including Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2, into the main OLTP database. Performed SSIS Development and Support.
  • Coordinated with management teams to plan, develop, align and execute strategies that would meet client's vision, mission and purpose.
  • Configured SSIS packages with XML configuration file, Registry entry, Parent package variable and SQL Server table.
BI Developer Analyst, 06/2015 to 03/2017
KPMG Professional Services, , Tashkent, Uzbekistan
  • Imported and exported data, ETL packages with various control flow choices and data flow transformations, such as Conditional Split, Multicast, Union all, and Derived Column.
  • Developed ETL packages in SSIS with Lookup, Execute SQL Task, Sequence Container, Breakpoint, and Checkpoint to guarantee data quality and consistency.
  • Using Event Handler, created ETL packages and sent emails to managers when a package was performed and an error occurred.
  • Multiple environments, including developing, testing, and production environments, were used to build, run, and deliver packages. Involved in the creation and implementation of SSIS and SSRS/PowerBi application solutions for different organizational business units.
  • SSIS packages were developed to prepare and load data into the data warehouse. SSIS program was developed to transport data between OLTP and OLAP databases using Incremental Load.
Education
Bachelor of Science: Computer Science, Expected in 05/2015 to Institute of Information Technologies - Samarkand, Uzbekistan,
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

  • Institute of Information Technologies

Job Titles Held:

  • SQL Developer
  • Business Intelligence Developer
  • BI/SSIS Developer
  • BI Developer Analyst

Degrees

  • Bachelor of Science

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

*As seen in:As seen in: