อยากได้ Resume ที่โดดเด่นกว่าตัวอย่างนี้?

ใช้ตัวอย่างเป็นแนวทางได้ แต่ Resume ที่ชนะต้องเขียนให้ตรงกับตำแหน่ง และประสบการณ์ของคุณ เราเป็นมืออาชีพรับเขียน Resume และ Cover Letter ภาษาอังกฤษ รับประกันความพึงพอใจ

รับเขียน Resumeรับเขียน Cover Letter

ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 196

Resume Example SQL Developer #0196 ประมาณ 2019 คำ

เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง MS SQL BI (T-SQL/SSIS/SSRS )DEVELOPER Gep | Detroit ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 7 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้

จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 6 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ

สิ่งที่ควรสังเกตในตัวอย่างนี้

เนื้อหาในเรซูเม่ฉบับนี้

Resume Example
MS SQL BI (T-SQL/SSIS/SSRS )DEVELOPER Gep | Detroit
Montgomery Street, San Francisco, CA 94

Professional Summary

Jessica Claire Experienced MS Business Intelligence Developer with 7+ years of experience working with Bl applications such as SSMS, SSIS, SSRS, SSAS in Development, Test and Production Environments. A wide experience working in different industry domains such as service, insurance and finance. - SQL/ETL Developer having 7+ years of IT experience in Requirement Gathering, Analysis, Design, Development and Implementation of Enterprise solutions. - Experience in Information Technology with a strong background in Database development and Data warehousing using MS SSIS/SSAS/SSRS. - Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2016/2014/2012/2008R2/2008. - Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions (SCD) and Dimensional Modeling (Kimball/Inmon methodologies, Star Schema and Snow Flake Schema) - Experience in report development using SSRS and creating various types of reports like Dashboard, Drill Down/Through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports. - Experience in SQL server MDS 2012 features including hierarchies, granular security, transactions, data versioning, and business rules. - Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert. - Excellent in High Level Design of ETL Packages and SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV and flat files, MS Access, SAS, Oracle, DB2, SalesForce, CRM) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Derived Column, Merge, Merge Join and Union all. - Experience in working with Web services to handle SQL connections. - Strong skills on deploying and operating large scale cloud infrastructure and application services in AWS, Azure, SAP, Oracle Cloud, Google Cloud, IBM Software and other Cloud providers - Strong knowledge with Host Scripting to automate routine tasks. - Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL. - Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files. - Experience in Performance Tuning and Query Optimization. - Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI's, OLAP charts and SSRS Reports with PPS. - Experience in maintenance and administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages. - Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse. - Expert in creating Parameterized Reports. - Hands on experience in creating Star Schemas and Snow Flake Schemas. - Excellent analytical, communication and interpersonal skills and proficient in writing and presenting complex technical concepts, comfortable working independently and with different size of teams. - Proficient in designing Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services. - Involved in designing and populating data in data warehouse and Cubes (OLAP) using SSAS and SSIS. - Data Modeler with strong Conceptual, Logical and Physical Data Modeling skills, has experience with JAD sessions for requirements gathering, creating data mapping documents and queries - Migrated on-premise SQL Server schemas to the cloud on Azure SQL Server DB and Azure VM and developed and maintained databases across both on-premise and cloud deployments.

Experience

MS SQL BI (T-SQL/SSIS/SSRS )DEVELOPER Gep | Detroit
MI SQL Server Reporting Services (SSRS) SQL Server Analysis Services (SSAS)
  • SQL and relational database, Data Warehouse Ability to test systems
Position09/2018 - CURRENT
  • Sompo International is the international operation and a wholly owned subsidiary of Sompo, which trades on the Tokyo Stock Exchange. Through our operating subsidiaries, Sompo International underwrites agriculture, professional lines, property, marine and energy, and casualty and other specialty lines of insurance and catastrophe, property, casualty, professional lines, weather risk and specialty lines of reinsurance.
  • Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE's, Views, Joins and Triggers.
  • Wrote T-SQL queries, Store Procedures and used them to build packages and reports.
  • Developing several behavioral reports and data points creating complex SQL queries and stored procedures using SSRS, Excel.
  • Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems (SQL Server) and scheduled Jobs to call the packages and Stored Procedures.
  • Improved Stored Procedures and SQL Queries performance by analyzing execution plans and creating
proper Indexes using SQL Profiler and Database Tuning Advisor.
  • Designed various SSRS reports as requested by the client
  • Developed several SSIS packages and data flow tasks by using SSIS.
  • Extracted data from different sources and stored in to SQL Staging tables in BI Staging database.
  • Created different data points and pulling those using SSIS package.
  • Applied various data transformations like Aggregate, Sort, Merge, Multicasting, Conditional Split, Derived column.
  • Developed SSIS Packages and Stored Procedures to load/transform/cleanse data from SQL Server, Oracle and Excel Files to Facts and Dimension Tables in the Data Warehouse.
  • Created SSRS reports such as tabular, matrix, charts, dashboard and sub-reports using SSRS 2012.
  • Designed various SSRS reports as requested by the client
  • Used SSIS to create maintain and troubleshoot ETL packages to validate, extract, transform and load data to data warehouse databases.
  • Wrote complex Stored Procedures, CTES and Functions for SSRS reports and ETL projects.
  • Implemented different Slowly Changing Dimension methodologies to maintain and update historical data.
SCO BI DEVELOPER/SSIS/SSRS/SSAS / Capital Bank Financial Corp. | City, STATE07/2017 - 10/2018
  • Actively participated in JAD sessions with different departments, Managers and End users to capture and document system requirements. Verified Business Requirements and Functional Specifications. Involved in dimensional Modeling of Data Warehouse using Erwin tool.
  • Gathered, analyzed and documented the business requirements and business rules by directly working with end users/clients. Created and maintained documents like Documentation Roadmap, DATA Models, ETL Execution Plan, Configuration Management Procedures, and Project Plan.
  • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL. Created appropriate Triggers to assist efficient data manipulation and data consistency.
  • Developed database objects like tables, stored procedures, triggers, user defined data types and functions. Created and updated clustered and non-clustered indexes to keep up the SQL Server performance. Implemented Error handling through TRY-CATCH method and used CTES. Responsibilities included fine- tuning the SQL Server to achieve best performance.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance.
  • Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages. Published SSRS reports in Report Manager, SharePoint web pages and in custom made ASP.NET web applications.
  • Performed SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2 into the central OLTP database.
  • Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for SSIS packages and SSRS reports.
  • Developed C# console applications to manipulate databases and perform calculations
  • Created Application Tracking System, Surveys and Manual data Entry web applications using ASP.NET Framework.
  • Extracted and Loaded SharePoint Lists and Surveys Data into SQL Server Database with SQL Server Integration Services
  • Worked extensively on system analysis, design, development, testing and implementation of projects.
  • Extended SSIS Capabilities by Creating Custom SSIS Components for SharePoint.
  • Configured SSIS packages with XML configuration file, Environment variable, Registry entry, Parent package variable and SQL Server table.
  • Pulled data into MS SQL Server Database from different DBMS databases like Oracle and Teradata with
ETL packages.
  • Created SSRS and PowerBI reports sourcing from SSAS's Multidimensional OLAP and Tabular model cubes with MDX and DAX. Developed and Maintained Crystal Reports.
  • Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks. - Designed the star schema for the data warehouse including facts and dimensions. Implemented DW applications based on the requirements.
  • Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
  • Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes. SCO BI DEVELOPER
AGROINVESTBANK | City, STATE01/2012 - 05/2017
  • OJSC <Agroinvestbank», established in 1992, is one of the leading banks of Tajikistan and has strong branch network across the country. The capital stock of the Bank is formed by individuals and legal entities - residents of the Republic of Tajikistan and European Bank of Reconstruction and Development. The high level of reliability of «Agroinvestbank» is proved by international awards. In October 2002, at the Geneva Conference <<Business Initiative Directions>> Bank was awarded Gold in "International Star Award for Quality" nomination for achievements in using in its practical activity modern, bank technologies, based upon international standards. In March, 2003, on Frankfurt conference «Business Initiative Directions>> bank was awarded Platinum in "The Arch of Europe" nomination for high quality of bank services and use of modern technologies.
  • Manage daily operations, including database backups and restores, maintenance jobs, and developers' requests.
  • Develop reports from SQL queries, including formatting, analyzing, reconciling and summarizing information.
  • Complete and/or resolve all elements in a timely manner while adhering to company policies and procedures.
  • Created T-SQL scripts, which generated tables and relationships, based on the customer's request.
  • Identified source, destination and staging area per ETL strategy and performed data cleansing and data profiling.
  • Creating SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems (SQL Server) and scheduled Jobs to call the packages and Stored Procedures.
  • Created new database objects such as procedures, functions, indexes and views utilized T-SQL.
  • Used System as well as User-Defined functions to enhance the functionality of my T-SQL code.
  • Utilized Dynamic SQL for user customizable queries to be answered by the SQL Server.
  • Designed SSIS packages to Extract, Transfer and Load (ETL) existing data into SQL Server from different environment.
  • Implemented Data Cleansing, Incremental Data Loading, Logging, Event Handling and Error Handling.
  • Created SSIS Packages using Fuzzy Lookup, Derived Columns, Condition Split, Execute SQL Task, Data Flow Task, and Execute Package Task.
  • Created Dynamic SSIS packages using complex expressions, variables and control flow components such as for each Loop Container to loop over a Directory to load inbound files coming daily.
  • Scheduling jobs and alerts using SQL Server Agent and configured database mail for any job failure.
  • Hands on experience in creating several SSIS schedule tasks and monitor those tasks regularly
  • Pulled data into MS SQL Server Database from different DBMS databases like Oracle and Teradata with ETL packages.
  • Created SSRS and PowerBI reports sourcing from SSAS's Multidimensional OLAP and Tabular model cubes with MDX and DAX. Developed and Maintained Crystal Reports.
  • Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks. - Designed the star schema for the data warehouse including facts and dimensions. Implemented DW applications based on the requirements.
  • Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
  • Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.

Education

  • Master of Engineering | Faculty of Computer Control Systems And Automatics Vinnytsia National Technical University, Vinnitsa, Ukraine · Completed Practical SQL/QALight. Ukraine 2011

Skills

SQL Server Integration Services (SSIS)Power BIDAX

สรุปว่าจะได้อะไรจากตัวอย่างนี้

ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง MS SQL BI (T-SQL/SSIS/SSRS )DEVELOPER Gep | Detroit ประสบการณ์ 7 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 6 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ

อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ

← ตัวอย่างก่อนหน้า (#0195)กลับไปหน้านักพัฒนา SQLตัวอย่างถัดไป (#0197) →