ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 238
Resume Example SQL Developer #0238 ประมาณ 1250 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง SQL BI Developer Sioux Falls, SD- 03/2018 - Current ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 7 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 7 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 7 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- ประสบการณ์ 7 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 40+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
Highly motivated Business Intelligence Professional with 7+ Years of experience in Business Intelligence and Data Warehouse Solutions. Thorough understanding of BI applications such as SSMS, SSIS, SSRS, SSAS. I like challenge and learning new things. I have been the problem solver of any workplace I have been a part of and I enjoy it.
Experience
SQL BI Developer Sioux Falls, SD- 03/2018 - Current
The Furniture Mart
- 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 the T-SQL code. - Designed SSIS packages to Extract, Transfer, and Load (ETL) existing data into SQL Server from different environment.
- 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. Developed and deployed database objects such as stored procedures, triggers, indexes, views, and UDFs in SQL Server.
- Implemented Error handling through TRY-CATCH method and used CTES.
- Extracted and loaded data from multiple sources (Excel, flat files, SQL Server, Oracle) to the staging areas
- Repaired SSIS packages with checkpoints, breakpoints, and data viewers.
Created SSIS
- 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.
- Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from different SQL Server Databases and Excel files, apply business logic, load in table and create view for end users.
- Migrated on-premise SQL Server schemas to cloud on Azure SQL Server DB and Azure VM, and developed and maintained databases across both on-premise and cloud deployments.
- Coordinated with project management staff on database development timelines and project scope. Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.
- Delivered complex business requirements without any issues by leveraging strong troubleshooting skills and extensive oversight.
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
- Supported multiple concurrent projects enabling delivery efficiencies and technical resolution. Created optimal technical solutions to user needs through research and in-depth system analysis. Tested programs and databases to identify issues and make necessary modifications. Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
- Produced high-standard database solutions to meet stability, reliability and performance metrics. Reviewed and interpreted business report requirements to address user needs.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Generated, debugged and enhanced existing reports with introduction of new system features.
Alight - SQL DeveloperOR, State- 06/2016 - 10/2017
- 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. Used System as well as User-Defined functions to enhance the functionality of my T-SQL code. Designed SSIS packages to Extract, Transfer and Load (ETL) existing data into SQL Server from different environment.
Developed and deploy / UDFs in
- I deployed database objects such as stored procedures, triggers, indexes, views, and in SQL Server. Implemented Error handling through TRY-CATCH method and used CTES. 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. Supported multiple concurrent projects enabling delivery efficiencies and technical resolution. Documented and analyzed business reports for prompt communication, follow-up and ongoing support.
- Produced high-standard database solutions to meet stability, reliability and performance metrics. Reviewed and interpreted business report requirements to address user needs. Analyzed existing SQL queries to identify opportunities for improvements.
- Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
Project Assistant
Community Transit
- Everett, WA. 12/2012 02/2016
- Prepared documents, reports and presentations for executives and board members using advanced software proficiencies.
- Purchased new products and oversaw inventory stocking and availability.
Created purchase orders.
- Planned and arranged meetings with external organizations and individuals, enabling all parties to meet and discuss project progress.
- Gathered requirements for ongoing projects and organized details for management use. Created workflow diagrams to clearly demonstrate processes and timelines. Mapped current business and operational processes and recommended areas for improvement. Hired freelancer programmer and worked together for the company's business intelligence project. Directed implementation of new business intelligence tools, selecting appropriate solutions and in aiding in corresponding onboarding processes.
- Derived conceptual designs from business objectives to deliver software and applications according to specifications for usability, performance and functionality.
- Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal
- Designed and implemented T-SQL queries for reporting and complex solution development. Developed, implemented and optimized stored procedures and functions using T-SQL.
- Reviewed and interpreted business report requirements to address user needs.
- Provided assistance with preparation of project-related reports, manuscripts, and presentations. Worked with senior leadership to complete complex projects on time and under-budget.
Belay BookkeeperAtlanta, GA. 10/2011- 07/2012
- Monitored, verified and approved invoices and reviewed balances using financial software to assess balance sheet for variances.
- Applied proper codes to invoices, files and receipts to keep records organized and easily searchable.
- Reviewed and processed employee expense reports and vendor invoices for payment.
- Maintained account accuracy by reviewing and reconciling checks monthly. Maintained and processed invoices, deposits and money logs.
Education
- Bachelor of Science: Marketing
- Berkeley College
- Bachelor of Science: Marketing Communications
Skills
(SSAS)Profound Knowledge andManagement Systems includingNormalizationStored ProceduresConstraintsQueryingJoinsKeysIndexesComplex viewsDynamic SQLTriggersConstraints (Primary keyForeign KeyUniqueDefault)DMLComplex Stored Procedurescreating TriggersCursorsUser-defined functionsExpertise inExtractingTransformationDevelopedCreating IndexesUpdatingDerived ColumnData umnDataConversionRow CountMerge ConversionRow CounJoinUnion Alletc.Experience in implementingvarious SSIS features like Event Handling
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง SQL BI Developer Sioux Falls, SD- 03/2018 - Current ประสบการณ์ 7 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 7 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ