ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 134
Resume Example SQL Developer #0134 ประมาณ 1505 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับสายงานนักพัฒนา SQL มีประสบการณ์รวมประมาณ 6 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 3 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 6 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- มีการกล่าวถึง Tableau, Power BI ซึ่งเป็นสิ่งที่ HR สายนักพัฒนา SQL ให้ความสำคัญ
- ประสบการณ์ 3 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
Professional Summary
- Around 6+ years of Information Technology experience in all phases of Software development life cycle including Database administration, Data Analysis and Business Intelligence. - Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services and MS SQL Server Reporting Services (SSRS). - Experience in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types and functions, Cursors and Indexes using T-SQL. - Extensively worked with clients to understand business requirements, recommended technical solutions and documented functional requirements. - Involved in Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling, Data Vault Modeling, Snow-Flake Modeling, FACT and Dimensions. - Experience in SDLC (Software Development Life Cycle) involving System analysis, Design Development & Implementation using Waterfall methodology and Agile methodology. - Strong experience in design and developing ETL using SQL Server Integration Services (SSIS). - Experience in creating SSIS package to load data from Flat Files to SQL Server using various types of transformations like Lookup, Fuzzy Lookup, Multicast, Derived Columns, Condition Split, Term Extraction, Aggregate, for transferred data modifications and dataflow tasks, script tasks, for loop container, for each loop, sequence container and Slowly Changing Dimension. - Experience in Installing, Managing, Monitoring and Troubleshooting SQL Server. Excellent knowledge in Dimensional Data Modeling and analyze Data warehouse by building multidimensional cubes using SQL Server Analysis Services.
Experience
PositionAug2020 - Current SQL Developer
Android Industries
- Worked with senior management team and operation-level managers to gather requirements.
- Strong experience in Analysis, Design, development, and implementation of end-to-end Business intelligence.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Developed ETL framework for processing and monitoring import of flat files in SSIS for key client.
- Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using Microsoft SSIS and/or Azure cloud technology.
- Developed, implemented and optimized stored procedures and functions using T-SQL.
- Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.
- Developed complex Stored Procedures and Views to generate various Drill-through reports, Linked Reports and Ad hoc reports using SSRS.
- Responsible for Scheduling reports to run daily, weekly and monthly basis using SSRS Report Manager
- Developed custom database objects, stored procedures and delivered application support.
- Designed and implemented TSQL queries for reporting and complex solution development.
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
- Reviewed and interpreted business report requirements to address user needs.
- Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
- Built useful reporting deliverables to properly document analysis results and provide performance improvement feedback.
- Generated, debugged and enhanced existing reports with introduction of new system features.
- Proved successful working within tight deadlines and fast-paced atmosphere.
- Developed and maintained courteous and effective working relationships.
- Participated in continuous improvement by generating suggestions, engaging in problem-solving activities to support teamwork. Sep2017 to Jul2020 SQL Developer
Position
Android Industries
- Worked with senior management team and operation-level managers to gather requirements.
- Wrote and optimized SQL statements to assist business intelligence practices.
- Responsible for creating and managing various database objects such as tables, stored procedures, views, Triggers, and Database Constraints to meet business requirements.
- Involved in Interacting with the user for gathering business requirements and resolving the claims for the client accounts.
- Responsible for making an analysis of transactions of the client and determining solution for settlement of the client account.
- Proficient in coding of optimized Teradata batch processing scripts for data transformation and aggregation.
- Teradata database, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables with in committed timelines.
- Responsible for extracting and loading client historical data from source to SQL environment for performing various business operations using SSIS.
- Responsible for scheduling SSIS jobs to automate the processes using SQL Server Agent.
- Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
- Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Checkpoints, Transactions and package configurations.
- Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
- Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
- Experience in deployment of SSIS packages into different environment using configurations for deployments to different environments.
- Implementing all high availability techniques like clustering, log shipping, replication.
- Experience in working with CMD Utility tool to run command files.
- Created different Power Pivot reports as per the client requirement.
- Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
- Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
- Experience in creating SSRS reports using pie charts, bars etc for business analysis purpose.
- Experience in creating SSRS reports using pie charts, bars etc for business analysis purpose.
- Experience in writing Excel macros using vb script to format the excel report.
- Responsible for designing, development and deployment of SSRS reports using SSRS report designer.
- Responsible in Designing and developing Tabular Report, Parameterized and Linked reports, Sub reports, drilldown reports, drill through reports, ad-hoc reports and Crystal Reports with thorough knowledge of SSRS. - Responsible for Scheduling reports to run daily, weekly and monthly basis using SSRS Report Manager.
- Defined security models with row level data security, role-based security etc in Business Objects Universes and Central Management Console (CMC).
- Responsible for creating complex Cross tab, OLAP Cube report using Crystal Reports integrated with SSMS.
- Designed Report Templates, Bar Graphs and Pie Charts in Crystal Reports for data analysis.
- Worked extensively on OBIEE Answers to create the Financial Statement reports and Intelligence Dashboards (Financials) as per the detailed design requirements.
- Involved in monitoring, trouble shooting performance tuning of databases to support production environment in 24/7 on-call rotation.
- Responsible for creating and maintaining high-level design documentation considering future changes.
- Demonstrated respect, friendliness and willingness to help wherever needed. Aug2014 to Aug2017MSBI Developer
Position
Cognizant Technology Solutions
- Gathered requirements to determine necessary hardware configurations for planned software.
- Involved as a team member for requirement analysis in design phase of the Project.
- Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs.
- Experience in handling Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
- Experience in working with different control flow elements like Data Flow Task, Bulk Insert Task, Active X scripts, Execute SQL Task, Script Task, Send Mail Task, and XML Task.
- Experience in working with different data flow elements like Flat File, OLEDB, Excel Sources and Destinations, Data Conversion, Term Extraction, Conditional Split, Derived Column, Pivot etc.
- Deployed different SSIS packages on development and test environments.
- Created and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly and monthly loads.
- Experience in migration of parts from Visual source safe (VSS) 2005 to Team foundation server (TFS) 2010.
- Involved in development and deployment of the Cube.
- Developed complex Stored Procedures and Views to generate various Drill-through reports, Linked Reports and Ad hoc reports using SSRS.
- Scheduled reports to run daily, weekly and monthly based on the requirement Report Manager.
- Defined Report Layouts for formatting the report design as per the need.
- Generated test data and tested new database consistency with existing databases.
- Maintained existing applications and designed and delivered new applications.
- Created Jobs, Alerts, Activity logs, Error logs to capture any possible errors using SQL server Agent.
- Enhanced performance using optimization techniques such as Normalization, Indexing and Transaction Isolation levels.
Education
- Bachelor of Science: Management Information Systems
- Unity University College
Skills
Windows NTUnix.SQL Server Integration Services (SSIS)SQL Server Reporting Services (SSRS)SQL Server Analysis Services (SSAS)ETLTableau.
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับสายงานนักพัฒนา SQL ประสบการณ์ 6 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 3 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ