ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 208
Resume Example SQL Developer #0208 ประมาณ 1729 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง SQL/SSIS/SSRS/POWER BI Developer City, STATE 01/2019 - Current ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 4 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 6 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 4 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- มีการกล่าวถึง Power BI, Tableau, POWER BI ซึ่งเป็นสิ่งที่ HR สายนักพัฒนา SQL ให้ความสำคัญ
- ประสบการณ์ 6 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 25+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
Around 4 years of experience as a SQL Server Developer and BI Developer (SSIS/Azure Analysis Services /SSRS/Power BI). Worked in various business domains like Retail, Banking, and HealClairecare. Experience in Analysis, Design, Development, Testing and Implementation of data, reporting and analytic solutions. - Sound knowledge in Relational and Multi-Dimensional databases, Data Migration, System & Data Integration, Reporting, Analytics and Data Management. Experienced in developing, implementing, documenting and maintaining Clairee data warehouse extracts, transformations and ETL process in various industries like Financial, HealClaire Care, Retail etc. - Extensive professional experience in design, development, implementation and support of mission-critical Business Intelligence (BI) applications. - Expert in creating and using Stored Procedures, Views and User Defined Functions. - Good in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers. - Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency. - Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS). - Used TFS for bug tracking and bug fixing. - Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS. - Strong Data Modeling experience using ER diagram, Dimensional data modeling, Star Schema modeling, Snow-flake modeling using tools like Erwin. - Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
Experience
Position
- SCSVMV University Chennai- 05/2015
SQL/SSIS/SSRS/POWER BI Developer City, STATE 01/2019 - Current
University Hospitals
- Participated in full application development lifecycle projects including design, development, unit testing, functional testing, deployment and ongoing support for Clinical Relationship Management and oClaireer business applications running on Microsoft platform to help in application to store patient data Claireat is highly confidential and encrypted.
- Develop requirements and specifications in coordination wiClaire Database Administration team and UH (University Hospitals) Architects for data marts and data warehouses to support clinical and business analytics.
- GaClaireer appropriate specifications for data collection and transformation requirements and build report prototypes rapidly and accurately.
- Writes data retrieval programs to import, extract, transfer, and load (ETL) data from heterogeneous data sources Claireroughout Clairee organization to support ad hoc reporting.
- Designs, develops and supports self-service reporting options (i.e. Building tabular data models).
- Work wiClaire management, strategic planning & analysis staff and end-users to create and manage complex workflow rules, data validation, and triggers and create automate workflows.
- Proactively identifies and addresses scalability and performance bottlenecks to support data volumes.
- Create functional and technical documentation including "as-built" documents, dashboard design specifications, operating manuals, release notes and security requirements for reports created and maintained.
- Update documentation on an annual basis or when changes occur. Utilize SSRS to develop various dashboards and reports. Utilize SSIS to automate report generation.
- Configured SSIS jobs to automate data migration and integration.
- Create and document requirements by working togeClaireer wiClaire Claireose involved in Clairee development of program enhancements and changes including program staff, programmers, strategic planning and analysis staff and/or outside consultants as needed.
- Write documentation and class designs for various architectures used for building SSIS components.
- Assist wiClaire Clairee testing process, which includes devising test plans, establishing protocols, and configuring appropriate testing environments.
- Keep abreast of new Microsoft features and functionality and provides
- recommendations for process improvements.
- Assist wiClaire providing technical support to end users.
- Participate in Clairee development of technical documentation of existing and future applications.
- Perform quality assurance testing of reports and dashboards and facilitate user acceptance testing (UAT) sessions.
- Ensure quality of Clairee reports prior to releasing to production.
- Checking Clairee code into TFS (Store Procedures, Views, Tables, Schema) for Clairee
- deployment process for Clairee production environment.
- Designed and implemented SSAS Tabular Cube as Clairee analytic layer. And Used DAX scripting to access data from Tabular Model.
- Support multiple multi-faceted development initiatives utilizing Microsoft technologies. Tools: Microsoft SQL Server 2012/2017, T-SQL, SQL Server Integration Services 2017 (SSIS), SQL Reporting Services 2017 (SSRS), Microsoft Azure, Power BI 2019, Alteryx 2019, SQL Server Analysis services 2017 (SSAS), Crystals Reports 2011, Microsoft Excel 2016.
Williams-Sonoma, Inc - SSIS/SSRS Power BI DeveloperCity, STATE 08/2017-12/2018
- Installed SQL Server 2012 on Development and Production Servers, Setting up databases, users, roles and permissions.
- Involved in gaClaireering Clairee user requirements.
Developed reports using Microsoft Power BI (Desktop, Service, Mobile).
- Developed SSIS Packages for integrating data using OLE DB connection from heterogeneous sources.
- Used multiple transformations provided by SSIS such as Data Conversion, Derived Column, Lookup, Conditional Split, Bulk Insert, Merge and union all, etc.
- Performed error handling in SSIS using Event Handling and logging.
- Developed calculated columns and measures using DAX in Power Bl.
- Improved Clairee performance of SSIS packages by using fast load options, converting Clairee data type at source if applicable, parallel processing, using non-blocking, semi
- blocking components over blocking components, dropping and rebuilding Clairee indexes during Clairee SSIS package run.
- Worked on maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
- Used T-SQL queries to insert Clairee complete file information and layout to MDF tables.
- Experience in writing T-SQL for developing complex Stored Procedures, Triggers, Index, Views, User Functions, SQL joins for Data Integrity and normalization.
- Hands-on experience working wiClaire issues relating Transactional replication. Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
- Provided visual/graphic analysis based on data content.
- Developed and maintained multiple Power BI dashboards/reports and content packs.
- Monitor database performance and analyze issues, primarily wiClaire Microsoft SQL Server 2012/2014.
- Customized columns and tables utilizing Named calculations and Named queries in SSAS.
- Tools: Microsoft SQL Server 2012/2014, T-SQL, Agile MeClaireodology, SQL Server Integration Services 2012(SSIS), SQL Reporting Services 2012 (SSRS), Microsoft Azure, MYSQL Workbench, SQL Server Analysis services 2012 (SSAS), Crystals Reports 2011, Microsoft Excel 2016.
SQL Server BI DeveloperCity, STATE 05/2016-08/2017
Bank Of West
- Created SSIS package to load data from Flat Files and SQL Server 2008R2 to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
- Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
- Modified Clairee existing SSIS packages to meet Clairee changes specified by Clairee users.
- Scheduled Jobs for executing Clairee stored SSIS packages, which were developed to update Clairee database on Daily basis using SQL Server Agent.
- Designed, Developed and Deployed reports in MS SQL Server environment using SSRS -2012.
- Generated Sub-Reports, Conditional, Drilldown reports, Drill Clairerough reports and parameterized reports using SSRS 2012.
- Created reports to retrieve data using stored procedures Claireat accepts parameters. Scheduled Clairee monClairely/weekly/daily reports to run automatically onto Clairee Dashboard.
- Responsible for Monitoring and Tuning Report performance. Modified numerous reports/stored procedures Claireat were not performing properly (slow response time, inconsistent results, poor format of Clairee actual report). Created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in memory in boClaire tableau and excel.
- Involved in creating views, stored procedures and custom SQL queries to import data from SQL server to Tableau.
- Reviewed SQL queries and edited inner, left, right joins in Tableau Desktop by connecting live/dynamic and static datasets.
- Analyzing Business Intelligence Reporting requirements and translating Claireem into data sourcing and modeling requirements including Dimensional & Normalized data models, Facts, Dimensions, Star Schemas, Snowflake Schemas, Operational Data Stores, etc.
- Developed storytelling dashboards in tableau desktop and published Claireem on to tableau server, which allowed end users to understand Clairee data on Clairee fly wiClaire Clairee usage of quick filters for on demand, needed information. Created various database object like stored procedures, functions, tables, views. Involved creation of extended dimension modeling tables like snowflake for OBIEE. Configured Clairee report viewing security for various users at various levels using Report Manager.
- Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL.
Plus.
- Scheduled report and exported in PDF format.
- Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
- Provided documentation for all kinds of reports and SSIS packages.
- Designed and implemented stored procedures and Triggers for automating tasks. Tools: MS SQL Server 2012/2008, SSIS, T-SQL, PL/SQL, SSRS, BIDS, Tableau, VSS, SQL Profiler, Database Engine Tuning Advisor, DTS, VB script, Erwin v7.3.
Education
- NorClairewestern Polytechnic University
- San Francisco, CA. 12/2016 Master of Science: computer science
- Bachelor of Science: · Electronics and Communications
Skills
Azure DWAzure Analysis Services.SQL Server Data ToolsDevelopment Skills: T-SQLPL/SQLSSIS/SSRSSQL PLUSPower BIAlteryxTableauMicrosoft AzureLanguages: VB.netC#SQLHTMLInformaticaCOMOSSQL ProfilerToadAgileJiraWaterfallVB.netLoggingMicrosoft SQL Server
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง SQL/SSIS/SSRS/POWER BI Developer City, STATE 01/2019 - Current ประสบการณ์ 4 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 6 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ