ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 195
Resume Example SQL Developer #0195 ประมาณ 1373 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง SQL BI/Power BI Developer / Project Sales Orders BI ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 8 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 5 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 8 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- มีการกล่าวถึง Power BI, Tableau ซึ่งเป็นสิ่งที่ HR สายนักพัฒนา SQL ให้ความสำคัญ
- ประสบการณ์ 5 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 27+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
Over 8 years of experience in developing BI applications utilizing SQL server, BI stack, Power BI, and Tableau. Involved in Business Analysis of the OLTP and OLAP data and in decision support. Extensive database programming. Experienced in Building SSAS Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence and writing MDX Scripts Experience in writing T-SQL Stored procedures, Triggers, Constraints and Indexes using various DDL and DML commands. Developed T-SQL scripts for performing automation tasks, Performed and fine-tuned Stored Procedures and SQL Queries and User Defined Functions. Strong k knowledge of Data Warehousing methodologies and including star schemas, snowflakes concepts. Used N-tier architecture for presentation layer, the business and the data access layers and were coded using C#, worked with Agile methodology for application development. Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning. - Proficient in Creating, Configuring workflows designed in MS SQL Server Integration Services (SSIS). Experience in Reporting Services, Power BI (Dash Board Reports), Crystal Reports, SSRS using MS SQL Server and in supporting services MDX technology of the analysis services Proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data sources and integrates data based on business logic and to load it in data warehouse. - Designed ETL using SSIS Packages to reprocess any date data at any time using Reprocess Logic. - Developing C# scripts in SSIS and automating tasks using C#. - Maintaining the Log and Audit information in SQL tables, Experienced in providing Logging, Error Handling bui Handling by using Event Handler for SSIS Packages. - Having knowledge in Dimensional Data Modelling, Cube development and manipulations in SQL Server Analysis Services ervices (SSAS). - Involved designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance performance of Hierarchies and Fact Dimensions. - Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to end-user to make filters. miters. - Implemented Power BI gateway different source to matching analysis criteria and further modeling for Power Pivot and Power View - Experienced in designing and developing SSRS reports using data from ETL Loads, SSAS Cubes and various heterogeneous data sources. Have knowledge of Big Data Technologies like Hadoop, Cosmos etc. - Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player. - Strong investigative and troubleshooting skills.
Highlights
- Received highest Customer Satisfaction Index (CSI) of 100% from the customers. Received client appreciation on successful completion of Data Integration Project. Received client appreciation on successful completion of Global Supplier 3.2 Release.
Experience
SQL BI/Power BI Developer / Project Sales Orders BIAliso Viejo, CA 08/2016 - 07/2017
Neogenomics Laboratories
- Description - Sales Orders Project will combine subsets of data from systems containing Sales Orders information and stage it in a format that can be easily interrogated by the business users. The BI solution will provide a consolidated view of the captured Sales Orders information, answering questions. The Users will have the ability to report sales inventory quantity and value in each country, where available.
- Developed high level test matrix based on business requirements, functional and technical specifications, and development standards for assigned projects/applications.
- Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2012, Analysis Services (SSAS) and Reporting service (SSRS)
- Created and deployed cubes in star and snowflake schema. Performed and worked with dimensions, measures, MDX
MDX queries.
- Designing current database by adding tables, relationships, creating stored procedures, views and performance tuning of SQL queries and stored procedures.
Designed, developed, maintained application using VB.Net, C#
- Implemented business logic in the form of custom classes written in C#.
- Developed test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability.
- Developed Power BI reports and dashboards from multiple data sources using data blending.
- Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
- Performed data quality analysis using advanced SQL skills. Performed Count Validation
- Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration. Extensive SQL querying on staging, Data warehouse and Data Mart.
- Explored data in a a variety of ways and across multiple visualizations using Power BI. Strategic expertise in design of experiments, data collection, analysis and visualization
- Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
- Contributed in the development of knowledge transfer documentation.
- Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
Tata Consultancy Services SQL/BI Developer / Global Supply Chain (GSC) organizationCity, STATE 2013-2015
- The Global Supplier BI of Xerox manages the invoice amount, amount distributed and payment amount. The individual teams under this group GSCB, XE-OMAF, OTC, OCF, NCTH and ACS need reports for analysis and decision making. GSC BI application is to mitigate the complexity by providing a single source instead of multiple sources, cleansed one stop integrated warehouse that is flexible enough to accommodate new changes and scalable enough to efficiently cater to the growing user community. GSC BI application provides the flexibility for the Xerox business users to take key management decisions for the improvement of their business. Responsibilities
- Requirement analysis. Customer Interaction for requirement clarifications.
- Planning the estimates. Hence assigning the user stories to the team for development and unit testing.
- Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting on SQL Server 2008 using SSAS, SSIS, SSRS.
- Developed custom reports and deployed them on server using Power BI.
- Developed Business logic layer by implementing Object Oriented Programming languages (OOPS) concepts abstraction, encapsulation, inheritance, polymorphism in C#.
- Designed a Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#, Entity Framework and SQL.
- Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
- Experienced in SDLC life cycle for Design, Development and Staging phases of the project's with
of Data-Flow, Process Models, and E-R Diagrams. / support of D
- Maintained log information in Text file to tracking Errors and recording package execution status. Created Configurations, Checkpoints and Breakpoints. Created
- Designed ad-hoc reports in excel power pivot and shared them using Power BI to the decision makers for strategic planning
- Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
- Created Data Warehouse schema to deploy fact and dimension table and defined Referenced relationships with the measure groups and fact tables.
- Understood the existing ETL and relational database framework and Scheduled Packages using SQL Server Agent Jobs.
- Perform Preventive maintenance activities like causal analysis, restructuring program codes, data problems resolution and performance tuning.
- Come up with different test scenarios for automating Unit test cases, Build verification test cases and Environment test cases. Unit testing, fixing bugs.
- Giving application demos to customer and other teams at every sprint end.
- Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
- Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
- Store all source code in the Team Foundation Server (TFS) and update development status in the TFS timely.
Education
- Purdue University · Indiana, USA. 2017
- Master of Science: Computer Information Technology
- Jawaharlal Nehru Technological University · Kakinada, India. 2014
- Bachelor of Science: Electrical Engineering Technology
Skills
JavaC#Logistic RegressionDecision TreeSVMNaive BayesKNNK- MeansDatabases - OracleMySQLHBaseMongoDBCentOSDebianEclipseJiraHLMGITSVNCosmosMapReducePIGAmbariZookeeperHiveSqoopOozie and Flume.
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง SQL BI/Power BI Developer / Project Sales Orders BI ประสบการณ์ 8 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 5 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ